items

Table actions

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

3 rows where record_id = "2019-08-12-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
04c089044a0adca55f5cc7216e58843b474452d7 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-08-12   Oliver Letwin uk.org.publicwhip/person/10355 0 2019-08-12-5f2cbd10-10355-0
baaebc8b3690e98b6bee80a0783fa926a379845d 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-08-12   Oliver Letwin uk.org.publicwhip/person/10355 1 2019-08-12-5f2cbd10-10355-0
c3d2f009ab5c2d14c413716e9df48d5c275e1424 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-08-12   Oliver Letwin uk.org.publicwhip/person/10355 2 2019-08-12-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");