items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-02-03-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 |
---|---|---|---|---|---|---|---|
291b3628079de82f3831794c6383ee248650747b | Name of donor: | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2014-02-03-80ef1083-10199-0 |
62817cea1800cd3fdd0d4a56ed8d03a2183b24b9 | 1) TNT Post UK | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2014-02-03-80ef1083-10199-0 |
6a4d8058c96291173f5d303007c6f71f90269981 | 2) PostNL | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2014-02-03-80ef1083-10199-0 |
4c918ab1ef9d1a7011c9b6a1ff93ad2fb46cb578 | Address of donor: | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2014-02-03-80ef1083-10199-0 |
2000020b267c7856582b2c7762550f51b2b0d473 | 1) 1 Globeside Business Park, Fieldhouse Lane, Marlow, Bucks SL7 1HY | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2014-02-03-80ef1083-10199-0 |
597c50b9c0162938366cf5b0cc27d5f48868cf2d | 2) Prinses, Beatrixlaan 23, 2595 AK, The Hague, The Netherlands | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2014-02-03-80ef1083-10199-0 |
f1342c9c1e1c4b93f91434dcc7905a30ef6d8ff9 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2014-02-03-80ef1083-10199-0 |
613e2b51048fb3ef102692b1ebf3ec1622e3672e | 1) Return flight, hotel accommodation and some transport costs; total £509.18 | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2014-02-03-80ef1083-10199-0 |
e6aa60814e653254c65c85121223f01d47e39ae0 | 2) Transport and some meals; total £244.11 | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2014-02-03-80ef1083-10199-0 |
63073770961881aba352a73e07570aacacfb891e | Destination of visit: The Netherlands | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2014-02-03-80ef1083-10199-0 |
0d0e4e48dd96dc542cfb5e76dd92a3a45fcc03e6 | Date of visit: 21-24 February 2013 | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2014-02-03-80ef1083-10199-0 |
60d7ec728da925e1847bccab2c0a1a3860ee1713 | Purpose of visit: visit as part of Industry and Parliament Trust Fellowship | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2014-02-03-80ef1083-10199-0 |
088f468caad91ff02ae67eef421fa67f6dfb405e | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2014-02-03 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 12 | 2014-02-03-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");