items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2023-05-02-10057ffd-13736-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 |
|---|---|---|---|---|---|---|---|
| 5b87c011357a39c28ece3f7c4e5c409a0d07275d | Director of RJMN Ltd, 145-157 St John Street, London EC1V 4PW, a strategic consultancy business. (Registered 11 April 2014) | Employment and earnings 10057ffd | 2023-05-02 | Bob Neill uk.org.publicwhip/person/13736 | 0 | 2023-05-02-10057ffd-13736-0 | |
| 9f268cb5a6f9fb9a6c9bb0aca7d505c7a862d50a | The Hemming Group Ltd; a client of RJMN Ltd. Address: 32 Vauxhall Bridge Road, London SW1V 2SS. From 1 July 2018 until further notice, I receive £200 a month for a regular article in the Municipal Journal. Hours: 1.5 hrs per month. Any additional payments are listed below. (Registered 03 February 2015; updated 04 July 2018) | Employment and earnings 10057ffd | 2023-05-02 | Bob Neill uk.org.publicwhip/person/13736 | 1 | 2023-05-02-10057ffd-13736-0 | |
| a917e30dfe2d62a51f7658cd141e3eb2609a64a1 | From 1 December 2016 until 30 November 2022, consultant to the Substantia Group, a property and business consultancy. From 8 June 2020, I had the title of Senior Adviser. Between June 2017 and 7 June 2020, I had the title Non-Executive Chairman. Address: 55 Chislehurst Road, Chislehurst BR7 5NP. From 1 December 2016 I received £1,000 per month for providing strategic consultancy advice. Hours: 6 hrs per month. (Registered 22 December 2016; updated 08 June 2020 and 28 December 2022) | Employment and earnings 10057ffd | 2023-05-02 | Bob Neill uk.org.publicwhip/person/13736 | 2 | 2023-05-02-10057ffd-13736-0 | |
| ec3d1b05818c4601b034285c7aa507032f3c37a0 | From 4 January 2023, a Non-executive Director of Greenbank Capital Inc, a business transformation company specialising in start-up and early-stage companies based in Canada and the United Kingdom. Address: 100 King Street West, Suite 5700, Toronto, Ontario M5X 1C7, Canada. Until further notice, I receive £3,000 per month. Hours: 6 hrs a month. (Registered 31 January 2023; updated 21 April 2023) | Employment and earnings 10057ffd | 2023-05-02 | Bob Neill uk.org.publicwhip/person/13736 | 3 | 2023-05-02-10057ffd-13736-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");