items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2023-08-07-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 |
|---|---|---|---|---|---|---|---|
| aa2681329f7eaf799f7f92e51154b0eade4cd0ef | 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-08-07 | Rushanara Ali uk.org.publicwhip/person/24958 | 0 | 2023-08-07-891eb863-24958-0 | |
| 76affc9f3334978d83a21234564608fb86f30636 | 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-08-07 | Rushanara Ali uk.org.publicwhip/person/24958 | 1 | 2023-08-07-891eb863-24958-0 | |
| c32793568c874fd31e9809af65e2531501c16e08 | 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-08-07 | Rushanara Ali uk.org.publicwhip/person/24958 | 2 | 2023-08-07-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");