items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2013-01-18-80ef1083-10013-0" sorted by date
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
e72440e4ffc2f4559c9f84324611ced8d1df08cc | Name of donor: Australia Israel Cultural Exchange | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2013-01-18-80ef1083-10013-0 |
d5b23536467f9ea8494269f32b61dd045defe6eb | Address of donor: Suite 838, St Kilda Road Towers, 1 Queens Road, Melbourne, Victoria 3004, Australia | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2013-01-18-80ef1083-10013-0 |
b9b72e2ec73a9db13e5be2245b4887d8e6c0d5c3 | Amount of donation (or estimate of the probable value): £1,416 comprising £673 for flights; £565 for accommodation and £178 for food, incidentals and other transport | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2013-01-18-80ef1083-10013-0 |
019f992c61dfc61a00ec62527382dc3584b52b35 | Destination of visit: Israel and the Palestinian territories | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2013-01-18-80ef1083-10013-0 |
2cd969e764e59128f935ac0c9148917bb6e9c3e3 | Date of visit: 7-10 January 2012 | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2013-01-18-80ef1083-10013-0 |
dcfeed6e2bc3d3d94dcfb0f87c7783a998929ba8 | Purpose of visit: participation in the Australia Israel UK Leadership Dialogue. | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2013-01-18-80ef1083-10013-0 |
c40fd2ea59eef81617aa1131631ffbcec38f3691 | (Registered 19 January 2012) | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2013-01-18-80ef1083-10013-0 |
b8412ed5975dff9c4721c9323dd5b06532007605 | Name of donor: (1) Easyjet; (2) Electric Infrastucture Security Council | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2013-01-18-80ef1083-10013-0 |
75c57d37197b0fc3329e145086b4a7fb0402841c | 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-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2013-01-18-80ef1083-10013-0 |
6de8bc3328c033561cc20686b0aed32deec78ca1 | 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-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2013-01-18-80ef1083-10013-0 |
014b7da581545f7372b0866e363bbf00b2cff7fa | Destination of visit: Tel Aviv | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2013-01-18-80ef1083-10013-0 |
2fe9aa61404278e424f88bdb659447ce26877942 | Date of visit: 10-12 October 2012 | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2013-01-18-80ef1083-10013-0 |
af1c41049fd9627d34042c4996be4d52594ebd0d | Purpose of visit: Meetings with officials and Ministers of the Israeli government about their electric infrastructure security | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2013-01-18-80ef1083-10013-0 |
081d371935dc31533ece904dc35c46c64bbb0057 | (Registered 29 October 2012; updated 9 November 2012) | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2013-01-18-80ef1083-10013-0 |
3a47dc80e49b266dc018cd543345ccfe5d34def5 | Name of donor: Turkish-British Tatlidil forum | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2013-01-18-80ef1083-10013-0 |
d5d1aee0b1662c7cb9e717d068d63edfa3c6f400 | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2013-01-18-80ef1083-10013-0 |
cef3ae38a6dcc414757c4912803962b76d2f1c2d | Amount of donation (or estimate of the probable value): flights and accommodation with a value of £1,606.36 | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2013-01-18-80ef1083-10013-0 |
0ed540fcf91515f6026efeba4a1a8bd106af4262 | Destination of visit: Istanbul | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2013-01-18-80ef1083-10013-0 |
f66bfeeddccbcba209f2e5cf48b1d36472440202 | Date of visit: 12-14 October 2012 | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2013-01-18-80ef1083-10013-0 |
3ff935bcf0441338ddc46373092408448126f82e | 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-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2013-01-18-80ef1083-10013-0 |
7fa45e2110e51d6ac99816381dac3b56debbf68b | (Registered 6 November 2012) | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2013-01-18-80ef1083-10013-0 |
e519fce951d8836139af19159c96f50ad779bf9f | Name of donor: British-Spanish Tertulias Forum | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 21 | 2013-01-18-80ef1083-10013-0 |
9f4e7a2aac72d90579df26beba4204331543619b | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 22 | 2013-01-18-80ef1083-10013-0 |
aa775214cd229053c8dad3eaf58d35ef677a911d | 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-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 23 | 2013-01-18-80ef1083-10013-0 |
4d99f6e83da90fd27b51d6e7da846977a6758bdd | Destination of visit: Madrid | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 24 | 2013-01-18-80ef1083-10013-0 |
2932bd5e7fa0d17d7067aef117ec25e238a4c0fd | Date of visit: 26-28 October 2012 | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 25 | 2013-01-18-80ef1083-10013-0 |
8660fae5f1c6096d34030f2f72147740d5755ddf | 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-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 26 | 2013-01-18-80ef1083-10013-0 |
0b85c4c75f29474f72794733ed0506aba525e2ef | (Registered 14 November 2012) | Overseas visits 80ef1083 | 2013-01-18 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 27 | 2013-01-18-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");