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

Data source: See col-scraper on GitHub

9 rows where ward_id = "e5a9d3d8" sorted by name

View and edit SQL

Suggested facets: role


  • Cripplegate · 9
id name ▼ role party ward_id url
231 David Andrew Graves Alderman   Cripplegate e5a9d3d8
137 David John Bradshaw Deputy   Cripplegate e5a9d3d8
392 John Tomlinson Deputy   Cripplegate e5a9d3d8
1958 Mark Bostock     Cripplegate e5a9d3d8
1957 Mary Durcan     Cripplegate e5a9d3d8
362 Stephen Douglas Quilter     Cripplegate e5a9d3d8
1934 Susan Jane Pearson     Cripplegate e5a9d3d8
287 Vivienne Littlechild     Cripplegate e5a9d3d8
1936 William Pimlott     Cripplegate e5a9d3d8

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