items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2023-04-17-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 |
|---|---|---|---|---|---|---|---|
| 8ea681663f263237816f1ea6ff29fb4a3cb30d2c | 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-04-17 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2023-04-17-10057ffd-24787-0 | |
| 5be859b73b4d6fdb99b4be7af60d20fe49468560 | 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-04-17 | Richard Fuller uk.org.publicwhip/person/24787 | 1 | 2023-04-17-10057ffd-24787-0 | |
| a02018ae7b94f516168c639037f99da3fcd47bd5 | 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-04-17 | Richard Fuller uk.org.publicwhip/person/24787 | 2 | 2023-04-17-10057ffd-24787-0 | |
| 885d688ad0e75ebdb3dd455a35788cffc36e7a65 | 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-04-17 | Richard Fuller uk.org.publicwhip/person/24787 | 3 | 2023-04-17-10057ffd-24787-0 | |
| 21c5f82b45d7603e10d705cd524f6a2159870705 | 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-04-17 | Richard Fuller uk.org.publicwhip/person/24787 | 4 | 2023-04-17-10057ffd-24787-0 | |
| fa3098320f29984cb7e39b68caca22222ad464f4 | 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-04-17 | Richard Fuller uk.org.publicwhip/person/24787 | 5 | 2023-04-17-10057ffd-24787-0 | |
| d34c496b55854d4215bdc3a015ce5e6da782b217 | 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-04-17 | Richard Fuller uk.org.publicwhip/person/24787 | 6 | 2023-04-17-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");