items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2021-01-04-10057ffd-24780-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 |
|---|---|---|---|---|---|---|---|
| 5a6d00763b762ba0c334f2f3d6317bf7802496c8 | Consultant to Trant Engineering Ltd, formerly Trant Construction Ltd, Rushington, Southampton SO40 9LT. Until 26 July 2019, I received £10,000 quarterly for 10 hours work per month. (Registered 27 June 2011; updated 14 July 2015, 12 October 2015 and 10 October 2019) | Employment and earnings 10057ffd | 2021-01-04 | Conor Burns uk.org.publicwhip/person/24780 | 0 | 2021-01-04-10057ffd-24780-0 | |
| 1bfc74f0d14de4fdd1df78edbc976912c77fabbd | From 1 February 2019 to 26 July 2019, consultant to The Affordable Housing and Healthcare Group, 170 Charminster Road, Bournemouth BH8 9RLH. I provided advice on providing key worker housing and elderly care provision using underutilised land. I received £12,500 on 12 August 2019 in return for a commitment of 6 hrs a month. This is a late registration to which the rectification procedure was applied on 10 June 2020. Paragraph 15 of chapter 4 of the 2019 Guide to the Rules refers. (Registered 26 February 2020; updated 10 June 2020) | Employment and earnings 10057ffd | 2021-01-04 | Conor Burns uk.org.publicwhip/person/24780 | 1 | 2021-01-04-10057ffd-24780-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");