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

Data source: See col-scraper on GitHub

7 rows where ward_id = "286f7f31" sorted by name

View and edit SQL

Suggested facets: role


  • Aldersgate · 7
id name ▼ role party ward_id url
1952 Adrian Mark Bastow     Aldersgate 286f7f31
363 Barbara Patricia Newman     Aldersgate 286f7f31
370 Jeremy Mayhew     Aldersgate 286f7f31
382 Joyce Carruthers Nash Deputy   Aldersgate 286f7f31
133 Nicholas Anstee Alderman   Aldersgate 286f7f31
1227 Randall Keith Anderson     Aldersgate 286f7f31
1956 Richard Peter Crossan     Aldersgate 286f7f31

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