items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2023-07-10-5f2cbd10-25276-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 |
|---|---|---|---|---|---|---|---|
| 663a2746076db165bcfc7eed466c5042e121e227 | From 24 February 2016, unremunerated director of UK Japan 21C Group. (Registered 28 April 2016) | Miscellaneous 5f2cbd10 | 2023-07-10 | Lisa Cameron uk.org.publicwhip/person/25276 | 0 | 2023-07-10-5f2cbd10-25276-0 | |
| 4c48b121423dbddf057f5bcd37f8a131fab3b2bf | From 19 September 2017, a trustee/director of the Industry and Parliament Trust. (Registered 19 September 2017) | Miscellaneous 5f2cbd10 | 2023-07-10 | Lisa Cameron uk.org.publicwhip/person/25276 | 1 | 2023-07-10-5f2cbd10-25276-0 | |
| 56c6a764410f2b147d014b2c443505bace184e15 | From 27 August 2019, a member of the Advisory Board of the Money and Mental Health Policy Institute at King's College, London. This role is unremunerated, but the Institute will meet any associated expenses. (Registered 27 August 2019) | Miscellaneous 5f2cbd10 | 2023-07-10 | Lisa Cameron uk.org.publicwhip/person/25276 | 2 | 2023-07-10-5f2cbd10-25276-0 | |
| 8951c4357960916eae6f9736693bb8288faf477c | From 19 October 2020, Trustee of the Mary Cameron Foundation that works to support projects, groups and charities across Lanarkshire. (Registered 03 December 2020) | Miscellaneous 5f2cbd10 | 2023-07-10 | Lisa Cameron uk.org.publicwhip/person/25276 | 3 | 2023-07-10-5f2cbd10-25276-0 | |
| 0ce95143981dd2aa67bddfb475ee264b7cbbd48d | From 6 December 2020, Advisory Board member for the World Health Organisation Rapid Assistive Technology Assessment (rATA) designed to gather information about the met and unmet needs for assistive technology. This role is unremunerated. (Registered 07 December 2020) | Miscellaneous 5f2cbd10 | 2023-07-10 | Lisa Cameron uk.org.publicwhip/person/25276 | 4 | 2023-07-10-5f2cbd10-25276-0 | |
| f9c0defd2d02a268ee7553e552484e490be9bb29 | From 15 January 2021, a member of the Trust Jack Foundation Advisory Board, a charity supporting young peopleâs mental health based in Stonehouse, South Lanarkshire. This role is unremunerated. (Registered 18 January 2021) | Miscellaneous 5f2cbd10 | 2023-07-10 | Lisa Cameron uk.org.publicwhip/person/25276 | 5 | 2023-07-10-5f2cbd10-25276-0 | |
| fad7b2b114947076a5b5311aa527aea88ca90ea7 | From 14 January 2021 until further notice, un-remunerated member of the Advisory Board of the Freedom Declared Foundation, a charity which works internationally to promote freedom of religious belief. (Registered 11 February 2021) | Miscellaneous 5f2cbd10 | 2023-07-10 | Lisa Cameron uk.org.publicwhip/person/25276 | 6 | 2023-07-10-5f2cbd10-25276-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");