items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-10-16-10057ffd-10162-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 |
|---|---|---|---|---|---|---|---|
| f9ebde2baef3f4a406030f0b2036e4e238b1f689 | 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-16 | David Davis uk.org.publicwhip/person/10162 | 0 | 2023-10-16-10057ffd-10162-0 | |
| 5e321fc6d585ecf35d9890e16156dbecd97d64fd | 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-16 | David Davis uk.org.publicwhip/person/10162 | 1 | 2023-10-16-10057ffd-10162-0 | |
| b4f8ab6362bbeaa7679076fa32471ee54c9d4d7a | 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-16 | David Davis uk.org.publicwhip/person/10162 | 2 | 2023-10-16-10057ffd-10162-0 | |
| 476db74ac448d491945dd89c332f9aa94d2db34c | 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-16 | David Davis uk.org.publicwhip/person/10162 | 3 | 2023-10-16-10057ffd-10162-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");