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

Data source: See col-scraper on GitHub

7 rows where ward_id = "c1386831" sorted by name

View and edit SQL

Suggested facets: role


  • Bishopsgate · 7
id name ▼ role party ward_id url
1945 Andrew Paul Mayer     Bishopsgate c1386831
2058 Benjamin Daniel Murphy     Bishopsgate c1386831
2104 Shravan Jashvantrai Joshi     Bishopsgate c1386831
151 Simon D'Olier Duckworth     Bishopsgate c1386831
1592 The Rt Hon the Baroness Patricia Scotland of Asthal, QC Alderman   Bishopsgate c1386831
1213 Tom Sleigh Deputy   Bishopsgate c1386831
263 Wendy Hyde Deputy   Bishopsgate c1386831

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