items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where person_id = "uk.org.publicwhip/person/10083" and sort_order = 7 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
bb1e1b2b00f5fc44b071e92d2db30ad552dd0df9 | (Registered 15 October 2009) | Overseas visits 80ef1083 | 2010-04-12 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2010-04-12-80ef1083-10083-0 |
607566af90429106b390674f3a69c8629d93d381 | (Registered 15 October 2009) | Overseas visits 80ef1083 | 2010-03-24 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2010-03-24-80ef1083-10083-0 |
82db5c0049a73ec94b0372110547bd337355d5f1 | (Registered 15 October 2009) | Overseas visits 80ef1083 | 2010-03-10 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2010-03-10-80ef1083-10083-0 |
934d7059f26cc1e9379139095bf936c07d9cda89 | (Registered 15 October 2009) | Overseas visits 80ef1083 | 2010-02-24 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2010-02-24-80ef1083-10083-0 |
af3259c1bc0b1a9b5f2b1a579d6c52121535e138 | Date of visit: 9 - 11 September 2009 | Overseas visits 80ef1083 | 2010-02-03 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2010-02-03-80ef1083-10083-0 |
a9de28d45f37ad8d021943a4b1b9adcc42013b50 | Date of visit: 9 - 11 September 2009 | Overseas visits 80ef1083 | 2010-01-06 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2010-01-06-80ef1083-10083-0 |
5249bf83c72668b6bbcb86dad1ef7ba5c29467ce | Date of visit: 9 - 11 September 2009 | Overseas visits 80ef1083 | 2009-12-10 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2009-12-10-80ef1083-10083-0 |
2059a1576c80c5528523f80b1d1cd2a3c9b8de19 | Date of visit: 9 - 11 September 2009 | Overseas visits 80ef1083 | 2009-11-25 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2009-11-25-80ef1083-10083-0 |
f1979dfd48376748a9fb7f8df5aa78ddab224b8b | Date of visit: 9 - 11 September 2009 | Overseas visits 80ef1083 | 2009-11-11 | Stephen Byers uk.org.publicwhip/member/1888 | Stephen Byers uk.org.publicwhip/person/10083 | 7 | 2009-11-11-80ef1083-10083-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");