home / colmem

committee_membership

Data source: See col-scraper on GitHub

15 rows where member_id = 1940

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
313 313 Academic & Education Committee of the Board of Governors of the City of London School 1232 Caroline Wilma Haines 1940  
314 314 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Caroline Wilma Haines 1940  
315 315 Board of Governors of the City of London School 233 Caroline Wilma Haines 1940  
316 316 Community & Children's Services Committee 120 Caroline Wilma Haines 1940  
317 317 223 Caroline Wilma Haines 1940  
318 318 Culture, Heritage and Libraries Committee 177 Caroline Wilma Haines 1940  
319 319 Education Board 1147 Caroline Wilma Haines 1940  
320 320 Education Charity Sub (Education Board) Committee 1241 Caroline Wilma Haines 1940  
321 321 Epping Forest & Commons Committee 122 Caroline Wilma Haines 1940  
322 322 Epping Forest Consultative Committee 1253 Caroline Wilma Haines 1940  
323 323 Finance Committee 145 Caroline Wilma Haines 1940  
324 324 Member Development Steering Group 174 Caroline Wilma Haines 1940  
325 325 Nominations Sub (Education Board) Committee 1222 Caroline Wilma Haines 1940  
326 326 Open Spaces and City Gardens 175 Caroline Wilma Haines 1940  
327 327 West Ham Park Committee 400 Caroline Wilma Haines 1940  

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 85.705ms · Data source: See col-scraper on GitHub