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 = 2 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
8c681c279a5c614fdac5844e35739a61f00adfc7 | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2010-04-12 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2010-04-12-80ef1083-10071-0 |
a92d9a88a24a20b779b422f43a1bfd1ccd78e50e | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2010-03-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2010-03-24-80ef1083-10071-0 |
f15f30675e8a95b6c2728b5ef2df11cb46a2d07a | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2010-03-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2010-03-10-80ef1083-10071-0 |
0c4640b1b6c78737ee66864d28a955d7a66441c1 | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2010-02-24 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2010-02-24-80ef1083-10071-0 |
cbda8d4fea045c644b3cbaa62ba0b3b7649d54c8 | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2010-02-03 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2010-02-03-80ef1083-10071-0 |
1e8d64ce7b683c24552ed7f3b2b2b873d5bc6e57 | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2010-01-06 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2010-01-06-80ef1083-10071-0 |
aeb6d9c5aa8646a7d3ce40141213939bd9067e7e | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2009-12-10 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2009-12-10-80ef1083-10071-0 |
3f551b0084e99a20a2d28cadcfe64d3812521476 | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2009-11-25 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2009-11-25-80ef1083-10071-0 |
5652235dc0abfcbd8d3ce0d876f550f0a2870a5f | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2009-11-11 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2009-11-11-80ef1083-10071-0 |
dc7c37e674becdada3877168bcdbc9a5484816f6 | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2009-10-28 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2009-10-28-80ef1083-10071-0 |
f2cf84e26cce1870a878e667b034c82204faf4ec | Address of donor: The Grayston Centre, 28 Charles Square, London, N1 6HT | Overseas visits 80ef1083 | 2009-10-14 | Des Browne uk.org.publicwhip/member/1996 | Des Browne uk.org.publicwhip/person/10071 | 2 | 2009-10-14-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");