committee_membership

Data source: See col-scraper on GitHub

10 rows where committee_id = 1262

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
32 32 Senior Remuneration Sub-Committee 1262 Edward Lord 292  
268 268 Senior Remuneration Sub-Committee 1262 Sir David Hugh Wootton 397  
297 297 Senior Remuneration Sub-Committee 1262 Catherine McGuinness 373  
408 408 Senior Remuneration Sub-Committee 1262 Jamie Ingham Clark 1223  
740 740 Senior Remuneration Sub-Committee 1262 Simon D'Olier Duckworth 151  
776 776 Senior Remuneration Sub-Committee 1262 Keith David Forbes Bottomley 1666  
810 810 Senior Remuneration Sub-Committee 1262 Jeremy Mayhew 370  
824 824 Senior Remuneration Sub-Committee 1262 Ruby Sayed 1938  
1046 1046 Senior Remuneration Sub-Committee 1262 The Revd Stephen Decatur Haines 232  
1189 1189 Senior Remuneration Sub-Committee 1262 Kevin Malcolm Everett 213  

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