items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-09-18-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 |
|---|---|---|---|---|---|---|---|
| c30f13bfbe9f1074903e051e0be99862445caf6d | 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-09-18 | Rushanara Ali uk.org.publicwhip/person/24958 | 0 | 2023-09-18-891eb863-24958-0 | |
| 694d57f201df2e127c54291b356da40118e5c07e | 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-09-18 | Rushanara Ali uk.org.publicwhip/person/24958 | 1 | 2023-09-18-891eb863-24958-0 | |
| b9b619f73f30544a89b3ffa11379efba1591227d | 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-09-18 | Rushanara Ali uk.org.publicwhip/person/24958 | 2 | 2023-09-18-891eb863-24958-0 | |
| 029decbfcf60b480f84cb152bb71ad0bda0193a3 | 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-09-18 | Rushanara Ali uk.org.publicwhip/person/24958 | 3 | 2023-09-18-891eb863-24958-0 | |
| 186e55e4c6e938b5b5b230ff031841b0e863dec5 | 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-09-18 | Rushanara Ali uk.org.publicwhip/person/24958 | 4 | 2023-09-18-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");