items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2023-10-30-5f2cbd10-25661-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 |
|---|---|---|---|---|---|---|---|
| 56a171488a45ba8e64e90b93b05463e255c5960d | Member (unpaid) of the Ditchley Foundation's Programme Committee. (Registered 06 July 2017) | Miscellaneous 5f2cbd10 | 2023-10-30 | Bim Afolami uk.org.publicwhip/person/25661 | 0 | 2023-10-30-5f2cbd10-25661-0 | |
| b1b4f17d0c410f3463fb3ee3cb9d572fce87c60b | From June 2017, Member (unpaid) of the Court of the University of Bedfordshire. (Registered 30 January 2018) | Miscellaneous 5f2cbd10 | 2023-10-30 | Bim Afolami uk.org.publicwhip/person/25661 | 1 | 2023-10-30-5f2cbd10-25661-0 | |
| 7a21c0df088711e03bba9a66b13e5a9f0d497366 | From 13 September 2018, Member (unpaid) of the Financial Inclusion Commission, a cross-party organisation which supports the principle of increased financial inclusion in the UK. (Registered 21 September 2018) | Miscellaneous 5f2cbd10 | 2023-10-30 | Bim Afolami uk.org.publicwhip/person/25661 | 2 | 2023-10-30-5f2cbd10-25661-0 | |
| bed9eaf098426823b0fdb8f7a3bc6e131099d6f3 | From 22 October 2018, Trustee (unpaid) of the Mitsubishi UFJ Trust Oxford Foundation, which supports the Oxford Union Literary and Debating Trust and through it the charitable activities of the Oxford Union Society. (Registered 05 November 2018) | Miscellaneous 5f2cbd10 | 2023-10-30 | Bim Afolami uk.org.publicwhip/person/25661 | 3 | 2023-10-30-5f2cbd10-25661-0 | |
| 2398654029bc09294261b3f30b1787ef6b1b01ee | From 20 June 2022, Member of the Advisory Board of the Nick Maughan Foundation, which works to further a range of philanthropic initiatives in education, the environment and civic support schemes for disenfranchised communities. This is an unpaid role. (Registered 20 June 2022) | Miscellaneous 5f2cbd10 | 2023-10-30 | Bim Afolami uk.org.publicwhip/person/25661 | 4 | 2023-10-30-5f2cbd10-25661-0 | |
| e173013fa3b01061a117370b14c06ebba8bdfb58 | From 20 June 2022, Member of the Advisory Board of the Energy and Climate Intelligence Unit, a non-profit organisation that supports informed debate on energy and climate change issues in the UK. This is an unpaid role. (Registered 20 June 2022) | Miscellaneous 5f2cbd10 | 2023-10-30 | Bim Afolami uk.org.publicwhip/person/25661 | 5 | 2023-10-30-5f2cbd10-25661-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");