items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
140 rows where person_id = "uk.org.publicwhip/person/10383" and sort_order = 1 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
4d2d0f552f8016a69412b2d00956c9aaaf53970b | 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-11-27 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-11-27-2fa6c1a9-10383-0 | |
e8b3e25fd820c4304734ec91e882eb8b701e62b3 | 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-11-13 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-11-13-2fa6c1a9-10383-0 | |
0188be679a1b5db9156a0a89c3c53f636c29b132 | 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-10-23 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-10-23-2fa6c1a9-10383-0 | |
8075af2dc6ad6475f0a9559e559c0082b0222313 | 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-10-09 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-10-09-2fa6c1a9-10383-0 | |
b149f04b17d509b345bb01436e9d036099abf696 | 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-09-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-09-11-2fa6c1a9-10383-0 | |
1a510746d051a329f858d323004a1aecdf3cc637 | 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-08-29 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-08-29-2fa6c1a9-10383-0 | |
58411ed519700385ab0ab02e38f305931700f943 | 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-07-31 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-07-31-2fa6c1a9-10383-0 | |
93d6d6a66cdbefdd00c852ad3c2ed5b5fe4b5b6e | 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-07-07 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-07-07-2fa6c1a9-10383-0 | |
e703a6ef4d8627203ff3f1dea1e5249d4722c5be | 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-05-02 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-05-02-2fa6c1a9-10383-0 | |
8a4a51b0df5a34e586b817cb9098b88be8a1b298 | 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-04-10 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-04-10-2fa6c1a9-10383-1 | |
55bb31b07dd1c764844f75a091bf86fef0344f0b | 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-03-20 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-03-20-2fa6c1a9-10383-0 | |
7336994b64f0c4c1d629e08eb50fdd310696f5ee | 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-03-06 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-03-06-2fa6c1a9-10383-1 | |
4702b5b516806b3e6a02b4f2285ae790c9ed478e | 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-02-20 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-02-20-2fa6c1a9-10383-0 | |
db7742c60a834384479d3fd8314d5df68fb014d9 | 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-02-06 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-02-06-2fa6c1a9-10383-0 | |
4a06d2bfcd06e1fc5e90b922b38df88cda616fac | 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-01-23 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-01-23-2fa6c1a9-10383-0 | |
aabe025bc9d594f17a0d9cabaa48ea1a8683b9ed | 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-01-09 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2017-01-09-2fa6c1a9-10383-0 | |
5c12094eca12a7b44a1148211ce1da12d97e1f2d | 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 £8,026.90 Donor status: trade union (Registered 31 October 2016; updated 2 December 2016) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-12-19 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-12-19-2fa6c1a9-10383-0 | |
fb4e527e7847902ee5cceddaa0bc59292d9a2ea1 | 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 £8,026.90 Donor status: trade union (Registered 31 October 2016; updated 2 December 2016) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-12-05 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-12-05-2fa6c1a9-10383-0 | |
bc79be5bc97abcdb08dc266d97ecf7469b849c36 | 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 19 May 2017, value £39,109.79. Donor status: trade union (Registered 31 October 2016) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-11-21 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-11-21-2fa6c1a9-10383-0 | |
15c9889a2863c0d2b07bbf7720cfbf120975a89a | 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 19 May 2017, value £39,109.79. Donor status: trade union (Registered 31 October 2016) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-10-31 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-10-31-2fa6c1a9-10383-0 | |
66c3c92fb3e3bd7a2f4da8f75ae4fc5cc4428e0f | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-03-21 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-03-21-2fa6c1a9-10383-0 | |
af4af4282fef3ac1d5d4dcd4ce9b3a8870fc6e7b | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-03-07 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-03-07-2fa6c1a9-10383-0 | |
c1f3382c766a8f53a2408f530a0b1637a7e62d85 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-02-22 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-02-22-2fa6c1a9-10383-0 | |
e0dd5fd7ff0d31b9bee44faa61bd59a192d87230 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-02-08 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-02-08-2fa6c1a9-10383-0 | |
de59d9ee7029929ecce914f489b88f0e8d455886 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-01-25 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-01-25-2fa6c1a9-10383-0 | |
b9f08644af1036bbb8fb3e80adbe8e7e0ad18e84 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2016-01-11 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2016-01-11-2fa6c1a9-10383-0 | |
e78890d3cd00a315ab4e1ad231eb1aee7a1b4098 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-12-14 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-12-14-2fa6c1a9-10383-0 | |
864d24672bfc7034b164d5eb70e9d63581675e76 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-11-30 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-11-30-2fa6c1a9-10383-0 | |
95f1390a00eb7b6054dfd7b3697fcbffa3682cb4 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-11-09 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-11-09-2fa6c1a9-10383-0 | |
aa6ae3abb548e3253cc9d2ab31665a4e05dfd7a5 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-10-26 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-10-26-2fa6c1a9-10383-0 | |
54e4c00aa7984f2ccd60ea2f9de06fbe9ad8f344 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-10-12 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-10-12-2fa6c1a9-10383-0 | |
d5448e3bd5e0ed8a87126c12477b2695a05dc258 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-09-28 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-09-28-2fa6c1a9-10383-0 | |
12f3eea5c334611865f946d168bf9bc62c831e31 | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-09-07 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-09-07-2fa6c1a9-10383-0 | |
ac51135d0c5fcf586495e64242154652de5e542b | Name of donor: FBU (Fire Brigades Union) Address of donor: Bradley House, 68 Coombe Road, Kingston upon Thames, London KT2 7AE Amount of donation or nature and value if donation in kind: £3,000 Donor status: trade union (Registered 15 June 2015) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-08-10 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-08-10-2fa6c1a9-10383-0 | |
3d619353c99f6a440b1d019418e23c0b4c4b1b4f | Name of donor: RMT (Rail, Maritime and Transport Union) Address of donor: Unity House, 39 Charlton Street, London NW1 1JD Amount of donation or nature and value if donation in kind: £8,000 Donor status: trade union | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2015-07-13 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-07-13-2fa6c1a9-10383-0 | |
96b1394c3aef69d002ba4e47cfcf7c5d1fb29daf | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-03-30 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-03-30-8f616a6e-10383-1 |
5ad5a49c3b90bfb0cb691342bedaf30eda13c69d | Address of donor: Unity House, 39 Chalton Street, London NW1 1JD | Sponsorships 8f616a6e | 2015-03-30 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-03-30-8f616a6e-10383-2 |
089f20f1dbb142e1711e8f6feefd81b33aded11e | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-03-09 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-03-09-8f616a6e-10383-1 |
a4bfb7b812cc8085206f357b37ae848322a075f8 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-02-23 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-02-23-8f616a6e-10383-1 |
99db3475e1436a5b07963c81bf7f13670daa4c6b | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-02-09 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-02-09-8f616a6e-10383-1 |
048d112befb6c9ac04fe794448614e01af8bdb44 | Address of donor: Unite House, 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-01-26 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-01-26-8f616a6e-10383-1 |
398a178c53aed799b6a6fd90e9ba077228ecb14e | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-01-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2015-01-06-8f616a6e-10383-0 |
2b3433f68ec2b118135c702f6e08fc62641a874c | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-12-08 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-12-08-8f616a6e-10383-0 |
9efaa3ef0f76902dbbdf08bf2924649ac70e3e5a | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-11-24 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-11-24-8f616a6e-10383-0 |
9113188764d3ea8ac7135d69b7ae77cd706b00ea | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-11-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-11-10-8f616a6e-10383-0 |
3e765c663f559bec4f9945206a122fe7f92950db | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-10-27 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-10-27-8f616a6e-10383-0 |
cef2a76021ebf8cccfb3558ef269eac34690b5e6 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-10-13 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-10-13-8f616a6e-10383-0 |
eabccfe6940ec4793c50d1d2b74984e8dedd96c2 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-09-22 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-09-22-8f616a6e-10383-0 |
eebd1b2d57f8658db46e8a07d40d46561fd6ca76 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-08-26 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-08-26-8f616a6e-10383-0 |
f64f3949895350cb99ab3f3fb6e5000f99b51543 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-07-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-07-28-8f616a6e-10383-0 |
4064cb0cf9acd900e26ace4d889e50b8f9c48b76 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-07-14 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-07-14-8f616a6e-10383-0 |
977ed7a9fc66e70d185fb847df3e6dc69952d2a6 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-30 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-06-30-8f616a6e-10383-0 |
8fb8890d23d0a03c9b3e17520f25e3942224dc85 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-06-16-8f616a6e-10383-0 |
891c1c01069bbca47f7e88679fdd60b5f3a4ba64 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-02 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-06-02-8f616a6e-10383-0 |
d4743d2529837067e75054a647472342de6909ac | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-05-12 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-05-12-8f616a6e-10383-0 |
53ad671e1ee5ea3c66d665a1a820c03a4ff42702 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-04-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2014-04-28-8f616a6e-10383-0 |
0a3e122965a836859520ff9f2a8f4d16a5f3e920 | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-06-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-06-06-8f616a6e-10383-0 |
6a2c85ac1a0a8edcdf6d073de4f1b78b63d5859c | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-05-16-8f616a6e-10383-0 |
a878030bbc819e684df6fa8ddf547c17272c68cb | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-05-03 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-05-03-8f616a6e-10383-0 |
13f0791cb0df8dfbd9490e1200371f0616c48d0e | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-04-18 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-04-18-8f616a6e-10383-0 |
893c295fa98e46010df1028dda16f19e8df2be45 | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-03-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-03-28-8f616a6e-10383-0 |
1968b7510292e150c2b0f585a38bce064dddc3cf | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-03-14 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-03-14-8f616a6e-10383-0 |
ffafbcc27ff84d204762b4ce5b0c103216c6a5f0 | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-02-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-02-28-8f616a6e-10383-0 |
e3adf974ed64c7b4aef2c951686063d158b5e07e | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-02-07 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-02-07-8f616a6e-10383-0 |
78f4db80af7a04c75125e1cb2b97debfaeb254ec | Name of donor: Musicians Union | Sponsorships 8f616a6e | 2011-01-24 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 1 | 2011-01-24-8f616a6e-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");