items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where "date" is on date 2010-10-25 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 |
---|---|---|---|---|---|---|---|
c9de50bc1ca8a7035acadb6e75d84202c454fe54 | 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-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-10-25-1f359ece-10009-0 |
9a1c120bc73245f26636f9649679ad30c298472d | Received annual payment of £6,000 on 21 December 2009. Hours: 100 hrs. (Registered 7 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-10-25-1f359ece-10009-0 |
b34d2b8516ba2b857f063195c911a2453956a3e6 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-10-25-8f616a6e-10009-0 |
43c66c43fe70234eb068c2dd9108fd6d6bcecbb7 | Name of donor: Southend West Dining Club | Sponsorships 8f616a6e | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-10-25-8f616a6e-10009-0 |
55336e86db273349e2128cd6a02c559b876dab3f | Address of donor: Kevin Thomas, Bird Luckin Ltd, Aquila House, Waterloo Lane, Chelmsford, CM1 1BW. | Sponsorships 8f616a6e | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2010-10-25-8f616a6e-10009-0 |
b76fffdb010c3d70d2dd32bdd0fc1b14b6a8bd77 | Amount of donation or nature and value if donation in kind: £9,000. No individual donor gave more than £1,500. | Sponsorships 8f616a6e | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2010-10-25-8f616a6e-10009-0 |
841ab320a22d136850a77808612132fc91e1802d | Donor status: group of individuals | Sponsorships 8f616a6e | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2010-10-25-8f616a6e-10009-0 |
68650788a250f5e791111090372d3793e64bec21 | (Registered 15 June 2010) | Sponsorships 8f616a6e | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2010-10-25-8f616a6e-10009-0 |
5e2a4584521a64d8e4713bcc42bd596dca4ea26e | Name of donor: Qatar Government | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-10-25-80ef1083-10009-0 |
f7a055d7c99321a3ad585edf63f3891e9021ab6f | Address of donor: Qatar Embassy, 1 South Audley Street, London W1K 1NB. | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-10-25-80ef1083-10009-0 |
beab457ac5c8ea1e465aba66bf624225a7f7b8d8 | Amount of donation (or estimate of the probable value): estimated value £5,000. | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2010-10-25-80ef1083-10009-0 |
0614de072a890d8ccdf03d0e7fc1542f7b398525 | Destination of visit: Doha, Qatar. | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2010-10-25-80ef1083-10009-0 |
b00477392f5802affb8f2b188f35cea4192f4a28 | Date of visit: 30 May to 2 June 2010 | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2010-10-25-80ef1083-10009-0 |
8903af0e8c01f5419a9f654b6c9bc783d138bcbe | Purpose of visit: to attend the Forum on Democracy | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2010-10-25-80ef1083-10009-0 |
2f4f3d4bcd36a60176992860997bfe16d8174f90 | (Registered 15 June 2010) | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2010-10-25-80ef1083-10009-0 |
19fbdcd9fff4af3369ad14b82e40ef003bdbfb56 | Name of donor: Voluntary Service Organisation | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2010-10-25-80ef1083-10009-0 |
a1f67d02c1535cff46c823a7fe9877234492970a | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-10-25-80ef1083-10009-0 |
0a01d2daa3b1bd7717000c5001902c7284a5498e | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-10-25-80ef1083-10009-0 |
7be413c9dbc1f0386bbac09f4e4ff27ec76fdfba | Destination of visit: Manila and Ifugao Province, Philippines | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2010-10-25-80ef1083-10009-0 |
7401efa149d74045a5f547c42590097b602460a9 | Date of visit: 22 August-3 September 2010 | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2010-10-25-80ef1083-10009-0 |
9df2defc7557a996a5f7a0f8b5b620e73dcbf5ca | Purpose of visit: to participate in VSO’s Parliamentarian Volunteering Scheme | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2010-10-25-80ef1083-10009-0 |
5dce754c8a62f8f6d58802931ab72b05d23f2511 | (Registered 24 September 2010) | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2010-10-25-80ef1083-10009-0 |
dd00e97cff70b09d6c3981967f7be52a8574a338 | Name of donor: Members of the Iranian community in Britain | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 14 | 2010-10-25-80ef1083-10009-0 |
212296b083d4328efc48acd23b5262f3f3e3c5d5 | Address of donor: Trafalgar House, Granvile Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 15 | 2010-10-25-80ef1083-10009-0 |
9c9a16db6410349abde2e2303c7b4a3fbcd66915 | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2010-10-25-80ef1083-10009-0 |
21baccec2e86659f4f7bd45a6230c4b6f609cd8f | Destination of visit: New York | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 17 | 2010-10-25-80ef1083-10009-0 |
92e11862926b99d8fbfd99f131d1bf8a32661ab7 | Date of visit: 20-23 September 2010 | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 18 | 2010-10-25-80ef1083-10009-0 |
6fac11eff790043116e72f29141504c6ef829052 | Purpose of visit: to deliver a speech on behalf of the Iranian community | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 19 | 2010-10-25-80ef1083-10009-0 |
64cba8bc1cd535fc663e1e474a7078fe0cf36b76 | (Registered 7 October 2010) | Overseas visits 80ef1083 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 20 | 2010-10-25-80ef1083-10009-0 |
24723775772a205f428eafc733a9760e462b0630 | Trustee of the Industry and Parliament Trust. | Miscellaneous 5f2cbd10 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-10-25-5f2cbd10-10009-0 |
89de03daea9c7f0ebc64ace00de1c47c283fcb74 | Chairman of the Industry and Parliament Fellowship Committee. | Miscellaneous 5f2cbd10 | 2010-10-25 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-10-25-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");