items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2023-10-16-891eb863-25888-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 |
|---|---|---|---|---|---|---|---|
| 8272dbfae8a38cf05793968af95bd377a05c2718 | 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, value £11,750 Destination of visit: Mecca, Madinah and Riyadh Dates of visit: 11-20 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. Plus meetings with the Deputy Minister for Madinah and holy sites stakeholders. (Registered 14 March 2023) | Visits outside the UK 891eb863 | 2023-10-16 | Tahir Ali uk.org.publicwhip/person/25888 | 0 | 2023-10-16-891eb863-25888-0 | |
| a55a35e8bf3bdba65d59d51051d556d200830da0 | Name of donor: Government of Pakistan, Speaker's Office Address of donor: Constitution Avenue, G5/2 Islamabad, Pakistan Estimate of the probable value (or amount of any donation): Flights, accommodation, internal travel and meals, total value £1,800 Destination of visit: Islamabad Dates of visit: 6-13 May 2023 Purpose of visit: Pakistan 1973 Constitution Golden Jubilee Celebrations. (Registered 05 June 2023) | Visits outside the UK 891eb863 | 2023-10-16 | Tahir Ali uk.org.publicwhip/person/25888 | 1 | 2023-10-16-891eb863-25888-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");