items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2023-10-30-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 |
|---|---|---|---|---|---|---|---|
| 20443da6941e5bb8fcf02c952234cefb2717f691 | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 0 | 2023-10-30-10057ffd-11946-0 | |
| c0fb47316ad4474b60c30e9f10febdcc73d3d0aa | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 1 | 2023-10-30-10057ffd-11946-0 | |
| 356710a572123d69c3878439b33eb62f7d075ae1 | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 2 | 2023-10-30-10057ffd-11946-0 | |
| 3863bc4561fe2346e3c6af06b0eb3c86204e04c8 | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 3 | 2023-10-30-10057ffd-11946-0 | |
| c26082c288a03e5ff6d772c5f401cf6ca9c323ff | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 4 | 2023-10-30-10057ffd-11946-0 | |
| 7d46295cd84a7df2e378beb22ad44d636fcd248f | Payments from 39th Street Strategies LLC, 9801 67th Avenue, New York, USA, a market research company: | Employment and earnings 10057ffd | 2023-10-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 5 | 2023-10-30-10057ffd-11946-0 | |
| 9d3b856585d27044e1f7ec3d09363dad3b2f7e03 | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 6 | 2023-10-30-10057ffd-11946-0 | |
| ebb35917b495938097f66f73a53c522a6fc7b6e5 | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 7 | 2023-10-30-10057ffd-11946-0 | |
| bdad8f7d96c4a3696a5a4164f2ffaaeed7183784 | 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-30 | Mark Pritchard uk.org.publicwhip/person/11946 | 8 | 2023-10-30-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");