home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

56 rows where election = 19

✎ View and edit SQL

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 party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes 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
9060 9060 423 David Lee     male   local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007407 Whyteleafe     http://www.libdems.org.uk/lee_david       https://static-candidates.democracyclub.org.uk/media/images/553ab331319151d456c24fb8.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/whyteleafedavid 2016-05-05 0 0   13102.0       PP90   0
9061 9061 1725 Jeffrey Bolter     male   local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007403 Valley                       2016-05-05 0 0   4852;13079       PP85   0
9062 9062 6774 Joe Branco     male   local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007408 Woldingham ward                       2016-05-05 0 0   32123.0       PP85   0
9063 9063 13057 Chris Botten     Male   local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007400 Portley                       2016-05-05 0 0   24965.0       PP90   0
9064 9064 13058 Robin Gwynn     male   local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007400 Portley     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Gwynn_Robin       https://static-candidates.democracyclub.org.uk/media/images/images/13058.png   profile-photo fbrc twitter profile pic https://twitter.com/Robin_Gwynn 2016-05-05 0 0   34969.0       PP52   0
9065 9065 13059 Lucy Blue McNally     female   local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007400 Portley                       2016-05-05 0 0           PP53   0
9066 9066 13060 Alex Standen     male   local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007400 Portley             https://static-candidates.democracyclub.org.uk/media/images/images/13060.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=136422743 2016-05-05 0 0           PP85   0
9067 9067 13065 Ollie Chamberlain         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007401 Queens Park                       2016-05-05 0 0           PP53   0
9068 9068 13066 Geoff Duck         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007401 Queens Park                       2016-05-05 0 0           PP52   0
9069 9069 13067 Dick Grant         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007401 Queens Park                       2016-05-05 0 0   32119.0       PP85   0
9070 9070 13068 Costel Petre         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007401 Queens Park                       2016-05-05 0 0           PP90   0
9071 9071 13080 Liz Goodwin         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007403 Valley                       2016-05-05 0 0           PP52   0
9072 9072 13081 Alun Anthony Jones     male   local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007403 Valley             https://static-candidates.democracyclub.org.uk/media/images/images/13081.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=89026793 2016-05-05 0 0           PP90   0
9073 9073 13082 Mark Jones         local.tandridge.2016-05-05 19 ynmp-party:2 Independent DIW:E05007403 Valley                       2016-05-05 0 0           ynmp-party:2   0
9074 9074 13083 Rachel Krengel         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007403 Valley                       2016-05-05 0 0           PP53   0
9075 9075 13084 Perry Chotai         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP52   0
9076 9076 13085 Martin Arthur Haley         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP85   0
9077 9077 13086 Jeremy Pursehouse         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP90   0
9078 9078 13087 Patrick Joseph Rogers         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP53   0
9079 9079 13088 Celia Caulcott     female   local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007405 Warlingham West     https://www.eastsurreylibdems.org.uk/election2018/102-candidates-2018/367-celia-caulcott-lib-dem-candidate-for-warlingham-west       https://static-candidates.democracyclub.org.uk/media/images/images/13088.png   profile-photo sjorford https://www.eastsurreylibdems.org.uk/election2018/102-candidates-2018/367-celia-caulcott-lib-dem-candidate-for-warlingham-west 2016-05-05 0 0           PP90   0
9080 9080 13089 David John Cooley         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007405 Warlingham West                       2016-05-05 0 0           PP52   0
9081 9081 13090 Jenifer Susan Dugdale         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007405 Warlingham West                       2016-05-05 0 0           PP53   0
9082 9082 13091 John Hill         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007405 Warlingham West                       2016-05-05 0 0           PP85   0
9083 9083 13096 Sally Rebecca Eason         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007406 Westway                       2016-05-05 0 0           PP53   0
9084 9084 13097 Sarah Louise Peay         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007406 Westway                       2016-05-05 0 0           PP85   0
9085 9085 13098 James Robert Richardson         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007406 Westway                       2016-05-05 0 0           PP52   0
9086 9086 13099 Caroline Jane Warner         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007406 Westway                       2016-05-05 0 0           PP90   0
9087 9087 13100 Matthew Paul Groves         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007407 Whyteleafe                       2016-05-05 0 0           PP52   0
9088 9088 13101 Fatima Kamara         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007407 Whyteleafe                       2016-05-05 0 0           PP53   0
9089 9089 13103 Neill Simon Cooper         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007408 Woldingham ward                       2016-05-05 0 0           PP90   0
9090 9090 13104 Thomas Rowley Ebbs         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007408 Woldingham ward                       2016-05-05 0 0           PP53   0
9091 9091 13105 Keith Martin Jecks         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007408 Woldingham ward                       2016-05-05 0 0           PP52   0
9092 9092 13336 Christopher Charles Dean         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007399 Oxted South                       2016-05-05 0 0           PP85   0
9093 9093 13337 Brigid Noreen McIntosh         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007399 Oxted South                       2016-05-05 0 0           PP90   0
9094 9094 13338 Michaela Claire O'Brien         local.tandridge.2016-05-05 19 party:63 Green Party DIW:E05007399 Oxted South                       2016-05-05 0 0           PP63   0
9095 9095 13339 Liz Parker         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007399 Oxted South                       2016-05-05 0 0           PP52   0
9096 9096 13340 Katherine Elizabeth Saunders         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007399 Oxted South                       2016-05-05 0 0           PP53   0
9097 9097 13347 Gordon Charles Keymer         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007398 Oxted North and Tandridge                       2016-05-05 0 0           PP52   0
9098 9098 13348 Donald Mahon         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007398 Oxted North and Tandridge                       2016-05-05 0 0           PP53   0
9099 9099 13349 Jackie Wren         local.tandridge.2016-05-05 19 party:3978 Oxted & Limpsfield Residents Group DIW:E05007398 Oxted North and Tandridge                       2016-05-05 0 0           PP3978   0
9100 9100 13350 Graham Bailey         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007395 Harestone                       2016-05-05 0 0           PP85   0
9101 9101 13351 Anne Margaret Bell         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007395 Harestone                       2016-05-05 0 0           PP90   0
9102 9102 13352 Michael John William Cooper         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007395 Harestone                       2016-05-05 0 0           PP52   0
9103 9103 13353 John Henry Edward Watts         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007395 Harestone                       2016-05-05 0 0           PP53   0
9104 9104 13354 Eileen Ruth Blake-Thomas         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007394 Godstone                       2016-05-05 0 0           PP52   0
9105 9105 13355 Marjory Broughton         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007394 Godstone                       2016-05-05 0 0           PP85   0
9106 9106 13356 Sarah Catherine MacDonnell         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007394 Godstone                       2016-05-05 0 0           PP53   0
9107 9107 13357 Dave Wilkes     Male   local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007394 Godstone                       2016-05-05 0 0   24969.0       PP90   0
9108 9108 13358 Harry John Fitzgerald         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP52   0
9109 9109 13359 Mark Adrian Fowler         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP85   0
9110 9110 13360 Fern Warwick-Ching         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP53   0
9111 9111 13361 Judy Wilkinson         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP90   0
9112 9112 13362 Linda Ruth Baharier         local.tandridge.2016-05-05 19 party:53 Labour Party DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0   42519.0       PP53   0
9113 9113 13363 Ian Crabb         local.tandridge.2016-05-05 19 party:85 UK Independence Party (UKIP) DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0           PP85   0
9114 9114 13364 Richard Barry Fowler         local.tandridge.2016-05-05 19 party:90 Liberal Democrats DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0           PP90   0
9115 9115 13365 Debbie Vickers         local.tandridge.2016-05-05 19 party:52 Conservative and Unionist Party DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0           PP52   0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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))
Powered by Datasette · Query took 7.412ms · Data license: CC-BY-SA · Data source: Democracy Club