items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2017-01-09-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 |
|---|---|---|---|---|---|---|---|
| 1bbce8795a54f1358a18cb92f2ebec482d4b9bf7 | Name of donor: (1) Shafik Gabr Foundation (2) Egypt Foreign Ministry Address of donor: (1) c/o 7, Hassan Al-Akbar Street, Mokattam, Cairo, Egypt 11571 (2) Nile Corniche, Boulaq, Cairo Governorate, Egypt Amount of donation (or estimate of the probable value): (1) Flights £1,836 (2) Accommodation, food and transport £850 Destination: Egypt Date of visit: 14-18 January 2016 Purpose of visit: Parliamentary fact finding delegation (Registered 28 January 2016) | Visits outside the UK 891eb863 | 2017-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 0 | 2017-01-09-891eb863-24891-0 | |
| d256157e01b4b9101b603022b3cffe216f6c701c | 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-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 1 | 2017-01-09-891eb863-24891-0 | |
| a241e473aae631bdbd1142b1567ccabed3b15eac | 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-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 2 | 2017-01-09-891eb863-24891-0 | |
| 3c5efab781817d8de55f9c8bf0ccc2642f411ff0 | 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-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 3 | 2017-01-09-891eb863-24891-0 | |
| 3feacdf54f4494399e885d053590b052b287df7a | 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-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 4 | 2017-01-09-891eb863-24891-0 | |
| 308eb4e3f581dc1d69bedcf7a060945adcb1d147 | 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-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 5 | 2017-01-09-891eb863-24891-0 | |
| 9aaad1b4ad168dff603a1b1d97b68d7ebb98e48d | 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-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 6 | 2017-01-09-891eb863-24891-0 | |
| 53f8598e061b05734cd2b37444b3f93c22201222 | 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-01-09 | Charlotte Leslie uk.org.publicwhip/person/24891 | 7 | 2017-01-09-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");