committee_membership

Data source: See col-scraper on GitHub

4 rows where committee_id = 218

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
625 625 Governance and Effectiveness Committee of the Board of Governors of the Guildhall School of Music & Drama 218 Graham Packham 1221  
834 834 Governance and Effectiveness Committee of the Board of Governors of the Guildhall School of Music & Drama 218 Marianne Bernadette Fredericks 223  
1115 1115 Governance and Effectiveness Committee of the Board of Governors of the Guildhall School of Music & Drama 218 Vivienne Littlechild 287  
1168 1168 Governance and Effectiveness Committee of the Board of Governors of the Guildhall School of Music & Drama 218 Ann Holmes 1230  

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