items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2023-05-15-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 |
|---|---|---|---|---|---|---|---|
| 79c4c815996965249c3daf6628e64e59ad029738 | 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-15 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2023-05-15-10057ffd-24787-0 | |
| 0188cf178a76221e78185db89473edc18790008c | 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-15 | Richard Fuller uk.org.publicwhip/person/24787 | 1 | 2023-05-15-10057ffd-24787-0 | |
| 70041e8fc446d31362efda3e2c51b65c92417f7f | 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-15 | Richard Fuller uk.org.publicwhip/person/24787 | 2 | 2023-05-15-10057ffd-24787-0 | |
| b05b8ae43e7e191a881294bcbcef7d20a1aa4fd3 | 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-15 | Richard Fuller uk.org.publicwhip/person/24787 | 3 | 2023-05-15-10057ffd-24787-0 | |
| b78c1795f8755ab8490c7f173d14b726817e9ec4 | 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-15 | Richard Fuller uk.org.publicwhip/person/24787 | 4 | 2023-05-15-10057ffd-24787-0 | |
| 2757c4522751db1eadcc1d9bf72b38905201ac9b | 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-15 | Richard Fuller uk.org.publicwhip/person/24787 | 5 | 2023-05-15-10057ffd-24787-0 | |
| 5f25b09d0e606de1891c61d65630fd73852b1bc9 | 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-15 | Richard Fuller uk.org.publicwhip/person/24787 | 6 | 2023-05-15-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");