committee_membership

Data source: See col-scraper on GitHub

39 rows where committee_id = 145

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
38 38 Finance Committee 145 Nicholas Stephen Leland Lyons 2034  
43 43 Finance Committee 145 Hugh Fenton Morris 380  
66 66 Finance Committee 145 Andrew Stratton McMurtrie 1225  
100 100 Finance Committee 145 Roger Arthur Holden Chadwick 158  
121 121 Finance Committee 145 Tom Sleigh 1213  
183 183 Finance Committee 145 Matthew Richardson 374  
216 216 Finance Committee 145 Benjamin Daniel Murphy 2058  
247 247 Finance Committee 145 John George Stewart Scott 401  
275 275 Finance Committee 145 James de Sausmarez 1658  
286 286 Finance Committee 145 Catherine McGuinness 373  
302 302 Finance Committee 145 Dominic Gerard Christian 1757  
307 307 Finance Committee 145 John William Fletcher 220  
323 323 Finance Committee 145 Caroline Wilma Haines 1940  
342 342 Finance Committee 145 Nicholas Michael Bensted-Smith 1472  
358 358 Finance Committee 145 Christopher Paul Boden 1219  
388 388 Finance Committee 145 Jamie Ingham Clark 1223  
450 450 Finance Committee 145 Michael Hudson 256  
484 484 Finance Committee 145 William Pimlott 1936  
531 531 Finance Committee 145 Gregory Alfred Lawrence 276  
573 573 Finance Committee 145 Paul Nicholas Martinelli 1217  
592 592 Finance Committee 145 Wendy Hyde 263  
610 610 Finance Committee 145 James Henry George Pollard 408  
689 689 Finance Committee 145 Sir Andrew Charles Parmley, 404  
701 701 Finance Committee 145 Susan Jane Pearson 1934  
726 726 Finance Committee 145 Simon D'Olier Duckworth 151  
746 746 Finance Committee 145 Sir Michael Snyder 385  
783 783 Finance Committee 145 Gregory Jones QC 1220  
800 800 Finance Committee 145 Jeremy Mayhew 370  
859 859 Finance Committee 145 Rehana Banu Ameer 1948  
876 876 Finance Committee 145 Randall Keith Anderson 1227  
900 900 Finance Committee 145 Graeme Martyn Smith 1231  
926 926 Finance Committee 145 Alastair John Naisbitt King 269  
933 933 Finance Committee 145 Ian Christopher Norman Seaton 402  
972 972 Finance Committee 145 Tim Levene 1944  
1004 1004 Finance Committee 145 Philip Woodhouse 1211  
1033 1033 Finance Committee 145 James Michael Douglas Thomson 1207  
1049 1049 Finance Committee 145 Robert Allan Merrett 377  
1066 1066 Finance Committee 145 Clare James 264  
1133 1133 Finance Committee 145 Oliver Arthur Wynlayne Lodge 291  

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