home / colmem

committee_membership

Data source: See col-scraper on GitHub

13 rows where committee_id = 248

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
145 145 Financial Investment Board 248 Andrien Gereith Dominic Meyers 1946  
276 276 Financial Investment Board 248 James de Sausmarez 1658  
344 344 Financial Investment Board 248 Nicholas Michael Bensted-Smith 1472  
366 366 Financial Investment Board 248 Robert Charles Hughes-Penney 257  
390 390 Financial Investment Board 248 Jamie Ingham Clark 1223  
611 611 Financial Investment Board 248 James Henry George Pollard 408  
646 646 Financial Investment Board 248 Robert Picton Seymour Howard 255  
728 728 Financial Investment Board 248 Simon D'Olier Duckworth 151  
935 935 Financial Investment Board 248 Ian Christopher Norman Seaton 402  
973 973 Financial Investment Board 248 Tim Levene 1944  
1007 1007 Financial Investment Board 248 Philip Woodhouse 1211  
1067 1067 Financial Investment Board 248 Clare James 264  
1077 1077 Financial Investment Board 248 Henry Nicholas Almroth Colthurst 1210  

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