home / democracyclub

democracyclub

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