home / colmem

committee_membership

Data source: See col-scraper on GitHub

12 rows where committee_id = 227

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
64 64 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Andrew Stratton McMurtrie 1225  
270 270 Benefices Sub (Culture, Heritage & Libraries) Committee 227 James de Sausmarez 1658  
314 314 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Caroline Wilma Haines 1940  
379 379 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Jamie Ingham Clark 1223  
577 577 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Richard David Regan 367  
588 588 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Wendy Hyde 263  
619 619 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Graham Packham 1221  
721 721 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Simon D'Olier Duckworth 151  
779 779 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Gregory Jones QC 1220  
927 927 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Ian Christopher Norman Seaton 402  
1039 1039 Benefices Sub (Culture, Heritage & Libraries) Committee 227 The Revd Stephen Decatur Haines 232  
1161 1161 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Ann Holmes 1230  

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 42.19ms · Data source: See col-scraper on GitHub