items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2012-12-03-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 |
---|---|---|---|---|---|---|---|
62180f03bdc20af0f2aaea5a84d72eff0265a149 | Name of donor: Australia Israel Cultural Exchange | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2012-12-03-80ef1083-10013-0 |
95bbb5491f14373627add22800d10bf3ca2f1599 | Address of donor: Suite 838, St Kilda Road Towers, 1 Queens Road, Melbourne, Victoria 3004, Australia | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2012-12-03-80ef1083-10013-0 |
692eabac9b53b9e343bb4d469888603fa3cc6989 | 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 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2012-12-03-80ef1083-10013-0 |
64ef3c49859411790c07d353e540eb783e2d3402 | Destination of visit: Israel and the Palestinian territories | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2012-12-03-80ef1083-10013-0 |
01ef60d19c623c1d3edeca479f494139405ad7b0 | Date of visit: 7-10 January 2012 | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2012-12-03-80ef1083-10013-0 |
38bfce83cc49de4a25b0586829567d75e1bd854d | Purpose of visit: participation in the Australia Israel UK Leadership Dialogue. | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2012-12-03-80ef1083-10013-0 |
81e482ac086a269f94be06c0fe91477e2180ca5f | (Registered 19 January 2012) | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2012-12-03-80ef1083-10013-0 |
3c78523a42e5b6da0d4e711aedea9123de664777 | Name of donor: (1) Easyjet; (2) Electric Infrastucture Security Council | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 7 | 2012-12-03-80ef1083-10013-0 |
13e3aae2cdd1529adaecf3d27e540e771a11d3d0 | 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 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 8 | 2012-12-03-80ef1083-10013-0 |
2fe3cde65e14f13381cc34e7c5b4c27e627b5d1f | 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 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 9 | 2012-12-03-80ef1083-10013-0 |
9f44b5eda6ab48d57c4bdd5542913564e6b21e84 | Destination of visit: Tel Aviv | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 10 | 2012-12-03-80ef1083-10013-0 |
5ef36b87985ee7245b5180b4d74e3f02227fadc5 | Date of visit: 10-12 October 2012 | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 11 | 2012-12-03-80ef1083-10013-0 |
598c321c49ae2d8d1652e835cce72dc29fbf5c4c | Purpose of visit: Meetings with officials and Ministers of the Israeli government about their electric infrastructure security | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 12 | 2012-12-03-80ef1083-10013-0 |
5f664671987165efe6a0628ea19997d133431dd0 | (Registered 29 October 2012; updated 9 November 2012) | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 13 | 2012-12-03-80ef1083-10013-0 |
75eb37688074dd66c282f892f3311d992b882ce8 | Name of donor: Turkish-British Tatlidil forum | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 14 | 2012-12-03-80ef1083-10013-0 |
b7cde9c56c7a076cc293ca0702fe40a72a89915e | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 15 | 2012-12-03-80ef1083-10013-0 |
0e07405bf326a0b59ad157ed66268c8cb12fc53d | Amount of donation (or estimate of the probable value): flights and accommodation with a value of £1,606.36 | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 16 | 2012-12-03-80ef1083-10013-0 |
e970a12fa7ece9b9909c842bfbaadaf440562b6f | Destination of visit: Istanbul | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 17 | 2012-12-03-80ef1083-10013-0 |
6230d648630322498f1784422579f37e7d67c68a | Date of visit: 12-14 October 2012 | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 18 | 2012-12-03-80ef1083-10013-0 |
ea002b42b21699dd897767693ccda908b1b2c5d6 | 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 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 19 | 2012-12-03-80ef1083-10013-0 |
5989bb8fedd279a466b4ca089712e596b8cb76f0 | (Registered 6 November 2012) | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 20 | 2012-12-03-80ef1083-10013-0 |
8ba2153246cee3b6ab9192e9bb57eb8f62644385 | Name of donor: British-Spanish Tertulias Forum | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 21 | 2012-12-03-80ef1083-10013-0 |
ce392072fd041c7b417f0a491d81478acc1ea7d8 | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 22 | 2012-12-03-80ef1083-10013-0 |
e804199cded5609e590912d75e94ee75d0ef8add | Amount of donation (or estimate of the probable value): Flights, accommodation and ground transport with a total value of £1,040 | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 23 | 2012-12-03-80ef1083-10013-0 |
e80c0c81f0f5a4d07435699562d6a0281caf5388 | Destination of visit: Madrid | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 24 | 2012-12-03-80ef1083-10013-0 |
2712ebd724044c15a19b517f9ab65b543b7a7786 | Date of visit: 26-28 October 2012 | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 25 | 2012-12-03-80ef1083-10013-0 |
285c458560cc719082ecc0b7d5a71758e1c405d4 | 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 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 26 | 2012-12-03-80ef1083-10013-0 |
d2a7c06aafdc12008d71df4fdbd46126c2f0c02b | (Registered 14 November 2012) | Overseas visits 80ef1083 | 2012-12-03 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 27 | 2012-12-03-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");