items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2023-06-26-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 |
|---|---|---|---|---|---|---|---|
| 43d614cd12cb0cfcadd789a39230cd36f44e61cd | 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,750.03 for the period April to June 2022. Date received: 1 April 2022 to 30 June 2022 Date accepted: 1 April 2022 Donor status: company, registration 10436078 (Registered 01 April 2022) | (b) Any other support not included in Category 2(a) 70b64e89 | 2023-06-26 | Hilary Benn uk.org.publicwhip/person/10669 | 0 | 2023-06-26-70b64e89-10669-0 | |
| 872a869fb44d120eb056e765c48acf95a5cccf1d | 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: A visit by UK Trade and Business Commission, of which I am co-convener, to meet businesses in Maidstone and Dover and to tour the Port of Dover including transport and refreshments for secretariat staff and attendees, secretariat services and staff time, and expert advice, total estimated value £1,050 Date received: 16 May 2022 Date accepted: 16 May 2022 Donor status: company, registration 10436078 (Registered 01 June 2022) | (b) Any other support not included in Category 2(a) 70b64e89 | 2023-06-26 | Hilary Benn uk.org.publicwhip/person/10669 | 1 | 2023-06-26-70b64e89-10669-0 | |
| 9ef7b5a2df5c7a39765d6a2339d5c9b584212dcb | 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-06-26 | Hilary Benn uk.org.publicwhip/person/10669 | 2 | 2023-06-26-70b64e89-10669-0 | |
| cc553185751d7856358358bd922989104c3f1bcb | 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-06-26 | Hilary Benn uk.org.publicwhip/person/10669 | 3 | 2023-06-26-70b64e89-10669-0 | |
| a369be4de0e67092ece86f5535521b581ab6a093 | 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-06-26 | Hilary Benn uk.org.publicwhip/person/10669 | 4 | 2023-06-26-70b64e89-10669-0 | |
| f40347145bd155d6125e961721f0d986e8d01f23 | 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-06-26 | Hilary Benn uk.org.publicwhip/person/10669 | 5 | 2023-06-26-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");