home / colmem

committee_membership

Data source: See col-scraper on GitHub

23 rows where member_id = 292

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
12 12 Board of Governors of the City of London School 233 Edward Lord 292  
13 13 Capital Buildings Committee 1255 Edward Lord 292  
14 14 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Edward Lord 292  
15 15 223 Edward Lord 292  
16 16 Courts Sub (Policy & Resources) Committee 1229 Edward Lord 292  
17 17 Establishment Committee 253 Edward Lord 292  
18 18 Finance & Estates Committee of the Board of Governors of the City of London School 1233 Edward Lord 292  
19 19 Governance Committee of the Board of Governors of the City of London School 1231 Edward Lord 292  
20 20 Gresham (City Side) Committee 259 Edward Lord 292  
21 21 Gresham Working Party 334 Edward Lord 292  
22 22 Investment Committee 176 Edward Lord 292  
23 23 Joint Consultative Committee 254 Edward Lord 292  
24 24 Markets Committee 411 Edward Lord 292  
25 25 Members Privileges Sub (Policy and Resources) Committee 407 Edward Lord 292  
26 26 Outside Bodies Sub (Policy and Resources) Committee 1205 Edward Lord 292  
27 27 Policy and Resources Committee 395 Edward Lord 292  
28 28 Property Investment Board 125 Edward Lord 292  
29 29 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Edward Lord 292  
30 30 Reference Sub (Markets) Committee 563 Edward Lord 292  
31 31 Resource Allocation Sub (Policy and Resources) Committee 396 Edward Lord 292  
32 32 Senior Remuneration Sub-Committee 1262 Edward Lord 292  
33 33 Standards Committee 408 Edward Lord 292  
34 34 The City Bridge Trust Committee 179 Edward Lord 292  

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 76.174ms · Data source: See col-scraper on GitHub