committee_membership

Data source: See col-scraper on GitHub

13 rows where member_id = 363

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
102 102 Barbican Residential Committee 153 Barbara Patricia Newman 363  
103 103 Community & Children's Services Committee 120 Barbara Patricia Newman 363  
104 104 223 Barbara Patricia Newman 363  
105 105 Culture, Heritage and Libraries Committee 177 Barbara Patricia Newman 363  
106 106 Establishment Committee 253 Barbara Patricia Newman 363  
107 107 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Barbara Patricia Newman 363  
108 108 Integrated Commissioning Sub Committee 1247 Barbara Patricia Newman 363  
109 109 Open Spaces and City Gardens 175 Barbara Patricia Newman 363  
110 110 Planning and Transportation Committee 143 Barbara Patricia Newman 363  
111 111 Standards Committee 408 Barbara Patricia Newman 363  
112 112 Streets and Walkways Sub (Planning and Transportation) Committee 389 Barbara Patricia Newman 363  
113 113 Wanstead Park Working Party 1208 Barbara Patricia Newman 363  
114 114 West Ham Park Committee 400 Barbara Patricia Newman 363  

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