items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2023-10-30-10057ffd-24740-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 |
|---|---|---|---|---|---|---|---|
| af4e2d913ec190a3265b7add32418f0e52e90afd | From 1 September 2020 until 31 December 2022, Senior Adviser to Veezu Holdings Ltd (private hire transport and technology platform), Raleigh House, Langstone Business Village, Newport NP18 2LH. I received £15,000 a year, paid monthly, for providing strategic advice. Hours: up to 70 hrs a year. I consulted ACoBA about this appointment. (Registered 28 September 2020; updated 25 January 2023) | Employment and earnings 10057ffd | 2023-10-30 | Alun Cairns uk.org.publicwhip/person/24740 | 0 | 2023-10-30-10057ffd-24740-0 | |
| 620c8aba94fd4388fc6704cf2495a0f8e3c33848 | 24 January 2023, received a termination payment of £8,000. Hours: no additional hours. (Registered 25 January 2023) | Employment and earnings 10057ffd | 2023-10-30 | Alun Cairns uk.org.publicwhip/person/24740 | 1 | 2023-10-30-10057ffd-24740-0 | |
| cd61c2380bba39db4137f8983f97092d152fe5ac | From 1 June 2021, Adviser to Elite Partners Capital Pte Ltd (global property investment firm), 8 Temasek Boulevard, Suntec Tower 3 #37-02, Singapore S038988. Until further notice I receive £30,000 per year, paid monthly, for providing strategic advice to the Board. Hours: up to 84 hrs a year. I consulted ACoBA about this appointment. (Registered 11 June 2021) | Employment and earnings 10057ffd | 2023-10-30 | Alun Cairns uk.org.publicwhip/person/24740 | 2 | 2023-10-30-10057ffd-24740-0 | |
| 3dcca3fd630518ecda510f8e426b76da9d0d8c55 | Payments from Yonder, Northburgh House,10 Northburgh Street, London EC1V 0AT, for surveys: | Employment and earnings 10057ffd | 2023-10-30 | Alun Cairns uk.org.publicwhip/person/24740 | 3 | 2023-10-30-10057ffd-24740-0 | |
| 5d13313d063180fe62b519d2e8ed7024ba74c217 | 9 December 2022, received £75. Hours: 25 mins. (Registered 09 December 2022) | Employment and earnings 10057ffd | 2023-10-30 | Alun Cairns uk.org.publicwhip/person/24740 | 4 | 2023-10-30-10057ffd-24740-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");