items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-09-18-64e8edeb-24873-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 |
|---|---|---|---|---|---|---|---|
| 7a32202b9b624539a04ad5dcf37a20428f325389 | Name of donor: The Betting and Gaming Council Address of donor: 1st Floor, 90 Chancery Lane, London WC2A 1EU Amount of donation or nature and value if donation in kind: Two tickets and hospitality at the Cheltenham Festival, value £1,560 Date received: 16 March 2023 Date accepted: 16 March 2023 Donor status: company, registration 12213577 (Registered 27 March 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-09-18 | Caroline Dinenage uk.org.publicwhip/person/24873 | 0 | 2023-09-18-64e8edeb-24873-0 | |
| 5095042ed1a262a2dd8eb68f33c86f4c32ddfbd4 | Name of donor: Google UK Ltd Address of donor: Belgrave House, 76 Buckingham Palace Road, London SW1W 9QT Amount of donation or nature and value if donation in kind: Two tickets with hospitality and accommodation as guests of YouTube at the Glastonbury Festival of Contemporary Arts 2023, value £3,302 Date received: 26 June 2023 Date accepted: 26 June 2023 Donor status: company, registration 03977902 (Registered 18 July 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-09-18 | Caroline Dinenage uk.org.publicwhip/person/24873 | 1 | 2023-09-18-64e8edeb-24873-0 | |
| 05272d968abcc153b303822afcc7800776c31aa0 | Name of donor: Sky UK Ltd Address of donor: 1 Grant Way, Isleworth TW7 5QD Amount of donation or nature and value if donation in kind: Ticket with hospitality for a match at Lordâs Cricket Ground, value £400 Date received: 29 June 2023 Date accepted: 29 June 2023 Donor status: company, registration 04416605 (Registered 24 July 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-09-18 | Caroline Dinenage uk.org.publicwhip/person/24873 | 2 | 2023-09-18-64e8edeb-24873-0 | |
| ea2da467913bae86b1600243e240954262ade0d0 | Name of donor: Sky UK Ltd Address of donor: 1 Grant Way, Isleworth TW7 5QD Amount of donation or nature and value if donation in kind: Ticket with hospitality for the Soho House Festival, value £250 Date received: 6 July 2023 Date accepted: 6 July 2023 Donor status: company, registration 04416605 (Registered 24 July 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-09-18 | Caroline Dinenage uk.org.publicwhip/person/24873 | 3 | 2023-09-18-64e8edeb-24873-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");