home / democracyclub

candidates

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

155 rows where election = 90

View and edit SQL

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, linkedin_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 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
14799 1011 Martin Tod     male 1964-08-22 local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011005     http://www.libdems.org.uk/martin_tod http://www.martintod.org.uk   https://uk.linkedin.com/in/martintod https://static-candidates.democracyclub.org.uk/media/images/images/1011_57vYvFC.png   mpntod Original of photo displayed here - https://twitter.com/mpntod 2016-05-05 0 0   17769.0       PP90 Dark Chocolate Florentine. 0
14800 2269 Patrick Davies     male   local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011003                     2016-05-05 0 0           PP53   0
14801 4542 Jackie Porter     Female   local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011007     http://www.libdems.org.uk/jackie_porter http://www.jackieporter.co.uk   https://www.linkedin.com/in/jackielibdem https://static-candidates.democracyclub.org.uk/media/images/images/4542.png     Auto imported from Twitter 2016-05-05 0 0           PP90   0
14802 5273 Andrew Adams Mr   male 1982.0 local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011003     http://www.andovernwhlabour.org.uk/andy http://www.andovernwhlabour.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/551ac34b13eb34c82843cb2e.png   _AndyAdams_ I'm the candidate - photo owned by me and free of copyright. 2016-05-05 0 0   5356;17722;42925       PP53 Jaffa Cake 0
14803 6036 Michael Wilks     Male   local.winchester.2016-05-05 90 party:63 Green Party DIW:E05011002             https://static-candidates.democracyclub.org.uk/media/images/553b8f3be6d2cbcd26e36a2e.png   edent This is the candidate’s twitter profile image, from https://twitter.com/WilksMwilks 2016-05-05 0 0           PP63   0
14804 6392 Eleanor Bell     female   local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010996             https://static-candidates.democracyclub.org.uk/media/images/553c97bd41b868785b1fe672.png   edent This is the candidate’s twitter profile image, from https://twitter.com/EleanorBell2015 2016-05-05 0 0           PP90   0
14805 7732 Mike Read     male   local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011000                     2016-05-05 0 0           PP52   0
14806 14965 Chris Barton-Briddon         local.winchester.2016-05-05 90 party:85 UK Independence Party (UKIP) DIW:E05010996                     2016-05-05 0 0           PP85   0
14807 14966 Gavin Craig Dick         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010996                     2016-05-05 0 0           PP52   0
14808 14967 Rob Ducker         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010996                     2016-05-05 0 0           PP52   0
14809 14968 Brian Leslie Laming         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010996     http://www.winld.org.uk/your_candidate_badgers_farm_and_olivers_battery       https://static-candidates.democracyclub.org.uk/media/images/images/14968.png   jtonline   2016-05-05 0 0           PP90   0
14810 14969 Alun Glyn Rees         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010996                     2016-05-05 0 0           PP53   0
14811 14970 Peter Rees         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010996                     2016-05-05 0 0           PP53   0
14812 14971 John Louis Romero         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010996                     2016-05-05 0 0           PP90   0
14813 14972 Jonathan Paul Tettmar         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010996                     2016-05-05 0 0           PP53   0
14814 14973 Jan Warwick         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010996                     2016-05-05 0 0           PP52   0
14815 15008 Sudhakar Kedareshwar Achwal         local.winchester.2016-05-05 90 ynmp-party:2 Independent DIW:E05010997                     2016-05-05 0 0           ynmp-party:2   0
14816 15009 Laurie Clough         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010997                     2016-05-05 0 0           PP53   0
14817 15010 Steve Haines         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010997                     2016-05-05 0 0           PP53   0
14818 15011 Thomas Houghton         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010997                     2016-05-05 0 0           PP90   0
14819 15012 Rob Humby         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010997                     2016-05-05 0 0           PP52   0
14820 15013 Steven John Jakubowski         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010997                     2016-05-05 0 0           PP53   0
14821 15014 David Charles Leon McLean         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010997                     2016-05-05 0 0           PP52   0
14822 15016 Benjamin Russell Mackintosh Stoneham         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010997                     2016-05-05 0 0           PP90   0
14823 15017 Vivienne Angela Young         local.winchester.2016-05-05 90 party:85 UK Independence Party (UKIP) DIW:E05010997                     2016-05-05 0 0           PP85   0
14824 15018 Keith Eric Divall         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010995                     2016-05-05 0 0           PP90   0
14825 15019 Russell Digby Gordon-Smith         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010995                     2016-05-05 0 0           PP90   0
14826 15020 Kim Alexander Gottlieb         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010995                     2016-05-05 0 0           PP52   0
14827 15021 Lisa Suzanne Griffiths         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010995                     2016-05-05 0 0           PP52   0
14828 15022 Lee Arthur Hayes         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010995                     2016-05-05 0 0           PP53   0
14829 15023 Ernie Jeffs         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010995                     2016-05-05 0 0           PP52   0
14830 15024 James Edwin Leppard         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010995                     2016-05-05 0 0           PP53   0
14831 15025 Margot Julia Power         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010995     http://www.winld.org.uk/your_candidate_alresford_itchen_valley_margot_power       https://static-candidates.democracyclub.org.uk/media/images/images/15025.png   jtonline   2016-05-05 0 0           PP90   0
14832 15026 Ian Duncan Wight         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010995                     2016-05-05 0 0           PP53   0
14833 17605 Sheila Mary Campbell         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010998     http://www.winld.org.uk/your_candidate_central_meon_valley_sheila_campbell       https://static-candidates.democracyclub.org.uk/media/images/images/17605.png   jtonline   2016-05-05 0 0           PP90   0
14834 17606 Stan Evans         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010998                     2016-05-05 0 0           PP53   0
14835 17607 Linda Eileen Elizabeth Gemmell         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010998                     2016-05-05 0 0           PP52   0
14836 17608 Alex Graft     Alex Graft 1983.0 local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010998             https://static-candidates.democracyclub.org.uk/media/images/images/17608.png   alex19   2016-05-05 0 0           PP53   0
14837 17609 Leslie Thomas Mitchell         local.winchester.2016-05-05 90 party:85 UK Independence Party (UKIP) DIW:E05010998                     2016-05-05 0 0           PP85   0
14838 17610 Frank Richard Pearson         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010998                     2016-05-05 0 0           PP52   0
14839 17611 Margaret Scriven         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010998                     2016-05-05 0 0           PP90   0
14840 17612 Anne Kristine Mackintosh Stoneham         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010998                     2016-05-05 0 0           PP90   0
14841 17613 Nicola Ann Wardrop         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010998                     2016-05-05 0 0           PP53   0
14842 17614 Vicki Weston         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010998                     2016-05-05 0 0           PP52   0
14843 17621 Paul James Brown         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010999                     2016-05-05 0 0           PP53   0
14844 17622 Sue J Cook         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010999                     2016-05-05 0 0           PP52   0
14845 17623 Sonia Frances Critcher         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05010999                     2016-05-05 0 0           PP53   0
14846 17624 Julia Ellen Hallmann         local.winchester.2016-05-05 90 party:63 Green Party DIW:E05010999                     2016-05-05 0 0           PP63   0
14847 17625 Richard Charles Izard         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010999                     2016-05-05 0 0           PP90   0
14848 17626 Robert Johnston         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05010999                     2016-05-05 0 0           PP90   0
14849 17627 Maureen Anne Rees         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05010999                     2016-05-05 0 0           PP52   0
14850 17640 Caroline Lorraine Brook         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011000                     2016-05-05 0 0           PP52   0
14851 17641 Jacqueline June Carroll         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011000                     2016-05-05 0 0           PP53   0
14852 17642 Steve Della Mora         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011000                     2016-05-05 0 0           PP53   0
14853 17643 Andrew Negus         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011000                     2016-05-05 0 0           PP90   0
14854 17644 Claire Louise Sorensen         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011000                     2016-05-05 0 0           PP53   0
14855 17645 Patricia Grace Stallard         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011000                     2016-05-05 0 0           PP52   0
14856 17646 Simon Paul Wernick         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011000                     2016-05-05 0 0           PP90   0
14857 17658 Mags Brown         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011006                     2016-05-05 0 0           PP52   0
14858 17659 Angela Clear         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011006                     2016-05-05 0 0           PP90   0
14859 17660 Neil Richard Cutler         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011006     http://www.winld.org.uk/your_candidate_southwick_wickham_neil_cutler       https://static-candidates.democracyclub.org.uk/media/images/images/17660.png   jtonline   2016-05-05 0 0           PP90   0
14860 17661 Leon George Dabbs         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011006                     2016-05-05 0 0           PP52   0
14861 17662 Therese Evans         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011006                     2016-05-05 0 0           PP90   0
14862 17663 Gary Allan Gray         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011006                     2016-05-05 0 0           PP53   0
14863 17664 Paul Francis Harris         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011006                     2016-05-05 0 0           PP53   0
14864 17665 Neil Harold Lander-Brinkley         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011006                     2016-05-05 0 0           PP52   0
14865 17666 Ian James Norgate         local.winchester.2016-05-05 90 party:85 UK Independence Party (UKIP) DIW:E05011006                     2016-05-05 0 0           PP85   0
14866 17667 Paul Thomas Sony         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011006                     2016-05-05 0 0           PP53   0
14867 17681 Eileen Mary Berry         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011001                     2016-05-05 0 0           PP52   0
14868 17682 Adrian John Paul Field         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011001                     2016-05-05 0 0           PP53   0
14869 17683 Hannah Valentine Field         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011001                     2016-05-05 0 0           PP53   0
14870 17684 Kezia Melissa Louise Hoffman         local.winchester.2016-05-05 90 ynmp-party:2 Independent DIW:E05011001                     2016-05-05 0 0           ynmp-party:2   0
14871 17685 Cameron Thomas Strachan Johnson         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011001                     2016-05-05 0 0           PP90   0
14872 17686 Kelsie Learney         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011001                     2016-05-05 0 0           PP90   0
14873 17687 Paul Charles Twelftree         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011001                     2016-05-05 0 0           PP52   0
14874 17688 Tessa Susan Valentine         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011001                     2016-05-05 0 0           PP53   0
14875 17689 Anne Helen Weir         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011001     http://www.winld.org.uk/your_candidate_st_barnabas_anne_weir       https://static-candidates.democracyclub.org.uk/media/images/images/17689.png   jtonline   2016-05-05 0 0           PP90   0
14876 17690 Angie Wilkinson         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011001                     2016-05-05 0 0           PP52   0
14877 17707 Bob Barnes         local.winchester.2016-05-05 90 party:85 UK Independence Party (UKIP) DIW:E05011002                     2016-05-05 0 0           PP85   0
14878 17708 Rose Burns         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011002                     2016-05-05 0 0           PP52   0
14879 17709 Lucy Emma Clement         local.winchester.2016-05-05 90 party:63 Green Party DIW:E05011002                     2016-05-05 0 0           PP63   0
14880 17710 Michael Frederick Coker-Davies         local.winchester.2016-05-05 90 ynmp-party:2 Independent DIW:E05011002                     2016-05-05 0 0           ynmp-party:2   0
14881 17711 David James Crudgington         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011002                     2016-05-05 0 0           PP52   0
14882 17712 Kathleen Frances Alice East         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011002                     2016-05-05 0 0           PP53   0
14883 17713 Nicki Elks         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011002                     2016-05-05 0 0           PP90   0
14884 17714 Sue Falconer         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011002                     2016-05-05 0 0           PP52   0
14885 17715 Clive Malcolm Gosling         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011002                     2016-05-05 0 0           PP53   0
14886 17716 Rhian Louise Harrison         local.winchester.2016-05-05 90 party:63 Green Party DIW:E05011002                     2016-05-05 0 0           PP63   0
14887 17717 Dominic Charles Alan Hiscock         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011002                     2016-05-05 0 0           PP90   0
14888 17718 Lawrence Andreas Leslie Mason         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011002                     2016-05-05 0 0           PP53   0
14889 17723 Derek Green         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011003                     2016-05-05 0 0           PP90   0
14890 17724 Tomos Owain James         local.winchester.2016-05-05 90 party:4047 Winchester Independents DIW:E05011003                     2016-05-05 0 0           PP4047   0
14891 17725 George Edward Marshall-James         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011003                     2016-05-05 0 0           PP52   0
14892 17726 Kia Robert Pope         local.winchester.2016-05-05 90 party:63 Green Party DIW:E05011003                     2016-05-05 0 0           PP63   0
14893 17727 Harry William Sampson         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011003                     2016-05-05 0 0           PP52   0
14894 17728 Jamie Robert Jonathan Scott         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011003                     2016-05-05 0 0           PP90   0
14895 17738 Guy Julian Claude Ashton         local.winchester.2016-05-05 90 party:52 Conservative and Unionist Party DIW:E05011004                     2016-05-05 0 0           PP52   0
14896 17739 David Banks         local.winchester.2016-05-05 90 party:90 Liberal Democrats DIW:E05011004                     2016-05-05 0 0           PP90   0
14897 17740 Dinah June Caroline Barton         local.winchester.2016-05-05 90 party:63 Green Party DIW:E05011004                     2016-05-05 0 0           PP63   0
14898 17741 Janet Mary Berry         local.winchester.2016-05-05 90 party:53 Labour Party DIW:E05011004                     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 8.867ms · Data license: CC-BY-SA · Data source: Democracy Club