members
Data source: See col-scraper on GitHub
77 rows where role = ""
This data as json, CSV (advanced)
ward_id 25 ✖
- Farringdon Without 8
- Castle Baynard 7
- Farringdon Within 6
- Cripplegate 6
- Aldersgate 5
- Coleman Street 5
- Cordwainer 4
- Aldgate 4
- Tower 4
- Bishopsgate 4
- Broad Street 3
- Portsoken 3
- Lime Street 3
- Langbourn 2
- Cornhill 2
- Cheap 2
- Billingsgate 1
- Vintry 1
- Bread Street 1
- Bassishaw 1
- Dowgate 1
- Bridge and Bridge Without 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");