committee_membership

Data source: See col-scraper on GitHub

10 rows where member_id = 2058

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
209 209 Community & Children's Services Committee 120 Benjamin Daniel Murphy 2058  
210 210 223 Benjamin Daniel Murphy 2058  
211 211 Digital Services Sub (Finance) Committee 257 Benjamin Daniel Murphy 2058  
212 212 Education Board 1147 Benjamin Daniel Murphy 2058  
213 213 Education Charity Sub (Education Board) Committee 1241 Benjamin Daniel Murphy 2058  
214 214 Epping Forest & Commons Committee 122 Benjamin Daniel Murphy 2058  
215 215 Epping Forest Consultative Committee 1253 Benjamin Daniel Murphy 2058  
216 216 Finance Committee 145 Benjamin Daniel Murphy 2058  
217 217 Homelessness and Rough Sleeping Sub Committee 1261 Benjamin Daniel Murphy 2058  
218 218 Projects Sub (Policy and Resources) Committee 168 Benjamin Daniel Murphy 2058  

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