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
12187 4899 Arthur Frank Stevens     male   57 party:85 UK Independence Party (UKIP) DIW:E05004865 Welwyn East ward             https://static-candidates.democracyclub.org.uk/media/images/553c9a13e22f98bc5d30fa58.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/ArthurUKIP 2016-05-05 0 0   18255.0       PP85   0
12188 13979 John Edward Blackburn         57 party:90 Liberal Democrats DIW:E05004866 Welwyn West ward                       2016-05-05 0 0           PP90   0
12189 13980 Tony Crump         57 party:53 Labour Party DIW:E05004866 Welwyn West ward                       2016-05-05 0 0           PP53   0
12190 13981 Tony Kingsbury         57 party:52 Conservative and Unionist Party DIW:E05004866 Welwyn West ward                       2016-05-05 0 0           PP52   0
12191 13982 Sandra Anne Kyriakides         57 ynmp-party:2 Independent DIW:E05004866 Welwyn West ward                       2016-05-05 0 0           ynmp-party:2   0
12192 13983 Kay Marion Mason         57 party:90 Liberal Democrats DIW:E05004866 Welwyn West ward                       2016-05-05 0 0           PP90   0
12193 13984 Mandy Perkins         57 party:52 Conservative and Unionist Party DIW:E05004866 Welwyn West ward                       2016-05-05 0 0           PP52   0
12194 13985 Nick Taylor         57 party:52 Conservative and Unionist Party DIW:E05004866 Welwyn West ward                       2016-05-05 0 0           PP52   0
12195 14836 Michael Anscombe         57 party:90 Liberal Democrats DIW:E05004850 Brookmans Park and Little Heath ward                       2016-05-05 0 0           PP90   0
12196 14837 Nigel Anthony van Someren Bain         57 party:90 Liberal Democrats DIW:E05004850 Brookmans Park and Little Heath ward                       2016-05-05 0 0           PP90   0
12197 14838 Jenny Blumsom         57 party:90 Liberal Democrats DIW:E05004850 Brookmans Park and Little Heath ward                       2016-05-05 0 0           PP90   0
12198 14839 Jonathan Stephen Findlay Boulton         57 party:52 Conservative and Unionist Party DIW:E05004850 Brookmans Park and Little Heath ward   1.0                   2016-05-05 0 0           PP52   0
12199 14840 Stephen John Boulton         57 party:52 Conservative and Unionist Party DIW:E05004850 Brookmans Park and Little Heath ward   1.0                   2016-05-05 0 0           PP52   0
12200 14841 Peter John Costello         57 party:53 Labour Party DIW:E05004850 Brookmans Park and Little Heath ward                       2016-05-05 0 0           PP53   0
12201 14842 John William Dean         57 party:52 Conservative and Unionist Party DIW:E05004850 Brookmans Park and Little Heath ward   1.0                   2016-05-05 0 0           PP52   0
12202 14843 James Robert Dolan         57 party:53 Labour Party DIW:E05004850 Brookmans Park and Little Heath ward                       2016-05-05 0 0           PP53   0
12203 14844 John Richard Eames-Petersen         57 party:53 Labour Party DIW:E05004850 Brookmans Park and Little Heath ward                       2016-05-05 0 0           PP53   0
12204 18052 Irene Hilda Dean         57 party:52 Conservative and Unionist Party DIW:E05004860 Northaw and Cuffley ward                       2016-05-05 0 0           PP52   0
12205 18053 Robina Helen Durrant         57 party:90 Liberal Democrats DIW:E05004860 Northaw and Cuffley ward                       2016-05-05 0 0           PP90   0
12206 18055 Liz Johnson         57 party:90 Liberal Democrats DIW:E05004860 Northaw and Cuffley ward                       2016-05-05 0 0           PP90   0
12207 18056 Graham Morris MacArthur         57 party:53 Labour Party DIW:E05004860 Northaw and Cuffley ward                       2016-05-05 0 0           PP53   0
12208 18057 George Michaelides         57 party:52 Conservative and Unionist Party DIW:E05004860 Northaw and Cuffley ward                       2016-05-05 0 0           PP52   0
12209 18058 Bernard John Sarson         57 party:52 Conservative and Unionist Party DIW:E05004860 Northaw and Cuffley ward                       2016-05-05 0 0           PP52   0
12210 18067 Lynne Allison         57 party:63 Green Party DIW:E05004851 Haldens ward                       2016-05-05 0 0           PP63   0
12211 18068 Alex Benakis         57 party:90 Liberal Democrats DIW:E05004851 Haldens ward                       2016-05-05 0 0           PP90   0
12212 18069 Chris Corbey-West         57 party:90 Liberal Democrats DIW:E05004851 Haldens ward                       2016-05-05 0 0   27105.0       PP90   0
12213 18070 Barbara Ann Fitzsimon         57 party:52 Conservative and Unionist Party DIW:E05004851 Haldens ward   1.0                   2016-05-05 0 0           PP52   0
12214 18071 Peter Hebden         57 party:52 Conservative and Unionist Party DIW:E05004851 Haldens ward                       2016-05-05 0 0           PP52   0
12215 18072 Mike Larkins         57 party:53 Labour Party DIW:E05004851 Haldens ward   1.0                   2016-05-05 0 0           PP53   0
12216 18073 Tara Mary Lyons         57 party:53 Labour Party DIW:E05004851 Haldens ward                       2016-05-05 0 0           PP53   0
12217 18074 Lucy Musk         57 party:53 Labour Party DIW:E05004851 Haldens ward                       2016-05-05 0 0           PP53   0
12218 18075 Malcolm Robert Spinks         57 party:52 Conservative and Unionist Party DIW:E05004851 Haldens ward   1.0                   2016-05-05 0 0           PP52   0
12219 18076 Sandra Jean Ward         57 party:90 Liberal Democrats DIW:E05004851 Haldens ward                       2016-05-05 0 0           PP90   0
12220 18077 Nick Atkinson         57 party:53 Labour Party DIW:E05004852 Handside ward                       2016-05-05 0 0           PP53   0
12221 18078 Rachel Lesley Basch         57 party:90 Liberal Democrats DIW:E05004852 Handside ward                       2016-05-05 0 0           PP90   0
12222 18079 Helen Elizabeth Bromley         57 party:52 Conservative and Unionist Party DIW:E05004852 Handside ward                       2016-05-05 0 0           PP52   0
12223 18080 Graham Eric Dowler         57 party:52 Conservative and Unionist Party DIW:E05004852 Handside ward                       2016-05-05 0 0           PP52   0
12224 18081 Tony Grice         57 party:53 Labour Party DIW:E05004852 Handside ward                       2016-05-05 0 0           PP53   0
12225 18082 Darren Lewis         57 party:53 Labour Party DIW:E05004852 Handside ward                       2016-05-05 0 0           PP53   0
12226 18084 Cecile May Raw         57 party:63 Green Party DIW:E05004852 Handside ward                       2016-05-05 0 0           PP63   0
12227 18085 Ayesha Rohale     Female   57 party:90 Liberal Democrats DIW:E05004852 Handside ward     https://welhatlibdems.org.uk/en/page/ayesha-rohale-panshanger-candidate-2017       https://static-candidates.democracyclub.org.uk/media/images/images/18085.png   profile-photo brycx https://welhatlibdems.org.uk/en/page/ayesha-rohale-panshanger-candidate-2017 2016-05-05 0 0           PP90   0
12228 18086 Fiona Thomson         57 party:52 Conservative and Unionist Party DIW:E05004852 Handside ward                       2016-05-05 0 0           PP52   0
12229 18090 Maureen Janet Cook         57 party:53 Labour Party DIW:E05004853 Hatfield Central ward   1.0                   2016-05-05 0 0   21104.0       PP53   0
12230 18091 James Samuel Crosse         57 party:52 Conservative and Unionist Party DIW:E05004853 Hatfield Central ward                       2016-05-05 0 0           PP52   0
12231 18092 John Adam Edwards         57 party:90 Liberal Democrats DIW:E05004853 Hatfield Central ward                       2016-05-05 0 0           PP90   0
12232 18093 Glyn Charles Hayes         57 party:53 Labour Party DIW:E05004853 Hatfield Central ward   1.0                   2016-05-05 0 0           PP53   0
12233 18094 Bukky Olawoyin         57 party:52 Conservative and Unionist Party DIW:E05004853 Hatfield Central ward                       2016-05-05 0 0           PP52   0
12234 18095 Karen Elizabeth Richardson         57 party:90 Liberal Democrats DIW:E05004853 Hatfield Central ward                       2016-05-05 0 0           PP90   0
12235 18096 Pankit Shah         57 party:53 Labour Party DIW:E05004853 Hatfield Central ward   1.0                   2016-05-05 0 0           PP53   0
12236 18097 Charles David Perry Walton         57 party:90 Liberal Democrats DIW:E05004853 Hatfield Central ward                       2016-05-05 0 0           PP90   0
12237 18098 Ronald Leonard Wheeler         57 party:52 Conservative and Unionist Party DIW:E05004853 Hatfield Central ward                       2016-05-05 0 0           PP52   0
12238 18107 Lenny Brandon         57 party:53 Labour Party DIW:E05004854 Hatfield East ward   1.0                   2016-05-05 0 0           PP53   0
12239 18108 Caroline Ruth Gillett         57 party:52 Conservative and Unionist Party DIW:E05004854 Hatfield East ward   1.0                   2016-05-05 0 0           PP52   0
12240 18109 Ian Gregory         57 party:63 Green Party DIW:E05004854 Hatfield East ward                       2016-05-05 0 0           PP63   0
12241 18110 Kerstin Birgit Holman         57 party:52 Conservative and Unionist Party DIW:E05004854 Hatfield East ward   1.0                   2016-05-05 0 0           PP52   0
12242 18111 Caron Anne Juggins         57 ynmp-party:2 Independent DIW:E05004854 Hatfield East ward                       2016-05-05 0 0           ynmp-party:2   0
12243 18112 Philip John Knott         57 party:53 Labour Party DIW:E05004854 Hatfield East ward                       2016-05-05 0 0           PP53   0
12244 18113 Manoj Kumar         57 party:52 Conservative and Unionist Party DIW:E05004854 Hatfield East ward                       2016-05-05 0 0           PP52   0
12245 18114 Lis Meyland-Smith         57 party:90 Liberal Democrats DIW:E05004854 Hatfield East ward                       2016-05-05 0 0           PP90   0
12246 18115 Christianne Sayers     female   57 party:63 Green Party DIW:E05004854 Hatfield East ward     https://my.greenparty.org.uk/candidates/106281 https://welwynhatfield.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/18115.png   profile-photo brycx Used in local news: http://www.whtimes.co.uk/news/general-election-2017-local-teacher-stands-for-greens-in-welwyn-hatfield-1-5005364 2016-05-05 0 0   25610.0       PP63   0
12247 18116 Oliver Sayers         57 party:63 Green Party DIW:E05004854 Hatfield East ward                       2016-05-05 0 0   27108.0       PP63   0
12248 18117 Bhumi Zhaveri         57 party:53 Labour Party DIW:E05004854 Hatfield East ward                       2016-05-05 0 0           PP53   0
12249 18123 Jack Adams         57 party:52 Conservative and Unionist Party DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP52   0
12250 18124 Sheila Jean Archer         57 party:90 Liberal Democrats DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP90   0
12251 18125 Simon John Archer         57 party:90 Liberal Democrats DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP90   0
12252 18126 Tom Boon         57 party:52 Conservative and Unionist Party DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP52   0
12253 18127 James Broach     male   57 party:53 Labour Party DIW:E05011063 Hatfield South West             https://static-candidates.democracyclub.org.uk/media/images/images/18127.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   21113.0       PP53   0
12254 18128 John Christopher Fitzpatrick         57 party:53 Labour Party DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP53   0
12255 18129 Sanjay Gadhvi         57 party:85 UK Independence Party (UKIP) DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP85   0
12256 18130 Hazel Marion Laming         57 party:90 Liberal Democrats DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP90   0
12257 18131 David John Perkins         57 party:52 Conservative and Unionist Party DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP52   0
12258 18132 Kieran Michael Thorpe         57 party:53 Labour Party DIW:E05011063 Hatfield South West                       2016-05-05 0 0           PP53   0
12259 18148 Graham Martyn Beevers         57 party:53 Labour Party DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0           PP53   0
12260 18149 Duncan James Bell         57 party:52 Conservative and Unionist Party DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0           PP52   0
12261 18150 Margaret Anne Eames-Petersen         57 party:53 Labour Party DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0   21111.0       PP53   0
12262 18151 Ros Edwards         57 party:90 Liberal Democrats DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0           PP90   0
12263 18152 Howard Morgan         57 party:52 Conservative and Unionist Party DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0           PP52   0
12264 18153 Matthew John Quenet         57 party:90 Liberal Democrats DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0           PP90   0
12265 18154 Jane Quinton     Female   57 party:90 Liberal Democrats DIW:E05004856 Hatfield Villages ward     https://welhatlibdems.org.uk/en/page/jane-quinton-hatfield-north-candidate-2017       https://static-candidates.democracyclub.org.uk/media/images/images/24389.png   profile-photo brycx https://welhatlibdems.org.uk/en/page/jane-quinton-hatfield-north-candidate-2017 2016-05-05 0 0   24389.0       PP90   0
12266 18155 Lynne Michele Sparks         57 party:52 Conservative and Unionist Party DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0           PP52   0
12267 18156 Alexander David Widger         57 party:53 Labour Party DIW:E05004856 Hatfield Villages ward                       2016-05-05 0 0           PP53   0
12268 18161 Jonquil Basch         57 party:90 Liberal Democrats DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP90   0
12269 18162 Konrad Basch         57 party:90 Liberal Democrats DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP90   0
12270 18163 Margaret Birleson         57 party:53 Labour Party DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP53   0
12271 18164 Lynn Anne Chesterman         57 party:53 Labour Party DIW:E05004858 Hollybush ward                       2016-05-05 0 0   21116.0       PP53   0
12272 18165 James Andrew Milliken         57 party:85 UK Independence Party (UKIP) DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP85   0
12273 18166 Nick Pace         57 party:52 Conservative and Unionist Party DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP52   0
12274 18167 Syam Puli         57 party:52 Conservative and Unionist Party DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP52   0
12275 18168 Drew Robert Richardson         57 party:52 Conservative and Unionist Party DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP52   0
12276 18169 Astrid Carle Thorpe         57 party:53 Labour Party DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP53   0
12277 18170 Paul Graham Wilson         57 party:90 Liberal Democrats DIW:E05004858 Hollybush ward                       2016-05-05 0 0           PP90   0
12278 18179 Laurence Geoffrey Brown         57 party:90 Liberal Democrats DIW:E05004859 Howlands ward                       2016-05-05 0 0           PP90   0
12279 18180 Kamala Chandrasekaran         57 party:52 Conservative and Unionist Party DIW:E05004859 Howlands ward                       2016-05-05 0 0           PP52   0
12280 18181 Alan Chesterman         57 party:53 Labour Party DIW:E05004859 Howlands ward                       2016-05-05 0 0   21103.0       PP53   0
12281 18182 Max Peter Holloway         57 party:53 Labour Party DIW:E05004859 Howlands ward                       2016-05-05 0 0           PP53   0
12282 18183 Dean James Milliken     male   57 party:85 UK Independence Party (UKIP) DIW:E05004859 Howlands ward     http://ukipwelwynhatfield.org.uk/team/dean-milliken/       https://static-candidates.democracyclub.org.uk/media/images/images/18183.png   profile-photo sjorford http://ukipwelwynhatfield.org.uk/team/dean-milliken/ 2016-05-05 0 0           PP85   0
12283 18184 Mark Alexander Smith         57 party:52 Conservative and Unionist Party DIW:E05004859 Howlands ward                       2016-05-05 0 0           PP52   0
12284 18185 Stan Tunstall         57 ynmp-party:2 Independent DIW:E05004859 Howlands ward                       2016-05-05 0 0           ynmp-party:2   0
12285 18186 Michael Damian Joseph Tuohy         57 party:90 Liberal Democrats DIW:E05004859 Howlands ward                       2016-05-05 0 0           PP90   0
12286 18187 Pauline Jill Weston         57 party:53 Labour Party DIW:E05004859 Howlands ward                       2016-05-05 0 0   21114.0       PP53   0
12287 18188 Annalisa Dorothy Yeowell         57 party:52 Conservative and Unionist Party DIW:E05004859 Howlands ward                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.026ms