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

Data source: See col-scraper on GitHub

7 rows where ward_id = 68323942 sorted by name

View and edit SQL

Suggested facets: role


  • Aldgate · 7
id name ▼ role party ward_id url
1946 Andrien Gereith Dominic Meyers     Aldgate 68323942
1224 Dhruv Patel     Aldgate 68323942
128 Douglas Barrow     Aldgate 68323942
380 Hugh Fenton Morris Deputy   Aldgate 68323942
511 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA Alderman   Aldgate 68323942
2186 Susan Langley Alderman   Aldgate 68323942
381 Sylvia Doreen Moys     Aldgate 68323942

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