items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2023-07-10-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 |
|---|---|---|---|---|---|---|---|
| ac1957f8b37ddd2c14ea1ddafec275b704338d2b | Name of donor: Franco-British Colloque Address of donor: 86 East Lane, West Horsley, Leatherhead KT24 6LQ Estimate of the probable value (or amount of any donation): Food and accommodation while attending the Franco-British Colloque 2022, total value £1,054 Destination of visit: Versailles, France Dates of visit: 30 June - 2 July 2022 Purpose of visit: To attend the Franco-British Colloque 2022. (Registered 05 July 2022) | Visits outside the UK 891eb863 | 2023-07-10 | Rushanara Ali uk.org.publicwhip/person/24958 | 0 | 2023-07-10-891eb863-24958-0 | |
| ce0b3da1f62c302b93e243de1954816ca3152945 | 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-07-10 | Rushanara Ali uk.org.publicwhip/person/24958 | 1 | 2023-07-10-891eb863-24958-0 | |
| 25fba808f962f11e2f19d2138a7b247a28cb0d83 | 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-07-10 | Rushanara Ali uk.org.publicwhip/person/24958 | 2 | 2023-07-10-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");