items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where item = "Donor status: trade union" and person_id = "uk.org.publicwhip/person/10329" 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 |
---|---|---|---|---|---|---|---|
1688e020c9a8d3163017618286609164bacab050 | Donor status: trade union | Sponsorships 8f616a6e | 2011-06-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-06-20-8f616a6e-10329-0 |
422da5559c7cb4d896887feab4c967586922b08f | Donor status: trade union | Sponsorships 8f616a6e | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-06-06-8f616a6e-10329-0 |
c56964d2a91bb26aeb6a56955db5003f692d61b8 | Donor status: trade union | Sponsorships 8f616a6e | 2011-05-16 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-05-16-8f616a6e-10329-0 |
6aecad64a4b5e224985a8c155ca00476f4d0ff0b | Donor status: trade union | Sponsorships 8f616a6e | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-05-03-8f616a6e-10329-0 |
b37218cfc264ab93ee85b1aa967990e279cc9a7c | Donor status: trade union | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-04-18-8f616a6e-10329-0 |
d859f2f77617bcba5144cadd22d7950835d6fa8e | Donor status: trade union | Sponsorships 8f616a6e | 2011-03-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-03-28-8f616a6e-10329-0 |
949c6619fc0ae7fbd785c7934bc53d4b9f6fe5df | Donor status: trade union | Sponsorships 8f616a6e | 2011-03-14 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-03-14-8f616a6e-10329-0 |
e2618a8eb9e959a9f786ddf808a842dc13dc1e02 | Donor status: trade union | Sponsorships 8f616a6e | 2011-02-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-02-28-8f616a6e-10329-0 |
4bc57642e13992077d87a2242748064b50875012 | Donor status: trade union | Sponsorships 8f616a6e | 2011-02-07 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-02-07-8f616a6e-10329-0 |
e5286765d09bbc64beed695d413896155e20158b | Donor status: trade union | Sponsorships 8f616a6e | 2011-01-24 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-01-24-8f616a6e-10329-0 |
d0282825489640800d0507fed651ef57b856f307 | Donor status: trade union | Sponsorships 8f616a6e | 2011-01-10 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-01-10-8f616a6e-10329-0 |
0437da87304f11384638f07bf93419b1ac52054f | Donor status: trade union | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-12-20-8f616a6e-10329-0 |
36e6c516e84f41536a122e492ed4cd16abf6ddf4 | Donor status: trade union | Sponsorships 8f616a6e | 2010-12-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-12-06-8f616a6e-10329-0 |
5bcdac39b1e4dd34054966d387b3c95634bb80f7 | Donor status: trade union | Sponsorships 8f616a6e | 2010-11-22 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-11-22-8f616a6e-10329-0 |
c7bdb70dafadc2e075c18a2d97e996edd0e8bf96 | Donor status: trade union | Sponsorships 8f616a6e | 2010-11-08 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-11-08-8f616a6e-10329-0 |
f6f65905d2697c2e1283c7d4beb037701d3b203f | Donor status: trade union | Sponsorships 8f616a6e | 2010-10-25 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-10-25-8f616a6e-10329-0 |
842c759faea5f8c69a64f764be1715881dfa2e35 | Donor status: trade union | Sponsorships 8f616a6e | 2010-09-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-09-06-8f616a6e-10329-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");