items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-09-04-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 |
|---|---|---|---|---|---|---|---|
| 863fcfb79fbcf19773efa7315a4e5ca833f3ee4b | 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-04 | Rushanara Ali uk.org.publicwhip/person/24958 | 0 | 2023-09-04-891eb863-24958-0 | |
| 004917cff3bb3222e8ccafd4fecff595d7254ea8 | 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-04 | Rushanara Ali uk.org.publicwhip/person/24958 | 1 | 2023-09-04-891eb863-24958-0 | |
| 5426dcb212764b722caeb4478cbe8238ac374a44 | 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-04 | Rushanara Ali uk.org.publicwhip/person/24958 | 2 | 2023-09-04-891eb863-24958-0 | |
| f8122d166d5762201424871cfc8e9454e7ef4cfe | 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-04 | Rushanara Ali uk.org.publicwhip/person/24958 | 3 | 2023-09-04-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");