items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2005-04-11-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 |
---|---|---|---|---|---|---|---|
68cf91e909daec0e68070ab59644ab446a737a58 | Consultant to the Tote, providing advice on public policy in relation to horseracing. (£15,001-£20,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 0 | 2005-04-11-1f359ece-10130-0 |
ebb2b30f50eccfd820aad5d1f7eefc1cb17cf566 | Contract for weekly article for The Guardian from October 2004. (£25,001-£30,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 1 | 2005-04-11-1f359ece-10130-0 |
de414ce37803d494678715cdf124757960ddf0dd | Payment from Simon & Schuster for the paperback edition of 'The Point of Departure'. (£45,001-£50,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 2 | 2005-04-11-1f359ece-10130-0 |
d42e187496622f245e0a6358e9c90019ea844377 | Occasional articles for: The Sunday Mirror (£1,000) (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 3 | 2005-04-11-1f359ece-10130-0 |
b3bac8be849ba34ac848ab4b2120dfff3db6a178 | The London Standard (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 4 | 2005-04-11-1f359ece-10130-0 |
f9592d43cd2674c5cad891cda48198d6ace86c65 | Monthly article for the Racing Post. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 5 | 2005-04-11-1f359ece-10130-0 |
8e9a95af8d09cb53effc4615155ffc3941570f75 | Occasional broadcasting fees from BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 6 | 2005-04-11-1f359ece-10130-0 |
d31f72ce14e51d38559ac7019579dec3d3a5b4f0 | 20 February 2004, lecture in Tokyo for Royal Bank of Scotland. (£5,001-£10,000) (Registered 13 July 2004) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 7 | 2005-04-11-1f359ece-10130-0 |
a287605fe767669e7fb06c5aeb0780008c5719a2 | 5 May 2004, lecture in Athens for Economist Intelligence Unit. (£5,001-£10,000) (Registered 13 July 2004) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 8 | 2005-04-11-1f359ece-10130-0 |
c090215832374f5419c2f80c78a3544ce129c103 | 6 September 2004, speech to an AMT-Sybex conference. (£5,001-£10,000) (Registered 4 October 2004) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 9 | 2005-04-11-1f359ece-10130-0 |
75a67a18271dd5a6a4182053802b163b78b52e05 | 23 September 2004, speech to the Yorkshire Fiscal Group. (£5,001-£10,000) (Registered 4 October 2004) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 10 | 2005-04-11-1f359ece-10130-0 |
2d54aa9a86d6a9c0eeaca8d929c03d7b44696794 | 14 October 2004, speech to the Society of Local Authority Chief Executives. (Up to £5,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 11 | 2005-04-11-1f359ece-10130-0 |
436b48763a35a37956ebf7f743c0c02bebbd22d4 | 28 October 2004, television appearance for Hat Trick Productions. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 12 | 2005-04-11-1f359ece-10130-0 |
bfb0fdd5e6693402ea0485639fdd488b9af15b54 | 29 October 2004, speech to the Irish Auctioneers & Valuers' Institute, Dublin. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 13 | 2005-04-11-1f359ece-10130-0 |
0ebae409eb0231dd3509107ce4fa309c4f570032 | 18 November 2004, speech to the Northern Ireland Chamber of Commerce. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 14 | 2005-04-11-1f359ece-10130-0 |
ace9904cf06d85793e7fd163d828bd6161462854 | 7 December 2004, speech to Russian Foundation. (Up to £5,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 15 | 2005-04-11-1f359ece-10130-0 |
7837d9575f04cdfcf33e2d173553b16c5d77005e | 16 December 2004, speech to the Association of Licensed Multiple Retailers. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 16 | 2005-04-11-1f359ece-10130-0 |
69b3adfc3cd580699f7ff20e1a2dded050e96429 | 17 December 2004, speech for Granada Television. (Up to £5,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 17 | 2005-04-11-1f359ece-10130-0 |
13c7b0f53557bb8433aa07a5c9278f8a37b4aebe | 2 April 2005, speech to the Association of British Tour Operators in France. (£5,001-£10,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 18 | 2005-04-11-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");