committee_membership
Data source: See col-scraper on GitHub
4 rows where member_id = 1935
This data as json, CSV (advanced)
Link | rowid ▼ | committee_id | member_id | role |
---|---|---|---|---|
682 | 682 | 223 | William Upton QC 1935 | |
683 | 683 | Hampstead Heath, Highgate Wood and Queen's Park Committee 250 | William Upton QC 1935 | |
684 | 684 | Local Plans Sub (Planning and Transportation) Committee 392 | William Upton QC 1935 | |
685 | 685 | Planning and Transportation Committee 143 | William Upton QC 1935 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE committee_membership( committee_id INTEGER REFERENCES committees(id), member_id INTEGER REFERENCES members(id), role VARCHAR(50) ); CREATE INDEX committee_membership_committee_id ON committee_membership("committee_id"); CREATE INDEX committee_membership_member_id ON committee_membership("member_id");