items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2023-05-15-891eb863-25375-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 |
|---|---|---|---|---|---|---|---|
| 024b4946fbe56f2c04e37b069dbd5de7ffb52a3c | Name of donor: Results UK Address of donor: 31-33 Bondway, London SW8 1SJ Estimate of the probable value (or amount of any donation): Flights £1046.70; hotel £2,309.22; food, taxis and other costs £329.97; total value £3,685.89 Destination of visit: New York, United States Dates of visit: 16-20 September 2022 Purpose of visit: Delegation to the United Nations General Secretary's Transforming Education Summit. (Registered 28 September 2022) | Visits outside the UK 891eb863 | 2023-05-15 | Imran Hussain uk.org.publicwhip/person/25375 | 0 | 2023-05-15-891eb863-25375-0 | |
| bf4d8285069d50778520ec37a4da703c0bde8a01 | Name of donor: Khubaib Foundation Address of donor: Office 1, 229 Spotland Road, Rochdale OL12 7AG Estimate of the probable value (or amount of any donation): Flights, accommodation and other related additional costs (travel, food, etc.), value £2,450 Destination of visit: Pakistan Dates of visit: 1-6 January 2023 Purpose of visit: To visit Khubaib Foundation orphanages for victims of the recent flooding and to discuss the ongoing humanitarian situation with Pakistani Government officials. (Registered 30 January 2023) | Visits outside the UK 891eb863 | 2023-05-15 | Imran Hussain uk.org.publicwhip/person/25375 | 1 | 2023-05-15-891eb863-25375-0 | |
| 670c3ad6bcca9b041918473920605559ff291fa9 | Name of donor: (1) Majlis Ash-Shura (Parliament) (2) Al-Noor Travels and Tours Ltd Address of donor: (1) AL-Yamamh Palace, Majlis Ash-Shura, 8006, Al-Hada, Unit: 3, Riyadh 12911 - 4021 (2) 66 Killinghall Road, Bradford BD3 8HN Estimate of the probable value (or amount of any donation): (1) Flights, accommodation, internal travel and meals, value £11,750 (2) Accommodation in Madinah between 16 and 20 February 2023, value £515 Destination of visit: Mecca, Madinah and Riyadh Dates of visit: 11-21 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 15 March 2023) | Visits outside the UK 891eb863 | 2023-05-15 | Imran Hussain uk.org.publicwhip/person/25375 | 2 | 2023-05-15-891eb863-25375-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");