items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2017-05-02-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 |
|---|---|---|---|---|---|---|---|
| 68a6fe20d6fe17854627bd6cc561e3f9226e617f | 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-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 0 | 2017-05-02-891eb863-24891-0 | |
| 0fc6ff0518ee9f6dbf3504eb92467b1fde45081c | 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-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 1 | 2017-05-02-891eb863-24891-0 | |
| 38595fd2822dae0262073803422f5e069014b67c | 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-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 2 | 2017-05-02-891eb863-24891-0 | |
| 9300727ef432dbf286039b88ae23c042e8e8db96 | 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-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 3 | 2017-05-02-891eb863-24891-0 | |
| 8a1181a5e283ebc6fd426fad3cb8d642070c515c | 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-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 4 | 2017-05-02-891eb863-24891-0 | |
| 4da918613fbe006fec04dd8b28284700b798008f | Name of donor: Indian High Commission/Government of India Address of donor: India House, Aldwych, London WC2B 4NA Estimate of the probable value (or amount of any donation): Flights £2,500; accommodation and hospitality £1,500; total value £4,000 Destination of visit: New Delhi, India Dates of visit: 12-18 February 2017 Purpose of visit: Indo-British APPG familiarisation visit to develop understanding of Indian policy aims and meet key decision makers in government and business. (Registered 07 March 2017) | Visits outside the UK 891eb863 | 2017-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 5 | 2017-05-02-891eb863-24891-0 | |
| 45f9a76a6635ee751d57eaa36ac5483e165e62f3 | Name of donor: (1) Prof. Magdy Ishak (2) Egyptian Ministry of Foreign Affairs Address of donor: (1) private (2) Nile Corniche, Boulaq, Cairo Governorate, Egypt Estimate of the probable value (or amount of any donation): (1) Flights with a value of £1,386 (2) Accommodation, food and transport with a value of £596 Destination of visit: Egypt Dates of visit: 16-20 March 2017 Purpose of visit: Parliamentary fact finding delegation. (Registered 30 March 2017) | Visits outside the UK 891eb863 | 2017-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 6 | 2017-05-02-891eb863-24891-0 | |
| 0834184f5758668dcd34424fc03b56029afed597 | Name of donor: The Shura Council of Saudi Arabia Address of donor: Al Yamamah Palace, Riyadh, Saudi Arabia Estimate of the probable value (or amount of any donation): Flights and accommodation with a value of £6,080; internal transport and hospitality with a value of £642.14; total £6,722.14 Destination of visit: Riyadh, Saudi Arabia Dates of visit: 9-13 April 2017 Purpose of visit: To strengthen British-Saudi Arabia diplomatic relations. (Registered 02 May 2017) | Visits outside the UK 891eb863 | 2017-05-02 | Charlotte Leslie uk.org.publicwhip/person/24891 | 7 | 2017-05-02-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");