items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2023-09-04-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 |
|---|---|---|---|---|---|---|---|
| 1a1917ba6ec1bf3959ca4c6c1d09dd1158a65e67 | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 0 | 2023-09-04-10057ffd-11946-0 | |
| 067c217851b4448b41610422e6d8d1acf1e2683c | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 1 | 2023-09-04-10057ffd-11946-0 | |
| cdbe79d27c3670915f1cfb08f18ddf45a62063c5 | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 2 | 2023-09-04-10057ffd-11946-0 | |
| 9f2f8dfe644330ce7b13f24a33c54b02ff773210 | From 1 May 2022 until 26 August 2022, I provided strategic marketing communications advice. I received £3,900 per month. Hours: 12 hrs a month. First payment received on 6 June 2022. (Registered 01 July 2022; updated 22 September 2022) | Employment and earnings 10057ffd | 2023-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 3 | 2023-09-04-10057ffd-11946-0 | |
| efcafbc796745a045b6afecfb6cbb6e99d4e8865 | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 4 | 2023-09-04-10057ffd-11946-0 | |
| 5931f14d7b70ab16679ee5d51834fa452dc107c8 | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 5 | 2023-09-04-10057ffd-11946-0 | |
| b0feeaaf301a26950f1f3c31f48750d3c6fd9539 | Payments from 39th Street Strategies LLC, 9801 67th Avenue, New York, USA, a market research company: | Employment and earnings 10057ffd | 2023-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 6 | 2023-09-04-10057ffd-11946-0 | |
| b48de960f58f4fa6e6463085ff58b4436f7e3abf | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 7 | 2023-09-04-10057ffd-11946-0 | |
| a11aea0520d6a7df404a88e7d1374d8a1c5efbf9 | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 8 | 2023-09-04-10057ffd-11946-0 | |
| bdc45cad5c4fe4755707853022a71050192c885e | 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-09-04 | Mark Pritchard uk.org.publicwhip/person/11946 | 9 | 2023-09-04-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");