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
12661 5142 Diana Moore     Female 1971-01-06 65 party:63 Green Party DIW:E05011020 St David's     http://exeter.greenparty.org.uk/votegreen2015.html https://dianamooregreen.wordpress.com/blog-and-reflections/     https://static-candidates.democracyclub.org.uk/media/images/54932a6533aed1a20f97d805.png         2016-05-05 0 0   11419;27577       PP63   0
12662 5991 James Taghdissian     male 1982.0 65 party:52 Conservative and Unionist Party DIW:E05011021 St Loyes     http://www.exeterconservatives.co.uk/person/james-taghdissian http://www.jamestaghdissian.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/5524a134f0e9e2c82406ebae.png   profile-photo TimPatmore PPC profile picture: https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Taghdissian_James.aspx 2016-05-05 0 0   11434.0       PP52   0
12663 9585 Philip Michael Bialyk         65 party:53 Labour Party DIW:E05011013 Exwick   1.0                   2016-05-05 0 0           PP53   0
12664 9586 Lawrence Simon Harper         65 party:85 UK Independence Party (UKIP) DIW:E05011013 Exwick                       2016-05-05 0 0   27512.0       PP85   0
12665 9587 Steve Hawkins         65 party:52 Conservative and Unionist Party DIW:E05011013 Exwick                       2016-05-05 0 0           PP52   0
12666 9588 Benjamin Tomos Lewis Dr   Male 1991.0 65 party:52 Conservative and Unionist Party DIW:E05011013 Exwick             https://static-candidates.democracyclub.org.uk/media/images/images/9588.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52 Digestive 0
12667 9589 Caroline Emily Gwyneth Nottle         65 party:90 Liberal Democrats DIW:E05011013 Exwick                       2016-05-05 0 0           PP90   0
12668 9590 Ollie Pearson         65 party:53 Labour Party DIW:E05011013 Exwick   1.0                   2016-05-05 0 0           PP53   0
12669 9591 Stephen Leslie Porter         65 party:63 Green Party DIW:E05011013 Exwick                       2016-05-05 0 0           PP63   0
12670 9592 Rachel Helen Sutton         65 party:53 Labour Party DIW:E05011013 Exwick   1.0                   2016-05-05 0 0           PP53   0
12671 9593 Patricia White         65 party:52 Conservative and Unionist Party DIW:E05011013 Exwick                       2016-05-05 0 0           PP52   0
12672 9621 Andrew Wallace Bell         65 party:63 Green Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP63   0
12673 9622 Isabel Castle         65 party:63 Green Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP63   0
12674 9623 Emily Croft         65 party:52 Conservative and Unionist Party DIW:E05011011 Alphington                       2016-05-05 0 0   26552.0       PP52   0
12675 9624 Dutch Dudgeon         65 party:85 UK Independence Party (UKIP) DIW:E05011011 Alphington                       2016-05-05 0 0           PP85   0
12676 9625 Audaye Khalid Elesedy         65 party:63 Green Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP63   0
12677 9626 Bob Foale         65 party:53 Labour Party DIW:E05011011 Alphington   1.0                   2016-05-05 0 0           PP53   0
12678 9627 Aric Gilinsky         65 party:52 Conservative and Unionist Party DIW:E05011011 Alphington                       2016-05-05 0 0   27576.0       PP52   0
12679 9628 John Harvey         65 party:52 Conservative and Unionist Party DIW:E05011011 Alphington                       2016-05-05 0 0           PP52   0
12680 9629 Chris Musgrave         65 party:53 Labour Party DIW:E05011011 Alphington   1.0                   2016-05-05 0 0           PP53   0
12681 9630 Rod Ruffle         65 party:90 Liberal Democrats DIW:E05011011 Alphington                       2016-05-05 0 0           PP90   0
12682 9631 Steve Warwick         65 party:53 Labour Party DIW:E05011011 Alphington   1.0                   2016-05-05 0 0           PP53   0
12683 9658 Richard William Elliott         65 party:52 Conservative and Unionist Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP52   0
12684 9659 Rouben Scott Freeman         65 party:63 Green Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP63   0
12685 9660 Tristan Charles Leonard Harris     Male 1997-05-11 65 party:53 Labour Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP53   0
12686 9661 Robert Edward William Hughes-Chamberlain         65 party:53 Labour Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP53   0
12687 9662 Kevin John Mitchell         65 party:90 Liberal Democrats DIW:E05011012 Duryard & St James   1.0                   2016-05-05 0 0           PP90   0
12688 9663 Michael Norman Mitchell         65 party:90 Liberal Democrats DIW:E05011012 Duryard & St James                       2016-05-05 0 0   27507.0       PP90   0
12689 9665 Keith Owen         65 party:53 Labour Party DIW:E05011012 Duryard & St James   1.0                   2016-05-05 0 0           PP53   0
12690 9666 Bethany Payne     female   65 party:63 Green Party DIW:E05011012 Duryard & St James           https://www.linkedin.com/in/bethanypayne/           2016-05-05 0 0   27574.0       PP63   0
12691 9667 Percy Prowse         65 party:52 Conservative and Unionist Party DIW:E05011012 Duryard & St James   1.0                   2016-05-05 0 0   27508.0       PP52   0
12692 9671 Jenny Steer         65 party:63 Green Party DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP63   0
12693 9672 Nicholas George Sutton         65 party:90 Liberal Democrats DIW:E05011012 Duryard & St James                       2016-05-05 0 0           PP90   0
12694 9673 Sallie Cherie Waters         65 party:85 UK Independence Party (UKIP) DIW:E05011012 Duryard & St James                       2016-05-05 0 0   27509.0       PP85   0
12695 11005 Gill Baker         65 party:63 Green Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP63   0
12696 11006 Diana Beasley         65 party:85 UK Independence Party (UKIP) DIW:E05011014 Heavitree                       2016-05-05 0 0           PP85   0
12697 11007 Rob Davies         65 party:63 Green Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP63   0
12698 11008 Rosie Clare Denham         65 party:53 Labour Party DIW:E05011014 Heavitree   1.0                   2016-05-05 0 0           PP53   0
12699 11009 Olwen Margaret Foggin         65 party:53 Labour Party DIW:E05011014 Heavitree   1.0                   2016-05-05 0 0           PP53   0
12700 11010 Sheila Muriel Hobden         65 party:90 Liberal Democrats DIW:E05011014 Heavitree                       2016-05-05 0 0           PP90   0
12701 11011 Steve Jones         65 party:63 Green Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP63   0
12702 11012 Sam Morfey         65 party:52 Conservative and Unionist Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP52   0
12703 11013 Guy Steven Frank Richards         65 party:52 Conservative and Unionist Party DIW:E05011014 Heavitree                       2016-05-05 0 0           PP52   0
12704 11014 Greg Sheldon         65 party:53 Labour Party DIW:E05011014 Heavitree   1.0                   2016-05-05 0 0           PP53   0
12705 11120 Anne Patricia Back         65 party:85 UK Independence Party (UKIP) DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP85   0
12706 11121 Stephen Alexander Brimble         65 party:53 Labour Party DIW:E05011015 Mincinglake & Whipton   1.0                   2016-05-05 0 0           PP53   0
12707 11122 Peter William Edwards         65 party:53 Labour Party DIW:E05011015 Mincinglake & Whipton   1.0                   2016-05-05 0 0           PP53   0
12708 11123 Eddie Higgins         65 party:85 UK Independence Party (UKIP) DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP85   0
12709 11124 George Thomas Livesey         65 party:52 Conservative and Unionist Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP52   0
12710 11125 Emma Anita Morse         65 party:53 Labour Party DIW:E05011015 Mincinglake & Whipton   1.0                   2016-05-05 0 0           PP53   0
12711 11126 Bridget Catherine Oliver         65 party:63 Green Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP63   0
12712 11127 Paul Robert Geoffrey Rota         65 party:52 Conservative and Unionist Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP52   0
12713 11128 Alison Jane Sheridan     Female   65 party:85 UK Independence Party (UKIP) DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP85   0
12714 11129 Andrew Matthew Soper         65 party:90 Liberal Democrats DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP90   0
12715 11130 David Thompson         65 party:52 Conservative and Unionist Party DIW:E05011015 Mincinglake & Whipton                       2016-05-05 0 0           PP52   0
12716 11132 Azhar-Jamal Chaudhry     male   65 party:52 Conservative and Unionist Party DIW:E05011014 Heavitree           https://www.linkedin.com/in/azhar-chaudry-881375100/ https://static-candidates.democracyclub.org.uk/media/images/images/11132.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
12717 11139 Richard Arthur Branston         65 party:53 Labour Party DIW:E05011016 Newtown & St Leonard's   1.0                   2016-05-05 0 0           PP53   0
12718 11140 Andrew Cheesewright         65 party:63 Green Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP63   0
12719 11141 Jacqueline Barbara Holdstock         65 party:85 UK Independence Party (UKIP) DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP85   0
12720 11142 James Landymore         65 party:90 Liberal Democrats DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP90   0
12721 11143 Tom Milburn       1978.0 65 party:63 Green Party DIW:E05011016 Newtown & St Leonard's     https://exeter.greenparty.org.uk/elect-tom-milburn.html       https://static-candidates.democracyclub.org.uk/media/images/images/11143.png   copyright-assigned TOM_MILBURN This is my own photograph of myself 2016-05-05 0 0           PP63   0
12722 11144 John Murphy         65 party:52 Conservative and Unionist Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP52   0
12723 11145 Joe Powell         65 party:63 Green Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP63   0
12724 11146 Norman Shiel         65 party:52 Conservative and Unionist Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP52   0
12725 11147 Dave Smith     male   65 party:1918 Independence from Europe DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0   46845.0       PP1918   0
12726 11148 Roger David Spackman         65 party:53 Labour Party DIW:E05011016 Newtown & St Leonard's   1.0                   2016-05-05 0 0           PP53   0
12727 11149 Natalie Jane Vizard         65 party:53 Labour Party DIW:E05011016 Newtown & St Leonard's   1.0                   2016-05-05 0 0           PP53   0
12728 11150 Stephanie Warner         65 party:52 Conservative and Unionist Party DIW:E05011016 Newtown & St Leonard's                       2016-05-05 0 0           PP52   0
12729 11159 David Barker-Hahlo         65 party:63 Green Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP63   0
12730 11160 Alysa Freeman         65 party:63 Green Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP63   0
12731 11161 Daniel Ryan Gottschalk         65 party:53 Labour Party DIW:E05011017 Pennsylvania   1.0                   2016-05-05 0 0           PP53   0
12732 11162 Peter Holland         65 party:52 Conservative and Unionist Party DIW:E05011017 Pennsylvania   1.0                   2016-05-05 0 0           PP52   0
12733 11163 Anne Jobson         65 party:52 Conservative and Unionist Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0   27580.0       PP52   0
12734 11164 Alan Jones         65 party:52 Conservative and Unionist Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP52   0
12735 11165 Rachel Clare Lyons         65 party:53 Labour Party DIW:E05011017 Pennsylvania   1.0                   2016-05-05 0 0           PP53   0
12736 11166 Christine Elizabeth Raybould-Gooding         65 party:53 Labour Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP53   0
12737 11167 Kimberley Lauren Stansfield     female   65 party:90 Liberal Democrats DIW:E05011017 Pennsylvania                       2016-05-05 0 0           PP90   0
12738 11168 Lizzie Woodman         65 party:63 Green Party DIW:E05011017 Pennsylvania                       2016-05-05 0 0   27510.0       PP63   0
12739 11173 David James Harvey         65 party:53 Labour Party DIW:E05011018 Pinhoe   1.0                   2016-05-05 0 0           PP53   0
12740 11174 Diana Patricia Jones         65 party:63 Green Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP63   0
12741 11175 Mike Payne         65 party:90 Liberal Democrats DIW:E05011018 Pinhoe                       2016-05-05 0 0   27575.0       PP90   0
12742 11176 John Rogers         65 party:52 Conservative and Unionist Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP52   0
12743 11177 Ruth Smith         65 party:52 Conservative and Unionist Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP52   0
12744 11178 Cynthia Thompson         65 party:52 Conservative and Unionist Party DIW:E05011018 Pinhoe   1.0                   2016-05-05 0 0           PP52   0
12745 11179 Duncan Wood         65 party:53 Labour Party DIW:E05011018 Pinhoe   1.0                   2016-05-05 0 0           PP53   0
12746 11180 Laura Charis Adelaide Wright         65 party:53 Labour Party DIW:E05011018 Pinhoe                       2016-05-05 0 0           PP53   0
12747 11401 Lucille Baker         65 party:52 Conservative and Unionist Party DIW:E05011019 Priory                       2016-05-05 0 0           PP52   0
12748 11402 Nicola Guagliardo         65 party:52 Conservative and Unionist Party DIW:E05011019 Priory                       2016-05-05 0 0           PP52   0
12749 11403 Kate Hannan         65 party:53 Labour Party DIW:E05011019 Priory   1.0                   2016-05-05 0 0           PP53   0
12750 11404 Ellen McDonnell         65 party:90 Liberal Democrats DIW:E05011019 Priory                       2016-05-05 0 0           PP90   0
12751 11405 Lesley Sara Robson         65 party:53 Labour Party DIW:E05011019 Priory   1.0                   2016-05-05 0 0           PP53   0
12752 11406 Robert James Sheridan         65 party:85 UK Independence Party (UKIP) DIW:E05011019 Priory                       2016-05-05 0 0           PP85   0
12753 11407 Mario Trabucco         65 party:52 Conservative and Unionist Party DIW:E05011019 Priory                       2016-05-05 0 0           PP52   0
12754 11408 Tony Wardle         65 party:53 Labour Party DIW:E05011019 Priory   1.0                   2016-05-05 0 0           PP53   0
12755 11409 Lynn Susan Wetenhall         65 party:63 Green Party DIW:E05011019 Priory                       2016-05-05 0 0           PP63   0
12756 11414 Philip John Brock         65 party:90 Liberal Democrats DIW:E05011020 St David's                       2016-05-05 0 0           PP90   0
12757 11415 Stella Rose Brock         65 party:90 Liberal Democrats DIW:E05011020 St David's                       2016-05-05 0 0           PP90   0
12758 11416 Kevin Martin Chun         65 party:90 Liberal Democrats DIW:E05011020 St David's                       2016-05-05 0 0           PP90   0
12759 11417 Lewis Peter Griffiths Keen         65 party:53 Labour Party DIW:E05011020 St David's   1.0                   2016-05-05 0 0           PP53   0
12760 11418 Robert Lamb         65 party:53 Labour Party DIW:E05011020 St David's   1.0                   2016-05-05 0 0           PP53   0
12761 11420 Catherine Pierce         65 party:52 Conservative and Unionist Party DIW:E05011020 St David's                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.037ms