committee_membership

Data source: See col-scraper on GitHub

14 rows where committee_id = 125

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
28 28 Property Investment Board 125 Edward Lord 292  
127 127 Property Investment Board 125 Tom Sleigh 1213  
149 149 Property Investment Board 125 Andrien Gereith Dominic Meyers 1946  
206 206 Property Investment Board 125 Dhruv Patel 1224  
362 362 Property Investment Board 125 Christopher Paul Boden 1219  
404 404 Property Investment Board 125 Jamie Ingham Clark 1223  
458 458 Property Investment Board 125 Michael Hudson 256  
476 476 Property Investment Board 125 Christopher Michael Hayward 1218  
955 955 Property Investment Board 125 John Douglas Chapman 160  
984 984 Property Investment Board 125 Shravan Jashvantrai Joshi 2104  
1013 1013 Property Investment Board 125 Philip Woodhouse 1211  
1102 1102 Property Investment Board 125 Sir Mark Boleat 136  
1125 1125 Property Investment Board 125 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511  
1143 1143 Property Investment Board 125 Alison Gowman 229  

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