items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-10-30-64e8edeb-25820-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
|---|---|---|---|---|---|---|---|
| ef74d94e43340ae2a3dcf6c4f27e3802ccd9d51f | 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-30 | Munira Wilson uk.org.publicwhip/person/25820 | 0 | 2023-10-30-64e8edeb-25820-0 | |
| 4e8043e9484e2cb5150cf1066b6143645735e1c4 | 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-30 | Munira Wilson uk.org.publicwhip/person/25820 | 1 | 2023-10-30-64e8edeb-25820-0 | |
| 56d52fa26819c7f8d50d175699a1ded6335bd51f | 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-30 | Munira Wilson uk.org.publicwhip/person/25820 | 2 | 2023-10-30-64e8edeb-25820-0 | |
| 3a4d8f016b4d53261ce8277a6a9ca983f090359b | 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-30 | Munira Wilson uk.org.publicwhip/person/25820 | 3 | 2023-10-30-64e8edeb-25820-0 | |
| 1a7c2315512092e032391a3dc17c6302408eea34 | 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-30 | Munira Wilson uk.org.publicwhip/person/25820 | 4 | 2023-10-30-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");