items

Table actions

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

4 rows where record_id = "2023-10-30-10057ffd-10162-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
39e1811a80f3bcf4969a0c279ea3ed5c3701ada7 From 1 December 2019 until further notice, Member of the Advisory Board of THI Holdings GmbH, Eberhardstrasse 65, 70173 Stuttgart (an investment company). I receive £33,900 per annum, paid quarterly by THI Investments UK Ltd, 17 Grosvenor Street, London W1K 4QG. Hours: approx. 16 hrs a year. I consulted ACoBA about this appointment. (Registered 09 January 2020) Employment and earnings 10057ffd 2023-10-30   David Davis uk.org.publicwhip/person/10162 0 2023-10-30-10057ffd-10162-0
72f77ecd589b6308946ddc9f9c5815fe16fdfc1d From 12 December 2019 until 31 May 2023, Chairman of the Supervisory Board of Kohlgartenstrasse 15 Verwaltungs AG, Bahnhofstrasse 8a, 15806 Zossen, Germany; a German real estate company. I received £16,948 per annum, paid monthly. Hours: approx. 168 hrs a year. I consulted ACoBA about this appointment. (Registered 09 January 2020; updated 07 July 2023) Employment and earnings 10057ffd 2023-10-30   David Davis uk.org.publicwhip/person/10162 1 2023-10-30-10057ffd-10162-0
c6c07f74fefed7493512f22469fd997cdc68206c 7 December 2022, received £200 from Radio 4’s Any Questions, BBC Broadcasting House, Whiteladies Road, Bristol BS8 2LR, for an appearance on BBC Radio 4’s Any Questions. Hours: 3 hrs. Fee will be donated to charity. (Registered 07 December 2022) Employment and earnings 10057ffd 2023-10-30   David Davis uk.org.publicwhip/person/10162 2 2023-10-30-10057ffd-10162-0
7d2f4f1d46f2255c37a4de45a82ec6c91e5f79d7 8 June 2023, payment of £400 from ANMFS LTD (Mail Group), Northcliffe House, 2 Derry Street, Kensington, London W8 5TT, for an article. Hours: 2 hrs. Fee paid direct to charity. (Registered 08 June 2023) Employment and earnings 10057ffd 2023-10-30   David Davis uk.org.publicwhip/person/10162 3 2023-10-30-10057ffd-10162-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");