committee_membership

Data source: See col-scraper on GitHub

5 rows where member_id = 1659

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
1 1 Community & Children's Services Committee 120 Graeme Harrower 1659  
2 2 223 Graeme Harrower 1659  
3 3 Culture, Heritage and Libraries Committee 177 Graeme Harrower 1659  
4 4 Planning and Transportation Committee 143 Graeme Harrower 1659  
5 5 Port Health & Environmental Services Committee 262 Graeme Harrower 1659  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");