committee_membership

Data source: See col-scraper on GitHub

33 rows where committee_id = 262

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
5 5 Port Health & Environmental Services Committee 262 Graeme Harrower 1659  
56 56 Port Health & Environmental Services Committee 262 Tom Hoffman 251  
79 79 Port Health & Environmental Services Committee 262 John Bennett 139  
118 118 Port Health & Environmental Services Committee 262 Sir Roger Gifford 226  
148 148 Port Health & Environmental Services Committee 262 Andrien Gereith Dominic Meyers 1946  
156 156 Port Health & Environmental Services Committee 262 Mark Raymond Peter Henry Delano Wheatley 1229  
160 160 Port Health & Environmental Services Committee 262 Caroline Kordai Addy 1947  
169 169 Port Health & Environmental Services Committee 262 Alexander Robertson Martin Barr 1951  
256 256 Port Health & Environmental Services Committee 262 Brian Desmond Francis Mooney 378  
335 335 Port Health & Environmental Services Committee 262 Jason Paul Pritchard 1937  
373 373 Port Health & Environmental Services Committee 262 Peter Gerard Dunphy 200  
401 401 Port Health & Environmental Services Committee 262 Jamie Ingham Clark 1223  
416 416 Port Health & Environmental Services Committee 262 Sophie Anne Fernandes 217  
498 498 Port Health & Environmental Services Committee 262 John David Absalom 132  
507 507 Port Health & Environmental Services Committee 262 Mary Durcan 1957  
524 524 Port Health & Environmental Services Committee 262 Anne Helen Fairweather 1756  
551 551 Port Health & Environmental Services Committee 262 Christopher Hill 1942  
564 564 Port Health & Environmental Services Committee 262 Tijs Broeke 1954  
585 585 Port Health & Environmental Services Committee 262 Richard David Regan 367  
596 596 Port Health & Environmental Services Committee 262 Wendy Hyde 263  
662 662 Port Health & Environmental Services Committee 262 Jeremy Lewis Simons 384  
717 717 Port Health & Environmental Services Committee 262 Peter Gordon Bennett 1888  
771 771 Port Health & Environmental Services Committee 262 Keith David Forbes Bottomley 1666  
785 785 Port Health & Environmental Services Committee 262 Gregory Jones QC 1220  
789 789 Port Health & Environmental Services Committee 262 Henrika Johanna Sofia Priest 409  
861 861 Port Health & Environmental Services Committee 262 Rehana Banu Ameer 1948  
920 920 Port Health & Environmental Services Committee 262 Joyce Carruthers Nash 382  
954 954 Port Health & Environmental Services Committee 262 John Douglas Chapman 160  
983 983 Port Health & Environmental Services Committee 262 Shravan Jashvantrai Joshi 2104  
988 988 Port Health & Environmental Services Committee 262 Adrian Mark Bastow 1952  
1059 1059 Port Health & Environmental Services Committee 262 Elizabeth Rogula 376  
1118 1118 Port Health & Environmental Services Committee 262 Vivienne Littlechild 287  
1186 1186 Port Health & Environmental Services Committee 262 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");