items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2013-09-09-80ef1083-10199-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
653b5f88f1c04cda23cb03d936e4d89328d65274 | Name of donor: | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2013-09-09-80ef1083-10199-0 |
8b7e6a46ef475069114c4c436aec2d30643ee4f2 | 1) TNT Post UK | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2013-09-09-80ef1083-10199-0 |
a1029172313f25ec781705c93b9b18793d60f575 | 2) PostNL | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2013-09-09-80ef1083-10199-0 |
b140da36ce81247bf755e1a89b4ccf7b049501bd | Address of donor: | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2013-09-09-80ef1083-10199-0 |
6b2dc7227ed69b5dee80650d9a65cfec09ef3190 | 1) 1 Globeside Business Park, Fieldhouse Lane, Marlow, Bucks SL7 1HY | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2013-09-09-80ef1083-10199-0 |
b40a1fa7f708bba8c609662c0439e77a38cc7c78 | 2) Prinses, Beatrixlaan 23, 2595 AK, The Hague, The Netherlands | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2013-09-09-80ef1083-10199-0 |
f7fb38438aeff87f3841186696a496e467c1382b | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2013-09-09-80ef1083-10199-0 |
abdd3eeb88e94a553c1e70752444aba9dc213fa0 | 1) Return flight, hotel accommodation and some transport costs; total £509.18 | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2013-09-09-80ef1083-10199-0 |
046a11c8567e35a13efb5d828eea485764ba790c | 2) Transport and some meals; total £244.11 | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2013-09-09-80ef1083-10199-0 |
7d2806c0f84e958dfe001d89124af56f9f005c71 | Destination of visit: The Netherlands | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2013-09-09-80ef1083-10199-0 |
b0c9aa0f5caddc3543c3e5e5bdb5f4f014683c6c | Date of visit: 21-24 February 2013 | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2013-09-09-80ef1083-10199-0 |
22152584aff90ff01eb64a3484b3a7c3da72606e | Purpose of visit: visit as part of Industry and Parliament Trust Fellowship | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2013-09-09-80ef1083-10199-0 |
ea8e55c6bb8b0ab4fa9670b083ea144a43f08d7a | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2013-09-09 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 12 | 2013-09-09-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");