items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-10-16-64e8edeb-25820-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 |
|---|---|---|---|---|---|---|---|
| 0f070c80b1f902f58eef0ab50819a214bfa1ca3b | Name of donor: National Liberal Club Address of donor: 1 Whitehall Place, London SW1A 2HE Amount of donation or nature and value if donation in kind: Honorary membership from 19 May 2021 to 31 December 2022, value £1,463 Date received: 19 May 2021 - 31 December 2022 Date accepted: 19 May 2021 Donor status: company, registration 01355034 (Registered 24 May 2021) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-16 | Munira Wilson uk.org.publicwhip/person/25820 | 0 | 2023-10-16-64e8edeb-25820-0 | |
| 802bd41fdaa0c7d08b39f7e41bd10c70c090b306 | Name of donor: Rugby Football Union Address of donor: Rugby House, Twickenham Stadium, 200 Whitton Road, Twickenham TW2 7BA Amount of donation or nature and value if donation in kind: Two tickets with hospitality for England v South Africa match at Twickenham Stadium, value £580.80 Date received: 26 November 2022 Date accepted: 26 November 2022 Donor status: company, registration IP27981R (Registered 09 December 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-16 | Munira Wilson uk.org.publicwhip/person/25820 | 1 | 2023-10-16-64e8edeb-25820-0 | |
| ead7b6693be41263357cfceed85858e0a3ec00eb | Name of donor: Centre for Turkey Studies & Development Address of donor: 239-241 Kennington Lane, London SE11 5QU Amount of donation or nature and value if donation in kind: Ticket to the British Kebab Awards, value £360 Date received: 28 February 2023 Date accepted: 28 February 2023 Donor status: company, registration 07512777 (Registered 03 March 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-16 | Munira Wilson uk.org.publicwhip/person/25820 | 2 | 2023-10-16-64e8edeb-25820-0 | |
| f21b09635a847a5f93b7e27cdfcc42f531a466ed | Name of donor: Harlequin Football Club Ltd Address of donor: Twickenham Stoop Stadium, Langhorn Drive, Twickenham TW2 7SX Amount of donation or nature and value if donation in kind: Two tickets with hospitality for the BG14 match at Twickenham Stadium, value £900 Date received: 4 March 2023 Date accepted: 4 March 2023 Donor status: company, registration 03213073 (Registered 06 March 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-16 | Munira Wilson uk.org.publicwhip/person/25820 | 3 | 2023-10-16-64e8edeb-25820-0 | |
| 7efd345dd5ea945e106aa1fc31ba1896ef3865a9 | Name of donor: Football Association Ltd Address of donor: Wembley Stadium, London HA9 0WS Amount of donation or nature and value if donation in kind: Two tickets and hospitality at the Womenâs FA Cup Final, value £340 Date received: 14 May 2023 Date accepted: 14 May 2023 Donor status: company, registration 00077797 (Registered 17 May 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-10-16 | Munira Wilson uk.org.publicwhip/person/25820 | 4 | 2023-10-16-64e8edeb-25820-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");