items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
318 rows where category_id = "2fa6c1a9" and person_id = "uk.org.publicwhip/person/10084" sorted by person_id
This data as json, CSV (advanced)
Suggested facets: item, sort_order, date (date)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
3ef185f33cbbd3e740491312d8f312c6e3b0071f | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-07 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-07-07-2fa6c1a9-10084-0 | |
02aae5302a213f68f466673c796a77335ec10414 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-07 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-07-07-2fa6c1a9-10084-0 | |
e47f58403f6c2ecb11790587d07c845bdd4b7d2f | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-07 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-07-07-2fa6c1a9-10084-0 | |
f0c165960d1bd216c472f7704fe46c80512f1d2d | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-31 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-07-31-2fa6c1a9-10084-0 | |
0ce6ee3ab16ad441da9e838cccd080e2bfe24377 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-31 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-07-31-2fa6c1a9-10084-0 | |
ab5ef59142769bfa5088f26d60e4fe4f67a7b40a | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-31 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-07-31-2fa6c1a9-10084-0 | |
875ff7cc715f564d001fc30086aacbd7a49874b0 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-08-29 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-08-29-2fa6c1a9-10084-0 | |
def8ef192a0ad6a6d543174e0c970cded8edb64f | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-08-29 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-08-29-2fa6c1a9-10084-0 | |
7fd49665fcbd01d06a0f9f77dede85537c96f3a3 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-08-29 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-08-29-2fa6c1a9-10084-0 | |
1fe30cddcb078731d1de06e133d7c2823034724c | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-09-11 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-09-11-2fa6c1a9-10084-0 | |
470c3ffbcde1d3cfb1825f84ff8581156831e843 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-09-11 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-09-11-2fa6c1a9-10084-0 | |
5b775fa97003fc9f8a6d86b7ebe90f57557a046b | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-09-11 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-09-11-2fa6c1a9-10084-0 | |
c16453a6c781372b8ca8e354153cfbb6a6a40529 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-09 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-10-09-2fa6c1a9-10084-0 | |
3d23ed25eb075820e91944335b9d056a5bbe6095 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-09 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-10-09-2fa6c1a9-10084-0 | |
6eb5af167b9f0fda2d3843c4fe13c9a5ef06234b | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-09 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-10-09-2fa6c1a9-10084-0 | |
8a098936db3e47669b654cfc45e6e4f61650d047 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-23 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-10-23-2fa6c1a9-10084-0 | |
cbfaab582866aac01db41c771ea8216812defa93 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-23 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-10-23-2fa6c1a9-10084-0 | |
5860472b96cf01a4c4c5d23a38f27aebe9332308 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-23 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-10-23-2fa6c1a9-10084-0 | |
4d303f1c1d88adbee749a8e347d1c34c164b8174 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-13 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-11-13-2fa6c1a9-10084-0 | |
7798d4ddc7859d919e3c3316c8dd0df998667d13 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-13 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-11-13-2fa6c1a9-10084-0 | |
da90bbc7f29519a47a1758f1a07966b248ac7f46 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-13 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-11-13-2fa6c1a9-10084-0 | |
007dfd2e17eb85029f52683d8eb90d706847b57c | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-27 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-11-27-2fa6c1a9-10084-0 | |
dbc326ba0e64c6fb73f47641bca745a07175f9c9 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-27 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-11-27-2fa6c1a9-10084-0 | |
61a4ba3bec8408363227f737e84c1a2af5943f19 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-27 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-11-27-2fa6c1a9-10084-0 | |
0c75e8948098639b026108308ff2b9be6aff4e18 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2017-12-11-2fa6c1a9-10084-0 | |
e47887eacca34f455ed990e959450634e0dcded6 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2017-12-11-2fa6c1a9-10084-0 | |
44e6b5c6f7ebbda32dd9d31c370dd212b1fcd914 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2017-12-11-2fa6c1a9-10084-0 | |
8bab15921c2bc98b59265fdcea238db026221183 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2017-12-11-2fa6c1a9-10084-0 | |
1132a60af4460badd4a2bd85b1d749073420238d | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2017-12-11-2fa6c1a9-10084-0 | |
9013122acf80408218413cfea752fadb63814d7b | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-08 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-01-08-2fa6c1a9-10084-0 | |
8844451dd59718ed35af3be1a0234621e09c56bd | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-08 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-01-08-2fa6c1a9-10084-0 | |
5dabe6a31053a25f89b69c2a6f1b5261ca346ad7 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-08 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-01-08-2fa6c1a9-10084-0 | |
c88a069c9b4e2ca729aea158b4c86d1a49bdf763 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-08 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-01-08-2fa6c1a9-10084-0 | |
645c2c370daa150d18fdbc196d14970ab641f3bd | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-08 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-01-08-2fa6c1a9-10084-0 | |
2d58dd2dd91f6a9f5b529a8200a02787edf56e14 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-22 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-01-22-2fa6c1a9-10084-0 | |
104b1d88c12f1f750ef6d76ad6167460c9b5d180 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-22 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-01-22-2fa6c1a9-10084-0 | |
eab6c197f39a2727db02ab6b9ced24c041827350 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-22 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-01-22-2fa6c1a9-10084-0 | |
33572e19a818f51b16b65449d156d36c9192aa1a | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-22 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-01-22-2fa6c1a9-10084-0 | |
218339adc47ce1f4a93a7e54303edda0b711d8c5 | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-22 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-01-22-2fa6c1a9-10084-0 | |
7c30d5cdd25295b8e58cf4d56f1b5448ee897a5d | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-05 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-02-05-2fa6c1a9-10084-0 | |
1c80338ab455727375291518a7f105b39add07aa | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-05 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-02-05-2fa6c1a9-10084-0 | |
cc239f5239de33c0b83450674dc620b9b7388fad | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-05 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-02-05-2fa6c1a9-10084-0 | |
b45e8979bcb6c0ff730e72de3bcb172177ede761 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-05 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-02-05-2fa6c1a9-10084-0 | |
c88e20b533b2faaa7a3844595efbce3f8b1019fb | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-05 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-02-05-2fa6c1a9-10084-0 | |
f1a7f874886043c4721a65667a6dfe7f7785217a | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-02-19-2fa6c1a9-10084-0 | |
961ee87e94792cf5d0ad6c2c2bcf11530ca9ee36 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-02-19-2fa6c1a9-10084-0 | |
c035c965c26a359cad0ca13a2a386793b5d4a995 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-02-19-2fa6c1a9-10084-0 | |
e3ebecc25408bfa7b057d0faa8b6d4adf47a38d5 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-02-19-2fa6c1a9-10084-0 | |
c1a0ba5480673733b48e9b90b781bbf73cd6b4ba | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-02-19-2fa6c1a9-10084-0 | |
3b2060fde52933a24e0d3e27ebea6dc6e7a205ba | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-05 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-03-05-2fa6c1a9-10084-0 | |
fcdb28758399994bece90b6b0f8c1bac15026cb9 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-05 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-03-05-2fa6c1a9-10084-0 | |
4d4cc7245449abc23bd487fbd63297909d458d9a | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-05 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-03-05-2fa6c1a9-10084-0 | |
8b4050fb896c99c517c6e59051289ce570e78b5d | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-05 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-03-05-2fa6c1a9-10084-0 | |
80bf5ec7359bdb881bb40e4015d44c668c954e7e | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-05 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-03-05-2fa6c1a9-10084-0 | |
9320a9b2deeb9706d507ec48d38a8566a3c3292f | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-19 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-03-19-2fa6c1a9-10084-0 | |
19156de68a2484f38fe28b808bbe516c3825a851 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-19 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-03-19-2fa6c1a9-10084-0 | |
7c9e3f28c826a145af4e4c1fbe71a07a1b46d86c | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-19 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-03-19-2fa6c1a9-10084-0 | |
5c4430b180c625c5dcf27b4f730ad160a8f90748 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-19 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-03-19-2fa6c1a9-10084-0 | |
2a0de712f9e65742e1e5edba0e90b39e2f666ae4 | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-19 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-03-19-2fa6c1a9-10084-0 | |
4bfdc273c751749ccfbde0a6c8ac0aae53fe0d03 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-16 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-04-16-2fa6c1a9-10084-0 | |
b6a7edefc97ba794d2f8ea0cbb2cf20a18931fcc | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-16 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-04-16-2fa6c1a9-10084-0 | |
88c42b9759e9dd8bd7a0f329a66b1f49a8262e2b | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-16 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-04-16-2fa6c1a9-10084-0 | |
c7598819aaff189c4eda622e5b95ce5de0fa4540 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-16 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-04-16-2fa6c1a9-10084-0 | |
362f1590dbfdcdf160763440a969824e67f92e78 | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-16 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-04-16-2fa6c1a9-10084-0 | |
f8628fc11c0a6fdde136f9b059dff10d1e0a5d00 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-30 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-04-30-2fa6c1a9-10084-0 | |
cbed1f58e548cc3b52a1399d5bcb8002e9b7012b | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-30 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-04-30-2fa6c1a9-10084-0 | |
761153904691e8ac635ebaaaa90f7fa0f78738f0 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-30 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-04-30-2fa6c1a9-10084-0 | |
25eb3d0d5dcf10885d74b9f617501f4d5f77d8b7 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-30 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-04-30-2fa6c1a9-10084-0 | |
e758e013b375d550504d507248122d6bad13878a | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-30 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-04-30-2fa6c1a9-10084-0 | |
b638de16b4ca6b272c5c925bfa00fb018f227068 | 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 | 2018-04-30 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2018-04-30-2fa6c1a9-10084-0 | |
706cf6c9d555cf6b9c5c37345f40b37088065b2c | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-05-14 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-05-14-2fa6c1a9-10084-0 | |
063ae4ffbf38e388adfdb997be0c60c1dfc4aa2c | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-05-14 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-05-14-2fa6c1a9-10084-0 | |
d3303bf72cc01f6f6a31f79a9812fa728aa63c45 | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-05-14 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-05-14-2fa6c1a9-10084-0 | |
01369c72da3814bd6df4ca2f3ef7b1c4c4741368 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-05-14 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-05-14-2fa6c1a9-10084-0 | |
7234392e11d02968958bed7ee9e725e7dc72287a | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-05-14 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-05-14-2fa6c1a9-10084-0 | |
0dd98e69e271e7562fef94d477a3808efec091b4 | 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 | 2018-05-14 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2018-05-14-2fa6c1a9-10084-0 | |
521399fc2f6a4868ce06f01f1c4b10ceb1d0ad04 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-04 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-06-04-2fa6c1a9-10084-0 | |
fad3a53e731df4dc1a62c5fb88a0de5e2a042e3e | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-04 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-06-04-2fa6c1a9-10084-0 | |
4709070909ed4058736ad8a315e52c5e1300f53f | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-04 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-06-04-2fa6c1a9-10084-0 | |
4fec968a3596cdf32a6eb2a563bfacde54ed9321 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-04 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-06-04-2fa6c1a9-10084-0 | |
dd24186433d6073a38c4dcc966e22a3bca397ee7 | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-04 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-06-04-2fa6c1a9-10084-0 | |
be2a795b943cf767f0dc65b33516e1bd1ab17f58 | 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 | 2018-06-04 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2018-06-04-2fa6c1a9-10084-0 | |
4244c65878067a7784481d26c5b630e965160f0a | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-18 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-06-18-2fa6c1a9-10084-0 | |
d82f750f2e0f6030ec8173707be4478657eb63f2 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-18 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-06-18-2fa6c1a9-10084-0 | |
058bd0b66421fc2aa3850c3a493e5afac5109dee | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-18 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-06-18-2fa6c1a9-10084-0 | |
7ffbaf7a6991d7759b38332cc76268ff55c368a3 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-18 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-06-18-2fa6c1a9-10084-0 | |
0c46874ab0bab3a6e45be42fec8f0e0baf209109 | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-18 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-06-18-2fa6c1a9-10084-0 | |
24b4295d3e532fcdd5ec284f9fdbe12cf2f3188c | 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 | 2018-06-18 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2018-06-18-2fa6c1a9-10084-0 | |
41b0a7f101cede4da3d913df641547140fba8061 | 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 | 2018-06-18 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2018-06-18-2fa6c1a9-10084-0 | |
3aa77a9a820ff13302f156d0bc2ab13bb1aefc23 | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-02 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-07-02-2fa6c1a9-10084-0 | |
39a74af1b6cd33c9e75999703858e6f45f23c914 | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-02 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-07-02-2fa6c1a9-10084-0 | |
9d534182a92c574eedfc39f3e242914323d874ba | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-02 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-07-02-2fa6c1a9-10084-0 | |
3d16365c58d5fb6a738ef0206ae4b28471331a0f | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-02 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-07-02-2fa6c1a9-10084-0 | |
97b92bc6f92d0ccae317586a17fb40902e80559e | Name of donor: Sue Howes Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-02 | Vincent Cable uk.org.publicwhip/person/10084 | 4 | 2018-07-02-2fa6c1a9-10084-0 | |
b7910846c949d2cabc582801b389d3f5f2327778 | 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 | 2018-07-02 | Vincent Cable uk.org.publicwhip/person/10084 | 5 | 2018-07-02-2fa6c1a9-10084-0 | |
c91b9ac16a4b560df70ea952d2beea2bdda43a10 | 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 | 2018-07-02 | Vincent Cable uk.org.publicwhip/person/10084 | 6 | 2018-07-02-2fa6c1a9-10084-0 | |
b8450aa8888d12dcd7f0f3a3819aa5a765cbfcdf | Name of donor: Andrew Dixon Address of donor: private Amount of donation, or nature and value if donation in kind: £10,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-16 | Vincent Cable uk.org.publicwhip/person/10084 | 0 | 2018-07-16-2fa6c1a9-10084-0 | |
dee9aba9a9fcedbebb52c325384ae4cb4d7783fb | Name of donor: David Alliance Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-16 | Vincent Cable uk.org.publicwhip/person/10084 | 1 | 2018-07-16-2fa6c1a9-10084-0 | |
181b0e12c6513190cba77b76a1117ab3d7ec7ece | Name of donor: Joe Zammit-Lucia Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-16 | Vincent Cable uk.org.publicwhip/person/10084 | 2 | 2018-07-16-2fa6c1a9-10084-0 | |
560eafe111e1da4a993197316dc0d4bcf7b1e3f4 | Name of donor: Greg Dyke Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 received via my central party organisation, to support the Leader's Office Donor status: individual (Registered 07 December 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-16 | Vincent Cable uk.org.publicwhip/person/10084 | 3 | 2018-07-16-2fa6c1a9-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");