items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2023-05-02-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 |
|---|---|---|---|---|---|---|---|
| 3440138682532c49e3ab1f893af5dcb5e5f4cd59 | 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-02 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2023-05-02-10057ffd-24787-0 | |
| 46ec57072e950d762c6109ca92c94d5d891a8721 | 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-02 | Richard Fuller uk.org.publicwhip/person/24787 | 1 | 2023-05-02-10057ffd-24787-0 | |
| dd870a9a77258e1adcc47aba7677db0e9dd0afd4 | 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-02 | Richard Fuller uk.org.publicwhip/person/24787 | 2 | 2023-05-02-10057ffd-24787-0 | |
| ad5ce5aba9f5611f6338c8b0b99a8d3c4d4ed31d | 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-02 | Richard Fuller uk.org.publicwhip/person/24787 | 3 | 2023-05-02-10057ffd-24787-0 | |
| e4683ccdec3771d612dff72c2faa7b1a0b4a9e38 | 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-02 | Richard Fuller uk.org.publicwhip/person/24787 | 4 | 2023-05-02-10057ffd-24787-0 | |
| 109f6efc47c6b43d66029d4220c5d56aa5d2a0a6 | 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-02 | Richard Fuller uk.org.publicwhip/person/24787 | 5 | 2023-05-02-10057ffd-24787-0 | |
| 4d810cf589131ec5eed204690d186f5e80027011 | 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-02 | Richard Fuller uk.org.publicwhip/person/24787 | 6 | 2023-05-02-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");