committee_membership

Data source: See col-scraper on GitHub

13 rows where committee_id = 247

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
107 107 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Barbara Patricia Newman 363  
191 191 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 David Andrew Graves 231  
203 203 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Dhruv Patel 1224  
309 309 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 John William Fletcher 220  
334 334 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Jason Paul Pritchard 1937  
486 486 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 William Pimlott 1936  
504 504 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Mary Durcan 1957  
702 702 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Susan Jane Pearson 1934  
714 714 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Peter Gordon Bennett 1888  
819 819 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Ruby Sayed 1938  
837 837 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Marianne Bernadette Fredericks 223  
879 879 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Randall Keith Anderson 1227  
1044 1044 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 The Revd Stephen Decatur Haines 232  

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