items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
38 rows where record_id = "2010-09-06-1f359ece-10084-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 |
---|---|---|---|---|---|---|---|
616fa50322342bfff12b2de2f2296c26720ec970 | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-09-06-1f359ece-10084-0 |
dbfd2a76667415efe77efbbd93ee2e70e097d8b1 | 8 July 2009, received payment of £4,666.67. Hours: 12hrs. (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-09-06-1f359ece-10084-0 |
e0da827bb120eefe9fd6c1c4414a5bfab30568eb | 10 August 2009, received payment of £4,666.67. Hours: 12hrs . (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-09-06-1f359ece-10084-0 |
aadcd58528ad99ac800b8702643bae3c3a234e22 | 14 September 2009, received payment of £4,666.67. Hours: 12 hrs. (Registered 21 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-09-06-1f359ece-10084-0 |
fac87a94ebd1e2fbd982c748cf6baffbab82b3b7 | 12 November 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-09-06-1f359ece-10084-0 |
86852785da860f2b759f5992957b75b58402b2fd | 10 December 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 11 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-09-06-1f359ece-10084-0 |
382125cfa552b1888e7de8edc1fad53045dca6fd | 13 January 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-09-06-1f359ece-10084-0 |
3527060705fe355f2c55c33f9e998930b3d8aeff | 10 February 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2010-09-06-1f359ece-10084-0 |
b82e3dd489aa6b07e8e8c89aed89a47c7deeefea | 10 March 2010 received payment of £4666.67. Hours: 12 hrs. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2010-09-06-1f359ece-10084-0 |
e183baf7b7b94c7316af396d55cc0570a13fb990 | 14 April 2010, received payment of £4,666.67. Hours: 12 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2010-09-06-1f359ece-10084-0 |
6db1b7fe72a26ce7e08825d50d7e8d6f6641c7bc | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2010-09-06-1f359ece-10084-0 |
d1c4df5a4625c90aa1888d91e6ee83d16ce1eee2 | Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2010-09-06-1f359ece-10084-0 |
7e0102879e79f47c3911380417321090cba5a8ec | Contract with Atlantic Books for a book on the state of the economy. (£15,001–£20,000) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2010-09-06-1f359ece-10084-0 |
47dbacccb93d33fc8ae4ad2c4c5e22b63b90edfc | 12 November 2009, received publication advance of £2068.75 for autobiographical book ‘Free Radical’ from Atlantic Books Ltd. Hours: difficult to calculate, as the book has been written over several years. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2010-09-06-1f359ece-10084-0 |
3808efd3033b2367a3f535dbc550013bfdd9d9c4 | 4 January 2010, received royalty earnings of £23,400.99 from publisher Atlantic Books for sales of ‘The Storm’. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2010-09-06-1f359ece-10084-0 |
ca3fb27d66d49b7c7d08638d03f362b91ba82929 | Fee of £500 received for speaking engagement organised by The Spectator, 22 Old Queen Street, London, SW1H 9HP. Hours: 1hr. Fee paid to charity. (Registered 2 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2010-09-06-1f359ece-10084-0 |
6ceda7d0378de70839d717d0990f3f9ec1f85c11 | Fee of £100 received for speaking engagement at Gaitskell Politics Society, Winchester College, Winchester, Hampshire, SO23 9NA. Hours: 1.5hrs. Fee paid to charity . (Registered 2 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2010-09-06-1f359ece-10084-0 |
96b2f6e19e8773032dc2986cd3dbe353b7fe9425 | 14 October 2009, received fee of £250 from Classic Arts Productions Ltd, The Old Rectory, Hampton Lovett, Droitwich, Worcestershire, WR9 OLY, for appearance on BBC Radio 3’s ‘Private Passions’, hours: 1.5 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 17 | 2010-09-06-1f359ece-10084-0 |
975002b9ab76f6d9f69fcded804ad1cf7544b20a | 16 October 2009, received honorarium of £200 from St Paul’s Institute, 3b Amen Court, London, EC4M 7BU for speaking at public debate on 20 October. Hours: 1.5 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 18 | 2010-09-06-1f359ece-10084-0 |
3c2116a02a9ef03295568ac824c11508451bc7fb | 23 October 2009, received three bottles of wine (estimated value £90) from Michelmores LLP, Woodwater House, Pynes Hill, Exeter, EX2 5WR, on speaking at Michelmores Financial services and markets lunch on 20 October. Hours: 2 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 19 | 2010-09-06-1f359ece-10084-0 |
9c55e87f84fb2217f64edc5f729d8d84c4417851 | 2 November 2009, received payment of £325 from BBC Contributor Payments, PO Box 480, Manchester, M14 0EL, for writing and reading an essay on Adam Smith. Hours: 4 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 20 | 2010-09-06-1f359ece-10084-0 |
c69a3ee66d7dbc10595b7348c36f64eb752c3223 | The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2010-09-06-1f359ece-10084-0 |
4299c649b7bd4e0be62cf778119d2c9c5142c1d1 | 4 November 2009, received payment of £500 for article, published October 20. Hours: 3 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 22 | 2010-09-06-1f359ece-10084-0 |
75692a52d76a71a8c38da98405f0a45ffe813025 | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2010-09-06-1f359ece-10084-0 |
d97740dc601ff45678133f5d11069b4d8e09d0dd | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 24 | 2010-09-06-1f359ece-10084-0 |
ae68f6d6d5a552999709bd20cf58e92b5ed409a4 | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 25 | 2010-09-06-1f359ece-10084-0 |
2628a9c44501475542cf860f612012262156abbf | 4 November 2009, received payment of £250 from the Society of Pension Consultants, St Bartholomew House, 92 Fleet Street, London, EC4Y 1DG, for speaking at their Annual Dinner on 4 November. The money was donated to charity. Hours: 3 hrs. (Registered 18 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 26 | 2010-09-06-1f359ece-10084-0 |
899e6837d9d1ea07d1f50250acb7c9d0a17c4eb1 | 12 November 2009, received payment of £300 for two events, ‘The Credit Crunch: where do we go from here?’ and a talk on ‘Free Radical’ on Saturday 10 October 2009 at the Cheltenham Literature Festival from Cheltenham Festivals, 109 Bath Road, Cheltenham, GL53 7LS. Hours: 2.5 hrs. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 27 | 2010-09-06-1f359ece-10084-0 |
e160aabec9e05b23098a95160d4926a5092e716b | 19 November 2009, received payment of £500 for an after-dinner speech on 27 October 2009 from Kleinwort Benson, 30 Gresham Street, London, EC2V 7PG. The money was donated to charity. Hours: 2.5 hrs. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 28 | 2010-09-06-1f359ece-10084-0 |
a3c5988e7f7c4e8ccebccde18d23836da8f617c9 | 4 December 2009, received fee for speaking engagement to P3 Pharmaceutical Group on 11 September 2009 from DBA speakers, 58 Station Avenue, Walton on Thames, Surrey, KT12 1NQ, £3200 paid to charity. Hours: 2 hrs. (Registered 11 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 29 | 2010-09-06-1f359ece-10084-0 |
028d06fccc155418c511f8b962bd254e1e357395 | 4 December 2009, received fee for speaking engagement to the Institute of Telecommunications Professionals on 24 September 2009 from DBA speakers, 58 Station Avenue, Walton on Thames, Surrey, KT12 1NQ, £6400 paid to charity. Hours: 2.5 hrs. (Registered 11 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 30 | 2010-09-06-1f359ece-10084-0 |
799421a52bea4a2ae926d8cfe2a0e934f2ddba41 | 4 December 2009, received payment of £6,400 for speaking engagement on 25 September to Chartered Institute of Public Finance and Accountancy (CIPFA) Northern Ireland from DBA Speakers, 58 Station Avenue, Walton-on-Thames, Surrey, KT12 1NQ. Fee paid to charity. Hours: 6.5 hrs. (Registered 18 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 31 | 2010-09-06-1f359ece-10084-0 |
415bd020fc1d5a16ac7c914994cfd8e271aee171 | £250 donation to charity made by the FCO Association for giving the annual Foreign Office lecture on 11 January 2010. FCO Association, Room 3/95, Old Admiralty Building, Whitehall, SW1A 2PA. Hours: 2.5 hrs. (Registered 15 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 32 | 2010-09-06-1f359ece-10084-0 |
dbc10231a04c4f40a08e0db654fc8540f4614016 | 22 December 2009, received a case of wine for an after dinner speech made to Cardiff Business Club, c/o M & A Solicitors LLP, Kenneth Pollard House, Cowbridge Road East, Cardiff, CF11 9AB on 17 December. Estimated value £150. Hours: 3 hrs. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 33 | 2010-09-06-1f359ece-10084-0 |
84414ba511f75aa3586df88b9dbd419f27ae4f82 | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 34 | 2010-09-06-1f359ece-10084-0 |
ad1f380fa0b8197fd70398514d6cb881c12d8f75 | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 35 | 2010-09-06-1f359ece-10084-0 |
a939ba94a6b95e2ff09183d85a4bc8c8b65b7fdb | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 36 | 2010-09-06-1f359ece-10084-0 |
a5cdd15cf3c520d79ba9eba18aa6e5ff14cef3ef | 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 | 2010-09-06 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 37 | 2010-09-06-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");