items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where "date" is on date 2010-12-06 and person_id = "uk.org.publicwhip/person/10009" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, sort_order, record_id
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d5b4a89323896abc682fb26c59fcc3ef64adf7a0 | 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 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-12-06-1f359ece-10009-0 |
c76c15d58fc1d3083e52d0f8b88b585af81b3a20 | Received annual payment of £6,000 on 21 December 2009. Hours: 100 hrs. (Registered 7 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-12-06-1f359ece-10009-0 |
b61a037bd37ca8a2725e7e1147abf5f80775a7fc | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-12-06-8f616a6e-10009-0 |
d365fe22c6f479cf7d6a62f3ae730f1a973ab920 | Name of donor: Southend West Dining Club | Sponsorships 8f616a6e | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-12-06-8f616a6e-10009-0 |
7b84547172c2fb90aa7e804e8c732fcf287ba735 | Address of donor: Kevin Thomas, Bird Luckin Ltd, Aquila House, Waterloo Lane, Chelmsford, CM1 1BW. | Sponsorships 8f616a6e | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2010-12-06-8f616a6e-10009-0 |
c869839cc05b17107fd66c872a02b7ed3775b9c8 | Amount of donation or nature and value if donation in kind: £9,000. No individual donor gave more than £1,500. | Sponsorships 8f616a6e | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2010-12-06-8f616a6e-10009-0 |
111b90593b201dc2895ebac733f9ab9aacee42c0 | Donor status: group of individuals | Sponsorships 8f616a6e | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2010-12-06-8f616a6e-10009-0 |
d4ba6e06f53595bba75787b97716777e6143cc25 | (Registered 15 June 2010) | Sponsorships 8f616a6e | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2010-12-06-8f616a6e-10009-0 |
68e873122a576c1f77b6e1edc98d92bf363e52ba | Name of donor: Qatar Government | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-12-06-80ef1083-10009-0 |
073de0c55d0491dcae92cf42b4eab2e8335a6fdb | Address of donor: Qatar Embassy, 1 South Audley Street, London W1K 1NB. | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-12-06-80ef1083-10009-0 |
d4dfc22260fcf88281f15d64dcebb0b47927547a | Amount of donation (or estimate of the probable value): estimated value £5,000. | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2010-12-06-80ef1083-10009-0 |
2af3dd461ec5e12b2097556fa6e182dec328c25f | Destination of visit: Doha, Qatar. | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2010-12-06-80ef1083-10009-0 |
c017c789c5a4942015612d4cc04a31794bbd9bca | Date of visit: 30 May to 2 June 2010 | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2010-12-06-80ef1083-10009-0 |
2e642401f7ac0d6a016fe54ce3b1bd7ee6efad5d | Purpose of visit: to attend the Forum on Democracy | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2010-12-06-80ef1083-10009-0 |
9e90ec533e539a048c632371caea13448227093d | (Registered 15 June 2010) | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2010-12-06-80ef1083-10009-0 |
c841c1328bb9b1d86fca08fd9684073262bd9c27 | Name of donor: Voluntary Service Organisation | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2010-12-06-80ef1083-10009-0 |
a6cb06f74c5583b346254bceccaab46583bc7c0d | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-12-06-80ef1083-10009-0 |
ced9a963724f98fbbf6fe12e65536791a50a1787 | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-12-06-80ef1083-10009-0 |
342b156f25a95a2e0a4ff061fa8c284839020dc2 | Destination of visit: Manila and Ifugao Province, Philippines | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2010-12-06-80ef1083-10009-0 |
cdc8cb5ab2e06c5838d9dd78a7ed51f70807aba5 | Date of visit: 22 August-3 September 2010 | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2010-12-06-80ef1083-10009-0 |
fd03e80c65575625b854bb55bfb4c3b9bd28fcfa | Purpose of visit: to participate in VSO’s Parliamentarian Volunteering Scheme | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2010-12-06-80ef1083-10009-0 |
25d6a174819ecf70bb7f5514c14286ea2868ca22 | (Registered 24 September 2010) | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2010-12-06-80ef1083-10009-0 |
2f4ab3ebae5ac00d2823f6e4a43256ede9d2437d | Name of donor: Iran Liberty Association | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 14 | 2010-12-06-80ef1083-10009-0 |
e9c5c3ed2c98d944a234912a9f47e61f99caaf61 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 15 | 2010-12-06-80ef1083-10009-0 |
b5db6ed41505d7e91e8e754b26df78f3e16b6c51 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2010-12-06-80ef1083-10009-0 |
40a6f3a3377f6f7372d6c15fe2f26603fd0762b5 | Destination of visit: New York | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 17 | 2010-12-06-80ef1083-10009-0 |
15231fb83ca89e14417fcf9deaf7aca30ad4cc63 | Date of visit: 20-23 September 2010 | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 18 | 2010-12-06-80ef1083-10009-0 |
1fa2a9c0e7a0d13f14585e7e80a22c2aba08ac5b | Purpose of visit: to deliver a speech on behalf of the Iranian community | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 19 | 2010-12-06-80ef1083-10009-0 |
e26bc99aadab7bd9bb83ffcea061a84ab332c161 | (Registered 7 October 2010) | Overseas visits 80ef1083 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 20 | 2010-12-06-80ef1083-10009-0 |
022f2c8bc81bc65eb0505c60631335f4edb97db8 | Trustee of the Industry and Parliament Trust. | Miscellaneous 5f2cbd10 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-12-06-5f2cbd10-10009-0 |
4b3a469beeb98f3caad8c8d3e3de0c0a1ced2eab | Chairman of the Industry and Parliament Fellowship Committee. | Miscellaneous 5f2cbd10 | 2010-12-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-12-06-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");