home / colmem

committee_membership

Data source: See col-scraper on GitHub

10 rows where member_id = 136

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link rowid ▼ committee_id member_id role
1095 1095 223 Sir Mark Boleat 136  
1096 1096 Culture, Heritage and Libraries Committee 177 Sir Mark Boleat 136  
1097 1097 Establishment Committee 253 Sir Mark Boleat 136  
1098 1098 1256 Sir Mark Boleat 136 Chairman
1099 1099 Investment Committee 176 Sir Mark Boleat 136  
1100 1100 Planning and Transportation Committee 143 Sir Mark Boleat 136  
1101 1101 Policy and Resources Committee 395 Sir Mark Boleat 136  
1102 1102 Property Investment Board 125 Sir Mark Boleat 136  
1103 1103 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Sir Mark Boleat 136  
1104 1104 Resource Allocation Sub (Policy and Resources) Committee 396 Sir Mark Boleat 136  

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