items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-10-30-64e8edeb-11816-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 |
|---|---|---|---|---|---|---|---|
| 46381bdd011f61890d58ea1101a3cf8a2adbaf13 | Name of donor: Arena Racing Company Address of donor: 4th Floor, Millbank Tower, 21-24 Millbank, London, SW1P 4QP Amount of donation or nature and value if donation in kind: A badge entitling me to free entrance to any of the donor's racecourses when racing is taking place. The badge is for life and not available for purchase, but its estimated value to me is between £0 and £1,000 depending on usage per year. Date received: 28 February 2022 Date accepted: 28 February 2022 Donor status: company, registration 07997040 (Registered 24 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Philip Davies uk.org.publicwhip/person/11816 | 0 | 2023-10-30-64e8edeb-11816-0 | |
| acdec0bac1eac95a06d9c785856fc2d5ef889b04 | Name of donor: Kindred London Limited Address of donor: Kindred House, 17 Hartfield, London SW19 3SE Amount of donation or nature and value if donation in kind: One ticket with hospitality to Cheltenham Races, total value £1,000 Date received: 14 March 2023 Date accepted: 14 March 2023 Donor status: company, registration 03433883 (Registered 31 March 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Philip Davies uk.org.publicwhip/person/11816 | 1 | 2023-10-30-64e8edeb-11816-0 | |
| e10660380af26a586d70cb35424665f7b767df5d | Name of donor: Betting and Gaming Council Address of donor: 1 Bedford Row, London WC1R 4BU Amount of donation or nature and value if donation in kind: One ticket with hospitality to Royal Ascot, total value £2,758 Date received: 22 June 2023 Date accepted: 22 June 2023 Donor status: company, registration 12213577 (Registered 26 June 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Philip Davies uk.org.publicwhip/person/11816 | 2 | 2023-10-30-64e8edeb-11816-0 | |
| c9c1ecb32482da03a023929710ad7132a6159a8d | Name of donor: Arena Racing Company Address of donor: 4th Floor, Millbank Tower, 21-24 Millbank, London SW1P 4QP Amount of donation or nature and value if donation in kind: Two tickets with hospitality to Royal Ascot, total value £790 Date received: 20 June 2023 Date accepted: 20 June 2023 Donor status: company, registration 07997040 (Registered 27 June 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Philip Davies uk.org.publicwhip/person/11816 | 3 | 2023-10-30-64e8edeb-11816-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");