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

Data source: See col-scraper on GitHub

5 rows where ward_id = "3aa4ba2e" sorted by id

View and edit SQL

Suggested facets: role


  • Cordwainer · 5
id ▼ name role party ward_id url
136 Sir Mark Boleat     Cordwainer 3aa4ba2e
226 Sir Roger Gifford Alderman   Cordwainer 3aa4ba2e
385 Sir Michael Snyder     Cordwainer 3aa4ba2e
1951 Alexander Robertson Martin Barr     Cordwainer 3aa4ba2e
2316 Tracey Graham     Cordwainer 3aa4ba2e

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