home / colmem

committee_membership

Data source: See col-scraper on GitHub

14 rows where committee_id = 216

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link rowid ▼ committee_id member_id role
272 272 Corporate Asset Sub (Finance) Committee 216 James de Sausmarez 1658  
300 300 Corporate Asset Sub (Finance) Committee 216 Dominic Gerard Christian 1757  
339 339 Corporate Asset Sub (Finance) Committee 216 Nicholas Michael Bensted-Smith 1472  
381 381 Corporate Asset Sub (Finance) Committee 216 Jamie Ingham Clark 1223 Deputy Chairman
447 447 Corporate Asset Sub (Finance) Committee 216 Michael Hudson 256  
463 463 Corporate Asset Sub (Finance) Committee 216 Christopher Michael Hayward 1218  
589 589 Corporate Asset Sub (Finance) Committee 216 Wendy Hyde 263  
794 794 Corporate Asset Sub (Finance) Committee 216 Jeremy Mayhew 370 Chairman
831 831 Corporate Asset Sub (Finance) Committee 216 Marianne Bernadette Fredericks 223  
870 870 Corporate Asset Sub (Finance) Committee 216 Randall Keith Anderson 1227  
913 913 Corporate Asset Sub (Finance) Committee 216 Joyce Carruthers Nash 382  
950 950 Corporate Asset Sub (Finance) Committee 216 John Douglas Chapman 160  
995 995 Corporate Asset Sub (Finance) Committee 216 Philip Woodhouse 1211  
1136 1136 Corporate Asset Sub (Finance) Committee 216 Alison Gowman 229  

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");
Powered by Datasette · Queries took 26.855ms · Data source: See col-scraper on GitHub