committee_membership

Data source: See col-scraper on GitHub

11 rows where committee_id = 1229

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
16 16 Courts Sub (Policy & Resources) Committee 1229 Edward Lord 292  
138 138 Courts Sub (Policy & Resources) Committee 1229 Sheriff Vincent Thomas Keaveny 1395  
246 246 Courts Sub (Policy & Resources) Committee 1229 John George Stewart Scott 401  
261 261 Courts Sub (Policy & Resources) Committee 1229 Sir David Hugh Wootton 397  
274 274 Courts Sub (Policy & Resources) Committee 1229 James de Sausmarez 1658  
284 284 Courts Sub (Policy & Resources) Committee 1229 Catherine McGuinness 373  
449 449 Courts Sub (Policy & Resources) Committee 1229 Michael Hudson 256  
650 650 Courts Sub (Policy & Resources) Committee 1229 Timothy Russell Hailes 1260  
723 723 Courts Sub (Policy & Resources) Committee 1229 Simon D'Olier Duckworth 151  
782 782 Courts Sub (Policy & Resources) Committee 1229 Gregory Jones QC 1220  
1139 1139 Courts Sub (Policy & Resources) Committee 1229 Alison Gowman 229  

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