Aldermen and Common Councilmen. There are 25 Aldermen and 100 Common Councilmen.

Data source: See col-scraper on GitHub

130 rows sorted by name descending

View and edit SQL

Suggested facets: role

id name ▲ role party ward_id url
1935 William Upton QC     Farringdon Without 2b5454aa
1936 William Pimlott     Cripplegate e5a9d3d8
1202 William Anthony Bowater Russell Alderman   Bread Street 15362cc1
375 Wendy Mead     Farringdon Without 2b5454aa
263 Wendy Hyde Deputy   Bishopsgate c1386831
287 Vivienne Littlechild     Cripplegate e5a9d3d8
2316 Tracey Graham     Cordwainer 3aa4ba2e
1213 Tom Sleigh Deputy   Bishopsgate c1386831
251 Tom Hoffman Deputy   Vintry 0bcd8436
1260 Timothy Russell Hailes Alderman   Bassishaw 2a66d0da
1944 Tim Levene     Bridge and Bridge Without 70fbd1ea
1954 Tijs Broeke     Cheap 70a9d190
1955 Thomas Cowley Clementi     Lime Street 675b7bdd
1950 Thomas Alexander Anderson     Farringdon Within 13e8d138
1419 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin     Coleman Street 43861e99
1592 The Rt Hon the Baroness Patricia Scotland of Asthal, QC Alderman   Bishopsgate c1386831
232 The Revd Stephen Decatur Haines Deputy   Cornhill 3a2fdc7e
207 The Lord Mountevans, Jeffrey Evans Alderman   Cheap 70a9d190
381 Sylvia Doreen Moys     Aldgate 68323942
2186 Susan Langley Alderman   Aldgate 68323942
1934 Susan Jane Pearson     Cripplegate e5a9d3d8
221 Stuart John Fraser, CBE     Coleman Street 43861e99
362 Stephen Douglas Quilter     Cripplegate e5a9d3d8
217 Sophie Anne Fernandes     Coleman Street 43861e99
226 Sir Roger Gifford Alderman   Cordwainer 3aa4ba2e
385 Sir Michael Snyder     Cordwainer 3aa4ba2e
136 Sir Mark Boleat     Cordwainer 3aa4ba2e
397 Sir David Hugh Wootton Alderman   Langbourn 09362530
404 Sir Andrew Charles Parmley, Alderman   Vintry 0bcd8436
399 Sir Alan Colin Drake Yarrow Alderman   Bridge and Bridge Without 70fbd1ea
151 Simon D'Olier Duckworth     Bishopsgate c1386831
2104 Shravan Jashvantrai Joshi     Bishopsgate c1386831
1395 Sheriff Vincent Thomas Keaveny Alderman   Farringdon Within 13e8d138
1938 Ruby Sayed     Farringdon Without 2b5454aa
158 Roger Arthur Holden Chadwick     Tower 9a06a5f0
255 Robert Picton Seymour Howard Alderman   Cornhill 3a2fdc7e
257 Robert Charles Hughes-Penney Alderman   Cheap 70a9d190
377 Robert Allan Merrett Deputy   Bassishaw 2a66d0da
1956 Richard Peter Crossan     Aldersgate 286f7f31
367 Richard David Regan Deputy   Farringdon Within 13e8d138
1948 Rehana Banu Ameer     Vintry 0bcd8436
1227 Randall Keith Anderson     Aldersgate 286f7f31
1323 Professor Michael Raymond Mainelli Alderman   Broad Street 0367a1d1
1939 Prem Goyal Alderman   Portsoken 03c562f9
1211 Philip Woodhouse Deputy   Langbourn 09362530
511 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA Alderman   Aldgate 68323942
1888 Peter Gordon Bennett     Walbrook ab151963
200 Peter Gerard Dunphy     Cornhill 3a2fdc7e
1217 Paul Nicholas Martinelli     Farringdon Without 2b5454aa
1941 Oliver Sells QC     Farringdon Without 2b5454aa
291 Oliver Arthur Wynlayne Lodge     Bread Street 15362cc1
2034 Nicholas Stephen Leland Lyons Alderman   Tower 9a06a5f0
1472 Nicholas Michael Bensted-Smith     Cheap 70a9d190
133 Nicholas Anstee Alderman   Aldersgate 286f7f31
2224 Natasha Maria Cabrera Lloyd-Owen     Castle Baynard 31037861
1949 Munsur Ali     Portsoken 03c562f9
141 Michael John Cassidy     Coleman Street 43861e99
256 Michael Hudson     Castle Baynard 31037861
374 Matthew Richardson Alderman   Billingsgate 0434a638
1953 Matthew Bell     Farringdon Within 13e8d138
1957 Mary Durcan     Cripplegate e5a9d3d8
1229 Mark Raymond Peter Henry Delano Wheatley     Dowgate 6df2119b
1958 Mark Bostock     Cripplegate e5a9d3d8
223 Marianne Bernadette Fredericks     Tower 9a06a5f0
213 Kevin Malcolm Everett Deputy   Candlewick e74982dd
1666 Keith David Forbes Bottomley Deputy   Bridge and Bridge Without 70fbd1ea
1222 Karina Dostalova     Farringdon Within 13e8d138
1212 Judith Pleasance     Langbourn 09362530
382 Joyce Carruthers Nash Deputy   Aldersgate 286f7f31
220 John William Fletcher     Portsoken 03c562f9
392 John Tomlinson Deputy   Cripplegate e5a9d3d8
2105 John Petrie     Billingsgate 0434a638
401 John George Stewart Scott     Broad Street 0367a1d1
225 John Garbutt Alderman   Walbrook ab151963
160 John Douglas Chapman     Langbourn 09362530
132 John David Absalom Deputy   Farringdon Without 2b5454aa
139 John Bennett     Broad Street 0367a1d1
370 Jeremy Mayhew     Aldersgate 286f7f31
384 Jeremy Lewis Simons     Castle Baynard 31037861
1937 Jason Paul Pritchard     Portsoken 03c562f9
1223 Jamie Ingham Clark Deputy   Billingsgate 0434a638
1658 James de Sausmarez     Candlewick e74982dd
394 James Richard Tumbridge     Tower 9a06a5f0
1207 James Michael Douglas Thomson Deputy   Walbrook ab151963
408 James Henry George Pollard Deputy   Dowgate 6df2119b
296 Ian David Luder Alderman   Castle Baynard 31037861
402 Ian Christopher Norman Seaton     Cornhill 3a2fdc7e
380 Hugh Fenton Morris Deputy   Aldgate 68323942
1210 Henry Nicholas Almroth Colthurst     Lime Street 675b7bdd
265 Henry Llewellyn Michael Jones Deputy   Portsoken 03c562f9
409 Henrika Johanna Sofia Priest     Castle Baynard 31037861
1220 Gregory Jones QC Alderman   Farringdon Without 2b5454aa
276 Gregory Alfred Lawrence     Farringdon Without 2b5454aa
1221 Graham Packham     Castle Baynard 31037861
1231 Graeme Martyn Smith     Farringdon Within 13e8d138
1659 Graeme Harrower     Bassishaw 2a66d0da
131 George Christopher Abrahams     Farringdon Without 2b5454aa
1458 Emma Edhem Alderman   Candlewick e74982dd
376 Elizabeth Rogula Deputy   Lime Street 675b7bdd
292 Edward Lord Deputy   Farringdon Without 2b5454aa

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE members (
        id INTEGER NOT NULL,
        name VARCHAR(255) NOT NULL,
        role VARCHAR(50),
        party VARCHAR(50),
        ward_id VARCHAR(8) REFERENCES wards(id),
        url VARCHAR(255),
        PRIMARY KEY (id)
CREATE INDEX members_ward_id ON members("ward_id");