items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2023-09-04-5f2cbd10-10534-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 |
|---|---|---|---|---|---|---|---|
| b0c1497a9f02cfd483f551f5aa7afaee6b08b6af | From 9 July 2021, President of the Parliamentary Advisory Committee for Transport Safety (PACTS). Prior to 9 July 2021, I was the Chair of Trustees. This is an unpaid role. (Updated 29 November 2021) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 0 | 2023-09-04-5f2cbd10-10534-0 | |
| 02585c4ba5bcf76a62f0b8e9033f4ed466351c2f | 23 November 2020, Chair of Thames Renaissance Ltd, an independent body which gathers data in order to inform more effective and constructive use of the River Thames. This is an unpaid role. (Registered 02 March 2021) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 1 | 2023-09-04-5f2cbd10-10534-0 | |
| 61e8b9933b83e435a85b6788ce64c67cf07463eb | From 1 August 2015, Chair (currently unpaid) of Optimised Waste Logistics Group (OWL), which is managed by CMS SupaTrak Ltd, Delta 1200, Welton Road, Swindon, SN5 7XZ. (Registered 18 May 2016; updated 27 May 2016 and 11 March 2021) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 2 | 2023-09-04-5f2cbd10-10534-0 | |
| 7b004619a5b89ad60dd81d6d0539695cc24556f7 | From 25 October 1995, Chair of Policy Connect, a cross-party think tank focusing on education, industry, sustainability and health. This is an unpaid role. (Registered 23 November 2021) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 3 | 2023-09-04-5f2cbd10-10534-0 | |
| d31fe5b00fa93da094f5893b673b11dd13728bde | From 24 August 2007, Chair of the John Clare Trust, which runs John Clare Cottage, preserving it and the poetâs works for future generations. This is an unpaid role. (Registered 23 November 2021) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 4 | 2023-09-04-5f2cbd10-10534-0 | |
| bb6bd71f66b1575f6f732ccc616af0723aaa6e8d | From 2 January 2015, Director of the Fairlife Foundation, a registered charity focused on improving financial products and promoting financial education. This is an unpaid role. (Registered 23 November 2021) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 5 | 2023-09-04-5f2cbd10-10534-0 | |
| 9d838b22cab1d2c87cc201535272e78044f7cbcf | On 16 November 2022, I accepted hotel accommodation from VISIE Communications for two nights at the Majestic Hotel Harrogate during the OWL Roadshow North, value £190. (Registered 24 November 2022) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 6 | 2023-09-04-5f2cbd10-10534-0 | |
| 9c3ad4ec45c7c7937c746043fc2d7f6ef856e5ad | From 6 February 2023, Director the of Sheerman Foundation Limited, a company limited by guarantee set up for the purposes of supporting environmental causes, sustainable development and the relief of poverty. (Registered 6 February 2023; updated 26 April 2023) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 7 | 2023-09-04-5f2cbd10-10534-0 | |
| f86221a614fc4f1a56664be938fba367a59593d9 | On 29 March 2023, I accepted hospitality from VISIE Communications during a Waste Logistics Conference, value £195. (Registered 11 April 2023) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 8 | 2023-09-04-5f2cbd10-10534-0 | |
| ecc97b9a9d08e2397385189b6694fe0c54dbe7e2 | From 25 April 2023, Trustee of the Future Justice Project, a registered charity set up to support the sound administration of the UK's justice system. This is an unpaid role. (Registered 26 April 2023) | Miscellaneous 5f2cbd10 | 2023-09-04 | Barry Sheerman uk.org.publicwhip/person/10534 | 9 | 2023-09-04-5f2cbd10-10534-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");