home / colmem

committee_membership

Data source: See col-scraper on GitHub

17 rows where member_id = 1221

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
617 617 Barbican Centre Board 140 Graham Packham 1221  
618 618 Barbican Residential Committee 153 Graham Packham 1221  
619 619 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Graham Packham 1221  
620 620 Board of Governors of the City of London Freemen's School 230 Graham Packham 1221  
621 621 Board of Governors of the Guildhall School of Music and Drama 387 Graham Packham 1221  
622 622 223 Graham Packham 1221  
623 623 Culture, Heritage and Libraries Committee 177 Graham Packham 1221  
624 624 Finance and Resources Committee of the Board of Governors of the Guildhall School of Music & Drama 163 Graham Packham 1221  
625 625 Governance and Effectiveness Committee of the Board of Governors of the Guildhall School of Music & Drama 218 Graham Packham 1221  
626 626 Keats House Consultative Committee 413 Graham Packham 1221  
627 627 Licensing Committee 123 Graham Packham 1221  
628 628 Local Plans Sub (Planning and Transportation) Committee 392 Graham Packham 1221  
629 629 Planning and Transportation Committee 143 Graham Packham 1221  
630 630 Policy and Resources Committee 395 Graham Packham 1221  
631 631 Reference Sub Committee of the Board of Governors of the Guildhall School of Music and Drama 410 Graham Packham 1221  
632 632 Remuneration and Nominations Committee of the Board of Governors of the Guildhall School of Music and Drama 1273 Graham Packham 1221  
633 633 Streets and Walkways Sub (Planning and Transportation) Committee 389 Graham Packham 1221  

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 10.075ms · Data source: See col-scraper on GitHub