members
Data source: See col-scraper on GitHub
7 rows where ward_id = "286f7f31" sorted by id descending
This data as json, CSV (advanced)
Suggested facets: role
id ▲ | name | role | party | ward_id | url |
---|---|---|---|---|---|
1956 | Richard Peter Crossan | Aldersgate 286f7f31 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1956 | ||
1952 | Adrian Mark Bastow | Aldersgate 286f7f31 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1952 | ||
1227 | Randall Keith Anderson | Aldersgate 286f7f31 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1227 | ||
382 | Joyce Carruthers Nash | Deputy | Aldersgate 286f7f31 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=382 | |
370 | Jeremy Mayhew | Aldersgate 286f7f31 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=370 | ||
363 | Barbara Patricia Newman | Aldersgate 286f7f31 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=363 | ||
133 | Nicholas Anstee | Alderman | Aldersgate 286f7f31 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=133 |
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");