items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2012-01-13-80ef1083-10009-0" sorted by sort_order descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
c0eced20b21f8bfd0412497413f5b67cfd460f9a | (Registered 21 March 2011) | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 20 | 2012-01-13-80ef1083-10009-0 |
0f1ed0f8c0af48795c99d884a90f28da8cc0eaf1 | 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 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 19 | 2012-01-13-80ef1083-10009-0 |
d4d3ae175b8bdb69ad955568b57d1d15dd842947 | Date of visit: 19-26 February 2011 | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 18 | 2012-01-13-80ef1083-10009-0 |
74b9b0466eba6626725b2c4f2e409aebabdbca06 | Destination of visit: Hong Kong | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 17 | 2012-01-13-80ef1083-10009-0 |
3982d2257d01b6ab5e1fb46a9e843dd2d089e5bf | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2012-01-13-80ef1083-10009-0 |
bdbd130969a8f7a0e09adabe20ee7a1302901991 | Address of donor: 6 Grafton Street, London W1S 4EQ | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 15 | 2012-01-13-80ef1083-10009-0 |
790ea1975a0c39dae94f8b11d6da2c4d896ea4ff | Name of donor: Hong Kong Economic and Trade Office (HKETO) | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 14 | 2012-01-13-80ef1083-10009-0 |
67dad500adbd20905c3713063b57e0e5ed508f1e | (Registered 7 October 2010) | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2012-01-13-80ef1083-10009-0 |
17b79dbaec30ead3cfdd1e440cf36d6c8578740e | Purpose of visit: to deliver a speech on behalf of the Iranian community | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2012-01-13-80ef1083-10009-0 |
a4052a1b420722ef32ba2ce25fc1f5a69b5ab68f | Date of visit: 20-23 September 2010 | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2012-01-13-80ef1083-10009-0 |
6f47ecc33cadce0d0f1af05a88c1aba0f74aecd3 | Destination of visit: New York | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2012-01-13-80ef1083-10009-0 |
2e7bdb4297ba9ec7cf911ded6ed4e52dd818527f | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4,487.57 | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2012-01-13-80ef1083-10009-0 |
8713305e6dcbf044da62e25402a696f142007750 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2012-01-13-80ef1083-10009-0 |
b13446cf2e433c5e242913390ff5387cc7733113 | Name of donor: Iran Liberty Association | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2012-01-13-80ef1083-10009-0 |
2617725ba368425080d0220b958f1052e01d9dff | (Registered 24 September 2010) | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2012-01-13-80ef1083-10009-0 |
445fcbd044b699b76b37c2f5afc0c6f432d05544 | Purpose of visit: to participate in VSO’s Parliamentarian Volunteering Scheme | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2012-01-13-80ef1083-10009-0 |
efe83a58f87fca22ff75cb5f2acf4836d3547346 | Date of visit: 22 August-3 September 2010 | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2012-01-13-80ef1083-10009-0 |
14e3f4d9ddb9ffa257dd213aa91b06d65768576d | Destination of visit: Manila and Ifugao Province, Philippines | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2012-01-13-80ef1083-10009-0 |
9a9168a951d1ac9dd4dc63ce575e663702d32e73 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2012-01-13-80ef1083-10009-0 |
09b036f919e17231f3c2859a339f8321da4ee3b1 | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2012-01-13-80ef1083-10009-0 |
3f5b2f9542bffc2f0041280ce8e7afab0a556ec4 | Name of donor: Voluntary Service Organisation | Overseas visits 80ef1083 | 2012-01-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2012-01-13-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");