items

Table actions

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

3 rows where record_id = "2002-11-26-0a4a155f-10637-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
7ac4e3f6b8628a7daf92e93200e3e6b31d28b1f1 Author. Remunerated employment, office, profession etc. 0a4a155f 2002-11-26 David Willetts uk.org.publicwhip/member/1320 David Willetts uk.org.publicwhip/person/10637 0 2002-11-26-0a4a155f-10637-0
2917fe6b1811f9bacdd1c7abba8ea471317b76c0 My employment as the Senior Adviser to Monitor Company Management Consultants ceased in May 2001. The company has indicated that it may in future seek my assistance from time to time with individual projects, for which payment could be made. No such payment has been received by me to date. Remunerated employment, office, profession etc. 0a4a155f 2002-11-26 David Willetts uk.org.publicwhip/member/1320 David Willetts uk.org.publicwhip/person/10637 1 2002-11-26-0a4a155f-10637-0
1fa64ed893f871db2f08742816d559530befba6d Economic Adviser to Dresdner Kleinwort Benson, Merchant Bank. Remunerated employment, office, profession etc. 0a4a155f 2002-11-26 David Willetts uk.org.publicwhip/member/1320 David Willetts uk.org.publicwhip/person/10637 2 2002-11-26-0a4a155f-10637-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");