committee_membership

Data source: See col-scraper on GitHub

17 rows where committee_id = 396

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
31 31 Resource Allocation Sub (Policy and Resources) Committee 396 Edward Lord 292  
129 129 Resource Allocation Sub (Policy and Resources) Committee 396 Tom Sleigh 1213  
267 267 Resource Allocation Sub (Policy and Resources) Committee 396 Sir David Hugh Wootton 397  
296 296 Resource Allocation Sub (Policy and Resources) Committee 396 Catherine McGuinness 373  
407 407 Resource Allocation Sub (Policy and Resources) Committee 396 Jamie Ingham Clark 1223  
430 430 Resource Allocation Sub (Policy and Resources) Committee 396 Karina Dostalova 1222  
478 478 Resource Allocation Sub (Policy and Resources) Committee 396 Christopher Michael Hayward 1218  
527 527 Resource Allocation Sub (Policy and Resources) Committee 396 Anne Helen Fairweather 1756  
544 544 Resource Allocation Sub (Policy and Resources) Committee 396 William Anthony Bowater Russell 1202  
567 567 Resource Allocation Sub (Policy and Resources) Committee 396 Tijs Broeke 1954  
679 679 Resource Allocation Sub (Policy and Resources) Committee 396 Ian David Luder 296  
739 739 Resource Allocation Sub (Policy and Resources) Committee 396 Simon D'Olier Duckworth 151  
750 750 Resource Allocation Sub (Policy and Resources) Committee 396 Sir Michael Snyder 385  
775 775 Resource Allocation Sub (Policy and Resources) Committee 396 Keith David Forbes Bottomley 1666  
809 809 Resource Allocation Sub (Policy and Resources) Committee 396 Jeremy Mayhew 370  
1104 1104 Resource Allocation Sub (Policy and Resources) Committee 396 Sir Mark Boleat 136  
1156 1156 Resource Allocation Sub (Policy and Resources) Committee 396 Dr Giles Robert Evelyn Shilson 383  

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