items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2023-10-30-10057ffd-10213-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 |
|---|---|---|---|---|---|---|---|
| 5974fde091694246db0bd71f52610530b4616e7b | Contract with Quercus Editions Limited for writing a book. Address: Quercus Editions Limited, 55 Baker Street, 7th Floor, South Block, London, W1U 8EW. | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 0 | 2023-10-30-10057ffd-10213-0 | |
| 83b1172efb93a78ab776fbc4868fd2b6b28d6b79 | Payments from WorldPR, Humboldt Tower, East 53 Street, Panama City, Urb. Marbella, Republic of Panama: | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 1 | 2023-10-30-10057ffd-10213-0 | |
| 851f824db5b99a78f3dabbd045a442543e62427d | 7 October 2022, received £7,699 as part of a six-month retainer fee covering 1 September 2022 to 28 February 2023. If required, I will provide advice on Business and International Politics, and payments will be listed below. Hours: none to date. (Registered 28 October 2022) | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 2 | 2023-10-30-10057ffd-10213-0 | |
| 545494f509dfd4cc9f8b6a5b5acf989652a76b4e | Payment of £10,000 expected as a six-month retainer fee covering 1 January 2023 to 30 June 2023. If required, I will provide advice on Business and International Politics, and payments will be listed below. Hours: none to date. (Registered 30 December 2022) | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 3 | 2023-10-30-10057ffd-10213-0 | |
| f684c0e692069b4d9a310205d6e34d8fc70d4049 | 7 July 2023, received £10,000 as a six-month retainer fee covering 1 July 2023 to 31 December 2023. If required, I will provide advice on Business and International Politics, and payments will be listed below. Hours: none to date. (Registered 26 July 2023) | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 4 | 2023-10-30-10057ffd-10213-0 | |
| 1487c15d4e5a76aa835327821ec215a9406097b0 | From 18 October 2021, Chair of the Global Britain Commission, an independent, non-partisan, membership organisation which aims to ensure that economics and trade are at the heart of policy delivery. I receive payment for this role from Bradshaw Advisory, 83 Ducie Street, Manchester M1 2JQ. It was unpaid until 15 August 2022. (Registered 22 October 2021; updated 06 September 2022) | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 5 | 2023-10-30-10057ffd-10213-0 | |
| 2f7d177d7e15eda976c9667b858a47dbbe02e207 | Payment of £6,000 expected for the period 1 August 2022 to 31 January 2023. Hours: 6 hrs. (Registered 31 January 2023) | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 6 | 2023-10-30-10057ffd-10213-0 | |
| 15260d88e133d96867b13cfdb7e70ca1f47a56a0 | 18 May 2023, received £2,000 for the period 1 March 2023 to 30 April 2023. Hours: 2 hrs. (Registered 31 May 2023) | Employment and earnings 10057ffd | 2023-10-30 | Liam Fox uk.org.publicwhip/person/10213 | 7 | 2023-10-30-10057ffd-10213-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");