home / democracyclub

candidates

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

93 rows where election = 93

✎ 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, homepage_url, image_url, image_copyright, image_uploading_user, 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
15070 15070 123 John Hayter     male   local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010855 Trinity                       2016-05-05 0 0   5900.0       PP85   0
15071 15071 4663 Simon Cross Mr   male 1964-09-04 local.rochford.2016-05-05 93 party:63 Green Party DIW:E05010845 Foulness & The Wakerings     https://southeastessex.greenparty.org.uk/candidates/simon-cross.html https://southeastessex.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/4663.png   profile-photo james24   2016-05-05 0 0   9797.0       PP63   0
15072 15072 9788 Shaun Cain         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0           PP53   0
15073 15073 9789 John Richard Chaffin         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0           PP341   0
15074 15074 9790 Tony Hollis         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0           PP52   0
15075 15075 9791 Deborah Mercer         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0           PP52   0
15076 15076 9792 Ron Oatham         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0           PP90   0
15077 15077 9793 Keith Brian Podd         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0           PP52   0
15078 15078 9794 Chris Stanley         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0           PP90   0
15079 15079 9795 Mark Arnold         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP90   0
15080 15080 9796 Tracy Arnold         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP90   0
15081 15081 9798 Daniel Efde         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP85   0
15082 15082 9799 Trevor Edward Goodwin         local.rochford.2016-05-05 93 ynmp-party:2 Independent DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           ynmp-party:2   0
15083 15083 9800 Ann Holland         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP52   0
15084 15084 9801 Neil Hookway         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP85   0
15085 15085 9802 Tina Hughes         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010845 Foulness & The Wakerings             https://static-candidates.democracyclub.org.uk/media/images/images/9802.png   profile-photo yanbad13257   2016-05-05 0 0   30154.0       PP85   0
15086 15086 9803 David James Michael Lench     male   local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP53   0
15087 15087 9804 Jack Newman         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP53   0
15088 15088 9806 Tony Porter         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP52   0
15089 15089 9807 Paul Leslie White         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP53   0
15090 15090 9808 Barbara Jean Wilkins         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010845 Foulness & The Wakerings                       2016-05-05 0 0           PP52   0
15091 15091 9809 Lesley Ann Butcher         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010846 Hawkwell East                       2016-05-05 0 0           PP52   0
15092 15092 9810 Gill Gibson         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010846 Hawkwell East                       2016-05-05 0 0           PP53   0
15093 15093 9811 Elliot Mason         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010846 Hawkwell East                       2016-05-05 0 0           PP341   0
15094 15094 9812 Jo McPherson         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010846 Hawkwell East                       2016-05-05 0 0           PP52   0
15095 15095 9813 Mike Webb         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010846 Hawkwell East                       2016-05-05 0 0           PP52   0
15096 15096 9814 Robert Clemenson Mr   Male 1997-06-18 local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010847 Hawkwell West                       2016-05-05 0 0           PP53   0
15097 15097 9815 Julie Roseanna Gooding         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010847 Hawkwell West                       2016-05-05 0 0           PP52   0
15098 15098 9816 Alex Holland-Martin         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010847 Hawkwell West                       2016-05-05 0 0           PP52   0
15099 15099 9817 Liz Marlow         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010847 Hawkwell West                       2016-05-05 0 0           PP52   0
15100 15100 9818 Christine Mason         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010847 Hawkwell West                       2016-05-05 0 0           PP341   0
15101 15101 9819 John Mason         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010847 Hawkwell West                       2016-05-05 0 0           PP341   0
15102 15102 9820 Irena Cassar         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010848 Hockley                       2016-05-05 0 0           PP341   0
15103 15103 9821 Adrian Eves         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010848 Hockley                       2016-05-05 0 0           PP341   0
15104 15104 9822 Brian Thomas Hazlewood         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010848 Hockley                       2016-05-05 0 0           PP52   0
15105 15105 9823 Keith Henry Hudson         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010848 Hockley                       2016-05-05 0 0           PP52   0
15106 15106 9824 Malcolm Maddocks         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010848 Hockley                       2016-05-05 0 0           PP52   0
15107 15107 9825 Ian James Rooke         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010848 Hockley                       2016-05-05 0 0           PP53   0
15108 15108 9826 Mike Carter         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010849 Hockley & Ashingdon                       2016-05-05 0 0           PP52   0
15109 15109 9827 Terry Cutmore         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010849 Hockley & Ashingdon                       2016-05-05 0 0           PP52   0
15110 15110 9828 Carole Anne Weston         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010849 Hockley & Ashingdon                       2016-05-05 0 0           PP52   0
15111 15111 9829 Stephen Arthur Willis         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010849 Hockley & Ashingdon                       2016-05-05 0 0           PP53   0
15112 15112 9830 John Alfred Bull         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP85   0
15113 15113 9831 David Frederick Flack     male   local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP53   0
15114 15114 9832 Angela Violet Hale         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP52   0
15115 15115 9833 Mark Peter Hale         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP52   0
15116 15116 9834 Diane Hoy         local.rochford.2016-05-05 93 party:63 Green Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP63   0
15117 15117 9835 Michael Hoy         local.rochford.2016-05-05 93 party:63 Green Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP63   0
15118 15118 9836 Robin Hume         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP53   0
15119 15119 9837 Angelina Donna Marriott         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP52   0
15120 15120 9838 Roger Anthony Neville         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP53   0
15121 15121 9839 Stuart Anthony Wilson         local.rochford.2016-05-05 93 party:63 Green Party DIW:E05010850 Hullbridge                       2016-05-05 0 0           PP63   0
15122 15122 9840 Bernadette Hannon         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010851 Lodge                       2016-05-05 0 0           PP53   0
15123 15123 9841 Richard Lambourne         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010851 Lodge                       2016-05-05 0 0           PP341   0
15124 15124 9842 Bob Milne         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010851 Lodge                       2016-05-05 0 0           PP52   0
15125 15125 9843 Simon Paul Smith         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010851 Lodge                       2016-05-05 0 0           PP52   0
15126 15126 9844 Stephen Tellis         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010851 Lodge                       2016-05-05 0 0           PP90   0
15127 15127 9845 Carol Ann Twydell         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010851 Lodge                       2016-05-05 0 0           PP85   0
15128 15128 9846 Ian Howard Ward         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010851 Lodge                       2016-05-05 0 0           PP52   0
15129 15129 9847 Nicholas Leonard Cooper         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010852 Roche North & Rural                       2016-05-05 0 0           PP85   0
15130 15130 9848 Mark Daniels     male   local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010852 Roche North & Rural             https://static-candidates.democracyclub.org.uk/media/images/images/9848.png   profile-photo brycx https://twitter.com/marky_daniels 2016-05-05 0 0           PP53   0
15131 15131 9849 George John Ioannou         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010852 Roche North & Rural                       2016-05-05 0 0           PP52   0
15132 15132 9850 Daniel Irlam         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010852 Roche North & Rural                       2016-05-05 0 0   30168.0       PP90   0
15133 15133 9851 Kevin Douglas Salt         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010852 Roche North & Rural                       2016-05-05 0 0           PP53   0
15134 15134 9852 Laureen Shaw         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010852 Roche North & Rural                       2016-05-05 0 0           PP52   0
15135 15135 9853 Philip John Shaw         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010852 Roche North & Rural                       2016-05-05 0 0           PP52   0
15136 15136 9854 Myra Anne Weir         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010852 Roche North & Rural                       2016-05-05 0 0           PP53   0
15137 15137 9855 Simon Gosden         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010853 Roche South                       2016-05-05 0 0           PP53   0
15138 15138 9856 John Henry Jefferies         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010853 Roche South                       2016-05-05 0 0           PP53   0
15139 15139 9857 Richard Henry Loding         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010853 Roche South                       2016-05-05 0 0           PP85   0
15140 15140 9858 Michael John Lucas-Gill         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010853 Roche South                       2016-05-05 0 0           PP52   0
15141 15141 9859 Marion Lilian Sawyer         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010853 Roche South                       2016-05-05 0 0           PP85   0
15142 15142 9860 Mike Steptoe         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010853 Roche South                       2016-05-05 0 0           PP52   0
15143 15143 9861 Arthur Williams         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010853 Roche South                       2016-05-05 0 0           PP52   0
15144 15144 9862 Victoria Mary Williams         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010853 Roche South                       2016-05-05 0 0           PP53   0
15145 15145 9863 Craig Matthew Archer         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010854 Sweyne Park & Grange                       2016-05-05 0 0           PP53   0
15146 15146 9864 June Rosemary Lumley         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010854 Sweyne Park & Grange                       2016-05-05 0 0           PP52   0
15147 15147 9865 Toby Mountain         local.rochford.2016-05-05 93 party:341 Rochford District Residents DIW:E05010854 Sweyne Park & Grange                       2016-05-05 0 0           PP341   0
15148 15148 9866 James Newport     male   local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010854 Sweyne Park & Grange       https://www.jamesnewport.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/9866_Yo4nD8p.png   copyright-assigned jamesnewport   2016-05-05 0 0           PP90   0
15149 15149 9867 Carol Ann Pavelin     female   local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010854 Sweyne Park & Grange                       2016-05-05 0 0           PP52   0
15150 15150 9868 Margaret Helen Spencer         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010854 Sweyne Park & Grange                       2016-05-05 0 0           PP52   0
15151 15151 9869 Stephen James Cooper         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010855 Trinity                       2016-05-05 0 0           PP53   0
15152 15152 9870 Keith Anthony Gibbs         local.rochford.2016-05-05 93 party:85 UK Independence Party (UKIP) DIW:E05010855 Trinity                       2016-05-05 0 0           PP85   0
15153 15153 9871 David Merrick     male   local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010855 Trinity                       2016-05-05 0 0           PP52   0
15154 15154 9872 Cheryl Edwina Roe         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010855 Trinity                       2016-05-05 0 0           PP52   0
15155 15155 9873 David John Sperring     male   local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010855 Trinity                       2016-05-05 0 0           PP52   0
15156 15156 9874 Jamie Clive Burton         local.rochford.2016-05-05 93 party:4007 Rayleigh Independents DIW:E05010856 Wheatley                       2016-05-05 0 0           PP4007   0
15157 15157 9875 Robin Richard Dray         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010856 Wheatley                       2016-05-05 0 0           PP52   0
15158 15158 9876 John David Griffin     male   local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010856 Wheatley                       2016-05-05 0 0           PP52   0
15159 15159 9877 Michael Handford         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010856 Wheatley                       2016-05-05 0 0           PP90   0
15160 15160 9878 Luke Houghton         local.rochford.2016-05-05 93 party:53 Labour Party DIW:E05010856 Wheatley                       2016-05-05 0 0           PP53   0
15161 15161 9879 Jack Leslie Lawmon         local.rochford.2016-05-05 93 party:52 Conservative and Unionist Party DIW:E05010856 Wheatley                       2016-05-05 0 0           PP52   0
15162 15162 30152 Christopher Ian Black         local.rochford.2016-05-05 93 party:90 Liberal Democrats DIW:E05010844 Downhall & Rawreth                       2016-05-05 0 0   9787.0       PP90   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 8.564ms · Data license: CC-BY-SA · Data source: Democracy Club