committee_membership

Data source: See col-scraper on GitHub

12 rows where committee_id = 408

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
33 33 Standards Committee 408 Edward Lord 292  
111 111 Standards Committee 408 Barbara Patricia Newman 363  
162 162 Standards Committee 408 Caroline Kordai Addy 1947  
409 409 Standards Committee 408 Jamie Ingham Clark 1223  
509 509 Standards Committee 408 Mary Durcan 1957  
664 664 Standards Committee 408 Jeremy Lewis Simons 384  
892 892 Standards Committee 408 Randall Keith Anderson 1227  
911 911 Standards Committee 408 Professor Michael Raymond Mainelli 1323  
1022 1022 Standards Committee 408 Susan Langley 2186  
1084 1084 Standards Committee 408 Henry Nicholas Almroth Colthurst 1210  
1121 1121 Standards Committee 408 Vivienne Littlechild 287  
1172 1172 Standards Committee 408 Ann Holmes 1230  

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