items

Table actions

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

1 row where record_id = "2023-05-30-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
d72c091d760a87b56912849796c46e1fce5a8b90 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-05-30   Tahir Ali uk.org.publicwhip/person/25888 0 2023-05-30-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");