items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
549 rows where person_id = "uk.org.publicwhip/person/10031" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, sort_order
date (date) >30 ✖
- 2014-05-12 6
- 2014-06-02 6
- 2014-06-16 6
- 2014-06-30 6
- 2014-07-14 6
- 2014-07-28 6
- 2014-08-26 6
- 2014-09-22 6
- 2014-10-13 6
- 2014-10-27 6
- 2014-11-10 6
- 2014-11-24 6
- 2014-12-08 6
- 2015-01-06 6
- 2015-01-26 6
- 2015-02-09 6
- 2015-02-23 6
- 2015-03-09 6
- 2015-03-30 6
- 2009-02-25 5
- 2009-03-11 5
- 2009-03-25 5
- 2009-04-22 5
- 2009-05-06 5
- 2009-05-20 5
- 2009-06-10 5
- 2008-06-16 4
- 2008-07-08 4
- 2008-07-22 4
- 2008-09-03 4
- …
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");