items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3 rows where record_id = "2015-03-30-1aeb07b2-24826-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 |
|---|---|---|---|---|---|---|---|
| 36b1225c6a67eeb5ad5341f7b8df0d2a5e23d613 | Non-executive director for Response Eco Ltd, 18 Hyde Gardens, Eastbourne, East Sussex BN21 4PT; water treatment company. I will be paid £12,000 a year for 96 hrs in total. (Registered 10 September 2012) | Directorships 1aeb07b2 | 2015-03-30 | Andrew Griffiths uk.org.publicwhip/member/40133 | Andrew Griffiths uk.org.publicwhip/person/24826 | 0 | 2015-03-30-1aeb07b2-24826-0 |
| c7f9e0ffc4a25873fc1a0ae4c7cea08e5bca9bf7 | £12,000 advance payment received on 12 September 2013. Hours: 96 hrs. (Registered 18 September 2013, updated 21 October 2014) | Directorships 1aeb07b2 | 2015-03-30 | Andrew Griffiths uk.org.publicwhip/member/40133 | Andrew Griffiths uk.org.publicwhip/person/24826 | 1 | 2015-03-30-1aeb07b2-24826-0 |
| afdd05c23e8b383cf49f35ede78bb0160d1e4d0b | £12,000 advance payment received on 30 September 2014. (Registered 21 October 2014, updated 31 October 2014) | Directorships 1aeb07b2 | 2015-03-30 | Andrew Griffiths uk.org.publicwhip/member/40133 | Andrew Griffiths uk.org.publicwhip/person/24826 | 2 | 2015-03-30-1aeb07b2-24826-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");