committee_membership

Data source: See col-scraper on GitHub

16 rows where committee_id = 153

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
102 102 Barbican Residential Committee 153 Barbara Patricia Newman 363  
151 151 Barbican Residential Committee 153 Mark Raymond Peter Henry Delano Wheatley 1229  
170 170 Barbican Residential Committee 153 Stephen Douglas Quilter 362  
355 355 Barbican Residential Committee 153 Christopher Paul Boden 1219  
445 445 Barbican Residential Committee 153 Michael Hudson 256  
481 481 Barbican Residential Committee 153 William Pimlott 1936  
499 499 Barbican Residential Committee 153 Mary Durcan 1957  
618 618 Barbican Residential Committee 153 Graham Packham 1221  
635 635 Barbican Residential Committee 153 Mark Bostock 1958  
691 691 Barbican Residential Committee 153 John Tomlinson 392  
698 698 Barbican Residential Committee 153 Susan Jane Pearson 1934  
791 791 Barbican Residential Committee 153 Jeremy Mayhew 370  
864 864 Barbican Residential Committee 153 Randall Keith Anderson 1227  
959 959 Barbican Residential Committee 153 David John Bradshaw 137  
986 986 Barbican Residential Committee 153 Adrian Mark Bastow 1952  
1085 1085 Barbican Residential Committee 153 Matthew Bell 1953  

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