committee_membership

Data source: See col-scraper on GitHub

23 rows where member_id = 151

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
720 720 Barbican Centre Board 140 Simon D'Olier Duckworth 151  
721 721 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Simon D'Olier Duckworth 151  
722 722 223 Simon D'Olier Duckworth 151  
723 723 Courts Sub (Policy & Resources) Committee 1229 Simon D'Olier Duckworth 151  
724 724 Crime and Disorder Scrutiny Committee 173 Simon D'Olier Duckworth 151  
725 725 Economic Crime Committee of the Police Authority Board 513 Simon D'Olier Duckworth 151  
726 726 Finance Committee 145 Simon D'Olier Duckworth 151  
727 727 Finance Grants Oversight and Performance Sub Committee 192 Simon D'Olier Duckworth 151  
728 728 Financial Investment Board 248 Simon D'Olier Duckworth 151  
729 729 Freedom Applications Committee 183 Simon D'Olier Duckworth 151  
730 730 Gresham (City Side) Committee 259 Simon D'Olier Duckworth 151  
731 731 Gresham Working Party 334 Simon D'Olier Duckworth 151  
732 732 Investment Committee 176 Simon D'Olier Duckworth 151  
733 733 Members Privileges Sub (Policy and Resources) Committee 407 Simon D'Olier Duckworth 151  
734 734 Nominations Committee of the Barbican Centre Board 164 Simon D'Olier Duckworth 151  
735 735 Outside Bodies Sub (Policy and Resources) Committee 1205 Simon D'Olier Duckworth 151  
736 736 Police Authority Board 142 Simon D'Olier Duckworth 151  
737 737 Policy and Resources Committee 395 Simon D'Olier Duckworth 151  
738 738 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Simon D'Olier Duckworth 151  
739 739 Resource Allocation Sub (Policy and Resources) Committee 396 Simon D'Olier Duckworth 151  
740 740 Senior Remuneration Sub-Committee 1262 Simon D'Olier Duckworth 151  
741 741 Standards Appeals Committee 1259 Simon D'Olier Duckworth 151  
742 742 The City Bridge Trust Committee 179 Simon D'Olier Duckworth 151  

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