committee_membership

Data source: See col-scraper on GitHub

7 rows where member_id = 394

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
941 941 223 James Richard Tumbridge 394  
942 942 Licensing Committee 123 James Richard Tumbridge 394  
943 943 Local Government Pensions Board 1187 James Richard Tumbridge 394  
944 944 Markets Committee 411 James Richard Tumbridge 394  
945 945 Outside Bodies Sub (Policy and Resources) Committee 1205 James Richard Tumbridge 394  
946 946 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 James Richard Tumbridge 394  
947 947 Reference Sub (Markets) Committee 563 James Richard Tumbridge 394  

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