items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where record_id = "2009-12-10-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 |
---|---|---|---|---|---|---|---|
4ee4f210f33ee38f490f9413e7b67972d80f1ea8 | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2009-12-10-1f359ece-10084-0 |
f905e717315a61c0ddd62da7721be636b0251787 | 8 July 2009, received payment of £4,666.67. Hours: 12hrs. (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2009-12-10-1f359ece-10084-0 |
516adbbd3bf5e3ca86c576c549dc995c6dd23ce2 | 10 August 2009, received payment of £4,666.67. Hours: 12hrs . (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2009-12-10-1f359ece-10084-0 |
926dcc1141b473d434023ec3ec3d7a260abb3fe0 | 14 September 2009, received payment of £4,666.67. Hours: 12 hrs. (Registered 21 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2009-12-10-1f359ece-10084-0 |
c92e28bd27b4042a41b1d6f47b82bfad0b9eee16 | 12 November 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2009-12-10-1f359ece-10084-0 |
d4d213a5426dd2a89f5f0e29c2811b8bed4358c2 | Fee from Hat Trick Productions for appearance on 'Have I Got News for You' on 30 October 2008. (Up to £5,000) (Registered 22 January 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2009-12-10-1f359ece-10084-0 |
8ddffff3c7ab5d035c14ad84e9e915b74cb78616 | Contract with Atlantic Books for a book on the state of the economy. (£15,001-£20,000) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2009-12-10-1f359ece-10084-0 |
51385517974ade858bbddbcc1a4790a96c237e58 | 12 November 2009, received publication advance of £2068.75 for autobiographical book 'Free Radical' from Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. Hours: difficult to calculate, as the book has been written over several years. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2009-12-10-1f359ece-10084-0 |
0ad45f09f5d381817a4793483ab19a9f73ca35d6 | Fee from Hat Trick Productions for appearance on 'It's Only a Theory' on 11 March 2009. (Up to £5,000) (Registered 30 April 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2009-12-10-1f359ece-10084-0 |
42bd7d64253d512573155658b8516e8b36d764cc | Speech at KPMG in London on 5 March 2009. (£5,001-£10,000) The money is paid to Twickenham Liberal Democrats. (Registered 6 May 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2009-12-10-1f359ece-10084-0 |
0624b48575d9cbb3ac2a17f8e299885ee7781c35 | Speaking engagement at Lombard on 11 March 2009. (£5,001-£10,000) Fee paid to charity. (Registered 7 May 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2009-12-10-1f359ece-10084-0 |
f8ce54000c16a4a7f29f2cc30be1590501d55dbe | Fee from Clive Conway Celebrity Productions Ltd for 'An Audience with Vince Cable' on 14 April 2009. (Up to £5,000) (Registered 12 May 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2009-12-10-1f359ece-10084-0 |
b6fd84ce23d406a99b27059b92ae7675f311e9c7 | Fee for speech at Isle of Man Institute of Directors on 23 May 2009 (Up to £5,000) . Fee paid to charity. (Registered 5 June 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2009-12-10-1f359ece-10084-0 |
980fab2b44ac507d92eb4290d83c85ea77f15613 | Fee for speaking engagement to alumni of Silcoates School on 25 March 2009. Fee of £1,200 paid to charity. Payment received from DBA speakers, 58 Station Avenue, Walton on Thames, Surrey, KT12 1NQ. Hours: 2hrs. (Registered 20 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2009-12-10-1f359ece-10084-0 |
40303fcc1e55699e10ff61eb598c671f95edf62c | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2009-12-10-1f359ece-10084-0 |
4f355f95385855d329306105ce07842683d7e41e | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2009-12-10-1f359ece-10084-0 |
2dfa8a434f36a4433595e6de1ff27f1231441478 | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2009-12-10-1f359ece-10084-0 |
479235ca3a1d7b7e288cc2116b698bc4c4ec308c | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 17 | 2009-12-10-1f359ece-10084-0 |
69d6e5cfb8c1ab229919518d73711a55c300ed3d | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 18 | 2009-12-10-1f359ece-10084-0 |
0ea3faf5a3b19ae4f3dc43ebd66f3db842874525 | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 19 | 2009-12-10-1f359ece-10084-0 |
09baa600dbb2af1022c83812740b15c847abd7b7 | 4 November 2009, received payment of £500 from The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY, for article, published October 20. Hours: 3 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 20 | 2009-12-10-1f359ece-10084-0 |
f70c9b026b461cba32c4c54cdb47845910fbe4fa | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2009-12-10-1f359ece-10084-0 |
21455a30f863be84a9b4c76de8df9d2b709d8985 | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 22 | 2009-12-10-1f359ece-10084-0 |
9891e85601d30e94ac0160d1a45fbbbc3f05bd51 | 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 | 2009-12-10 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2009-12-10-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");