members
Data source: See col-scraper on GitHub
130 rows sorted by url
This data as json, CSV (advanced)
ward_id 20 ✖
- Castle Baynard 4
- Aldersgate 3
- Aldgate 3
- Bread Street 2
- Farringdon Without 2
- Cripplegate 2
- Broad Street 1
- Billingsgate 1
- Langbourn 1
- Vintry 1
- Farringdon Within 1
- Bassishaw 1
- Cornhill 1
- Cordwainer 1
- Lime Street 1
- Dowgate 1
- Bridge and Bridge Without 1
- Tower 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");