items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2017-03-06-891eb863-24891-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| f57c4ef2bce063dcb4ff16d45514bfe649a0ff09 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures. (Registered 14 April 2016) | Visits outside the UK 891eb863 | 2017-03-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 0 | 2017-03-06-891eb863-24891-0 | |
| 46e33cfeefdac5fe4a07d93e9cb2763eea51c73e | Name of donor: The VPRO, Netherlands Address of donor: Villa VPRO, Sumatralaan 49, 1217 GP Hilversum, Netherlands Amount of donation (or estimate of the probable value): flights, accommodation and food with a value of £507.94 Destination of visit: Amsterdam, Netherlands Date of visit: 16-17 April 2016 Purpose of visit: to participate in a discussion on the future of the EU on a Dutch politics show. (Registered 13 May 2016) | Visits outside the UK 891eb863 | 2017-03-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 1 | 2017-03-06-891eb863-24891-0 | |
| 76f331206d6308ec6930ff62d73dbec3c484eebd | Name of donor: Aspen Institute Italia Address of donor: Piazza Navona 114, 00186 Rome, Italy Estimate of the probable value (or amount of any donation): travel, accommodation and hospitality with a value of £660 Destination of visit: Rome, Italy Dates of visit: 11-12 November 2016 Purpose of visit: To give lecture on implications and causes of Brexit for Europeans. (Registered 30 November 2016) | Visits outside the UK 891eb863 | 2017-03-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 2 | 2017-03-06-891eb863-24891-0 | |
| d18560e37276a7eb32cafab985a2310ab9c73993 | Name of donor: Falcon and Associates International Ltd Address of donor: 140 Brompton Road, London SW3 1HY Estimate of the probable value (or amount of any donation): Flights, accommodation and transportation with a value of £4,313 Destination of visit: Dubai Dates of visit: 3-7 November 2016 Purpose of visit: Parliamentary delegation to gain a deeper understanding of the important strategic links between Dubai and the UK. (Registered 01 December 2016) | Visits outside the UK 891eb863 | 2017-03-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 3 | 2017-03-06-891eb863-24891-0 | |
| acdc60dc7e0ca8b4d715ab563ca0d2795277a1a2 | Name of donor: (1) The Great Britain China Centre with sponsorship by Prudential plc; (2) The All China Youth Federation Address of donor: (1) 15 Belgrave Square, London SWIX 8PS; (2) 10, Qianmen Dong Dajie, Beijing, 100051, People’s Republic of China Estimate of the probable value (or amount of any donation): (1) Flights and local transport with a value of £642.50; (2) Flights and local transport £642.50, plus accommodation £889, food and drink £178 and meetings (inc. interpretation, venue hire, equipment) £1,333, total £3,042.50 Destination of visit: China Dates of visit: 5–8 December 2016 Purpose of visit: To attend the 2016 UK-China Young Leaders Roundtable and the UK-China People-to-People Dialogue, building UK-China partnership in youth, reform, innovation and entrepreneurship. (Registered 20 December 2016) | Visits outside the UK 891eb863 | 2017-03-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 4 | 2017-03-06-891eb863-24891-0 | |
| 8aa1ffac254ee0c74a6cbb88e74a25be66607369 | Name of donor: Ministry of Foreign Affairs Address of donor: P.O. Box 547, Government Road, Manama, Kingdom of Bahrain Estimate of the probable value (or amount of any donation): Flights, accommodation, travel and board with a value of £3,250 Destination of visit: Bahrain Dates of visit: 8-12 December 2016 Purpose of visit: Attendance of IISS Manama Dialogue. (Registered 20 December 2016) | Visits outside the UK 891eb863 | 2017-03-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 5 | 2017-03-06-891eb863-24891-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");