items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
487 rows where person_id = "uk.org.publicwhip/person/25392" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
c80f02c2152372e2471ee21c6de3c0cf0dc056e1 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-06-08 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-06-08-70b64e89-25392-0 | |
cfed81ac7385deeb06ff4c7c479bed358e05e146 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-07-13 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-07-13-70b64e89-25392-0 | |
8da09261a27e23f231ecff7e1ad2ecc9dcab853f | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-08-10 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-08-10-70b64e89-25392-0 | |
c90037fe1975272f609031ee5a1f0d8391f0d727 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-09-07 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-09-07-70b64e89-25392-0 | |
f561b2fe21a7acd7ca3121e160ea0fba1db30098 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-09-28 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-09-28-70b64e89-25392-0 | |
cbb1067c096ee4a9a2f6137ed113a386d701a11a | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-10-12 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-10-12-70b64e89-25392-0 | |
ad545a93483dcaea934115c8a4f875cabc15bfa6 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-10-26 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-10-26-70b64e89-25392-0 | |
544544d913a6888b45cdfdbd94386c55642b281f | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-11-09 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-11-09-70b64e89-25392-0 | |
d63c0ad8f657df71a6c2fb240d8de718301c62d2 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-11-30 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-11-30-70b64e89-25392-0 | |
619ec656a14391cf6a67361851230d80d2a680c1 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2015-12-14 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2015-12-14-70b64e89-25392-0 | |
7a533f69c047e3cf892519c77b9afebab18d9e53 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-01-11 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-01-11-70b64e89-25392-0 | |
e024459949336626bd495f7f367ef19715ba6fa6 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-01-25 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-01-25-70b64e89-25392-0 | |
17e79a24bd8ab82f1ae9ba42f83f20ae5cb598dd | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-02-08 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-02-08-70b64e89-25392-0 | |
a765af396030a5f422978636c5f62d8ab3e744a3 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-02-08 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-02-08-5f2cbd10-25392-0 | |
47e643b3f8054a8d8f16ff40f6079c78499d3f2d | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-02-22 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-02-22-70b64e89-25392-0 | |
5ab6356b608ec8c811eaa204a44a7945ac13434e | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-02-22 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-02-22-5f2cbd10-25392-0 | |
467b4decc8b183c713d5e19f76c2a65240ee569f | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-03-07 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-03-07-70b64e89-25392-0 | |
a1de8c426b0cad9ea8f7a91295c3d42c31a8be33 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-03-07 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-03-07-5f2cbd10-25392-0 | |
2da3e4b5a17e4f79abc5852f1b65a8fc833e75bc | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-03-21 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-03-21-70b64e89-25392-0 | |
5a0b22c20a326657be6f763fb0d178c2b8afde01 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-03-21 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-03-21-5f2cbd10-25392-0 | |
fd9258c81473828b02d6605781f5d5d406700dd3 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-04-18 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-04-18-70b64e89-25392-0 | |
06141998848ae2285dd8b03fe052bfb548b48b1e | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-04-18 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-04-18-891eb863-25392-0 | |
03e7ea45a95da7b102d4ab4677f20cc9d52e43fe | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-04-18 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-04-18-5f2cbd10-25392-0 | |
08f4488fce21d7814ba1f58882a43c52409d6e30 | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-05-03 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-05-03-70b64e89-25392-0 | |
ffc872678e6a1d4772a51e645d4914f19345da77 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-05-03 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-05-03-891eb863-25392-0 | |
10bd526ea4b41d6db0ec3347997265f1b82cc83d | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-05-03 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-05-03-5f2cbd10-25392-0 | |
b7e471878a08b7f8a3d64ccf190b23aabbdb82aa | Name of donor: Lord Farmer Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 19 December 2014 Date accepted: 19 December 2014 Donor status: individual (Registered 26 May 2015) | (b) Any other support not included in Category 2(a) 70b64e89 | 2016-05-16 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-05-16-70b64e89-25392-0 | |
32423c8785f90e1426e04694ededec3451add54a | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-05-16 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-05-16-891eb863-25392-0 | |
5e6cfd5f21398e131873d15d0712be0c6d9c0666 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-05-16 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-05-16-5f2cbd10-25392-0 | |
080e2d16b38f368a63346dd71ff1106742082894 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-06-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-06-06-891eb863-25392-0 | |
68944399fd9d9bf417cda54715d5763f537c580b | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-06-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-06-06-5f2cbd10-25392-0 | |
8fa8a8945894f72518b9551c78341ad4f5f0c200 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-06-27 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-06-27-891eb863-25392-0 | |
bc3eb0063fae8d7543ea6b70741091fd47b97740 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-06-27 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-06-27-5f2cbd10-25392-0 | |
d333609e9bba56583e803f22c69270346dac811a | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-07-11 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-07-11-891eb863-25392-0 | |
6dd25c9304864ad50690eecb44769d383e71cb5b | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-07-11 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-07-11-5f2cbd10-25392-0 | |
b24ce0ecfd3bd2bdad21a05fdfd6b578dd9bc22e | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-08-01 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-08-01-891eb863-25392-0 | |
1d3de6aab3e19f4052b8861708b1d782caed0c91 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-08-01 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-08-01-5f2cbd10-25392-0 | |
488a4768269885bad16f26f086254948d0e3ecd6 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-09-05 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-09-05-891eb863-25392-0 | |
12e430ee02223f213b2813f5d8329e6800aaabe0 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-09-05 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-09-05-5f2cbd10-25392-0 | |
f890654ce8d8ae24f9513e9be8037139e04c28b9 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-10-03 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-10-03-891eb863-25392-0 | |
fa3220d80a4f1822296c2274e35cb3b8a8b2d8e5 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-10-03 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-10-03-5f2cbd10-25392-0 | |
ecbc96b34be0720d03af30c066bc6f0a4c80129e | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-10-17 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-10-17-891eb863-25392-0 | |
f1c5dce7a13cbe6655b29dee07c12aed638b71cd | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-10-17 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-10-17-5f2cbd10-25392-0 | |
5d7134e9584cff52b3767bc5c7f9fd31dd1141b7 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-10-31 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-10-31-891eb863-25392-0 | |
725e03bd3c03d4b093f5d015806dc8797733a881 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-10-31 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-10-31-5f2cbd10-25392-0 | |
67145661533d709857bd014648ce7704430a8e33 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-11-21 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-11-21-891eb863-25392-0 | |
c4ff071bfdf9a5f1eb93feec385339b179652f12 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-11-21 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-11-21-5f2cbd10-25392-0 | |
3d2bdc716df03956fa14991d0ba07d32eeeb9366 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-12-05 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-12-05-891eb863-25392-0 | |
4331ee261aa06f6036e36c651145d99b1d988904 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-12-05 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-12-05-5f2cbd10-25392-0 | |
14b7747b2f40b8713590551222f300b20ebcf838 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2016-12-19 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-12-19-891eb863-25392-0 | |
1040187e1ce6ed63f9c5f68b788c8b52748a89d5 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2016-12-19 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2016-12-19-5f2cbd10-25392-0 | |
1e919bf3c698e140330a4886102ef09c031908fd | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2017-01-09 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-01-09-891eb863-25392-0 | |
bfbc7eb2477c805c8ade82fb004e70f27de54c26 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-01-09 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-01-09-5f2cbd10-25392-0 | |
ea1b19adf26801ca4551213523a26acf59d12ebe | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2017-01-23 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-01-23-891eb863-25392-0 | |
8968952eacc0056a39198d844bc254c702b271e9 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-01-23 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-01-23-5f2cbd10-25392-0 | |
b4e3812780188c6e7999da55b48584863137354e | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2017-02-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-02-06-891eb863-25392-0 | |
fd01312268927e0b8d5c15bab348b5eeed9f981e | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-02-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-02-06-5f2cbd10-25392-0 | |
982629e7f1fbdd26c7ee63940e6c031b1f4651f7 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2017-02-20 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-02-20-891eb863-25392-0 | |
cfd8462bf9b1d1dfc1ebbdebbee1ed01d6407e3a | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-02-20 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-02-20-5f2cbd10-25392-0 | |
9c71850965e44a5253e4c76cbfa0f8fd535e867b | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2017-03-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-03-06-891eb863-25392-0 | |
fec7990696b14d796e6714efd95194e97d5ab306 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-03-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-03-06-5f2cbd10-25392-0 | |
54bad7464f4325e5f022270cd03fa1fcb2d92fae | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2017-03-20 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-03-20-891eb863-25392-0 | |
65114ff0758b3b23709c8e7ea013926046e87664 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-03-20 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-03-20-5f2cbd10-25392-0 | |
97f499794f780233a0c83e01e37ec23ecf8b1098 | Name of donor: United Arab Emirates Ministry of Foreign Affairs Address of donor: Al Bateen, Abu Dhabi, United Arab Emirates Amount of donation (or estimate of the probable value): travel and accommodation with a total value of £2,800 Destination of visit: United Arab Emirates Date of visit: 1-6 April 2016 Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures to build on the bilateral relationship and promote trade and investment ties. (Registered 12 April 2016) | Visits outside the UK 891eb863 | 2017-04-10 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-04-10-891eb863-25392-0 | |
0c2e529f5fd430b7edb8c91b733bbb25346abeba | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-04-10 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-04-10-5f2cbd10-25392-0 | |
3872a7bf844039c380e734777508ce1c89215a68 | Name of donor: Human Appeal Address of donor: Carrs Road, Cheadle, Manchester SK8 2BL Estimate of the probable value (or amount of any donation): flights, accommodation, food and transport with a value of £1,350 Destination of visit: West Bank and Israel Dates of visit: 6-10 October 2016 Purpose of visit: Fact finding visit organised by the Council for Arab-British Understanding and Human Appeal. (Registered 18 October 2016) | Visits outside the UK 891eb863 | 2017-05-02 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-05-02-891eb863-25392-0 | |
6805b04bebb695bf02d9aac1c8521aec8ad8c0c9 | From 20 January 2016, Honorary Vice-President of the Society of Maritime Industries. (Registered 27 January 2016) | Miscellaneous 5f2cbd10 | 2017-05-02 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2017-05-02-5f2cbd10-25392-0 | |
c32db0735be3b1eb9ab958b002aab323c9858e22 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-01-11 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-01-11-2fa6c1a9-25392-0 | |
e6aab885ea7ee4d594f2ae7ceb8f7e7dd5f077f9 | Board member of National Citizens' Service (NCS); on unpaid leave. (Registered 07 January 2020) | Miscellaneous 5f2cbd10 | 2020-01-11 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-01-11-5f2cbd10-25392-0 | |
ec1c1a6f0d533c6ccd49ca7c362d8d7a9e13a423 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-02-10 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-02-10-2fa6c1a9-25392-0 | |
216a571af92469d3cd40ff9fcc6cc3809cf57891 | Board member of National Citizens' Service (NCS); on unpaid leave. (Registered 07 January 2020) | Miscellaneous 5f2cbd10 | 2020-02-10 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-02-10-5f2cbd10-25392-0 | |
4ff9bd341c85c0990a7576eba349e108aaff6891 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-03-02 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-03-02-2fa6c1a9-25392-0 | |
be1239ecdc5ae3d6b71935fbf8c62e918393f6a0 | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-03-02 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-03-02-5f2cbd10-25392-0 | |
773b760cbcd03e29509b612cb5ec9fab69a6cb04 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-03-16 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-03-16-2fa6c1a9-25392-0 | |
e2fb2ac15b596b7f83d3501a4a2c9f08a8ca9894 | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-03-16 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-03-16-5f2cbd10-25392-0 | |
327c73c980858a29ec0cf7beda2ee2e6e36da225 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-03-30 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-03-30-2fa6c1a9-25392-0 | |
fad7aa15f368be18b87765e887028d7280e9c6ed | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-03-30 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-03-30-5f2cbd10-25392-0 | |
e8edf5cb32f52f7f7c496619b0b0e87b7667f307 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-04-14 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-04-14-2fa6c1a9-25392-0 | |
722c3d58693b104bcde41208f38ffcf709f1ee7a | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-04-14 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-04-14-5f2cbd10-25392-0 | |
e713f9f72da763a4cc829e40f4fc6a7b3f249766 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-04-27 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-04-27-2fa6c1a9-25392-0 | |
252748351b3d70797d1d912c43ed8417338f099d | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-04-27 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-04-27-5f2cbd10-25392-0 | |
65a4af4f706e1e70b55cfd7d1f93240eb0cd72bb | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-05-11 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-05-11-2fa6c1a9-25392-0 | |
ba24df2c4dbe2e59c800301a6a19b6ce9733505b | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-05-11 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-05-11-5f2cbd10-25392-0 | |
c271d063067147c843e95eea764a4730b10d6050 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-05-26 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-05-26-2fa6c1a9-25392-0 | |
b36e83c9738c431811fe625451a51cb03c3525b5 | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-05-26 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-05-26-5f2cbd10-25392-0 | |
e0a4a6b8982a7fd2d2b20fe024207f3d492567ad | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-06-08 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-06-08-2fa6c1a9-25392-0 | |
7487391b1a523d9bedfdccb7a054d4cc8f3ed68e | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-06-08 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-06-08-5f2cbd10-25392-0 | |
23f25001d01c58d915855f3d914a13379083f68c | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-06-22 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-06-22-2fa6c1a9-25392-0 | |
618d3992c04e1f48b1c77dc7f4dbfa4949c7b46f | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-06-22 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-06-22-5f2cbd10-25392-0 | |
a9ee70b5e0f14e8000bc7d91ad4b2c82dad81e34 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-07-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-07-06-2fa6c1a9-25392-0 | |
cb870a661068be0d26beecf015f4542cc6aeac3f | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-07-06 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-07-06-5f2cbd10-25392-0 | |
f18a9e4cf101a8d31ad664fbf1fa54b231a784a0 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-07-20 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-07-20-2fa6c1a9-25392-0 | |
6e88815f98bcb5d6196d470ed0e23f2e747b419e | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-07-20 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-07-20-5f2cbd10-25392-0 | |
aa1a3643e8daefb60bfb3468fb6bae221ac04029 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-08-10 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-08-10-2fa6c1a9-25392-0 | |
40d780a331edcb37242389c823a433b43d36736c | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-08-10 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-08-10-5f2cbd10-25392-0 | |
2124c2fc22d1c432a9e588b5cd3fded9f807344c | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-09-01 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-09-01-2fa6c1a9-25392-0 | |
dc87e0ec627aeb694931f04b7fe28bd2a3910108 | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-09-01 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-09-01-5f2cbd10-25392-0 | |
52b97dc6a19712b968ffeca9c1b6122b8b417b32 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-09-14 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-09-14-2fa6c1a9-25392-0 | |
b3323b085d8a0fed869f5b62af67ec0bbc217a3e | Until 4 February 2020, Board member of National Citizens' Service (NCS). I was on unpaid leave since 13 December 2019. (Registered 07 January 2020; updated 24 February 2020) | Miscellaneous 5f2cbd10 | 2020-09-14 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-09-14-5f2cbd10-25392-0 | |
0d1ffadbe79d7f423aff9a63d62c55b296718ea2 | Name of donor: Malcolm Isaac Address of donor: private Amount of donation, or nature and value if donation in kind: £5,000 Donor status: individual (Registered 07 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-09-28 | Flick Drummond uk.org.publicwhip/person/25392 | 0 | 2020-09-28-2fa6c1a9-25392-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");