items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

2 rows where record_id = "2023-09-18-891eb863-25888-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
58446937bbc945734c807d1e5ef013e4276818c5 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-09-18   Tahir Ali uk.org.publicwhip/person/25888 0 2023-09-18-891eb863-25888-0
3dd4a825876546a8500887e51bbb1da214465399 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-09-18   Tahir Ali uk.org.publicwhip/person/25888 1 2023-09-18-891eb863-25888-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");