items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2014-12-08-80ef1083-10013-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 |
---|---|---|---|---|---|---|---|
be361b5e2c3a151cec8b265464b2c18e27104698 | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2014-12-08-80ef1083-10013-0 |
7e9d49131fe2935757e1e2e2ac88e89e743fee5b | Address of donor: 45B Westbourne Terrace, London W2 3UR | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2014-12-08-80ef1083-10013-0 |
8153bd12de97a2abc8bca763f2fd6b835db1d316 | Amount of donation (or estimate of the probable value): Flights, accommodation, internal transport, and meals with a total value of £2,528 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2014-12-08-80ef1083-10013-0 |
8e97ec727155b8aa626999abfe0f37bfe4fe63af | Destination of visit: Israel | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2014-12-08-80ef1083-10013-0 |
c1da326b83fc0e7966a4b82f45f9dcb51c215615 | Date of visit: 3 to 7 July 2014 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2014-12-08-80ef1083-10013-0 |
15a5744e6fe70b548426b22ecefe107d5178256f | Purpose of visit: fact-finding political, industrial, and education discussions in Israel | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2014-12-08-80ef1083-10013-0 |
20e3c3ecce2351587e1d9cbe4cfc604988fa29f5 | (Registered 9 July 2014) | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2014-12-08-80ef1083-10013-0 |
db84b333a84383836cedefc061ad52e7766ccb26 | Name of donor: The Taipei Representative Office in the UK (TRO) | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2014-12-08-80ef1083-10013-0 |
2fcb352ab6b9ea91cd2d937bed948cc146b9978b | Address of donor: 50 Grosvenor Gardens, London SW1W 0EB | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2014-12-08-80ef1083-10013-0 |
7e3c470520d6c11d5f364512d3777af8f58f9da1 | Amount of donation (or estimate of the probable value): the approximate amount includes accommodation £600, food £300 and return flights £2,400; total £3,300 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2014-12-08-80ef1083-10013-0 |
e5be6d0370cdc7b4c64e7bb1aa3e15b256ba45d0 | Destination of visit: Taiwan | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2014-12-08-80ef1083-10013-0 |
1361ec31d90876a8390d706e8298f4cdce9ccfd1 | Date of visit: 26 July-2 August 2014 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2014-12-08-80ef1083-10013-0 |
c22140a606c07f3c501b78203ae5d275c72dc8d5 | Purpose of visit: As part of the British-Taiwanese APPG, to promote the understanding of Taiwan and strengthen UK-Taiwan relations. | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2014-12-08-80ef1083-10013-0 |
2f8dbc974611c77d7d7871a6f297a6c5364ab1c9 | (Registered 5 August 2014) | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2014-12-08-80ef1083-10013-0 |
d30a66eed3b4aa0451b52ef27e9a6e2103786e6a | Name of donor: Tertulias | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2014-12-08-80ef1083-10013-0 |
9b666c8e88a0089c311571f1716354d5cb7ab137 | Address of donor: 48 Desning Hall Cottages, Higham, Suffolk IP28 6PB | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2014-12-08-80ef1083-10013-0 |
42ee7db5dfae6733af9eb2d163fff80e4ade3c1a | Amount of donation (or estimate of the probable value): for me and my wife, flights £490, 2 nights hotel accommodation £500, meals £360 and ground transport £138.20; total £1,488.20 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2014-12-08-80ef1083-10013-0 |
054e2971c55de4467fd62a777a0340e4d14db329 | Destination of visit: Bilbao, Spain | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2014-12-08-80ef1083-10013-0 |
6cd98bf390df1e88f9d4cf2c0b86b96b84471fb6 | Date of visit: 18-19 October 2014 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2014-12-08-80ef1083-10013-0 |
5c953d4babde4b27b348fe8fb58382886a37422c | Purpose of visit: to attend the British-Spanish Tertulias Forum, an annual weekend bringing MPs, business people, academics and artists together to discuss topical issues. | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2014-12-08-80ef1083-10013-0 |
756dbd0fce2c956148295e781a1a6dcfb66b9172 | (Registered 4 November 2014) | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2014-12-08-80ef1083-10013-0 |
3522329f939b028ea12b08412bcbc16114c70d71 | Name of donor: Canada-UK Council | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 21 | 2014-12-08-80ef1083-10013-0 |
061c4004b46a866fe035d3e216f13e1ab84c8604 | Address of donor: 4 The Willows, Wootton, Boars Hill, Oxford OX1 5LD | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 22 | 2014-12-08-80ef1083-10013-0 |
389edd4dffaf766c577c62c2a4da9010c0f262d0 | Amount of donation (or estimate of the probable value): Flights costing £695; hotel accommodation costing £324 and food and ground transport valued at £151; total £1,170 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 23 | 2014-12-08-80ef1083-10013-0 |
fe22327f4899eb5a8c0928d6eeffe4d80ec755cc | Destination of visit: Montebello, Quebec, Canada | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 24 | 2014-12-08-80ef1083-10013-0 |
5ace576efdbc556484dce39293d478656da0b46d | Date of visit: 23-26 November 2014 | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 25 | 2014-12-08-80ef1083-10013-0 |
872f8d52064a71b7a4329fa81175e93c306e1abb | Purpose of visit: to participate in meeting of leading politicians, officials, academics, businessmen, practitioners and members of the media to discuss matters of current public policy concern to each country. | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 26 | 2014-12-08-80ef1083-10013-0 |
e29f6735a8c8af47d679cc64158a35ad0fb44f43 | (Registered 5 December 2014) | Overseas visits 80ef1083 | 2014-12-08 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 27 | 2014-12-08-80ef1083-10013-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");