items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2011-02-07-1f359ece-10084-0" sorted by record_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2011-02-07 16
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
00bd562e4c1cd5e1604f194de16ac02d33fad1a1 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2011-02-07-1f359ece-10084-0 |
4ad96672fd12b4d677779305eb9315f3aa5605ee | 10 February 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2011-02-07-1f359ece-10084-0 |
5a7a0a3c32885c06b600ec3c60d65cec5319e5e8 | 10 March 2010 received payment of £4666.67. Hours: 12 hrs. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2011-02-07-1f359ece-10084-0 |
9d582f2b372986e25ccc6ef53097d604fc7ca63a | 14 April 2010, received payment of £4,666.67. Hours: 12 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2011-02-07-1f359ece-10084-0 |
4ffc445a5030ae41cfed0a6648be5da48a23e245 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2011-02-07-1f359ece-10084-0 |
fe7e271690cc3cb368e295ed1de71f06ef7877d4 | Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2011-02-07-1f359ece-10084-0 |
ed9389dfcad9649cdda40d381c04946aad7ded61 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2011-02-07-1f359ece-10084-0 |
1ad3cc24659981675e93595b913ec9ba7b06b157 | The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2011-02-07-1f359ece-10084-0 |
5b32ef7ea245046c03b612c5e241f08c67fb39e6 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2011-02-07-1f359ece-10084-0 |
3feaa8c46547d018ac42764a1525dc0023dc49d4 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2011-02-07-1f359ece-10084-0 |
63fdfeef93e5dcfa13e333a550d0545a3ff44ca4 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2011-02-07-1f359ece-10084-0 |
2da504dcf1c0ba824755505c3e5bca62bd6389ba | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2011-02-07-1f359ece-10084-0 |
cb6705a56e0e61e41ebb270b952d4d7235685d55 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2011-02-07-1f359ece-10084-0 |
c29e54553b23738724f4c321b761c9e9fc680cea | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2011-02-07-1f359ece-10084-0 |
5a50e85128d6c5d68a5bfeb2e06d63939a0a2227 | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2011-02-07-1f359ece-10084-0 |
4ec83a742a535483c5028e03f27e4988f961ee2a | 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-07 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2011-02-07-1f359ece-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");