committee_membership

Data source: See col-scraper on GitHub

12 rows where member_id = 397

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
258 258 Capital Buildings Committee 1255 Sir David Hugh Wootton 397  
259 259 220 Sir David Hugh Wootton 397  
260 260 223 Sir David Hugh Wootton 397  
261 261 Courts Sub (Policy & Resources) Committee 1229 Sir David Hugh Wootton 397  
262 262 Freedom Applications Committee 183 Sir David Hugh Wootton 397  
263 263 1183 Sir David Hugh Wootton 397  
264 264 Planning and Transportation Committee 143 Sir David Hugh Wootton 397  
265 265 Policy and Resources Committee 395 Sir David Hugh Wootton 397  
266 266 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Sir David Hugh Wootton 397  
267 267 Resource Allocation Sub (Policy and Resources) Committee 396 Sir David Hugh Wootton 397  
268 268 Senior Remuneration Sub-Committee 1262 Sir David Hugh Wootton 397  
269 269 Standards Appeals Committee 1259 Sir David Hugh Wootton 397  

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