items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where person_id = "uk.org.publicwhip/person/10071" and sort_order = 4 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 |
---|---|---|---|---|---|---|---|
6ba758cc9242520cdc6610989b7b23fbb952a027 | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2009-10-14 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2009-10-14-80ef1083-10071-0 |
78e4cc95db4808bb8cd2c4cd49c003567d58a4b6 | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2009-10-28 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2009-10-28-80ef1083-10071-0 |
3d5bd9087f936ba8be9f186bda1c8e682c837922 | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2009-11-11 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2009-11-11-80ef1083-10071-0 |
f45b0d13635f3f99ea41e87ffcb5cece666921de | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2009-11-25 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2009-11-25-80ef1083-10071-0 |
d17815954d18a71fe9bb93f229924bc69e89fff2 | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2009-12-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2009-12-10-80ef1083-10071-0 |
0b02b1d9c7afcab2d253d91a793f098c573a55a6 | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2010-01-06 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2010-01-06-80ef1083-10071-0 |
c399e86e68bf64f90040070ba7186c7854c0c74c | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2010-02-03 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2010-02-03-80ef1083-10071-0 |
46203fab6b0d833b43a7e152d8296b3e2e80757f | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2010-02-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2010-02-24-80ef1083-10071-0 |
126d8e6a20aa79e75db13947ca0b8d1b102e448e | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2010-03-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2010-03-10-80ef1083-10071-0 |
e93dd0f976a4ca08771105fc933a7b667b1b8948 | Destination of visit: Washington DC, US | Overseas visits 80ef1083 | 2010-03-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 4 | 2010-03-24-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");