home / democracyclub

candidates

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

74 rows where election = 18

✎ 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, 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
8986 8986 887 Jane Kulka     female   local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007331 Earlswood and Whitebushes     http://reigatelibdems.org.uk/en/contact/jane-kulka       https://static-candidates.democracyclub.org.uk/media/images/images/887_68QISFj.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   18796.0       PP90   0
8987 8987 2821 Leigh Jones     male 1958-03-20 local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007340 Redhill East                       2016-05-05 0 0           PP85   0
8988 8988 5488 Nicola Dodgson     female   local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007345 South Park and Woodhatch     http://rbgp.org.uk/2015/01/introducing-our-general-election-candidates/ https://nicoladodgson.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/54bf99ae5a9c3744778f9b89.png         2016-05-05 0 0           PP63   0
8989 8989 5937 Liam Ascough     male   local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007334 Horley West     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ascough_Liam.aspx       https://static-candidates.democracyclub.org.uk/media/images/54cd19df668e142f73d3b4a3.png   profile-photo     2016-05-05 0 0   4812;15002       PP52   0
8990 8990 6028 Anna Tarrant     female 1974.0 local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007336 Meadvale and St John's     http://www.libdems.org.uk/anna_tarrant       https://static-candidates.democracyclub.org.uk/media/images/5548add99b4dcd1028de1cc3.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/anna_tarrant 2016-05-05 0 0   18828.0       PP90   0
8991 8991 8162 Chris Byrne         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007329 Banstead Village                       2016-05-05 0 0           PP85   0
8992 8992 8164 Valerie Ann Moore         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP85   0
8993 8993 8165 Steven David Alfred Russell     male   local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007330 Chipstead, Hooley and Woodmansterne                       2016-05-05 0 0           PP85   0
8994 8994 8166 Bob Cambridge         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007335 Kingswood with Burgh Heath                       2016-05-05 0 0           PP85   0
8995 8995 8167 Phyl Cambridge         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007337 Merstham                       2016-05-05 0 0           PP85   0
8996 8996 8168 Laurence James Clack         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007343 Reigate Hill                       2016-05-05 0 0           PP85   0
8997 8997 8169 Tim Pearson         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007341 Redhill West                       2016-05-05 0 0           PP85   0
8998 8998 8170 Alastair Richardson         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0   41206.0       PP85   0
8999 8999 8171 Gerard Martin Hever         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP85   0
9000 9000 8172 Colin Brian Stiff         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007331 Earlswood and Whitebushes                       2016-05-05 0 0           PP85   0
9001 9001 14148 Toby Brampton     male   local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007340 Redhill East     https://vote.labour.org.uk/toby-brampton       https://static-candidates.democracyclub.org.uk/media/images/images/14148_dtxOiBm.png   public-domain TobyBrampton   2016-05-05 0 0           PP53   0
9002 9002 14151 Steve McKenna         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007340 Redhill East                       2016-05-05 0 0           PP63   0
9003 9003 14847 Mark Alan Brunt     Male 1970.0 local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007337 Merstham       http://www.rbca.org.uk/person/mark-brunt-cllr-merstham-and-association-deputy-chairman-political     https://static-candidates.democracyclub.org.uk/media/images/images/14847.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
9004 9004 14953 Natalie Jane Bramhall Mrs   Female   local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007341 Redhill West                       2016-05-05 0 0           PP52   0
9005 9005 14959 Victor William Broad Mr   Male   local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP52   0
9006 9006 14979 Roger Charles Newstead Mr       local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007343 Reigate Hill                       2016-05-05 0 0           PP52   0
9007 9007 14980 Helen Jane Foreman Mrs       local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP52   0
9008 9008 14986 Eddy Humphreys Mr       local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007329 Banstead Village                       2016-05-05 0 0           PP52   0
9009 9009 14987 James Paul King Mr       local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0           PP52   0
9010 9010 14988 James Edward Durrant Mr   male   local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007331 Earlswood and Whitebushes             https://static-candidates.democracyclub.org.uk/media/images/images/14988.png   profile-photo fbrc Twitter profile pic https://twitter.com/cllr_durrant 2016-05-05 0 0           PP52   0
9011 9011 14989 Jane Illingworth         local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007347 Tattenhams                       2016-05-05 0 0           PP52   0
9012 9012 14990 Ben Leslie Mr   male   local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007340 Redhill East             https://static-candidates.democracyclub.org.uk/media/images/images/14990.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   14150.0       PP52   0
9013 9013 14991 Stephen Thomas Bramhall Mr       local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0           PP52   0
9014 9014 14992 Simon John Parnall Mr       local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007335 Kingswood with Burgh Heath                       2016-05-05 0 0           PP52   0
9015 9015 14996 Keith Foreman Mr       local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007330 Chipstead, Hooley and Woodmansterne                       2016-05-05 0 0           PP52   0
9016 9016 15000 David Thomas Powell         local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007332 Horley Central                       2016-05-05 0 0           PP52   0
9017 9017 15001 Tony Schofield         local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007333 Horley East                       2016-05-05 0 0           PP52   0
9018 9018 15003 Philip Abimbola Olanipekun     male   local.reigate-and-banstead.2016-05-05 18 party:52 Conservative and Unionist Party DIW:E05007338 Nork                       2016-05-05 0 0           PP52   0
9019 9019 18769 James Christopher Fowler     Male   local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007329 Banstead Village                       2016-05-05 0 0   25001.0       PP90   0
9020 9020 18770 Pete Kermally         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007329 Banstead Village                       2016-05-05 0 0           PP53   0
9021 9021 18783 Evan Patrick Raymond Gregory         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007330 Chipstead, Hooley and Woodmansterne                       2016-05-05 0 0           PP53   0
9022 9022 18795 Sue Fenton         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007331 Earlswood and Whitebushes                       2016-05-05 0 0           PP63   0
9023 9023 18797 Graham Richard Wildridge         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007331 Earlswood and Whitebushes                       2016-05-05 0 0           PP53   0
9024 9024 18801 Linda Jane Mabbett         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007332 Horley Central                       2016-05-05 0 0           PP53   0
9025 9025 18802 Malcolm Roger Brighting         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007332 Horley Central                       2016-05-05 0 0           PP85   0
9026 9026 18806 Joanna Barnett         local.reigate-and-banstead.2016-05-05 18 ynmp-party:2 Independent DIW:E05007333 Horley East                       2016-05-05 0 0           ynmp-party:2   0
9027 9027 18818 Sarah Jane Finch         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007334 Horley West                       2016-05-05 0 0           PP63   0
9028 9028 18819 André Edward Grant         local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007334 Horley West                       2016-05-05 0 0           PP85   0
9029 9029 18820 Geoffrey Smith         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007334 Horley West                       2016-05-05 0 0           PP53   0
9030 9030 18821 Geoff Southall     Male   local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007334 Horley West                       2016-05-05 0 0   25004.0       PP90   0
9031 9031 18826 Isabella Lane         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007335 Kingswood with Burgh Heath                       2016-05-05 0 0           PP53   0
9032 9032 18827 Malcolm Kemp Savidge         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0           PP53   0
9033 9033 18832 Sarah Josephine Vaci         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0           PP63   0
9034 9034 18837 Stewart James Dack         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007337 Merstham                       2016-05-05 0 0           PP53   0
9035 9035 18838 Chris Howell         local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007337 Merstham                       2016-05-05 0 0           PP90   0
9036 9036 18839 Kenneth Tze Ken Yau         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007337 Merstham                       2016-05-05 0 0           PP63   0
9037 9037 18840 Kimberley Marie Griffin         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007338 Nork                       2016-05-05 0 0           PP53   0
9038 9038 18841 Jonathan Charles White         local.reigate-and-banstead.2016-05-05 18 party:138 Nork Residents' Association DIW:E05007338 Nork                       2016-05-05 0 0           PP138   0
9039 9039 18842 Gregory Clack         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007341 Redhill West                       2016-05-05 0 0           PP53   0
9040 9040 18843 Andrew James Cressy         local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007341 Redhill West                       2016-05-05 0 0           PP90   0
9041 9041 18844 Rob Jarrett         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007341 Redhill West                       2016-05-05 0 0           PP63   0
9042 9042 18845 Soo Abram         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP63   0
9043 9043 18846 Helen Mary Samuel         local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP90   0
9044 9044 18847 Robin Spencer         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP53   0
9045 9045 18848 Christopher Thomas Henry Whinney         local.reigate-and-banstead.2016-05-05 18 ynmp-party:2 Independent DIW:E05007342 Reigate Central                       2016-05-05 0 0           ynmp-party:2   0
9046 9046 18849 Gregory Alec Edwin Ardan     Male   local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007343 Reigate Hill                       2016-05-05 0 0   25005.0       PP90   0
9047 9047 18850 Andrew David Saunders         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007343 Reigate Hill                       2016-05-05 0 0           PP53   0
9048 9048 18851 Moray William Macleod Carey     Male   local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0   25002.0       PP90   0
9049 9049 18852 Mark Peter Collins         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0           PP53   0
9050 9050 18854 Sonja Begley-Moore         local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP90   0
9051 9051 18856 Alistair Patrick Galbraith Morten         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP63   0
9052 9052 18857 Margaret Caroline Deirdre Walkling         local.reigate-and-banstead.2016-05-05 18 ynmp-party:2 Independent DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           ynmp-party:2   0
9053 9053 18858 Jacob David Thomas Bonner         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007347 Tattenhams                       2016-05-05 0 0           PP53   0
9054 9054 18859 Jill Scott Bray         local.reigate-and-banstead.2016-05-05 18 party:141 Tattenhams Residents' Association DIW:E05007347 Tattenhams                       2016-05-05 0 0           PP141   0
9055 9055 18860 Roger Baizeley Ponsford         local.reigate-and-banstead.2016-05-05 18 party:63 Green Party DIW:E05007347 Tattenhams     https://surrey.greenparty.org.uk/elections.html                 2016-05-05 0 0   30562.0       PP63   0
9056 9056 25007 Stuart Holmes     Male   local.reigate-and-banstead.2016-05-05 18 party:90 Liberal Democrats DIW:E05007340 Redhill East                       2016-05-05 0 0   14149.0       PP90   0
9057 9057 30691 David Anthony Burnley         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0   18855.0       PP53   0
9058 9058 30697 Tom Turner         local.reigate-and-banstead.2016-05-05 18 party:53 Labour Party DIW:E05007333 Horley East                       2016-05-05 0 0   18807.0       PP53   0
9059 9059 40178 Joe Fox     male 1948.0 local.reigate-and-banstead.2016-05-05 18 party:85 UK Independence Party (UKIP) DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0   3891.0       PP85   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 7.608ms · Data license: CC-BY-SA · Data source: Democracy Club