home / democracyclub

democracyclub

Custom SQL query returning 101 rows

Query parameters

This data as JSON, CSV

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