committee_membership

Data source: See col-scraper on GitHub

11 rows where member_id = 1210

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
1074 1074 223 Henry Nicholas Almroth Colthurst 1210  
1075 1075 Education Board 1147 Henry Nicholas Almroth Colthurst 1210  
1076 1076 Education Charity Sub (Education Board) Committee 1241 Henry Nicholas Almroth Colthurst 1210  
1077 1077 Financial Investment Board 248 Henry Nicholas Almroth Colthurst 1210  
1078 1078 Investment Committee 176 Henry Nicholas Almroth Colthurst 1210  
1079 1079 Nominations Sub (Education Board) Committee 1222 Henry Nicholas Almroth Colthurst 1210  
1080 1080 Outside Bodies Sub (Policy and Resources) Committee 1205 Henry Nicholas Almroth Colthurst 1210  
1081 1081 Planning and Transportation Committee 143 Henry Nicholas Almroth Colthurst 1210  
1082 1082 Social Investment Board 1064 Henry Nicholas Almroth Colthurst 1210  
1083 1083 Standards Appeals Committee 1259 Henry Nicholas Almroth Colthurst 1210  
1084 1084 Standards Committee 408 Henry Nicholas Almroth Colthurst 1210  

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