items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2023-05-30-10057ffd-24787-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 |
|---|---|---|---|---|---|---|---|
| 199e60ddc663441be28e8a4396dda9a85c46d880 | Until 7 July 2022, Chairman of OpSec Security, brand protection. Address: 40 Phoenix Road, Washington, NE38 0AD. From 1 April 2021 until 30 June 2022, I received £40,000 a year, paid monthly for an expected commitment of 4 hours per month. (Registered 09 January 2020; updated 27 April 2020, 23 April 2021 and 18 July 2022) | Employment and earnings 10057ffd | 2023-05-30 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2023-05-30-10057ffd-24787-0 | |
| 0d690f87167488b4f2615ebb41e18f720190d966 | Until 7 July 2022, Director of Eviivo Ltd (software), of 154 Pentonville Rd, London N1 9JE. I received £15,000 a year, paid monthly, for an expected commitment of 2 hours per month. From 1 April 2020 until my resignation, payments were suspended and I did not accept any further payment for this role. (Registered 09 January 2020; updated 27 April 2020 and 18 July 2022) | Employment and earnings 10057ffd | 2023-05-30 | Richard Fuller uk.org.publicwhip/person/24787 | 1 | 2023-05-30-10057ffd-24787-0 | |
| 6325c987dfd67fef827d61b9c7a2de152b872dee | Until 7 July 2022, a director of Impero Solutions Ltd, 2 Tollhouse Hill, Nottingham NG1 5FS, a software company. From 1 April 2021 until 30 June 2022, I received £20,000 a year, paid monthly for an expected commitment of 2 hours per month. (Registered 09 January 2020; updated 27 April 2020, 23 April 2021, 18 July 2022 and 13 April 2023) | Employment and earnings 10057ffd | 2023-05-30 | Richard Fuller uk.org.publicwhip/person/24787 | 2 | 2023-05-30-10057ffd-24787-0 | |
| 66465e747944bc08320d9cbb92bf6c12247bcefe | Until 7 July 2022 and again from 1 April 2023, Advisory Director of Investcorp Securities Ltd, of 48 Grosvenor St, London W1K 3HW, a venture capital company. (Registered 09 January 2020; updated 18 July 2022 and 14 April 2023) | Employment and earnings 10057ffd | 2023-05-30 | Richard Fuller uk.org.publicwhip/person/24787 | 3 | 2023-05-30-10057ffd-24787-0 | |
| 0b04393b9416bd64e209876a60afedc408d1b723 | Until 7 July 2023, I received £20,000 a year, paid quarterly for an expected commitment of 2 hours a month. (Registered 09 January 2020; updated 18 July 2022) | Employment and earnings 10057ffd | 2023-05-30 | Richard Fuller uk.org.publicwhip/person/24787 | 4 | 2023-05-30-10057ffd-24787-0 | |
| a0f4ee494d409d576662ecda6add28fe54e030d4 | From 1 April 2023 until further notice, I receive £25,000 per year, paid quarterly for an expected commitment of 10 hours per month. I consulted ACoBA about this appointment. (Registered 14 April 2023) | Employment and earnings 10057ffd | 2023-05-30 | Richard Fuller uk.org.publicwhip/person/24787 | 5 | 2023-05-30-10057ffd-24787-0 | |
| 15bc2714dc88918796e377620130b16b7a38631e | From 1 April 2023, a director of Impero Holdings Ltd, 2 Tollhouse Hill, Nottingham NG1 5FS, a software company. Until further notice, I receive £20,000 a year, paid monthly for an expected commitment of 5 hours per month. I consulted ACoBA about this appointment. (Registered 14 April 2023) | Employment and earnings 10057ffd | 2023-05-30 | Richard Fuller uk.org.publicwhip/person/24787 | 6 | 2023-05-30-10057ffd-24787-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");