items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where item = "I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015)" 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 |
---|---|---|---|---|---|---|---|
c10eec5fcf98202d55943348d33fa76a40193ca4 | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-05-02 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-05-02-5f2cbd10-10008-0 | |
40a4e060c49058c2f40539c2f72edf3c68312597 | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-04-10 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-04-10-5f2cbd10-10008-0 | |
0628f0bbf93fbf5a5cb7c8602fd8fff7637d689e | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-03-20 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-03-20-5f2cbd10-10008-0 | |
dd9ff92ce647bfa32eb8c790f621fafbf22a417d | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-03-06 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-03-06-5f2cbd10-10008-0 | |
e1a3d121ad402188cd64a0d3bc82ea2193b3adbc | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-02-20 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-02-20-5f2cbd10-10008-0 | |
31ce6f46b2e1ba2fb3343fa24766ab9918111590 | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-02-06 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-02-06-5f2cbd10-10008-0 | |
8f1a455a5e490072563a10d18a65a90f7939d60a | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-01-23 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-01-23-5f2cbd10-10008-0 | |
3f5f812a87e072ca408e0118daf29b8b037ae484 | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2017-01-09 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2017-01-09-5f2cbd10-10008-0 | |
3232757b3e9ff79dd3eb436c32f9703778f82a51 | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2016-12-19 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2016-12-19-5f2cbd10-10008-0 | |
f6e374e4af40ee8cb8c68b38dc2bf6c7f31eadd3 | I am unremunerated Chair of the Rebalancing the Outer Estates Foundation, a registered charity. (Registered 22 October 2014; updated 13 May 2015) | Miscellaneous 5f2cbd10 | 2016-12-05 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 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");