home / democracyclub

democracyclub

Custom SQL query returning 42 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
11704 1268 Tony Wright     male 1954-08-12 51 party:53 Labour Party DIW:E05005792 Gorleston     http://www.gylabour.org.uk/tony_wright http://www.gylabour.org.uk https://en.wikipedia.org/wiki/Tony_Wright_(Great_Yarmouth_MP)   https://static-candidates.democracyclub.org.uk/media/images/images/1268.png   profile-photo john18   2016-05-05 0 0           PP53   0
11705 4814 Alan Christie Grey     male   51 party:85 UK Independence Party (UKIP) DIW:E05005784 Bradwell North   1.0 http://ukip-gy.co.uk/Alan%20Grey.pdf       https://static-candidates.democracyclub.org.uk/media/images/54e7b2d002f716934fefdb7f.png         2016-05-05 0 0   11739;32668       PP85   0
11706 8192 Ken Petersen     male 1955.0 51 party:63 Green Party DIW:E05005790 East Flegg             https://static-candidates.democracyclub.org.uk/media/images/images/8192.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
11707 10228 Joshua Michael Turton     Male 1994-03-20 51 party:63 Green Party DIW:E05005794 Magdalen                       2016-05-05 0 0           PP63   0
11708 11737 James Louis Borg     male   51 party:53 Labour Party DIW:E05005784 Bradwell North     http://www.gylabour.org.uk/james_borg http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11737.png   profile-photo john18   2016-05-05 0 0           PP53 Chocolate Chip Cookie 0
11709 11738 David Thomas Drewitt         51 party:52 Conservative and Unionist Party DIW:E05005784 Bradwell North                       2016-05-05 0 0           PP52   0
11710 11745 Sue Hacon         51 party:85 UK Independence Party (UKIP) DIW:E05005785 Bradwell South and Hopton   1.0                   2016-05-05 0 0           PP85   0
11711 11746 Julia Ann Miller         51 party:52 Conservative and Unionist Party DIW:E05005785 Bradwell South and Hopton                       2016-05-05 0 0           PP52   0
11712 11747 Hilary Jeanette Wainwright     female   51 party:53 Labour Party DIW:E05005785 Bradwell South and Hopton       http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11747.png   copyright-assigned john18   2016-05-05 0 0           PP53   0
11713 11753 Stephen Alfred Ames         51 party:52 Conservative and Unionist Party DIW:E05005789 Claydon                       2016-05-05 0 0           PP52   0
11714 11754 Carol Ann Borg     female   51 party:53 Labour Party DIW:E05005789 Claydon   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11754.png   copyright-assigned john18   2016-05-05 0 0           PP53   0
11715 11755 Philip Malcolm Grimmer         51 party:85 UK Independence Party (UKIP) DIW:E05005789 Claydon                       2016-05-05 0 0           PP85   0
11716 11762 Peter Fitzgerald         51 party:85 UK Independence Party (UKIP) DIW:E05005792 Gorleston                       2016-05-05 0 0           PP85   0
11717 11763 Emma Claire Flaxman-Taylor         51 party:52 Conservative and Unionist Party DIW:E05005792 Gorleston   1.0                   2016-05-05 0 0           PP52   0
11718 11768 Margaret Mary Greenacre         51 party:52 Conservative and Unionist Party DIW:E05005798 Southtown and Cobholm                       2016-05-05 0 0           PP52   0
11719 11769 Gary Paige         51 party:85 UK Independence Party (UKIP) DIW:E05005798 Southtown and Cobholm                       2016-05-05 0 0           PP85   0
11720 11770 Paula Waters-Bunn     female   51 party:53 Labour Party DIW:E05005798 Southtown and Cobholm   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11770.png   profile-photo john18   2016-05-05 0 0           PP53   0
11721 11771 Patricia Elizabeth Page         51 party:52 Conservative and Unionist Party DIW:E05005794 Magdalen                       2016-05-05 0 0           PP52   0
11722 11772 Sylvia Pratt     female   51 party:53 Labour Party DIW:E05005794 Magdalen   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11772.png   profile-photo john18   2016-05-05 0 0           PP53   0
11723 11773 Michael Thomas Jeal     male   51 party:53 Labour Party DIW:E05005795 Nelson   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11773.png   profile-photo john18   2016-05-05 0 0           PP53   0
11724 11774 Aurelio Spinola         51 party:85 UK Independence Party (UKIP) DIW:E05005795 Nelson                       2016-05-05 0 0           PP85   0
11725 11775 Anthony Chester Taylor         51 party:52 Conservative and Unionist Party DIW:E05005795 Nelson                       2016-05-05 0 0           PP52   0
11726 11776 Tony Harris         51 party:90 Liberal Democrats DIW:E05005788 Central And Northgate                       2016-05-05 0 0           PP90   0
11727 11777 Lee Paul Sutton     male   51 party:53 Labour Party DIW:E05005788 Central And Northgate       http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11777.png   profile-photo john18   2016-05-05 0 0           PP53   0
11728 11778 John Cyril Taylor         51 party:52 Conservative and Unionist Party DIW:E05005788 Central And Northgate                       2016-05-05 0 0           PP52   0
11729 11779 Chris Walch         51 party:85 UK Independence Party (UKIP) DIW:E05005788 Central And Northgate   1.0                   2016-05-05 0 0           PP85   0
11730 11780 Cliff Cotgrove         51 party:85 UK Independence Party (UKIP) DIW:E05005796 Ormesby                       2016-05-05 0 0           PP85   0
11731 11781 Charles Joseph Reynolds         51 party:52 Conservative and Unionist Party DIW:E05005796 Ormesby   1.0                   2016-05-05 0 0           PP52   0
11732 11782 John Simmons     male 1983.0 51 joint-party:53-119 Labour and Co-operative Party DIW:E05005796 Ormesby     http://www.gylabour.org.uk/john_simmons http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11782.png   profile-photo john18   2016-05-05 0 0           joint-party:53-119 Bourbon 0
11733 11783 Tracey Ann Darnell         51 party:63 Green Party DIW:E05005797 St Andrews                       2016-05-05 0 0           PP63   0
11734 11784 Marlene Ellen Fairhead     female   51 party:53 Labour Party DIW:E05005797 St Andrews   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11784.png   profile-photo john18   2016-05-05 0 0           PP53   0
11735 11785 Peter Phipps         51 party:85 UK Independence Party (UKIP) DIW:E05005797 St Andrews                       2016-05-05 0 0           PP85   0
11736 11786 George William Rogers         51 party:52 Conservative and Unionist Party DIW:E05005797 St Andrews                       2016-05-05 0 0           PP52   0
11737 11787 Graham Paul Carpenter         51 party:52 Conservative and Unionist Party DIW:E05005800 Yarmouth North                       2016-05-05 0 0           PP52   0
11738 11788 Nicholas Mark Dyer         51 party:90 Liberal Democrats DIW:E05005800 Yarmouth North                       2016-05-05 0 0           PP90   0
11739 11789 Paul Charles Hammond         51 party:85 UK Independence Party (UKIP) DIW:E05005800 Yarmouth North   1.0                   2016-05-05 0 0           PP85   0
11740 11790 Christina Horne     female 1957.0 51 joint-party:53-119 Labour and Co-operative Party DIW:E05005800 Yarmouth North       http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11790.png   copyright-assigned john18   2016-05-05 0 0           joint-party:53-119   0
11741 11791 James William Bensly         51 party:52 Conservative and Unionist Party DIW:E05005790 East Flegg   1.0                   2016-05-05 0 0           PP52   0
11742 11792 Gary William Boyd         51 party:53 Labour Party DIW:E05005790 East Flegg                       2016-05-05 0 0           PP53   0
11743 11793 Carly Anne Webb         51 party:85 UK Independence Party (UKIP) DIW:E05005790 East Flegg                       2016-05-05 0 0           PP85   0
11744 11794 Barry George Coleman         51 party:52 Conservative and Unionist Party DIW:E05005799 West Flegg   1.0                   2016-05-05 0 0           PP52   0
11745 11795 Christina Stewart     female   51 party:53 Labour Party DIW:E05005799 West Flegg     http://www.gylabour.org.uk/christina_stewart http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/35840.png   profile-photo john18   2016-05-05 0 0   35840.0       PP53   0
Powered by Datasette · Query took 0.688ms