items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
54 rows where person_id = "uk.org.publicwhip/person/10009" and sort_order = 8 sorted by record_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
5882ba44f66c1562135bbc551c637e5a507472bb | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2009-10-14 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2009-10-14-80ef1083-10009-0 |
a18057d9e4adab1a108d5e28d6c9bf239369ed2d | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2009-10-28 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2009-10-28-80ef1083-10009-0 |
faeb0b281523d572ec0bf8aa08a7f4296be896d9 | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2009-11-11 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2009-11-11-80ef1083-10009-0 |
a0898c5f9c9cd7505ac074fdf10ac2d94684ec8a | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2009-11-25 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2009-11-25-80ef1083-10009-0 |
a2bf3de2e7685c07417bca11ffddd37239738468 | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2009-12-10 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2009-12-10-80ef1083-10009-0 |
103e4bdf5aff0646cac18e8fb5ee0e4cb49d67ca | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2010-01-06 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-01-06-80ef1083-10009-0 |
783197fc31484cb4da2e9f2932b8721ff3217d76 | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2010-02-03 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-02-03-80ef1083-10009-0 |
1e2dea9aa7ade4aaa0c3349a6d81efd0d739980b | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2010-02-24 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-02-24-80ef1083-10009-0 |
8faa10f46fbfcbd1b10e6da4b99c438f4eb7f8b4 | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2010-03-10 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-03-10-80ef1083-10009-0 |
7848ae3ccac7d4d6da1c0f9dffa0172181ab901d | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2010-03-24 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-03-24-80ef1083-10009-0 |
ec149be8219c0e9a33c6288d2e254a10ed0926fa | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2010-04-12 | David Amess uk.org.publicwhip/member/1829 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-04-12-80ef1083-10009-0 |
432b50ce5e1fbc1f07ac7e4a743e1ce1fb0ac1cf | Address of donor: Qatar Embassy, 1 South Audley Street, London W1K 1NB. | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-09-06-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 |
253e9639ef32cf5532e6b6b5eb7faf0dcaca69bb | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2010-11-08 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-11-08-80ef1083-10009-0 |
3e83de700a676d3ba4cfade1f97fb75f96489d16 | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2010-11-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-11-22-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 |
1a7d97152002090e94578eeeba42221c6501ebac | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2010-12-20 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2010-12-20-80ef1083-10009-0 |
7efe3e86a1d80e4db09cdd84a93848dd4913ffee | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-01-10-80ef1083-10009-0 |
ba904ce90d18f66b8c332648e9df82f244ee882d | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-01-24 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-01-24-80ef1083-10009-0 |
ce86c7ec949f70d4445ad118ff582061a891d408 | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-02-07 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-02-07-80ef1083-10009-0 |
b9326c3cb5256795bf4ecc78f0ac0841447d789b | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-02-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-02-28-80ef1083-10009-0 |
58644a024201dce63bcc8c02eeda27dbca0ff993 | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-03-14 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-03-14-80ef1083-10009-0 |
80e6fb1fe67d0a2db5135f130be41fafc236eda7 | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-03-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-03-28-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 |
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 |
6c186c4e8d63f81c3a3a6b3ec91d5ece6ee9306a | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-05-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-05-16-80ef1083-10009-0 |
46f14ac9753af8f29fc4f0592e2563e772fc07cd | Address of donor: Carlton House, 27A Carlton Drive, London SW15 2BS | Overseas visits 80ef1083 | 2011-06-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-06-06-80ef1083-10009-0 |
5556ec2b36c8ecef11a56c613135fa3ffea08a28 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-06-20 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-06-20-80ef1083-10009-0 |
767b727c87f7d10669046eb69dc3ed97349dc7a6 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-07-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-07-06-80ef1083-10009-0 |
ee2ab2248ed6704e95e615a2ed1f1c33dfdfdc26 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-07-19 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-07-19-80ef1083-10009-0 |
aac53aa66e138b8cfc9269a34fcd9d46e708e100 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-08-30 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-08-30-80ef1083-10009-0 |
f9ea6c56559e2f5e054216bb1f7d5e777e532366 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-09-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-09-28-80ef1083-10009-0 |
75ef88d4178ebdb11ecce9e4dab8301bb1351048 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-10-17 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-10-17-80ef1083-10009-0 |
f96317ac5016a9998b3ca84724b26c7d67c4d3de | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-10-31 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-10-31-80ef1083-10009-0 |
55320497ed56f01ef2cf4a6fae34aa9ec2058019 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-11-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-11-16-80ef1083-10009-0 |
3f105922474215e5684339106393450f6c67b584 | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-11-29 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-11-29-80ef1083-10009-0 |
a3c2d0437ba4937c1facfaf779123b9d4a4e2c7c | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-12-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2011-12-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 |
31cda862cd8ec21c2c28e378b86c826d77fea7a2 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-06-16 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-06-16-80ef1083-10009-0 |
d12d20b57fa14c48c4cf2739e371a545142183a1 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-06-30 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-06-30-80ef1083-10009-0 |
854984d6860552410b71b10a3587274e140f46c7 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-07-14 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-07-14-80ef1083-10009-0 |
da96b5115c9628d29152b8588d4938a23910a960 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-07-28 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-07-28-80ef1083-10009-0 |
86b984f0a691f58b0f7ef1148d4da8280aa45303 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-08-26 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-08-26-80ef1083-10009-0 |
2a28dcc88384e17c2910116c4e5066ad7808cb91 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-09-22-80ef1083-10009-0 |
cb840fe8bfe7b9f88ac978b5d6f06fcce2a71fff | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-10-13 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-10-13-80ef1083-10009-0 |
840c3523230ee687dfc1c2f5d04bd86e8e1fce07 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-10-27 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-10-27-80ef1083-10009-0 |
8c3a888ad290e7e3a340b16c7ff29ea5b9b13a7b | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-11-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-11-10-80ef1083-10009-0 |
8852f0f8d4c0de8885c4e7c6a8467241d3e855ff | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-11-24 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-11-24-80ef1083-10009-0 |
130dc990793ccf4799cb2f73a66892c18a1dacf0 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-12-08 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-12-08-80ef1083-10009-0 |
5db91d2945230a03c51ed40d56542e10052af881 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2015-01-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2015-01-06-80ef1083-10009-0 |
0e4faeee6a004c05f768cb0538fed7e37a10f13e | Payment of £350 expected from Eden & Partners, 50 Broadway, London SW1H 0RG, for taking part in a seminar on parliamentary engagement with a group of NHS clinical fellows on 11 September 2019. Hours: 2 hrs. (Registered 12 September 2019) | Employment and earnings 10057ffd | 2019-09-16 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2019-09-16-10057ffd-10009-0 | |
05461ef9521a29c636b3dc0a4f17db4d34881055 | Payment of £350 expected from Eden & Partners, 50 Broadway, London SW1H 0RG, for taking part in a seminar on parliamentary engagement with a group of NHS clinical fellows on 11 September 2019. Hours: 2 hrs. (Registered 12 September 2019) | Employment and earnings 10057ffd | 2019-09-30 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2019-09-30-10057ffd-10009-0 | |
082bbb825139f4d3a52ae4e5ab064c571fb981a6 | Payment of £350 expected from Eden & Partners, 50 Broadway, London SW1H 0RG, for taking part in a seminar on parliamentary engagement with a group of NHS clinical fellows on 11 September 2019. Hours: 2 hrs. (Registered 12 September 2019) | Employment and earnings 10057ffd | 2019-10-21 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2019-10-21-10057ffd-10009-0 | |
4e8bc27f40dd5d81135cea6f503869b48e2685ba | Payment of £350 expected from Eden & Partners, 50 Broadway, London SW1H 0RG, for taking part in a seminar on parliamentary engagement with a group of NHS clinical fellows on 11 September 2019. Hours: 2 hrs. (Registered 12 September 2019) | Employment and earnings 10057ffd | 2019-11-05 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2019-11-05-10057ffd-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");