items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2013-07-29-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 |
---|---|---|---|---|---|---|---|
292b422db548009d0ea7c3d7d9003e61c503c59b | Name of donor: (1) Easyjet; (2) Electric Infrastucture Security Council | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2013-07-29-80ef1083-10013-0 |
1ae2b98c3d9da1ad33665d8f52febf464687c358 | 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-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2013-07-29-80ef1083-10013-0 |
7f1f7cf85fa5680516e501fd2a124d94f443adf8 | 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-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2013-07-29-80ef1083-10013-0 |
08a40d72dc9d57e5640cec7ccf9013fa09aa5118 | Destination of visit: Tel Aviv | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2013-07-29-80ef1083-10013-0 |
778701dcf1a34954bbe0931cca4fe60c0bf81e6d | Date of visit: 10-12 October 2012 | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2013-07-29-80ef1083-10013-0 |
c3de911ea58e172f83e6c7a2ec23d43931195b57 | Purpose of visit: Meetings with officials and Ministers of the Israeli government about their electric infrastructure security | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2013-07-29-80ef1083-10013-0 |
37061960451f8037a1baee5397a7789d3e0cc7ea | (Registered 29 October 2012; updated 9 November 2012) | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2013-07-29-80ef1083-10013-0 |
a08a3fa0c9f93f74ddc363f25fa872e7e45ffa34 | Name of donor: Turkish-British Tatlidil forum | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2013-07-29-80ef1083-10013-0 |
18ffee8d5177c7a3f8eab4b9b6fb9ec941fa033d | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2013-07-29-80ef1083-10013-0 |
beabea3f007d2f8fcdb24533a954ae253b2caeb5 | Amount of donation (or estimate of the probable value): flights and accommodation with a value of £1,606.36 | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2013-07-29-80ef1083-10013-0 |
c58ca3cb17a6daffe11b8ceeb71d48565be1c7f8 | Destination of visit: Istanbul | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2013-07-29-80ef1083-10013-0 |
09db31f2868983407b8b6603b9a236d7f607c965 | Date of visit: 12-14 October 2012 | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2013-07-29-80ef1083-10013-0 |
e05ff6f04af85a6b21d86802f76d4f8e93e29163 | 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-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2013-07-29-80ef1083-10013-0 |
3d7b60b9dbd0082dd8ae99e2a0423de6d420d7df | (Registered 6 November 2012) | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2013-07-29-80ef1083-10013-0 |
bc903c8d32ad1be0acfda8e8757740e2342aeafb | Name of donor: British-Spanish Tertulias Forum | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2013-07-29-80ef1083-10013-0 |
94a26b5a2eff29572357ca77618b896907257f4c | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2013-07-29-80ef1083-10013-0 |
abb15924921eeb04f98e15a44e3c9f08313821a3 | 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-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2013-07-29-80ef1083-10013-0 |
e0c5fa969c658c441e34861a76c9476b6a2c49b7 | Destination of visit: Madrid | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2013-07-29-80ef1083-10013-0 |
675ac9d3259d14963e4cf9e73e3a4716c06f47bd | Date of visit: 26-28 October 2012 | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2013-07-29-80ef1083-10013-0 |
67d4016c88baf4847b60851eb9ce6a8f4788440e | 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-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2013-07-29-80ef1083-10013-0 |
a5ddac3251fe2b6e3831d82390a568b66a78f2f1 | (Registered 14 November 2012) | Overseas visits 80ef1083 | 2013-07-29 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2013-07-29-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");