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

Data source: See col-scraper on GitHub

4 rows where ward_id = "3a2fdc7e"

View and edit SQL

Suggested facets: role


  • Cornhill · 4
id ▼ name role party ward_id url
200 Peter Gerard Dunphy     Cornhill 3a2fdc7e
232 The Revd Stephen Decatur Haines Deputy   Cornhill 3a2fdc7e
255 Robert Picton Seymour Howard Alderman   Cornhill 3a2fdc7e
402 Ian Christopher Norman Seaton     Cornhill 3a2fdc7e

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