items

Table actions

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

2 rows where record_id = "2023-05-15-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
bd6494125acf1e4bce4bbfb4dfa73bf56c1c25f8 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-05-15   Jon Ashworth uk.org.publicwhip/person/25120 0 2023-05-15-891eb863-25120-0
31aeaab70af7cbce79a925b1a67bfcdbe4056c2e 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-05-15   Jon Ashworth uk.org.publicwhip/person/25120 1 2023-05-15-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");