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 = 5 sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
235e6ceeb7729e7f53781b9b5d68ad8f72c793dd | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2009-11-11 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2009-11-11-80ef1083-10071-0 |
235e98990c6e3445016eeb43bb8462c5de59018c | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2010-04-12 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2010-04-12-80ef1083-10071-0 |
523ea74718e08af72cd569ce9ee5f4dab41312a0 | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2010-03-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2010-03-24-80ef1083-10071-0 |
892de82c60f97969bbf616728d9dbcfc164838af | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2009-10-14 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2009-10-14-80ef1083-10071-0 |
994424beabdb651f4ff8c6223ba52510f8743ef0 | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2010-02-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2010-02-24-80ef1083-10071-0 |
b7b5a63fcec9f5ab2e5e99dcfe2e8b023dadccfe | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2009-12-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2009-12-10-80ef1083-10071-0 |
c164e9ac9f9ad5c8680998db6f8f5a08cdde4329 | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2009-10-28 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2009-10-28-80ef1083-10071-0 |
d1f853216734e23116d270d02cbe3098a2a82122 | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2010-03-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2010-03-10-80ef1083-10071-0 |
ddd876361570171ca646857b5440eaf4f90cf35b | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2009-11-25 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2009-11-25-80ef1083-10071-0 |
e2b7d53f7361bf30d816effef1feaef82309f0ff | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2010-02-03 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2010-02-03-80ef1083-10071-0 |
ee08973ba50d367a8ecb12920ce3895e07ccee69 | Date of visit: 8-13 September 2009 | Overseas visits 80ef1083 | 2010-01-06 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 5 | 2010-01-06-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");