items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where date = "2004-05-21" and person_id = "uk.org.publicwhip/person/10130" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
fefd89092c768864b22e1dbfed217e212abf0828 | 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-05-21 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 0 | 2004-05-21-1f359ece-10130-0 |
eed3aa4eb60529de875eb2c96c827669377eb84d | Weekly article for The Independent. (£15,001-£20,000) (Registered 8 July 2003) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 1 | 2004-05-21-1f359ece-10130-0 |
86816b5da8d13ada010cf0a5085ea35c17bbcc22 | 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-05-21 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 2 | 2004-05-21-1f359ece-10130-0 |
74aa892e871055d3547cf9b424d1f9958dfea748 | 9 October 2003, lecture for Royal Bank of Scotland. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 3 | 2004-05-21-1f359ece-10130-0 |
304b1401f1005ff11bbac18783c2c0ecd203538b | Occasional articles for: The Sunday Mirror (£2,000) (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 4 | 2004-05-21-1f359ece-10130-0 |
8818766059030d1e28eec39e4043840174c5b8ef | The London Standard (£3,500) (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 5 | 2004-05-21-1f359ece-10130-0 |
1309ffcf9b0e61dc0e2ab2cb9c1f4b1e142b2133 | The Guardian (£650) (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 6 | 2004-05-21-1f359ece-10130-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");