committee_membership
Data source: See col-scraper on GitHub
5 rows where member_id = 1953 sorted by rowid
This data as json, CSV (advanced)
Link | rowid ▼ | committee_id | member_id | role |
---|---|---|---|---|
1085 | 1085 | Barbican Residential Committee 153 | Matthew Bell 1953 | |
1086 | 1086 | Community & Children's Services Committee 120 | Matthew Bell 1953 | |
1087 | 1087 | 223 | Matthew Bell 1953 | |
1088 | 1088 | Health and Wellbeing Board 994 | Matthew Bell 1953 | |
1089 | 1089 | Markets Committee 411 | Matthew Bell 1953 |
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");