items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2011-10-17-80ef1083-10199-0" sorted by member_id
This data as json, CSV (advanced)
date (date) 1 ✖
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
4c393ca681168665e281a9856569d410ea8317b4 | Name of donor: 1) Doha Forum | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2011-10-17-80ef1083-10199-0 |
cb9e945dbcc1bd9af1fb81e44adc44522eabd825 | 2) UCLA (University of California, Los Angeles) | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2011-10-17-80ef1083-10199-0 |
008a437a084cf2277257900dfe0482ec7ef0db4b | Address of donor: 1) Doha, Qatar | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2011-10-17-80ef1083-10199-0 |
1f4898c6ea79b669a6ac1f9f76b6abfeb44cc505 | 2) Centre for Middle East Development, Los Angeles, USA | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2011-10-17-80ef1083-10199-0 |
244a45ec6e0ac43298f9cfc00ec049b278b09160 | Amount of donation (or estimate of the probable value): return flights and accommodation provided for 2 nights; approximate cost £3,000 | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2011-10-17-80ef1083-10199-0 |
536c77406b6dab5b3153f42c7739b36bcb85bf97 | Destination of visit: Doha, Qatar | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2011-10-17-80ef1083-10199-0 |
b53f953bfc4dabc20da8fd6481752070fe135e38 | Date of visit: 8-11 May 2011 | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2011-10-17-80ef1083-10199-0 |
51b51abd40df5650ec6380af57e9c5bdd088d7bf | Purpose of visit: to attend and speak at the Forum | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2011-10-17-80ef1083-10199-0 |
5c8645f687df01244382acebb5a6c4fea101f2cb | (Registered 20 May 2011) | Overseas visits 80ef1083 | 2011-10-17 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2011-10-17-80ef1083-10199-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE items ( hash VARCHAR(40) NOT NULL, item TEXT, category_id TEXT, date TEXT, member_id TEXT, person_id TEXT, sort_order INTEGER, record_id TEXT, PRIMARY KEY (hash), FOREIGN KEY ("category_id") REFERENCES [categories](id), FOREIGN KEY ("member_id") REFERENCES [members](id), FOREIGN KEY ("person_id") REFERENCES [people](id) ); CREATE INDEX items_date ON items("date"); CREATE INDEX items_category_id ON items("category_id"); CREATE INDEX items_member_id ON items("member_id"); CREATE INDEX items_person_id ON items("person_id"); CREATE INDEX items_record_id ON items("record_id");