items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where category_id = "9e46def6" and person_id = "uk.org.publicwhip/person/10012" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
3f8cf73466acef482624bf438ce2ec2123d01a46 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2009-01-28 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2009-01-28-9e46def6-10012-0 |
316cdd40c678c30755be7058e45cc7303ceac30f | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2009-01-14 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2009-01-14-9e46def6-10012-0 |
016db51dd23983216ba32474ea3ef9a29052cae3 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-12-17 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-12-17-9e46def6-10012-0 |
807366911c487235f9b971917cb5252cf36f12df | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-12-03 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-12-03-9e46def6-10012-0 |
5fdf99e6df9ee28049d7dcfa7506f88bfda41c4a | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-11-19-9e46def6-10012-0 |
239fe35497befc4ee5c1767cb6a5ec40e5e381cc | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-11-05 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-11-05-9e46def6-10012-0 |
5051f586a39fd1b9d5e6fd2a77f515eba0a0d1c1 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-10-22 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-10-22-9e46def6-10012-0 |
94776ec55fb17bdc26971c324a11ae091251c433 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-10-08-9e46def6-10012-0 |
3677e48b159373afbea9ca8ccda9a587fbcb5dbe | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-09-03 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-09-03-9e46def6-10012-0 |
7ec2b75fbc6c8ad79334594bb3a095e23e0c74f6 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-07-22 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-07-22-9e46def6-10012-0 |
5bccc0ce296b33db5d440d6cec6b5c5076dc7f1e | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-07-08 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-07-08-9e46def6-10012-0 |
bf3afb983f59fd801832241735e05853aad47245 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-06-16 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-06-16-9e46def6-10012-0 |
a9054d8d89b809737c7de5991e41de408bd32d4b | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-04-23 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-04-23-9e46def6-10012-0 |
a9a88b33f3740f3c7c6f0701553847714dec5b29 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-03-25 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-03-25-9e46def6-10012-0 |
f0f0863815dec6b0480e6fa704a51f83f7bc247d | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-03-11 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-03-11-9e46def6-10012-0 |
08724a98e5259122979c4632b463a2aea043401a | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-02-26 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-02-26-9e46def6-10012-0 |
7d36d3c7d6a26c14945f960b349e097c75343144 | Donation to my constituency party from B & E Boys Ltd of Rossendale. (Registered 29 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-02-05 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2008-02-05-9e46def6-10012-0 |
aff4d74aa8e89a7d6c57ecb35427065476b76bed | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2006-07-25-9e46def6-10012-0 |
e5dccbbd0e933bbd1305683a8c0f3fd61f34705e | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2006-06-21-9e46def6-10012-0 |
633d420787af7af179741fd8de55fbaae4164216 | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2006-05-12-9e46def6-10012-0 |
046cdc9db1fb95d50dfe8b35f5c7236551e51139 | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2006-03-24-9e46def6-10012-0 |
dd99aa5d2837ac48f5a82e6b8d3f9d7130a39f55 | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2006-02-14-9e46def6-10012-0 |
df7341d3c1bb70c02723bd5ccee2861d628b2b8c | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2006-02-13-9e46def6-10012-0 |
e2d35e8ccf4043f7341d94ce99bda166b2ceb000 | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2005-12-14-9e46def6-10012-0 |
c96a364ea0521529ead97a8ca7b9f08f440f5abe | Donation to my constituency party from Mr Brian Boys (personal donation from constituent). (Registered 15 September 2005) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Janet Anderson uk.org.publicwhip/member/1788 | Janet Anderson uk.org.publicwhip/person/10012 | 0 | 2005-11-01-9e46def6-10012-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");