committee_membership

Data source: See col-scraper on GitHub

8 rows where member_id = 392

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
690 690 Barbican Estate Residents Consultation Committee 188 John Tomlinson 392  
691 691 Barbican Residential Committee 153 John Tomlinson 392  
692 692 223 John Tomlinson 392  
693 693 Hampstead Heath, Highgate Wood and Queen's Park Committee 250 John Tomlinson 392  
694 694 Highgate Wood Consultative Group 240 John Tomlinson 392  
695 695 Open Spaces and City Gardens 175 John Tomlinson 392  
696 696 Reference Sub Committee of the Barbican Centre Board 172 John Tomlinson 392  
697 697 West Ham Park Committee 400 John Tomlinson 392  

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