items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2,836 rows where person_id = "uk.org.publicwhip/person/10084" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, sort_order, record_id
date (date) 205 ✖
- 2015-01-26 62
- 2015-02-09 62
- 2015-02-23 62
- 2015-03-09 62
- 2015-03-30 62
- 2010-09-06 61
- 2010-10-25 61
- 2010-04-12 59
- 2010-11-08 56
- 2010-12-20 52
- 2011-01-10 52
- 2010-11-22 51
- 2010-12-06 51
- 2010-03-24 49
- 2010-03-10 47
- 2010-02-03 43
- 2010-02-24 40
- 2010-01-06 38
- 2015-01-06 36
- 2014-09-22 34
- 2014-10-13 34
- 2014-10-27 34
- 2014-11-10 34
- 2014-11-24 34
- 2014-12-08 34
- 2011-01-24 32
- 2011-02-07 32
- 2011-02-28 32
- 2014-08-26 32
- 2014-07-28 28
- 2009-11-25 27
- 2009-12-10 27
- 2018-06-18 26
- 2018-07-02 26
- 2018-07-16 26
- 2011-03-14 25
- 2011-03-28 25
- 2018-04-30 24
- 2018-05-14 24
- 2018-06-04 24
- 2018-01-22 22
- 2018-02-05 22
- 2018-02-19 22
- 2018-03-05 22
- 2018-03-19 22
- 2018-04-16 22
- 2018-01-08 21
- 2018-12-17 21
- 2018-11-19 18
- 2018-12-03 18
- 2019-01-21 18
- 2009-10-28 17
- 2009-11-11 17
- 2017-12-11 17
- 2018-08-13 17
- 2018-09-10 17
- 2018-10-01 17
- 2018-10-15 17
- 2018-10-29 17
- 2009-10-14 16
- 2014-06-16 16
- 2014-06-30 16
- 2014-07-14 16
- 2019-01-07 16
- 2017-11-27 15
- 2019-02-04 15
- 2019-02-18 15
- 2019-03-04 15
- 2019-03-18 15
- 2019-04-01 15
- 2019-04-23 15
- 2019-06-17 15
- 2019-07-29 15
- 2019-11-05 15
- 2017-11-13 14
- 2019-05-07 14
- 2019-05-20 14
- 2019-06-03 14
- 2019-07-15 14
- 2019-08-12 14
- 2019-09-02 14
- 2019-09-16 14
- 2019-09-30 14
- 2019-10-21 14
- 2017-10-09 13
- 2017-10-23 13
- 2019-07-01 13
- 2009-09-02 12
- 2017-07-07 12
- 2017-07-31 12
- 2017-08-29 12
- 2017-09-11 12
- 2005-11-01 11
- 2005-12-14 11
- 2009-06-10 11
- 2009-06-24 11
- 2009-07-08 11
- 2009-07-21 11
- 2009-05-20 10
- 2009-05-06 8
- 2006-02-13 7
- 2006-02-14 7
- 2006-03-24 7
- 2006-05-12 7
- 2006-06-21 7
- 2006-07-25 7
- 2006-09-19 6
- 2008-11-19 6
- 2008-12-03 6
- 2009-04-22 6
- 2011-04-18 6
- 2011-05-03 6
- 2011-05-16 6
- 2008-10-08 5
- 2008-10-22 5
- 2008-11-05 5
- 2009-02-25 5
- 2009-03-11 5
- 2009-03-25 5
- 2005-01-28 4
- 2005-04-11 4
- 2008-07-22 4
- 2008-09-03 4
- 2008-06-16 3
- 2008-07-08 3
- 2009-01-28 3
- 2009-02-11 3
- 2011-06-06 3
- 2011-06-20 3
- 2011-07-06 3
- 2011-07-19 3
- 2011-08-30 3
- 2011-09-28 3
- 2011-10-17 3
- 2011-10-31 3
- 2011-11-16 3
- 2011-11-29 3
- 2011-12-13 3
- 2012-01-13 3
- 2000-11-10 2
- 2001-05-14 2
- 2008-03-25 2
- 2008-04-23 2
- 2008-12-17 2
- 2009-01-14 2
- 2012-01-30 2
- 2012-02-20 2
- 2012-03-05 2
- 2012-03-19 2
- 2012-04-16 2
- 2012-04-30 2
- 2012-05-14 2
- 2012-06-11 2
- 2012-06-25 2
- 2012-07-09 2
- 2012-07-30 2
- 2012-09-03 2
- 2012-10-01 2
- 2012-10-22 2
- 2012-11-05 2
- 2012-11-19 2
- 2012-12-03 2
- 2012-12-19 2
- 2013-01-18 2
- 2013-02-04 2
- 2013-02-25 2
- 2013-03-11 2
- 2013-04-08 2
- 2013-04-22 2
- 2013-05-07 2
- 2013-05-20 2
- 2013-06-10 2
- 2013-06-24 2
- 2013-07-08 2
- 2013-07-29 2
- 2013-08-27 2
- 2013-09-09 2
- 2013-09-30 2
- 2013-10-14 2
- 2013-10-28 2
- 2013-11-11 2
- 2013-11-25 2
- 2013-12-09 2
- 2014-01-06 2
- 2014-01-20 2
- 2014-02-03 2
- 2014-02-24 2
- 2014-03-10 2
- 2014-03-21 2
- 2014-03-24 2
- 2014-04-07 2
- 2014-04-28 2
- 2014-05-12 2
- 2014-06-02 2
- 2002-05-14 1
- 2002-11-26 1
- 2003-12-04 1
- 2004-01-31 1
- 2004-05-21 1
- 2004-07-16 1
- 2004-09-08 1
- 2008-01-22 1
- 2008-02-05 1
- 2008-02-26 1
- 2008-03-11 1
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");