committee_membership

Data source: See col-scraper on GitHub

30 rows where committee_id = 411

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
24 24 Markets Committee 411 Edward Lord 292  
51 51 Markets Committee 411 Tom Hoffman 251  
88 88 Markets Committee 411 Wendy Mead 375  
124 124 Markets Committee 411 Tom Sleigh 1213  
134 134 Markets Committee 411 Thomas Alexander Anderson 1950  
147 147 Markets Committee 411 Andrien Gereith Dominic Meyers 1946  
154 154 Markets Committee 411 Mark Raymond Peter Henry Delano Wheatley 1229  
172 172 Markets Committee 411 Stephen Douglas Quilter 362  
192 192 Markets Committee 411 David Andrew Graves 231  
242 242 Markets Committee 411 Bronek Masojada 2259  
250 250 Markets Committee 411 John George Stewart Scott 401  
254 254 Markets Committee 411 Brian Desmond Francis Mooney 378  
312 312 Markets Committee 411 Richard Peter Crossan 1956  
347 347 Markets Committee 411 Nicholas Michael Bensted-Smith 1472  
439 439 Markets Committee 411 Douglas Barrow 128  
532 532 Markets Committee 411 Gregory Alfred Lawrence 276  
638 638 Markets Committee 411 Mark Bostock 1958  
715 715 Markets Committee 411 Peter Gordon Bennett 1888  
854 854 Markets Committee 411 Angus Knowles-Cutler 1943  
918 918 Markets Committee 411 Joyce Carruthers Nash 382  
938 938 Markets Committee 411 Ian Christopher Norman Seaton 402  
944 944 Markets Committee 411 James Richard Tumbridge 394  
953 953 Markets Committee 411 John Douglas Chapman 160  
964 964 Markets Committee 411 David John Bradshaw 137  
1018 1018 Markets Committee 411 Henry Llewellyn Michael Jones 265  
1050 1050 Markets Committee 411 Robert Allan Merrett 377  
1089 1089 Markets Committee 411 Matthew Bell 1953  
1093 1093 Markets Committee 411 John Petrie 2105  
1152 1152 Markets Committee 411 Dr Giles Robert Evelyn Shilson 383  
1185 1185 Markets Committee 411 Kevin Malcolm Everett 213  

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