home / colmem

committee_membership

Data source: See col-scraper on GitHub

35 rows where member_id = 1223

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link rowid ▼ committee_id member_id role
377 377 Assessment Sub (Standards) Committee 1134 Jamie Ingham Clark 1223  
378 378 Audit and Risk Management Committee 244 Jamie Ingham Clark 1223  
379 379 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Jamie Ingham Clark 1223  
380 380 Capital Buildings Committee 1255 Jamie Ingham Clark 1223  
381 381 Corporate Asset Sub (Finance) Committee 216 Jamie Ingham Clark 1223 Deputy Chairman
382 382 223 Jamie Ingham Clark 1223  
383 383 Crime and Disorder Scrutiny Committee 173 Jamie Ingham Clark 1223  
384 384 Digital Services Sub (Finance) Committee 257 Jamie Ingham Clark 1223  
385 385 Dispensations Sub (Standards) Committee 1106 Jamie Ingham Clark 1223  
386 386 Efficiency and Performance Sub (Finance) Committee 245 Jamie Ingham Clark 1223  
387 387 Establishment Committee 253 Jamie Ingham Clark 1223  
388 388 Finance Committee 145 Jamie Ingham Clark 1223  
389 389 Finance Grants Oversight and Performance Sub Committee 192 Jamie Ingham Clark 1223  
390 390 Financial Investment Board 248 Jamie Ingham Clark 1223  
391 391 Investment Committee 176 Jamie Ingham Clark 1223  
392 392 Joint Consultative Committee 254 Jamie Ingham Clark 1223  
393 393 Licensing (Hearing) Sub Committee 200 Jamie Ingham Clark 1223  
394 394 Licensing Committee 123 Jamie Ingham Clark 1223  
395 395 Local Plans Sub (Planning and Transportation) Committee 392 Jamie Ingham Clark 1223  
396 396 1183 Jamie Ingham Clark 1223  
397 397 Member Development Steering Group 174 Jamie Ingham Clark 1223  
398 398 Members Privileges Sub (Policy and Resources) Committee 407 Jamie Ingham Clark 1223  
399 399 Planning and Transportation Committee 143 Jamie Ingham Clark 1223  
400 400 Policy and Resources Committee 395 Jamie Ingham Clark 1223  
401 401 Port Health & Environmental Services Committee 262 Jamie Ingham Clark 1223  
402 402 Procurement Sub (Finance) Committee 1267 Jamie Ingham Clark 1223  
403 403 Projects Sub (Policy and Resources) Committee 168 Jamie Ingham Clark 1223  
404 404 Property Investment Board 125 Jamie Ingham Clark 1223  
405 405 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Jamie Ingham Clark 1223  
406 406 Reference Sub (Licensing) Committee 986 Jamie Ingham Clark 1223  
407 407 Resource Allocation Sub (Policy and Resources) Committee 396 Jamie Ingham Clark 1223  
408 408 Senior Remuneration Sub-Committee 1262 Jamie Ingham Clark 1223  
409 409 Standards Committee 408 Jamie Ingham Clark 1223  
410 410 Streets and Walkways Sub (Planning and Transportation) Committee 389 Jamie Ingham Clark 1223  
411 411 The City Bridge Trust Committee 179 Jamie Ingham Clark 1223  

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");
Powered by Datasette · Queries took 9.354ms · Data source: See col-scraper on GitHub