members
Data source: See col-scraper on GitHub
6 rows where role = "" and ward_id = "13e8d138"
This data as json, CSV (advanced)
id ▼ | name | role | party | ward_id | url |
---|---|---|---|---|---|
1222 | Karina Dostalova | Farringdon Within 13e8d138 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1222 | ||
1230 | Ann Holmes | Farringdon Within 13e8d138 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1230 | ||
1231 | Graeme Martyn Smith | Farringdon Within 13e8d138 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1231 | ||
1942 | Christopher Hill | Farringdon Within 13e8d138 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1942 | ||
1950 | Thomas Alexander Anderson | Farringdon Within 13e8d138 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1950 | ||
1953 | Matthew Bell | Farringdon Within 13e8d138 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1953 |
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");