items

Table actions

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

2 rows where record_id = "2023-10-16-891eb863-25810-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
353202c2d0f9e5905c4a30f8bcf5562efafcb40e Name of donor: Falkland Islands Government Address of donor: Falkland Islands Legislative Assembly, Gilbert House, Ross Road, Stanley, Falkland Islands FIQQ 1ZZ Estimate of the probable value (or amount of any donation): Air travel, accommodation and hospitality, total value £3,991.06 Destination of visit: Falkland Islands Dates of visit: 17-25 November 2022 Purpose of visit: Falkland Islands All-Party Parliamentary Group visit as guests of the Falkland Islands Government to mark the 40th anniversary of the liberation of the Falkland Islands. (Registered 19 December 2022) Visits outside the UK 891eb863 2023-10-16   Sarah Atherton uk.org.publicwhip/person/25810 0 2023-10-16-891eb863-25810-0
9877c3004e4bff889bda4dc6f7dd05befb1f2e6e Name of donor: Ministry of Foreign Affairs Taiwan Address of donor: Office of Taiwanese Representative, 50 Grosvenor Gardens, London SW1W 0EB Estimate of the probable value (or amount of any donation): Flights £3,820.90, accommodation and meals £1,328, rail travel £130, minibus travel £147, total value £5,425.90 Destination of visit: Taiwan Dates of visit: 19-24 March 2023 Purpose of visit: British-Taiwan APPG visit to meet ministers and officials to learn about the situation in Taiwan. (Registered 03 April 2023) Visits outside the UK 891eb863 2023-10-16   Sarah Atherton uk.org.publicwhip/person/25810 1 2023-10-16-891eb863-25810-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");