items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where person_id = "uk.org.publicwhip/person/10266" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
dba057ba3904765348c341ed989e095352f498f4 | Contribution towards general election campaign expenditure received by my constituency party from GMB. (Registered 12 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Sylvia Heal uk.org.publicwhip/member/2018 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2006-06-21-9e46def6-10266-0 |
77be0d74560214472566691d2d20964d78778519 | Contribution towards general election campaign expenditure received by my constituency party from GMB. (Registered 12 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Sylvia Heal uk.org.publicwhip/member/2018 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2006-05-12-9e46def6-10266-0 |
cf504fd6039e700bcb613ad834e5d25a3603a28c | Contribution towards general election campaign expenditure received by my constituency party from GMB. (Registered 12 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Sylvia Heal uk.org.publicwhip/member/2018 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2006-03-24-9e46def6-10266-0 |
f618982e6b073cdc38241fd842b272713e7e312e | Contribution towards general election campaign expenditure received by my constituency party from GMB. (Registered 12 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Sylvia Heal uk.org.publicwhip/member/2018 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2006-02-14-9e46def6-10266-0 |
85b8acc355af81b83cd199a003113370f5ba8bcc | Contribution towards general election campaign expenditure received by my constituency party from GMB. (Registered 12 July 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Sylvia Heal uk.org.publicwhip/member/2018 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2006-02-13-9e46def6-10266-0 |
72940a0301bf0bd1a8dd3d0ccf6485589561fb7f | Contribution towards general election campaign expenditure received by my constituency party from GMB. (Registered 12 July 2005) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Sylvia Heal uk.org.publicwhip/member/2018 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2005-12-14-9e46def6-10266-0 |
30f4b53f22d2255ce8aa3b62c8d245c6a9c2f233 | Contribution towards general election campaign expenditure received by my constituency party from GMB. (Registered 12 July 2005) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Sylvia Heal uk.org.publicwhip/member/2018 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2005-11-01-9e46def6-10266-0 |
ae074543793737522e15c6ee777104dce67d9c95 | A contribution of more than 25% of my election expenses at the 2001 General Election was made by the GMB Union. | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Sylvia Heal uk.org.publicwhip/member/947 | Sylvia Heal uk.org.publicwhip/person/10266 | 0 | 2002-05-14-9e46def6-10266-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");