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

Data source: See col-scraper on GitHub

3 rows where ward_id = "70fbd1ea" sorted by name

View and edit SQL


  • Bridge and Bridge Without · 3
id name ▼ role party ward_id url
1666 Keith David Forbes Bottomley Deputy   Bridge and Bridge Without 70fbd1ea
399 Sir Alan Colin Drake Yarrow Alderman   Bridge and Bridge Without 70fbd1ea
1944 Tim Levene     Bridge and Bridge Without 70fbd1ea

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