home / democracyclub

democracyclub

Custom SQL query returning 60 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
9757 886 John Beirne     male   30 ynmp-party:2 Independent MTW:E05000927 Sutton                       2016-05-05 0 0   5513.0       ynmp-party:2   0
9758 3797 Brian Spencer     male   30 party:90 Liberal Democrats MTW:E05000927 Sutton             https://static-candidates.democracyclub.org.uk/media/images/images/3797.png   other rml http://www.sthelensstar.co.uk/news/15272340.Former_council_leader_Brian_Spencer_to_stand_as_Lib_Dems_announce_general_election_candidates/ 2016-05-05 0 0   15928.0       PP90   0
9759 13531 Charlie Preston         30 party:53 Labour Party MTW:E05000919 Earlestown                       2016-05-05 0 0           PP53   0
9760 13532 Mark Paul Sherman         30 party:85 UK Independence Party (UKIP) MTW:E05000919 Earlestown                       2016-05-05 0 0           PP85   0
9761 13533 Les Skeetch         30 party:52 Conservative and Unionist Party MTW:E05000919 Earlestown                       2016-05-05 0 0           PP52   0
9762 13986 Anthony James Burns Mr   Male   30 party:53 Labour Party MTW:E05000921 Haydock                       2016-05-05 0 0           PP53   0
9763 13992 Mark Joseph Hitchen Mr   Male   30 party:85 UK Independence Party (UKIP) MTW:E05000921 Haydock                       2016-05-05 0 0           PP85   0
9764 13993 Melanie Ann Marie Lee Ms   Female   30 party:52 Conservative and Unionist Party MTW:E05000921 Haydock                       2016-05-05 0 0           PP52   0
9765 15875 Judith Margaret Collins         30 party:52 Conservative and Unionist Party MTW:E05000916 Billinge and Seneley Green                       2016-05-05 0 0           PP52   0
9766 15876 Dennis McDonnell         30 party:53 Labour Party MTW:E05000916 Billinge and Seneley Green                       2016-05-05 0 0           PP53   0
9767 15877 Peter Peers Mr   male   30 party:85 UK Independence Party (UKIP) MTW:E05000916 Billinge and Seneley Green     http://ukipnw.org.uk/branches/merseyside/ukip-st-helens/       https://static-candidates.democracyclub.org.uk/media/images/images/15877.png   public-domain ripperger2345   2016-05-05 0 0           PP85   0
9768 15878 Nancy Jane Ashcroft         30 party:52 Conservative and Unionist Party MTW:E05000917 Blackbrook                       2016-05-05 0 0           PP52   0
9769 15879 Barry Joseph Critchley         30 party:85 UK Independence Party (UKIP) MTW:E05000917 Blackbrook                       2016-05-05 0 0           PP85   0
9770 15880 Alan Cunliffe         30 party:53 Labour Party MTW:E05000917 Blackbrook                       2016-05-05 0 0           PP53   0
9771 15881 David O'Keefe         30 party:63 Green Party MTW:E05000918 Bold                       2016-05-05 0 0   41880.0       PP63   0
9772 15882 Ian Edward Pennington         30 party:85 UK Independence Party (UKIP) MTW:E05000918 Bold                       2016-05-05 0 0           PP85   0
9773 15883 John Wiseman         30 joint-party:53-119 Labour and Co-operative Party MTW:E05000918 Bold                       2016-05-05 0 0           joint-party:53-119   0
9774 15884 Barbara Evelyne Woodcock         30 party:52 Conservative and Unionist Party MTW:E05000918 Bold                       2016-05-05 0 0           PP52   0
9775 15889 Kathleen Sheila Barton         30 party:52 Conservative and Unionist Party MTW:E05000920 Eccleston                       2016-05-05 0 0           PP52   0
9776 15890 Alex Graham         30 joint-party:53-119 Labour and Co-operative Party MTW:E05000920 Eccleston                       2016-05-05 0 0           joint-party:53-119   0
9777 15891 Teresa Veronica Sims         30 party:90 Liberal Democrats MTW:E05000920 Eccleston                       2016-05-05 0 0           PP90   0
9778 15892 Susan Gwyneth Wagstaff         30 party:85 UK Independence Party (UKIP) MTW:E05000920 Eccleston                       2016-05-05 0 0           PP85   0
9779 15897 Laurence Christopher Allen         30 party:85 UK Independence Party (UKIP) MTW:E05000922 Moss Bank                       2016-05-05 0 0           PP85   0
9780 15898 Steve Broughton         30 ynmp-party:2 Independent MTW:E05000922 Moss Bank                       2016-05-05 0 0           ynmp-party:2   0
9781 15899 Deb Connor         30 party:63 Green Party MTW:E05000922 Moss Bank                       2016-05-05 0 0           PP63   0
9782 15900 Margaret Hilda Ethel Harvey         30 party:52 Conservative and Unionist Party MTW:E05000922 Moss Bank                       2016-05-05 0 0           PP52   0
9783 15901 Paul Michael John Lynch         30 joint-party:53-119 Labour and Co-operative Party MTW:E05000922 Moss Bank                       2016-05-05 0 0           joint-party:53-119   0
9784 15904 John Philip Cunliffe         30 party:52 Conservative and Unionist Party MTW:E05000923 Newton                       2016-05-05 0 0           PP52   0
9785 15905 Seve Gomez-Aspron         30 party:53 Labour Party MTW:E05000923 Newton                       2016-05-05 0 0           PP53   0
9786 15906 Rachel Parkinson Ms   Female 1968.0 30 party:63 Green Party MTW:E05000923 Newton     https://my.greenparty.org.uk/candidates/106216       https://static-candidates.democracyclub.org.uk/media/images/images/15906.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106216 2016-05-05 0 0           PP63   0
9787 15907 Mark Stephen Richardson         30 party:85 UK Independence Party (UKIP) MTW:E05000923 Newton                       2016-05-05 0 0           PP85   0
9788 15908 David James Smith         30 party:90 Liberal Democrats MTW:E05000923 Newton                       2016-05-05 0 0           PP90   0
9789 15913 Andy Bowden         30 party:53 Labour Party MTW:E05000924 Parr                       2016-05-05 0 0           PP53   0
9790 15914 Paul Brown         30 ynmp-party:2 Independent MTW:E05000924 Parr                       2016-05-05 0 0           ynmp-party:2   0
9791 15915 Susan Levy         30 party:85 UK Independence Party (UKIP) MTW:E05000924 Parr                       2016-05-05 0 0           PP85   0
9792 15916 Madeleine Patricia Wilcock         30 party:52 Conservative and Unionist Party MTW:E05000924 Parr                       2016-05-05 0 0           PP52   0
9793 15917 Alex Mitchell         30 party:53 Labour Party MTW:E05000925 Rainford                       2016-05-05 0 0           PP53   0
9794 15919 Rob Reynolds         30 party:52 Conservative and Unionist Party MTW:E05000925 Rainford                       2016-05-05 0 0           PP52   0
9795 15920 Barrie Andrew Grunewald         30 party:53 Labour Party MTW:E05000926 Rainhill                       2016-05-05 0 0           PP53   0
9796 15921 Graham Samuel Woodhouse         30 party:52 Conservative and Unionist Party MTW:E05000926 Rainhill                       2016-05-05 0 0           PP52   0
9797 15925 Mark Stephen Collins         30 party:52 Conservative and Unionist Party MTW:E05000927 Sutton                       2016-05-05 0 0           PP52   0
9798 15926 John Michael Fairhurst         30 party:85 UK Independence Party (UKIP) MTW:E05000927 Sutton                       2016-05-05 0 0           PP85   0
9799 15927 Jimmy Jackson         30 joint-party:53-119 Labour and Co-operative Party MTW:E05000927 Sutton                       2016-05-05 0 0           joint-party:53-119   0
9800 15932 Nova Louise Charlton         30 party:53 Labour Party MTW:E05000928 Thatto Heath                       2016-05-05 0 0           PP53   0
9801 15933 Lisa Mackarell         30 party:52 Conservative and Unionist Party MTW:E05000928 Thatto Heath                       2016-05-05 0 0           PP52   0
9802 15934 Tony Rundle         30 party:85 UK Independence Party (UKIP) MTW:E05000928 Thatto Heath                       2016-05-05 0 0           PP85   0
9803 15940 Jonathan Casson         30 ynmp-party:2 Independent MTW:E05000929 Town Centre                       2016-05-05 0 0           ynmp-party:2   0
9804 15941 Lynn Susan Clarke         30 party:53 Labour Party MTW:E05000929 Town Centre                       2016-05-05 0 0           PP53   0
9805 15942 Paul David Leyland         30 party:85 UK Independence Party (UKIP) MTW:E05000929 Town Centre                       2016-05-05 0 0           PP85   0
9806 15943 Henry John Patrick Spriggs         30 party:52 Conservative and Unionist Party MTW:E05000929 Town Centre                       2016-05-05 0 0           PP52   0
9807 15944 Richard William Barton         30 party:52 Conservative and Unionist Party MTW:E05000930 West Park                       2016-05-05 0 0           PP52   0
9808 15945 Martin William Ellison         30 party:85 UK Independence Party (UKIP) MTW:E05000930 West Park                       2016-05-05 0 0           PP85   0
9809 15946 Derek Paul Long         30 party:53 Labour Party MTW:E05000930 West Park                       2016-05-05 0 0           PP53   0
9810 15947 Jessica Ayesha Northey Dr   Female   30 party:63 Green Party MTW:E05000930 West Park     https://my.greenparty.org.uk/candidates/106217       https://static-candidates.democracyclub.org.uk/media/images/images/15947.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106217 2016-05-05 0 0   34183.0       PP63   0
9811 15948 Paul Joseph Pritchard         30 party:53 Labour Party MTW:E05000930 West Park                       2016-05-05 0 0           PP53   0
9812 15953 Wally Ashcroft         30 party:52 Conservative and Unionist Party MTW:E05000931 Windle                       2016-05-05 0 0           PP52   0
9813 15954 Gill Neal         30 party:53 Labour Party MTW:E05000931 Windle                       2016-05-05 0 0           PP53   0
9814 15955 Maria Alison Parr         30 party:85 UK Independence Party (UKIP) MTW:E05000931 Windle                       2016-05-05 0 0           PP85   0
9815 15956 Ann Shacklady-Smith         30 party:63 Green Party MTW:E05000931 Windle                       2016-05-05 0 0           PP63   0
9816 42173 Tony Parr         30 party:85 UK Independence Party (UKIP) MTW:E05000925 Rainford                       2016-05-05 0 0   15918.0       PP85   0
Powered by Datasette · Query took 0.782ms