home / democracyclub

candidates

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

109 rows where election = 23

✎ 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, 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, 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
9400 9400 1884 Bill Wakeham     male   local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002095 Southway                       2016-05-05 0 0           PP85   0
9401 9401 3461 Wendy Miller     female 1957.0 local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002087 Peverell                       2016-05-05 0 0   14228.0       PP63   0
9402 9402 5349 Louise Parker     female   local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002097 Sutton and Mount Gould     http://tusc2015.com/louise-parker-for-plymouth-moor-view/       https://static-candidates.democracyclub.org.uk/media/images/55479596a57e7ec942ad8e29.png   profile-photo andylolz From party PPC page: http://tusc2015.com/louise-parker-for-plymouth-moor-view/ 2016-05-05 0 0           PP804   0
9403 9403 8862 Fleur Olivia Stoner Ball         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002080 Devonport                       2016-05-05 0 0           PP90   0
9404 9404 14225 Peter Geoffrey Brooksbank         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002087 Peverell                       2016-05-05 0 0           PP3940   0
9405 9405 14226 Tony Carson         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002087 Peverell                       2016-05-05 0 0           PP52   0
9406 9406 14227 Jeremy Goslin         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002087 Peverell                       2016-05-05 0 0           PP53   0
9407 9407 14229 Justin Pollard         local.plymouth.2016-05-05 23 joint-party:804-2045 Left Unity - Trade Unionists and Socialists UTW:E05002087 Peverell                       2016-05-05 0 0           joint-party:804-2045   0
9408 9408 14230 Charlotte Jane Radmore         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002087 Peverell                       2016-05-05 0 0           PP90   0
9409 9409 14614 Richard Bray         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002086 Moor View                       2016-05-05 0 0           PP90   0
9410 9410 14615 Chris Mavin         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002086 Moor View                       2016-05-05 0 0           PP53   0
9411 9411 14616 Philip Partridge         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002086 Moor View                       2016-05-05 0 0           PP85   0
9412 9412 14617 Bethan Roberts         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002086 Moor View                       2016-05-05 0 0           PP52   0
9413 9413 14618 Arthur Nicoll Watson         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002086 Moor View                       2016-05-05 0 0           PP3940   0
9414 9414 16707 Richard Ball         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002079 Compton                       2016-05-05 0 0           PP52   0
9415 9415 16708 Nigel Buckley         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002079 Compton                       2016-05-05 0 0           PP804   0
9416 9416 16709 Steven Guy         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002079 Compton                       2016-05-05 0 0           PP90   0
9417 9417 16710 John Petrie         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002079 Compton                       2016-05-05 0 0           PP53   0
9418 9418 16711 Grace Stickland         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002079 Compton                       2016-05-05 0 0           PP3940   0
9419 9419 16712 Colin Trier         local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002079 Compton                       2016-05-05 0 0           PP63   0
9420 9420 17575 Charlotte Bladen         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002078 Budshead                       2016-05-05 0 0           PP52   0
9421 9421 17576 Gordon Charles Miller         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002078 Budshead                       2016-05-05 0 0           PP85   0
9422 9422 17577 Roger James Mitchell         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002078 Budshead                       2016-05-05 0 0           PP90   0
9423 9423 17578 Joshua George Pope     male 1997-12-08 local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002078 Budshead       https://www.joshuapope.org/     https://static-candidates.democracyclub.org.uk/media/images/images/17578.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63 Pink Wafers 0
9424 9424 17579 Jon Taylor     male   local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002078 Budshead             https://static-candidates.democracyclub.org.uk/media/images/images/17579.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=816238800569507842 2016-05-05 0 0           joint-party:53-119   0
9425 9425 17580 Andrew White         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002078 Budshead                       2016-05-05 0 0           PP804   0
9426 9426 17581 Sandy Borthwick         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002080 Devonport                       2016-05-05 0 0           PP52   0
9427 9427 17582 Michael Ellison         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002080 Devonport                       2016-05-05 0 0           PP85   0
9428 9428 17583 Simon Gomery         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002080 Devonport                       2016-05-05 0 0           PP804   0
9429 9429 17584 Andrew Robert Pratt         local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002080 Devonport                       2016-05-05 0 0           PP63   0
9430 9430 17585 Kate Taylor         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002080 Devonport                       2016-05-05 0 0           PP53   0
9431 9431 17586 Scott Aiden Wardle         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002080 Devonport                       2016-05-05 0 0           PP3940   0
9432 9432 17587 George Davis         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP52   0
9433 9433 17588 Rafiqul Mazed Haque         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP90   0
9434 9434 17589 Hannah Marie Lewis         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP804   0
9435 9435 17590 Terry Luscombe         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP3940   0
9436 9436 17591 Brian Vincent         local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           joint-party:53-119   0
9437 9437 17592 Heath Cook         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP52   0
9438 9438 17593 Hugh Scott Davies         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP85   0
9439 9439 17594 Sam Down         local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP63   0
9440 9440 17595 Lesley Duncan         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP804   0
9441 9441 17596 Paul Charles McNamara     male   local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002083 Eggbuckland                       2016-05-05 0 0           joint-party:53-119   0
9442 9442 17597 Richard John Simpson         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP90   0
9443 9443 17598 Chris Treise         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP3940   0
9444 9444 17599 Ryan John Aldred         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002084 Ham                       2016-05-05 0 0           PP804   0
9445 9445 17600 Stuart Bernard Charles         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002084 Ham                       2016-05-05 0 0           PP85   0
9446 9446 17601 Matthew Charles Radmore         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002084 Ham                       2016-05-05 0 0           PP90   0
9447 9447 17602 Dean Seddon         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002084 Ham                       2016-05-05 0 0           PP52   0
9448 9448 17603 Jason Shopland Mr   male 1972-05-30 local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002084 Ham     http://www.forplymouth.co.uk/the-team/ http://www.forplymouth.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/17603.png   copyright-assigned Jannerpolitics It is me 2016-05-05 0 0           PP3940 Digestive 0
9449 9449 17604 Tina Tuohy         local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002084 Ham                       2016-05-05 0 0           joint-party:53-119   0
9450 9450 17615 Nikki Bale         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP85   0
9451 9451 17616 Carl Evans         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP3940   0
9452 9452 17617 Joshua Gray         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP804   0
9453 9453 17618 Dylan Harry Morris         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP90   0
9454 9454 17619 Pete Smith         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP53   0
9455 9455 17620 Sally Walker         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP52   0
9456 9456 17628 Jonathan Brian Frost         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP85   0
9457 9457 17629 Samantha Jane Leaves         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP52   0
9458 9458 17630 Connor Smart         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP53   0
9459 9459 17631 Teresa Stuart         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP804   0
9460 9460 17632 Louise Caroline Alldridge         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP804   0
9461 9461 17633 Ian Patrick Darcy         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP52   0
9462 9462 17634 Peter Endean         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP3940   0
9463 9463 17635 Christianne Louise Pollock         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP90   0
9464 9464 17636 Janet Denise Wise         local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002089 Plympton Erle                       2016-05-05 0 0           joint-party:53-119   0
9465 9465 17637 Andrea Victoria Loveridge         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002090 Plympton St Mary                       2016-05-05 0 0           PP52   0
9466 9466 17638 Tom Nally         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002090 Plympton St Mary                       2016-05-05 0 0           PP804   0
9467 9467 17639 Roger David Williams         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002090 Plympton St Mary                       2016-05-05 0 0           PP53   0
9468 9468 17647 Roxy Castell         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP804   0
9469 9469 17648 Sima Katie Davarian-Dehsorkhe         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP90   0
9470 9470 17649 Dena Rafati         local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           joint-party:53-119   0
9471 9471 17650 David Salmon         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP85   0
9472 9472 17651 Kevin Charles Wigens         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP52   0
9473 9473 17652 Vince Barry     Male 1997.0 local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002092 Plymstock Radford     https://vote.labour.org.uk/vince-barry       https://static-candidates.democracyclub.org.uk/media/images/images/17652.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           joint-party:53-119   0
9474 9474 17653 Connor Clarke         local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002092 Plymstock Radford     https://plymouth.lib.dm/en/article/2018/1269850/our-local-candidate-for-stoke-by-election-on-26th-july       https://static-candidates.democracyclub.org.uk/media/images/images/17653.png   profile-photo j0e_m https://plymouth.lib.dm/en/article/2018/1269850/our-local-candidate-for-stoke-by-election-on-26th-july 2016-05-05 0 0   49013.0       PP63   0
9475 9475 17654 Jeffrey Hall         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP90   0
9476 9476 17655 Michael John Edward Leaves         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP52   0
9477 9477 17656 Thomas Michael Sloman         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP804   0
9478 9478 17657 John Edwin Wheeler         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP85   0
9479 9479 17668 Stan Beal         local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP63   0
9480 9480 17669 Dan Bothwick         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP52   0
9481 9481 17670 Adam Lloyd Duffield         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP3940   0
9482 9482 17671 Stephen David Luscombe         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP90   0
9483 9483 17672 Aaron Bradley Smith         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP804   0
9484 9484 17673 Margaret Louise Storer         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP85   0
9485 9485 17674 Darren Mark Winter         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP53   0
9486 9486 17675 Bob Brice         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           PP804   0
9487 9487 17676 Jessica Rose Horner     female   local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002094 St Peter and the Waterfront             https://static-candidates.democracyclub.org.uk/media/images/images/17676.png   profile-photo DetachedOwl   2016-05-05 0 0           PP63   0
9488 9488 17677 Hugh Janes         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           PP90   0
9489 9489 17679 Karen Elizabeth Thurston         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           PP52   0
9490 9490 17680 Ian Glenn Tuffin         local.plymouth.2016-05-05 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           joint-party:53-119   0
9491 9491 17691 Nik Brookson         local.plymouth.2016-05-05 23 party:804 Trade Unionist and Socialist Coalition UTW:E05002095 Southway                       2016-05-05 0 0           PP804   0
9492 9492 17692 Storm Norman         local.plymouth.2016-05-05 23 party:90 Liberal Democrats UTW:E05002095 Southway                       2016-05-05 0 0           PP90   0
9493 9493 17693 Lorraine Parker         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002095 Southway                       2016-05-05 0 0           PP53   0
9494 9494 17694 Daniel Michael Sheaff     male   local.plymouth.2016-05-05 23 party:63 Green Party UTW:E05002095 Southway             https://static-candidates.democracyclub.org.uk/media/images/images/17694.png   public-domain ElPopey97   2016-05-05 0 0           PP63   0
9495 9495 17695 Rebecca Jane Smith         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002095 Southway                       2016-05-05 0 0           PP52   0
9496 9496 17696 Natasha Anne Squires         local.plymouth.2016-05-05 23 party:3940 Plymouth Independents UTW:E05002095 Southway                       2016-05-05 0 0           PP3940   0
9497 9497 17697 Sam Davey         local.plymouth.2016-05-05 23 party:53 Labour Party UTW:E05002096 Stoke                       2016-05-05 0 0           PP53   0
9498 9498 17698 Ramon Philip Fereday         local.plymouth.2016-05-05 23 party:85 UK Independence Party (UKIP) UTW:E05002096 Stoke                       2016-05-05 0 0           PP85   0
9499 9499 17699 Andrew Ford         local.plymouth.2016-05-05 23 party:52 Conservative and Unionist Party UTW:E05002096 Stoke                       2016-05-05 0 0           PP52   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 8.831ms · Data license: CC-BY-SA · Data source: Democracy Club