items

Table actions

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

1 row where record_id = "2020-03-16-891eb863-25380-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
6d5148dd58308bfe14e04f4024319303cf1fc658 Name of donor: British Council Address of donor: 10 Spring Gardens, London SW1A 2BN Estimate of the probable value (or amount of any donation): For myself plus one member of staff, flights £2,900; accommodation £634; transport and internal transfers £792; food (estimated cost) £40; total value £4,366 Destination of visit: Mexico City, Mexico Dates of visit: 17-22 February 2019 Purpose of visit: Meeting with local stakeholders in my capacity as Chair of the Youth Violence Commission to discuss our work on tackling youth violence (organised by the British Council). (Registered 11 March 2019) Visits outside the UK 891eb863 2020-03-16   Vicky Foxcroft uk.org.publicwhip/person/25380 0 2020-03-16-891eb863-25380-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");