items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-07-10-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 |
|---|---|---|---|---|---|---|---|
| a52cac65a86a1ca26b69eeb2f86a565a985aff4b | 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,578.84 for the period July to September 2022. Date received: 1 July to 30 September 2022 Date accepted: 1 July 2022 Donor status: company, registration 10436078 (Registered 01 July 2022) | (b) Any other support not included in Category 2(a) 70b64e89 | 2023-07-10 | Hilary Benn uk.org.publicwhip/person/10669 | 0 | 2023-07-10-70b64e89-10669-0 | |
| 8bb68be581c4c02c4fb1c392bcd7bdaf78414838 | 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-07-10 | Hilary Benn uk.org.publicwhip/person/10669 | 1 | 2023-07-10-70b64e89-10669-0 | |
| aff572055a57519718c6a6720fe161162372e349 | 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-07-10 | Hilary Benn uk.org.publicwhip/person/10669 | 2 | 2023-07-10-70b64e89-10669-0 | |
| aacfe4060615c2158c862f18fb213ab38cbe0ea5 | 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-07-10 | Hilary Benn uk.org.publicwhip/person/10669 | 3 | 2023-07-10-70b64e89-10669-0 | |
| 8d117f2e39e369985a50f94a20c3b18b275de737 | 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-07-10 | Hilary Benn uk.org.publicwhip/person/10669 | 4 | 2023-07-10-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");