items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-10-30-70b64e89-10669-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 |
|---|---|---|---|---|---|---|---|
| bc6f20b6984aa88b1e34a1449caffc33bd0775fe | Name of donor: Best for Britain Ltd Address of donor: International House, 24 Holborn Viaduct, London EC1A 2BN Amount of donation or nature and value if donation in kind: secretariat, research, transcription and communication services provided to the members of the UK Trade and Business Commission of which I am co-convener, to an estimated value of £18,773.84 for the period October to December 2022. Date received: 1 October to 31 December 2022 Date accepted: 1 October 2022 Donor status: company, registration 10436078 (Registered 03 October 2022) | (b) Any other support not included in Category 2(a) 70b64e89 | 2023-10-30 | Hilary Benn uk.org.publicwhip/person/10669 | 0 | 2023-10-30-70b64e89-10669-0 | |
| 5841f698cfaabda009ad3c9605bf44a88f8178a5 | Name of donor: Best for Britain Ltd Address of donor: International House, 24 Holborn Viaduct, London EC1A 2BN Amount of donation or nature and value if donation in kind: secretariat, research, transcription and communication services provided to the members of the UK Trade and Business Commission of which I am co-convener, to a value of £26,131 for the period January to March 2023. Date received: 1 January to 31 March 2023 Date accepted: 1 January 2023 Donor status: company, registration 10436078 (Registered 03 January 2023; updated 15 March 2023) | (b) Any other support not included in Category 2(a) 70b64e89 | 2023-10-30 | Hilary Benn uk.org.publicwhip/person/10669 | 1 | 2023-10-30-70b64e89-10669-0 | |
| 381edcb7eadf060c0494920d304d6e6b7a097745 | Name of donor: Best for Britain Ltd Address of donor: International House, 24 Holborn Viaduct, London EC1A 2BN Amount of donation or nature and value if donation in kind: secretariat, research, graphic design, transcription and communication services provided to the members of the UK Trade and Business Commission of which I am co-convener, to an estimated value of £29,831.17 for the period April to June 2023. Date received: 1 April to 30 June 2023 Date accepted: 1 April 2023 Donor status: company, registration 10436078 (Registered 05 April 2023) | (b) Any other support not included in Category 2(a) 70b64e89 | 2023-10-30 | Hilary Benn uk.org.publicwhip/person/10669 | 2 | 2023-10-30-70b64e89-10669-0 | |
| 02baf94f31f8df52765a0521db4aea8e3498ea6a | Name of donor: Best for Britain Ltd Address of donor: International House, 24 Holborn Viaduct, London EC1A 2BN Amount of donation or nature and value if donation in kind: secretariat, research, graphic design, printing, transcription and communication services provided to the members of the UK Trade and Business Commission of which I am co-convener, to an estimated value of £28,909.47 for the period July to September 2023. Date received: 1 July to 30 September 2023 Date accepted: 1 July 2023 Donor status: company, registration 10436078 (Registered 07 July 2023) | (b) Any other support not included in Category 2(a) 70b64e89 | 2023-10-30 | Hilary Benn uk.org.publicwhip/person/10669 | 3 | 2023-10-30-70b64e89-10669-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");