items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where member_id = "uk.org.publicwhip/member/431" and person_id = "uk.org.publicwhip/person/10431" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ca56f508262922becc922c28d336d96f973007b2 | Very occasional journalism. | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | Alun Michael uk.org.publicwhip/member/431 | Alun Michael uk.org.publicwhip/person/10431 | 0 | 2001-05-14-f3967f4d-10431-0 |
6117259f65006ca62b0e991527e51b6b3a7e15b5 | Fee received from Infolog Ltd., a company in London specialising in facilitating partnership training and development, for helping to plan and then chair three conferences on crime reduction issues for practitioners and professionals from crime reduction, local government, police etc. (Registered 11 May 2001) | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | Alun Michael uk.org.publicwhip/member/431 | Alun Michael uk.org.publicwhip/person/10431 | 1 | 2001-05-14-f3967f4d-10431-0 |
491a18e3d2d7f652d22a8f4b42ad581527d149b7 | Very occasional journalism. | Remunerated employment, office, profession, etc. f3967f4d | 2000-11-10 | Alun Michael uk.org.publicwhip/member/431 | Alun Michael uk.org.publicwhip/person/10431 | 0 | 2000-11-10-f3967f4d-10431-0 |
2dc3cb6439705387419ffec8e62f9b96b6b52fd4 | Member of the National Assembly for Wales and First Secretary. | Remunerated employment, office, profession, etc. f3967f4d | 2000-11-10 | Alun Michael uk.org.publicwhip/member/431 | Alun Michael uk.org.publicwhip/person/10431 | 1 | 2000-11-10-f3967f4d-10431-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");