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
14799 1011 Martin Tod     male 1964-08-22 90 party:90 Liberal Democrats DIW:E05011005 St Paul     http://www.libdems.org.uk/martin_tod http://www.martintod.org.uk   https://uk.linkedin.com/in/martintod https://static-candidates.democracyclub.org.uk/media/images/images/1011_57vYvFC.png   profile-photo mpntod Original of photo displayed here - https://twitter.com/mpntod 2016-05-05 0 0   17769.0       PP90 Dark Chocolate Florentine. 0
14800 2269 Patrick Davies     male   90 party:53 Labour Party DIW:E05011003 St Luke                       2016-05-05 0 0           PP53   0
14801 4542 Jackie Porter     Female   90 party:90 Liberal Democrats DIW:E05011007 The Worthys     http://www.libdems.org.uk/jackie_porter http://www.jackieporter.co.uk   https://www.linkedin.com/in/jackielibdem https://static-candidates.democracyclub.org.uk/media/images/images/4542.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
14802 5273 Andrew Adams Mr   male 1982.0 90 party:53 Labour Party DIW:E05011003 St Luke     http://www.andovernwhlabour.org.uk/andy http://www.andovernwhlabour.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/551ac34b13eb34c82843cb2e.png   other _AndyAdams_ I'm the candidate - photo owned by me and free of copyright. 2016-05-05 0 0   5356;17722;42925       PP53 Jaffa Cake 0
14803 6036 Michael Wilks     Male   90 party:63 Green Party DIW:E05011002 St Bartholomew             https://static-candidates.democracyclub.org.uk/media/images/553b8f3be6d2cbcd26e36a2e.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/WilksMwilks 2016-05-05 0 0           PP63   0
14804 6392 Eleanor Bell     female   90 party:90 Liberal Democrats DIW:E05010996 Badger Farm & Oliver's Battery             https://static-candidates.democracyclub.org.uk/media/images/553c97bd41b868785b1fe672.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/EleanorBell2015 2016-05-05 0 0           PP90   0
14805 7732 Mike Read     male   90 party:52 Conservative and Unionist Party DIW:E05011000 Denmead                       2016-05-05 0 0           PP52   0
14806 14965 Chris Barton-Briddon         90 party:85 UK Independence Party (UKIP) DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP85   0
14807 14966 Gavin Craig Dick         90 party:52 Conservative and Unionist Party DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP52   0
14808 14967 Rob Ducker         90 party:52 Conservative and Unionist Party DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP52   0
14809 14968 Brian Leslie Laming         90 party:90 Liberal Democrats DIW:E05010996 Badger Farm & Oliver's Battery     http://www.winld.org.uk/your_candidate_badgers_farm_and_olivers_battery       https://static-candidates.democracyclub.org.uk/media/images/images/14968.png   profile-photo jtonline   2016-05-05 0 0           PP90   0
14810 14969 Alun Glyn Rees         90 party:53 Labour Party DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP53   0
14811 14970 Peter Rees         90 party:53 Labour Party DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP53   0
14812 14971 John Louis Romero         90 party:90 Liberal Democrats DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP90   0
14813 14972 Jonathan Paul Tettmar         90 party:53 Labour Party DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP53   0
14814 14973 Jan Warwick         90 party:52 Conservative and Unionist Party DIW:E05010996 Badger Farm & Oliver's Battery                       2016-05-05 0 0           PP52   0
14815 15008 Sudhakar Kedareshwar Achwal         90 ynmp-party:2 Independent DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           ynmp-party:2   0
14816 15009 Laurie Clough         90 party:53 Labour Party DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP53   0
14817 15010 Steve Haines         90 party:53 Labour Party DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP53   0
14818 15011 Thomas Houghton         90 party:90 Liberal Democrats DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP90   0
14819 15012 Rob Humby         90 party:52 Conservative and Unionist Party DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP52   0
14820 15013 Steven John Jakubowski         90 party:53 Labour Party DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP53   0
14821 15014 David Charles Leon McLean         90 party:52 Conservative and Unionist Party DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP52   0
14822 15016 Benjamin Russell Mackintosh Stoneham         90 party:90 Liberal Democrats DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP90   0
14823 15017 Vivienne Angela Young         90 party:85 UK Independence Party (UKIP) DIW:E05010997 Bishop's Waltham                       2016-05-05 0 0           PP85   0
14824 15018 Keith Eric Divall         90 party:90 Liberal Democrats DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP90   0
14825 15019 Russell Digby Gordon-Smith         90 party:90 Liberal Democrats DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP90   0
14826 15020 Kim Alexander Gottlieb         90 party:52 Conservative and Unionist Party DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP52   0
14827 15021 Lisa Suzanne Griffiths         90 party:52 Conservative and Unionist Party DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP52   0
14828 15022 Lee Arthur Hayes         90 party:53 Labour Party DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP53   0
14829 15023 Ernie Jeffs         90 party:52 Conservative and Unionist Party DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP52   0
14830 15024 James Edwin Leppard         90 party:53 Labour Party DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP53   0
14831 15025 Margot Julia Power         90 party:90 Liberal Democrats DIW:E05010995 Alresford & Itchen Valley     http://www.winld.org.uk/your_candidate_alresford_itchen_valley_margot_power       https://static-candidates.democracyclub.org.uk/media/images/images/15025.png   profile-photo jtonline   2016-05-05 0 0           PP90   0
14832 15026 Ian Duncan Wight         90 party:53 Labour Party DIW:E05010995 Alresford & Itchen Valley                       2016-05-05 0 0           PP53   0
14833 17605 Sheila Mary Campbell         90 party:90 Liberal Democrats DIW:E05010998 Central Meon Valley     http://www.winld.org.uk/your_candidate_central_meon_valley_sheila_campbell       https://static-candidates.democracyclub.org.uk/media/images/images/17605.png   profile-photo jtonline   2016-05-05 0 0           PP90   0
14834 17606 Stan Evans         90 party:53 Labour Party DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP53   0
14835 17607 Linda Eileen Elizabeth Gemmell         90 party:52 Conservative and Unionist Party DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP52   0
14836 17608 Alex Graft     Alex Graft 1983.0 90 party:53 Labour Party DIW:E05010998 Central Meon Valley             https://static-candidates.democracyclub.org.uk/media/images/images/17608.png   public-domain alex19   2016-05-05 0 0           PP53   0
14837 17609 Leslie Thomas Mitchell         90 party:85 UK Independence Party (UKIP) DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP85   0
14838 17610 Frank Richard Pearson         90 party:52 Conservative and Unionist Party DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP52   0
14839 17611 Margaret Scriven         90 party:90 Liberal Democrats DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP90   0
14840 17612 Anne Kristine Mackintosh Stoneham         90 party:90 Liberal Democrats DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP90   0
14841 17613 Nicola Ann Wardrop         90 party:53 Labour Party DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP53   0
14842 17614 Vicki Weston         90 party:52 Conservative and Unionist Party DIW:E05010998 Central Meon Valley                       2016-05-05 0 0           PP52   0
14843 17621 Paul James Brown         90 party:53 Labour Party DIW:E05010999 Colden Common & Twyford                       2016-05-05 0 0           PP53   0
14844 17622 Sue J Cook         90 party:52 Conservative and Unionist Party DIW:E05010999 Colden Common & Twyford                       2016-05-05 0 0           PP52   0
14845 17623 Sonia Frances Critcher         90 party:53 Labour Party DIW:E05010999 Colden Common & Twyford                       2016-05-05 0 0           PP53   0
14846 17624 Julia Ellen Hallmann         90 party:63 Green Party DIW:E05010999 Colden Common & Twyford                       2016-05-05 0 0           PP63   0
14847 17625 Richard Charles Izard         90 party:90 Liberal Democrats DIW:E05010999 Colden Common & Twyford                       2016-05-05 0 0           PP90   0
14848 17626 Robert Johnston         90 party:90 Liberal Democrats DIW:E05010999 Colden Common & Twyford                       2016-05-05 0 0           PP90   0
14849 17627 Maureen Anne Rees         90 party:52 Conservative and Unionist Party DIW:E05010999 Colden Common & Twyford                       2016-05-05 0 0           PP52   0
14850 17640 Caroline Lorraine Brook         90 party:52 Conservative and Unionist Party DIW:E05011000 Denmead                       2016-05-05 0 0           PP52   0
14851 17641 Jacqueline June Carroll         90 party:53 Labour Party DIW:E05011000 Denmead                       2016-05-05 0 0           PP53   0
14852 17642 Steve Della Mora         90 party:53 Labour Party DIW:E05011000 Denmead                       2016-05-05 0 0           PP53   0
14853 17643 Andrew Negus         90 party:90 Liberal Democrats DIW:E05011000 Denmead                       2016-05-05 0 0           PP90   0
14854 17644 Claire Louise Sorensen         90 party:53 Labour Party DIW:E05011000 Denmead                       2016-05-05 0 0           PP53   0
14855 17645 Patricia Grace Stallard         90 party:52 Conservative and Unionist Party DIW:E05011000 Denmead                       2016-05-05 0 0           PP52   0
14856 17646 Simon Paul Wernick         90 party:90 Liberal Democrats DIW:E05011000 Denmead                       2016-05-05 0 0           PP90   0
14857 17658 Mags Brown         90 party:52 Conservative and Unionist Party DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP52   0
14858 17659 Angela Clear         90 party:90 Liberal Democrats DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP90   0
14859 17660 Neil Richard Cutler         90 party:90 Liberal Democrats DIW:E05011006 Southwick & Wickham     http://www.winld.org.uk/your_candidate_southwick_wickham_neil_cutler       https://static-candidates.democracyclub.org.uk/media/images/images/17660.png   profile-photo jtonline   2016-05-05 0 0           PP90   0
14860 17661 Leon George Dabbs         90 party:52 Conservative and Unionist Party DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP52   0
14861 17662 Therese Evans         90 party:90 Liberal Democrats DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP90   0
14862 17663 Gary Allan Gray         90 party:53 Labour Party DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP53   0
14863 17664 Paul Francis Harris         90 party:53 Labour Party DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP53   0
14864 17665 Neil Harold Lander-Brinkley         90 party:52 Conservative and Unionist Party DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP52   0
14865 17666 Ian James Norgate         90 party:85 UK Independence Party (UKIP) DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP85   0
14866 17667 Paul Thomas Sony         90 party:53 Labour Party DIW:E05011006 Southwick & Wickham                       2016-05-05 0 0           PP53   0
14867 17681 Eileen Mary Berry         90 party:52 Conservative and Unionist Party DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP52   0
14868 17682 Adrian John Paul Field         90 party:53 Labour Party DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP53   0
14869 17683 Hannah Valentine Field         90 party:53 Labour Party DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP53   0
14870 17684 Kezia Melissa Louise Hoffman         90 ynmp-party:2 Independent DIW:E05011001 St Barnabas                       2016-05-05 0 0           ynmp-party:2   0
14871 17685 Cameron Thomas Strachan Johnson         90 party:90 Liberal Democrats DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP90   0
14872 17686 Kelsie Learney         90 party:90 Liberal Democrats DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP90   0
14873 17687 Paul Charles Twelftree         90 party:52 Conservative and Unionist Party DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP52   0
14874 17688 Tessa Susan Valentine         90 party:53 Labour Party DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP53   0
14875 17689 Anne Helen Weir         90 party:90 Liberal Democrats DIW:E05011001 St Barnabas     http://www.winld.org.uk/your_candidate_st_barnabas_anne_weir       https://static-candidates.democracyclub.org.uk/media/images/images/17689.png   profile-photo jtonline   2016-05-05 0 0           PP90   0
14876 17690 Angie Wilkinson         90 party:52 Conservative and Unionist Party DIW:E05011001 St Barnabas                       2016-05-05 0 0           PP52   0
14877 17707 Bob Barnes         90 party:85 UK Independence Party (UKIP) DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP85   0
14878 17708 Rose Burns         90 party:52 Conservative and Unionist Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP52   0
14879 17709 Lucy Emma Clement         90 party:63 Green Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP63   0
14880 17710 Michael Frederick Coker-Davies         90 ynmp-party:2 Independent DIW:E05011002 St Bartholomew                       2016-05-05 0 0           ynmp-party:2   0
14881 17711 David James Crudgington         90 party:52 Conservative and Unionist Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP52   0
14882 17712 Kathleen Frances Alice East         90 party:53 Labour Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP53   0
14883 17713 Nicki Elks         90 party:90 Liberal Democrats DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP90   0
14884 17714 Sue Falconer         90 party:52 Conservative and Unionist Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP52   0
14885 17715 Clive Malcolm Gosling         90 party:53 Labour Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP53   0
14886 17716 Rhian Louise Harrison         90 party:63 Green Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP63   0
14887 17717 Dominic Charles Alan Hiscock         90 party:90 Liberal Democrats DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP90   0
14888 17718 Lawrence Andreas Leslie Mason         90 party:53 Labour Party DIW:E05011002 St Bartholomew                       2016-05-05 0 0           PP53   0
14889 17723 Derek Green         90 party:90 Liberal Democrats DIW:E05011003 St Luke                       2016-05-05 0 0           PP90   0
14890 17724 Tomos Owain James         90 party:4047 Winchester Independents DIW:E05011003 St Luke                       2016-05-05 0 0           PP4047   0
14891 17725 George Edward Marshall-James         90 party:52 Conservative and Unionist Party DIW:E05011003 St Luke                       2016-05-05 0 0           PP52   0
14892 17726 Kia Robert Pope         90 party:63 Green Party DIW:E05011003 St Luke                       2016-05-05 0 0           PP63   0
14893 17727 Harry William Sampson         90 party:52 Conservative and Unionist Party DIW:E05011003 St Luke                       2016-05-05 0 0           PP52   0
14894 17728 Jamie Robert Jonathan Scott         90 party:90 Liberal Democrats DIW:E05011003 St Luke                       2016-05-05 0 0           PP90   0
14895 17738 Guy Julian Claude Ashton         90 party:52 Conservative and Unionist Party DIW:E05011004 St Michael                       2016-05-05 0 0           PP52   0
14896 17739 David Banks         90 party:90 Liberal Democrats DIW:E05011004 St Michael                       2016-05-05 0 0           PP90   0
14897 17740 Dinah June Caroline Barton         90 party:63 Green Party DIW:E05011004 St Michael                       2016-05-05 0 0           PP63   0
14898 17741 Janet Mary Berry         90 party:53 Labour Party DIW:E05011004 St Michael                       2016-05-05 0 0           PP53   0
14899 17742 Michael Christopher Elks         90 party:90 Liberal Democrats DIW:E05011004 St Michael                       2016-05-05 0 0           PP90   0
Powered by Datasette · Query took 1.116ms