home / democracyclub

candidates

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

163 rows where election = 31

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, 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
9817 9817 1229 John Wilkinson     male   local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001031 Silverwood ward                       2016-05-05 0 0           PP85   0
9818 9818 5201 Allen Cowles     male   local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001032 Sitwell ward                       2016-05-05 0 0           PP85   0
9819 9819 5911 Michael Naughton     male   local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001023 Holderness ward     https://www.southyorkshireconservatives.org.uk/people/michael-naughton-brightside-hillsborough       https://static-candidates.democracyclub.org.uk/media/images/5547b2d81086a8201ec0cff7.png   profile-photo andylolz From party PPC page: https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Naughton_Michael.aspx 2016-05-05 0 0   18416.0       PP52   0
9820 9820 6589 Janice Middleton Ms   Female   local.rotherham.2016-05-05 31 party:90 Liberal Democrats MTW:E05001025 Keppel ward     http://www.libdems.org.uk/janice_middleton http://rotherhamandbarnsleylibdems.org.uk/en/     https://static-candidates.democracyclub.org.uk/media/images/images/6589.png   profile-photo kdcm87 http://www.libdems.org.uk/janice_middleton 2016-05-05 0 0           PP90   0
9821 9821 6739 Lee Hunter     Male   local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001038 Wingfield ward             https://static-candidates.democracyclub.org.uk/media/images/5525ef81413cb4432adffa58.png   profile-photo JPCarrington Profile picture as featured on official party PPC pages here: http://www.myukip.com/parliamentary-candidates-a-b.html 2016-05-05 0 0   18636.0       PP85   0
9822 9822 7097 Pat McLaughlin     Male   local.rotherham.2016-05-05 31 party:804 Trade Unionist and Socialist Coalition MTW:E05001030 Rotherham West ward     http://www.tusc.org.uk/txt/332.pdf                 2016-05-05 0 0           PP804   0
9823 9823 14016 Jenny Andrews         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001022 Hellaby ward   1.0                   2016-05-05 0 0           PP53   0
9824 9824 14017 Brian Cutts         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001022 Hellaby ward   1.0                   2016-05-05 0 0           PP85   0
9825 9825 14018 Andrew James Fenwick-Green         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001022 Hellaby ward                       2016-05-05 0 0           PP53   0
9826 9826 14019 Richard Fleming         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001022 Hellaby ward                       2016-05-05 0 0           PP85   0
9827 9827 14020 Janet Law         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001022 Hellaby ward                       2016-05-05 0 0           PP53   0
9828 9828 14021 Anne Middleton         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001022 Hellaby ward                       2016-05-05 0 0           PP52   0
9829 9829 14022 John Turner         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001022 Hellaby ward   1.0                   2016-05-05 0 0           PP85   0
9830 9830 14023 Rebecca Louise Whyman         local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05001022 Hellaby ward                       2016-05-05 0 0           PP63   0
9831 9831 14830 Keith Hunter         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001030 Rotherham West ward                       2016-05-05 0 0           PP52   0
9832 9832 14831 Pat Jarvis         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001030 Rotherham West ward   1.0                   2016-05-05 0 0           PP53   0
9833 9833 14832 Ian Paul Jones         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001030 Rotherham West ward   1.0                   2016-05-05 0 0           PP53   0
9834 9834 14833 Eve Rose Keenan         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001030 Rotherham West ward   1.0                   2016-05-05 0 0           PP53   0
9835 9835 14834 Maureen Vines         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001030 Rotherham West ward                       2016-05-05 0 0           PP85   0
9836 9836 14863 Wendy Cooksey         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001029 Rotherham East ward                       2016-05-05 0 0           PP53   0
9837 9837 14864 Barry Dodson         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05001029 Rotherham East ward                       2016-05-05 0 0           ynmp-party:2   0
9838 9838 14865 Deborah Fenwick-Green         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001029 Rotherham East ward                       2016-05-05 0 0           PP53   0
9839 9839 14866 Tajamal Khan         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001029 Rotherham East ward                       2016-05-05 0 0           PP53   0
9840 9840 14867 Marilyn Marshall         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001029 Rotherham East ward                       2016-05-05 0 0           PP52   0
9841 9841 14868 Richard William Penycate         local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05001029 Rotherham East ward                       2016-05-05 0 0           PP63   0
9842 9842 14869 Courtney Lea Webster         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001029 Rotherham East ward                       2016-05-05 0 0           PP85   0
9843 9843 18322 Lauren Amy Edith Astbury         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           PP53   0
9844 9844 18323 Phillip John Clarke         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           PP85   0
9845 9845 18324 Charles David Foulstone         local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           PP63   0
9846 9846 18325 Bernard Froggatt         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           PP85   0
9847 9847 18326 Jonathan Charles Ireland         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           PP53   0
9848 9848 18327 Clive Robert Jepson         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           ynmp-party:2   0
9849 9849 18328 Anthony John Kavanagh         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           PP52   0
9850 9850 18329 Christine Sadler         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           ynmp-party:2   0
9851 9851 18330 Katherine Wilson         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05008935 Anston and Woodsetts ward                       2016-05-05 0 0           PP53   0
9852 9852 18349 Saghir Alam         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001019 Boston Castle ward   1.0                   2016-05-05 0 0           PP53   0
9853 9853 18350 Christopher James Edward Bingham         local.rotherham.2016-05-05 31 party:804 Trade Unionist and Socialist Coalition MTW:E05001019 Boston Castle ward                       2016-05-05 0 0           PP804   0
9854 9854 18351 Christian Carl Backer Kramer         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001019 Boston Castle ward                       2016-05-05 0 0           PP52   0
9855 9855 18352 Rose McNeely         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001019 Boston Castle ward   1.0                   2016-05-05 0 0           PP53   0
9856 9856 18353 Lisa Michelle Raby         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001019 Boston Castle ward                       2016-05-05 0 0           PP85   0
9857 9857 18354 Taiba Yasseen         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001019 Boston Castle ward   1.0                   2016-05-05 0 0           PP53   0
9858 9858 18363 Shabana Ahmed         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001020 Brinsworth and Catcliffe ward   1.0                   2016-05-05 0 0           PP53   0
9859 9859 18364 Alan Buckley         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001020 Brinsworth and Catcliffe ward   1.0                   2016-05-05 0 0           PP53   0
9860 9860 18365 Adam Jonathon Carter Dr   Male   local.rotherham.2016-05-05 31 party:90 Liberal Democrats MTW:E05001020 Brinsworth and Catcliffe ward                       2016-05-05 0 0           PP90   0
9861 9861 18366 Ruth Pauline Marsh         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001020 Brinsworth and Catcliffe ward                       2016-05-05 0 0           PP52   0
9862 9862 18367 Andrew Scott Roddison         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001020 Brinsworth and Catcliffe ward   1.0                   2016-05-05 0 0           PP53   0
9863 9863 18368 Nigel Gary Simpson         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001020 Brinsworth and Catcliffe ward                       2016-05-05 0 0           PP85   0
9864 9864 18396 Thomas Joseph Angel         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05008936 Dinnington ward                       2016-05-05 0 0           PP52   0
9865 9865 18397 Les Clarke         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05008936 Dinnington ward                       2016-05-05 0 0           ynmp-party:2   0
9866 9866 18398 Ian Kenneth Finnie         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05008936 Dinnington ward                       2016-05-05 0 0           PP85   0
9867 9867 18399 Shaun Grice         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05008936 Dinnington ward                       2016-05-05 0 0           PP85   0
9868 9868 18400 Wendy Hamilton         local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05008936 Dinnington ward                       2016-05-05 0 0           PP63   0
9869 9869 18401 Jean Hart         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05008936 Dinnington ward                       2016-05-05 0 0           ynmp-party:2   0
9870 9870 18402 Jeanette Martin Mallinder         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05008936 Dinnington ward                       2016-05-05 0 0           PP53   0
9871 9871 18403 Dave Smith         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05008936 Dinnington ward                       2016-05-05 0 0           ynmp-party:2   0
9872 9872 18404 Simon Andrew Tweed         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05008936 Dinnington ward                       2016-05-05 0 0           PP53   0
9873 9873 18405 John Vjestica         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05008936 Dinnington ward                       2016-05-05 0 0           PP53   0
9874 9874 18412 Ian Barkley         local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05001023 Holderness ward                       2016-05-05 0 0           PP63   0
9875 9875 18413 Michael Elliott         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001023 Holderness ward   1.0                   2016-05-05 0 0           PP85   0
9876 9876 18414 Darren Jason Louis Hughes         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001023 Holderness ward                       2016-05-05 0 0           PP53   0
9877 9877 18415 John Jenkins         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001023 Holderness ward                       2016-05-05 0 0           PP85   0
9878 9878 18417 Lyndsay Pitchley         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001023 Holderness ward   1.0                   2016-05-05 0 0           PP53   0
9879 9879 18418 Robert Paul Taylor         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001023 Holderness ward   1.0                   2016-05-05 0 0           PP53   0
9880 9880 18422 Tyrrell Jane Bingham         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001024 Hoober ward                       2016-05-05 0 0           PP52   0
9881 9881 18423 Amanda Cowles         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001024 Hoober ward                       2016-05-05 0 0           PP85   0
9882 9882 18424 Denise Lelliott         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001024 Hoober ward   1.0                   2016-05-05 0 0           PP53   0
9883 9883 18425 David John Roche         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001024 Hoober ward   1.0                   2016-05-05 0 0           PP53   0
9884 9884 18426 Steven Scutt         local.rotherham.2016-05-05 31 party:90 Liberal Democrats MTW:E05001024 Hoober ward                       2016-05-05 0 0           PP90   0
9885 9885 18427 Brian Steele         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001024 Hoober ward   1.0                   2016-05-05 0 0           PP53   0
9886 9886 18439 Neil Adshead         local.rotherham.2016-05-05 31 party:804 Trade Unionist and Socialist Coalition MTW:E05001025 Keppel ward                       2016-05-05 0 0           PP804   0
9887 9887 18440 Jo Baker-Rogers         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001025 Keppel ward                       2016-05-05 0 0           PP53   0
9888 9888 18441 Maggi Clark         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001025 Keppel ward   1.0                   2016-05-05 0 0           PP53   0
9889 9889 18442 David Cutts         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001025 Keppel ward   1.0                   2016-05-05 0 0           PP85   0
9890 9890 18443 John Foden         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001025 Keppel ward                       2016-05-05 0 0           PP53   0
9891 9891 18444 Paul Hague         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001025 Keppel ward   1.0                   2016-05-05 0 0           PP85   0
9892 9892 18445 Thomas Hill     Non binary 1993.0 local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05001025 Keppel ward             https://static-candidates.democracyclub.org.uk/media/images/images/18445_ERNiGSe.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
9893 9893 18446 Christine Houghton         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001025 Keppel ward                       2016-05-05 0 0           PP85   0
9894 9894 18447 Peter Robert Key         local.rotherham.2016-05-05 31 party:2120 Yorkshire First MTW:E05001025 Keppel ward                       2016-05-05 0 0           PP2120   0
9895 9895 18448 Kenneth Rodney Marshall         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001025 Keppel ward                       2016-05-05 0 0           PP52   0
9896 9896 18456 Simon Ashley Ball         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05001026 Maltby ward                       2016-05-05 0 0           ynmp-party:2   0
9897 9897 18457 Christine Beaumont         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001026 Maltby ward   1.0                   2016-05-05 0 0           PP53   0
9898 9898 18458 Shaz Biggin         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05001026 Maltby ward                       2016-05-05 0 0           ynmp-party:2   0
9899 9899 18459 Joy Bradford         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05001026 Maltby ward                       2016-05-05 0 0           ynmp-party:2   0
9900 9900 18460 Jon Carratt         local.rotherham.2016-05-05 31 ynmp-party:2 Independent MTW:E05001026 Maltby ward                       2016-05-05 0 0           ynmp-party:2   0
9901 9901 18461 Roger Jarvis         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001026 Maltby ward                       2016-05-05 0 0           PP85   0
9902 9902 18462 Richard Price         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001026 Maltby ward   1.0                   2016-05-05 0 0           PP53   0
9903 9903 18463 Amy Rushforth         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001026 Maltby ward   1.0                   2016-05-05 0 0           PP53   0
9904 9904 18464 Jane Rosemary Salt         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001026 Maltby ward                       2016-05-05 0 0           PP52   0
9905 9905 18470 Bob Bird         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001027 Rawmarsh ward   1.0                   2016-05-05 0 0           PP53   0
9906 9906 18471 Sandra Marriott         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001027 Rawmarsh ward   1.0                   2016-05-05 0 0           PP85   0
9907 9907 18472 David Roy Sheppard         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001027 Rawmarsh ward   1.0                   2016-05-05 0 0           PP53   0
9908 9908 18473 Josephine Margaret Taylor         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001027 Rawmarsh ward                       2016-05-05 0 0           PP52   0
9909 9909 18474 Emma Wallis         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001027 Rawmarsh ward                       2016-05-05 0 0           PP53   0
9910 9910 18475 Emily West         local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05001027 Rawmarsh ward                       2016-05-05 0 0           PP63   0
9911 9911 18488 Leon Allcock         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001028 Rother Vale ward   1.0                   2016-05-05 0 0           PP53   0
9912 9912 18489 Amy Caroline Brookes         local.rotherham.2016-05-05 31 party:53 Labour Party MTW:E05001028 Rother Vale ward   1.0                   2016-05-05 0 0           PP53   0
9913 9913 18490 Martin Brown         local.rotherham.2016-05-05 31 party:63 Green Party MTW:E05001028 Rother Vale ward                       2016-05-05 0 0           PP63   0
9914 9914 18491 Matthew Eyre         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001028 Rother Vale ward                       2016-05-05 0 0           PP85   0
9915 9915 18492 Greg Reynolds         local.rotherham.2016-05-05 31 party:85 UK Independence Party (UKIP) MTW:E05001028 Rother Vale ward                       2016-05-05 0 0           PP85   0
9916 9916 18493 William Salt         local.rotherham.2016-05-05 31 party:52 Conservative and Unionist Party MTW:E05001028 Rother Vale ward                       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 9.262ms · Data license: CC-BY-SA · Data source: Democracy Club