items

Table actions

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

10 rows where record_id = "2004-09-08-1f359ece-10130-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
f5b9444d82e587a5287a891c5a73ae084dcb1e4e Consultant to College Hill, providing advice on public policy in relation to horseracing, solely for their work in respect of the Tote. (£15,001-£20,000) (Registered 8 July 2003) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 0 2004-09-08-1f359ece-10130-0
2d57c9929518d9a6d00dcaeffcec9edb85cd6f61 Weekly article for The Independent. (£15,001-£20,000) (Registered 8 July 2003) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 1 2004-09-08-1f359ece-10130-0
2f725659e6f99d5ef4e15d37780a2aeb713d24cf Contract with Simon & Schuster for a book on political events since the General Election of 2001, for which I have received £250,000 from the publishers and £200,000 from the Sunday Times. (Registered 8 July 2003) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 2 2004-09-08-1f359ece-10130-0
d8597fbf6e76061cf1aa25554a1e7c9771ab10d4 9 October 2003, lecture for Royal Bank of Scotland. (£5,001-£10,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 3 2004-09-08-1f359ece-10130-0
df9c6e165b33f506cd24dd38ad1d1e4429fd6917 Occasional articles for: The Sunday Mirror (£2,000) (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 4 2004-09-08-1f359ece-10130-0
03fa447de5a5abab843b32080b9e6553c8078a13 The London Standard (£3,500) (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 5 2004-09-08-1f359ece-10130-0
e965f0312b75e8dd35c1b9818f918e286bdea733 The Guardian (£650) (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 6 2004-09-08-1f359ece-10130-0
f2b32d173e8bd775efb1e65a86117123700f44aa Monthly article for the Racing Post. (£5,001-£10,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 7 2004-09-08-1f359ece-10130-0
84943c032e9e569eb9383695a70d34d07c58b8ed 20 February 2004, lecture in Tokyo for Royal Bank of Scotland. (£5,001-£10,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 8 2004-09-08-1f359ece-10130-0
30959ad6824ba4691b7b303c11af0bba1f802823 5 May 2004, lecture in Athens for Economist Intelligence Unit. (£5,001-£10,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Robin Cook uk.org.publicwhip/member/817 Robin Cook uk.org.publicwhip/person/10130 9 2004-09-08-1f359ece-10130-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");