items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where date = "2002-05-14" and person_id = "uk.org.publicwhip/person/10017" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
477ce03a320dcc5f414d7b3c9c04864ca0453af3 | Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Candy Atherton uk.org.publicwhip/member/702 | Candy Atherton uk.org.publicwhip/person/10017 | 0 | 2002-05-14-1f359ece-10017-0 |
4e0ad92801deb767090c3971d03d1985063f0ba3 | Member of Harris Political Opinion Panel. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Candy Atherton uk.org.publicwhip/member/702 | Candy Atherton uk.org.publicwhip/person/10017 | 1 | 2002-05-14-1f359ece-10017-0 |
501ee1a33a19b251bbde003ecba2ccf185a244e5 | Fees received from panels goes to my constituency office. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Candy Atherton uk.org.publicwhip/member/702 | Candy Atherton uk.org.publicwhip/person/10017 | 2 | 2002-05-14-1f359ece-10017-0 |
609bdeadb288de2a02a3606c7cf06ad47c93fdb7 | £12,000 in lieu of rent from Falmouth Labour Club to Falmouth Branch Labour Party. (Registered 7 October 2001) | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Candy Atherton uk.org.publicwhip/member/702 | Candy Atherton uk.org.publicwhip/person/10017 | 0 | 2002-05-14-9e46def6-10017-0 |
196d4ac5f71b2c822eda125bdc7714f4711baef1 | Small cottage in St. Day, Cornwall. | Land and Property 4f1e6359 | 2002-05-14 | Candy Atherton uk.org.publicwhip/member/702 | Candy Atherton uk.org.publicwhip/person/10017 | 0 | 2002-05-14-4f1e6359-10017-0 |
cf0db7ea5435e42c5bed6900edbc7eec235de702 | Trustee on the Board of Directors for Carn Brea Recreation Centre, Cornwall, a charitable trust (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Candy Atherton uk.org.publicwhip/member/702 | Candy Atherton uk.org.publicwhip/person/10017 | 0 | 2002-05-14-265f2269-10017-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");