items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
1 row where record_id = "2016-01-25-a5bbc519-25330-0" sorted by sort_order descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
edfe91fd5157993ff192818a90945b3de3a720eb | New River Retail Limited, a property investment company which is a specialist owner, manager and developer of UK retail and leisure assets. The shares are held jointly with my husband. The value of the shares became registrable in October 2015. (Registered 29 October 2015; updated 14 January 2016) | (ii) Other shareholdings, valued at more than £70,000 a5bbc519 | 2016-01-25 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2016-01-25-a5bbc519-25330-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");