committee_membership

Data source: See col-scraper on GitHub

28 rows where member_id = 1211

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
989 989 Academic and Personnel Sub Committee of the Board of Governors of the City of London Freemen's School 213 Philip Woodhouse 1211  
990 990 Ashtead Common Consultative Group 141 Philip Woodhouse 1211  
991 991 Board of Governors of the City of London Freemen's School 230 Philip Woodhouse 1211  
992 992 Burnham Beeches and Stoke Common Consultation Group 1228 Philip Woodhouse 1211  
993 993 Bursary Committee of the Board of Governors of the City of London Freemen's School 231 Philip Woodhouse 1211  
994 994 Community & Children's Services Committee 120 Philip Woodhouse 1211  
995 995 Corporate Asset Sub (Finance) Committee 216 Philip Woodhouse 1211  
996 996 223 Philip Woodhouse 1211  
997 997 Education Board 1147 Philip Woodhouse 1211  
998 998 Education Charity Sub (Education Board) Committee 1241 Philip Woodhouse 1211  
999 999 Efficiency and Performance Sub (Finance) Committee 245 Philip Woodhouse 1211  
1000 1000 Epping Forest & Commons Committee 122 Philip Woodhouse 1211  
1001 1001 Epping Forest Consultative Committee 1253 Philip Woodhouse 1211  
1002 1002 Epping Forest Joint Consultative Committee 1251 Philip Woodhouse 1211  
1003 1003 Establishment Committee 253 Philip Woodhouse 1211  
1004 1004 Finance Committee 145 Philip Woodhouse 1211  
1005 1005 Finance Grants Oversight and Performance Sub Committee 192 Philip Woodhouse 1211  
1006 1006 Finance, General Purposes and Estates Sub-Committee of the Board of Governors of the City of London Freemen's School 212 Philip Woodhouse 1211  
1007 1007 Financial Investment Board 248 Philip Woodhouse 1211  
1008 1008 Investment Committee 176 Philip Woodhouse 1211  
1009 1009 Livery Committee 383 Philip Woodhouse 1211  
1010 1010 Open Spaces and City Gardens 175 Philip Woodhouse 1211  
1011 1011 Policy and Resources Committee 395 Philip Woodhouse 1211  
1012 1012 Projects Sub (Policy and Resources) Committee 168 Philip Woodhouse 1211  
1013 1013 Property Investment Board 125 Philip Woodhouse 1211  
1014 1014 1094 Philip Woodhouse 1211  
1015 1015 Wanstead Park Working Party 1208 Philip Woodhouse 1211  
1016 1016 West Wickham, Spring Park and Coulsdon Commons Consultation Group 1077 Philip Woodhouse 1211  

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