committee_membership

Data source: See col-scraper on GitHub

10 rows where member_id = 264

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
1060 1060 Board of Governors of the City of London Freemen's School 230 Clare James 264  
1061 1061 Board of Governors of the City of London School 233 Clare James 264  
1062 1062 Board of Governors of the City of London School for Girls 236 Clare James 264  
1063 1063 Bursary Committee of the Board of Governors of the City of London School for Girls 237 Clare James 264  
1064 1064 223 Clare James 264  
1065 1065 Efficiency and Performance Sub (Finance) Committee 245 Clare James 264  
1066 1066 Finance Committee 145 Clare James 264  
1067 1067 Financial Investment Board 248 Clare James 264  
1068 1068 Investment Committee 176 Clare James 264  
1069 1069 Reference Sub Committee of the Board of Governors of the City of London School for Girls 196 Clare James 264  

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