members
Data source: See col-scraper on GitHub
130 rows sorted by ward_id
This data as json, CSV (advanced)
ward_id 6 ✖
- Cripplegate 9
- Bishopsgate 7
- Tower 4
- Candlewick 4
- Walbrook 3
- Queenhithe 3
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");