items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2023-10-30-891eb863-24920-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 |
|---|---|---|---|---|---|---|---|
| 9a370f90d66e1d5f22eb7c63571235e4b92c4b85 | Name of donor: Majlis Ash-Shura (Parliament) Address of donor: AL-Yamamh Palace, Majlis Ash-Shura, 8006, Al-Hada, Unit: 3, Riyadh 12911 - 4021, Kingdom of Saudi Arabia Estimate of the probable value (or amount of any donation): Flights, accommodation, internal travel and meals, total value £11,000 Destination of visit: Mecca, Madinah and Riyadh Dates of visit: 12-16 February 2023 Purpose of visit: APPG for Hajj and Umrah visit to meet with the Ministry of Hajj and Umrah to discuss challenges specific to British Muslims, and the UK Mission in Riyadh, Ambassador and UK Consul General covering Mecca and Madinah. (Registered 14 March 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Rehman Chishti uk.org.publicwhip/person/24920 | 0 | 2023-10-30-891eb863-24920-0 | |
| 707b7d508dca8783da2c85e9ef691478b44c406d | Name of donor: Muslim World League Address of donor: PO Box, 537, Mecca 21955, Kingdom of Saudi Arabia Estimate of the probable value (or amount of any donation): Flights, accommodation, internal travel and meals, total value £12,280 Destination of visit: New York City, USA Dates of visit: 13-18 June 2023 Purpose of visit: Invited to speak at an event at the UN, at a Conference hosted by the Muslim World League with faith leaders, Representatives from the UN, Academia, USA Government, NGOS, Civil Society. (Registered 10 July 2023) | Visits outside the UK 891eb863 | 2023-10-30 | Rehman Chishti uk.org.publicwhip/person/24920 | 1 | 2023-10-30-891eb863-24920-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");