home / democracyclub

democracyclub

Custom SQL query returning 48 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
9520 4986 Shan Oakes     female   26 party:63 Green Party DIW:E05006240 Boroughbridge     http://yorkshireandhumber.greenparty.org.uk/candidates/shan-oakes-harrogate.html http://shanoakes.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/54c195e504fa01fd0c8356bd.png         2016-05-05 0 0   109;30712       PP63   0
9521 8536 Harvey Alexander     male   26 party:85 UK Independence Party (UKIP) DIW:E05006270 Washburn                       2016-05-05 0 0           PP85   0
9522 13886 Alan Beatham         26 party:53 Labour Party DIW:E05006261 Ribston                       2016-05-05 0 0           PP53   0
9523 13887 Elizabeth Collins     female   26 party:63 Green Party DIW:E05006261 Ribston             https://static-candidates.democracyclub.org.uk/media/images/images/27651.png   profile-photo Danby https://harrogate.greenparty.org.uk/councillors.html 2016-05-05 0 0   27651.0       PP63   0
9524 13888 Simon James Oldroyd         26 party:90 Liberal Democrats DIW:E05006261 Ribston                       2016-05-05 0 0           PP90   0
9525 13889 Andy Paraskos         26 party:52 Conservative and Unionist Party DIW:E05006261 Ribston   1.0                   2016-05-05 0 0           PP52   0
9526 14050 Guy Allanson         26 party:53 Labour Party DIW:E05006253 Marston Moor                       2016-05-05 0 0           PP53   0
9527 14051 Tim Myatt         26 party:52 Conservative and Unionist Party DIW:E05006253 Marston Moor   1.0                   2016-05-05 0 0   48496.0       PP52   0
9528 14993 Ian Crabbe         26 party:53 Labour Party DIW:E05006252 Lower Nidderdale                       2016-05-05 0 0           PP53   0
9529 14994 Nathan Roger Hull         26 party:52 Conservative and Unionist Party DIW:E05006252 Lower Nidderdale   1.0                   2016-05-05 0 0           PP52   0
9530 14995 Paul Geoffrey Trewhitt         26 party:63 Green Party DIW:E05006252 Lower Nidderdale                       2016-05-05 0 0           PP63   0
9531 16092 Laura Ann Dinning         26 party:53 Labour Party DIW:E05006239 Bishop Monkton                       2016-05-05 0 0           PP53   0
9532 16093 Ian Roger Galloway         26 party:52 Conservative and Unionist Party DIW:E05006239 Bishop Monkton   1.0                   2016-05-05 0 0           PP52   0
9533 16094 Greig John Sharman     Male   26 party:63 Green Party DIW:E05006239 Bishop Monkton                       2016-05-05 0 0           PP63   0
9534 16106 Paul Martin Burns         26 party:53 Labour Party DIW:E05006240 Boroughbridge                       2016-05-05 0 0   30707.0       PP53   0
9535 16107 Hannah Gostlow         26 party:90 Liberal Democrats DIW:E05006240 Boroughbridge                       2016-05-05 0 0           PP90   0
9536 16108 Robert Windass         26 party:52 Conservative and Unionist Party DIW:E05006240 Boroughbridge   1.0                   2016-05-05 0 0           PP52   0
9537 16122 David Anthony Bulmer         26 party:53 Labour Party DIW:E05006241 Claro                       2016-05-05 0 0           PP53   0
9538 16123 Nick Duxbury         26 party:52 Conservative and Unionist Party DIW:E05006241 Claro   1.0                   2016-05-05 0 0           PP52   0
9539 16124 Adam Richard Harper         26 party:63 Green Party DIW:E05006241 Claro                       2016-05-05 0 0           PP63   0
9540 16125 Emma Jane Walsh         26 party:90 Liberal Democrats DIW:E05006241 Claro                       2016-05-05 0 0           PP90   0
9541 16133 Rio Sebastian Justin Goldhammer         26 party:53 Labour Party DIW:E05006246 Killinghall                       2016-05-05 0 0           PP53   0
9542 16134 Michael Harrison         26 party:52 Conservative and Unionist Party DIW:E05006246 Killinghall   1.0                   2016-05-05 0 0   46895.0       PP52   0
9543 16135 Kenn Hart         26 party:85 UK Independence Party (UKIP) DIW:E05006246 Killinghall                       2016-05-05 0 0           PP85   0
9544 16136 Bill Hoult         26 party:90 Liberal Democrats DIW:E05006246 Killinghall                       2016-05-05 0 0           PP90   0
9545 16142 Margaret Edna Atkinson     female   26 party:52 Conservative and Unionist Party DIW:E05006247 Kirkby Malzeard   1.0                   2016-05-05 0 0           PP52   0
9546 16143 Vivienne Graham         26 party:53 Labour Party DIW:E05006247 Kirkby Malzeard                       2016-05-05 0 0           PP53   0
9547 16148 Christine Elsie Brackley         26 party:53 Labour Party DIW:E05006254 Mashamshire                       2016-05-05 0 0           PP53   0
9548 16149 Nigel Simms         26 party:52 Conservative and Unionist Party DIW:E05006254 Mashamshire   1.0                   2016-05-05 0 0           PP52   0
9549 16154 Nick Brown         26 party:52 Conservative and Unionist Party DIW:E05006255 Newby   1.0                   2016-05-05 0 0           PP52   0
9550 16155 Matthew David Forth         26 party:53 Labour Party DIW:E05006255 Newby                       2016-05-05 0 0           PP53   0
9551 16161 Andrew James Murday         26 party:53 Labour Party DIW:E05006257 Nidd Valley                       2016-05-05 0 0           PP53   0
9552 16162 Mick Stanley         26 party:52 Conservative and Unionist Party DIW:E05006257 Nidd Valley                       2016-05-05 0 0           PP52   0
9553 16163 Tom Watson         26 party:90 Liberal Democrats DIW:E05006257 Nidd Valley   1.0                   2016-05-05 0 0           PP90   0
9554 16169 Kevin Brian Hawkins         26 party:90 Liberal Democrats DIW:E05006258 Ouseburn                       2016-05-05 0 0           PP90   0
9555 16170 Ash Teague Mr       26 party:52 Conservative and Unionist Party DIW:E05006258 Ouseburn   1.0                   2016-05-05 0 0           PP52   0
9556 16171 Dave Wheeler         26 party:53 Labour Party DIW:E05006258 Ouseburn                       2016-05-05 0 0           PP53   0
9557 16175 Stan Beer         26 ynmp-party:2 Independent DIW:E05006260 Pateley Bridge                       2016-05-05 0 0           ynmp-party:2   0
9558 16177 Gillian Rosemary Charters         26 party:63 Green Party DIW:E05006260 Pateley Bridge                       2016-05-05 0 0           PP63   0
9559 16178 Stanley Lumley         26 party:52 Conservative and Unionist Party DIW:E05006260 Pateley Bridge   1.0                   2016-05-05 0 0           PP52   0
9560 16182 Shirley Patricia Fawcett         26 party:52 Conservative and Unionist Party DIW:E05006267 Spofforth with Lower Wharfedale   1.0                   2016-05-05 0 0           PP52   0
9561 16183 Pamela Godsell         26 party:90 Liberal Democrats DIW:E05006267 Spofforth with Lower Wharfedale                       2016-05-05 0 0   40445.0       PP90   0
9562 16184 Carol Walker         26 party:53 Labour Party DIW:E05006267 Spofforth with Lower Wharfedale                       2016-05-05 0 0           PP53   0
9563 16197 Nick Murray         26 party:53 Labour Party DIW:E05006270 Washburn                       2016-05-05 0 0           PP53   0
9564 16198 Christine Anne Ryder     female   26 party:52 Conservative and Unionist Party DIW:E05006270 Washburn   1.0                   2016-05-05 0 0           PP52   0
9565 16203 Bernard Arthur Bateman         26 party:52 Conservative and Unionist Party DIW:E05006271 Wathvale   1.0                   2016-05-05 0 0           PP52   0
9566 16204 Alan Peter Woodhead     male 1949.0 26 party:53 Labour Party DIW:E05006271 Wathvale             https://static-candidates.democracyclub.org.uk/media/images/images/16204.png   profile-photo yanbad13257   2016-05-05 0 0           PP53   0
9567 31798 David Lionel Brackley         26 party:53 Labour Party DIW:E05006260 Pateley Bridge                       2016-05-05 0 0   16176.0       PP53   0
Powered by Datasette · Query took 0.639ms