items

Table actions

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

2 rows where record_id = "2023-07-10-891eb863-24873-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
5087d6dc49a415ec18e115910e573626748bd0b5 Name of donor: Jamaica Tourist Board Address of donor: 1-2 Prince Consort Rd, London SW7 2BZ Estimate of the probable value (or amount of any donation): Air travel and accommodation for two people, value £3,950 Destination of visit: Kingston and St Elizabeth Parish, Jamaica Dates of visit: 1-8 August 2022 Purpose of visit: Lords and Commons Cricket delegation for the 60th Anniversary of Jamaican Independence, including UK High Commission event with ministers and parliamentarians and presenting a donation to the BREDS Cricket Academy. (Registered 31 August 2022) Visits outside the UK 891eb863 2023-07-10   Caroline Dinenage uk.org.publicwhip/person/24873 0 2023-07-10-891eb863-24873-0
0bbe47568dd1e4235fb0c7baa50b3aa5f8143921 Name of donor: Coalition for Global Prosperity Address of donor: 1 Horse Guards Ave, London SW1A 2HU Estimate of the probable value (or amount of any donation): Air Travel, transport, hotel, food and subsistence together with malarial tablets and medical, value £3,199.88 Destination of visit: Sierra Leone Dates of visit: 21-25 March 2023 Purpose of visit: To mark International Women’s Month to help improve outcomes for women during childbirth, and meet with the Minister for Education, the Sierra Leone Vice President and the UK’s High Commissioner to the country. (Registered 13 April 2023) Visits outside the UK 891eb863 2023-07-10   Caroline Dinenage uk.org.publicwhip/person/24873 1 2023-07-10-891eb863-24873-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");