items

Table actions

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

2 rows where record_id = "2023-07-10-891eb863-10182-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
c5e57783aa3f62e325410e3a6b0d4e26817e8813 Name of donor: Sovereign Sustainability and Development Address of donor: 10 Bloomsbury Way, (Office 2.14), Holborn, London WC1A 2SL Estimate of the probable value (or amount of any donation): Travel £537.17; accommodation £624.20; food £80; total value £1,241.37 Destination of visit: Geneva, Switzerland Dates of visit: 31 August - 3 September 2022 Purpose of visit: To attend the Health20 Summit hosted by the G20 Health and Development Partnership at the WHO headquarters, in my role as Global Ambassador. (Registered 20 September 2022) Visits outside the UK 891eb863 2023-07-10   Angela Eagle uk.org.publicwhip/person/10182 0 2023-07-10-891eb863-10182-0
e37e477a19b4473769d90d2d82ee3f5fd41ce5ab Name of donor: Sovereign Sustainability and Development Address of donor: 10 Bloomsbury Way, (Office 2.14), Holborn, London WC1A 2SL Estimate of the probable value (or amount of any donation): Travel (£421.40), accommodation (£524.79) and food (£210.14), total value £1,156.33 Destination of visit: Geneva, Switzerland Dates of visit: 21-23 June 2023 Purpose of visit: To attend the Health20 Summit hosted by the G20 Health and Development Partnership in my role as Global Ambassador. (Registered 10 July 2023) Visits outside the UK 891eb863 2023-07-10   Angela Eagle uk.org.publicwhip/person/10182 1 2023-07-10-891eb863-10182-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");