items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-01-20-80ef1083-10199-0" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
71172bdca356c238deb6a192e351f09218344a78 | Name of donor: | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2014-01-20-80ef1083-10199-0 |
3d86a7c12f90078f4b27cc799f128311d0fed170 | 1) TNT Post UK | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2014-01-20-80ef1083-10199-0 |
56c43d82998652d2efb992b4fd2858d84a4008f5 | 2) PostNL | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2014-01-20-80ef1083-10199-0 |
062f8ea1e3d2c1f948cc6e80f5df3a99316b1a93 | Address of donor: | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2014-01-20-80ef1083-10199-0 |
e7ff590ee5870f7724303bda85fda8191b06fd89 | 1) 1 Globeside Business Park, Fieldhouse Lane, Marlow, Bucks SL7 1HY | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2014-01-20-80ef1083-10199-0 |
23a3d4b4e73e9a47cba55412ff241deeb8cb1802 | 2) Prinses, Beatrixlaan 23, 2595 AK, The Hague, The Netherlands | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2014-01-20-80ef1083-10199-0 |
2e5020630afec7e298205dab0689b51090a7bb24 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2014-01-20-80ef1083-10199-0 |
58902bd40490742b512952c9b2510c74eb4a9c8e | 1) Return flight, hotel accommodation and some transport costs; total £509.18 | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2014-01-20-80ef1083-10199-0 |
e236a7fe330f9ec215bbd015eafba6fb92e5fd4a | 2) Transport and some meals; total £244.11 | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2014-01-20-80ef1083-10199-0 |
bedb48978236e20e563261eeede033f500478c61 | Destination of visit: The Netherlands | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2014-01-20-80ef1083-10199-0 |
e1cd4e610573822e5ffab3c8e5afee2db9159b74 | Date of visit: 21-24 February 2013 | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2014-01-20-80ef1083-10199-0 |
38bdb0344eea95f6da8b2743c1ae6378350aa422 | Purpose of visit: visit as part of Industry and Parliament Trust Fellowship | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2014-01-20-80ef1083-10199-0 |
3609dad978d76349e006844f35cda515d63d728f | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2014-01-20 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 12 | 2014-01-20-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");