items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2013-11-25-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 |
---|---|---|---|---|---|---|---|
b31ce07200bc259fcf0ab82524d3b1bfe7beb52a | Name of donor: (1) Easyjet; (2) Electric Infrastucture Security Council | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2013-11-25-80ef1083-10013-0 |
11062139da0112462e196d90720cc5acc4d50a0e | Address of donor: (1) Hangar 89, London Luton Airport, LU2 9PF; (2) 13400 Washington Boulevard, Suite 206 Marina Del Rey, CA 90292 USA | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2013-11-25-80ef1083-10013-0 |
02cdd5d2a346cacc8855f3093f3c06aba794ae7f | Amount of donation (or estimate of the probable value): (1) Flight from Luton to Tel Aviv with a value of £250; (2) hotel costs, internal flights and other transport with a total value of £591.46 | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2013-11-25-80ef1083-10013-0 |
cf565a7a7f00af4f8581767d84e4ab5632dddace | Destination of visit: Tel Aviv | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2013-11-25-80ef1083-10013-0 |
f70776b9512b24a5f85f809c529beecc13151c81 | Date of visit: 10-12 October 2012 | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2013-11-25-80ef1083-10013-0 |
5c0185bdaf0dcecccc670b613498de032edd0c2f | Purpose of visit: Meetings with officials and Ministers of the Israeli government about their electric infrastructure security | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2013-11-25-80ef1083-10013-0 |
ddb256cc24cb1558a7cabb3c2b03b380fb07986a | (Registered 29 October 2012; updated 9 November 2012) | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2013-11-25-80ef1083-10013-0 |
d20e5c98cdbdf8a23c6e51c176aa389d30375fa5 | Name of donor: Turkish-British Tatlidil forum | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2013-11-25-80ef1083-10013-0 |
972165a86bcafd4a85865da044de1cf61dfd7dee | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2013-11-25-80ef1083-10013-0 |
125b5779f462026883efce6b434904f1dcbcc431 | Amount of donation (or estimate of the probable value): flights and accommodation with a value of £1,606.36 | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2013-11-25-80ef1083-10013-0 |
9572b1cc3eb5005523763edb955801a6b52cf1aa | Destination of visit: Istanbul | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2013-11-25-80ef1083-10013-0 |
1d184e01768b73ef5dc32296794364600e94f0ec | Date of visit: 12-14 October 2012 | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2013-11-25-80ef1083-10013-0 |
1ebf0485c7b0d48b90ce3b4eb95cefdbb8dbaab3 | Purpose of visit: to attend the Tatlidil Forum, an annual event which brings together MPs, business people academics and artists to discuss topical issues. | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2013-11-25-80ef1083-10013-0 |
4b002c14612c194772af75220f8f70c5218affe4 | (Registered 6 November 2012) | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2013-11-25-80ef1083-10013-0 |
6965b4d3d1f3e7d00459bf2f47aca2e80b5e9629 | Name of donor: British-Spanish Tertulias Forum | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2013-11-25-80ef1083-10013-0 |
47c8bbda0cabe9bac13b4d734d6317d465459aeb | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2013-11-25-80ef1083-10013-0 |
44e0a5df163b66b18a3496567d7b24d2c90ba5d7 | Amount of donation (or estimate of the probable value): Flights, accommodation and ground transport with a total value of £1,040 | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2013-11-25-80ef1083-10013-0 |
3a85349fdaf2accff34112cff079b2629909186a | Destination of visit: Madrid | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2013-11-25-80ef1083-10013-0 |
80447e89770f0f1cc0441074dc5e96acb0df114e | Date of visit: 26-28 October 2012 | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2013-11-25-80ef1083-10013-0 |
cc67cae6efa57e644cde6e1ac194dab74363ec91 | 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 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2013-11-25-80ef1083-10013-0 |
6520d1d2204ac53ed0cd1aeb3418eac2be34cd84 | (Registered 14 November 2012) | Overseas visits 80ef1083 | 2013-11-25 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2013-11-25-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");