items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2009-10-14-80ef1083-10009-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
fdbffdb87bd90fc4b1be3b82d5f32792a94e6513 | 4-11 April 2009 to China as a guest of the Chinese Association of Friendship and Understanding. Accommodation and food paid for by the Association and flight sponsored by Mr Maurice Bennett; businessman, London. (Registered 13 April 2009) | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2009-10-14-80ef1083-10009-0 |
968bba18d78eac8456cb96b69ef88b5c314a8ae8 | 15-20 February 2009, to Israel on a parliamentary delegation, paid for by Conservative Friends of Israel and the Government of Israel. (Registered 27 April 2009) | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2009-10-14-80ef1083-10009-0 |
9f2c69ac61b14673c0b0017600a229ba80a57933 | Name of donor: Maldives Government | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2009-10-14-80ef1083-10009-0 |
594608e5145fbac10687b647ccc4ef60632e5c0a | Address of donor: Maldives Government Offices, Maldives | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2009-10-14-80ef1083-10009-0 |
bfa6490101a474602a3b0f08275e4ce17bd753f4 | Amount of donation (or estimate of the probable value): less than £5,000 | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2009-10-14-80ef1083-10009-0 |
251c3cc4ce4b9e39c66b6236f16b01680651e0d1 | Destination of visit: Maldives | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2009-10-14-80ef1083-10009-0 |
be1302258c94acff1cbaba43c3e0e1edd1c5358c | Date of visit: 24 August-2 September 2009 | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2009-10-14-80ef1083-10009-0 |
8ff2c4be73d5b5f4a7a6eb358d6c0cc948f024c5 | Purpose of visit: to meet parliamentarians and advise on good practice in election procedures, as a member of the All-Party British-Maldives Parliamentary Group. | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2009-10-14-80ef1083-10009-0 |
5882ba44f66c1562135bbc551c637e5a507472bb | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2009-10-14-80ef1083-10009-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");