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

Data source: See col-scraper on GitHub

3 rows where ward_id = "15362cc1" sorted by id descending

View and edit SQL


  • Bread Street · 3
id ▲ name role party ward_id url
1202 William Anthony Bowater Russell Alderman   Bread Street 15362cc1
383 Dr Giles Robert Evelyn Shilson Deputy   Bread Street 15362cc1
291 Oliver Arthur Wynlayne Lodge     Bread Street 15362cc1

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