home / democracyclub

democracyclub

Custom SQL query returning 56 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
9060 423 David Lee     male   19 party:90 Liberal Democrats DIW:E05007407 Whyteleafe     http://www.libdems.org.uk/lee_david       https://static-candidates.democracyclub.org.uk/media/images/553ab331319151d456c24fb8.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/whyteleafedavid 2016-05-05 0 0   13102.0       PP90   0
9061 1725 Jeffrey Bolter     male   19 party:85 UK Independence Party (UKIP) DIW:E05007403 Valley                       2016-05-05 0 0   4852;13079       PP85   0
9062 6774 Joe Branco     male   19 party:85 UK Independence Party (UKIP) DIW:E05007408 Woldingham ward                       2016-05-05 0 0   32123.0       PP85   0
9063 13057 Chris Botten     Male   19 party:90 Liberal Democrats DIW:E05007400 Portley                       2016-05-05 0 0   24965.0       PP90   0
9064 13058 Robin Gwynn     male   19 party:52 Conservative and Unionist Party DIW:E05007400 Portley     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Gwynn_Robin       https://static-candidates.democracyclub.org.uk/media/images/images/13058.png   profile-photo fbrc twitter profile pic https://twitter.com/Robin_Gwynn 2016-05-05 0 0   34969.0       PP52   0
9065 13059 Lucy Blue McNally     female   19 party:53 Labour Party DIW:E05007400 Portley                       2016-05-05 0 0           PP53   0
9066 13060 Alex Standen     male   19 party:85 UK Independence Party (UKIP) DIW:E05007400 Portley             https://static-candidates.democracyclub.org.uk/media/images/images/13060.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=136422743 2016-05-05 0 0           PP85   0
9067 13065 Ollie Chamberlain         19 party:53 Labour Party DIW:E05007401 Queens Park                       2016-05-05 0 0           PP53   0
9068 13066 Geoff Duck         19 party:52 Conservative and Unionist Party DIW:E05007401 Queens Park                       2016-05-05 0 0           PP52   0
9069 13067 Dick Grant         19 party:85 UK Independence Party (UKIP) DIW:E05007401 Queens Park                       2016-05-05 0 0   32119.0       PP85   0
9070 13068 Costel Petre         19 party:90 Liberal Democrats DIW:E05007401 Queens Park                       2016-05-05 0 0           PP90   0
9071 13080 Liz Goodwin         19 party:52 Conservative and Unionist Party DIW:E05007403 Valley                       2016-05-05 0 0           PP52   0
9072 13081 Alun Anthony Jones     male   19 party:90 Liberal Democrats DIW:E05007403 Valley             https://static-candidates.democracyclub.org.uk/media/images/images/13081.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=89026793 2016-05-05 0 0           PP90   0
9073 13082 Mark Jones         19 ynmp-party:2 Independent DIW:E05007403 Valley                       2016-05-05 0 0           ynmp-party:2   0
9074 13083 Rachel Krengel         19 party:53 Labour Party DIW:E05007403 Valley                       2016-05-05 0 0           PP53   0
9075 13084 Perry Chotai         19 party:52 Conservative and Unionist Party DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP52   0
9076 13085 Martin Arthur Haley         19 party:85 UK Independence Party (UKIP) DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP85   0
9077 13086 Jeremy Pursehouse         19 party:90 Liberal Democrats DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP90   0
9078 13087 Patrick Joseph Rogers         19 party:53 Labour Party DIW:E05007404 Warlingham East and Chelsham and Farleigh                       2016-05-05 0 0           PP53   0
9079 13088 Celia Caulcott     female   19 party:90 Liberal Democrats DIW:E05007405 Warlingham West     https://www.eastsurreylibdems.org.uk/election2018/102-candidates-2018/367-celia-caulcott-lib-dem-candidate-for-warlingham-west       https://static-candidates.democracyclub.org.uk/media/images/images/13088.png   profile-photo sjorford https://www.eastsurreylibdems.org.uk/election2018/102-candidates-2018/367-celia-caulcott-lib-dem-candidate-for-warlingham-west 2016-05-05 0 0           PP90   0
9080 13089 David John Cooley         19 party:52 Conservative and Unionist Party DIW:E05007405 Warlingham West                       2016-05-05 0 0           PP52   0
9081 13090 Jenifer Susan Dugdale         19 party:53 Labour Party DIW:E05007405 Warlingham West                       2016-05-05 0 0           PP53   0
9082 13091 John Hill         19 party:85 UK Independence Party (UKIP) DIW:E05007405 Warlingham West                       2016-05-05 0 0           PP85   0
9083 13096 Sally Rebecca Eason         19 party:53 Labour Party DIW:E05007406 Westway                       2016-05-05 0 0           PP53   0
9084 13097 Sarah Louise Peay         19 party:85 UK Independence Party (UKIP) DIW:E05007406 Westway                       2016-05-05 0 0           PP85   0
9085 13098 James Robert Richardson         19 party:52 Conservative and Unionist Party DIW:E05007406 Westway                       2016-05-05 0 0           PP52   0
9086 13099 Caroline Jane Warner         19 party:90 Liberal Democrats DIW:E05007406 Westway                       2016-05-05 0 0           PP90   0
9087 13100 Matthew Paul Groves         19 party:52 Conservative and Unionist Party DIW:E05007407 Whyteleafe                       2016-05-05 0 0           PP52   0
9088 13101 Fatima Kamara         19 party:53 Labour Party DIW:E05007407 Whyteleafe                       2016-05-05 0 0           PP53   0
9089 13103 Neill Simon Cooper         19 party:90 Liberal Democrats DIW:E05007408 Woldingham ward                       2016-05-05 0 0           PP90   0
9090 13104 Thomas Rowley Ebbs         19 party:53 Labour Party DIW:E05007408 Woldingham ward                       2016-05-05 0 0           PP53   0
9091 13105 Keith Martin Jecks         19 party:52 Conservative and Unionist Party DIW:E05007408 Woldingham ward                       2016-05-05 0 0           PP52   0
9092 13336 Christopher Charles Dean         19 party:85 UK Independence Party (UKIP) DIW:E05007399 Oxted South                       2016-05-05 0 0           PP85   0
9093 13337 Brigid Noreen McIntosh         19 party:90 Liberal Democrats DIW:E05007399 Oxted South                       2016-05-05 0 0           PP90   0
9094 13338 Michaela Claire O'Brien         19 party:63 Green Party DIW:E05007399 Oxted South                       2016-05-05 0 0           PP63   0
9095 13339 Liz Parker         19 party:52 Conservative and Unionist Party DIW:E05007399 Oxted South                       2016-05-05 0 0           PP52   0
9096 13340 Katherine Elizabeth Saunders         19 party:53 Labour Party DIW:E05007399 Oxted South                       2016-05-05 0 0           PP53   0
9097 13347 Gordon Charles Keymer         19 party:52 Conservative and Unionist Party DIW:E05007398 Oxted North and Tandridge                       2016-05-05 0 0           PP52   0
9098 13348 Donald Mahon         19 party:53 Labour Party DIW:E05007398 Oxted North and Tandridge                       2016-05-05 0 0           PP53   0
9099 13349 Jackie Wren         19 party:3978 Oxted & Limpsfield Residents Group DIW:E05007398 Oxted North and Tandridge                       2016-05-05 0 0           PP3978   0
9100 13350 Graham Bailey         19 party:85 UK Independence Party (UKIP) DIW:E05007395 Harestone                       2016-05-05 0 0           PP85   0
9101 13351 Anne Margaret Bell         19 party:90 Liberal Democrats DIW:E05007395 Harestone                       2016-05-05 0 0           PP90   0
9102 13352 Michael John William Cooper         19 party:52 Conservative and Unionist Party DIW:E05007395 Harestone                       2016-05-05 0 0           PP52   0
9103 13353 John Henry Edward Watts         19 party:53 Labour Party DIW:E05007395 Harestone                       2016-05-05 0 0           PP53   0
9104 13354 Eileen Ruth Blake-Thomas         19 party:52 Conservative and Unionist Party DIW:E05007394 Godstone                       2016-05-05 0 0           PP52   0
9105 13355 Marjory Broughton         19 party:85 UK Independence Party (UKIP) DIW:E05007394 Godstone                       2016-05-05 0 0           PP85   0
9106 13356 Sarah Catherine MacDonnell         19 party:53 Labour Party DIW:E05007394 Godstone                       2016-05-05 0 0           PP53   0
9107 13357 Dave Wilkes     Male   19 party:90 Liberal Democrats DIW:E05007394 Godstone                       2016-05-05 0 0   24969.0       PP90   0
9108 13358 Harry John Fitzgerald         19 party:52 Conservative and Unionist Party DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP52   0
9109 13359 Mark Adrian Fowler         19 party:85 UK Independence Party (UKIP) DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP85   0
9110 13360 Fern Warwick-Ching         19 party:53 Labour Party DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP53   0
9111 13361 Judy Wilkinson         19 party:90 Liberal Democrats DIW:E05007410 Burstow, Horne and Outwood                       2016-05-05 0 0           PP90   0
9112 13362 Linda Ruth Baharier         19 party:53 Labour Party DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0   42519.0       PP53   0
9113 13363 Ian Crabb         19 party:85 UK Independence Party (UKIP) DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0           PP85   0
9114 13364 Richard Barry Fowler         19 party:90 Liberal Democrats DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0           PP90   0
9115 13365 Debbie Vickers         19 party:52 Conservative and Unionist Party DIW:E05007409 Bletchingley and Nutfield                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 0.7ms