committee_membership

Data source: See col-scraper on GitHub

25 rows where member_id = 223

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
825 825 Audit and Risk Management Committee 244 Marianne Bernadette Fredericks 223  
826 826 Audit and Risk Management Committee of the Board of Governors of the Guildhall School of Music & Drama 201 Marianne Bernadette Fredericks 223  
827 827 Board of Governors of the City of London School 233 Marianne Bernadette Fredericks 223  
828 828 Board of Governors of the Guildhall School of Music and Drama 387 Marianne Bernadette Fredericks 223  
829 829 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Marianne Bernadette Fredericks 223  
830 830 Community & Children's Services Committee 120 Marianne Bernadette Fredericks 223  
831 831 Corporate Asset Sub (Finance) Committee 216 Marianne Bernadette Fredericks 223  
832 832 223 Marianne Bernadette Fredericks 223  
833 833 Crime and Disorder Scrutiny Committee 173 Marianne Bernadette Fredericks 223  
834 834 Governance and Effectiveness Committee of the Board of Governors of the Guildhall School of Music & Drama 218 Marianne Bernadette Fredericks 223  
835 835 Health and Wellbeing Board 994 Marianne Bernadette Fredericks 223  
836 836 Homelessness and Rough Sleeping Sub Committee 1261 Marianne Bernadette Fredericks 223  
837 837 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Marianne Bernadette Fredericks 223  
838 838 Integrated Commissioning Sub Committee 1247 Marianne Bernadette Fredericks 223  
839 839 Licensing (Hearing) Sub Committee 200 Marianne Bernadette Fredericks 223  
840 840 Licensing Committee 123 Marianne Bernadette Fredericks 223  
841 841 Member Development Steering Group 174 Marianne Bernadette Fredericks 223  
842 842 Planning and Transportation Committee 143 Marianne Bernadette Fredericks 223  
843 843 Policy and Resources Committee 395 Marianne Bernadette Fredericks 223  
844 844 Reference Sub (Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital) Committee 1063 Marianne Bernadette Fredericks 223  
845 845 Reference Sub (Licensing) Committee 986 Marianne Bernadette Fredericks 223  
846 846 Remuneration and Nominations Committee of the Board of Governors of the Guildhall School of Music and Drama 1273 Marianne Bernadette Fredericks 223  
847 847 Safeguarding Sub (Community & Children's Services) Committee 1096 Marianne Bernadette Fredericks 223  
848 848 Standards Appeals Committee 1259 Marianne Bernadette Fredericks 223  
849 849 The City Bridge Trust Committee 179 Marianne Bernadette Fredericks 223  

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