committee_membership

Data source: See col-scraper on GitHub

11 rows where committee_id = 175

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
89 89 Open Spaces and City Gardens 175 Wendy Mead 375  
109 109 Open Spaces and City Gardens 175 Barbara Patricia Newman 363  
326 326 Open Spaces and City Gardens 175 Caroline Wilma Haines 1940  
424 424 Open Spaces and City Gardens 175 Karina Dostalova 1222  
492 492 Open Spaces and City Gardens 175 Oliver Sells QC 1941  
522 522 Open Spaces and City Gardens 175 Anne Helen Fairweather 1756  
660 660 Open Spaces and City Gardens 175 Jeremy Lewis Simons 384  
675 675 Open Spaces and City Gardens 175 Ian David Luder 296  
695 695 Open Spaces and City Gardens 175 John Tomlinson 392  
902 902 Open Spaces and City Gardens 175 Graeme Martyn Smith 1231  
1010 1010 Open Spaces and City Gardens 175 Philip Woodhouse 1211  

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