committee_membership

Data source: See col-scraper on GitHub

17 rows where member_id = 1954

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
553 553 Board of Governors of the City of London School for Girls 236 Tijs Broeke 1954  
554 554 223 Tijs Broeke 1954  
555 555 Culture, Heritage and Libraries Committee 177 Tijs Broeke 1954  
556 556 Education Board 1147 Tijs Broeke 1954  
557 557 Freedom Applications Committee 183 Tijs Broeke 1954  
558 558 Homelessness and Rough Sleeping Sub Committee 1261 Tijs Broeke 1954  
559 559 Investment Committee 176 Tijs Broeke 1954  
560 560 Nominations Sub (Education Board) Committee 1222 Tijs Broeke 1954  
561 561 Performance and Resource Management Committee of the Police Authority Board 171 Tijs Broeke 1954  
562 562 Police Authority Board 142 Tijs Broeke 1954  
563 563 Policy and Resources Committee 395 Tijs Broeke 1954  
564 564 Port Health & Environmental Services Committee 262 Tijs Broeke 1954  
565 565 Professional Standards and Integrity Committee of the Police Authority Board 398 Tijs Broeke 1954  
566 566 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Tijs Broeke 1954  
567 567 Resource Allocation Sub (Policy and Resources) Committee 396 Tijs Broeke 1954  
568 568 Safer City Partnership Strategy Group 1110 Tijs Broeke 1954  
569 569 Social Investment Board 1064 Tijs Broeke 1954  

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