home / colmem

committee_membership

Data source: See col-scraper on GitHub

37 rows where committee_id = 143

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
4 4 Planning and Transportation Committee 143 Graeme Harrower 1659  
61 61 Planning and Transportation Committee 143 Emma Edhem 1458  
110 110 Planning and Transportation Committee 143 Barbara Patricia Newman 363  
179 179 Planning and Transportation Committee 143 Judith Pleasance 1212  
234 234 Planning and Transportation Committee 143 Sylvia Doreen Moys 381  
255 255 Planning and Transportation Committee 143 Brian Desmond Francis Mooney 378  
264 264 Planning and Transportation Committee 143 Sir David Hugh Wootton 397  
278 278 Planning and Transportation Committee 143 James de Sausmarez 1658  
368 368 Planning and Transportation Committee 143 Robert Charles Hughes-Penney 257  
372 372 Planning and Transportation Committee 143 Peter Gerard Dunphy 200  
399 399 Planning and Transportation Committee 143 Jamie Ingham Clark 1223  
415 415 Planning and Transportation Committee 143 Sophie Anne Fernandes 217  
425 425 Planning and Transportation Committee 143 Karina Dostalova 1222  
435 435 Planning and Transportation Committee 143 Natasha Maria Cabrera Lloyd-Owen 2224  
472 472 Planning and Transportation Committee 143 Christopher Michael Hayward 1218  
493 493 Planning and Transportation Committee 143 Oliver Sells QC 1941  
515 515 Planning and Transportation Committee 143 Stuart John Fraser, CBE 221  
534 534 Planning and Transportation Committee 143 Tracey Graham 2316  
550 550 Planning and Transportation Committee 143 Christopher Hill 1942  
604 604 Planning and Transportation Committee 143 Prem Goyal 1939  
613 613 Planning and Transportation Committee 143 James Henry George Pollard 408  
629 629 Planning and Transportation Committee 143 Graham Packham 1221  
640 640 Planning and Transportation Committee 143 Mark Bostock 1958  
685 685 Planning and Transportation Committee 143 William Upton QC 1935  
704 704 Planning and Transportation Committee 143 Susan Jane Pearson 1934  
716 716 Planning and Transportation Committee 143 Peter Gordon Bennett 1888  
768 768 Planning and Transportation Committee 143 Keith David Forbes Bottomley 1666  
842 842 Planning and Transportation Committee 143 Marianne Bernadette Fredericks 223  
860 860 Planning and Transportation Committee 143 Rehana Banu Ameer 1948  
884 884 Planning and Transportation Committee 143 Randall Keith Anderson 1227  
981 981 Planning and Transportation Committee 143 Shravan Jashvantrai Joshi 2104  
1081 1081 Planning and Transportation Committee 143 Henry Nicholas Almroth Colthurst 1210  
1100 1100 Planning and Transportation Committee 143 Sir Mark Boleat 136  
1107 1107 Planning and Transportation Committee 143 Andrew Paul Mayer 1945  
1134 1134 Planning and Transportation Committee 143 Oliver Arthur Wynlayne Lodge 291  
1175 1175 Planning and Transportation Committee 143 Alastair Michael Moss 1226  
1193 1193 Planning and Transportation Committee 143 Munsur Ali 1949  

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