home / colmem

committee_membership

Data source: See col-scraper on GitHub

11 rows where member_id = 1957

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
499 499 Barbican Residential Committee 153 Mary Durcan 1957  
500 500 Community & Children's Services Committee 120 Mary Durcan 1957  
501 501 223 Mary Durcan 1957  
502 502 Culture, Heritage and Libraries Committee 177 Mary Durcan 1957  
503 503 Homelessness and Rough Sleeping Sub Committee 1261 Mary Durcan 1957  
504 504 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Mary Durcan 1957  
505 505 Licensing Committee 123 Mary Durcan 1957  
506 506 Outside Bodies Sub (Policy and Resources) Committee 1205 Mary Durcan 1957  
507 507 Port Health & Environmental Services Committee 262 Mary Durcan 1957  
508 508 Safeguarding Sub (Community & Children's Services) Committee 1096 Mary Durcan 1957  
509 509 Standards Committee 408 Mary Durcan 1957  

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