committee_membership

Data source: See col-scraper on GitHub

12 rows where committee_id = 259

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
20 20 Gresham (City Side) Committee 259 Edward Lord 292  
50 50 Gresham (City Side) Committee 259 Tom Hoffman 251  
71 71 Gresham (City Side) Committee 259 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
78 78 Gresham (City Side) Committee 259 John Bennett 139  
84 84 Gresham (City Side) Committee 259 Wendy Mead 375  
249 249 Gresham (City Side) Committee 259 John George Stewart Scott 401  
345 345 Gresham (City Side) Committee 259 Nicholas Michael Bensted-Smith 1472  
466 466 Gresham (City Side) Committee 259 Christopher Michael Hayward 1218  
672 672 Gresham (City Side) Committee 259 Ian David Luder 296  
730 730 Gresham (City Side) Committee 259 Simon D'Olier Duckworth 151  
909 909 Gresham (City Side) Committee 259 Professor Michael Raymond Mainelli 1323  
1151 1151 Gresham (City Side) Committee 259 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");