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

Data source: See col-scraper on GitHub

5 rows where ward_id = "03c562f9" sorted by name

View and edit SQL

Suggested facets: role


  • Portsoken · 5
id name ▼ role party ward_id url
265 Henry Llewellyn Michael Jones Deputy   Portsoken 03c562f9
1937 Jason Paul Pritchard     Portsoken 03c562f9
220 John William Fletcher     Portsoken 03c562f9
1949 Munsur Ali     Portsoken 03c562f9
1939 Prem Goyal Alderman   Portsoken 03c562f9

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