items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2021-01-18-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 |
|---|---|---|---|---|---|---|---|
| 329670fd80b8c0ee5df48744ee0f80fcc65ab7ab | 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 | 2021-01-18 | Stuart Andrew uk.org.publicwhip/person/24864 | 0 | 2021-01-18-2fa6c1a9-24864-0 | |
| 921821c519f5852dc8ebf83d3ca3ab50d6b9f6a2 | 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 | 2021-01-18 | Stuart Andrew uk.org.publicwhip/person/24864 | 1 | 2021-01-18-2fa6c1a9-24864-0 | |
| b0415f35c4dd450ba5b384f50968cc014837d1e8 | 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 | 2021-01-18 | Stuart Andrew uk.org.publicwhip/person/24864 | 2 | 2021-01-18-2fa6c1a9-24864-0 | |
| 46b42f942ca8138debff80eab509b53d84d9eaad | 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 | 2021-01-18 | Stuart Andrew uk.org.publicwhip/person/24864 | 3 | 2021-01-18-2fa6c1a9-24864-0 | |
| e5f6740ed2ee2dd4347387820b69879dcb04f7a8 | 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 | 2021-01-18 | Stuart Andrew uk.org.publicwhip/person/24864 | 4 | 2021-01-18-2fa6c1a9-24864-0 | |
| c6745f1b0492a3c39e3725f96dca2fcf7b9835b0 | 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 | 2021-01-18 | Stuart Andrew uk.org.publicwhip/person/24864 | 5 | 2021-01-18-2fa6c1a9-24864-0 | |
| c202d99eb249fd642a331666d23c0bf526e53722 | 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 | 2021-01-18 | Stuart Andrew uk.org.publicwhip/person/24864 | 6 | 2021-01-18-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");