committee_membership

Data source: See col-scraper on GitHub

18 rows where member_id = 373

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
280 280 Capital Buildings Committee 1255 Catherine McGuinness 373  
281 281 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Catherine McGuinness 373  
282 282 Community & Children's Services Committee 120 Catherine McGuinness 373  
283 283 223 Catherine McGuinness 373  
284 284 Courts Sub (Policy & Resources) Committee 1229 Catherine McGuinness 373  
285 285 Crime and Disorder Scrutiny Committee 173 Catherine McGuinness 373  
286 286 Finance Committee 145 Catherine McGuinness 373  
287 287 Freedom Applications Committee 183 Catherine McGuinness 373  
288 288 Investment Committee 176 Catherine McGuinness 373  
289 289 1183 Catherine McGuinness 373  
290 290 Members Privileges Sub (Policy and Resources) Committee 407 Catherine McGuinness 373  
291 291 Outside Bodies Sub (Policy and Resources) Committee 1205 Catherine McGuinness 373  
292 292 Policy and Resources Committee 395 Catherine McGuinness 373  
293 293 Projects Sub (Policy and Resources) Committee 168 Catherine McGuinness 373  
294 294 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Catherine McGuinness 373  
295 295 Reference Sub Committee of the Barbican Centre Board 172 Catherine McGuinness 373  
296 296 Resource Allocation Sub (Policy and Resources) Committee 396 Catherine McGuinness 373  
297 297 Senior Remuneration Sub-Committee 1262 Catherine McGuinness 373  

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