home / democracyclub

democracyclub

Custom SQL query returning 97 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
13353 1964 Peter Harper     male   75 party:85 UK Independence Party (UKIP) MTW:E05000946 Molyneux                       2016-05-05 0 0           PP85   0
13354 2627 Pat Gaskell     female   75 party:85 UK Independence Party (UKIP) MTW:E05000947 Netherton and Orrell                       2016-05-05 0 0           PP85   0
13355 3751 Terry Durrance Mr   male 1944.0 75 party:85 UK Independence Party (UKIP) MTW:E05000941 Kew       http://ukipnw.org.uk/branches/merseyside/ukip-southport/               2016-05-05 0 0   16157.0       PP85   0
13356 3978 John Gibson     male   75 party:90 Liberal Democrats MTW:E05000944 Manor                       2016-05-05 0 0           PP90   0
13357 7085 Laurence Rankin     Male   75 party:63 Green Party MTW:E05000947 Netherton and Orrell     https://my.greenparty.org.uk/candidates/106212       https://static-candidates.democracyclub.org.uk/media/images/551ab471e2ac8b7333e6a280.png   profile-photo rgwillis   2016-05-05 0 0   16214.0       PP63   0
13358 16087 Duncan Browne         75 party:85 UK Independence Party (UKIP) MTW:E05000932 Ainsdale                       2016-05-05 0 0           PP85   0
13359 16088 Mhairi McLeod Johnstone Doyle     female   75 party:53 Labour Party MTW:E05000932 Ainsdale                       2016-05-05 0 0   41394.0       PP53   0
13360 16089 Barbara Ann Dutton         75 party:63 Green Party MTW:E05000932 Ainsdale                       2016-05-05 0 0           PP63   0
13361 16090 Jamie Halsall         75 party:52 Conservative and Unionist Party MTW:E05000932 Ainsdale                       2016-05-05 0 0           PP52   0
13362 16091 Lynne Thompson         75 party:90 Liberal Democrats MTW:E05000932 Ainsdale   1.0                   2016-05-05 0 0           PP90   0
13363 16095 Bernhard Frank         75 party:63 Green Party MTW:E05000933 Birkdale                       2016-05-05 0 0           PP63   0
13364 16096 Linda Julia Ann Gunn-Russo         75 party:85 UK Independence Party (UKIP) MTW:E05000933 Birkdale                       2016-05-05 0 0           PP85   0
13365 16097 Richard Ronald Hands         75 party:90 Liberal Democrats MTW:E05000933 Birkdale   1.0                   2016-05-05 0 0           PP90   0
13366 16098 John Charles Lyon-Taylor         75 party:52 Conservative and Unionist Party MTW:E05000933 Birkdale                       2016-05-05 0 0           PP52   0
13367 16099 Ged Wright         75 party:53 Labour Party MTW:E05000933 Birkdale                       2016-05-05 0 0           PP53   0
13368 16103 Aaron Hugh Ellis         75 party:52 Conservative and Unionist Party MTW:E05000934 Blundellsands                       2016-05-05 0 0           PP52   0
13369 16104 Diane Elizabeth Roscoe     female   75 party:53 Labour Party MTW:E05000934 Blundellsands   1.0                   2016-05-05 0 0           PP53   0
13370 16105 Michael James Walsh         75 party:63 Green Party MTW:E05000934 Blundellsands                       2016-05-05 0 0           PP63   0
13371 16113 David William Collins         75 party:63 Green Party MTW:E05000935 Cambridge                       2016-05-05 0 0           PP63   0
13372 16114 Stephen James Jowett         75 party:53 Labour Party MTW:E05000935 Cambridge                       2016-05-05 0 0           PP53   0
13373 16115 Pat Keith         75 party:90 Liberal Democrats MTW:E05000935 Cambridge   1.0                   2016-05-05 0 0           PP90   0
13374 16116 Jordan Thomas Shandley         75 party:52 Conservative and Unionist Party MTW:E05000935 Cambridge                       2016-05-05 0 0           PP52   0
13375 16117 Michael Skarratts         75 party:85 UK Independence Party (UKIP) MTW:E05000935 Cambridge                       2016-05-05 0 0           PP85   0
13376 16126 Helen Louise Barber         75 party:52 Conservative and Unionist Party MTW:E05000936 Church                       2016-05-05 0 0           PP52   0
13377 16127 Mike Carter     male   75 party:63 Green Party MTW:E05000936 Church     https://my.greenparty.org.uk/candidates/106170 https://sefton.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/16127.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106170 2016-05-05 0 0           PP63   0
13378 16128 Paul Paschal Cummins         75 party:53 Labour Party MTW:E05000936 Church   1.0                   2016-05-05 0 0           PP53   0
13379 16129 Alwynne Ann Cartmell         75 party:63 Green Party MTW:E05000937 Derby                       2016-05-05 0 0           PP63   0
13380 16130 Susan Brenda Hughes         75 party:85 UK Independence Party (UKIP) MTW:E05000937 Derby                       2016-05-05 0 0           PP85   0
13381 16131 Angela Rankin         75 party:52 Conservative and Unionist Party MTW:E05000937 Derby                       2016-05-05 0 0           PP52   0
13382 16132 Anne Margaret Thompson         75 party:53 Labour Party MTW:E05000937 Derby   1.0                   2016-05-05 0 0           PP53   0
13383 16137 Jacky Bliss         75 party:52 Conservative and Unionist Party MTW:E05000938 Duke's                       2016-05-05 0 0           PP52   0
13384 16138 Tony Dawson         75 party:90 Liberal Democrats MTW:E05000938 Duke's   1.0                   2016-05-05 0 0           PP90   0
13385 16139 Bernie Draper         75 party:63 Green Party MTW:E05000938 Duke's                       2016-05-05 0 0           PP63   0
13386 16140 Frank Hanley         75 party:53 Labour Party MTW:E05000938 Duke's                       2016-05-05 0 0           PP53   0
13387 16141 Matthew James Hubbard         75 party:85 UK Independence Party (UKIP) MTW:E05000938 Duke's                       2016-05-05 0 0           PP85   0
13388 16144 Lynne Margaret Bold         75 party:52 Conservative and Unionist Party MTW:E05000939 Ford                       2016-05-05 0 0           PP52   0
13389 16145 Alan De Ledger St Claire         75 party:63 Green Party MTW:E05000939 Ford                       2016-05-05 0 0           PP63   0
13390 16146 Paulette Lappin         75 party:53 Labour Party MTW:E05000939 Ford   1.0                   2016-05-05 0 0           PP53   0
13391 16147 Philip James Wordley         75 party:85 UK Independence Party (UKIP) MTW:E05000939 Ford                       2016-05-05 0 0           PP85   0
13392 16150 Alf Doran         75 party:53 Labour Party MTW:E05000940 Harington                       2016-05-05 0 0           PP53   0
13393 16151 Stephen Thomas McCluskie         75 party:90 Liberal Democrats MTW:E05000940 Harington                       2016-05-05 0 0           PP90   0
13394 16152 Michael Ronald Pitt     male   75 party:52 Conservative and Unionist Party MTW:E05000940 Harington   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/16152.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=913207880 2016-05-05 0 0           PP52   0
13395 16153 Richard Graham Willis         75 party:63 Green Party MTW:E05000940 Harington                       2016-05-05 0 0           PP63   0
13396 16156 Tina Bliss         75 party:52 Conservative and Unionist Party MTW:E05000941 Kew                       2016-05-05 0 0           PP52   0
13397 16158 Richard James Furness         75 party:63 Green Party MTW:E05000941 Kew                       2016-05-05 0 0           PP63   0
13398 16159 Janet Catherine Harrison         75 party:53 Labour Party MTW:E05000941 Kew                       2016-05-05 0 0           PP53   0
13399 16160 David Gwyn Pullin         75 party:90 Liberal Democrats MTW:E05000941 Kew   1.0                   2016-05-05 0 0           PP90   0
13400 16164 Iain Beckett         75 party:52 Conservative and Unionist Party MTW:E05000942 Linacre                       2016-05-05 0 0           PP52   0
13401 16165 Jake Michael Bowness         75 ynmp-party:2 Independent MTW:E05000942 Linacre                       2016-05-05 0 0           ynmp-party:2   0
13402 16166 Barbara Ann Bryan Ms   Female 1952.0 75 party:73 Socialist Labour Party MTW:E05000942 Linacre                       2016-05-05 0 0           PP73   0
13403 16167 Brenda O'Brien         75 party:53 Labour Party MTW:E05000942 Linacre   1.0                   2016-05-05 0 0           PP53   0
13404 16168 Marion Wykes         75 party:63 Green Party MTW:E05000942 Linacre                       2016-05-05 0 0   41163.0       PP63   0
13405 16172 Trish Hardy         75 party:53 Labour Party MTW:E05000943 Litherland   1.0                   2016-05-05 0 0           PP53   0
13406 16173 Jessamine Miles Hounslea         75 party:52 Conservative and Unionist Party MTW:E05000943 Litherland                       2016-05-05 0 0           PP52   0
13407 16174 Ethan Wykes         75 party:63 Green Party MTW:E05000943 Litherland                       2016-05-05 0 0           PP63   0
13408 16185 Paul Martyn Barber         75 party:52 Conservative and Unionist Party MTW:E05000953 Victoria                       2016-05-05 0 0           PP52   0
13409 16186 Alison Gibbon     female   75 party:63 Green Party MTW:E05000944 Manor     https://my.greenparty.org.uk/candidates/105835       https://static-candidates.democracyclub.org.uk/media/images/images/16186.png   profile-photo sjorford https://www.facebook.com/125157814711098/photos/a.125159658044247.1073741827.125157814711098/125159661377580/ 2016-05-05 0 0           PP63   0
13410 16187 Craig Anthony John Hughes         75 party:85 UK Independence Party (UKIP) MTW:E05000944 Manor                       2016-05-05 0 0           PP85   0
13411 16188 John Kelly     male   75 party:53 Labour Party MTW:E05000944 Manor   1.0                   2016-05-05 0 0           PP53   0
13412 16192 Debbie Bannon         75 party:53 Labour Party MTW:E05000945 Meols                       2016-05-05 0 0           PP53   0
13413 16193 Katy Bonney         75 party:85 UK Independence Party (UKIP) MTW:E05000945 Meols                       2016-05-05 0 0           PP85   0
13414 16194 John Dodd         75 party:90 Liberal Democrats MTW:E05000945 Meols   1.0   http://localfocusnews.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/16194.png   public-domain John_Dodd   2016-05-05 0 0           PP90   0
13415 16195 Sarah-Jayne McIntosh         75 party:63 Green Party MTW:E05000945 Meols                       2016-05-05 0 0           PP63   0
13416 16196 Luke Anthony Thompson         75 party:52 Conservative and Unionist Party MTW:E05000945 Meols                       2016-05-05 0 0           PP52   0
13417 16205 Marcus Julian Romaine Bleasdale         75 party:52 Conservative and Unionist Party MTW:E05000946 Molyneux                       2016-05-05 0 0           PP52   0
13418 16206 Paula Mary Murphy         75 party:53 Labour Party MTW:E05000946 Molyneux   1.0                   2016-05-05 0 0           PP53   0
13419 16207 Pierre Laurence Vicary         75 party:63 Green Party MTW:E05000946 Molyneux                       2016-05-05 0 0           PP63   0
13420 16212 Robert John Brennan         75 party:53 Labour Party MTW:E05000947 Netherton and Orrell   1.0                   2016-05-05 0 0           PP53   0
13421 16213 John Malcolm Rankin         75 party:52 Conservative and Unionist Party MTW:E05000947 Netherton and Orrell                       2016-05-05 0 0           PP52   0
13422 16248 Roy Greason         75 party:63 Green Party MTW:E05000949 Park                       2016-05-05 0 0           PP63   0
13423 16249 Pat From Lydiate         75 ynmp-party:2 Independent MTW:E05000949 Park   1.0                   2016-05-05 0 0           ynmp-party:2   0
13424 16250 Andy Wilson         75 party:53 Labour Party MTW:E05000949 Park                       2016-05-05 0 0           PP53   0
13425 16251 Lesley Delves         75 party:53 Labour Party MTW:E05000948 Norwood                       2016-05-05 0 0           PP53   0
13426 16252 Peter Noel Gregson         75 party:85 UK Independence Party (UKIP) MTW:E05000948 Norwood                       2016-05-05 0 0           PP85   0
13427 16253 Poppy Elise Jones         75 party:52 Conservative and Unionist Party MTW:E05000948 Norwood                       2016-05-05 0 0           PP52   0
13428 16254 David McIntosh         75 party:63 Green Party MTW:E05000948 Norwood                       2016-05-05 0 0           PP63   0
13429 16255 Bill Welsh         75 party:90 Liberal Democrats MTW:E05000948 Norwood   1.0                   2016-05-05 0 0           PP90   0
13430 16264 Jean Boardman         75 party:85 UK Independence Party (UKIP) MTW:E05000950 Ravenmeols                       2016-05-05 0 0           PP85   0
13431 16265 Tim Hale         75 party:53 Labour Party MTW:E05000950 Ravenmeols                       2016-05-05 0 0           PP53   0
13432 16266 Bob McCann         75 party:2232 Community Action Party MTW:E05000950 Ravenmeols   1.0                   2016-05-05 0 0           PP2232   0
13433 16267 Wendy Moore         75 party:52 Conservative and Unionist Party MTW:E05000950 Ravenmeols                       2016-05-05 0 0           PP52   0
13434 16268 Kim Bryan Dr   female 1960.0 75 party:73 Socialist Labour Party MTW:E05000951 St Oswald       http://www.socialist-labour-party.org.uk/index.html https://en.wikipedia.org/wiki/Socialist_Labour_Party_(UK)   https://static-candidates.democracyclub.org.uk/media/images/images/16268.png   profile-photo Kim Bryan   2016-05-05 0 0           PP73   0
13435 16269 Linda Cluskey         75 party:53 Labour Party MTW:E05000951 St Oswald   1.0                   2016-05-05 0 0           PP53   0
13436 16270 Peter Robert Papworth         75 party:52 Conservative and Unionist Party MTW:E05000951 St Oswald                       2016-05-05 0 0           PP52   0
13437 16271 Shaun Smyth         75 party:63 Green Party MTW:E05000951 St Oswald                       2016-05-05 0 0           PP63   0
13438 16272 Carla Maria Thomas         75 party:53 Labour Party MTW:E05000951 St Oswald   1.0                   2016-05-05 0 0           PP53   0
13439 16273 Janice Blanchard         75 party:52 Conservative and Unionist Party MTW:E05000952 Sudell                       2016-05-05 0 0           PP52   0
13440 16274 Carla Jane Fox     female   75 party:63 Green Party MTW:E05000952 Sudell                       2016-05-05 0 0           PP63   0
13441 16275 Matt Gannon         75 ynmp-party:2 Independent MTW:E05000952 Sudell   1.0                   2016-05-05 0 0           ynmp-party:2   0
13442 16276 Bruce Lock Hubbard         75 party:90 Liberal Democrats MTW:E05000952 Sudell                       2016-05-05 0 0           PP90   0
13443 16277 Sarah Patricia Hughes         75 party:85 UK Independence Party (UKIP) MTW:E05000952 Sudell                       2016-05-05 0 0           PP85   0
13444 16278 Nina Killen     female   75 party:53 Labour Party MTW:E05000952 Sudell             https://static-candidates.democracyclub.org.uk/media/images/images/16278.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=19936226 2016-05-05 0 0           PP53   0
13445 16279 Andrew Roy Donegan         75 party:63 Green Party MTW:E05000953 Victoria                       2016-05-05 0 0           PP63   0
13446 16280 Joseph Graeme Hedgecock         75 party:85 UK Independence Party (UKIP) MTW:E05000953 Victoria                       2016-05-05 0 0           PP85   0
13447 16281 Michael Roche         75 party:53 Labour Party MTW:E05000953 Victoria   1.0                   2016-05-05 0 0           PP53   0
13448 16282 Carol Tonkiss         75 party:90 Liberal Democrats MTW:E05000953 Victoria                       2016-05-05 0 0           PP90   0
13449 19092 Martyn Paul Barber         75 party:52 Conservative and Unionist Party MTW:E05000944 Manor                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.099ms