items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2023-06-12-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 |
|---|---|---|---|---|---|---|---|
| 5d2c1f573582ce69837627276a650cce9b3b5c81 | 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-06-12 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2023-06-12-10057ffd-24787-0 | |
| 933204d2d450fff0e5a0693c25cb101ad9a3078e | 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-06-12 | Richard Fuller uk.org.publicwhip/person/24787 | 1 | 2023-06-12-10057ffd-24787-0 | |
| ee05655236f00e7e770497645f9948d4ea1b165b | 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-06-12 | Richard Fuller uk.org.publicwhip/person/24787 | 2 | 2023-06-12-10057ffd-24787-0 | |
| 08516853cdbe50665c0e7457c3afd06928e3aa4d | 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-06-12 | Richard Fuller uk.org.publicwhip/person/24787 | 3 | 2023-06-12-10057ffd-24787-0 | |
| 31523b963d77159c6017e251ebe1239675b6a42d | 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-06-12 | Richard Fuller uk.org.publicwhip/person/24787 | 4 | 2023-06-12-10057ffd-24787-0 | |
| 2e423a6eac4a2540236d6b5ab98b9f44e7b3c569 | 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-06-12 | Richard Fuller uk.org.publicwhip/person/24787 | 5 | 2023-06-12-10057ffd-24787-0 | |
| 2da36b9f9dfa91414fd193a9533937aaeee4b18b | 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-06-12 | Richard Fuller uk.org.publicwhip/person/24787 | 6 | 2023-06-12-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");