committee_membership

Data source: See col-scraper on GitHub

32 rows where member_id = 1227

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
862 862 Audit and Risk Management Committee 244 Randall Keith Anderson 1227  
863 863 Audit and Risk Management Committee of the Board of Governors of the Guildhall School of Music & Drama 201 Randall Keith Anderson 1227  
864 864 Barbican Residential Committee 153 Randall Keith Anderson 1227  
865 865 Board of Governors of the City of London School for Girls 236 Randall Keith Anderson 1227  
866 866 Board of Governors of the Guildhall School of Music and Drama 387 Randall Keith Anderson 1227  
867 867 Bursary Committee of the Board of Governors of the City of London School for Girls 237 Randall Keith Anderson 1227  
868 868 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Randall Keith Anderson 1227  
869 869 Community & Children's Services Committee 120 Randall Keith Anderson 1227  
870 870 Corporate Asset Sub (Finance) Committee 216 Randall Keith Anderson 1227  
871 871 223 Randall Keith Anderson 1227  
872 872 Digital Services Sub (Finance) Committee 257 Randall Keith Anderson 1227  
873 873 Education Board 1147 Randall Keith Anderson 1227  
874 874 Efficiency and Performance Sub (Finance) Committee 245 Randall Keith Anderson 1227  
875 875 Establishment Committee 253 Randall Keith Anderson 1227  
876 876 Finance Committee 145 Randall Keith Anderson 1227  
877 877 Health and Wellbeing Board 994 Randall Keith Anderson 1227  
878 878 Homelessness and Rough Sleeping Sub Committee 1261 Randall Keith Anderson 1227  
879 879 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Randall Keith Anderson 1227  
880 880 Integrated Commissioning Sub Committee 1247 Randall Keith Anderson 1227  
881 881 Joint Consultative Committee 254 Randall Keith Anderson 1227  
882 882 Local Plans Sub (Planning and Transportation) Committee 392 Randall Keith Anderson 1227  
883 883 Nominations Sub Committee of the Audit and Risk Management Committee 1260 Randall Keith Anderson 1227  
884 884 Planning and Transportation Committee 143 Randall Keith Anderson 1227  
885 885 Policy and Resources Committee 395 Randall Keith Anderson 1227  
886 886 Procurement Sub (Finance) Committee 1267 Randall Keith Anderson 1227  
887 887 Reference Sub Committee of the Board of Governors of the City of London School for Girls 196 Randall Keith Anderson 1227  
888 888 Reference Sub Committee of the Board of Governors of the Guildhall School of Music and Drama 410 Randall Keith Anderson 1227  
889 889 Remuneration and Nominations Committee of the Board of Governors of the Guildhall School of Music and Drama 1273 Randall Keith Anderson 1227  
890 890 Safeguarding Sub (Community & Children's Services) Committee 1096 Randall Keith Anderson 1227  
891 891 Standards Appeals Committee 1259 Randall Keith Anderson 1227  
892 892 Standards Committee 408 Randall Keith Anderson 1227  
893 893 Streets and Walkways Sub (Planning and Transportation) Committee 389 Randall Keith Anderson 1227  

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