committee_membership

Data source: See col-scraper on GitHub

13 rows where member_id = 375

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
80 80 Barbican Centre Board 140 Wendy Mead 375  
81 81 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Wendy Mead 375  
82 82 223 Wendy Mead 375  
83 83 Culture, Heritage and Libraries Committee 177 Wendy Mead 375  
84 84 Gresham (City Side) Committee 259 Wendy Mead 375  
85 85 Hampstead Heath, Highgate Wood and Queen's Park Committee 250 Wendy Mead 375  
86 86 Health and Social Care Scrutiny Committee 185 Wendy Mead 375  
87 87 Livery Committee 383 Wendy Mead 375  
88 88 Markets Committee 411 Wendy Mead 375  
89 89 Open Spaces and City Gardens 175 Wendy Mead 375  
90 90 Policy and Resources Committee 395 Wendy Mead 375  
91 91 The City Bridge Trust Committee 179 Wendy Mead 375  
92 92 West Ham Park Committee 400 Wendy Mead 375  

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