items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2020-12-07-2fa6c1a9-24864-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 076cb4aee4354f560cd88632c6f6eaa064e54a3e | Name of donor: Stalbury Trustees Address of donor: 31 Hill Street, London W1J 4LS Amount of donation or nature and value if donation in kind: £3,000 for my General Election 2019 fighting fund Donor status: company, registration 01430799 (Registered 11 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 | Stuart Andrew uk.org.publicwhip/person/24864 | 0 | 2020-12-07-2fa6c1a9-24864-0 | |
| 2468118880b2ae33e1d00fbd0b2939e4c22cb438 | Name of donor: J. C Bamford Excavators Ltd Address of donor: J. C Bamford Excavators Ltd, Rochester, Staffordshire ST14 5JP Amount of donation or nature and value if donation in kind: £5,000, received via the Midlands Industrial Council for my General Election 2019 fighting fund Donor status: company, registration 561597 (Registered 11 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 | Stuart Andrew uk.org.publicwhip/person/24864 | 1 | 2020-12-07-2fa6c1a9-24864-0 | |
| fdf0d27992bbb07109c5adde65f4261b8315239f | Name of donor: Association of Conservative Clubs Ltd Address of donor: 24 Old Queen Street, London SW11 0HP Amount of donation or nature and value if donation in kind: £2,500 for my General Election 2019 fighting fund Donor status: company, registration 00457188 (Registered 11 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 | Stuart Andrew uk.org.publicwhip/person/24864 | 2 | 2020-12-07-2fa6c1a9-24864-0 | |
| 9b57e83fcd8b1c26f88effe888e3eda47b2cdd88 | Name of donor: Lawrence Tomlinson Address of donor: private Amount of donation or nature and value if donation in kind: £2,500 for my General Election 2019 fighting fund Donor status: individual (Registered 11 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 | Stuart Andrew uk.org.publicwhip/person/24864 | 3 | 2020-12-07-2fa6c1a9-24864-0 | |
| 0210a25b0dc571e0957f92eaa1a387a4c671b296 | Name of donor: Graham Smith Address of donor: private Amount of donation or nature and value if donation in kind: £2,000 for my General Election 2019 fighting fund Donor status: individual (Registered 11 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 | Stuart Andrew uk.org.publicwhip/person/24864 | 4 | 2020-12-07-2fa6c1a9-24864-0 | |
| b52522327a16ba7c4b3ca6cb6eb3441937de1bb8 | Name of donor: Lord Philip Harris of Peckham Address of donor: private Amount of donation or nature and value if donation in kind: £3,000 for my General Election 2019 fighting fund Donor status: individual (Registered 11 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 | Stuart Andrew uk.org.publicwhip/person/24864 | 5 | 2020-12-07-2fa6c1a9-24864-0 | |
| 671c896d39bc9682661aee319606924e7fa4b227 | Name of donor: Carlton Club Political Committee Address of donor: 69 St James's Street, London SW1A 1PJ Amount of donation or nature and value if donation in kind: £2,500 for my General Election 2019 fighting fund Donor status: unincorporated association (Registered 11 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 | Stuart Andrew uk.org.publicwhip/person/24864 | 6 | 2020-12-07-2fa6c1a9-24864-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");