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 = 12 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 |
---|---|---|---|---|---|---|---|
07a8a86fa9633a0c8524c0fdb1aa416e3265d968 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-06-02 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-06-02-8f616a6e-10075-0 |
1667ed1ca5a96b2afb06ee92bf8b874b353d2adc | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-10-13 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-10-13-8f616a6e-10075-0 |
30063f26f1c11c29e6b469599831a79b94983fcb | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-05-12 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-05-12-8f616a6e-10075-0 |
3b8ebc6e175da781d9a87498e5425d0e4582bc78 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-07-14 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-07-14-8f616a6e-10075-0 |
6cde615431e6536ae4374437edfb97bf46834180 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-09-22 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-09-22-8f616a6e-10075-0 |
93edf284771824db2322aef9d8e9dc4cf5402290 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-06-16 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-06-16-8f616a6e-10075-0 |
95bb4e250650127c0c9a907ba41530ca49e885b7 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-07-28 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-07-28-8f616a6e-10075-0 |
a7eb39f8d36f9a8dbcd9d44a2a4da1e2d208c726 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-04-28 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-04-28-8f616a6e-10075-0 |
ad16774e48a744a04904722cbb01a2937b225d75 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-06-30 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-06-30-8f616a6e-10075-0 |
ae714f9b75ba38a5868260d6c9fdf5147de6f528 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-10-27 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-10-27-8f616a6e-10075-0 |
b86b3e90b8357b37301782d9d7c1970160e79f25 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-08-26 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-08-26-8f616a6e-10075-0 |
c2090bfe517695077e1f8040be539a3ce28a1aa7 | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2014-04-07 | Karen Buck uk.org.publicwhip/member/40655 | Karen Buck uk.org.publicwhip/person/10075 | 12 | 2014-04-07-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");