Data license: CC-BY-SA · Data source: Democracy Club
This data as JSON, CSV (advanced)
Suggested facets: gender, party_id, party_name, post_id, post_label, email, twitter_username, party_ppc_page_url, image_url, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id
| Link | rowid | id | name | honorific_prefix | honorific_suffix | gender | birth_date | election | party_id | party_name | post_id | post_label | mapit_url | elected | twitter_username | facebook_page_url | party_ppc_page_url | facebook_personal_url | homepage_url | wikipedia_url | linkedin_url | image_url | proxy_image_url_template | image_copyright | image_uploading_user | image_uploading_user_notes | twitter_user_id | election_date | election_current | party_lists_in_use | party_list_position | old_person_ids | gss_code | parlparse_id | theyworkforyou_url | party_ec_id | favourite_biscuits | cancelled_poll | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8203 | 8203 | 19601 | Kate Bramson | local.southwark.2016-05-05 4 | party:52 | Conservative and Unionist Party | LBW:E05000538 | College ward | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 8204 | 8204 | 19602 | Brigid Gardner | Ms | Female | local.southwark.2016-05-05 4 | party:90 | Liberal Democrats | LBW:E05000538 | College ward | http://www.southwark-libdems.org.uk/dulwich_village_candidates | https://static-candidates.democracyclub.org.uk/media/images/images/36112.png | profile-photo | JackyC123 | The photo is on the candidate's website | 2016-05-05 | 0 | 0 | 36112.0 | PP90 | 0 | ||||||||||||||||||
| 8205 | 8205 | 19603 | Denis Pougin | local.southwark.2016-05-05 4 | party:2137 | All People's Party | LBW:E05000538 | College ward | 2016-05-05 | 0 | 0 | PP2137 | 0 | ||||||||||||||||||||||||||
| 8206 | 8206 | 19604 | Toby Prescott | local.southwark.2016-05-05 4 | party:85 | UK Independence Party (UKIP) | LBW:E05000538 | College ward | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 8207 | 8207 | 19605 | Dale Leslie Rapley | male | local.southwark.2016-05-05 4 | party:63 | Green Party | LBW:E05000538 | College ward | dalerapley | https://static-candidates.democracyclub.org.uk/media/images/images/19605.png | profile-photo | bookshelf | 475399845 | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||
| 8208 | 8208 | 19611 | Siobhan Gite Aarons | local.southwark.2016-05-05 4 | party:52 | Conservative and Unionist Party | LBW:E05000544 | Newington ward | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 8209 | 8209 | 19612 | Terry Adewale | local.southwark.2016-05-05 4 | party:2137 | All People's Party | LBW:E05000544 | Newington ward | 2016-05-05 | 0 | 0 | PP2137 | 0 | ||||||||||||||||||||||||||
| 8210 | 8210 | 19613 | Michelle Deborah Baharier | local.southwark.2016-05-05 4 | ynmp-party:2 | Independent | LBW:E05000544 | Newington ward | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | ||||||||||||||||||||||||||
| 8211 | 8211 | 19614 | James Coldwell | male | local.southwark.2016-05-05 4 | party:53 | Labour Party | LBW:E05000544 | Newington ward | james.coldwell@southwark.gov.uk | JamesColdwellUK | http://www.southwarklabour.co.uk/2018wards/newington.aspx | https://static-candidates.democracyclub.org.uk/media/images/images/19614.png | profile-photo | roy2 | Photo is from Southwark Labour party website - http://www.southwarklabour.co.uk/2018wards/newington.aspx | 4250485828 | 2016-05-05 | 0 | 0 | PP53 | 0 | |||||||||||||||||
| 8212 | 8212 | 19615 | Nick Hooper | local.southwark.2016-05-05 4 | party:63 | Green Party | LBW:E05000544 | Newington ward | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 8213 | 8213 | 19616 | Martin Shapland | local.southwark.2016-05-05 4 | party:90 | Liberal Democrats | LBW:E05000544 | Newington ward | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 8214 | 8214 | 19617 | Gawain Howard Wilkinson Towler | local.southwark.2016-05-05 4 | party:85 | UK Independence Party (UKIP) | LBW:E05000544 | Newington ward | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 8215 | 8215 | 48117 | Catherine Rose | local.southwark.2016-05-05 4 | party:53 | Labour Party | LBW:E05000538 | College ward | catherine.rose@southwark.gov.uk | 2016-05-05 | 0 | 0 | 19606.0 | PP53 | 0 |
JSON shape: default, array, newline-delimited
CREATE TABLE "candidates" (
"id" INTEGER,
"name" TEXT,
"honorific_prefix" REAL,
"honorific_suffix" REAL,
"gender" TEXT,
"birth_date" REAL,
"election" INTEGER,
"party_id" TEXT,
"party_name" TEXT,
"post_id" TEXT,
"post_label" TEXT,
"mapit_url" INTEGER,
"elected" REAL,
"email" TEXT,
"twitter_username" REAL,
"facebook_page_url" REAL,
"party_ppc_page_url" REAL,
"facebook_personal_url" REAL,
"homepage_url" REAL,
"wikipedia_url" REAL,
"linkedin_url" REAL,
"image_url" REAL,
"proxy_image_url_template" INTEGER,
"image_copyright" REAL,
"image_uploading_user" REAL,
"image_uploading_user_notes" REAL,
"twitter_user_id" INTEGER,
"election_date" TEXT,
"election_current" INTEGER,
"party_lists_in_use" INTEGER,
"party_list_position" INTEGER,
"old_person_ids" REAL,
"gss_code" INTEGER,
"parlparse_id" REAL,
"theyworkforyou_url" REAL,
"party_ec_id" TEXT,
"favourite_biscuits" REAL,
"cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))