items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-10-16-5f2cbd10-10213-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 |
|---|---|---|---|---|---|---|---|
| f3a1f916d7bbb7ff57276dac283382d2a5eafb8b | From 15 July 2021, Chair of the UK Abraham Accords Group, and from 17 January 2023 also an unpaid Director of Abraham Accords (UK) Ltd. The purpose of the group is to provide a UK forum to promote the Accords and the wider cause of peace across the Middle East. I consulted ACoBA about this unpaid role. (Registered 15 July 2021; updated 25 January 2023) | Miscellaneous 5f2cbd10 | 2023-10-16 | Liam Fox uk.org.publicwhip/person/10213 | 0 | 2023-10-16-5f2cbd10-10213-0 | |
| 744279ec9ac9a8967d937d20a349803390844284 | From 30 July 2021, UK Chair, and from 23 May 2022, a Director of the Conservative Friends of America. These are unpaid roles. (Registered 30 July 2021; updated 16 June 2022) | Miscellaneous 5f2cbd10 | 2023-10-16 | Liam Fox uk.org.publicwhip/person/10213 | 1 | 2023-10-16-5f2cbd10-10213-0 | |
| 802a08278218e4405e6567b2cf9993e5a1409263 | From 13 September 2021, unpaid adviser to Arcs Energy. This is an unpaid role. (Registered 15 September 2021) | Miscellaneous 5f2cbd10 | 2023-10-16 | Liam Fox uk.org.publicwhip/person/10213 | 2 | 2023-10-16-5f2cbd10-10213-0 | |
| 6bdac16bc43564793b2cb48acf737b915cd74616 | From 5 September 2023, Member of the Advisory Board for Conservative Coalition for Climate Solutions (C3 Solutions). C3 Solutions is an educational organisation incorporated in Washington, DC. This is an unpaid role. (Registered 07 September 2023) | Miscellaneous 5f2cbd10 | 2023-10-16 | Liam Fox uk.org.publicwhip/person/10213 | 3 | 2023-10-16-5f2cbd10-10213-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");