items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
56 rows where "date" is on date 2010-11-08 and person_id = "uk.org.publicwhip/person/10084" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: category_id, record_id
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
d318afb3a3563c2a846c2712d506df9f3330c834 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-11-08-1f359ece-10084-0 |
99a5caa976fbd85b6ae52d99fa1d85a3b1003c9e | 12 November 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-11-08-1f359ece-10084-0 |
dc31472350f2d99934618070209c4ad17836081a | 10 December 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 11 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-11-08-1f359ece-10084-0 |
4ef237f0d3193b4b424ff5dc9f602d8a0152a006 | 13 January 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-11-08-1f359ece-10084-0 |
ebf83faea7350500493e6d1966f8a08b5ac8e510 | 10 February 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-11-08-1f359ece-10084-0 |
f98e31be4982d2c7cb747de444c54fea80fd3b22 | 10 March 2010 received payment of £4666.67. Hours: 12 hrs. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-11-08-1f359ece-10084-0 |
63af5f3a4bff149fd29242b6a89fe9185865202b | 14 April 2010, received payment of £4,666.67. Hours: 12 hrs. (Registered 4 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-11-08-1f359ece-10084-0 |
e656706fdf526e8dc77e198c2d49589f70bd3e5e | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2010-11-08-1f359ece-10084-0 |
c13797dfee57e9bcfb27e4c5a96facfc01ee5936 | Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2010-11-08-1f359ece-10084-0 |
05febf0c8d9b6ae4c580965e8cbfc75be34d7a46 | Contract with Atlantic Books for a book on the state of the economy. (£15,001–£20,000) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2010-11-08-1f359ece-10084-0 |
6097d947a057e0bda57a0a9f57695f3cf33964e5 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2010-11-08-1f359ece-10084-0 |
660c1919b1845279a1050dab0ed0c3c660835869 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2010-11-08-1f359ece-10084-0 |
2bb91a1625820ab4bc13ef9e64279aa359fa978b | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2010-11-08-1f359ece-10084-0 |
1fa54742edfc872efb295c5711802119a864486f | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2010-11-08-1f359ece-10084-0 |
22f790a64288e6d2849edf54e8cabea600e284f1 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2010-11-08-1f359ece-10084-0 |
11d3d10c78e4735de1aac2ca044f8620c777572d | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2010-11-08-1f359ece-10084-0 |
6fb86adcb9314fdd51ab95f375108338cd29cfb4 | The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2010-11-08-1f359ece-10084-0 |
79050296cc9f0999adb5c97a5bc5400cfcdc562f | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 17 | 2010-11-08-1f359ece-10084-0 |
4d9cb53cce661c88f7c83f085feb19c05d7102a6 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 18 | 2010-11-08-1f359ece-10084-0 |
7e71d27ccaf6e37e432b6946f6851a0d7de8eed2 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 19 | 2010-11-08-1f359ece-10084-0 |
73248f266a6e3c2e7b08aa9d41f013bd7d014822 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 20 | 2010-11-08-1f359ece-10084-0 |
34a7ec9c553e6fba01e0b7533d78f3ff5da452a5 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2010-11-08-1f359ece-10084-0 |
d78c8644c07dde1da3d4c5d3f3cc9607dbdd7a85 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 22 | 2010-11-08-1f359ece-10084-0 |
f380600be4a6293b02ca6da41ad781c4cfc4e574 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2010-11-08-1f359ece-10084-0 |
2b7c7e898ae51093fbadc649ac9748c2dffdf914 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 24 | 2010-11-08-1f359ece-10084-0 |
002adf58377ad969a48bf5769d5583810600475d | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 25 | 2010-11-08-1f359ece-10084-0 |
885f347e73f3f32fe29a1aaa3000490a1f9ea639 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 26 | 2010-11-08-1f359ece-10084-0 |
40f2e12ddfa6e093ab9c623e3413c1be2b0df489 | £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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 27 | 2010-11-08-1f359ece-10084-0 |
16ceccf603a7ff0327a70e18264182c2bba69742 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 28 | 2010-11-08-1f359ece-10084-0 |
3c89ed82c0370cf2c4befe4ffdb4b8a4e389f9cd | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 29 | 2010-11-08-1f359ece-10084-0 |
3a7f4509e3882d0d8bb944aa1f803047143535fc | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 30 | 2010-11-08-1f359ece-10084-0 |
a806aa2ee595acf20d3b28fb67c72f23478e22e5 | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 31 | 2010-11-08-1f359ece-10084-0 |
7f529d3833b6856a1b14909b9b44e772e21fe6fb | 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-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 32 | 2010-11-08-1f359ece-10084-0 |
4ea30531f039794dede3d89c4cb95c5e775b090b | Name of donor: Conde Nast Publications Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-11-08-84642823-10084-0 |
02b2f2458a97fbbc879f90081345d7868c20bf75 | Address of donor: Vogue House, Hanover Square, London W1S 1JU. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-11-08-84642823-10084-0 |
49451535db399f69cc4362d5950dcad90eecafdf | Amount of donation or nature and value if donation in kind: estimated value £1500-a gift bag sent by GQ magazine after I was nominated for one of their awards but was unable to attend the ceremony on 8 September 2009. The contents were donated to charity. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-11-08-84642823-10084-0 |
1f3ce0c002f2fcb10bd521d594f9f223a3007f1a | Date of receipt of donation: 22 September 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-11-08-84642823-10084-0 |
fb5cd4a58c98ade66015a2f5f4a9971e098f0cbf | Date of acceptance of donation: 22 September 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-11-08-84642823-10084-0 |
43f35445e17eba58452bdc785f2ee4d7cdae2f65 | Donor status: company, registration number 00226900 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-11-08-84642823-10084-0 |
b1937caa05bf216f6022aa7575952e1706cb8418 | (Registered 23 December 2009) | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-11-08-84642823-10084-0 |
b978352eae2a515090c29d77643742cc4b185161 | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-11-08-9e46def6-10084-0 |
14c33642ed169fb553903bc2d6553b638c21e83c | Name of donor: Bloomberg Professional Services | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-11-08-9e46def6-10084-0 |
6fd481d1f7da49c52d06429af0612122fa412557 | Address of donor: Bloomberg Tradebook Europe Limited, City Gate House, 39-45 Finsbury Square, London EC2 A1P | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-11-08-9e46def6-10084-0 |
5df339a7005a820bb7817c4b4ae0a2d476d4d252 | 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 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-11-08-9e46def6-10084-0 |
36c3500f4813ebaf27337f769f1bb241123a7bfb | Date of receipt: 25 September 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-11-08-9e46def6-10084-0 |
d3db539acd363e4a9581f23997c5e689212892e4 | Date of acceptance: 25 September 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-11-08-9e46def6-10084-0 |
f623641cf81998586393b3b2e5e6b96481c9e5ce | Donor status: company, registration 03556095 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-11-08-9e46def6-10084-0 |
be3c548045d010bae1e4c95f765e91f42826fcb3 | (Registered 31 March 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2010-11-08-9e46def6-10084-0 |
2a1c2b2173e70f7f2de546784d25b5ac10c4ab4c | Name of donor: PricewaterhouseCoopers | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2010-11-08-9e46def6-10084-0 |
d2946d65614cef21ca8ece5d661063374e61e16e | Address of donor: Hay’s Galleria, 1 Hay’s Lane, London SE1 2RD. | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2010-11-08-9e46def6-10084-0 |
016d54d56859adc3eacb6a461ad1c4a9993b13e6 | 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 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2010-11-08-9e46def6-10084-0 |
d707596c6f88322f33f7fa949e653a0f2ec55c70 | 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 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2010-11-08-9e46def6-10084-0 |
18890c61b774b4173bccf81f2ae749525fad5a97 | Date of receipt: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2010-11-08-9e46def6-10084-0 |
c5da286fab0cfc001ab4e31c5f628423181ebdc2 | Date of acceptance: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2010-11-08-9e46def6-10084-0 |
546b513cbbde4306aa4569012077bb86b833b9a0 | Donor status: limited liability partnership | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2010-11-08-9e46def6-10084-0 |
1068f7c105ddd4d0c7d0fd0d6b7ac84bc80f926a | (Registered 8 April 2010) | Sponsorship or financial or material support 9e46def6 | 2010-11-08 | Vincent Cable uk.org.publicwhip/member/40618 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2010-11-08-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");