items

Table actions

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

2 rows where record_id = "2023-06-26-891eb863-25120-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
810438df6fcf007784a282787c75ad1f994744f8 Name of donor: Friedrich-Ebert-Stiftung Address of donor: 44 Charlotte Street, London W1T 2NR Estimate of the probable value (or amount of any donation): Hotel, flights, transfers and meals with a value of £870; translation valued at £435; total value £1,305 Destination of visit: Berlin and Erfurt, Germany Dates of visit: 6-8 July 2022 Purpose of visit: To meet with German politicians, experts, academics, business and civil society to get a sense of the work being done in Germany on regional and structural transformation, and to relate that back to what’s going in the UK. (Registered 13 July 2022) Visits outside the UK 891eb863 2023-06-26   Jon Ashworth uk.org.publicwhip/person/25120 0 2023-06-26-891eb863-25120-0
4da46d3e353b140517c20a35f15d5cc064234cb8 Name of donor: Trades Union Congress Address of donor: Congress House, Great Russell Street, London WC1B 3LS Estimate of the probable value (or amount of any donation): Hotel, flights, transfers and meals with a value of £2,285 Destination of visit: Madrid, Spain Dates of visit: 26-28 October 2022 Purpose of visit: To meet with Spanish trade unions and their members, as well as high-level representatives of the Spanish Government and Congress to see first-hand the work being done on labour reform workers' rights. (Registered 21 November 2022) Visits outside the UK 891eb863 2023-06-26   Jon Ashworth uk.org.publicwhip/person/25120 1 2023-06-26-891eb863-25120-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");