items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where "date" is on date 2011-01-24 and person_id = "uk.org.publicwhip/person/10084" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
15215ec7f5e93e5962c38ecf81cd77929583199c | Weekly column for Mail on Sunday, Associated Newspapers, 2 Derry Street, Kensington, W8 5TT. (£15,001–£20,000) The money after tax is paid to Twickenham Liberal Democrats. | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2011-01-24-1f359ece-10084-0 |
5187872b0e9f1157ac2b46d6af49af1456c06871 | 10 February 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2011-01-24-1f359ece-10084-0 |
ab952c88139a897a0bfe77d601c8db9afe09ad48 | 10 March 2010 received payment of £4666.67. Hours: 12 hrs. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2011-01-24-1f359ece-10084-0 |
ce0072278977369d24de3c5a607649026caced71 | 14 April 2010, received payment of £4,666.67. Hours: 12 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2011-01-24-1f359ece-10084-0 |
fbe017b46c71c8d238d79bb74b1be72e78c2a7ec | 12 May 2010, received payment of £4,666.67. This payment was for work undertaken before Mr Cable entered Government. Hours: 12 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2011-01-24-1f359ece-10084-0 |
fb5bda0ae2b9df1f39381113edf333b1669e28c7 | Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2011-01-24-1f359ece-10084-0 |
d3c9ec38b2ae9a8247a349591d8feeedd8decaa7 | Contract with Atlantic Books for a book on the state of the economy. (£15,001–£20,000) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2011-01-24-1f359ece-10084-0 |
6fad61ad372248447a5c0e893d01d5fde744cf41 | The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2011-01-24-1f359ece-10084-0 |
fb7e12ac9185ba0f13645b19d19543a6b5cc6a9c | 5 February 2010 donation to charity of £350 for contribution to ‘My first holiday’ article in the Saturday Times Magazine. Hours: 1.5 hrs (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2011-01-24-1f359ece-10084-0 |
e6edd0ae5ddc9ed3b6b8dec09689c3b0b882072b | 8 February 2010, received payment of £500 for article published 18 November 2009. Hours: 2 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2011-01-24-1f359ece-10084-0 |
abadb927085cbc5863291ba6cf3669c7d3bf49fc | 8 February 2010, received payment of £500 for article published 9 December 2009. Hours: 2 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2011-01-24-1f359ece-10084-0 |
d8603481791ad6526f070643531742dac9f7f7f3 | 1 February 2010, received payment of £300 for speaking engagement on 9 January at the Oxford Conference in Education. Address: 63 Buckingham Road, Richmond, TW10 7EH. Hours: 1 hr 15 mins. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2011-01-24-1f359ece-10084-0 |
206ac42eab94dce961e8949d880bc1d55a75076d | 25 February 2010 I received a tie, book and two jars of honey for giving a lunchtime speech to the D Group, 23 Grafton Street, W1S 4EY. Estimated value: £130. Hours: 1.5 hrs. (Registered 9 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2011-01-24-1f359ece-10084-0 |
9a39a6728186fe932964e88226f4fb76a683c65f | 8 March 2010, received a bottle of champagne from Cicero Consulting Limited, 1-2 Lower James Street, W1F 9EG for speaking at their Treasury Ministerial Question Time Panel on 23 February 2010. Estimated value: £30 Hours: 1 hr. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2011-01-24-1f359ece-10084-0 |
4ba7b455d6fd8c4902cefa34100e53c4f1edce48 | 24 March 2010, received a bottle of champagne from CBRE, Kingsley House, Wimpole Street, W1G ORE for participating in a question time panel debate. Estimated value: £60. Hours: 1 hr. (Registered 31 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2011-01-24-1f359ece-10084-0 |
5c49506084262bc75ddc8212dbc36989672e31ba | November 2010, received payment for participating in the Strictly Come Dancing Christmas Special on 29 November 2010. Address: BBC, Television Centre, Wood Lane, London W12 7RJ. Hours: 21.5. Payment: £10,000 donated to charity. (Registered 15 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2011-01-24-1f359ece-10084-0 |
ea906900f16f4094eeb1366b288a931d59be3eb8 | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2011-01-24-9e46def6-10084-0 |
a0e83a0f46c9cb9f5dc845c347aa240c53602bc4 | Name of donor: Bloomberg Professional Services | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2011-01-24-9e46def6-10084-0 |
0b76cd95d60e9d4961edfe6e42d85e463a96817c | Address of donor: Bloomberg Tradebook Europe Limited, City Gate House, 39-45 Finsbury Square, London EC2 A1P | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2011-01-24-9e46def6-10084-0 |
1c7aa410e9fb3533f682f156cfdaa1ea6afca1ba | Amount of donation or nature and value if donation in kind: provision of an ongoing subscription (since 25 September 2009) to Bloomberg Professional Services with accompanying monitor, keyboard and access to Bloomberg Anywhere in my capacity as Shadow Chancellor; estimated value £1150 per month. This subscription has now been terminated. | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2011-01-24-9e46def6-10084-0 |
13ca15db555214a2c2c453323a131d021a8790dc | Date of receipt: 25 September 2009 | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2011-01-24-9e46def6-10084-0 |
8a4db7563afce9efd7c5b3236400a40c385d9d6f | Date of acceptance: 25 September 2009 | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2011-01-24-9e46def6-10084-0 |
a6bd891e74c76cd3f8bf0a3ffc645f6b8a5af0c5 | Donor status: company, registration 03556095 | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2011-01-24-9e46def6-10084-0 |
62c1b051969f1dc500e70bf952ee0d50cd8282fc | (Registered 31 March 2010) | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2011-01-24-9e46def6-10084-0 |
a51bd183839a5a95f0326d30df1bc6da1a73588e | Name of donor: PricewaterhouseCoopers | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2011-01-24-9e46def6-10084-0 |
4b029c7cd1b4b40279bc6094961ab64a91a63cc3 | Address of donor: Hay’s Galleria, 1 Hay’s Lane, London SE1 2RD. | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2011-01-24-9e46def6-10084-0 |
f04598cf7b089297d2ef8ed86ecb29edc139d000 | Amount of donation or nature and value if donation in kind: advice to the Liberal Democrat Treasury Team during the Commons stages of the Finance Bill and secondment of a tax specialist between May and August 2009, who provides ongoing advice on an ad hoc basis. | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2011-01-24-9e46def6-10084-0 |
8e89cc2299d821a62ffe8550d7284ab1edd02645 | Total value £78,710 to Liberal Democrat Treasury Team of which as a Shadow Chancellor I receive a significant share. Covers period 1 April 2009 to February 2010. | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2011-01-24-9e46def6-10084-0 |
c4b1b6106e1760fdebd2cb1170a8d94c594854ce | Date of receipt: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2011-01-24-9e46def6-10084-0 |
75832b7a9c18b02eabdce5ee74835a17686a47a6 | Date of acceptance: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2011-01-24-9e46def6-10084-0 |
6dfd6827c5962e90ae327d1dc02a40413d6b5a98 | Donor status: limited liability partnership | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2011-01-24-9e46def6-10084-0 |
4e43b141932f6f5b6daef59555b8679fecb62cd3 | (Registered 8 April 2010) | Sponsorship or financial or material support 9e46def6 | 2011-01-24 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2011-01-24-9e46def6-10084-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");