members
Data source: See col-scraper on GitHub
1 row where role = "Alderman" and ward_id = "c1386831" sorted by party
This data as json, CSV (advanced)
id | name | role | party ▼ | ward_id | url |
---|---|---|---|---|---|
1592 | The Rt Hon the Baroness Patricia Scotland of Asthal, QC | Alderman | Bishopsgate c1386831 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1592 |
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");