items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
1,960 rows where category_id = "eeb1f309" sorted by person_id descending
This data as json, CSV (advanced)
Suggested facets: sort_order, date (date)
person_id 25 ✖
- Paul Bristow 211
- Nia Griffith 175
- Ruth Cadbury 175
- Wes Streeting 163
- Paul Scully 118
- John Whittingdale 111
- Sarah Jones 107
- James Morris 97
- Norman Lamb 88
- Amber Rudd 87
- Feryal Clark 86
- Victoria Atkins 77
- Sue Hayman 62
- Ruth Edwards 45
- Sarah Green 42
- Jim Dowd 38
- Alan Haselhurst 38
- Tom Blenkinsop 38
- George Kerevan 38
- Guy Opperman 34
- Sajid Javid 29
- Mark Tami 28
- Dehenna Davison 27
- Kevin Barron 24
- Darren Jones 22
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");