items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2011-04-18-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 |
---|---|---|---|---|---|---|---|
b06760206fbbbaec9f19621101cccc32d5bd7b9e | Name of donor: Qatar Government | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2011-04-18-80ef1083-10009-0 |
f9406ea4ab0ccb1c51cd6d07e9fe8bf021bbb6c5 | Address of donor: Qatar Embassy, 1 South Audley Street, London W1K 1NB. | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2011-04-18-80ef1083-10009-0 |
f6e8815acf0e4f9570b93b816b1000f1fa162bd4 | Amount of donation (or estimate of the probable value): estimated value £5,000. | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2011-04-18-80ef1083-10009-0 |
f927603c89034cc27bd2fbd1a5bb47bee382327f | Destination of visit: Doha, Qatar. | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2011-04-18-80ef1083-10009-0 |
233bca9dee6f64ad1c7a34e04424c24aca85ac26 | Date of visit: 30 May to 2 June 2010 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2011-04-18-80ef1083-10009-0 |
2430ac3aac3ecd47d954c6cc82b6bc9d7a9ada26 | Purpose of visit: to attend the Forum on Democracy | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2011-04-18-80ef1083-10009-0 |
61f96239af245c84ddbdc7669bd0b750382eab6a | (Registered 15 June 2010) | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2011-04-18-80ef1083-10009-0 |
71739d144725567e3035556f5be4163fa5b732fa | Name of donor: Voluntary Service Organisation | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2011-04-18-80ef1083-10009-0 |
e2ce9c646f5e244d819a5aeee3886dc263399ca8 | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-04-18-80ef1083-10009-0 |
3e56861cacfb37b15101d262c04940ca8ae0ea73 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-04-18-80ef1083-10009-0 |
b5cd0d557b2573b37ec442cfb8799cf744026498 | Destination of visit: Manila and Ifugao Province, Philippines | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2011-04-18-80ef1083-10009-0 |
8bc450e79ce30dcd82b46c05ecef082c84a6af4b | Date of visit: 22 August-3 September 2010 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2011-04-18-80ef1083-10009-0 |
2af6dd9316dd26d1f89f74948a1326957117345b | Purpose of visit: to participate in VSO’s Parliamentarian Volunteering Scheme | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2011-04-18-80ef1083-10009-0 |
62c7cb2b122e9bb17ca82b649f182fe84e669367 | (Registered 24 September 2010) | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2011-04-18-80ef1083-10009-0 |
ee833b7c42a7c049e0be46f2569bd89b0214fb3c | Name of donor: Iran Liberty Association | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 14 | 2011-04-18-80ef1083-10009-0 |
3e56f5cbcfe6ca92ecd5cb62560c0baa0337dba2 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 15 | 2011-04-18-80ef1083-10009-0 |
49199488d8319f5cc4f616b8055c15ffaf61e15c | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-04-18-80ef1083-10009-0 |
2ab15e6e2f2b93a8a1a43d9c21f91b641a4c876f | Destination of visit: New York | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 17 | 2011-04-18-80ef1083-10009-0 |
9199fe295fe6ac17704b37ea6a74433dad0f790f | Date of visit: 20-23 September 2010 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 18 | 2011-04-18-80ef1083-10009-0 |
e7c979af4e07c1e7e4d0cf2a31079d66a780be38 | Purpose of visit: to deliver a speech on behalf of the Iranian community | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 19 | 2011-04-18-80ef1083-10009-0 |
1cc0f3c602d91aa23aef587efcca1d985ff1ea5b | (Registered 7 October 2010) | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 20 | 2011-04-18-80ef1083-10009-0 |
c2a8d91fcc5ccc6e16427249f86a01b75da3c1dc | Name of donor: Hong Kong Economic and Trade Office (HKETO) | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 21 | 2011-04-18-80ef1083-10009-0 |
aae6122ae2f0d51bdb155d561b3092ed5e996d04 | Address of donor: 6 Grafton Street, London W1S 4EQ | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 22 | 2011-04-18-80ef1083-10009-0 |
f58ff43b6d349283dce91c5ecf56fd6c76cc9195 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 23 | 2011-04-18-80ef1083-10009-0 |
2b14db243789110ade1ec3f2d4314b2f85fe6971 | Destination of visit: Hong Kong | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 24 | 2011-04-18-80ef1083-10009-0 |
8ba233f02eceb4cbc9041a8b513ded92d48818d0 | Date of visit: 19-26 February 2011 | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 25 | 2011-04-18-80ef1083-10009-0 |
28a47ef459c63477d14259e6ff2750bf894ddc35 | Purpose of visit: to strengthen bilateral ties and deepen understanding between the UK and Hong Kong, and to update knowledge and awareness of Hong Kong’s political, social and economic development | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 26 | 2011-04-18-80ef1083-10009-0 |
43282329c42ef4933b9ad26595580c49e504e6a5 | (Registered 21 March 2011) | Overseas visits 80ef1083 | 2011-04-18 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 27 | 2011-04-18-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");