items

Table actions

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

3 rows where record_id = "2019-06-17-5f2cbd10-10355-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
dd64bc0f9f6a9e5532f6b7e0743cdde44a9c8126 From February 2017, Vice President of the Great Britain China Centre; a body funded by the FCO to promote relationships between the UK and the Communist Party of China. This role is unpaid but from time to time will involve travel to Beijing at the expense of the Centre. (Registered 13 February 2017) Miscellaneous 5f2cbd10 2019-06-17   Oliver Letwin uk.org.publicwhip/person/10355 0 2019-06-17-5f2cbd10-10355-0
b0e4b7e71080a9b3ab7f260f976fbb34f1edbf3f From 19 April 2017, Chair (unpaid) of the Management Board of the Red Tape Initiative; a cross-party think tank established to identify regulatory changes that can be made by political consensus speedily after Brexit. (Registered 19 April 2017) Miscellaneous 5f2cbd10 2019-06-17   Oliver Letwin uk.org.publicwhip/person/10355 1 2019-06-17-5f2cbd10-10355-0
ac8e249a1b8ab4011cc4fff76ea8e4c9228f9e47 From 31 October 2018, member (unpaid) of the Advisory Council of the Bennett Institute for Public Policy at the University of Cambridge, which aims to deepen understanding of some of the most pressing challenges of our turbulent times, and to identify and explore sustainable solutions to them. (Registered 23 October 2018) Miscellaneous 5f2cbd10 2019-06-17   Oliver Letwin uk.org.publicwhip/person/10355 2 2019-06-17-5f2cbd10-10355-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");