home / democracyclub

candidates

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

80 rows where election = 5

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, homepage_url, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id, favourite_biscuits

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
8216 8216 2141 Ian Womersley     male   local.wakefield.2016-05-05 5 ynmp-party:2 Independent MTW:E05001450 Hemsworth                       2016-05-05 0 0           ynmp-party:2   0
8217 8217 5269 Steve Ashton     male   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001448 Crofton, Ryhill and Walton     http://www.ukipwakefield.co.uk/ukip12_027.htm       https://static-candidates.democracyclub.org.uk/media/images/5526922d59bbc5c063445bbb.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-f-k.html 2016-05-05 0 0           PP85   0
8218 8218 5831 Nathan Garbutt     Male 1984-11-24 local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001444 Ackworth, North Elmsall and Upton       http://www.nathangarbutt.com/     https://static-candidates.democracyclub.org.uk/media/images/5529215cb6a860ed1648be4c.png   profile-photo jack4   2016-05-05 0 0   35332.0       PP85   0
8219 8219 6189 Mick Griffiths     male   local.wakefield.2016-05-05 5 party:804 Trade Unionist and Socialist Coalition MTW:E05001459 Wakefield East     http://tusc2015.com/mick-griffiths-for-wakefield2/       https://static-candidates.democracyclub.org.uk/media/images/554795efa57e7ec942ad8e2b.png   profile-photo andylolz From party PPC page: http://tusc2015.com/mick-griffiths-for-wakefield2/ 2016-05-05 0 0           PP804   0
8220 8220 6642 Martin Roberts     male 1986-12-11 local.wakefield.2016-05-05 5 party:2120 Yorkshire First MTW:E05001444 Ackworth, North Elmsall and Upton             https://static-candidates.democracyclub.org.uk/media/images/images/6642.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   13968.0       PP2120   0
8221 8221 6833 Arnie Craven Mr   male   local.wakefield.2016-05-05 5 party:2120 Yorkshire First MTW:E05001455 Pontefract North             https://static-candidates.democracyclub.org.uk/media/images/images/6833.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP2120   0
8222 8222 7682 Joshua Spencer Mr   Male 1994-04-12 local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001455 Pontefract North                       2016-05-05 0 0   35841.0       PP85 Bourbon creams 0
8223 8223 7685 Lewis Thompson Mr   Male 1993.0 local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001452 Knottingley       https://www.ukip-npc.org     https://static-candidates.democracyclub.org.uk/media/images/images/7685_SzOteyl.png   public-domain Lewishaloboy   2016-05-05 0 0           PP85 Rich tea 0
8224 8224 8547 Dawn Lumb     female   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001447 Castleford Central and Glasshoughton                       2016-05-05 0 0           PP85   0
8225 8225 8548 Penny Ashton     female   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001450 Hemsworth                       2016-05-05 0 0           PP85   0
8226 8226 8549 Neil David Coleman     male   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001451 Horbury and South Ossett                       2016-05-05 0 0           PP85   0
8227 8227 8550 Jonathan Andrew Cook     male   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001454 Ossett                       2016-05-05 0 0           PP85   0
8228 8228 8551 James Johnston     male   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001458 Stanley and Outwood East                       2016-05-05 0 0           PP85   0
8229 8229 8552 Keith Frank Wells     male   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001460 Wakefield North                       2016-05-05 0 0           PP85   0
8230 8230 8553 Ian Michael Sheldrake     male   local.wakefield.2016-05-05 5 party:85 UK Independence Party (UKIP) MTW:E05001464 Wrenthorpe and Outwood West                       2016-05-05 0 0           PP85   0
8231 8231 13966 Don Marshall         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001444 Ackworth, North Elmsall and Upton                       2016-05-05 0 0           PP52   0
8232 8232 13967 Steven Mark Pallett         local.wakefield.2016-05-05 5 ynmp-party:2 Independent MTW:E05001444 Ackworth, North Elmsall and Upton                       2016-05-05 0 0           ynmp-party:2   0
8233 8233 13969 Martyn Charles Ward         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001444 Ackworth, North Elmsall and Upton   1.0                   2016-05-05 0 0           PP53   0
8234 8234 14163 Brian Else         local.wakefield.2016-05-05 5 party:63 Green Party MTW:E05001463 Wakefield West                       2016-05-05 0 0           PP63   0
8235 8235 14164 Louis Kasatkin         local.wakefield.2016-05-05 5 party:804 Trade Unionist and Socialist Coalition MTW:E05001463 Wakefield West                       2016-05-05 0 0           PP804   0
8236 8236 14165 Hilary Gail Mitchell         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001463 Wakefield West   1.0                   2016-05-05 0 0           PP53   0
8237 8237 14166 Dianne Elizabeth Presha         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001463 Wakefield West                       2016-05-05 0 0           PP52   0
8238 8238 14167 Peter John Williams         local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001463 Wakefield West                       2016-05-05 0 0           PP90   0
8239 8239 14175 Ian Charles Bain         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001462 Wakefield South                       2016-05-05 0 0           PP53   0
8240 8240 14176 Daniel Mathieson Cochran         local.wakefield.2016-05-05 5 party:2120 Yorkshire First MTW:E05001462 Wakefield South                       2016-05-05 0 0           PP2120   0
8241 8241 14177 David Cameron Currie         local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001462 Wakefield South                       2016-05-05 0 0           PP90   0
8242 8242 14178 Richard Stephen Hunt         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001462 Wakefield South   1.0                   2016-05-05 0 0           PP52   0
8243 8243 14179 John Henry Sibbald         local.wakefield.2016-05-05 5 party:804 Trade Unionist and Socialist Coalition MTW:E05001462 Wakefield South                       2016-05-05 0 0           PP804   0
8244 8244 14319 Eamonn Malachy Mullins         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001452 Knottingley                       2016-05-05 0 0           PP52   0
8245 8245 14320 Graham Stokes         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001452 Knottingley   1.0                   2016-05-05 0 0           PP53   0
8246 8246 16480 Les Shaw         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001445 Airedale and Ferry Fryston   1.0                   2016-05-05 0 0           PP53   0
8247 8247 16481 Amy Louise Swift         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001445 Airedale and Ferry Fryston                       2016-05-05 0 0           PP52   0
8248 8248 16487 Peter Box         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001446 Altofts and Whitwood   1.0                   2016-05-05 0 0           PP53   0
8249 8249 16488 Steve Crookes         local.wakefield.2016-05-05 5 party:2120 Yorkshire First MTW:E05001446 Altofts and Whitwood                       2016-05-05 0 0           PP2120   0
8250 8250 16489 Anthony David Hill         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001446 Altofts and Whitwood                       2016-05-05 0 0           PP52   0
8251 8251 16490 Matthew Robert Peter Jeans         local.wakefield.2016-05-05 5 ynmp-party:2 Independent MTW:E05001446 Altofts and Whitwood                       2016-05-05 0 0           ynmp-party:2   0
8252 8252 16491 Richard Anthony Forster         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001447 Castleford Central and Glasshoughton   1.0                   2016-05-05 0 0           PP53   0
8253 8253 16492 Joanne Grace Smart         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001447 Castleford Central and Glasshoughton                       2016-05-05 0 0           PP52   0
8254 8254 16493 Tony Alexander Ayoade         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001448 Crofton, Ryhill and Walton                       2016-05-05 0 0           PP52   0
8255 8255 16494 Adam James Belcher     male   local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001448 Crofton, Ryhill and Walton             https://static-candidates.democracyclub.org.uk/media/images/images/16494.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=979055922575224832 2016-05-05 0 0           PP90   0
8256 8256 16495 Faith Heptinstall         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001448 Crofton, Ryhill and Walton   1.0                   2016-05-05 0 0           PP53   0
8257 8257 16496 Maureen Linda Tennant-King         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001449 Featherstone   1.0                   2016-05-05 0 0           PP53   0
8258 8258 16497 Rodney Lorraine Williams         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001449 Featherstone                       2016-05-05 0 0           PP52   0
8259 8259 16498 Pauline Kitching         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001450 Hemsworth   1.0                   2016-05-05 0 0           PP53   0
8260 8260 16499 John Andrew Martin         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001450 Hemsworth                       2016-05-05 0 0           PP52   0
8261 8261 16500 Darren Byford         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001451 Horbury and South Ossett   1.0                   2016-05-05 0 0           PP53   0
8262 8262 16501 Madalena Coutinho Mestre         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001451 Horbury and South Ossett                       2016-05-05 0 0           PP52   0
8263 8263 16502 Mark Andrew Goodair     Male 1971.0 local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001451 Horbury and South Ossett             https://static-candidates.democracyclub.org.uk/media/images/images/16502_enr7I3I.png   public-domain Mark Goodair   2016-05-05 0 0           PP90 Garibali 0
8264 8264 16503 Richard Hargreaves Norris         local.wakefield.2016-05-05 5 party:63 Green Party MTW:E05001451 Horbury and South Ossett                       2016-05-05 0 0           PP63   0
8265 8265 16508 Mathew Charles Gilligan         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001453 Normanton                       2016-05-05 0 0           PP52   0
8266 8266 16509 Alan Wassell         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001453 Normanton   1.0                   2016-05-05 0 0           PP53   0
8267 8267 17183 Terry Brown         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001454 Ossett                       2016-05-05 0 0           PP52   0
8268 8268 17184 Lynn Masterman         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001454 Ossett   1.0                   2016-05-05 0 0           PP53   0
8269 8269 17185 Tony Richardson         local.wakefield.2016-05-05 5 ynmp-party:2 Independent MTW:E05001454 Ossett                       2016-05-05 0 0           ynmp-party:2   0
8270 8270 17186 Tony Sargeant         local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001454 Ossett                       2016-05-05 0 0           PP90   0
8271 8271 17187 Chris Hyomes         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001455 Pontefract North                       2016-05-05 0 0           PP52   0
8272 8272 17188 Lorna Jane Malkin         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001455 Pontefract North   1.0                   2016-05-05 0 0           PP53   0
8273 8273 17199 John Gill         local.wakefield.2016-05-05 5 party:804 Trade Unionist and Socialist Coalition MTW:E05001456 Pontefract South                       2016-05-05 0 0           PP804   0
8274 8274 17200 Celia Loughran         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001456 Pontefract South   1.0                   2016-05-05 0 0           PP53   0
8275 8275 17201 Geoff Walsh         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001456 Pontefract South                       2016-05-05 0 0           PP52   0
8276 8276 17202 Dan Woodlock         local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001456 Pontefract South                       2016-05-05 0 0           PP90   0
8277 8277 17203 Michelle Louise Collins         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001457 South Elmsall and South Kirkby   1.0                   2016-05-05 0 0           PP53   0
8278 8278 17204 Chris I'Anson         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001457 South Elmsall and South Kirkby                       2016-05-05 0 0           PP52   0
8279 8279 17205 Dave Byrom         local.wakefield.2016-05-05 5 party:804 Trade Unionist and Socialist Coalition MTW:E05001458 Stanley and Outwood East                       2016-05-05 0 0           PP804   0
8280 8280 17206 Margaret Dodd         local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001458 Stanley and Outwood East                       2016-05-05 0 0           PP90   0
8281 8281 17207 Gill Laidler         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001458 Stanley and Outwood East                       2016-05-05 0 0           PP52   0
8282 8282 17208 Matthew Morley         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001458 Stanley and Outwood East   1.0                   2016-05-05 0 0           PP53   0
8283 8283 17209 Jody Paul Gabriel Mr   Male 1972.0 local.wakefield.2016-05-05 5 party:63 Green Party MTW:E05001459 Wakefield East             https://static-candidates.democracyclub.org.uk/media/images/images/17209.png   copyright-assigned Jody Gabriel   2016-05-05 0 0           PP63 Dark Chocolate Hobnob 0
8284 8284 17210 Rosaline Mary Lund         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001459 Wakefield East   1.0                   2016-05-05 0 0           PP53   0
8285 8285 17211 Richard Martin Wakefield         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001459 Wakefield East                       2016-05-05 0 0           PP52   0
8286 8286 17212 Lucy Brown     female   local.wakefield.2016-05-05 5 party:2120 Yorkshire First MTW:E05001460 Wakefield North     http://www.yorkshireparty.org.uk/candidates       https://static-candidates.democracyclub.org.uk/media/images/images/17212.png   profile-photo kdcm87 http://www.yorkshireparty.org.uk/candidates 2016-05-05 0 0           PP2120   0
8287 8287 17213 Allan Couch         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001460 Wakefield North                       2016-05-05 0 0           PP52   0
8288 8288 17214 Elizabeth Rhodes         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001460 Wakefield North   1.0                   2016-05-05 0 0           PP53   0
8289 8289 17215 Cynthia Binns         local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001461 Wakefield Rural   1.0                   2016-05-05 0 0           PP52   0
8290 8290 17216 Denis Finbarr Cronin         local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001461 Wakefield Rural                       2016-05-05 0 0           PP90   0
8291 8291 17217 Samuel Lynch         local.wakefield.2016-05-05 5 party:804 Trade Unionist and Socialist Coalition MTW:E05001461 Wakefield Rural                       2016-05-05 0 0           PP804   0
8292 8292 17218 Jayne Louise Wilby         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001461 Wakefield Rural                       2016-05-05 0 0           PP53   0
8293 8293 17219 Natasha Marie De Vere         local.wakefield.2016-05-05 5 party:90 Liberal Democrats MTW:E05001464 Wrenthorpe and Outwood West                       2016-05-05 0 0           PP90   0
8294 8294 17220 Sam Harvey     female   local.wakefield.2016-05-05 5 party:52 Conservative and Unionist Party MTW:E05001464 Wrenthorpe and Outwood West       http://www.samanthaharvey.org.uk/               2016-05-05 0 0           PP52   0
8295 8295 17221 Martyn Johnson         local.wakefield.2016-05-05 5 party:53 Labour Party MTW:E05001464 Wrenthorpe and Outwood West   1.0                   2016-05-05 0 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.827ms · Data license: CC-BY-SA · Data source: Democracy Club