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

Data source: See col-scraper on GitHub

4 rows where ward_id = 09362530 sorted by name

View and edit SQL

Suggested facets: role


  • Langbourn · 4
id name ▼ role party ward_id url
160 John Douglas Chapman     Langbourn 09362530
1212 Judith Pleasance     Langbourn 09362530
1211 Philip Woodhouse Deputy   Langbourn 09362530
397 Sir David Hugh Wootton Alderman   Langbourn 09362530

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