items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where item = "Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017)" and person_id = "uk.org.publicwhip/person/10031" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
8f5180ae0551598b8370d4b43fcb09c0e021615e | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-07 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-07-07-2fa6c1a9-10031-0 | |
f4c11f20dd0829a7d40e53f9f51c2b224af96e93 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-07-31 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-07-31-2fa6c1a9-10031-0 | |
3ab21df3710d750b873e4e48aac6b149aeadd4f1 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-08-29 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-08-29-2fa6c1a9-10031-0 | |
f653a968035b8c3cc39a5184d816aa93bae9b181 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-09-11 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-09-11-2fa6c1a9-10031-0 | |
4e71001eb4a4c9de2638a497e1ec0ef90229a412 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-09 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-10-09-2fa6c1a9-10031-0 | |
ff0285135f6b67d922e55215118d557fa557532a | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-10-23 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-10-23-2fa6c1a9-10031-0 | |
7f2835b699e78b8aad8b68eee37b4c3080dd703e | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-13 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-11-13-2fa6c1a9-10031-0 | |
82b7e2bc8eb058f3788fd5877a5a1158ac44a0c6 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-11-27 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-11-27-2fa6c1a9-10031-0 | |
b181f4299e62ecb65c41d778919126b764365a24 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2017-12-11 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2017-12-11-2fa6c1a9-10031-0 | |
d660601b40a8eebeb85d6d4e94671bd6827dcae5 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-08 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-01-08-2fa6c1a9-10031-0 | |
3b80e64679e3d630d244977912e2d16a93e7abb5 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-01-22 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-01-22-2fa6c1a9-10031-0 | |
fe18a67dfc305a05206adb9737c461241af1da5b | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-05 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-02-05-2fa6c1a9-10031-0 | |
aa8912e3a78601a0bd40bc36f67e6cea7252016d | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-02-19-2fa6c1a9-10031-0 | |
d4872c34797fde76aeec84b411ad2133cec02196 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-05 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-03-05-2fa6c1a9-10031-0 | |
6fdbcaf88ee4625c55deb681ad0f2c9d386eb974 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-03-19 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-03-19-2fa6c1a9-10031-0 | |
50b6e8b362574745b5b9243f80d99b348117e6cd | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-16 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-04-16-2fa6c1a9-10031-0 | |
96f5fb2f832bbec13e5764f0d667e50ae72b079d | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-04-30 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-04-30-2fa6c1a9-10031-0 | |
3c42367c877a15ad23f4d012fe12bea1fd415b40 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-05-14 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-05-14-2fa6c1a9-10031-0 | |
dad2ba3db95b15a2735dd0236a0c2ed84eb4d756 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-04 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-06-04-2fa6c1a9-10031-0 | |
ea1820a32d0bfa8bbdc006dd30ac0cf5d4e04add | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-06-18 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-06-18-2fa6c1a9-10031-0 | |
27e51a477e19617dbd668b8e02921ad7b05f8194 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-02 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-07-02-2fa6c1a9-10031-0 | |
3eb6ce459118270f1abc8873decb8d07cc162ba2 | Name of donor: Unite the Union Address of donor: 128 Theobalds Road, Holborn, London WC1X 8TN Amount of donation or nature and value if donation in kind: £2,000 Donor status: trade union (Registered 07 July 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-07-16 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2018-07-16-2fa6c1a9-10031-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");