committee_membership

Data source: See col-scraper on GitHub

5 rows where committee_id = 1106

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
357 357 Dispensations Sub (Standards) Committee 1106 Christopher Paul Boden 1219  
385 385 Dispensations Sub (Standards) Committee 1106 Jamie Ingham Clark 1223  
1132 1132 Dispensations Sub (Standards) Committee 1106 Oliver Arthur Wynlayne Lodge 291  
1165 1165 Dispensations Sub (Standards) Committee 1106 Ann Holmes 1230  
1180 1180 Dispensations Sub (Standards) Committee 1106 Kevin Malcolm Everett 213  

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