items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where person_id = "uk.org.publicwhip/person/10071" and sort_order = 7 sorted by person_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
e68e095f648ec400c8d7ce68518e40833d1e3046 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2009-10-14 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2009-10-14-80ef1083-10071-0 |
c34b0e1b40c1540a52c265ea0bc82e774b2787aa | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2009-10-28 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2009-10-28-80ef1083-10071-0 |
c9c8c9c2911c89a4bee572ceb48d4be5f745e963 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2009-11-11 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2009-11-11-80ef1083-10071-0 |
5db4a21ed17b47e268d01e8e7d037104e144f11c | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2009-11-25 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2009-11-25-80ef1083-10071-0 |
03975c902c47bee2c014e1400abdfd7074821680 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2009-12-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2009-12-10-80ef1083-10071-0 |
260d33ce417ecc9f260895b2359b279e1bdbebfb | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2010-01-06 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2010-01-06-80ef1083-10071-0 |
dea6a08e8938aa396bab9b5f0fdb5acc5607f607 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2010-02-03 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2010-02-03-80ef1083-10071-0 |
d830bcace40dc0b04a34951f8350ea697dac8190 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2010-02-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2010-02-24-80ef1083-10071-0 |
6b484d2d23ddee1700edd0e494ad22e123ba02b1 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2010-03-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2010-03-10-80ef1083-10071-0 |
cec72f46b5bdf624f0f94361a5cd0bf051d5f9b0 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2010-03-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2010-03-24-80ef1083-10071-0 |
3373a453513cdee0ca25235a774b790dc061cf44 | (Registered 30 September 2009) | Overseas visits 80ef1083 | 2010-04-12 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 7 | 2010-04-12-80ef1083-10071-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");