committee_membership

Data source: See col-scraper on GitHub

5 rows where committee_id = 1096

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
508 508 Safeguarding Sub (Community & Children's Services) Committee 1096 Mary Durcan 1957  
706 706 Safeguarding Sub (Community & Children's Services) Committee 1096 Susan Jane Pearson 1934  
823 823 Safeguarding Sub (Community & Children's Services) Committee 1096 Ruby Sayed 1938  
847 847 Safeguarding Sub (Community & Children's Services) Committee 1096 Marianne Bernadette Fredericks 223  
890 890 Safeguarding Sub (Community & Children's Services) Committee 1096 Randall Keith Anderson 1227  

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