committee_membership

Data source: See col-scraper on GitHub

10 rows where member_id = 1658

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
270 270 Benefices Sub (Culture, Heritage & Libraries) Committee 227 James de Sausmarez 1658  
271 271 Community & Children's Services Committee 120 James de Sausmarez 1658  
272 272 Corporate Asset Sub (Finance) Committee 216 James de Sausmarez 1658  
273 273 223 James de Sausmarez 1658  
274 274 Courts Sub (Policy & Resources) Committee 1229 James de Sausmarez 1658  
275 275 Finance Committee 145 James de Sausmarez 1658  
276 276 Financial Investment Board 248 James de Sausmarez 1658  
277 277 Investment Committee 176 James de Sausmarez 1658  
278 278 Planning and Transportation Committee 143 James de Sausmarez 1658  
279 279 Projects Sub (Policy and Resources) Committee 168 James de Sausmarez 1658  

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