items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2004-10-22-1f359ece-10130-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
dbd7bb2121e86658a24e8229b5567bd18b48da34 | 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) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 0 | 2004-10-22-1f359ece-10130-0 |
88c646929f1413ac69872a7a4106e5313215b73f | Contract for weekly article for The Guardian from October 2004. (£25,001-£30,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 1 | 2004-10-22-1f359ece-10130-0 |
d4ae16d4e6ff030225b60d71426fa486221cefa2 | 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-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 2 | 2004-10-22-1f359ece-10130-0 |
c7b67b0f461e9904a00f8ac30b654e802f9ad824 | 9 October 2003, lecture for Royal Bank of Scotland. (£5,001-£10,000) (Registered 8 January 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 3 | 2004-10-22-1f359ece-10130-0 |
8176c51e1dc3dbb4cbb23264a76ee2e7ad90d487 | Occasional articles for: | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 4 | 2004-10-22-1f359ece-10130-0 |
e81f99dcf6b961cfd3d75689c737a2f8f0743eac | The London Standard (£3,500) (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 5 | 2004-10-22-1f359ece-10130-0 |
891ae17a75cb4c893c54845cab72cc062c94fc59 | Monthly article for the Racing Post. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 6 | 2004-10-22-1f359ece-10130-0 |
9697c36ee388d39c3a364db28b3f4e844c78b2ca | 20 February 2004, lecture in Tokyo for Royal Bank of Scotland. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 7 | 2004-10-22-1f359ece-10130-0 |
3d6d1cfa7cc4eebd69f01211975008b51459fb1c | 5 May 2004, lecture in Athens for Economist Intelligence Unit. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 8 | 2004-10-22-1f359ece-10130-0 |
d4e10b89ae7af47e54fa83601c525db44f59c49f | 6 September 2004, speech to an AMT-Sybex conference. (£5,001-£10,000) (Registered 4 October 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 9 | 2004-10-22-1f359ece-10130-0 |
4f66b5a2ce8e297fac455c8e575474ab2e42598c | 23 September 2004, speech to the Yorkshire Fiscal Group. (£5,001-£10,000) (Registered 4 October 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 10 | 2004-10-22-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");