committee_membership

Data source: See col-scraper on GitHub

12 rows where member_id = 229

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
1135 1135 Capital Buildings Committee 1255 Alison Gowman 229  
1136 1136 Corporate Asset Sub (Finance) Committee 216 Alison Gowman 229  
1137 1137 220 Alison Gowman 229  
1138 1138 223 Alison Gowman 229  
1139 1139 Courts Sub (Policy & Resources) Committee 1229 Alison Gowman 229  
1140 1140 Investment Committee 176 Alison Gowman 229  
1141 1141 Police Authority Board 142 Alison Gowman 229  
1142 1142 Professional Standards and Integrity Committee of the Police Authority Board 398 Alison Gowman 229  
1143 1143 Property Investment Board 125 Alison Gowman 229  
1144 1144 Social Investment Board 1064 Alison Gowman 229  
1145 1145 Streets and Walkways Sub (Planning and Transportation) Committee 389 Alison Gowman 229  
1146 1146 The City Bridge Trust Committee 179 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");