Data source: See col-scraper on GitHub

18 rows where member_id = 1472

View and edit SQL

Link rowid ▼ committee_id member_id role
336 Board of Governors of the City of London School for Girls 236 Nicholas Michael Bensted-Smith 1472  
337 Bursary Committee of the Board of Governors of the City of London School for Girls 237 Nicholas Michael Bensted-Smith 1472  
338 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Nicholas Michael Bensted-Smith 1472  
339 Corporate Asset Sub (Finance) Committee 216 Nicholas Michael Bensted-Smith 1472  
340 223 Nicholas Michael Bensted-Smith 1472  
341 Economic Crime Committee of the Police Authority Board 513 Nicholas Michael Bensted-Smith 1472  
342 Finance Committee 145 Nicholas Michael Bensted-Smith 1472  
343 Finance Grants Oversight and Performance Sub Committee 192 Nicholas Michael Bensted-Smith 1472  
344 Financial Investment Board 248 Nicholas Michael Bensted-Smith 1472  
345 Gresham (City Side) Committee 259 Nicholas Michael Bensted-Smith 1472  
346 Investment Committee 176 Nicholas Michael Bensted-Smith 1472  
347 Markets Committee 411 Nicholas Michael Bensted-Smith 1472  
348 Performance and Resource Management Committee of the Police Authority Board 171 Nicholas Michael Bensted-Smith 1472  
349 Police Authority Board 142 Nicholas Michael Bensted-Smith 1472  
350 Professional Standards and Integrity Committee of the Police Authority Board 398 Nicholas Michael Bensted-Smith 1472  
351 Reference Sub Committee of the Board of Governors of the City of London School for Girls 196 Nicholas Michael Bensted-Smith 1472  
352 Social Investment Board 1064 Nicholas Michael Bensted-Smith 1472  
353 Standards Appeals Committee 1259 Nicholas Michael Bensted-Smith 1472  

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