items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where date = "2005-01-28" and person_id = "uk.org.publicwhip/person/10130" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
457fb3714088a6889edfe4d2c05f4138cbea6cca | Consultant to the Tote, providing advice on public policy in relation to horseracing. (£15,001-£20,000) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 0 | 2005-01-28-5177ae6a-10130-0 |
3a36111e6510344cac452ccbcc9475343b9995bf | Contract for weekly article for The Guardian from October 2004. (£25,001-£30,000) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 1 | 2005-01-28-5177ae6a-10130-0 |
f4d6f069731ad23ff69bf2064d87dcadf626672f | 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... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 2 | 2005-01-28-5177ae6a-10130-0 |
5bf51f7137a1a9ce43ccf87ca4f2ddc5b312b2ea | Occasional articles for: The Sunday Mirror (£1,000) (Up to £5,000) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 3 | 2005-01-28-5177ae6a-10130-0 |
841fd1af087589af25257a0000bbd62d85a31da8 | Occasional articles for: The London Standard (Up to £5,000) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 4 | 2005-01-28-5177ae6a-10130-0 |
62860f69331e8ad04e2f055dfabf0927c2ba8cd4 | Monthly article for the Racing Post. (£5,001-£10,000) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 5 | 2005-01-28-5177ae6a-10130-0 |
bf87f2a549f48389f4172781a2c6a09412c2edde | Occasional broadcasting fees from BBC. (Up to £5,000) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 6 | 2005-01-28-5177ae6a-10130-0 |
2403a96a4fceeab89c50f863453a084d1f7ec15d | 20 February 2004, lecture in Tokyo for Royal Bank of Scotland. (£5,001-£10,000) (Registered 13 July 2004) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 7 | 2005-01-28-5177ae6a-10130-0 |
25e88e52193f56f65be1625ec35efb6a18103e3a | 5 May 2004, lecture in Athens for Economist Intelligence Unit. (£5,001-£10,000) (Registered 13 July 2004) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 8 | 2005-01-28-5177ae6a-10130-0 |
45437da6d5cdd25f5598fca666ba263ae1d888a0 | 6 September 2004, speech to an AMT-Sybex conference. (£5,001-£10,000) (Registered 4 October 2004) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 9 | 2005-01-28-5177ae6a-10130-0 |
fa767aa3a90378b84176c9085c92e6d3738f0e52 | 23 September 2004, speech to the Yorkshire Fiscal Group. (£5,001-£10,000) (Registered 4 October 2004) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 10 | 2005-01-28-5177ae6a-10130-0 |
d884869fa9d0b876c49c8b3b8019cde573930108 | 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... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 11 | 2005-01-28-5177ae6a-10130-0 |
cebb16b926e8413f829ce6e7c7e3fdd99e5dfe24 | 28 October 2004, television appearance for Hat Trick Productions. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 12 | 2005-01-28-5177ae6a-10130-0 |
2a36d0bf6e8470234fd95f18cf3c4e54b1c48c9c | 29 October 2004, speech to the Irish Auctioneers & Valuers' Institute, Dublin. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 13 | 2005-01-28-5177ae6a-10130-0 |
c03c588e8d81f4c7cc85596737b152b143d05683 | 18 November 2004, speech to the Northern Ireland Chamber of Commerce. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 14 | 2005-01-28-5177ae6a-10130-0 |
a02761eec235277f774d7d4a2ed8729860b74585 | 7 December 2004, speech to Russian Foundation. (Up to £5,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 15 | 2005-01-28-5177ae6a-10130-0 |
d5420e847fc8fb4c67757be1c49a6598f308238a | 16 December 2004, speech to the Association of Licensed Multiple Retailers. (£5,001-£10,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 16 | 2005-01-28-5177ae6a-10130-0 |
8c453a448a9e7eee8cb40937cb634b8a5ebefb34 | 17 December 2004, speech for Granada Television. (Up to £5,000) (Registered 28 January 2005) | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 17 | 2005-01-28-5177ae6a-10130-0 |
1caa4f77682355ae0d9a0b757c3f695ff356d720 | 13 May 2004, gold necklace given to my wife on behalf of the Arab Women's Association in appreciation of her and my attendance at their charity dinner. (Registered 13 July 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 0 | 2005-01-28-84642823-10130-0 |
ed0c3a4c80ad76eb4d0034a121970fe0d80fee82 | One residential property in London from which rental income is received. | Land and Property 4f1e6359 | 2005-01-28 | Robin Cook uk.org.publicwhip/member/817 | Robin Cook uk.org.publicwhip/person/10130 | 0 | 2005-01-28-4f1e6359-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");