items

Table actions

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

3 rows where record_id = "2015-03-30-1f359ece-10326-4" 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
73bfb2aeb0ee598864f686ddc62ac380ffc90ee0 Received from the Harvard School of Public Health, 651 Huntington Ave, Boston, MA, fees for my role as expert adviser on Ministerial Leadership in Health programme for Ministers of Finance: Remunerated employment, office, profession etc 1f359ece 2015-03-30 Tessa Jowell uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 0 2015-03-30-1f359ece-10326-4
f9f5ecf39439ab615f1fe518d4d3684dead26abe Received fee of £2,448 for my role as expert adviser on programme which took place in Cambridge, MA from 5 to 9 April 2014. Harvard also paid for my return air fare and accommodation. Hours: 5 days plus 3 days’ preparation. (Registered 13 June 2014; updated 7 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Tessa Jowell uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 1 2015-03-30-1f359ece-10326-4
48a52c4334f15f38d48a697f44c1235af6423d87 Received fee of £2,798 for my role as expert adviser on programme which took place in Cambridge, MA from 1 to 6 June 2014. Harvard also paid for my return air fare and accommodation. Hours: 5 days plus 3 days’ preparation. (Registered 1 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Tessa Jowell uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 2 2015-03-30-1f359ece-10326-4

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");