items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2023-10-16-10057ffd-11946-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 |
|---|---|---|---|---|---|---|---|
| 595ceea0a41eb9a435dcb68045524e4cb8fb9f78 | Director of MAP Advisory Ltd, c/o Gallaghers, 2nd Floor, 69/85 Tabernacle Street, London EC2A 4RR. (Registered 7 September 2013; updated 7 July 2015 and 25 April 2022) | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 0 | 2023-10-16-10057ffd-11946-0 | |
| 43735738d5dbbefa3e471bce80b3095e43020c06 | From 1 April 2022 until further notice, I provide strategic marketing counsel to Strategeast; a non-profit organisation which promotes the rule of law in Eurasian countries through the digital economy and a client of MAP Advisory Ltd. Address: 1900K Street NW, Suite 100, Washington DC 20006, USA. I receive £2,083.33 per month. Hours: 10 hrs a month. First payment received on 9 May 2022. (Registered 06 June 2022) | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 1 | 2023-10-16-10057ffd-11946-0 | |
| 65f4742fe427459e7131596cfae293e6e5d284ca | Payments from Linden Energy Holdings, Inc; an energy development company and a client of MAP Advisory Ltd. Address: 700 Milam Street, Suite 1300, Houston, Texas, 77002, USA. | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 2 | 2023-10-16-10057ffd-11946-0 | |
| 296f073f7ce46b8aa2147007695d76eebc8e392c | From 26 August 2022 until further notice, I am Lead Marketing Counsel and Vice Chairman of the Advisory Board at Linden Energy Holdings, Inc. I receive £4,900 per month. Hours: 12 hrs a month. (Registered 22 September 2022; updated 02 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 3 | 2023-10-16-10057ffd-11946-0 | |
| be37004def739bd41a31d25ca4b9bfdcf61c4f48 | From 1 September 2022 until 31 July 2023, I provided marketing advice to Redway AG; an engineering and technical services company and a client of MAP Advisory Ltd. Address: Oberer Graben 4-6, 9001, St Gallen, Switzerland. I received £4,000 per month. Hours: 12 hrs per month. First payment received on 12 October 2022. (Registered 08 August 2022; updated 16 August 2023) | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 4 | 2023-10-16-10057ffd-11946-0 | |
| d3b98b38fc7c979a4659439ee8c4f8c73b6d0ae4 | Payments from 39th Street Strategies LLC, 9801 67th Avenue, New York, USA, a market research company: | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 5 | 2023-10-16-10057ffd-11946-0 | |
| 4a4126922020c2d442089a1473a6fa598cf0eabf | 4 November 2022, received £2,600 as a further commission payment for market research services previously registered. Hours: no additional hours. (Registered 01 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 6 | 2023-10-16-10057ffd-11946-0 | |
| d4690bd3d2e734d3eb1d87c2a8d71bfdb7aaf8db | 2 June 2023, received £709 as a further commission payment for market research services previously registered. Hours: no additional hours. (Registered 30 June 2023) | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 7 | 2023-10-16-10057ffd-11946-0 | |
| d0a01dbff2f7c5c94b9ca6d3bd70c8984cc52884 | From 1 January 2023 until further notice, I hold the position of Marketing Counsel to Focal Point Energy LLC (energy investment and development), 1250 Wood Branch Park Drive, Suite 490, Houston, TX, 77079, USA. I received £3,900 per month for January and February 2023, paid on 1 and 3 February 2023 respectively. Any further payments will be listed below. Hours: 12 hrs per month. (Registered 27 February 2023; updated 20 July 2023) | Employment and earnings 10057ffd | 2023-10-16 | Mark Pritchard uk.org.publicwhip/person/11946 | 8 | 2023-10-16-10057ffd-11946-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");