committee_membership

Data source: See col-scraper on GitHub

6 rows where member_id = 396

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
6 6 Academic and Personnel Sub Committee of the Board of Governors of the City of London Freemen's School 213 Dame Fiona Woolf 396  
7 7 Board of Governors of the City of London Freemen's School 230 Dame Fiona Woolf 396  
8 8 220 Dame Fiona Woolf 396  
9 9 223 Dame Fiona Woolf 396  
10 10 Finance, General Purposes and Estates Sub-Committee of the Board of Governors of the City of London Freemen's School 212 Dame Fiona Woolf 396  
11 11 1183 Dame Fiona Woolf 396  

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