items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where "date" is on date 2011-02-28 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 ▼ |
---|---|---|---|---|---|---|---|
d01e6afc2bbc4e02e977a96b520d582a6bee41e8 | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2011-02-28-1f359ece-10084-0 |
45f1be406a5050310a496bee80e509b667e4ec22 | 10 February 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2011-02-28-1f359ece-10084-0 |
0439a2054f407f29e52b53e2d7287a11973a765b | 10 March 2010 received payment of £4666.67. Hours: 12 hrs. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2011-02-28-1f359ece-10084-0 |
9cf43198d96eceefa7fd06df2f2ac6be1c0bd437 | 14 April 2010, received payment of £4,666.67. Hours: 12 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2011-02-28-1f359ece-10084-0 |
ea30b0f3f51a6ae0afa207ebf39afc3938ec420c | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2011-02-28-1f359ece-10084-0 |
2d1e6c24c04533d7377e2e515172f0e2f54cb2ae | Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2011-02-28-1f359ece-10084-0 |
e7856a1d033e509c7c5b3b4d008b3bfd6f0dd270 | Contract with Atlantic Books for a book on the state of the economy. (£15,001–£20,000) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2011-02-28-1f359ece-10084-0 |
47d0526aa32d926869f0d8c3cef0159faf490d28 | The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2011-02-28-1f359ece-10084-0 |
35b094b3fb88589bddf32ef946daf39d311da1af | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2011-02-28-1f359ece-10084-0 |
43c1c8e8e42a35453fe7a35fdbcf4a968dd20a1d | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2011-02-28-1f359ece-10084-0 |
d456ba87b678196efff042dbaa96124c2c5f25bc | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2011-02-28-1f359ece-10084-0 |
8c4843007f1366e1a910cf4a6bd264c855e4d789 | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2011-02-28-1f359ece-10084-0 |
42caab5b9af7a61f67de2a291a6ae221463597c3 | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2011-02-28-1f359ece-10084-0 |
ee6c93e64954558167bc903f16b417501adf646b | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2011-02-28-1f359ece-10084-0 |
625e71f78aaaff8463541aa6963d9dc462c2d9c0 | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2011-02-28-1f359ece-10084-0 |
f1f4d1398ccedcc5eeafb6b30bbc9f80ae22cc1a | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2011-02-28-1f359ece-10084-0 |
cc0b5bacb841169daf4c0dd4067176d9b5a4bb5e | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2011-02-28-9e46def6-10084-0 |
b71510d1114a01c9939774d67b3b2c1d2425bd57 | Name of donor: Bloomberg Professional Services | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2011-02-28-9e46def6-10084-0 |
28baecd89042816d9f221c9e6ed0d5f11c228f89 | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2011-02-28-9e46def6-10084-0 |
c50a3c3c45801737b29645c21f3ae781238b1d3c | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2011-02-28-9e46def6-10084-0 |
6bd83f9a7dabc3aa908da852fadb9ee7a8669a95 | Date of receipt: 25 September 2009 | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2011-02-28-9e46def6-10084-0 |
c9a831860d4817b57b29dfa1dace21f69b1016a5 | Date of acceptance: 25 September 2009 | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2011-02-28-9e46def6-10084-0 |
bd19912cdc801fa0c46981e3f56e3bab8b5e12b5 | Donor status: company, registration 03556095 | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2011-02-28-9e46def6-10084-0 |
3ecb43694a76b439d21fbb2c2e9398e05b34c871 | (Registered 31 March 2010) | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2011-02-28-9e46def6-10084-0 |
1a8bcd4264f0fb85cae0d738a90155c052e1802e | Name of donor: PricewaterhouseCoopers | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2011-02-28-9e46def6-10084-0 |
a0691f8fc905cf7995146db6491b9f66b2319dad | Address of donor: Hay’s Galleria, 1 Hay’s Lane, London SE1 2RD. | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2011-02-28-9e46def6-10084-0 |
bc3ad97beed62ed6f27f20f803442907217e8f30 | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2011-02-28-9e46def6-10084-0 |
c29689fcf8dc38bfb3851933572170bcb829dce1 | 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-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2011-02-28-9e46def6-10084-0 |
4b7fffa625cd6645a583ba56679dae42838822de | Date of receipt: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2011-02-28-9e46def6-10084-0 |
752a58f2b2f9f1c7d69b8380f3d9bf800dd86980 | Date of acceptance: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2011-02-28-9e46def6-10084-0 |
e14a67b11e15026633a788f80200c3f6ab9af950 | Donor status: limited liability partnership | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2011-02-28-9e46def6-10084-0 |
80e68da6dcde864945a34e18aef4e600b61c4dd2 | (Registered 8 April 2010) | Sponsorship or financial or material support 9e46def6 | 2011-02-28 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2011-02-28-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");