items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2013-02-04-80ef1083-10013-0" sorted by category_id descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▲ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
1d4e76b1dee88091f1b755379b84839272b75940 | Name of donor: Australia Israel Cultural Exchange | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2013-02-04-80ef1083-10013-0 |
ffd6e1fe4f7b5923e38e5f2812134fccb3efd62e | Address of donor: Suite 838, St Kilda Road Towers, 1 Queens Road, Melbourne, Victoria 3004, Australia | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2013-02-04-80ef1083-10013-0 |
d18cc2f276778c5ebae2afd8cbf45ea857dafd20 | 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-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2013-02-04-80ef1083-10013-0 |
09316d3167cc24f8acc42cffee13502a2d07ee0e | Destination of visit: Israel and the Palestinian territories | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2013-02-04-80ef1083-10013-0 |
7aa94cc2c800ab3885c36b357977a5ee3c7a94e3 | Date of visit: 7-10 January 2012 | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2013-02-04-80ef1083-10013-0 |
35a25fd80457f63ec777591778b032da22218c7f | Purpose of visit: participation in the Australia Israel UK Leadership Dialogue. | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2013-02-04-80ef1083-10013-0 |
2957e8dae46d3e9a0bb80a68ea66dddd3497f7d4 | (Registered 19 January 2012) | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2013-02-04-80ef1083-10013-0 |
0d7b7d5f6829fc5f1c73474dc75c83e84d15f5c7 | Name of donor: (1) Easyjet; (2) Electric Infrastucture Security Council | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2013-02-04-80ef1083-10013-0 |
081052afbde61f78f1dc2590e206171d32bc1a27 | 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-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2013-02-04-80ef1083-10013-0 |
bddd6dc1e8c3de52c14f646537a09c7ac2bdc4dc | 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-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2013-02-04-80ef1083-10013-0 |
d38208226567ed815dd1a3e1a00f6785dc4dfc0b | Destination of visit: Tel Aviv | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2013-02-04-80ef1083-10013-0 |
b49134be30d5dd64700493cff5c43383cf42bce6 | Date of visit: 10-12 October 2012 | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2013-02-04-80ef1083-10013-0 |
49176b8bba8229c449ac9d73408095a6bd5393ba | Purpose of visit: Meetings with officials and Ministers of the Israeli government about their electric infrastructure security | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2013-02-04-80ef1083-10013-0 |
44776a1f7bbb4f5b581f2a8508466761a29df673 | (Registered 29 October 2012; updated 9 November 2012) | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2013-02-04-80ef1083-10013-0 |
7b16524299a5f07b1e707401da0bd6f456e078a8 | Name of donor: Turkish-British Tatlidil forum | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2013-02-04-80ef1083-10013-0 |
1b106895ff012c65642e0491283ab7918e7dfeff | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2013-02-04-80ef1083-10013-0 |
7100ec2e0dde5959002047354422b377f607f2c5 | Amount of donation (or estimate of the probable value): flights and accommodation with a value of £1,606.36 | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2013-02-04-80ef1083-10013-0 |
55fe3d3dfb1ec4c86f9a9ab064b2b9ddb5f3c833 | Destination of visit: Istanbul | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2013-02-04-80ef1083-10013-0 |
1759fa61fce1869c2bb0482f7e7b11081b6dadb7 | Date of visit: 12-14 October 2012 | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2013-02-04-80ef1083-10013-0 |
290db2bda4839d1e70a36ff065cb78419a94ecdf | 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-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2013-02-04-80ef1083-10013-0 |
b7d24b0168e99ed7ec490ecf6b06262cc0d98bf2 | (Registered 6 November 2012) | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2013-02-04-80ef1083-10013-0 |
a198d5fa4e1bc48e8b0d5a132edd0b1078b2ef8b | Name of donor: British-Spanish Tertulias Forum | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 21 | 2013-02-04-80ef1083-10013-0 |
25a20a85c9c9e81fbf9953b04774ae1144859315 | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 22 | 2013-02-04-80ef1083-10013-0 |
308276f19797984a1af6adf196b811969fa710a3 | 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-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 23 | 2013-02-04-80ef1083-10013-0 |
388729bf061af37db63a803740ff97567934e335 | Destination of visit: Madrid | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 24 | 2013-02-04-80ef1083-10013-0 |
a7a58debcb071e149cb0475b4776b1c408a461ea | Date of visit: 26-28 October 2012 | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 25 | 2013-02-04-80ef1083-10013-0 |
0c52400930ddcf6e217784508071ecd49106eb14 | 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-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 26 | 2013-02-04-80ef1083-10013-0 |
9a2d0ad9d9c85ea74b5e97a8e3eca961e2d83c25 | (Registered 14 November 2012) | Overseas visits 80ef1083 | 2013-02-04 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 27 | 2013-02-04-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");