home / colmem

committee_membership

Data source: See col-scraper on GitHub

18 rows where member_id = 1472

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
336 336 Board of Governors of the City of London School for Girls 236 Nicholas Michael Bensted-Smith 1472  
337 337 Bursary Committee of the Board of Governors of the City of London School for Girls 237 Nicholas Michael Bensted-Smith 1472  
338 338 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Nicholas Michael Bensted-Smith 1472  
339 339 Corporate Asset Sub (Finance) Committee 216 Nicholas Michael Bensted-Smith 1472  
340 340 223 Nicholas Michael Bensted-Smith 1472  
341 341 Economic Crime Committee of the Police Authority Board 513 Nicholas Michael Bensted-Smith 1472  
342 342 Finance Committee 145 Nicholas Michael Bensted-Smith 1472  
343 343 Finance Grants Oversight and Performance Sub Committee 192 Nicholas Michael Bensted-Smith 1472  
344 344 Financial Investment Board 248 Nicholas Michael Bensted-Smith 1472  
345 345 Gresham (City Side) Committee 259 Nicholas Michael Bensted-Smith 1472  
346 346 Investment Committee 176 Nicholas Michael Bensted-Smith 1472  
347 347 Markets Committee 411 Nicholas Michael Bensted-Smith 1472  
348 348 Performance and Resource Management Committee of the Police Authority Board 171 Nicholas Michael Bensted-Smith 1472  
349 349 Police Authority Board 142 Nicholas Michael Bensted-Smith 1472  
350 350 Professional Standards and Integrity Committee of the Police Authority Board 398 Nicholas Michael Bensted-Smith 1472  
351 351 Reference Sub Committee of the Board of Governors of the City of London School for Girls 196 Nicholas Michael Bensted-Smith 1472  
352 352 Social Investment Board 1064 Nicholas Michael Bensted-Smith 1472  
353 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");
Powered by Datasette · Queries took 14.02ms · Data source: See col-scraper on GitHub