home / colmem

committee_membership

Data source: See col-scraper on GitHub

23 rows where member_id = 370

✎ View and edit SQL

This data as json, CSV (advanced)

role 2 ✖

  • - 22
  • Chairman 1
Link rowid ▼ committee_id member_id role
790 790 Audit and Risk Management Committee 244 Jeremy Mayhew 370  
791 791 Barbican Residential Committee 153 Jeremy Mayhew 370  
792 792 Board of Governors of the Guildhall School of Music and Drama 387 Jeremy Mayhew 370  
793 793 Capital Buildings Committee 1255 Jeremy Mayhew 370  
794 794 Corporate Asset Sub (Finance) Committee 216 Jeremy Mayhew 370 Chairman
795 795 223 Jeremy Mayhew 370  
796 796 Culture, Heritage and Libraries Committee 177 Jeremy Mayhew 370  
797 797 Digital Services Sub (Finance) Committee 257 Jeremy Mayhew 370  
798 798 Efficiency and Performance Sub (Finance) Committee 245 Jeremy Mayhew 370  
799 799 Establishment Committee 253 Jeremy Mayhew 370  
800 800 Finance Committee 145 Jeremy Mayhew 370  
801 801 Finance Grants Oversight and Performance Sub Committee 192 Jeremy Mayhew 370  
802 802 Freedom Applications Committee 183 Jeremy Mayhew 370  
803 803 Investment Committee 176 Jeremy Mayhew 370  
804 804 1183 Jeremy Mayhew 370  
805 805 Outside Bodies Sub (Policy and Resources) Committee 1205 Jeremy Mayhew 370  
806 806 Policy and Resources Committee 395 Jeremy Mayhew 370  
807 807 Procurement Sub (Finance) Committee 1267 Jeremy Mayhew 370  
808 808 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Jeremy Mayhew 370  
809 809 Resource Allocation Sub (Policy and Resources) Committee 396 Jeremy Mayhew 370  
810 810 Senior Remuneration Sub-Committee 1262 Jeremy Mayhew 370  
811 811 Social Investment Board 1064 Jeremy Mayhew 370  
812 812 The City Bridge Trust Committee 179 Jeremy Mayhew 370  

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