items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2,836 rows where person_id = "uk.org.publicwhip/person/10084" sorted by date descending
This data as json, CSV (advanced)
date (date) >30 ✖
- 2015-01-26 62
- 2015-02-09 62
- 2015-02-23 62
- 2015-03-09 62
- 2015-03-30 62
- 2010-09-06 61
- 2010-10-25 61
- 2010-04-12 59
- 2010-11-08 56
- 2010-12-20 52
- 2011-01-10 52
- 2010-11-22 51
- 2010-12-06 51
- 2010-03-24 49
- 2010-03-10 47
- 2010-02-03 43
- 2010-02-24 40
- 2010-01-06 38
- 2015-01-06 36
- 2014-09-22 34
- 2014-10-13 34
- 2014-10-27 34
- 2014-11-10 34
- 2014-11-24 34
- 2014-12-08 34
- 2011-01-24 32
- 2011-02-07 32
- 2011-02-28 32
- 2014-08-26 32
- 2014-07-28 28
- …
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
00c6acf8154920029f6e9da33e3c9c3b22c2be87 | Name of donor: Lord David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £25,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2019-04-01-2fa6c1a9-10084-0 | |
0c9deb954a856eff6091e82ea0023e0f36db0d4e | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 27 July 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-04-01-2fa6c1a9-10084-0 | |
162f63aed7869e1b67b335a4370a323bcfff0b4c | Visiting Professor at the London School of Economics, and the universities of Nottingham, Sheffield and St Mary, Twickenham. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-04-01-5f2cbd10-10084-0 | |
25d92c184b523d4995b619af3f58eb4ea43d877c | Name of donor: Sue Howes Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2019-04-01-2fa6c1a9-10084-0 | |
266be14d90ab91ed5abef84377d7d5380f13c1e8 | I have been given life membership of the National Liberal Club, Whitehall Place, London SW1A 2HE. (Registered 26 September 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-04-01-64e8edeb-10084-0 | |
38b66765f4b84042eb1f8ef61f8fd73c41b1d46b | Name of donor: Harlequin Football Club Ltd Address of donor: Twickenham Stoop Stadium, Langhorn Drive, Twickenham TW2 7SX Amount of donation or nature and value if donation in kind: Two tickets to a match, value £336 Date received: 29 December 2018 Date accepted: 29 December 2018 Donor status: company, registration 03213073 (Registered 15 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-04-01-64e8edeb-10084-0 | |
5fe98db7ecd57f87c0f169771714cab7ab1cc3fd | 12 November 2018, payment of £3,000 from State Street Global Advisors (asset management), 20 Churchill Place, London E14 5HJ, for a speech and Q&A session. Hours: 2 hrs. Fee paid direct to local charity. (Registered 23 November 2018) | Employment and earnings 10057ffd | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-04-01-10057ffd-10084-0 | |
60e3fda56215f3ea7837ca3094a5698a68cd7c23 | 23 May 2018, payment of £500 from the Financial Times, One Southwark Bridge, London SE1 9HL, for an article. Hours: approx. 3 hrs. Fee paid direct to local charity. (Registered 05 June 2018) | Employment and earnings 10057ffd | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-04-01-10057ffd-10084-0 | |
6a471b3e284c727a475ce662f75749fd8fede734 | Chair (unpaid) of HCT; accessible transport company. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-04-01-5f2cbd10-10084-0 | |
b1de2778cec309aa6278e52b82f7206d63f0859d | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 05 November 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2019-04-01-2fa6c1a9-10084-0 | |
c16d94655cc12f25c30a8fab2aa4fdc2a1898c4b | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 13 June 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-04-01-2fa6c1a9-10084-0 | |
e9506d9f3605e569e40f4fa5038961c3ad7b6761 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 30 April 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-04-01-2fa6c1a9-10084-0 | |
f0c3c55e687f02ba94ae32a3757d88463536d602 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 15 January 2019) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2019-04-01-2fa6c1a9-10084-0 | |
f2b674da09b7924c4e9fba9d35f626b444b67d2d | Name of donor: Greg Dyke Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2019-04-01-2fa6c1a9-10084-0 | |
fd5d28abde297574aea5fb9debbb0305f2171f24 | Name of donor: Alliance Manchester Business School Address of donor: F12 AMBS East, Booth Street East, Manchester M13 9SS Amount of donation, or nature and value if donation in kind: For a member of staff and myself, travel (£142 per person) and accommodation (£125 per person) associated with delivering a lecture at the Alliance Manchester Business School, total value £534 Date received: 15 March 2018 Date accepted: 15 March 2018 Donor status: unincorporated association (Registered 17 April 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-04-01 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-04-01-64e8edeb-10084-0 | |
05f86613ac322fa11ffa404d3c047f80b28ccdee | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 30 April 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-18-2fa6c1a9-10084-0 | |
074fd01c619c7c418f3d9e77a75a62801a2b28ba | 23 May 2018, payment of £500 from the Financial Times, One Southwark Bridge, London SE1 9HL, for an article. Hours: approx. 3 hrs. Fee paid direct to local charity. (Registered 05 June 2018) | Employment and earnings 10057ffd | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-18-10057ffd-10084-0 | |
0c2cec2bdad572993e07e9b613c9d0ee74d0120c | Name of donor: Lord David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £25,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2019-03-18-2fa6c1a9-10084-0 | |
3654f321414e7a3d8bb6a381fc645be311c9e3f2 | Name of donor: Sue Howes Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2019-03-18-2fa6c1a9-10084-0 | |
41ff6dd30a87748c4303db56017c7e6aee8cc169 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 05 November 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2019-03-18-2fa6c1a9-10084-0 | |
7acc5fc5e82782c9d7fd00748c513964194245d3 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 13 June 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-18-2fa6c1a9-10084-0 | |
8c52abc2d942c766a43ed61f8a57ff27c0ec7270 | I have been given life membership of the National Liberal Club, Whitehall Place, London SW1A 2HE. (Registered 26 September 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-18-64e8edeb-10084-0 | |
94254e5783bf85f9e0b0ab34a9e6ff54909b5607 | Name of donor: Greg Dyke Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2019-03-18-2fa6c1a9-10084-0 | |
948ab3db321ff4f5da82090eea31f83b9629272a | Name of donor: Harlequin Football Club Ltd Address of donor: Twickenham Stoop Stadium, Langhorn Drive, Twickenham TW2 7SX Amount of donation or nature and value if donation in kind: Two tickets to a match, value £336 Date received: 29 December 2018 Date accepted: 29 December 2018 Donor status: company, registration 03213073 (Registered 15 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-03-18-64e8edeb-10084-0 | |
98400cf3a787c31d41f75f33a1347c1dd2b45558 | Chair (unpaid) of HCT; accessible transport company. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-18-5f2cbd10-10084-0 | |
9c35a78a6b0cd7e3d86c4ce831e53ea5b28a925f | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 15 January 2019) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2019-03-18-2fa6c1a9-10084-0 | |
a91f57b78803bb9c27451c12f0cb076f4bf3605f | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 27 July 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-03-18-2fa6c1a9-10084-0 | |
bea2c68a0e85beca0a8e670d16551082ede2733c | 12 November 2018, payment of £3,000 from State Street Global Advisors (asset management), 20 Churchill Place, London E14 5HJ, for a speech and Q&A session. Hours: 2 hrs. Fee paid direct to local charity. (Registered 23 November 2018) | Employment and earnings 10057ffd | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-18-10057ffd-10084-0 | |
cf4c5b148f8e3831af72c1e058c6e0df6bb1d674 | Visiting Professor at the London School of Economics, and the universities of Nottingham, Sheffield and St Mary, Twickenham. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-18-5f2cbd10-10084-0 | |
e650850e26a96cd6f20be64ef3b9c603c5962f16 | Name of donor: Alliance Manchester Business School Address of donor: F12 AMBS East, Booth Street East, Manchester M13 9SS Amount of donation, or nature and value if donation in kind: For a member of staff and myself, travel (£142 per person) and accommodation (£125 per person) associated with delivering a lecture at the Alliance Manchester Business School, total value £534 Date received: 15 March 2018 Date accepted: 15 March 2018 Donor status: unincorporated association (Registered 17 April 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-03-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-18-64e8edeb-10084-0 | |
08b40c799d82e77405f638effa488a270cf8f397 | Visiting Professor at the London School of Economics, and the universities of Nottingham, Sheffield and St Mary, Twickenham. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-04-5f2cbd10-10084-0 | |
1f54324374be95faf9113957c93ba079c6aa482e | Name of donor: Alliance Manchester Business School Address of donor: F12 AMBS East, Booth Street East, Manchester M13 9SS Amount of donation, or nature and value if donation in kind: For a member of staff and myself, travel (£142 per person) and accommodation (£125 per person) associated with delivering a lecture at the Alliance Manchester Business School, total value £534 Date received: 15 March 2018 Date accepted: 15 March 2018 Donor status: unincorporated association (Registered 17 April 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-04-64e8edeb-10084-0 | |
440b3702a2c3ae0b55921c2bb620bae584a43b13 | Name of donor: Sue Howes Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2019-03-04-2fa6c1a9-10084-0 | |
4c92b86d50a1fada4de00721c8d1f15f5b84877c | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 30 April 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-04-2fa6c1a9-10084-0 | |
630676ae5789348ea5e247a81eb3aab1733f34ec | I have been given life membership of the National Liberal Club, Whitehall Place, London SW1A 2HE. (Registered 26 September 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-04-64e8edeb-10084-0 | |
692e312f2ca367663669b310bc11c4826e1db190 | 23 May 2018, payment of £500 from the Financial Times, One Southwark Bridge, London SE1 9HL, for an article. Hours: approx. 3 hrs. Fee paid direct to local charity. (Registered 05 June 2018) | Employment and earnings 10057ffd | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-04-10057ffd-10084-0 | |
882f921ed19ac7e65b4ad62984e52d2fd8e8bada | Name of donor: Greg Dyke Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2019-03-04-2fa6c1a9-10084-0 | |
a7b2c1845b23adbeed864e8af086032a881474c3 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 15 January 2019) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2019-03-04-2fa6c1a9-10084-0 | |
b5a2ff291d7ae0c5f010d2dce85897cc907a4d71 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 05 November 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2019-03-04-2fa6c1a9-10084-0 | |
b904966135e5cb9822437336ad18b34b336597a9 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 27 July 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-03-04-2fa6c1a9-10084-0 | |
b94beede9edc758bfd9ae40b2b6546f611365f71 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 13 June 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-04-2fa6c1a9-10084-0 | |
cae7f57a0b45a3ea19bc521a1591ac052f07bd1f | Name of donor: Lord David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £25,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2019-03-04-2fa6c1a9-10084-0 | |
cfc392a43a45bb37dfe03ae66dcd2d71c9d62661 | 12 November 2018, payment of £3,000 from State Street Global Advisors (asset management), 20 Churchill Place, London E14 5HJ, for a speech and Q&A session. Hours: 2 hrs. Fee paid direct to local charity. (Registered 23 November 2018) | Employment and earnings 10057ffd | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-03-04-10057ffd-10084-0 | |
e420937799ca9be4fb20e2db1130125b0744d60e | Name of donor: Harlequin Football Club Ltd Address of donor: Twickenham Stoop Stadium, Langhorn Drive, Twickenham TW2 7SX Amount of donation or nature and value if donation in kind: Two tickets to a match, value £336 Date received: 29 December 2018 Date accepted: 29 December 2018 Donor status: company, registration 03213073 (Registered 15 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-03-04-64e8edeb-10084-0 | |
ed0536f67d4668a133a57b21f7c3197c6b550656 | Chair (unpaid) of HCT; accessible transport company. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-03-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-03-04-5f2cbd10-10084-0 | |
002f6a4803d546f46a3ce9c9cfc742411c70d495 | I have been given life membership of the National Liberal Club, Whitehall Place, London SW1A 2HE. (Registered 26 September 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-18-64e8edeb-10084-0 | |
0c568f3271d6de8bfb304c61a104bc8d831f48e0 | Name of donor: Harlequin Football Club Ltd Address of donor: Twickenham Stoop Stadium, Langhorn Drive, Twickenham TW2 7SX Amount of donation or nature and value if donation in kind: Two tickets to a match, value £336 Date received: 29 December 2018 Date accepted: 29 December 2018 Donor status: company, registration 03213073 (Registered 15 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-02-18-64e8edeb-10084-0 | |
10d07203e29aa676ed820dfe47e65b9f4b2b0fd5 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 27 July 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-02-18-2fa6c1a9-10084-0 | |
21cc4366407fb94a37075531983bf26c640556c3 | 23 May 2018, payment of £500 from the Financial Times, One Southwark Bridge, London SE1 9HL, for an article. Hours: approx. 3 hrs. Fee paid direct to local charity. (Registered 05 June 2018) | Employment and earnings 10057ffd | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-18-10057ffd-10084-0 | |
280812dbc1c0947a573b19f7dde3345369a30982 | Name of donor: Sue Howes Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2019-02-18-2fa6c1a9-10084-0 | |
37c6fdd4aa098d5e579ad5502761eaea0d9d1b82 | 12 November 2018, payment of £3,000 from State Street Global Advisors (asset management), 20 Churchill Place, London E14 5HJ, for a speech and Q&A session. Hours: 2 hrs. Fee paid direct to local charity. (Registered 23 November 2018) | Employment and earnings 10057ffd | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-18-10057ffd-10084-0 | |
3a01246ffcefb960b21d4f4e4b2b7ae5d9059ec4 | Visiting Professor at the London School of Economics, and the universities of Nottingham, Sheffield and St Mary, Twickenham. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-18-5f2cbd10-10084-0 | |
4b3e0f602dff9a17b66b076a1b2efd5d8df41cb6 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 05 November 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2019-02-18-2fa6c1a9-10084-0 | |
7dcc69d371a041345d7c53597b0faef3ffa9a01f | Name of donor: Alliance Manchester Business School Address of donor: F12 AMBS East, Booth Street East, Manchester M13 9SS Amount of donation, or nature and value if donation in kind: For a member of staff and myself, travel (£142 per person) and accommodation (£125 per person) associated with delivering a lecture at the Alliance Manchester Business School, total value £534 Date received: 15 March 2018 Date accepted: 15 March 2018 Donor status: unincorporated association (Registered 17 April 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-18-64e8edeb-10084-0 | |
833049b54705ce25e6bc2bd7bf6294028acb56c2 | Name of donor: Greg Dyke Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2019-02-18-2fa6c1a9-10084-0 | |
9152380a2ce2d0033a83197d6dda60c7523b2d30 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 13 June 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-18-2fa6c1a9-10084-0 | |
970365718a79768812f4dec754624086d8085130 | Chair (unpaid) of HCT; accessible transport company. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-18-5f2cbd10-10084-0 | |
9878c51f63d594d4bdb74bf441d524d8c30ecd0e | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 30 April 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-18-2fa6c1a9-10084-0 | |
bdd812ab721c2d57bc27b9e77eb9b570f5760f34 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 15 January 2019) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2019-02-18-2fa6c1a9-10084-0 | |
ef942b2512e7aca6dd9547f8bfbd60b54e7f5538 | Name of donor: Lord David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £25,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-18 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2019-02-18-2fa6c1a9-10084-0 | |
01d2528f6c76ecbc974414f7aa44a201c535e1b4 | Name of donor: Alliance Manchester Business School Address of donor: F12 AMBS East, Booth Street East, Manchester M13 9SS Amount of donation, or nature and value if donation in kind: For a member of staff and myself, travel (£142 per person) and accommodation (£125 per person) associated with delivering a lecture at the Alliance Manchester Business School, total value £534 Date received: 15 March 2018 Date accepted: 15 March 2018 Donor status: unincorporated association (Registered 17 April 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-04-64e8edeb-10084-0 | |
083479aba9778831efa28ef87897459dd0e04a18 | Visiting Professor at the London School of Economics, and the universities of Nottingham, Sheffield and St Mary, Twickenham. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-04-5f2cbd10-10084-0 | |
200188ede917001920a66d5f2c426f4a20172e89 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 13 June 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-04-2fa6c1a9-10084-0 | |
2be42f8120949031c171b49d34622a1e85ee5823 | Name of donor: Sue Howes Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2019-02-04-2fa6c1a9-10084-0 | |
61b20ba9c4557c480da395c8c9cb7ac6cc453634 | I have been given life membership of the National Liberal Club, Whitehall Place, London SW1A 2HE. (Registered 26 September 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-04-64e8edeb-10084-0 | |
7cc5102de052fc1b10d67867740e42874383e620 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 15 January 2019) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2019-02-04-2fa6c1a9-10084-0 | |
7ced3158c6c572503bedfdaea5e37ecabcf4a23e | 23 May 2018, payment of £500 from the Financial Times, One Southwark Bridge, London SE1 9HL, for an article. Hours: approx. 3 hrs. Fee paid direct to local charity. (Registered 05 June 2018) | Employment and earnings 10057ffd | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-04-10057ffd-10084-0 | |
912895797233fe89a91595baa19c44fa5de11084 | 12 November 2018, payment of £3,000 from State Street Global Advisors (asset management), 20 Churchill Place, London E14 5HJ, for a speech and Q&A session. Hours: 2 hrs. Fee paid direct to local charity. (Registered 23 November 2018) | Employment and earnings 10057ffd | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-02-04-10057ffd-10084-0 | |
92da6d3bb1407df497bc82450e77a87fd038e107 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 05 November 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2019-02-04-2fa6c1a9-10084-0 | |
99ec59c69690ae4ac012f8b68add996111f41ede | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 30 April 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-04-2fa6c1a9-10084-0 | |
dbb5520094b4ee8f84d1bd52c5392a43bc772497 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 27 July 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-02-04-2fa6c1a9-10084-0 | |
df63535b9ac177d097e2ae801236e9de574f8c0c | Name of donor: Harlequin Football Club Ltd Address of donor: Twickenham Stoop Stadium, Langhorn Drive, Twickenham TW2 7SX Amount of donation or nature and value if donation in kind: Two tickets to a match, value £336 Date received: 29 December 2018 Date accepted: 29 December 2018 Donor status: company, registration 03213073 (Registered 15 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-02-04-64e8edeb-10084-0 | |
e2d1a1e0e8ab442a9c8b8135ee4ab57ea896141c | Name of donor: Greg Dyke Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2019-02-04-2fa6c1a9-10084-0 | |
e3c678b6ef02204d75bc7b089fc3b2a1a866d6d0 | Name of donor: Lord David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £25,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2019-02-04-2fa6c1a9-10084-0 | |
eeb91141f3b6dbb03b847a679ca46fbff98128ca | Chair (unpaid) of HCT; accessible transport company. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-02-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-02-04-5f2cbd10-10084-0 | |
17ad4eef9a6c003c300bc4906eaefb517e205b0a | Chair (unpaid) of HCT; accessible transport company. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-21-5f2cbd10-10084-0 | |
1b356bf03951161a3008e608b907a9d50f18c116 | Name of donor: IBEC, an association for businesses based in Ireland Address of donor: 84-86 Lower Baggot St, Dublin 2 Estimate of the probable value (or amount of any donation): travel and accommodation for myself and a staff member; £561 in total Destination of visit: Dublin Dates of visit: 14 December 2017 Purpose of visit: to address IBEC (unpaid). (Registered 16 January 2018) | Visits outside the UK 891eb863 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-21-891eb863-10084-0 | |
1d90acc94a1b37f567791cdd7edaa0147bd21894 | Name of donor: Sue Howes Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2019-01-21-2fa6c1a9-10084-0 | |
20aa8993fc1a9d6e21942e77696f1901063afb9c | I have been given life membership of the National Liberal Club, Whitehall Place, London SW1A 2HE. (Registered 26 September 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-21-64e8edeb-10084-0 | |
3c4a2c2f0336e36da88372bc467c33b1f6b568eb | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 27 July 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-01-21-2fa6c1a9-10084-0 | |
43c0bed923e0e1ad2196826cc82db1e99ced62d8 | 23 May 2018, payment of £500 from the Financial Times, One Southwark Bridge, London SE1 9HL, for an article. Hours: approx. 3 hrs. Fee paid direct to local charity. (Registered 05 June 2018) | Employment and earnings 10057ffd | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-01-21-10057ffd-10084-0 | |
6662b63254a32ac44dd2ad50cb3abe2accb1af17 | Name of donor: Alliance Manchester Business School Address of donor: F12 AMBS East, Booth Street East, Manchester M13 9SS Amount of donation, or nature and value if donation in kind: For a member of staff and myself, travel (£142 per person) and accommodation (£125 per person) associated with delivering a lecture at the Alliance Manchester Business School, total value £534 Date received: 15 March 2018 Date accepted: 15 March 2018 Donor status: unincorporated association (Registered 17 April 2018) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-01-21-64e8edeb-10084-0 | |
6c33efbe3dd9f0ab614d7538689524fa42ea6daa | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 13 June 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-01-21-2fa6c1a9-10084-0 | |
78e6059ff4bcad9ab90d459dbe9db0f76a94a571 | Name of donor: Harlequin Football Club Ltd Address of donor: Twickenham Stoop Stadium, Langhorn Drive, Twickenham TW2 7SX Amount of donation or nature and value if donation in kind: Two tickets to a match, value £336 Date received: 29 December 2018 Date accepted: 29 December 2018 Donor status: company, registration 03213073 (Registered 15 January 2019) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-01-21-64e8edeb-10084-0 | |
7d03fc214b612bcdb03e0358bd04fd67681f1741 | Name of donor: Greg Dyke Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2019-01-21-2fa6c1a9-10084-0 | |
8e02a9eec66d79517c1201e604bd031f00dfdd78 | Payments received for speaking engagements via DBA Speakers, of 58 Station Avenue, Walton on Thames, Surrey KT12 1NQ: | Employment and earnings 10057ffd | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-21-10057ffd-10084-0 | |
9ab96cb4869c425d7dd0bc4d1420a46716ae39e7 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 30 April 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-21-2fa6c1a9-10084-0 | |
9e10002313c17ae185cfad097afe42c176df8870 | Name of donor: Lord David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £25,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2019-01-21-2fa6c1a9-10084-0 | |
9e7706dd73736dbda2149dfdd9468cd2af82e013 | 12 November 2018, payment of £3,000 from State Street Global Advisors (asset management), 20 Churchill Place, London E14 5HJ, for a speech and Q&A session. Hours: 2 hrs. Fee paid direct to local charity. (Registered 23 November 2018) | Employment and earnings 10057ffd | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2019-01-21-10057ffd-10084-0 | |
9ecfe2d19e64cd3bbd0c1999596ac9d3b70a7b9f | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 05 November 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2019-01-21-2fa6c1a9-10084-0 | |
b84bc000ea0d2415cf6d9e06829e67e2bf3235ba | Visiting Professor at the London School of Economics, and the universities of Nottingham, Sheffield and St Mary, Twickenham. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-01-21-5f2cbd10-10084-0 | |
b85e3997e135a84671488c41dae971f93868e0f0 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 15 January 2019) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 7 | 2019-01-21-2fa6c1a9-10084-0 | |
ec428f76a8a7ba22fadb421af54d41c0b6215af7 | 15 December 2017, received £5,000 for speaking at a conference from the Personal Finance Society, 20 Aldermanbury, London EC2V 7HY. Fee donated to local charities. Hours: 4 hrs. (Registered 03 January 2018) | Employment and earnings 10057ffd | 2019-01-21 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-01-21-10057ffd-10084-0 | |
1cad2c1d721d268dad1a12b9717758655fc0086e | Name of donor: IBEC, an association for businesses based in Ireland Address of donor: 84-86 Lower Baggot St, Dublin 2 Estimate of the probable value (or amount of any donation): travel and accommodation for myself and a staff member; £561 in total Destination of visit: Dublin Dates of visit: 14 December 2017 Purpose of visit: to address IBEC (unpaid). (Registered 16 January 2018) | Visits outside the UK 891eb863 | 2019-01-07 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-07-891eb863-10084-0 | |
200f37062a7b4de7a9af3c9f1b1ae4c456078e94 | Name of donor: Sue Howes Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 17 December 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-07 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2019-01-07-2fa6c1a9-10084-0 | |
24dc95686fcc1c5670cea98647a5ec74df67d8db | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 13 June 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-07 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-01-07-2fa6c1a9-10084-0 | |
2f8318beb7d1b67a59280654e1208dce4a3c9af7 | Chair (unpaid) of HCT; accessible transport company. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-01-07 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-07-5f2cbd10-10084-0 | |
38e760cb113b5c402ec5bb2d893846fd96d5e289 | Visiting Professor at the London School of Economics, and the universities of Nottingham, Sheffield and St Mary, Twickenham. (Registered 07 July 2017) | Miscellaneous 5f2cbd10 | 2019-01-07 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2019-01-07-5f2cbd10-10084-0 | |
4adaa6ec4bde28a10d4f7b0646c8b87c5325eeb2 | Name of donor: Dinesh Dhamija Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 30 April 2018) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2019-01-07 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2019-01-07-2fa6c1a9-10084-0 | |
549156920b021dd8bc0760015ab1faca9fe75dc0 | 23 May 2018, payment of £500 from the Financial Times, One Southwark Bridge, London SE1 9HL, for an article. Hours: approx. 3 hrs. Fee paid direct to local charity. (Registered 05 June 2018) | Employment and earnings 10057ffd | 2019-01-07 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2019-01-07-10057ffd-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");