items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2013-07-29-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 |
---|---|---|---|---|---|---|---|
8577e411e0da8ab05eafecfe96d6a19b8407f04e | Name of donor: | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2013-07-29-80ef1083-10199-0 |
1d95cbfb8fa6df8dc78ee78c11c680a8fd995713 | 1) TNT Post UK | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2013-07-29-80ef1083-10199-0 |
0473adffc765a57051604182887ce997bfbb124d | 2) PostNL | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2013-07-29-80ef1083-10199-0 |
d6403e60da6eaf99f68101cb721d3bc40b93c085 | Address of donor: | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2013-07-29-80ef1083-10199-0 |
5b20a70de0b9764a465c3fa075dd8f3d29c2dc8e | 1) 1 Globeside Business Park, Fieldhouse Lane, Marlow, Bucks SL7 1HY | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2013-07-29-80ef1083-10199-0 |
286364bff18c41939c91ccd9e400da9836ccf88b | 2) Prinses, Beatrixlaan 23, 2595 AK, The Hague, The Netherlands | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2013-07-29-80ef1083-10199-0 |
b6eae49888eaab832873b8a0c4ac26ab5a139631 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2013-07-29-80ef1083-10199-0 |
448914f0a25ad483925d2956467c84227a7a81e4 | 1) Return flight, hotel accommodation and some transport costs; total £509.18 | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2013-07-29-80ef1083-10199-0 |
c4b606c4a83140e4ece0e7513bc65d6cd02befae | 2) Transport and some meals; total £244.11 | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2013-07-29-80ef1083-10199-0 |
8393f8298b7a6504bfb9fefd986ce9d29136c9bf | Destination of visit: The Netherlands | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2013-07-29-80ef1083-10199-0 |
3ff1711a2a0e1a1ddc0e08167550b9798c577885 | Date of visit: 21-24 February 2013 | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2013-07-29-80ef1083-10199-0 |
c2485ddfe4d0c99ad9f55e49b4304d47fc8e3d60 | Purpose of visit: visit as part of Industry and Parliament Trust Fellowship | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2013-07-29-80ef1083-10199-0 |
a532803919ea742762dd2be6fa1c4dc574590b34 | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2013-07-29 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 12 | 2013-07-29-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");