members
Data source: See col-scraper on GitHub
5 rows where ward_id = "70a9d190" sorted by ward_id
This data as json, CSV (advanced)
Suggested facets: role
id | name | role | party | ward_id ▼ | url |
---|---|---|---|---|---|
207 | The Lord Mountevans, Jeffrey Evans | Alderman | Cheap 70a9d190 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=207 | |
257 | Robert Charles Hughes-Penney | Alderman | Cheap 70a9d190 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=257 | |
1226 | Alastair Michael Moss | Deputy | Cheap 70a9d190 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1226 | |
1472 | Nicholas Michael Bensted-Smith | Cheap 70a9d190 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1472 | ||
1954 | Tijs Broeke | Cheap 70a9d190 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1954 |
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");