items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where item = "I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014)" and person_id = "uk.org.publicwhip/person/10008" 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 |
---|---|---|---|---|---|---|---|
798d65416fcb3cf64cc1e37e978b40322505786d | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-05-02 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-05-02-5f2cbd10-10008-0 | |
15b3a113c3452769cdd14f587d794b7863034b13 | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-04-10 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-04-10-5f2cbd10-10008-0 | |
8b96a2190fd88f0eff08ed0279ff1e1307541871 | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-03-20 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-03-20-5f2cbd10-10008-0 | |
595dd602d9fb00dc06456a904952a84ab178ce85 | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-03-06 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-03-06-5f2cbd10-10008-0 | |
05d5e04861a0165ad41fe4ae41b05fab594c85c5 | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-02-20 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-02-20-5f2cbd10-10008-0 | |
3c8d4ff7ae0e86238ceaccf817aa45149795264c | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-02-06 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-02-06-5f2cbd10-10008-0 | |
f0ec3d9e5dfc5dfc74a630db0788ac2441cf156b | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-01-23 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-01-23-5f2cbd10-10008-0 | |
e40b0006a997f9cef26f761629798c87fe8a5723 | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2017-01-09 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2017-01-09-5f2cbd10-10008-0 | |
7fefdf4d354fc15f4a3bada5cff8dcbd44342b16 | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2016-12-19 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2016-12-19-5f2cbd10-10008-0 | |
4766d2e0e237de30206ace155b01142545f06d16 | I am unremunerated Founding Chair of trustees of the Early Intervention Foundation, a registered Charity. (Registered 12 December 2012; updated 22 October 2014) | Miscellaneous 5f2cbd10 | 2016-12-05 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2016-12-05-5f2cbd10-10008-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");