items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2013-06-24-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 |
---|---|---|---|---|---|---|---|
d7bf149e1e7978896f536d431a478117f24d2acb | Name of donor: (1) Easyjet; (2) Electric Infrastucture Security Council | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2013-06-24-80ef1083-10013-0 |
de8db8224d67ea40d5abb3949f127d23665569a8 | 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-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2013-06-24-80ef1083-10013-0 |
ede06a3f87e248e0507d2fc00bb76c4bd1475981 | 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-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2013-06-24-80ef1083-10013-0 |
47e830ec314aa72af71309f0dfe3428a99b82627 | Destination of visit: Tel Aviv | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2013-06-24-80ef1083-10013-0 |
3982cf08f61a68738b1d55ed1e8d3183eeed1977 | Date of visit: 10-12 October 2012 | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2013-06-24-80ef1083-10013-0 |
f8e64fadc4c3174977e1b12924649057ee53acb5 | Purpose of visit: Meetings with officials and Ministers of the Israeli government about their electric infrastructure security | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2013-06-24-80ef1083-10013-0 |
0c3fd50feb9a4b1b086d544ad84a7e3918133dca | (Registered 29 October 2012; updated 9 November 2012) | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2013-06-24-80ef1083-10013-0 |
019b1af03f3e4f9b6e4342fadebdbb0b283e186a | Name of donor: Turkish-British Tatlidil forum | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2013-06-24-80ef1083-10013-0 |
1e5e3693c8897ce9e59226b923303e3d53ce6278 | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2013-06-24-80ef1083-10013-0 |
c13d2a6c64585869973feb1a334f07115c405e82 | Amount of donation (or estimate of the probable value): flights and accommodation with a value of £1,606.36 | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2013-06-24-80ef1083-10013-0 |
3dce41e4adf578f921b57747c18ad6d208bc43f9 | Destination of visit: Istanbul | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2013-06-24-80ef1083-10013-0 |
184a37efcbc09710bf4796b4d6a131628f8fa8dd | Date of visit: 12-14 October 2012 | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2013-06-24-80ef1083-10013-0 |
33821436c2e1b78cbb627c8524ba456e40ec11e0 | 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-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2013-06-24-80ef1083-10013-0 |
f4c9bf57fbb884d1e18a70295e911ea2daeea4d1 | (Registered 6 November 2012) | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2013-06-24-80ef1083-10013-0 |
c416802d4dae162ee6beae856c8ac1931ec743a0 | Name of donor: British-Spanish Tertulias Forum | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2013-06-24-80ef1083-10013-0 |
25f0e48bd7d960107364f8b0ab727a71429d83fa | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2013-06-24-80ef1083-10013-0 |
2bcd04ab92b077c8be9b3b9836d4daf59c9e697b | 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-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2013-06-24-80ef1083-10013-0 |
720531844c7bb01353536e84cbd41d7c3730936a | Destination of visit: Madrid | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2013-06-24-80ef1083-10013-0 |
7f8e3e028f0fe2f1535ee44629a6132e630e72f9 | Date of visit: 26-28 October 2012 | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2013-06-24-80ef1083-10013-0 |
a954e3d1a838f84af79695f067d810e3671525ea | 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-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2013-06-24-80ef1083-10013-0 |
c3adf35cbc84a6e9eb3f33b5df13acc57e73f5fd | (Registered 14 November 2012) | Overseas visits 80ef1083 | 2013-06-24 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2013-06-24-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");