home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

5 rows where record_id = "2023-10-16-10057ffd-24740-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
e78edf5718ec1142be8d1aa8506dd257b163d1f1 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-16   Alun Cairns uk.org.publicwhip/person/24740 0 2023-10-16-10057ffd-24740-0
b3a775b4062f17bc8981d6d75cf4f65ab2686686 24 January 2023, received a termination payment of £8,000. Hours: no additional hours. (Registered 25 January 2023) Employment and earnings 10057ffd 2023-10-16   Alun Cairns uk.org.publicwhip/person/24740 1 2023-10-16-10057ffd-24740-0
bb7b3b1751366874b2790ae4f687cb5979adcc0e 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-16   Alun Cairns uk.org.publicwhip/person/24740 2 2023-10-16-10057ffd-24740-0
a5fa57e479eda90e584c239cf1a679d7ae9c0f65 Payments from Yonder, Northburgh House,10 Northburgh Street, London EC1V 0AT, for surveys: Employment and earnings 10057ffd 2023-10-16   Alun Cairns uk.org.publicwhip/person/24740 3 2023-10-16-10057ffd-24740-0
a95e2bfb09dafc78ae0d8e31d8b4f34908f60b71 9 December 2022, received £75. Hours: 25 mins. (Registered 09 December 2022) Employment and earnings 10057ffd 2023-10-16   Alun Cairns uk.org.publicwhip/person/24740 4 2023-10-16-10057ffd-24740-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");
Powered by Datasette · Queries took 14.077ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette