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

Data source: See col-scraper on GitHub

130 rows

View and edit SQL

id ▼ name role party ward_id url
1937 Jason Paul Pritchard     Portsoken 03c562f9
1938 Ruby Sayed     Farringdon Without 2b5454aa
1939 Prem Goyal Alderman   Portsoken 03c562f9
1940 Caroline Wilma Haines     Queenhithe fd77f10c
1941 Oliver Sells QC     Farringdon Without 2b5454aa
1942 Christopher Hill     Farringdon Within 13e8d138
1943 Angus Knowles-Cutler     Castle Baynard 31037861
1944 Tim Levene     Bridge and Bridge Without 70fbd1ea
1945 Andrew Paul Mayer     Bishopsgate c1386831
1946 Andrien Gereith Dominic Meyers     Aldgate 68323942
1947 Caroline Kordai Addy     Farringdon Without 2b5454aa
1948 Rehana Banu Ameer     Vintry 0bcd8436
1949 Munsur Ali     Portsoken 03c562f9
1950 Thomas Alexander Anderson     Farringdon Within 13e8d138
1951 Alexander Robertson Martin Barr     Cordwainer 3aa4ba2e
1952 Adrian Mark Bastow     Aldersgate 286f7f31
1953 Matthew Bell     Farringdon Within 13e8d138
1954 Tijs Broeke     Cheap 70a9d190
1955 Thomas Cowley Clementi     Lime Street 675b7bdd
1956 Richard Peter Crossan     Aldersgate 286f7f31
1957 Mary Durcan     Cripplegate e5a9d3d8
1958 Mark Bostock     Cripplegate e5a9d3d8
2034 Nicholas Stephen Leland Lyons Alderman   Tower 9a06a5f0
2058 Benjamin Daniel Murphy     Bishopsgate c1386831
2104 Shravan Jashvantrai Joshi     Bishopsgate c1386831
2105 John Petrie     Billingsgate 0434a638
2186 Susan Langley Alderman   Aldgate 68323942
2224 Natasha Maria Cabrera Lloyd-Owen     Castle Baynard 31037861
2259 Bronek Masojada Alderman   Billingsgate 0434a638
2316 Tracey Graham     Cordwainer 3aa4ba2e

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