committee_membership

Data source: See col-scraper on GitHub

15 rows where committee_id = 179

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
34 34 The City Bridge Trust Committee 179 Edward Lord 292  
74 74 The City Bridge Trust Committee 179 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
91 91 The City Bridge Trust Committee 179 Wendy Mead 375  
208 208 The City Bridge Trust Committee 179 Dhruv Patel 1224  
376 376 The City Bridge Trust Committee 179 Peter Gerard Dunphy 200  
411 411 The City Bridge Trust Committee 179 Jamie Ingham Clark 1223  
431 431 The City Bridge Trust Committee 179 Karina Dostalova 1222  
576 576 The City Bridge Trust Committee 179 Paul Nicholas Martinelli 1217  
742 742 The City Bridge Trust Committee 179 Simon D'Olier Duckworth 151  
812 812 The City Bridge Trust Committee 179 Jeremy Mayhew 370  
849 849 The City Bridge Trust Committee 179 Marianne Bernadette Fredericks 223  
940 940 The City Bridge Trust Committee 179 Ian Christopher Norman Seaton 402  
1023 1023 The City Bridge Trust Committee 179 Susan Langley 2186  
1146 1146 The City Bridge Trust Committee 179 Alison Gowman 229  
1158 1158 The City Bridge Trust Committee 179 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");