committee_membership

Data source: See col-scraper on GitHub

13 rows where committee_id = 244

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
143 143 Audit and Risk Management Committee 244 Andrien Gereith Dominic Meyers 1946  
163 163 Audit and Risk Management Committee 244 Alexander Robertson Martin Barr 1951  
328 328 Audit and Risk Management Committee 244 Nicholas Anstee 133  
354 354 Audit and Risk Management Committee 244 Christopher Paul Boden 1219  
378 378 Audit and Risk Management Committee 244 Jamie Ingham Clark 1223  
516 516 Audit and Risk Management Committee 244 Anne Helen Fairweather 1756  
570 570 Audit and Risk Management Committee 244 Paul Nicholas Martinelli 1217  
668 668 Audit and Risk Management Committee 244 Ian David Luder 296  
790 790 Audit and Risk Management Committee 244 Jeremy Mayhew 370  
825 825 Audit and Risk Management Committee 244 Marianne Bernadette Fredericks 223  
862 862 Audit and Risk Management Committee 244 Randall Keith Anderson 1227  
1070 1070 Audit and Risk Management Committee 244 John Garbutt 225  
1090 1090 Audit and Risk Management Committee 244 John Petrie 2105  

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