committee_membership

Data source: See col-scraper on GitHub

25 rows where member_id = 1666

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
754 754 Board of Governors of the City of London School 233 Keith David Forbes Bottomley 1666  
755 755 Capital Buildings Committee 1255 Keith David Forbes Bottomley 1666  
756 756 223 Keith David Forbes Bottomley 1666  
757 757 Digital Services Sub (Finance) Committee 257 Keith David Forbes Bottomley 1666  
758 758 Economic Crime Committee of the Police Authority Board 513 Keith David Forbes Bottomley 1666  
759 759 Education Board 1147 Keith David Forbes Bottomley 1666  
760 760 Establishment Committee 253 Keith David Forbes Bottomley 1666  
761 761 Finance & Estates Committee of the Board of Governors of the City of London School 1233 Keith David Forbes Bottomley 1666  
762 762 Joint Consultative Committee 254 Keith David Forbes Bottomley 1666  
763 763 Licensing (Hearing) Sub Committee 200 Keith David Forbes Bottomley 1666  
764 764 Licensing Committee 123 Keith David Forbes Bottomley 1666  
765 765 Local Plans Sub (Planning and Transportation) Committee 392 Keith David Forbes Bottomley 1666  
766 766 Member Development Steering Group 174 Keith David Forbes Bottomley 1666  
767 767 Performance and Resource Management Committee of the Police Authority Board 171 Keith David Forbes Bottomley 1666  
768 768 Planning and Transportation Committee 143 Keith David Forbes Bottomley 1666  
769 769 Police Authority Board 142 Keith David Forbes Bottomley 1666  
770 770 Policy and Resources Committee 395 Keith David Forbes Bottomley 1666  
771 771 Port Health & Environmental Services Committee 262 Keith David Forbes Bottomley 1666  
772 772 Projects Sub (Policy and Resources) Committee 168 Keith David Forbes Bottomley 1666  
773 773 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Keith David Forbes Bottomley 1666  
774 774 Reference Sub (Licensing) Committee 986 Keith David Forbes Bottomley 1666  
775 775 Resource Allocation Sub (Policy and Resources) Committee 396 Keith David Forbes Bottomley 1666  
776 776 Senior Remuneration Sub-Committee 1262 Keith David Forbes Bottomley 1666  
777 777 Standards Appeals Committee 1259 Keith David Forbes Bottomley 1666  
778 778 Streets and Walkways Sub (Planning and Transportation) Committee 389 Keith David Forbes Bottomley 1666  

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