items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-10-16-891eb863-24958-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 |
|---|---|---|---|---|---|---|---|
| 59bf18e0c40ce9b3210158175cb6d21ab50cbf47 | Name of donor: The Ministry of Foreign Affairs and International Cooperation of the UAE Address of donor: King Abdullah Bin Abdulaziz Al Saud St, Al Bateen, Abu Dhabi, United Arab Emirates Estimate of the probable value (or amount of any donation): Flights, accommodation, transport and food, value £4,711 Destination of visit: United Arab Emirates Dates of visit: 11-16 February 2023 Purpose of visit: Cross-Party Delegation to the UAE to meet with officials and politicians and discuss UAE-UK bilateral ties/learn more about the region. (Registered 06 March 2023) | Visits outside the UK 891eb863 | 2023-10-16 | Rushanara Ali uk.org.publicwhip/person/24958 | 0 | 2023-10-16-891eb863-24958-0 | |
| 9e7502732ba1b36e5826eb7344d14ba543ba6c38 | Name of donor: Media City Qatar Address of donor: Floor 17 & 18, Tornado Tower, Bldg. 17, Zone 60, Street 810, Corner Majlis Al Taawoon And, Al Funduq St, Doha, Qatar Estimate of the probable value (or amount of any donation): Flights, accommodation, transport and food, total value £7,100 Destination of visit: Doha Dates of visit: 20-26 May 2023 Purpose of visit: To participate at the Bloomberg Qatar Economic Forum 2023 and meet Qatari and international officials to discuss current affairs including regional conflict resolution, labour rights and Qatar-UK bilateral relations. (Registered 06 June 2023) | Visits outside the UK 891eb863 | 2023-10-16 | Rushanara Ali uk.org.publicwhip/person/24958 | 1 | 2023-10-16-891eb863-24958-0 | |
| eda727f14f5466eae70094c5e3b316a69d4a33ee | Name of donor: Siobhan's Trust Address of donor: Birkhill House, Cupar KY15 4QP Estimate of the probable value (or amount of any donation): Accommodation, transport and food, value £606 Destination of visit: Ukraine Dates of visit: 2-7 July 2023 Purpose of visit: Parliamentary delegation to meet with Ukrainian MPs to discuss the support that is needed from the UK and see the support that Siobhan's Trust is providing. (Registered 26 July 2023) | Visits outside the UK 891eb863 | 2023-10-16 | Rushanara Ali uk.org.publicwhip/person/24958 | 2 | 2023-10-16-891eb863-24958-0 | |
| 508014044372bb8ba71ced0dd984a548bdd73190 | Name of donor: The HALO Trust Address of donor: Carronfoot, Thornhill, Dumfries DG3 5BF Estimate of the probable value (or amount of any donation): Flights, Accommodation, transport food and visa, value £2,710.50 Destination of visit: Somaliland and Ethiopia Dates of visit: 6-11 August 2023 Purpose of visit: To see the Halo Trustâs work in removing landmines and unexploded ordnance, and gain a better understanding of the UK's role supporting NGOs like the Halo Trust to deliver greater resilience and recovery from conflict. (Registered 25 August 2023) | Visits outside the UK 891eb863 | 2023-10-16 | Rushanara Ali uk.org.publicwhip/person/24958 | 3 | 2023-10-16-891eb863-24958-0 | |
| 84f819dc293cc8b5dce3951ad99e3ee1aa45ad35 | Name of donor: Inter-Parliamentary Alliance on China (supported by the National Democratic Institute and Open Society foundations) Address of donor: 27 Old Gloucester St, London WC1N 3AX Estimate of the probable value (or amount of any donation): Flights, accommodation, transport and food, value £901 Destination of visit: Prague, Czech Republic Dates of visit: 31 August - 2 September 2023 Purpose of visit: To participate in the Inter-Parliamentary Alliance on China Prague Summit. (Registered 08 September 2023) | Visits outside the UK 891eb863 | 2023-10-16 | Rushanara Ali uk.org.publicwhip/person/24958 | 4 | 2023-10-16-891eb863-24958-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");