items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-10-30-64e8edeb-24725-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 |
|---|---|---|---|---|---|---|---|
| 60903e61718483636da1844bfb5fd0a5c2fc4bfa | Name of donor: Alton Towers Resort (part of the Merlin Entertainment Group) Address of donor: Alton, Staffordshire ST10 4DB Amount of donation or nature and value if donation in kind: Two tickets and Fastrack passes to Alton Towers Theme Park, total value £324 Date received: 28 October 2022 Date accepted: 28 October 2022 Donor status: company, registration 06272935 (Registered 02 November 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Karen Bradley uk.org.publicwhip/person/24725 | 0 | 2023-10-30-64e8edeb-24725-0 | |
| 49f0b7d34061f10df316fe92f89e095c5799a9d5 | Name of donor: The FA Premier League Ltd Address of donor: Brunel Building, 57 North Wharf Road, London W2 1HQ Amount of donation or nature and value if donation in kind: Three tickets and hospitality to NFL Denver Broncos v Jacksonville Jaguars at Wembley, total value £1,350 Date received: 30 October 2022 Date accepted: 30 October 2022 Donor status: company, registration 2719699 (Registered 09 November 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Karen Bradley uk.org.publicwhip/person/24725 | 1 | 2023-10-30-64e8edeb-24725-0 | |
| 38443f7a67240375f5fc23f36b59d07dd8f97a33 | Name of donor: The FA Premier League Ltd Address of donor: Brunel Building, 57 North Wharf Road, London W2 1HQ Amount of donation or nature and value if donation in kind: Ticket with hospitality to Man City v Real Madrid, total value £450 Date received: 17 May 2023 Date accepted: 17 May 2023 Donor status: company, registration 2719699 (Registered 26 May 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Karen Bradley uk.org.publicwhip/person/24725 | 2 | 2023-10-30-64e8edeb-24725-0 | |
| f657a7b3cffd4652aa5718b2da2c788519f60bf9 | Name of donor: Silverstone Circuits Ltd Address of donor: The Jimmy Brown Centre, Silverstone Circuits, Towcester NN12 8TN Amount of donation or nature and value if donation in kind: Four tickets with hospitality at the Grand Prix, total value £4,665.60 Date received: 9 July 2023 Date accepted: 9 July 2023 Donor status: company, registration 00882843 (Registered 12 July 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Karen Bradley uk.org.publicwhip/person/24725 | 3 | 2023-10-30-64e8edeb-24725-0 | |
| 882c403b70c0640bbd59eb363b56c486010859b9 | Name of donor: R&A Championships Limited Address of donor: Beach House, Golf Place, St Andrews KY18 9JA Amount of donation or nature and value if donation in kind: Three tickets with hospitality to the Liverpool Open, value £1,575 Date received: 21 July 2023 Date accepted: 21 July 2023 Donor status: company, registration SC247047 (Registered 15 August 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-30 | Karen Bradley uk.org.publicwhip/person/24725 | 4 | 2023-10-30-64e8edeb-24725-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");