items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2023-08-07-5f2cbd10-24786-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 |
|---|---|---|---|---|---|---|---|
| 0165220ce4801e229cf4ae2aa1cbcb3a01d92b32 | From 20 October 2020 until 9 September 2022, Chair of the Advisory Board of Conservatives Against Racism For Equality (CARFE), an organisation building a new narrative on race relations, working with Conservative MPs and individuals across the Conservative Party and wider society. (Registered 18 December 2020; updated 26 June 2023) | Miscellaneous 5f2cbd10 | 2023-08-07 | Steven Baker uk.org.publicwhip/person/24786 | 0 | 2023-08-07-5f2cbd10-24786-0 | |
| f25f071116d65c754f4a4dc04592e7b7dfca3e2f | From 15 December 2020 until 9 September 2022, Member of the Air League Council. The Air League aims to change lives through aviation, promoting an interest in aviation by inspiring young people, awarding scholarships and work opportunities. I returned to the Air League Council after a lapse of several years. (Registered 18 December 2020; updated 26 June 2023) | Miscellaneous 5f2cbd10 | 2023-08-07 | Steven Baker uk.org.publicwhip/person/24786 | 1 | 2023-08-07-5f2cbd10-24786-0 | |
| 2ee33c192e643735db229de90f5968d4b05211b6 | From 5 November 2020 until 8 September 2022, Deputy Chairman of the Covid Recovery Group, a group of Conservative MPs and peers which co-ordinates parliamentary work to facilitate the countryâs recovery from Covid 19. This was an unpaid role. (Registered 26 January 2021; updated 26 June 2023) | Miscellaneous 5f2cbd10 | 2023-08-07 | Steven Baker uk.org.publicwhip/person/24786 | 2 | 2023-08-07-5f2cbd10-24786-0 | |
| deae804500258eafd997620ef80a5c428d7f583b | From 17 May 2021 until 9 September 2022, Member of the Global Warming Policy Foundation's Board of Trustees. This was an unpaid role. (Registered 21 May 2021; updated 26 June 2023) | Miscellaneous 5f2cbd10 | 2023-08-07 | Steven Baker uk.org.publicwhip/person/24786 | 3 | 2023-08-07-5f2cbd10-24786-0 | |
| b92d6e94d03225ca64f59b98fc72297ea308ac4e | From 29 April 2022 until 9 September 2022, a director and Chairman of Conservative Way Forward Ltd. This was an unpaid role. (Registered 23 May 2022; updated 26 June 2023) | Miscellaneous 5f2cbd10 | 2023-08-07 | Steven Baker uk.org.publicwhip/person/24786 | 4 | 2023-08-07-5f2cbd10-24786-0 | |
| 0a339d999d1766cdd3dd5e0a5cfa67348729787f | 18 January 2023, my local association accepted a donation of £1,500 from First Corporate which is below the registrable threshold. (Registered 02 March 2023) | Miscellaneous 5f2cbd10 | 2023-08-07 | Steven Baker uk.org.publicwhip/person/24786 | 5 | 2023-08-07-5f2cbd10-24786-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");