committee_membership

Data source: See col-scraper on GitHub

12 rows where member_id = 1213

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
119 119 Barbican Centre Board 140 Tom Sleigh 1213  
120 120 223 Tom Sleigh 1213  
121 121 Finance Committee 145 Tom Sleigh 1213  
122 122 Finance Committee of the Barbican Centre Board 165 Tom Sleigh 1213  
123 123 Investment Committee 176 Tom Sleigh 1213  
124 124 Markets Committee 411 Tom Sleigh 1213  
125 125 Nominations Committee of the Barbican Centre Board 164 Tom Sleigh 1213  
126 126 Policy and Resources Committee 395 Tom Sleigh 1213  
127 127 Property Investment Board 125 Tom Sleigh 1213  
128 128 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Tom Sleigh 1213  
129 129 Resource Allocation Sub (Policy and Resources) Committee 396 Tom Sleigh 1213  
130 130 Risk Committee of the Barbican Centre Board 249 Tom Sleigh 1213  

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