items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2017-04-10-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 |
|---|---|---|---|---|---|---|---|
| bda9a9c4a9dc1ed75f407afca0c6c0a7ef0a1f7c | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 0 | 2017-04-10-891eb863-24891-0 | |
| bb46f7eddc332d4a3b3238c1221dab8b91af45d2 | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 1 | 2017-04-10-891eb863-24891-0 | |
| e792497e7a0c32c5e680aa3caca8e6b1ffe5544e | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 2 | 2017-04-10-891eb863-24891-0 | |
| 2dc2d282cc3723a35deee06516660da7a813e289 | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 3 | 2017-04-10-891eb863-24891-0 | |
| f89fe74f2e25507832b0c382fff7a505ce2257ec | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 4 | 2017-04-10-891eb863-24891-0 | |
| e2e63dd62ee2132294395d92bd284cd9a492ae33 | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 5 | 2017-04-10-891eb863-24891-0 | |
| f6310e2042785b06ad56f78a8c839d7840e9b66e | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 6 | 2017-04-10-891eb863-24891-0 | |
| 63c1fbb5ddb7e623c7278e1f54bffa1e77e57a43 | 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-04-10 | Charlotte Leslie uk.org.publicwhip/person/24891 | 7 | 2017-04-10-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");