members
Data source: See col-scraper on GitHub
28 rows where role = "Alderman"
This data as json, CSV (advanced)
id ▼ | name | role | party | ward_id | url |
---|---|---|---|---|---|
1939 | Prem Goyal | Alderman | Portsoken 03c562f9 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1939 | |
2034 | Nicholas Stephen Leland Lyons | Alderman | Tower 9a06a5f0 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=2034 | |
2186 | Susan Langley | Alderman | Aldgate 68323942 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=2186 | |
2259 | Bronek Masojada | Alderman | Billingsgate 0434a638 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=2259 |
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");