home / democracyclub

candidates

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

114 rows where election = 77

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, image_url, image_copyright, 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
13508 13508 1452 Nick Smith Mr   male 1962-11-15 local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010790 Hartsholme       http://lincolngainsboro.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/54fb5a5eac1daeda13b59edb.png   copyright-assigned NickSmithUKIP   2016-05-05 0 0           PP85   0
13509 13509 2066 Tony Wells     male   local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010785 Birchwood                       2016-05-05 0 0           PP85   0
13510 13510 5555 Ross David Pepper     male 1986.0 local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010792 Moorland     http://www.lsnhlibdems.org.uk/ross_pepper http://www.lsnhlibdems.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5501a4a0551f41c939045335.png   profile-photo artesea From Facebook https://m.facebook.com/photo.php?fbid=10155273723395704&id=755900703&set=a.10150274732560704.523107.755900703&source=11 2016-05-05 0 0   17504.0       PP90   0
13511 13511 14057 Graham Bratby         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP52   0
13512 13512 14058 Kathleen Emma Brothwell         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010784 Abbey   1.0                   2016-05-05 0 0           PP53   0
13513 13513 14059 Michael Edward Brown         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010784 Abbey                       2016-05-05 0 0           PP90   0
13514 13514 14060 Chris Butler         local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010784 Abbey                       2016-05-05 0 0           PP85   0
13515 13515 14061 Douglas Vincent Collison         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP52   0
13516 13516 14062 Gavyn Graham         local.city-of-lincoln.2016-05-05 77 party:804 Trade Unionist and Socialist Coalition DIW:E05010784 Abbey                       2016-05-05 0 0           PP804   0
13517 13517 14063 Jac Green         local.city-of-lincoln.2016-05-05 77 party:804 Trade Unionist and Socialist Coalition DIW:E05010784 Abbey                       2016-05-05 0 0           PP804   0
13518 13518 14064 Caleb Joseph Smith Harris         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP52   0
13519 13519 14065 Nick Parker         local.city-of-lincoln.2016-05-05 77 party:804 Trade Unionist and Socialist Coalition DIW:E05010784 Abbey                       2016-05-05 0 0           PP804   0
13520 13520 14066 Clare Smalley         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010784 Abbey                       2016-05-05 0 0           PP90   0
13521 13521 14067 Fay Smith         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010784 Abbey   1.0                   2016-05-05 0 0           PP53   0
13522 13522 14068 Peter John West         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010784 Abbey   1.0                   2016-05-05 0 0           PP53   0
13523 13523 14069 Kenneth George Yates         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP63   0
13524 13524 17419 Morgan Fae Aran         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010785 Birchwood                       2016-05-05 0 0   25624.0       PP90   0
13525 13525 17420 Jenine Emilie Butroid         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010785 Birchwood                       2016-05-05 0 0           PP52   0
13526 13526 17421 David Denman         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010785 Birchwood                       2016-05-05 0 0           PP52   0
13527 13527 17422 Paul Alan Gowen         local.city-of-lincoln.2016-05-05 77 joint-party:53-119 Labour and Co-operative Party DIW:E05010785 Birchwood   1.0                   2016-05-05 0 0           joint-party:53-119   0
13528 13528 17423 Anthony John Gray         local.city-of-lincoln.2016-05-05 77 joint-party:53-119 Labour and Co-operative Party DIW:E05010785 Birchwood                       2016-05-05 0 0           joint-party:53-119   0
13529 13529 17424 Rosanne Christina Kirk         local.city-of-lincoln.2016-05-05 77 joint-party:53-119 Labour and Co-operative Party DIW:E05010785 Birchwood   1.0                   2016-05-05 0 0           joint-party:53-119   0
13530 13530 17425 John Anthony Radford         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010785 Birchwood                       2016-05-05 0 0   45755.0       PP63   0
13531 13531 17426 Eddie Strengiel         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010785 Birchwood   1.0                   2016-05-05 0 0           PP52   0
13532 13532 17427 Elaine Elizabeth Warde         local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010785 Birchwood                       2016-05-05 0 0           PP85   0
13533 13533 17428 Alan William Briggs         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010786 Boultham                       2016-05-05 0 0           PP52   0
13534 13534 17429 Gill Clayton-Hewson         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010786 Boultham   1.0                   2016-05-05 0 0           PP53   0
13535 13535 17430 Heather Elizabeth Cullen         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010786 Boultham                       2016-05-05 0 0           PP90   0
13536 13536 17431 Ryan Thomas Cullen         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010786 Boultham                       2016-05-05 0 0           PP90   0
13537 13537 17432 Roger Joseph Hansard         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010786 Boultham                       2016-05-05 0 0           PP52   0
13538 13538 17433 Gary Trevor Hewson         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010786 Boultham   1.0                   2016-05-05 0 0           PP53   0
13539 13539 17434 Hannah Poppy Smith     female   local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010786 Boultham                       2016-05-05 0 0           PP85   0
13540 13540 17435 Ralph Toofany         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010786 Boultham   1.0                   2016-05-05 0 0           PP53   0
13541 13541 17436 Caroline Wilson         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010786 Boultham                       2016-05-05 0 0           PP52   0
13542 13542 17437 Matthew Fido     Male 1993-01-26 local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010787 Carholme             https://static-candidates.democracyclub.org.uk/media/images/images/17437.png   profile-photo matthew4   2016-05-05 0 0           PP52   0
13543 13543 17438 Karen Lee     female   local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010787 Carholme   1.0 http://www.lincolnlabourparty.org.uk/karen-lee/   https://en.wikipedia.org/wiki/Karen_Lee_(politician)   https://static-candidates.democracyclub.org.uk/media/images/images/17438_88idLbJ.png   profile-photo nick2   2016-05-05 0 0           PP53   0
13544 13544 17439 Ben Loryman     male   local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010787 Carholme     https://my.greenparty.org.uk/candidates/106046       https://static-candidates.democracyclub.org.uk/media/images/images/17439.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1165771298 2016-05-05 0 0           PP63   0
13545 13545 17440 Neil McElhinney Murray         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010787 Carholme   1.0                   2016-05-05 0 0           PP53   0
13546 13546 17441 Christopher Padley         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP63   0
13547 13547 17442 Katya Roures Salvador         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP52   0
13548 13548 17443 Charles William Shaw         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010787 Carholme                       2016-05-05 0 0           PP90   0
13549 13549 17444 David Vincent Smith         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP52   0
13550 13550 17445 Tony Speakman         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010787 Carholme   1.0                   2016-05-05 0 0           PP53   0
13551 13551 17446 Nicola Watson         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP63   0
13552 13552 17447 Rod Archer         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010788 Castle                       2016-05-05 0 0           PP52   0
13553 13553 17448 Malcolm Roger Barham         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010788 Castle                       2016-05-05 0 0           PP52   0
13554 13554 17449 Jim Hanrahan         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010788 Castle   1.0                   2016-05-05 0 0           PP53   0
13555 13555 17450 Donald James Nannestad         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010788 Castle   1.0                   2016-05-05 0 0           PP53   0
13556 13556 17451 Daphne Alexandra Shaw         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010788 Castle                       2016-05-05 0 0           PP90   0
13557 13557 17452 David Frank Warde         local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010788 Castle                       2016-05-05 0 0           PP85   0
13558 13558 17453 Loraine Karen Woolley         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010788 Castle   1.0                   2016-05-05 0 0           PP53   0
13559 13559 17454 David Wright         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010788 Castle                       2016-05-05 0 0           PP52   0
13560 13560 17455 Jamie Luke Bartch         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP52   0
13561 13561 17456 Andrew Peter Bradley         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP52   0
13562 13562 17457 Norman Haigh         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP63   0
13563 13563 17458 Adam Jacob Holman         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP63   0
13564 13564 17459 Jackie Lisa Kirk         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010789 Glebe   1.0                   2016-05-05 0 0           PP53   0
13565 13565 17460 Stephen Peter Lonsdale         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010789 Glebe                       2016-05-05 0 0           PP90   0
13566 13566 17461 Keri Lowe         local.city-of-lincoln.2016-05-05 77 party:804 Trade Unionist and Socialist Coalition DIW:E05010789 Glebe                       2016-05-05 0 0           PP804   0
13567 13567 17462 Fiona McKenna     female   local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010789 Glebe     https://my.greenparty.org.uk/candidates/106183       https://static-candidates.democracyclub.org.uk/media/images/images/17462.png   profile-photo J https://my.greenparty.org.uk/candidates/106183 2016-05-05 0 0           PP63   0
13568 13568 17463 Peter Francis McNeill         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP52   0
13569 13569 17464 Ric Metcalfe         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010789 Glebe   1.0                   2016-05-05 0 0           PP53   0
13570 13570 17465 Patrick Joseph Vaughan         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010789 Glebe   1.0                   2016-05-05 0 0           PP53   0
13571 13571 17466 Biff Bean         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010790 Hartsholme   1.0                   2016-05-05 0 0           PP53   0
13572 13572 17467 Adelle Ellis         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP53   0
13573 13573 17468 David Anthony Gaskell         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP90   0
13574 13574 17469 Ron Hills         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010790 Hartsholme   1.0                   2016-05-05 0 0           PP52   0
13575 13575 17470 Mervyn Keith Hobden         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP90   0
13576 13576 17471 Andy Kerry         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010790 Hartsholme   1.0                   2016-05-05 0 0           PP52   0
13577 13577 17472 Liz Massey         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP53   0
13578 13578 17473 Jeff McGeachie         local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP85   0
13579 13579 17474 Angela Jane Porter         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP63   0
13580 13580 17475 Marika Susan Riddick         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP52   0
13581 13581 17476 Nicola Jane Smith     female   local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP85   0
13582 13582 17477 Peaceful Warrior         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP63   0
13583 13583 17478 Yvonne Bodger         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010791 Minster   1.0                   2016-05-05 0 0           PP52   0
13584 13584 17479 Dave Callow         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010791 Minster                       2016-05-05 0 0           PP53   0
13585 13585 17480 James Robert Easter         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010791 Minster                       2016-05-05 0 0           PP90   0
13586 13586 17481 Tony Plato Higgs         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010791 Minster                       2016-05-05 0 0           PP52   0
13587 13587 17482 Liz Maxwell         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010791 Minster   1.0                   2016-05-05 0 0           PP53   0
13588 13588 17483 Nicole Danielle Pouncey Mrs   Female 1986-07-12 local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010791 Minster                       2016-05-05 0 0           PP90   0
13589 13589 17484 Christopher Edward Reid         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010791 Minster                       2016-05-05 0 0           PP52   0
13590 13590 17485 Naomi Tweddle         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010791 Minster   1.0                   2016-05-05 0 0           PP53   0
13591 13591 17496 Bob Bushell         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010792 Moorland   1.0                   2016-05-05 0 0           PP53   0
13592 13592 17497 Geoff Ellis         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010792 Moorland   1.0                   2016-05-05 0 0           PP53   0
13593 13593 17498 Kevin John Harrington     male   local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010792 Moorland                       2016-05-05 0 0           PP85   0
13594 13594 17499 David Graham Kerry         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010792 Moorland                       2016-05-05 0 0           PP52   0
13595 13595 17500 Sharon Dawn Longthorne         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010792 Moorland                       2016-05-05 0 0           PP52   0
13596 13596 17501 Adrianna McNulty         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010792 Moorland   1.0                   2016-05-05 0 0           PP53   0
13597 13597 17502 Vasos Stavros Melides         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010792 Moorland                       2016-05-05 0 0           PP52   0
13598 13598 17503 Lynn Joan Pepper         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010792 Moorland                       2016-05-05 0 0           PP90   0
13599 13599 17510 Roly Bunce         local.city-of-lincoln.2016-05-05 77 party:85 UK Independence Party (UKIP) DIW:E05010793 Park                       2016-05-05 0 0           PP85   0
13600 13600 17511 Chris Burke         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010793 Park   1.0                   2016-05-05 0 0           PP53   0
13601 13601 17512 Sue Burke         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010793 Park   1.0                   2016-05-05 0 0           PP53   0
13602 13602 17513 Richard David Butroid     male   local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010793 Park                       2016-05-05 0 0   45732.0       PP52   0
13603 13603 17514 Natasha Seeta Chapman         local.city-of-lincoln.2016-05-05 77 party:90 Liberal Democrats DIW:E05010793 Park                       2016-05-05 0 0           PP90   0
13604 13604 17515 Lauren Robin Finka         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010793 Park                       2016-05-05 0 0           PP63   0
13605 13605 17516 Sally Anne Horscroft         local.city-of-lincoln.2016-05-05 77 party:63 Green Party DIW:E05010793 Park                       2016-05-05 0 0           PP63   0
13606 13606 17517 Janusz Jerzy Kala         local.city-of-lincoln.2016-05-05 77 party:52 Conservative and Unionist Party DIW:E05010793 Park                       2016-05-05 0 0           PP52   0
13607 13607 17518 Helena Mavis Mair         local.city-of-lincoln.2016-05-05 77 party:53 Labour Party DIW:E05010793 Park   1.0                   2016-05-05 0 0   30032.0       PP53   0

Next page

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 10.721ms · Data license: CC-BY-SA · Data source: Democracy Club