committee_membership
Data source: See col-scraper on GitHub
3 rows where member_id = 1952 sorted by committee_id
This data as json, CSV (advanced)
Link | rowid | committee_id ▼ | member_id | role |
---|---|---|---|---|
986 | 986 | Barbican Residential Committee 153 | Adrian Mark Bastow 1952 | |
987 | 987 | 223 | Adrian Mark Bastow 1952 | |
988 | 988 | Port Health & Environmental Services Committee 262 | Adrian Mark Bastow 1952 |
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");