committee_membership

Data source: See col-scraper on GitHub

13 rows where member_id = 1888

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
707 707 Board of Governors of the City of London School for Girls 236 Peter Gordon Bennett 1888  
708 708 Capital Buildings Committee 1255 Peter Gordon Bennett 1888  
709 709 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Peter Gordon Bennett 1888  
710 710 Community & Children's Services Committee 120 Peter Gordon Bennett 1888  
711 711 223 Peter Gordon Bennett 1888  
712 712 Culture, Heritage and Libraries Committee 177 Peter Gordon Bennett 1888  
713 713 Epping Forest & Commons Committee 122 Peter Gordon Bennett 1888  
714 714 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Peter Gordon Bennett 1888  
715 715 Markets Committee 411 Peter Gordon Bennett 1888  
716 716 Planning and Transportation Committee 143 Peter Gordon Bennett 1888  
717 717 Port Health & Environmental Services Committee 262 Peter Gordon Bennett 1888  
718 718 Reference Sub (Markets) Committee 563 Peter Gordon Bennett 1888  
719 719 Streets and Walkways Sub (Planning and Transportation) Committee 389 Peter Gordon Bennett 1888  

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