items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where member_id = "uk.org.publicwhip/member/136" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
69a47ddba8137a06fbd12f3f95442c2ac7961c82 | Chairman, Plasticable Ltd.; private company, manufacturer of plastic extrusions. | Remunerated directorships ead1ca87 | 2001-05-14 | Brian Cotter uk.org.publicwhip/member/136 | Brian Cotter uk.org.publicwhip/person/10136 | 0 | 2001-05-14-ead1ca87-10136-0 |
bfdce349e96379ec3eda6a4c8bde5577e773eb3c | Plasticable Ltd. | Registrable shareholdings 3aff2389 | 2001-05-14 | Brian Cotter uk.org.publicwhip/member/136 | Brian Cotter uk.org.publicwhip/person/10136 | 0 | 2001-05-14-3aff2389-10136-0 |
939b8584835ab17a0093fd5fc90d3f0a89964ec6 | Director (unremunerated) of The Genesis Initiative Ltd.; promoting the interests of small business at national and international level. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Brian Cotter uk.org.publicwhip/member/136 | Brian Cotter uk.org.publicwhip/person/10136 | 0 | 2001-05-14-265f2269-10136-0 |
4491ce1ca47e1ea53a954052faf12e2e7838599e | Chairman, Plasticable Ltd.; private company, manufacturer of plastic extrusions. | Remunerated directorships ead1ca87 | 2000-11-10 | Brian Cotter uk.org.publicwhip/member/136 | Brian Cotter uk.org.publicwhip/person/10136 | 0 | 2000-11-10-ead1ca87-10136-0 |
d6a424f8d742a562f6e6498ab7593fa492e5352b | 8-9 February 1999, to Dublin, to be briefed on the political situation in Northern Ireland, at the invitation of the Irish Government who paid for my air fares, accommodation, transport in Dublin and meals. (Registered 20 May 1999) | Overseas visits 80ef1083 | 2000-11-10 | Brian Cotter uk.org.publicwhip/member/136 | Brian Cotter uk.org.publicwhip/person/10136 | 0 | 2000-11-10-80ef1083-10136-0 |
8ccd238887b5f7ae91a2b1f04a7e918c36670488 | Plasticable Ltd. | Registrable shareholdings 3aff2389 | 2000-11-10 | Brian Cotter uk.org.publicwhip/member/136 | Brian Cotter uk.org.publicwhip/person/10136 | 0 | 2000-11-10-3aff2389-10136-0 |
48938a5b99cd2f6f698ec3b566caff6ffce6b93d | Director (unremunerated) of The Genesis Initiative Ltd.; promoting the interests of small business at national and international level. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | Brian Cotter uk.org.publicwhip/member/136 | Brian Cotter uk.org.publicwhip/person/10136 | 0 | 2000-11-10-265f2269-10136-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");