committee_membership

Data source: See col-scraper on GitHub

13 rows where committee_id = 230

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
7 7 Board of Governors of the City of London Freemen's School 230 Dame Fiona Woolf 396  
39 39 Board of Governors of the City of London Freemen's School 230 Hugh Fenton Morris 380  
75 75 Board of Governors of the City of London Freemen's School 230 John Bennett 139  
94 94 Board of Governors of the City of London Freemen's School 230 Roger Arthur Holden Chadwick 158  
238 238 Board of Governors of the City of London Freemen's School 230 Bronek Masojada 2259  
446 446 Board of Governors of the City of London Freemen's School 230 Michael Hudson 256  
510 510 Board of Governors of the City of London Freemen's School 230 Stuart John Fraser, CBE 221  
620 620 Board of Governors of the City of London Freemen's School 230 Graham Packham 1221  
991 991 Board of Governors of the City of London Freemen's School 230 Philip Woodhouse 1211  
1019 1019 Board of Governors of the City of London Freemen's School 230 Susan Langley 2186  
1025 1025 Board of Governors of the City of London Freemen's School 230 James Michael Douglas Thomson 1207  
1055 1055 Board of Governors of the City of London Freemen's School 230 Elizabeth Rogula 376  
1060 1060 Board of Governors of the City of London Freemen's School 230 Clare James 264  

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