committee_membership

Data source: See col-scraper on GitHub

11 rows where committee_id = 122

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
214 214 Epping Forest & Commons Committee 122 Benjamin Daniel Murphy 2058  
230 230 Epping Forest & Commons Committee 122 Sylvia Doreen Moys 381  
321 321 Epping Forest & Commons Committee 122 Caroline Wilma Haines 1940  
365 365 Epping Forest & Commons Committee 122 Robert Charles Hughes-Penney 257  
490 490 Epping Forest & Commons Committee 122 Oliver Sells QC 1941  
529 529 Epping Forest & Commons Committee 122 Gregory Alfred Lawrence 276  
645 645 Epping Forest & Commons Committee 122 Robert Picton Seymour Howard 255  
657 657 Epping Forest & Commons Committee 122 Jeremy Lewis Simons 384  
713 713 Epping Forest & Commons Committee 122 Peter Gordon Bennett 1888  
897 897 Epping Forest & Commons Committee 122 Graeme Martyn Smith 1231  
1000 1000 Epping Forest & Commons Committee 122 Philip Woodhouse 1211  

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