items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
730 rows where person_id = "uk.org.publicwhip/person/10383" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, member_id, sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
1dc646b3e80beeec11d998371a75cc0a232b6517 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2021-01-18 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2021-01-18-2fa6c1a9-10383-0 | |
32f2430e71003581bcebe4096051ff7e354a35da | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2021-01-04 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2021-01-04-2fa6c1a9-10383-0 | |
fc217323f8eec4bedf402d0f4c7f54438acca5ae | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-12-21 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-12-21-2fa6c1a9-10383-0 | |
323f278412e4241ecd0b1cae6d50c3031af8ccbe | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-12-07 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-12-07-2fa6c1a9-10383-0 | |
dbe730bda3f911c5f8d6582e9b001b12d2643e72 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-11-23 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-11-23-2fa6c1a9-10383-0 | |
0a7ec05fd44bc9b39c3220ff4f890a602bc29cda | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-11-09 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-11-09-2fa6c1a9-10383-0 | |
c7bfc60d5a9968a2e3f716b43634bc8dabdaef58 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-10-26 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-10-26-2fa6c1a9-10383-0 | |
e77b4b44409de022b7ff0ddfbf2d47838ed0ae48 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 January 2020) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2020-10-12 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-10-12-2fa6c1a9-10383-0 | |
8d0b83435e03beed8f52676607a8adb34a478bf5 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-09-28-2fa6c1a9-10383-0 | |
f334883ff825df91cb7a0cd3148a2ecb0c246873 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-09-14-2fa6c1a9-10383-0 | |
457d5859af92c6ebd30e488b49c4192838f9542b | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-09-01-2fa6c1a9-10383-0 | |
605b49011ca9fb4bfd7819599ae25712f2af4215 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-08-10 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-08-10-10057ffd-10383-0 | |
68544ac9963da1402b8922e31b9845a7da04ed80 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-08-10 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-08-10-10057ffd-10383-0 | |
bd716b66c6e71e78638a8f248454b7858b37d14f | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-08-10-2fa6c1a9-10383-0 | |
6170efbf742c400759aa0a879b87e22481e9fa79 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-07-20 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-07-20-10057ffd-10383-0 | |
802e4c9e972cb2a34f85042ee9fee6dfcf532762 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-07-20 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-07-20-10057ffd-10383-0 | |
ff85fb56325e2201cde19f2b5d45f4e58ea667bb | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-07-20-2fa6c1a9-10383-0 | |
f03777f397a84473f29d4decb23aadb61291499d | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-07-06 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-07-06-10057ffd-10383-0 | |
6804b64d9e7208eeb8a613d80e0d2fe8f62177dd | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-07-06 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-07-06-10057ffd-10383-0 | |
9425693b3ec26cf1b3405fedae1c38827094c365 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-07-06-2fa6c1a9-10383-0 | |
f83855150df7d1cee01b72016f7f5e77d6dab861 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-06-22 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-06-22-10057ffd-10383-0 | |
bcdeb1ec723c94fb7a8b9c2c144bec65e4979995 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-06-22 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-06-22-10057ffd-10383-0 | |
dea43242ccf54f9adda432bf3665ce8030d31b3a | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-06-22-2fa6c1a9-10383-0 | |
cbb1eabe9c878198f9b349a3e4111a0c05515cc2 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-06-08 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-06-08-10057ffd-10383-0 | |
9334918a150153d3e7013193bb97c177aaa52dfa | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-06-08 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-06-08-10057ffd-10383-0 | |
682db3d83d2969df3f2fddc972ea19634e9fe794 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-06-08-2fa6c1a9-10383-0 | |
5993327a9bfa625223f88ec9687b3318447e2a63 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-05-26 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-05-26-10057ffd-10383-0 | |
8af9e9f60a90359f9cbbe3e38c41943a780ec250 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-05-26 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-05-26-10057ffd-10383-0 | |
babb98eb51771def8df21593303a9d637b7f762f | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-05-26-2fa6c1a9-10383-0 | |
f64a33a7f279e8f45492a29320fb20cb0f1b8cfd | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-05-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-05-11-10057ffd-10383-0 | |
11dcdecfa75fd87169fb78991305ce9000a29630 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-05-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-05-11-10057ffd-10383-0 | |
5a318430abcf9091c29dfa5b283343f9a9be34f2 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-05-11-2fa6c1a9-10383-0 | |
f6fbb1d7206b6ed3adfb24441c407f17a79b180c | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-04-27 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-04-27-10057ffd-10383-0 | |
2be0448c09cda4beb98893988503ecb125e388d1 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-04-27 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-04-27-10057ffd-10383-0 | |
b7e0eee8fee66136deb7746fd05026153364c98b | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-04-27-2fa6c1a9-10383-0 | |
612a1a414b12a94f84e3cec843f0684d829c949d | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-04-14 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-04-14-10057ffd-10383-0 | |
feb5937311c2b3aca83999638e9d7acc93f03d2f | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-04-14 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-04-14-10057ffd-10383-0 | |
d792e25287221b839f54e17c8a63589c5dbf6b2b | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-04-14-2fa6c1a9-10383-0 | |
f2c68a706aea77a956966e7a872d44c749155247 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-03-30 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-03-30-10057ffd-10383-0 | |
eb9a1e903a0ec5ccfabb3b09f88ed5d86268e8d6 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-03-30 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-03-30-10057ffd-10383-0 | |
fbb55b736882d65142281979904679aa66b4630d | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-03-30-2fa6c1a9-10383-0 | |
7bb2cd71b47c51ea4163de999ccb3068380fae76 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-03-16 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-03-16-10057ffd-10383-0 | |
0b7844d229e503f85772279b7b24d60449e9f956 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-03-16 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-03-16-10057ffd-10383-0 | |
472a30313af570f406e6ec151033ab3d87cd38c6 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-03-16-2fa6c1a9-10383-0 | |
9dc264d9e7dd03704b232c3c330d5bd4f57af0f7 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-03-02 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-03-02-10057ffd-10383-0 | |
7bdd572a567ed622398879af814cb1c2e794b758 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-03-02 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-03-02-10057ffd-10383-0 | |
c0cb990c3d822ec8e317f06670bddd790bbacf1f | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-03-02-2fa6c1a9-10383-0 | |
bf0b618981f0921ebd6ae3835badb535b6ff25f7 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-02-10 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-02-10-10057ffd-10383-0 | |
eb86a74f547e76f09162dcb665bdcabde8488e54 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-02-10 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-02-10-10057ffd-10383-0 | |
26d4b7a3a8bc1118d2f288c971ce51059196bffd | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-02-10-2fa6c1a9-10383-0 | |
aeb429871ac8361e066113af18b1e8ea57cad40b | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2020-01-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-01-11-10057ffd-10383-0 | |
284b4db18b0f8333d76abcc5ad482eece92acbe3 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2020-01-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2020-01-11-10057ffd-10383-0 | |
578b3f5c04beb5a6f62520d9770083688c5fd040 | Name of donor: RMT Address of donor: Unity House 39 Charlton Street, London NW1 1DU Amount of donation, or nature and value if donation in kind: £8,325 Donor status: trade union (Registered 10 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2020-01-11-2fa6c1a9-10383-0 | |
24e6cc25b2995c6d5188ee5abf626a6e4f34717f | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2019-11-05 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2019-11-05-10057ffd-10383-0 | |
fb6363e9ca50c7c404cd978cb086169d81b0e935 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2019-11-05 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2019-11-05-10057ffd-10383-0 | |
438ffe76b1083468515cce5a613e7a1d5a8dd15f | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2019-10-21 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2019-10-21-10057ffd-10383-0 | |
072811f03e4faaaa1a310244b6c3591ad2a0489e | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2019-10-21 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2019-10-21-10057ffd-10383-0 | |
bb8aacadfded96138581ab417b565e300f35e180 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2019-09-30 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2019-09-30-10057ffd-10383-0 | |
18f9fb3904e7cfd83a60ce22eeeffaeeb87c763a | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2019-09-30 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2019-09-30-10057ffd-10383-0 | |
2d51fd228a5fc8722180b5dd22ab6f99845831f4 | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2019-09-16 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2019-09-16-10057ffd-10383-0 | |
8d27e8d88e5ba7b84155c2302e2680d7122644fe | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2019-09-16 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2019-09-16-10057ffd-10383-0 | |
ba401548e8c96b8856c3672fa80bce148427e27b | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2019-09-02 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2019-09-02-10057ffd-10383-0 | |
0c4e863bc4f46e5d7d754970e3bcf6223e312679 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2019-09-02 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2019-09-02-10057ffd-10383-0 | |
a12f64f4e56798d20d37afcdfabfa953c3ccc03b | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2019-08-12 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2019-08-12-10057ffd-10383-0 | |
1835b2e9a3a82cc9060313886a2ab9430c6c63d1 | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. Payment, minus tax owed, donated to the Labour Party. (Registered 22 July 2019; updated 02 August 2019) | Employment and earnings 10057ffd | 2019-08-12 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2019-08-12-10057ffd-10383-0 | |
af39f535b3da40616f638d5250033ab1b834e18d | Payments from Verso, 6 Mead St, London W1F 0EG, for editing and providing an introduction to a book of 16 essays: | Employment and earnings 10057ffd | 2019-07-29 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2019-07-29-10057ffd-10383-0 | |
26ff7da23392822a4bcddf8f544199d28e7966dd | 26 June 2019, received £2,000 as advance upon publication. Hours: 10 hrs. (Registered 22 July 2019) | Employment and earnings 10057ffd | 2019-07-29 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2019-07-29-10057ffd-10383-0 | |
64ced9777c1819fc781cb47952b94de00e819345 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-07-16-2fa6c1a9-10383-0 | |
a0b6e2c75207889e334bd59790622e2dbab50b45 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-07-16-2fa6c1a9-10383-0 | |
e0ebaf06bf5e018866821a2be3c3e7f28d015605 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-07-02-2fa6c1a9-10383-0 | |
19ea5e281f811ccc31ed4dc548ad44d15f902d76 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-07-02-2fa6c1a9-10383-0 | |
e3cff203bcb8a176e9ee4e058d3e70e2e25fa155 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-06-18-2fa6c1a9-10383-0 | |
520b405bbde9e3773e6375adf54092f009226205 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-06-18-2fa6c1a9-10383-0 | |
0df722106b70af3aaa428601ad3de827d62fb994 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-06-04-2fa6c1a9-10383-0 | |
50c8cc62c6d8d0a2a3c17ed0628861babbc2a918 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-06-04-2fa6c1a9-10383-0 | |
2f5e849d82dfa5822f81219b75c3aace720f8026 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-05-14-2fa6c1a9-10383-0 | |
8009ae01e997b6fcafcdd000b17bc9d67a5a0a43 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-05-14-2fa6c1a9-10383-0 | |
6589ab5ac22959db8591a45b018500044c03c809 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-04-30-2fa6c1a9-10383-0 | |
8b327dab4510ced8d05437f184008bfbaf8b9044 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-04-30-2fa6c1a9-10383-0 | |
11898987a542134780c7798844d810335a567ecf | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-04-16-2fa6c1a9-10383-0 | |
700e12d87870000f3b376aceff8592156e15a647 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-04-16-2fa6c1a9-10383-0 | |
7b912459c7df75d8a2d1da714e18b18547e8ed11 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-03-19-2fa6c1a9-10383-0 | |
533b6faa6a1600b2483b2b372824024986fea518 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-03-19-2fa6c1a9-10383-0 | |
fa5532c2bf4704fd944fd6b5eb7456963dd0e714 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-03-05-2fa6c1a9-10383-0 | |
4afb355cd632013b5fbce0a3c8c664d757aa984d | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-03-05-2fa6c1a9-10383-0 | |
4927b7abe0c7ac3e4c3a52b255a4dca3a153b1bf | Name of donor: TSSA Address of donor: Walkden House, 10 Melton St, London NW1 2EJ Amount of donation or nature and value if donation in kind: Secondment of an economic adviser from 10 December 2015 to 26 July 2016, value £5,897.79 Donor status: trade union (Registered 22 July 2016; updated 31 October 2016 and 22 December 2016) This payment is a late entry to which the rectification procedure was applied on 14 February 2017. Paragraph 16 of Chapter 4 of the 2015 Guide to the Rules refers. | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-02-19-2fa6c1a9-10383-0 | |
29c793a82137af4af555ee2f0932fafbb536471f | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-02-19-2fa6c1a9-10383-0 | |
b55b24bd6ead56889eb713983f077389271cf560 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 2 | 2018-02-19-2fa6c1a9-10383-0 | |
17b8ec46e6d5679947ea5f3246f2d27d45697d26 | Name of donor: TSSA Address of donor: Walkden House, 10 Melton St, London NW1 2EJ Amount of donation or nature and value if donation in kind: Secondment of an economic adviser from 10 December 2015 to 26 July 2016, value £5,897.79 Donor status: trade union (Registered 22 July 2016; updated 31 October 2016 and 22 December 2016) This payment is a late entry to which the rectification procedure was applied on 14 February 2017. Paragraph 16 of Chapter 4 of the 2015 Guide to the Rules refers. | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-05 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-02-05-2fa6c1a9-10383-0 | |
695f0f6041850982e8cc5deed5443dbc30a1e553 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-02-05-2fa6c1a9-10383-0 | |
88a8d7afbcdc096acc09948013b92f5a043434e9 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 2 | 2018-02-05-2fa6c1a9-10383-0 | |
3775f1b943e3e68589472d9fd479be8089cb1022 | Name of donor: TSSA Address of donor: Walkden House, 10 Melton St, London NW1 2EJ Amount of donation or nature and value if donation in kind: Secondment of an economic adviser from 10 December 2015 to 26 July 2016, value £5,897.79 Donor status: trade union (Registered 22 July 2016; updated 31 October 2016 and 22 December 2016) This payment is a late entry to which the rectification procedure was applied on 14 February 2017. Paragraph 16 of Chapter 4 of the 2015 Guide to the Rules refers. | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-22 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-01-22-2fa6c1a9-10383-0 | |
8a8a439a9b0ca860cf81eb37e5ea80e76f56d680 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-01-22-2fa6c1a9-10383-0 | |
10ecb6a33a3cc8028a0724958650f699d1323749 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 2 | 2018-01-22-2fa6c1a9-10383-0 | |
0ffcd0bd407818f6705b918ab64524903222825e | Name of donor: TSSA Address of donor: Walkden House, 10 Melton St, London NW1 2EJ Amount of donation or nature and value if donation in kind: Secondment of an economic adviser from 10 December 2015 to 26 July 2016, value £5,897.79 Donor status: trade union (Registered 22 July 2016; updated 31 October 2016 and 22 December 2016) This payment is a late entry to which the rectification procedure was applied on 14 February 2017. Paragraph 16 of Chapter 4 of the 2015 Guide to the Rules refers. | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-08 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2018-01-08-2fa6c1a9-10383-0 | |
6c6401e4d39f0bf4447592d7de9d8aa2e93bb8b6 | Name of donor: RMT Address of donor: 39 Chalton Street, King's Cross, London NW1 1DU Amount of donation or nature and value if donation in kind: £8,650 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2018-01-08-2fa6c1a9-10383-0 | |
7c62effff5419ac2010d2c3f43825217043d9b3d | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, London WC1X 8TN Amount of donation or nature and value if donation in kind: £4,000 Donor status: trade union (Registered 06 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 | John Martin McDonnell uk.org.publicwhip/person/10383 | 2 | 2018-01-08-2fa6c1a9-10383-0 | |
89b41f01dfc528be9c7ccb98b9eb135284982847 | Name of donor: TSSA Address of donor: Walkden House, 10 Melton St, London NW1 2EJ Amount of donation or nature and value if donation in kind: Secondment of an economic adviser from 10 December 2015 to 26 July 2016, value £5,897.79 Donor status: trade union (Registered 22 July 2016; updated 31 October 2016 and 22 December 2016) This payment is a late entry to which the rectification procedure was applied on 14 February 2017. Paragraph 16 of Chapter 4 of the 2015 Guide to the Rules refers. | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 0 | 2017-12-11-2fa6c1a9-10383-0 | |
45a681c34283e0f647b6ef093b9a5bd6cd3f54c8 | Name of donor: TSSA Address of donor: Walkden House, 10 Melton St, London NW1 2EJ Amount of donation or nature and value if donation in kind: Secondment of an economic adviser from 3 October 2016 to 18 November 2016, value £1,240.10 Donor status: trade union (Registered 31 October 2016 ; updated 2 December 2016 and 22 December 2016) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-12-11-2fa6c1a9-10383-0 | |
1396716cb6e758724b03d86fd409fac97e4628e9 | Name of donor: CWU Address of donor: CWU, 150 The Broadway, Wimbledon, London, SW19 1RX Amount of donation or nature and value if donation in kind: contribution to costs incurred by TSSA in seconding an economic adviser from 10 December 2015 to 26 July 2016 and from 3 October 2016 to 18 November 2016, value £20,000. Donor status: trade union (Registered 22 December 2016) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 2 | 2017-12-11-2fa6c1a9-10383-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");