members
Data source: See col-scraper on GitHub
7 rows where role = "" and ward_id = 31037861
This data as json, CSV (advanced)
id ▼ | name | role | party | ward_id | url |
---|---|---|---|---|---|
256 | Michael Hudson | Castle Baynard 31037861 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=256 | ||
384 | Jeremy Lewis Simons | Castle Baynard 31037861 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=384 | ||
409 | Henrika Johanna Sofia Priest | Castle Baynard 31037861 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=409 | ||
1219 | Christopher Paul Boden | Castle Baynard 31037861 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1219 | ||
1221 | Graham Packham | Castle Baynard 31037861 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1221 | ||
1943 | Angus Knowles-Cutler | Castle Baynard 31037861 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=1943 | ||
2224 | Natasha Maria Cabrera Lloyd-Owen | Castle Baynard 31037861 | http://democracy.cityoflondon.gov.uk/mgUserInfo.aspx?UID=2224 |
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");