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

Data source: See col-scraper on GitHub

130 rows sorted by name

View and edit SQL

id name ▼ role party ward_id url
399 Sir Alan Colin Drake Yarrow Alderman   Bridge and Bridge Without 70fbd1ea
404 Sir Andrew Charles Parmley, Alderman   Vintry 0bcd8436
397 Sir David Hugh Wootton Alderman   Langbourn 09362530
136 Sir Mark Boleat     Cordwainer 3aa4ba2e
385 Sir Michael Snyder     Cordwainer 3aa4ba2e
226 Sir Roger Gifford Alderman   Cordwainer 3aa4ba2e
217 Sophie Anne Fernandes     Coleman Street 43861e99
362 Stephen Douglas Quilter     Cripplegate e5a9d3d8
221 Stuart John Fraser, CBE     Coleman Street 43861e99
1934 Susan Jane Pearson     Cripplegate e5a9d3d8
2186 Susan Langley Alderman   Aldgate 68323942
381 Sylvia Doreen Moys     Aldgate 68323942
207 The Lord Mountevans, Jeffrey Evans Alderman   Cheap 70a9d190
232 The Revd Stephen Decatur Haines Deputy   Cornhill 3a2fdc7e
1592 The Rt Hon the Baroness Patricia Scotland of Asthal, QC Alderman   Bishopsgate c1386831
1419 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin     Coleman Street 43861e99
1950 Thomas Alexander Anderson     Farringdon Within 13e8d138
1955 Thomas Cowley Clementi     Lime Street 675b7bdd
1954 Tijs Broeke     Cheap 70a9d190
1944 Tim Levene     Bridge and Bridge Without 70fbd1ea
1260 Timothy Russell Hailes Alderman   Bassishaw 2a66d0da
251 Tom Hoffman Deputy   Vintry 0bcd8436
1213 Tom Sleigh Deputy   Bishopsgate c1386831
2316 Tracey Graham     Cordwainer 3aa4ba2e
287 Vivienne Littlechild     Cripplegate e5a9d3d8
263 Wendy Hyde Deputy   Bishopsgate c1386831
375 Wendy Mead     Farringdon Without 2b5454aa
1202 William Anthony Bowater Russell Alderman   Bread Street 15362cc1
1936 William Pimlott     Cripplegate e5a9d3d8
1935 William Upton QC     Farringdon Without 2b5454aa

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