members
Data source: See col-scraper on GitHub
130 rows sorted by role
This data as json, CSV (advanced)
ward_id 22 ✖
- Bishopsgate 3
- Portsoken 2
- Billingsgate 2
- Farringdon Within 2
- Farringdon Without 2
- Aldgate 2
- Cripplegate 2
- Langbourn 1
- Vintry 1
- Bread Street 1
- Aldersgate 1
- Bassishaw 1
- Castle Baynard 1
- Cornhill 1
- Lime Street 1
- Dowgate 1
- Cheap 1
- Bridge and Bridge Without 1
- Tower 1
- Walbrook 1
- Candlewick 1
- Queenhithe 1
Advanced export
JSON shape: default, array, newline-delimited, object
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");