committee_membership

Data source: See col-scraper on GitHub

14 rows where member_id = 1230

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
1159 1159 Assessment Sub (Standards) Committee 1134 Ann Holmes 1230  
1160 1160 Audit and Risk Management Committee of the Board of Governors of the Guildhall School of Music & Drama 201 Ann Holmes 1230  
1161 1161 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Ann Holmes 1230  
1162 1162 Board of Governors of the Guildhall School of Music and Drama 387 Ann Holmes 1230  
1163 1163 223 Ann Holmes 1230  
1164 1164 Culture, Heritage and Libraries Committee 177 Ann Holmes 1230  
1165 1165 Dispensations Sub (Standards) Committee 1106 Ann Holmes 1230  
1166 1166 Education Board 1147 Ann Holmes 1230  
1167 1167 Education Charity Sub (Education Board) Committee 1241 Ann Holmes 1230  
1168 1168 Governance and Effectiveness Committee of the Board of Governors of the Guildhall School of Music & Drama 218 Ann Holmes 1230  
1169 1169 Member Development Steering Group 174 Ann Holmes 1230  
1170 1170 Members Privileges Sub (Policy and Resources) Committee 407 Ann Holmes 1230  
1171 1171 Nominations Sub (Education Board) Committee 1222 Ann Holmes 1230  
1172 1172 Standards Committee 408 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");