items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2013-11-25-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 |
---|---|---|---|---|---|---|---|
c9d8bc2bc273ada8e75ab680902a6bcb9edbd050 | Name of donor: | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 0 | 2013-11-25-80ef1083-10199-0 |
860f6d638125de0d40e81a31af196267ce739d7e | 1) TNT Post UK | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 1 | 2013-11-25-80ef1083-10199-0 |
0da01b99bdfc6a08fbd2a523c1b2ca431f7eff9a | 2) PostNL | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 2 | 2013-11-25-80ef1083-10199-0 |
2184df53dd1a7b8b983c93d14c196d0af0eed63e | Address of donor: | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 3 | 2013-11-25-80ef1083-10199-0 |
29ba4981611e14831c369bab87a9e6db9ffa86ed | 1) 1 Globeside Business Park, Fieldhouse Lane, Marlow, Bucks SL7 1HY | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 4 | 2013-11-25-80ef1083-10199-0 |
9a53c4716db7f654eeedc8b015ce3cd59a53aa90 | 2) Prinses, Beatrixlaan 23, 2595 AK, The Hague, The Netherlands | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 5 | 2013-11-25-80ef1083-10199-0 |
19c9a861043736e7191582223c02b287679fd944 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 6 | 2013-11-25-80ef1083-10199-0 |
470b2443af5e86317b9936b5513f806e9ae13cac | 1) Return flight, hotel accommodation and some transport costs; total £509.18 | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 7 | 2013-11-25-80ef1083-10199-0 |
0c38c644dea3e9d913ea71ba627220c304d4f0cd | 2) Transport and some meals; total £244.11 | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 8 | 2013-11-25-80ef1083-10199-0 |
ff5af0d3788ea2aab1cb77f488ca3b12c0eba381 | Destination of visit: The Netherlands | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 9 | 2013-11-25-80ef1083-10199-0 |
9f5a12a8fb83571e9d3d384964687cdcea488fed | Date of visit: 21-24 February 2013 | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 10 | 2013-11-25-80ef1083-10199-0 |
f2ec8315f06d6495299d4fe1b9ecf8e2389ce2cc | Purpose of visit: visit as part of Industry and Parliament Trust Fellowship | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 11 | 2013-11-25-80ef1083-10199-0 |
13548b37b2126471f51bf9c529432fe492db2c74 | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2013-11-25 | Jim Fitzpatrick uk.org.publicwhip/member/40484 | Jim Fitzpatrick uk.org.publicwhip/person/10199 | 12 | 2013-11-25-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");