home / democracyclub

democracyclub

Custom SQL query returning 29 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
8788 11410 Kathy Condon         11 party:53 Labour Party DIW:E05009002 Broxbourne and Hoddesdon South                       2016-05-05 0 0           PP53   0
8789 11411 Evelyn Faulkner         11 party:85 UK Independence Party (UKIP) DIW:E05009002 Broxbourne and Hoddesdon South                       2016-05-05 0 0   27137.0       PP85   0
8790 11412 David William Holliday         11 party:52 Conservative and Unionist Party DIW:E05009002 Broxbourne and Hoddesdon South   1.0                   2016-05-05 0 0           PP52   0
8791 11413 Robert Ronald Hyde         11 party:63 Green Party DIW:E05009002 Broxbourne and Hoddesdon South                       2016-05-05 0 0           PP63   0
8792 13890 Tony Renwick         11 party:53 Labour Party DIW:E05009003 Cheshunt North                       2016-05-05 0 0           PP53   0
8793 13891 Linda Joy Russell         11 party:52 Conservative and Unionist Party DIW:E05009003 Cheshunt North   1.0                   2016-05-05 0 0           PP52   0
8794 14084 Cliff Hunt         11 party:85 UK Independence Party (UKIP) DIW:E05009009 Rosedale and Bury Green                       2016-05-05 0 0           PP85   0
8795 14237 Dee Hart     female   11 party:52 Conservative and Unionist Party DIW:E05009005 Flamstead End   1.0                   2016-05-05 0 0           PP52   0
8796 14238 Errol George Lawrence         11 party:53 Labour Party DIW:E05009005 Flamstead End                       2016-05-05 0 0           PP53   0
8797 14239 Shirley Pratt         11 party:85 UK Independence Party (UKIP) DIW:E05009005 Flamstead End                       2016-05-05 0 0   26793.0       PP85   0
8798 14240 Keith Martin Brown         11 party:52 Conservative and Unionist Party DIW:E05009007 Hoddesdon North   1.0                   2016-05-05 0 0           PP52   0
8799 14241 Tony Faulkner         11 party:85 UK Independence Party (UKIP) DIW:E05009007 Hoddesdon North                       2016-05-05 0 0   27127.0       PP85   0
8800 14242 Ed Hopwood         11 party:53 Labour Party DIW:E05009007 Hoddesdon North                       2016-05-05 0 0           PP53   0
8801 14243 Ken Ayling         11 party:52 Conservative and Unionist Party DIW:E05009008 Hoddesdon Town and Rye Park   1.0                   2016-05-05 0 0           PP52   0
8802 14244 Mark Hall         11 party:53 Labour Party DIW:E05009008 Hoddesdon Town and Rye Park                       2016-05-05 0 0           PP53   0
8803 14245 Sidney Pratt         11 party:85 UK Independence Party (UKIP) DIW:E05009008 Hoddesdon Town and Rye Park                       2016-05-05 0 0           PP85   0
8804 14249 Selina Norgrove     female   11 party:53 Labour Party DIW:E05009009 Rosedale and Bury Green             https://static-candidates.democracyclub.org.uk/media/images/images/14249.png   profile-photo sjorford http://www.broxbournelabour.org.uk/our_labour_candidate_2017 2016-05-05 0 0           PP53   0
8805 14250 Darren Richard Pitcher         11 party:52 Conservative and Unionist Party DIW:E05009009 Rosedale and Bury Green   1.0                   2016-05-05 0 0           PP52   0
8806 14251 Malcolm David Aitken         11 party:53 Labour Party DIW:E05009010 Waltham Cross   1.0                   2016-05-05 0 0           PP53   0
8807 14252 Patsy Spears         11 party:52 Conservative and Unionist Party DIW:E05009010 Waltham Cross                       2016-05-05 0 0           PP52   0
8808 14253 Dawn Bloor         11 party:85 UK Independence Party (UKIP) DIW:E05009011 Wormley and Turnford                       2016-05-05 0 0           PP85   0
8809 14254 Lewis Christopher Cocking         11 party:52 Conservative and Unionist Party DIW:E05009011 Wormley and Turnford   1.0                   2016-05-05 0 0           PP52   0
8810 14255 Kehinde Osifuwa         11 party:53 Labour Party DIW:E05009011 Wormley and Turnford                       2016-05-05 0 0           PP53   0
8811 14304 Steve Coster         11 party:85 UK Independence Party (UKIP) DIW:E05009006 Goffs Oak                       2016-05-05 0 0   27129.0       PP85   0
8812 14305 Gillian Mary Lawrence         11 party:53 Labour Party DIW:E05009006 Goffs Oak                       2016-05-05 0 0           PP53   0
8813 14306 Jeremy Pearce         11 party:52 Conservative and Unionist Party DIW:E05009006 Goffs Oak   1.0                   2016-05-05 0 0           PP52   0
8814 16620 Mavis Clark         11 party:85 UK Independence Party (UKIP) DIW:E05009004 Cheshunt South and Theobalds                       2016-05-05 0 0           PP85   0
8815 16621 Carol Ann Crump         11 party:52 Conservative and Unionist Party DIW:E05009004 Cheshunt South and Theobalds   1.0                   2016-05-05 0 0           PP52   0
8816 16622 Ian Martin Charles Dust         11 party:53 Labour Party DIW:E05009004 Cheshunt South and Theobalds                       2016-05-05 0 0           PP53   0
Powered by Datasette · Query took 0.49ms