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

Data source: See col-scraper on GitHub

5 rows where ward_id = "9a06a5f0" sorted by role

View and edit SQL

Suggested facets: role


  • Tower · 5
id name role ▼ party ward_id url
158 Roger Arthur Holden Chadwick     Tower 9a06a5f0
223 Marianne Bernadette Fredericks     Tower 9a06a5f0
394 James Richard Tumbridge     Tower 9a06a5f0
1756 Anne Helen Fairweather     Tower 9a06a5f0
2034 Nicholas Stephen Leland Lyons Alderman   Tower 9a06a5f0

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