home / democracyclub

candidates

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

137 rows where election = 65

✎ 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, party_ppc_page_url, facebook_personal_url, homepage_url, linkedin_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
12661 12661 5142 Diana Moore     Female 1971-01-06 local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011020 St David's     http://exeter.greenparty.org.uk/votegreen2015.html https://dianamooregreen.wordpress.com/blog-and-reflections/     https://static-candidates.democracyclub.org.uk/media/images/54932a6533aed1a20f97d805.png         2016-05-05 0 0   11419;27577       PP63   0
12662 12662 5991 James Taghdissian     male 1982.0 local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011021 St Loyes     http://www.exeterconservatives.co.uk/person/james-taghdissian http://www.jamestaghdissian.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/5524a134f0e9e2c82406ebae.png   profile-photo TimPatmore PPC profile picture: https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Taghdissian_James.aspx 2016-05-05 0 0   11434.0       PP52   0
12663 12663 9585 Philip Michael Bialyk         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011013 Exwick   1.0                   2016-05-05 0 0           PP53   0
12664 12664 9586 Lawrence Simon Harper         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011013 Exwick                       2016-05-05 0 0   27512.0       PP85   0
12665 12665 9587 Steve Hawkins         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011013 Exwick                       2016-05-05 0 0           PP52   0
12666 12666 9588 Benjamin Tomos Lewis Dr   Male 1991.0 local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011013 Exwick             https://static-candidates.democracyclub.org.uk/media/images/images/9588.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52 Digestive 0
12667 12667 9589 Caroline Emily Gwyneth Nottle         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011013 Exwick                       2016-05-05 0 0           PP90   0
12668 12668 9590 Ollie Pearson         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011013 Exwick   1.0                   2016-05-05 0 0           PP53   0
12669 12669 9591 Stephen Leslie Porter         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011013 Exwick                       2016-05-05 0 0           PP63   0
12670 12670 9592 Rachel Helen Sutton         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011013 Exwick   1.0                   2016-05-05 0 0           PP53   0
12671 12671 9593 Patricia White         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011013 Exwick                       2016-05-05 0 0           PP52   0
12672 12672 9621 Andrew Wallace Bell         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP63   0
12673 12673 9622 Isabel Castle         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP63   0
12674 12674 9623 Emily Croft         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011011 Alphington                       2016-05-05 0 0   26552.0       PP52   0
12675 12675 9624 Dutch Dudgeon         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011011 Alphington                       2016-05-05 0 0           PP85   0
12676 12676 9625 Audaye Khalid Elesedy         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP63   0
12677 12677 9626 Bob Foale         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011011 Alphington   1.0                   2016-05-05 0 0           PP53   0
12678 12678 9627 Aric Gilinsky         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011011 Alphington                       2016-05-05 0 0   27576.0       PP52   0
12679 12679 9628 John Harvey         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP52   0
12680 12680 9629 Chris Musgrave         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011011 Alphington   1.0                   2016-05-05 0 0           PP53   0
12681 12681 9630 Rod Ruffle         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011011 Alphington                       2016-05-05 0 0           PP90   0
12682 12682 9631 Steve Warwick         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011011 Alphington   1.0                   2016-05-05 0 0           PP53   0
12683 12683 9658 Richard William Elliott         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP52   0
12684 12684 9659 Rouben Scott Freeman         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP63   0
12685 12685 9660 Tristan Charles Leonard Harris     Male 1997-05-11 local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP53   0
12686 12686 9661 Robert Edward William Hughes-Chamberlain         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP53   0
12687 12687 9662 Kevin John Mitchell         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011012 Duryard & St James   1.0                   2016-05-05 0 0           PP90   0
12688 12688 9663 Michael Norman Mitchell         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011012 Duryard & St James                       2016-05-05 0 0   27507.0       PP90   0
12689 12689 9665 Keith Owen         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011012 Duryard & St James   1.0                   2016-05-05 0 0           PP53   0
12690 12690 9666 Bethany Payne     female   local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011012 Duryard & St James           https://www.linkedin.com/in/bethanypayne/           2016-05-05 0 0   27574.0       PP63   0
12691 12691 9667 Percy Prowse         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011012 Duryard & St James   1.0                   2016-05-05 0 0   27508.0       PP52   0
12692 12692 9671 Jenny Steer         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP63   0
12693 12693 9672 Nicholas George Sutton         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP90   0
12694 12694 9673 Sallie Cherie Waters         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011012 Duryard & St James                       2016-05-05 0 0   27509.0       PP85   0
12695 12695 11005 Gill Baker         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP63   0
12696 12696 11006 Diana Beasley         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011014 Heavitree                       2016-05-05 0 0           PP85   0
12697 12697 11007 Rob Davies         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP63   0
12698 12698 11008 Rosie Clare Denham         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011014 Heavitree   1.0                   2016-05-05 0 0           PP53   0
12699 12699 11009 Olwen Margaret Foggin         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011014 Heavitree   1.0                   2016-05-05 0 0           PP53   0
12700 12700 11010 Sheila Muriel Hobden         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011014 Heavitree                       2016-05-05 0 0           PP90   0
12701 12701 11011 Steve Jones         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP63   0
12702 12702 11012 Sam Morfey         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP52   0
12703 12703 11013 Guy Steven Frank Richards         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP52   0
12704 12704 11014 Greg Sheldon         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011014 Heavitree   1.0                   2016-05-05 0 0           PP53   0
12705 12705 11120 Anne Patricia Back         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP85   0
12706 12706 11121 Stephen Alexander Brimble         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011015 Mincinglake & Whipton   1.0                   2016-05-05 0 0           PP53   0
12707 12707 11122 Peter William Edwards         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011015 Mincinglake & Whipton   1.0                   2016-05-05 0 0           PP53   0
12708 12708 11123 Eddie Higgins         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP85   0
12709 12709 11124 George Thomas Livesey         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP52   0
12710 12710 11125 Emma Anita Morse         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011015 Mincinglake & Whipton   1.0                   2016-05-05 0 0           PP53   0
12711 12711 11126 Bridget Catherine Oliver         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP63   0
12712 12712 11127 Paul Robert Geoffrey Rota         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP52   0
12713 12713 11128 Alison Jane Sheridan     Female   local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP85   0
12714 12714 11129 Andrew Matthew Soper         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP90   0
12715 12715 11130 David Thompson         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP52   0
12716 12716 11132 Azhar-Jamal Chaudhry     male   local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011014 Heavitree           https://www.linkedin.com/in/azhar-chaudry-881375100/ https://static-candidates.democracyclub.org.uk/media/images/images/11132.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
12717 12717 11139 Richard Arthur Branston         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011016 Newtown & St Leonard's   1.0                   2016-05-05 0 0           PP53   0
12718 12718 11140 Andrew Cheesewright         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP63   0
12719 12719 11141 Jacqueline Barbara Holdstock         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP85   0
12720 12720 11142 James Landymore         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP90   0
12721 12721 11143 Tom Milburn       1978.0 local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011016 Newtown & St Leonard's     https://exeter.greenparty.org.uk/elect-tom-milburn.html       https://static-candidates.democracyclub.org.uk/media/images/images/11143.png   copyright-assigned TOM_MILBURN This is my own photograph of myself 2016-05-05 0 0           PP63   0
12722 12722 11144 John Murphy         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP52   0
12723 12723 11145 Joe Powell         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP63   0
12724 12724 11146 Norman Shiel         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP52   0
12725 12725 11147 Dave Smith     male   local.exeter.2016-05-05 65 party:1918 Independence from Europe DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0   46845.0       PP1918   0
12726 12726 11148 Roger David Spackman         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011016 Newtown & St Leonard's   1.0                   2016-05-05 0 0           PP53   0
12727 12727 11149 Natalie Jane Vizard         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011016 Newtown & St Leonard's   1.0                   2016-05-05 0 0           PP53   0
12728 12728 11150 Stephanie Warner         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP52   0
12729 12729 11159 David Barker-Hahlo         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP63   0
12730 12730 11160 Alysa Freeman         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP63   0
12731 12731 11161 Daniel Ryan Gottschalk         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011017 Pennsylvania   1.0                   2016-05-05 0 0           PP53   0
12732 12732 11162 Peter Holland         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011017 Pennsylvania   1.0                   2016-05-05 0 0           PP52   0
12733 12733 11163 Anne Jobson         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0   27580.0       PP52   0
12734 12734 11164 Alan Jones         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP52   0
12735 12735 11165 Rachel Clare Lyons         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011017 Pennsylvania   1.0                   2016-05-05 0 0           PP53   0
12736 12736 11166 Christine Elizabeth Raybould-Gooding         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP53   0
12737 12737 11167 Kimberley Lauren Stansfield     female   local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP90   0
12738 12738 11168 Lizzie Woodman         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0   27510.0       PP63   0
12739 12739 11173 David James Harvey         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011018 Pinhoe   1.0                   2016-05-05 0 0           PP53   0
12740 12740 11174 Diana Patricia Jones         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP63   0
12741 12741 11175 Mike Payne         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011018 Pinhoe                       2016-05-05 0 0   27575.0       PP90   0
12742 12742 11176 John Rogers         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP52   0
12743 12743 11177 Ruth Smith         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP52   0
12744 12744 11178 Cynthia Thompson         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011018 Pinhoe   1.0                   2016-05-05 0 0           PP52   0
12745 12745 11179 Duncan Wood         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011018 Pinhoe   1.0                   2016-05-05 0 0           PP53   0
12746 12746 11180 Laura Charis Adelaide Wright         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP53   0
12747 12747 11401 Lucille Baker         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011019 Priory                       2016-05-05 0 0           PP52   0
12748 12748 11402 Nicola Guagliardo         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011019 Priory                       2016-05-05 0 0           PP52   0
12749 12749 11403 Kate Hannan         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011019 Priory   1.0                   2016-05-05 0 0           PP53   0
12750 12750 11404 Ellen McDonnell         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011019 Priory                       2016-05-05 0 0           PP90   0
12751 12751 11405 Lesley Sara Robson         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011019 Priory   1.0                   2016-05-05 0 0           PP53   0
12752 12752 11406 Robert James Sheridan         local.exeter.2016-05-05 65 party:85 UK Independence Party (UKIP) DIW:E05011019 Priory                       2016-05-05 0 0           PP85   0
12753 12753 11407 Mario Trabucco         local.exeter.2016-05-05 65 party:52 Conservative and Unionist Party DIW:E05011019 Priory                       2016-05-05 0 0           PP52   0
12754 12754 11408 Tony Wardle         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011019 Priory   1.0                   2016-05-05 0 0           PP53   0
12755 12755 11409 Lynn Susan Wetenhall         local.exeter.2016-05-05 65 party:63 Green Party DIW:E05011019 Priory                       2016-05-05 0 0           PP63   0
12756 12756 11414 Philip John Brock         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011020 St David's                       2016-05-05 0 0           PP90   0
12757 12757 11415 Stella Rose Brock         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011020 St David's                       2016-05-05 0 0           PP90   0
12758 12758 11416 Kevin Martin Chun         local.exeter.2016-05-05 65 party:90 Liberal Democrats DIW:E05011020 St David's                       2016-05-05 0 0           PP90   0
12759 12759 11417 Lewis Peter Griffiths Keen         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011020 St David's   1.0                   2016-05-05 0 0           PP53   0
12760 12760 11418 Robert Lamb         local.exeter.2016-05-05 65 party:53 Labour Party DIW:E05011020 St David's   1.0                   2016-05-05 0 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 9.027ms · Data license: CC-BY-SA · Data source: Democracy Club