items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where record_id = "2009-11-25-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 |
---|---|---|---|---|---|---|---|
6535f1321d185ce895f5d967e235864d3a11bfe3 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2009-11-25-1f359ece-10084-0 |
417d3f2d27890a23ee892f76d68e1f97dc175d92 | 8 July 2009, received payment of £4,666.67. Hours: 12hrs. (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2009-11-25-1f359ece-10084-0 |
d84bc566321fec3e848df790da2b89eedca0616d | 10 August 2009, received payment of £4,666.67. Hours: 12hrs . (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2009-11-25-1f359ece-10084-0 |
d3abdac45d4ed54f21161908571df7502790a827 | 14 September 2009, received payment of £4,666.67. Hours: 12 hrs. (Registered 21 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2009-11-25-1f359ece-10084-0 |
0e3d126ba31edd7cdfd234a571364faaf2b41848 | 12 November 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2009-11-25-1f359ece-10084-0 |
097ee942f85949fcb9cf62df58c6ecb73d11ff53 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2009-11-25-1f359ece-10084-0 |
d1ea743cb4f032dfd0d3702de6aa0ab110fc9da7 | Contract with Atlantic Books for a book on the state of the economy. (£15,001-£20,000) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2009-11-25-1f359ece-10084-0 |
8664b684db5641f29644fd596d143be2a4219d03 | 12 November 2009, received publication advance of £2068.75 for '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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2009-11-25-1f359ece-10084-0 |
bfaa3b924261a506f61673b7cea264e4626b5c70 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2009-11-25-1f359ece-10084-0 |
98a87a84df08c6bb8b77c9e80175ee3a0da7937c | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2009-11-25-1f359ece-10084-0 |
cf9e5ac9d7ebe29249a318c873b93bf200774261 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2009-11-25-1f359ece-10084-0 |
de06a6bb6a2c8121f97e523969bcb645337cc99c | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2009-11-25-1f359ece-10084-0 |
d0e5e74104167c7db9d174689601482d3590ae45 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2009-11-25-1f359ece-10084-0 |
e28a3ad3d9b4e38ed655c4dcd44363c66cd350b2 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2009-11-25-1f359ece-10084-0 |
5645b8dddadb3af97db99310706cdedeaf3ed5b4 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2009-11-25-1f359ece-10084-0 |
0fed5aaf550a631d06557fe2e6b3af5e2e0eb146 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2009-11-25-1f359ece-10084-0 |
4f595974f86b3f3f9350d32a2f755bb6c180a888 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2009-11-25-1f359ece-10084-0 |
7ed9bd31a59f80a61574d722b70ede306e55ce83 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 17 | 2009-11-25-1f359ece-10084-0 |
6b244091897e70f62fbe98985f9235b401c4d184 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 18 | 2009-11-25-1f359ece-10084-0 |
a69fc75d03dc1f44dc63bbec30dccf757e0887e5 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 19 | 2009-11-25-1f359ece-10084-0 |
ecb88266560a2ddd91a1c2e7abb5fb835365f6f4 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 20 | 2009-11-25-1f359ece-10084-0 |
10bcdc7463978b7272248e1462c5f63b15544152 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2009-11-25-1f359ece-10084-0 |
d1215019f51be160467a5da1a9c10597fd9bbb2b | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 22 | 2009-11-25-1f359ece-10084-0 |
a5b0a0786124a1d334d8e00c71d43279a8ae96c4 | 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-11-25 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2009-11-25-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");