home / democracyclub

democracyclub

Custom SQL query returning 50 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
13024 5876 Alan Durrant     male   70 party:53 Labour Party DIW:E05004538 Forton     https://www.gosportlabour.co.uk/gosport-elections-2018/chris-percival-christchurch-2-2/ http://www.alandurrant4gosport.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/5876.png   profile-photo gosportlabour1 Most recent photo of candidate 2016-05-05 0 0   15935;38402       PP53   0
13025 13840 Diane Hilda Furlong         70 party:52 Conservative and Unionist Party DIW:E05004540 Hardway                       2016-05-05 0 0           PP52   0
13026 13841 Stephen James Marshall         70 party:90 Liberal Democrats DIW:E05004540 Hardway                       2016-05-05 0 0           PP90   0
13027 13842 Mark Smith     male   70 party:53 Labour Party DIW:E05004540 Hardway     https://www.gosportlabour.co.uk/gosport-elections-2018/mark-smith-for-hardway/       https://static-candidates.democracyclub.org.uk/media/images/images/13842.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/mark-smith-for-hardway/ 2016-05-05 0 0           PP53   0
13028 14161 Philip Iain Raffaelli         70 party:52 Conservative and Unionist Party DIW:E05004532 Anglesey                       2016-05-05 0 0           PP52   0
13029 14162 David Langton Waite         70 party:53 Labour Party DIW:E05004532 Anglesey                       2016-05-05 0 0           PP53   0
13030 15887 Jonathan Eaton     male   70 party:53 Labour Party DIW:E05004531 Alverstoke     https://www.gosportlabour.co.uk/gosport-elections-2018/jonathan-eaton-alverstoke/                 2016-05-05 0 0   15885.0       PP53   0
13031 15888 Mark William Paul Hook         70 party:52 Conservative and Unionist Party DIW:E05004531 Alverstoke                       2016-05-05 0 0           PP52   0
13032 15895 Tasha Hook         70 party:52 Conservative and Unionist Party DIW:E05004533 Bridgemary North                       2016-05-05 0 0           PP52   0
13033 15896 Jill Madeline Wright         70 party:53 Labour Party DIW:E05004533 Bridgemary North                       2016-05-05 0 0           PP53   0
13034 15902 Peter Batty         70 party:53 Labour Party DIW:E05004534 Bridgemary South                       2016-05-05 0 0           PP53   0
13035 15903 Kath Jones         70 party:52 Conservative and Unionist Party DIW:E05004534 Bridgemary South                       2016-05-05 0 0           PP52   0
13036 15909 James Fox     male   70 party:53 Labour Party DIW:E05004535 Brockhurst     https://www.gosportlabour.co.uk/gosport-elections-2018/jim-fox-bridgemary-south/                 2016-05-05 0 0           PP53   0
13037 15910 Robert Leonard Hylands         70 party:90 Liberal Democrats DIW:E05004535 Brockhurst                       2016-05-05 0 0           PP90   0
13038 15911 Jane Staffieri         70 party:63 Green Party DIW:E05004535 Brockhurst                       2016-05-05 0 0           PP63   0
13039 15912 Gary David Walker     male 1967.0 70 party:52 Conservative and Unionist Party DIW:E05004535 Brockhurst     http://www.gosportconservatives.org/person/mr-gary-walker       https://static-candidates.democracyclub.org.uk/media/images/images/15912.png   profile-photo JeniT from their party page at http://www.gosportconservatives.org/person/mr-gary-walker 2016-05-05 0 0           PP52   0
13040 15922 Richard James Dickson         70 party:52 Conservative and Unionist Party DIW:E05004536 Christchurch                       2016-05-05 0 0           PP52   0
13041 15923 Dawn Christina Kelly         70 party:90 Liberal Democrats DIW:E05004536 Christchurch                       2016-05-05 0 0           PP90   0
13042 15924 Charis Noakes     female   70 party:53 Labour Party DIW:E05004536 Christchurch     https://www.gosportlabour.co.uk/gosport-elections-2018/charis-noakes-leesland/       https://static-candidates.democracyclub.org.uk/media/images/images/15924.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/charis-noakes-leesland/ 2016-05-05 0 0           PP53   0
13043 15929 Richard Philip Earle         70 party:90 Liberal Democrats DIW:E05004537 Elson                       2016-05-05 0 0           PP90   0
13044 15930 Craig Thomas Hazel         70 party:52 Conservative and Unionist Party DIW:E05004537 Elson                       2016-05-05 0 0           PP52   0
13045 15931 Louie Christina Sykes         70 party:53 Labour Party DIW:E05004537 Elson                       2016-05-05 0 0           PP53   0
13046 15936 Dale Fletcher         70 ynmp-party:2 Independent DIW:E05004538 Forton                       2016-05-05 0 0           ynmp-party:2   0
13047 15937 Chloe Marie Palmer     Female 1989.0 70 party:85 UK Independence Party (UKIP) DIW:E05004538 Forton     http://www.ukip.org/candidates2017     https://www.linkedin.com/in/chloe-palmer-4295107a/ https://static-candidates.democracyclub.org.uk/media/images/images/15937.png   copyright-assigned PrincessChloe   2016-05-05 0 0           PP85   0
13048 15938 Angela Jane Prickett         70 party:90 Liberal Democrats DIW:E05004538 Forton                       2016-05-05 0 0           PP90   0
13049 15939 Rebecca Stares         70 party:52 Conservative and Unionist Party DIW:E05004538 Forton                       2016-05-05 0 0           PP52   0
13050 15949 John Alan Bowles         70 party:85 UK Independence Party (UKIP) DIW:E05004539 Grange                       2016-05-05 0 0           PP85   0
13051 15950 Sean Evans         70 party:90 Liberal Democrats DIW:E05004539 Grange                       2016-05-05 0 0           PP90   0
13052 15951 Maggie Morgan         70 party:52 Conservative and Unionist Party DIW:E05004539 Grange                       2016-05-05 0 0           PP52   0
13053 15952 David Malcolm Pollard         70 party:53 Labour Party DIW:E05004539 Grange                       2016-05-05 0 0           PP53   0
13054 15957 Graham Burgess         70 party:52 Conservative and Unionist Party DIW:E05004541 Lee East                       2016-05-05 0 0           PP52   0
13055 15958 Nancy Ruth Hurworth         70 party:63 Green Party DIW:E05004541 Lee East                       2016-05-05 0 0           PP63   0
13056 15959 Caroline Osborne     female   70 party:53 Labour Party DIW:E05004541 Lee East     https://www.gosportlabour.co.uk/gosport-elections-2018/caroline-osborne-lee-on-solent-east/       https://static-candidates.democracyclub.org.uk/media/images/images/15959.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/caroline-osborne-lee-on-solent-east/ 2016-05-05 0 0           PP53   0
13057 15960 John Beavis         70 party:52 Conservative and Unionist Party DIW:E05004542 Lee West                       2016-05-05 0 0           PP52   0
13058 15961 Peter Hurworth         70 party:63 Green Party DIW:E05004542 Lee West                       2016-05-05 0 0           PP63   0
13059 15962 Jill Whitcher     female   70 party:53 Labour Party DIW:E05004542 Lee West     https://www.gosportlabour.co.uk/gosport-elections-2018/jill-whitcher-lee-on-solent-west/       https://static-candidates.democracyclub.org.uk/media/images/images/15962.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/jill-whitcher-lee-on-solent-west/ 2016-05-05 0 0           PP53   0
13060 15963 Steve Butterworth         70 party:52 Conservative and Unionist Party DIW:E05004543 Leesland                       2016-05-05 0 0           PP52   0
13061 15964 Maria Jane Diffey         70 party:90 Liberal Democrats DIW:E05004543 Leesland                       2016-05-05 0 0           PP90   0
13062 15965 Michael John Madgwick         70 party:53 Labour Party DIW:E05004543 Leesland                       2016-05-05 0 0           PP53   0
13063 15966 David Eugen Sekules         70 party:63 Green Party DIW:E05004543 Leesland                       2016-05-05 0 0           PP63   0
13064 15967 Paul Noakes         70 party:53 Labour Party DIW:E05004544 Peel Common     https://www.gosportlabour.co.uk/gosport-elections-2018/paul-noakes-for-anglesey/                 2016-05-05 0 0           PP53   0
13065 15968 Stephen Philpott         70 party:52 Conservative and Unionist Party DIW:E05004544 Peel Common                       2016-05-05 0 0           PP52   0
13066 15969 Zoe Huggins         70 party:52 Conservative and Unionist Party DIW:E05004545 Privett                       2016-05-05 0 0           PP52   0
13067 15970 James Bertram Tomlinson         70 party:53 Labour Party DIW:E05004545 Privett                       2016-05-05 0 0           PP53   0
13068 15971 Jean Ann Batterbury         70 party:53 Labour Party DIW:E05004546 Rowner and Holbrook                       2016-05-05 0 0           PP53   0
13069 15972 Karen Elizabeth Bergin         70 party:85 UK Independence Party (UKIP) DIW:E05004546 Rowner and Holbrook                       2016-05-05 0 0           PP85   0
13070 15973 Marcus Thomas Murphy         70 party:52 Conservative and Unionist Party DIW:E05004546 Rowner and Holbrook                       2016-05-05 0 0           PP52   0
13071 15974 Keith Cyril Farr         70 party:53 Labour Party DIW:E05004547 Town                       2016-05-05 0 0           PP53   0
13072 15975 Sam Matthias Hayward-Vernon         70 party:90 Liberal Democrats DIW:E05004547 Town                       2016-05-05 0 0           PP90   0
13073 15976 Simon Barry Lockyer         70 party:52 Conservative and Unionist Party DIW:E05004547 Town                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.022ms