items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where member_id = "uk.org.publicwhip/member/937" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
58242860483b0f4111ae006a6ac5d95b0a61fd6d | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2005-04-11-1f359ece-10258-0 |
db2322e49a5142aa5ca50d2e503f791d65129d66 | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc.. 12405e8c | 2005-01-28 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2005-01-28-12405e8c-10258-0 |
e1328cae382824ad5d90bd26d5ec9740da2ac34c | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2004-12-03-1f359ece-10258-0 |
bb442ccd86988ef401e66d0601459175b1e0b2e1 | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2004-10-22-1f359ece-10258-0 |
30718f867a2022ee522a21c434d169c60c4e65e5 | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2004-09-08-1f359ece-10258-0 |
55468a9c2ce3e75c039bd091ba144759c5c1f1da | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2004-07-16-1f359ece-10258-0 |
579ece3013fa71a2998e18b32a72dfd66f306657 | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2004-05-21-1f359ece-10258-0 |
f2e4bb31470d8cec831af2c33bcf0e4a282dc087 | Councillor and an Executive Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2004-01-31-1f359ece-10258-0 |
135e552e70ba90df8d7da63b7f53dfe22c9ce672 | Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2003-12-04-1f359ece-10258-0 |
15fbfac8420b89d8055e0d6de517e283f6828935 | Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2002-11-26-1f359ece-10258-0 |
a3b0c4bcb705ea511a313807e335eb78a4c963a3 | Member of Portsmouth City Council. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Mike Hancock uk.org.publicwhip/member/937 | Mike Hancock uk.org.publicwhip/person/10258 | 0 | 2002-05-14-1f359ece-10258-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");