items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-09-18-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 |
|---|---|---|---|---|---|---|---|
| ce8524a05d8c819e6e81e26351ce9c8e1a161b4c | 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-09-18 | Munira Wilson uk.org.publicwhip/person/25820 | 0 | 2023-09-18-64e8edeb-25820-0 | |
| 68eaa3ef26f9ac0544a5c2a2fd448b61186cd8d3 | 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-09-18 | Munira Wilson uk.org.publicwhip/person/25820 | 1 | 2023-09-18-64e8edeb-25820-0 | |
| 69230dd7386244c78d57eee08722a04825f5bd05 | 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-09-18 | Munira Wilson uk.org.publicwhip/person/25820 | 2 | 2023-09-18-64e8edeb-25820-0 | |
| ec2ac63a7c2ee90ad493f8c7946f8288a134f252 | 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-09-18 | Munira Wilson uk.org.publicwhip/person/25820 | 3 | 2023-09-18-64e8edeb-25820-0 | |
| 656348b8d5612235954cabf8a3d684a57f374522 | 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-09-18 | Munira Wilson uk.org.publicwhip/person/25820 | 4 | 2023-09-18-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");