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

Data source: See col-scraper on GitHub

5 rows where ward_id = "43861e99" sorted by name

View and edit SQL


  • Coleman Street · 5
id name ▼ role party ward_id url
1225 Andrew Stratton McMurtrie     Coleman Street 43861e99
141 Michael John Cassidy     Coleman Street 43861e99
217 Sophie Anne Fernandes     Coleman Street 43861e99
221 Stuart John Fraser, CBE     Coleman Street 43861e99
1419 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin     Coleman Street 43861e99

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