committee_membership

Data source: See col-scraper on GitHub

14 rows where member_id = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
668 668 Audit and Risk Management Committee 244 Ian David Luder 296  
669 669 Capital Buildings Committee 1255 Ian David Luder 296  
670 670 220 Ian David Luder 296  
671 671 223 Ian David Luder 296  
672 672 Gresham (City Side) Committee 259 Ian David Luder 296  
673 673 Gresham Working Party 334 Ian David Luder 296  
674 674 Nominations Sub Committee of the Audit and Risk Management Committee 1260 Ian David Luder 296  
675 675 Open Spaces and City Gardens 175 Ian David Luder 296  
676 676 Police Authority Board 142 Ian David Luder 296  
677 677 Police Pensions Board 1206 Ian David Luder 296  
678 678 Policy and Resources Committee 395 Ian David Luder 296  
679 679 Resource Allocation Sub (Policy and Resources) Committee 396 Ian David Luder 296  
680 680 Standards Appeals Committee 1259 Ian David Luder 296  
681 681 West Ham Park Committee 400 Ian David Luder 296  

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