items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where person_id = "uk.org.publicwhip/person/10075" and sort_order = 11 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 |
---|---|---|---|---|---|---|---|
1f6b7e35f79c0062cfd954182ec8da8bdad703c6 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-07-14 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-07-14-8f616a6e-10075-0 |
2dd751734787a42cd66ce5d4b0ec5191b16a40f5 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-04-07 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-04-07-8f616a6e-10075-0 |
6cbb53160df5b78436ccd5f52c02a6adda0989dc | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-02 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-06-02-8f616a6e-10075-0 |
6d104687400989492bbfe53d588be5fb65e2aad2 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-08-26 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-08-26-8f616a6e-10075-0 |
85565451d8d3c4b17920b551c9870cea6c0a4f01 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-05-12 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-05-12-8f616a6e-10075-0 |
86b6a44f6b7cd27b1da20303a753b8a329a39c34 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-30 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-06-30-8f616a6e-10075-0 |
929f17918d0d16a6f53cba0ecbd75d70852e2581 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-10-13 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-10-13-8f616a6e-10075-0 |
9770df2fe119e36427da3b4d8e47a9b1d8bf5efd | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-06-16 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-06-16-8f616a6e-10075-0 |
a56f8ef813e0c398e4ee0a08cb7932da3c421c5d | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-04-28 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-04-28-8f616a6e-10075-0 |
c74077e2d27fa4465a04c72e0556b83a4ab8bcc6 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-07-28 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-07-28-8f616a6e-10075-0 |
d2a318c47dc7da25875aad7318dd61969b03e7ec | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-10-27 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-10-27-8f616a6e-10075-0 |
d51f9a7a2db4f8a7529cf6db83e063efd8f35f24 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2014-09-22 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 11 | 2014-09-22-8f616a6e-10075-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");