members
Data source: See col-scraper on GitHub
130 rows
This data as json, CSV (advanced)
ward_id 16 ✖
- Portsoken 3
- Farringdon Within 3
- Farringdon Without 3
- Bishopsgate 3
- Billingsgate 2
- Aldersgate 2
- Castle Baynard 2
- Cordwainer 2
- Aldgate 2
- Cripplegate 2
- Vintry 1
- Lime Street 1
- Cheap 1
- Bridge and Bridge Without 1
- Tower 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");