Data source: See col-scraper on GitHub

6 rows where member_id = 1947

View and edit SQL

Link rowid ▼ committee_id member_id role
157 223 Caroline Kordai Addy 1947  
158 Licensing (Hearing) Sub Committee 200 Caroline Kordai Addy 1947  
159 Licensing Committee 123 Caroline Kordai Addy 1947  
160 Port Health & Environmental Services Committee 262 Caroline Kordai Addy 1947  
161 Reference Sub (Licensing) Committee 986 Caroline Kordai Addy 1947  
162 Standards Committee 408 Caroline Kordai Addy 1947  

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