committee_membership

Data source: See col-scraper on GitHub

11 rows where member_id = 160

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
948 948 Audit and Risk Management Committee of the Board of Governors of the Guildhall School of Music & Drama 201 John Douglas Chapman 160  
949 949 Board of Governors of the Guildhall School of Music and Drama 387 John Douglas Chapman 160  
950 950 Corporate Asset Sub (Finance) Committee 216 John Douglas Chapman 160  
951 951 223 John Douglas Chapman 160  
952 952 Investment Committee 176 John Douglas Chapman 160  
953 953 Markets Committee 411 John Douglas Chapman 160  
954 954 Port Health & Environmental Services Committee 262 John Douglas Chapman 160  
955 955 Property Investment Board 125 John Douglas Chapman 160  
956 956 Reference Sub (Markets) Committee 563 John Douglas Chapman 160  
957 957 Remuneration and Nominations Committee of the Board of Governors of the Guildhall School of Music and Drama 1273 John Douglas Chapman 160  
958 958 Standards Appeals Committee 1259 John Douglas Chapman 160  

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