home / colmem

committee_membership

Data source: See col-scraper on GitHub

19 rows where member_id = 1218

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
462 462 Capital Buildings Committee 1255 Christopher Michael Hayward 1218  
463 463 Corporate Asset Sub (Finance) Committee 216 Christopher Michael Hayward 1218  
464 464 223 Christopher Michael Hayward 1218  
465 465 Establishment Committee 253 Christopher Michael Hayward 1218  
466 466 Gresham (City Side) Committee 259 Christopher Michael Hayward 1218  
467 467 Gresham Working Party 334 Christopher Michael Hayward 1218  
468 468 Investment Committee 176 Christopher Michael Hayward 1218  
469 469 Livery Committee 383 Christopher Michael Hayward 1218  
470 470 Local Plans Sub (Planning and Transportation) Committee 392 Christopher Michael Hayward 1218  
471 471 Members Privileges Sub (Policy and Resources) Committee 407 Christopher Michael Hayward 1218  
472 472 Planning and Transportation Committee 143 Christopher Michael Hayward 1218  
473 473 Police Authority Board 142 Christopher Michael Hayward 1218  
474 474 Policy and Resources Committee 395 Christopher Michael Hayward 1218  
475 475 Projects Sub (Policy and Resources) Committee 168 Christopher Michael Hayward 1218  
476 476 Property Investment Board 125 Christopher Michael Hayward 1218  
477 477 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Christopher Michael Hayward 1218  
478 478 Resource Allocation Sub (Policy and Resources) Committee 396 Christopher Michael Hayward 1218  
479 479 Standards Appeals Committee 1259 Christopher Michael Hayward 1218  
480 480 Streets and Walkways Sub (Planning and Transportation) Committee 389 Christopher Michael Hayward 1218  

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 8.531ms · Data source: See col-scraper on GitHub