items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
604 rows where member_id = "uk.org.publicwhip/member/1885" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
84cd1e7937bf4ba565d8d65d452a92b66522b75f | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-04-12-1f359ece-10084-0 |
0c814b68157d6669e80a1cfc4135a1ecc5111d64 | 8 July 2009, received payment of £4,666.67. Hours: 12hrs. (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-04-12-1f359ece-10084-0 |
df617610e0f0bd841693cbb6bd6a227f7e8a62b1 | 10 August 2009, received payment of £4,666.67. Hours: 12hrs . (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-04-12-1f359ece-10084-0 |
37c8ec739fff5c27a2da9131f3802835fb7ce4b1 | 14 September 2009, received payment of £4,666.67. Hours: 12 hrs. (Registered 21 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-04-12-1f359ece-10084-0 |
4f93cd721ef74b3bc56e6dc7f56709670334ed77 | 12 November 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-04-12-1f359ece-10084-0 |
a3ecabb2ce58c66d047c96744c798ae6e65b3841 | 10 December 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 11 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-04-12-1f359ece-10084-0 |
200c04cc540f83a4c84876ddc86f6da2f14ee80a | 13 January 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-04-12-1f359ece-10084-0 |
ec37bb12f951e0a8c6852d85009b85e1220d377b | 10 February 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2010-04-12-1f359ece-10084-0 |
f6ef68923eeb6642ca8b2e48b2969265e0bbde56 | 10 March 2010 received payment of £4666.67. Hours: 12 hrs. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2010-04-12-1f359ece-10084-0 |
233dd5ea6bc93e5cdc0093df48a83664fe27017f | Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2010-04-12-1f359ece-10084-0 |
f5966f205cc27bfc44c2dff69e0b05dd99994f88 | Contract with Atlantic Books for a book on the state of the economy. (£15,001-£20,000) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2010-04-12-1f359ece-10084-0 |
3fa827231bb5e85fc85bdeb3933c2575df511377 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2010-04-12-1f359ece-10084-0 |
872721be8040cb10ec1bee5f3ca850ce70793912 | 4 January 2010, received royalty earnings of £23,400.99 from publisher Atlantic Books for sales of 'The Storm'. Hours: TBC. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2010-04-12-1f359ece-10084-0 |
f3166cf8101077e0e08c70a47ca490b3c7da3248 | 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 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2010-04-12-1f359ece-10084-0 |
b5f71cb86909804a624083d0023cc39f047518d1 | 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 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2010-04-12-1f359ece-10084-0 |
b28d4f289e81e294aedbddf8de91fbf06164dfcf | 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 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2010-04-12-1f359ece-10084-0 |
264487b17f488a7b1dfa7a5b89b8b2400b1cf6c9 | 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 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2010-04-12-1f359ece-10084-0 |
9a7268211bde5afbef631e21c7ec5d8444251168 | 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 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 17 | 2010-04-12-1f359ece-10084-0 |
8d285b1a45ac524dc5ba685406c39fccaffbc2d4 | 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 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 18 | 2010-04-12-1f359ece-10084-0 |
c1aacc742cc8024d32cde94a4ecd72542db152e4 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 19 | 2010-04-12-1f359ece-10084-0 |
0c1c49eaf82711fbcd3a0c904cf8bf02cb4dd6f2 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 20 | 2010-04-12-1f359ece-10084-0 |
5e977c6aa0053e9e45bee745658efcb126c10ab1 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2010-04-12-1f359ece-10084-0 |
64433c8074f8fe00c71da76f277cfcac40570647 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 22 | 2010-04-12-1f359ece-10084-0 |
fe6e9270bd4eb5d85dd5f9e7fbbdef01d0d2f487 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2010-04-12-1f359ece-10084-0 |
4d984eec84bcc894953906d06c5b972012af75ad | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 24 | 2010-04-12-1f359ece-10084-0 |
aabf5096345611a60670502de9551089e38900f1 | The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 25 | 2010-04-12-1f359ece-10084-0 |
95deb3b864e03d74a476b3fed33cedc870652129 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 26 | 2010-04-12-1f359ece-10084-0 |
41276328c679ca6373a4884e22a913e2cb4b7067 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 27 | 2010-04-12-1f359ece-10084-0 |
bd2617a23016df85de489b3f62747932040efdea | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 28 | 2010-04-12-1f359ece-10084-0 |
37ff24ff3740f63014dbb2a1b4329995bdf6d9be | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 29 | 2010-04-12-1f359ece-10084-0 |
f157dd388ba473cff557389fce50efbce8990d1e | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 30 | 2010-04-12-1f359ece-10084-0 |
99e9bdf4257855df999fb3e84528ac564e452068 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 31 | 2010-04-12-1f359ece-10084-0 |
053b7fad071ff1d52c2764a35c7269721b4f5651 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 32 | 2010-04-12-1f359ece-10084-0 |
5a1a36c4c80395679baac7003eac6f8bf0b49642 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 33 | 2010-04-12-1f359ece-10084-0 |
b3a9d5880055c849b7b935c98211fb2afd267f7e | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 34 | 2010-04-12-1f359ece-10084-0 |
7fce75ab6e7085bb7dbfc12a08f36ccd19b8b2a3 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 35 | 2010-04-12-1f359ece-10084-0 |
26501bc21f9d428c6c64b4b0017fe7771428027c | £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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 36 | 2010-04-12-1f359ece-10084-0 |
679ad8d0db9c5ac4bb1eb88b4260766c0566edef | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 37 | 2010-04-12-1f359ece-10084-0 |
612eb3748bbcee57f83f21b6fe07ff73c3491aff | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 38 | 2010-04-12-1f359ece-10084-0 |
6a23b988adaf63bf5c50ca41e0e0a9ec0c7418d3 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 39 | 2010-04-12-1f359ece-10084-0 |
dd1012a6ea952e369dd629dfa83a78dabcf256d4 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 40 | 2010-04-12-1f359ece-10084-0 |
1870076fb811fdbd0e2e20cff6ae4754ea05dc91 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 41 | 2010-04-12-1f359ece-10084-0 |
cfd053be1723e0fcfd2f809d97401bc96ffdf69b | Support received for my Westminster office from Lord Alliance, for a member of staff working part-time for me in my capacity as Liberal Democrat Treasury Spokesman. (Registered 15 April 2009) | Sponsorship or financial or material support 9e46def6 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-04-12-9e46def6-10084-0 |
0ef4ef7603d969625db0c91582ba75059b8716d8 | Name of donor: PricewaterhouseCoopers | Sponsorship or financial or material support 9e46def6 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-04-12-9e46def6-10084-0 |
bd446bbf5d55247585a96947cc389da960ac21df | Address of donor: Hay's Galleria, 1 Hay's Lane, London SE1 2RD. | Sponsorship or financial or material support 9e46def6 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-04-12-9e46def6-10084-0 |
5093d75f7c520a324f046b46d797e11f7a6bf4c7 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-04-12-9e46def6-10084-0 |
f6702030abc7e61d97faa36e756a06094826f674 | 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-04-12-9e46def6-10084-0 |
80a9bbcff6b088c48b0b3e6dfdb0701c05d0bd77 | Date of receipt: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-04-12-9e46def6-10084-0 |
d27fb8c95c3f66ecf261cfb737775ea916bb0132 | Date of acceptance: 1 April 2009 | Sponsorship or financial or material support 9e46def6 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-04-12-9e46def6-10084-0 |
5ad26b3dc930c56f5524225c582888ed3b1cc142 | Donor status: limited liability partnership | Sponsorship or financial or material support 9e46def6 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2010-04-12-9e46def6-10084-0 |
967df3ea97b01cb16f9b078b9bdff998129bd4c0 | (Registered 8 April 2010) | Sponsorship or financial or material support 9e46def6 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2010-04-12-9e46def6-10084-0 |
51d776ecf562e92acdc9f79b4979ff753db763f9 | Name of donor: Conde Nast Publications Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-04-12-84642823-10084-0 |
ce3ae499f3e9d689c875f8bc3fd6621011538273 | Address of donor: Vogue House, Hanover Square, London W1S 1JU. | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-04-12-84642823-10084-0 |
66e39ab122e9808ed0e7c5b7931d56b09102fccf | Amount of donation or nature and value if donation in kind: estimated value £1500a gift bag sent by GQ magazine after he 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-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-04-12-84642823-10084-0 |
24e38345f038d6f1db1cf28846f9bfb746a5864d | Date of receipt of donation: 22 September 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-04-12-84642823-10084-0 |
2a7ae8880dd312daac7ea0258ef1af23db4f678c | Date of acceptance of donation: 22 September 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-04-12-84642823-10084-0 |
adb7dc533e9aa4322428414f5ccc5b0015b6ce0b | Donor status: company, registration number 00226900 | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-04-12-84642823-10084-0 |
0e3db1b0a9cc98a8dbfe97ddb1e961ee54836898 | (Registered 23 December 2009) | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-04-12-84642823-10084-0 |
55262a3ac79978b01572b9e71fb2cc4dadd3d76f | 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. Address: Bloomberg Finance LP, 731 Lexington Avenue, New York, NY 10022, USA. (Registered 31 March 2010) | Overseas benefits and gifts a41b9847 | 2010-04-12 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-04-12-a41b9847-10084-0 |
08800c38979c885342f66bbcc170e2e0905aef2b | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2010-03-24-1f359ece-10084-0 |
62eb7b91ff78cac7757497bcac343889f03cc8b9 | 8 July 2009, received payment of £4,666.67. Hours: 12hrs. (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2010-03-24-1f359ece-10084-0 |
a2a4ddca4ef00f339bc863f4715b7fd401eb589e | 10 August 2009, received payment of £4,666.67. Hours: 12hrs . (Registered 30 September 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2010-03-24-1f359ece-10084-0 |
e14496a2008a6bcb7c38e88ac29de7594e73c485 | 14 September 2009, received payment of £4,666.67. Hours: 12 hrs. (Registered 21 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2010-03-24-1f359ece-10084-0 |
b6a39dd6f0b39aa4dd98d14aff15680c87cd68b1 | 12 November 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 16 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2010-03-24-1f359ece-10084-0 |
d84264f77e2989fe13f45d5f0892dd711807fc7d | 10 December 2009, received payment of £4666.67. Hours: 12 hrs. (Registered 11 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2010-03-24-1f359ece-10084-0 |
68a3d82efdc73e66d0478143b10fb63916f9cc53 | 13 January 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2010-03-24-1f359ece-10084-0 |
3171e752944886b30e1958bbb39706dcd5d73b53 | 10 February 2010, received payment of £4666.67. Hours: 12 hrs. (Registered 25 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2010-03-24-1f359ece-10084-0 |
eb80f1e0e85db532f0a4b47b4363e2202ae069e1 | 10 March 2010 received payment of £4666.67. Hours: 12 hrs. (Registered 17 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 8 | 2010-03-24-1f359ece-10084-0 |
ba2dfb56f31f31cf4f8609f795b745bcc0af22cc | Atlantic Books Ltd, Ormond House, 26-27 Boswell Street, London, WC1N 3JZ. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 9 | 2010-03-24-1f359ece-10084-0 |
7b1e3d94241345b56cc904af5dc09bdaea27e87d | Contract with Atlantic Books for a book on the state of the economy. (£15,001-£20,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 10 | 2010-03-24-1f359ece-10084-0 |
932c142efe440bc3c22c0f90d98c67aacebb0bd5 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 11 | 2010-03-24-1f359ece-10084-0 |
277ac6ede861839212738646c4554658642334fd | 4 January 2010, received royalty earnings of £23,400.99 from publisher Atlantic Books for sales of 'The Storm'. Hours: TBC. (Registered 21 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 12 | 2010-03-24-1f359ece-10084-0 |
d32fec1f2d247a27b232aa7e97e47ea1d794d3e6 | 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 | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 13 | 2010-03-24-1f359ece-10084-0 |
301223df0bec5e1ca3cd683e5cd1dd2acd4f7a69 | 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 | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 14 | 2010-03-24-1f359ece-10084-0 |
5e278f319e5137308670989349e20d9d12d136f7 | 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 | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 15 | 2010-03-24-1f359ece-10084-0 |
eccb23970355302312d1175a0326926536eb5b6b | 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 | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 16 | 2010-03-24-1f359ece-10084-0 |
6c00b0dd108f918d85235e972be4ad301df485e4 | 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 | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 17 | 2010-03-24-1f359ece-10084-0 |
bdd83834ef68ec9488b60dd6bbf5b84be1b98ac5 | 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 | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 18 | 2010-03-24-1f359ece-10084-0 |
a7bc1bca57b943606dcef74c53cef535f065ac6d | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 19 | 2010-03-24-1f359ece-10084-0 |
0d4f05b2e0bdd31e5833dd241c00428749a641b4 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 20 | 2010-03-24-1f359ece-10084-0 |
4993f24cb5d389d52626de95e2d993644bcc3223 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 21 | 2010-03-24-1f359ece-10084-0 |
bf4d8ded7b107123e200d6a24f15ca92a023ed65 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 22 | 2010-03-24-1f359ece-10084-0 |
05cf29ba20c3d3176fa1ffacc2a0316fba92828b | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 23 | 2010-03-24-1f359ece-10084-0 |
48241b61c973365d2cc929c85ad1e426f90d35a3 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 24 | 2010-03-24-1f359ece-10084-0 |
f1df8159d4dea1fe21f9d37eafe1172414a80cf3 | The Times newspaper, News International Group. News International Limited, 1 Virginia St, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 25 | 2010-03-24-1f359ece-10084-0 |
155d6aa44e0d02906918859bb6c06ee09fb436ca | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 26 | 2010-03-24-1f359ece-10084-0 |
8dd7c85db34df123a00b83e9d620bc83df9d9e49 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 27 | 2010-03-24-1f359ece-10084-0 |
f406314ff75d7c6e060d128f1130b7f5903dce2a | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 28 | 2010-03-24-1f359ece-10084-0 |
a14529385decd9f05d98433d074c0158bbfdea04 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 29 | 2010-03-24-1f359ece-10084-0 |
c610286ed372c27bd377c57ae01c5def20fa4f78 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 30 | 2010-03-24-1f359ece-10084-0 |
5cc80cf56ee7f6cf102dac7dbcb9dd70a3b39dd2 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 31 | 2010-03-24-1f359ece-10084-0 |
eec939fc7110acf06039a03a81796c2d59c9661f | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 32 | 2010-03-24-1f359ece-10084-0 |
04f247b9c26c53cbc6433401a345f9a02fa9ed59 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 33 | 2010-03-24-1f359ece-10084-0 |
46c6957d9500cacca6c44ae742ebc6f7ad972038 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 34 | 2010-03-24-1f359ece-10084-0 |
993415f6f77f4fd566a2a00f25ee69c4d10a4133 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 35 | 2010-03-24-1f359ece-10084-0 |
d2b41cb9a60c89ca0284b044d1a5a5d5a19d89a9 | £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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 36 | 2010-03-24-1f359ece-10084-0 |
8b841a3d4ea17d9e20f8e89cee2a09db7291a046 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 37 | 2010-03-24-1f359ece-10084-0 |
ee5ab42af1cb472d82ef8c03876a0fbf3a6839d5 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 38 | 2010-03-24-1f359ece-10084-0 |
804a1018fdf7d9ada39fac5d8bdf6ea30695ccec | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 39 | 2010-03-24-1f359ece-10084-0 |
14923245c6fb23ae9c0351cac5c93d3dc0decf32 | 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-03-24 | Vincent Cable uk.org.publicwhip/member/1885 | Vincent Cable uk.org.publicwhip/person/10084 | 40 | 2010-03-24-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");