items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2017-02-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 |
|---|---|---|---|---|---|---|---|
| dc93faea40a09ee9e1c566aa1049ddbe3dd5a309 | Name of donor: Bahrain Ministry of Foreign Affairs Address of donor: P.O. Box 547, Government Road, Manama, Kingdom of Bahrain Amount of donation: Flights, accommodation and transport to a value of £4,753.26 Destination of visit: Bahrain Date of visit: 21-25 January 2016 Purpose of visit: Conservative Middle East Council fact finding delegation (Registered 03 February 2016) | Visits outside the UK 891eb863 | 2017-02-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 0 | 2017-02-06-891eb863-24891-0 | |
| 3f6c4d9a4efcdb64c75d8c0e0ba952275f737a5b | 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-02-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 1 | 2017-02-06-891eb863-24891-0 | |
| 7742d015fcffc1cb18eab8e4890410921e45c09a | 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-02-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 2 | 2017-02-06-891eb863-24891-0 | |
| c41ebda775619313ec52567cec7a048452b86835 | 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-02-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 3 | 2017-02-06-891eb863-24891-0 | |
| 78fc9c77389660aaf7989ff8a91a4a46d39e8388 | 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-02-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 4 | 2017-02-06-891eb863-24891-0 | |
| d1286713ba71db2fcb31d4cd2b2d4b01d3416219 | 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-02-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 5 | 2017-02-06-891eb863-24891-0 | |
| b49b042ddd5badd6657b1024844d4a7c66036fcc | 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-02-06 | Charlotte Leslie uk.org.publicwhip/person/24891 | 6 | 2017-02-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");