items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2010-09-06-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 |
---|---|---|---|---|---|---|---|
9fc47f89a8427a1dd80fda4903c1b07dd72472be | Name of donor: Maldives Government | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2010-09-06-80ef1083-10009-0 |
139111dd7534d8c071a20132b21efc9363c3c0c0 | Address of donor: Maldives Government Offices, Maldives | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2010-09-06-80ef1083-10009-0 |
9252b755ae1abcc45c226d87cacf6e24f8d3d134 | Amount of donation (or estimate of the probable value): less than £5,000 | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2010-09-06-80ef1083-10009-0 |
ad852717c2025f31242a5192661283b35629ead1 | Destination of visit: Maldives | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2010-09-06-80ef1083-10009-0 |
026ae0b53ce8e5cc0ddcaf18fb1369600fc5151b | Date of visit: 24 August-2 September 2008 | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2010-09-06-80ef1083-10009-0 |
5b0c2d945965b8addebec6a1b6c16eb92f4fad8f | Purpose of visit: to meet parliamentarians and advise on good practice in election procedures, as a member of the All-Party British-Maldives Parliamentary Group. | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2010-09-06-80ef1083-10009-0 |
620415c0ec9a556e86db3d56c78a1ad9d395523d | (Registered 15 September 2009) | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2010-09-06-80ef1083-10009-0 |
8cff166e8096361a7e06384bb4f8db68d35f017f | Name of donor: Qatar Government | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2010-09-06-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 |
a8169f1ca27d95fc9eae499df666df268aec4914 | Amount of donation (or estimate of the probable value): estimated value £5,000. | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2010-09-06-80ef1083-10009-0 |
6f38a7061babf9ad5d29e0a131a1345ab69b12c6 | Destination of visit: Doha, Qatar. | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2010-09-06-80ef1083-10009-0 |
73bfd5ff4ee972c7cb64dfc385f8fba183cc8c17 | Date of visit: 30 May to 2 June 2010 | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2010-09-06-80ef1083-10009-0 |
ca08e6ba086858ce22fcf5d69986b0b7b1cd0a68 | Purpose of visit: to attend the Forum on Democracy | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2010-09-06-80ef1083-10009-0 |
4cf4515668c9af4038479907fec7494e1aa3a79d | (Registered 15 June 2010) | Overseas visits 80ef1083 | 2010-09-06 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2010-09-06-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");