items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
39 rows where "date" is on date 2011-05-03 and person_id = "uk.org.publicwhip/person/10009" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d51d2666ee2e7b7b5ea8e1c6357f83a0aaca6ad5 | Parliamentary Adviser to the Caravan Club, East Grinstead House, East Grinstead, West Sussex RH19 1UA. (£5,001–£10,000) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2011-05-03-1f359ece-10009-0 |
f142033461881b0e5f0e6f8b8fe5e0f01cabe1f0 | Received annual payment of £6,000 on 21 December 2009. Hours: 100 hrs. (Registered 7 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2011-05-03-1f359ece-10009-0 |
a979de3ffc7ac56a829dc115d969a1dc65ba046a | 18 March 2011, payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion research interview in February 2011. Hours: 15 mins. Payment donated to charity. (Registered 30 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2011-05-03-1f359ece-10009-0 |
5aa94ffb80d9b77ad02fb23dca8b101cd37ced4a | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2011-05-03-8f616a6e-10009-0 |
22a14cf79cddbf0c963d5852c7963ceff8f06bd6 | Name of donor: Southend West Dining Club | Sponsorships 8f616a6e | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2011-05-03-8f616a6e-10009-0 |
5e3be9f9402b98aab069918e5d7480b07b221156 | Address of donor: Kevin Thomas, Bird Luckin Ltd, Aquila House, Waterloo Lane, Chelmsford, CM1 1BW. | Sponsorships 8f616a6e | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2011-05-03-8f616a6e-10009-0 |
a67da788ecee1aeaa97e17384c6e4281fd4d2b7c | Amount of donation or nature and value if donation in kind: £9,000. No individual donor gave more than £1,500. | Sponsorships 8f616a6e | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2011-05-03-8f616a6e-10009-0 |
13c6cbb7173bc4458eef38f6c9ba028bbeb21e00 | Donor status: group of individuals | Sponsorships 8f616a6e | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2011-05-03-8f616a6e-10009-0 |
89a9a0885e829bff9d9d97e91e9f7bc1d085fa64 | (Registered 15 June 2010) | Sponsorships 8f616a6e | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2011-05-03-8f616a6e-10009-0 |
416019dd5b63b8ceaaf63a7cf99910975a5c8cf1 | Name of donor: Qatar Government | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2011-05-03-80ef1083-10009-0 |
55e53c3683e582d4afc04def6115682072a1262b | Address of donor: Qatar Embassy, 1 South Audley Street, London W1K 1NB. | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2011-05-03-80ef1083-10009-0 |
9f9a1f3afb7465ff68a040e5a43ec2785d4f3827 | Amount of donation (or estimate of the probable value): estimated value £5,000. | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2011-05-03-80ef1083-10009-0 |
8a97dc5d668764f1c46c85b94fcd961eb9f33091 | Destination of visit: Doha, Qatar. | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2011-05-03-80ef1083-10009-0 |
4ec7b123c49fab64f4c1c3ce2d2f4b166ba38c00 | Date of visit: 30 May to 2 June 2010 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2011-05-03-80ef1083-10009-0 |
453d20ddab556931e692ca089fa6fb958ec0a2ce | Purpose of visit: to attend the Forum on Democracy | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2011-05-03-80ef1083-10009-0 |
197b38ec8f0fbed7695103d2a73bc581a04987d1 | (Registered 15 June 2010) | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2011-05-03-80ef1083-10009-0 |
b202c4a21c66b3c9d65a1c6a5f222cc73cf89905 | Name of donor: Voluntary Service Organisation | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2011-05-03-80ef1083-10009-0 |
2d7bb341d27a320a85fa3a2dbeecdb60c3b59fd9 | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-05-03-80ef1083-10009-0 |
5475e9281b939fc7fb0776fa1f67bbee0b8eef90 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-05-03-80ef1083-10009-0 |
498e2f16eaa54dad452802a295ba42c2467dedc0 | Destination of visit: Manila and Ifugao Province, Philippines | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2011-05-03-80ef1083-10009-0 |
74050f3e890f8eb1108ec86b4aac476a25409b5e | Date of visit: 22 August-3 September 2010 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2011-05-03-80ef1083-10009-0 |
fbbf723997e321d5e7c168c6b82e8f9978531ba6 | Purpose of visit: to participate in VSO’s Parliamentarian Volunteering Scheme | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2011-05-03-80ef1083-10009-0 |
66b0408a61b33616e7f98de5fdb449da31594b78 | (Registered 24 September 2010) | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2011-05-03-80ef1083-10009-0 |
1760e2ccb249188fa5331837314f2fb23c501579 | Name of donor: Iran Liberty Association | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 14 | 2011-05-03-80ef1083-10009-0 |
5ec3a05ef7367226f5298d10db84de269be869d7 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 15 | 2011-05-03-80ef1083-10009-0 |
3012ec8ff2743232305e87dac6d4876c63868d1f | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-05-03-80ef1083-10009-0 |
eae59c3c5d0abb8b1e5a04ed212c8410e9c59a65 | Destination of visit: New York | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 17 | 2011-05-03-80ef1083-10009-0 |
93a47e0a47ac0610b430a63aa4e750582206fe88 | Date of visit: 20-23 September 2010 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 18 | 2011-05-03-80ef1083-10009-0 |
315ef5f31ee308f97e9efd9223f47adad2a9eed4 | Purpose of visit: to deliver a speech on behalf of the Iranian community | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 19 | 2011-05-03-80ef1083-10009-0 |
4a7cb7d7d3abc9dfbe022daebf930cdb105e05cb | (Registered 7 October 2010) | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 20 | 2011-05-03-80ef1083-10009-0 |
32d79d5ab73a23f6a9ca87559ef73cf6d43097d3 | Name of donor: Hong Kong Economic and Trade Office (HKETO) | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 21 | 2011-05-03-80ef1083-10009-0 |
18c59a45db1e4e3b8c6310559b47857db8e489d1 | Address of donor: 6 Grafton Street, London W1S 4EQ | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 22 | 2011-05-03-80ef1083-10009-0 |
8b46f98f6617dbb6a84bae045451d1da71203057 | Amount of donation (or estimate of the probable value): £7,752.29, including business class flights, accommodation, transportation and meals | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 23 | 2011-05-03-80ef1083-10009-0 |
7724f4c6759a1742cb850fa81123134a53bf2269 | Destination of visit: Hong Kong | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 24 | 2011-05-03-80ef1083-10009-0 |
096347bb895ceef823b6ca021e2de9a9a5e28e50 | Date of visit: 19-26 February 2011 | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 25 | 2011-05-03-80ef1083-10009-0 |
2b6c06d0ed7e39dee44dc8a7cce761a32443e375 | 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-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 26 | 2011-05-03-80ef1083-10009-0 |
6f82165e5533bceeabad4c7f123fa5564d385d7c | (Registered 21 March 2011) | Overseas visits 80ef1083 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 27 | 2011-05-03-80ef1083-10009-0 |
7a5d2a8a9331a58f1b63af56e72eebe898f75526 | Trustee of the Industry and Parliament Trust. | Miscellaneous 5f2cbd10 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2011-05-03-5f2cbd10-10009-0 |
be9549fd439291f60839867d3a94b9c9db365ffd | Chairman of the Industry and Parliament Fellowship Committee. | Miscellaneous 5f2cbd10 | 2011-05-03 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2011-05-03-5f2cbd10-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");