home / democracyclub

candidates

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

48 rows where election = 26

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, image_url, image_uploading_user, 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
9520 9520 4986 Shan Oakes     female   local.harrogate.2016-05-05 26 party:63 Green Party DIW:E05006240 Boroughbridge     http://yorkshireandhumber.greenparty.org.uk/candidates/shan-oakes-harrogate.html http://shanoakes.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/54c195e504fa01fd0c8356bd.png         2016-05-05 0 0   109;30712       PP63   0
9521 9521 8536 Harvey Alexander     male   local.harrogate.2016-05-05 26 party:85 UK Independence Party (UKIP) DIW:E05006270 Washburn                       2016-05-05 0 0           PP85   0
9522 9522 13886 Alan Beatham         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006261 Ribston                       2016-05-05 0 0           PP53   0
9523 9523 13887 Elizabeth Collins     female   local.harrogate.2016-05-05 26 party:63 Green Party DIW:E05006261 Ribston             https://static-candidates.democracyclub.org.uk/media/images/images/27651.png   profile-photo Danby https://harrogate.greenparty.org.uk/councillors.html 2016-05-05 0 0   27651.0       PP63   0
9524 9524 13888 Simon James Oldroyd         local.harrogate.2016-05-05 26 party:90 Liberal Democrats DIW:E05006261 Ribston                       2016-05-05 0 0           PP90   0
9525 9525 13889 Andy Paraskos         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006261 Ribston   1.0                   2016-05-05 0 0           PP52   0
9526 9526 14050 Guy Allanson         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006253 Marston Moor                       2016-05-05 0 0           PP53   0
9527 9527 14051 Tim Myatt         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006253 Marston Moor   1.0                   2016-05-05 0 0   48496.0       PP52   0
9528 9528 14993 Ian Crabbe         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006252 Lower Nidderdale                       2016-05-05 0 0           PP53   0
9529 9529 14994 Nathan Roger Hull         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006252 Lower Nidderdale   1.0                   2016-05-05 0 0           PP52   0
9530 9530 14995 Paul Geoffrey Trewhitt         local.harrogate.2016-05-05 26 party:63 Green Party DIW:E05006252 Lower Nidderdale                       2016-05-05 0 0           PP63   0
9531 9531 16092 Laura Ann Dinning         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006239 Bishop Monkton                       2016-05-05 0 0           PP53   0
9532 9532 16093 Ian Roger Galloway         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006239 Bishop Monkton   1.0                   2016-05-05 0 0           PP52   0
9533 9533 16094 Greig John Sharman     Male   local.harrogate.2016-05-05 26 party:63 Green Party DIW:E05006239 Bishop Monkton                       2016-05-05 0 0           PP63   0
9534 9534 16106 Paul Martin Burns         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006240 Boroughbridge                       2016-05-05 0 0   30707.0       PP53   0
9535 9535 16107 Hannah Gostlow         local.harrogate.2016-05-05 26 party:90 Liberal Democrats DIW:E05006240 Boroughbridge                       2016-05-05 0 0           PP90   0
9536 9536 16108 Robert Windass         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006240 Boroughbridge   1.0                   2016-05-05 0 0           PP52   0
9537 9537 16122 David Anthony Bulmer         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006241 Claro                       2016-05-05 0 0           PP53   0
9538 9538 16123 Nick Duxbury         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006241 Claro   1.0                   2016-05-05 0 0           PP52   0
9539 9539 16124 Adam Richard Harper         local.harrogate.2016-05-05 26 party:63 Green Party DIW:E05006241 Claro                       2016-05-05 0 0           PP63   0
9540 9540 16125 Emma Jane Walsh         local.harrogate.2016-05-05 26 party:90 Liberal Democrats DIW:E05006241 Claro                       2016-05-05 0 0           PP90   0
9541 9541 16133 Rio Sebastian Justin Goldhammer         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006246 Killinghall                       2016-05-05 0 0           PP53   0
9542 9542 16134 Michael Harrison         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006246 Killinghall   1.0                   2016-05-05 0 0   46895.0       PP52   0
9543 9543 16135 Kenn Hart         local.harrogate.2016-05-05 26 party:85 UK Independence Party (UKIP) DIW:E05006246 Killinghall                       2016-05-05 0 0           PP85   0
9544 9544 16136 Bill Hoult         local.harrogate.2016-05-05 26 party:90 Liberal Democrats DIW:E05006246 Killinghall                       2016-05-05 0 0           PP90   0
9545 9545 16142 Margaret Edna Atkinson     female   local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006247 Kirkby Malzeard   1.0                   2016-05-05 0 0           PP52   0
9546 9546 16143 Vivienne Graham         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006247 Kirkby Malzeard                       2016-05-05 0 0           PP53   0
9547 9547 16148 Christine Elsie Brackley         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006254 Mashamshire                       2016-05-05 0 0           PP53   0
9548 9548 16149 Nigel Simms         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006254 Mashamshire   1.0                   2016-05-05 0 0           PP52   0
9549 9549 16154 Nick Brown         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006255 Newby   1.0                   2016-05-05 0 0           PP52   0
9550 9550 16155 Matthew David Forth         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006255 Newby                       2016-05-05 0 0           PP53   0
9551 9551 16161 Andrew James Murday         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006257 Nidd Valley                       2016-05-05 0 0           PP53   0
9552 9552 16162 Mick Stanley         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006257 Nidd Valley                       2016-05-05 0 0           PP52   0
9553 9553 16163 Tom Watson         local.harrogate.2016-05-05 26 party:90 Liberal Democrats DIW:E05006257 Nidd Valley   1.0                   2016-05-05 0 0           PP90   0
9554 9554 16169 Kevin Brian Hawkins         local.harrogate.2016-05-05 26 party:90 Liberal Democrats DIW:E05006258 Ouseburn                       2016-05-05 0 0           PP90   0
9555 9555 16170 Ash Teague Mr       local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006258 Ouseburn   1.0                   2016-05-05 0 0           PP52   0
9556 9556 16171 Dave Wheeler         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006258 Ouseburn                       2016-05-05 0 0           PP53   0
9557 9557 16175 Stan Beer         local.harrogate.2016-05-05 26 ynmp-party:2 Independent DIW:E05006260 Pateley Bridge                       2016-05-05 0 0           ynmp-party:2   0
9558 9558 16177 Gillian Rosemary Charters         local.harrogate.2016-05-05 26 party:63 Green Party DIW:E05006260 Pateley Bridge                       2016-05-05 0 0           PP63   0
9559 9559 16178 Stanley Lumley         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006260 Pateley Bridge   1.0                   2016-05-05 0 0           PP52   0
9560 9560 16182 Shirley Patricia Fawcett         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006267 Spofforth with Lower Wharfedale   1.0                   2016-05-05 0 0           PP52   0
9561 9561 16183 Pamela Godsell         local.harrogate.2016-05-05 26 party:90 Liberal Democrats DIW:E05006267 Spofforth with Lower Wharfedale                       2016-05-05 0 0   40445.0       PP90   0
9562 9562 16184 Carol Walker         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006267 Spofforth with Lower Wharfedale                       2016-05-05 0 0           PP53   0
9563 9563 16197 Nick Murray         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006270 Washburn                       2016-05-05 0 0           PP53   0
9564 9564 16198 Christine Anne Ryder     female   local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006270 Washburn   1.0                   2016-05-05 0 0           PP52   0
9565 9565 16203 Bernard Arthur Bateman         local.harrogate.2016-05-05 26 party:52 Conservative and Unionist Party DIW:E05006271 Wathvale   1.0                   2016-05-05 0 0           PP52   0
9566 9566 16204 Alan Peter Woodhead     male 1949.0 local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006271 Wathvale             https://static-candidates.democracyclub.org.uk/media/images/images/16204.png   profile-photo yanbad13257   2016-05-05 0 0           PP53   0
9567 9567 31798 David Lionel Brackley         local.harrogate.2016-05-05 26 party:53 Labour Party DIW:E05006260 Pateley Bridge                       2016-05-05 0 0   16176.0       PP53   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.962ms · Data license: CC-BY-SA · Data source: Democracy Club