items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2011-01-10-80ef1083-10009-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
de3dd50e575a867e0f1317854128b8cdb3c7a4ae | Name of donor: Qatar Government | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2011-01-10-80ef1083-10009-0 |
001d9f6c2e909a0d564d5e2c0e41d31aa0c621b8 | Address of donor: Qatar Embassy, 1 South Audley Street, London W1K 1NB. | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2011-01-10-80ef1083-10009-0 |
38624adbdeeef5ca8534df5497f7d3514ddce62c | Amount of donation (or estimate of the probable value): estimated value £5,000. | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2011-01-10-80ef1083-10009-0 |
f4c7a29aa645270dbc7a3ebe395aa9cc20210dfb | Destination of visit: Doha, Qatar. | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2011-01-10-80ef1083-10009-0 |
36735c3a1f90781abeb6689ad5328f9a43bcf4b2 | Date of visit: 30 May to 2 June 2010 | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2011-01-10-80ef1083-10009-0 |
948ca380ee0336c49995e2119f34b16d8a00803e | Purpose of visit: to attend the Forum on Democracy | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2011-01-10-80ef1083-10009-0 |
c9f2a2da0a14eeb8108f341e699e943f7525a371 | (Registered 15 June 2010) | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2011-01-10-80ef1083-10009-0 |
6ee881a21ad08510ebf7d448698dc4e07a7aba41 | Name of donor: Voluntary Service Organisation | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2011-01-10-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 |
8d7c23b3515fa39595e929a1c16a01097c506c6c | Amount of donation (or estimate of the probable value): £1,404.37 | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2011-01-10-80ef1083-10009-0 |
8d08669f1cdd72e8bb8de04f7dee28ad0e53fca1 | Destination of visit: Manila and Ifugao Province, Philippines | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2011-01-10-80ef1083-10009-0 |
9437ca820f32e3fbb032a097a52dea344bed0999 | Date of visit: 22 August-3 September 2010 | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2011-01-10-80ef1083-10009-0 |
ab678796df5d24a49aa490794f5440da0320bdf6 | Purpose of visit: to participate in VSO’s Parliamentarian Volunteering Scheme | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2011-01-10-80ef1083-10009-0 |
ae0be98ed0058fde52dd9d1a2649c81b3e7c2c80 | (Registered 24 September 2010) | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2011-01-10-80ef1083-10009-0 |
3a34450663ed76a973d10ef2f89f8df50e4bf6be | Name of donor: Iran Liberty Association | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 14 | 2011-01-10-80ef1083-10009-0 |
64342bd3cdf3ef8269abe55210cfc1624c06a97b | Address of donor: Trafalgar House, Granville Place, Mill Hill, London NW7 3SA | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 15 | 2011-01-10-80ef1083-10009-0 |
f3a80056561720a47fb6ffb9897684aad121a60a | Amount of donation (or estimate of the probable value): Travel and hotel accommodation value £4487.57 | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2011-01-10-80ef1083-10009-0 |
ca69cbecbc73cd38eb871a67313be24ad34ae2e7 | Destination of visit: New York | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 17 | 2011-01-10-80ef1083-10009-0 |
7ffc4592e1708cb78f8b658cc13d507d5447e31e | Date of visit: 20-23 September 2010 | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 18 | 2011-01-10-80ef1083-10009-0 |
2cda55d486060cd4b71d8874acab2ccb642f13c4 | Purpose of visit: to deliver a speech on behalf of the Iranian community | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 19 | 2011-01-10-80ef1083-10009-0 |
481126c11cd413ec168a6c29083b26b51e770505 | (Registered 7 October 2010) | Overseas visits 80ef1083 | 2011-01-10 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 20 | 2011-01-10-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");