home / colmem

committee_membership

Data source: See col-scraper on GitHub

14 rows where member_id = 381

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
224 224 Ashtead Common Consultative Group 141 Sylvia Doreen Moys 381  
225 225 Board of Governors of the City of London School 233 Sylvia Doreen Moys 381  
226 226 Board of Governors of the City of London School for Girls 236 Sylvia Doreen Moys 381  
227 227 Burnham Beeches and Stoke Common Consultation Group 1228 Sylvia Doreen Moys 381  
228 228 223 Sylvia Doreen Moys 381  
229 229 Culture, Heritage and Libraries Committee 177 Sylvia Doreen Moys 381  
230 230 Epping Forest & Commons Committee 122 Sylvia Doreen Moys 381  
231 231 Epping Forest Consultative Committee 1253 Sylvia Doreen Moys 381  
232 232 Epping Forest Joint Consultative Committee 1251 Sylvia Doreen Moys 381  
233 233 Establishment Committee 253 Sylvia Doreen Moys 381  
234 234 Planning and Transportation Committee 143 Sylvia Doreen Moys 381  
235 235 1094 Sylvia Doreen Moys 381  
236 236 Wanstead Park Working Party 1208 Sylvia Doreen Moys 381  
237 237 West Wickham, Spring Park and Coulsdon Commons Consultation Group 1077 Sylvia Doreen Moys 381  

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");
Powered by Datasette · Queries took 8.967ms · Data source: See col-scraper on GitHub