committee_membership

Data source: See col-scraper on GitHub

13 rows where committee_id = 1259

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
269 269 Standards Appeals Committee 1259 Sir David Hugh Wootton 397  
353 353 Standards Appeals Committee 1259 Nicholas Michael Bensted-Smith 1472  
461 461 Standards Appeals Committee 1259 Michael Hudson 256  
479 479 Standards Appeals Committee 1259 Christopher Michael Hayward 1218  
680 680 Standards Appeals Committee 1259 Ian David Luder 296  
741 741 Standards Appeals Committee 1259 Simon D'Olier Duckworth 151  
777 777 Standards Appeals Committee 1259 Keith David Forbes Bottomley 1666  
848 848 Standards Appeals Committee 1259 Marianne Bernadette Fredericks 223  
891 891 Standards Appeals Committee 1259 Randall Keith Anderson 1227  
958 958 Standards Appeals Committee 1259 John Douglas Chapman 160  
1083 1083 Standards Appeals Committee 1259 Henry Nicholas Almroth Colthurst 1210  
1094 1094 Standards Appeals Committee 1259 John Petrie 2105  
1127 1127 Standards Appeals Committee 1259 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511  

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