items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-01-23-64e8edeb-13852-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 |
|---|---|---|---|---|---|---|---|
| f90993f339af20c79768e9fd9bb9fcc43a01844d | Name of donor: Motorsport UK Address of donor: Bicester Motion OX27 8FY Amount of donation or nature and value if donation in kind: In my capacity as an MP and Independent Chairman of Northern Ireland’s Motorsport Taskforce, guest of honour at the Evening of Racing Champions, total value for me and a guest £1,260 Date received: 22 January 2022 Date accepted: 22 January 2022 Donor status: company, registration 1344829 (Registered 31 January 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-01-23 | Ian Paisley Jnr uk.org.publicwhip/person/13852 | 0 | 2023-01-23-64e8edeb-13852-0 | |
| ea1efbf19c9627416d887d619bfc39d988f91b2b | Name of donor: John Pye Auctions Ltd Address of donor: James Shipstone House, Radford Road, Nottingham NG7 7EA Amount of donation or nature and value if donation in kind: Ticket with hospitality for England v New Zealand Test match, value £649.99 Date received: 10 June 2022 Date accepted: 10 June 2022 Donor status: company, registration 2564753 (Registered 24 June 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-01-23 | Ian Paisley Jnr uk.org.publicwhip/person/13852 | 1 | 2023-01-23-64e8edeb-13852-0 | |
| eab253ba0f6f4359e73c78ce804847a54de70988 | Name of donor: R&A Championships Ltd Address of donor: Beach House, Golf Place, St Andrews KY16 9JA Amount of donation or nature and value if donation in kind: Two tickets with hospitality for the Open at St Andrews, value £750 Date received: 14 July 2022 Date accepted: 14 July 2022 Donor status: company, registration SC247047 (Registered 25 July 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-01-23 | Ian Paisley Jnr uk.org.publicwhip/person/13852 | 2 | 2023-01-23-64e8edeb-13852-0 | |
| ef0c96a55c5c40500153c4fb85428541f3484947 | Name of donor: Motorsport UK Address of donor: Bicester Motion OX27 8FY Amount of donation or nature and value if donation in kind: Received in my capacity as Chair of the F1 APPG and Independent Chairman of Northern Ireland’s Motorsport Taskforce, two tickets with hospitality for the British Grand Prix, total value £1,260. I was unable to attend but the second ticket was used by my guest. Date received: 3 July 2022 Date accepted: 3 July 2022 Donor status: company, registration 1344829 (Registered 25 July 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-01-23 | Ian Paisley Jnr uk.org.publicwhip/person/13852 | 3 | 2023-01-23-64e8edeb-13852-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");