committee_membership

Data source: See col-scraper on GitHub

11 rows where committee_id = 140

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
45 45 Barbican Centre Board 140 Tom Hoffman 251  
80 80 Barbican Centre Board 140 Wendy Mead 375  
119 119 Barbican Centre Board 140 Tom Sleigh 1213  
173 173 Barbican Centre Board 140 Judith Pleasance 1212  
185 185 Barbican Centre Board 140 David Andrew Graves 231  
535 535 Barbican Centre Board 140 William Anthony Bowater Russell 1202  
587 587 Barbican Centre Board 140 Wendy Hyde 263  
617 617 Barbican Centre Board 140 Graham Packham 1221  
720 720 Barbican Centre Board 140 Simon D'Olier Duckworth 151  
1109 1109 Barbican Centre Board 140 Vivienne Littlechild 287  
1147 1147 Barbican Centre Board 140 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");