committee_membership

Data source: See col-scraper on GitHub

1 row where role = "Deputy Chairman"

✎ View and edit SQL

This data as json, CSV (advanced)

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