home / colmem

committee_membership

Data source: See col-scraper on GitHub

30 rows where committee_id = 120

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
1 1 Community & Children's Services Committee 120 Graeme Harrower 1659  
103 103 Community & Children's Services Committee 120 Barbara Patricia Newman 363  
131 131 Community & Children's Services Committee 120 Thomas Alexander Anderson 1950  
187 187 Community & Children's Services Committee 120 David Andrew Graves 231  
199 199 Community & Children's Services Committee 120 Dhruv Patel 1224  
209 209 Community & Children's Services Committee 120 Benjamin Daniel Murphy 2058  
271 271 Community & Children's Services Committee 120 James de Sausmarez 1658  
282 282 Community & Children's Services Committee 120 Catherine McGuinness 373  
305 305 Community & Children's Services Committee 120 John William Fletcher 220  
316 316 Community & Children's Services Committee 120 Caroline Wilma Haines 1940  
331 331 Community & Children's Services Committee 120 Jason Paul Pritchard 1937  
432 432 Community & Children's Services Committee 120 Natasha Maria Cabrera Lloyd-Owen 2224  
482 482 Community & Children's Services Committee 120 William Pimlott 1936  
500 500 Community & Children's Services Committee 120 Mary Durcan 1957  
546 546 Community & Children's Services Committee 120 George Christopher Abrahams 131  
599 599 Community & Children's Services Committee 120 Prem Goyal 1939  
699 699 Community & Children's Services Committee 120 Susan Jane Pearson 1934  
710 710 Community & Children's Services Committee 120 Peter Gordon Bennett 1888  
786 786 Community & Children's Services Committee 120 Henrika Johanna Sofia Priest 409  
813 813 Community & Children's Services Committee 120 Ruby Sayed 1938  
830 830 Community & Children's Services Committee 120 Marianne Bernadette Fredericks 223  
852 852 Community & Children's Services Committee 120 Angus Knowles-Cutler 1943  
856 856 Community & Children's Services Committee 120 Rehana Banu Ameer 1948  
869 869 Community & Children's Services Committee 120 Randall Keith Anderson 1227  
912 912 Community & Children's Services Committee 120 Joyce Carruthers Nash 382  
994 994 Community & Children's Services Committee 120 Philip Woodhouse 1211  
1040 1040 Community & Children's Services Committee 120 The Revd Stephen Decatur Haines 232  
1071 1071 Community & Children's Services Committee 120 John Garbutt 225  
1086 1086 Community & Children's Services Committee 120 Matthew Bell 1953  
1190 1190 Community & Children's Services Committee 120 Munsur Ali 1949  

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");
Powered by Datasette · Queries took 6.775ms · Data source: See col-scraper on GitHub