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
13706 156 David Blackburn     male   79 party:63 Green Party MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP63   0
13707 482 Mike Davies     male   79 party:67 Alliance For Green Socialism MTW:E05001419 Chapel Allerton             https://static-candidates.democracyclub.org.uk/media/images/images/482.png   other j0e_m Provided by the candidate to democlub for use on public website. 2016-05-05 0 0           PP67   0
13708 503 Eleanor Tunnicliffe     female   79 party:53 Labour Party MTW:E05001440 Roundhay             https://static-candidates.democracyclub.org.uk/media/images/images/503.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   14003.0       PP53   0
13709 992 Aqila Choudhry     female   79 party:90 Liberal Democrats MTW:E05001436 Morley South     http://www.libdems.org.uk/aqila_choudhry       https://static-candidates.democracyclub.org.uk/media/images/5481e91bb150e238702c0630.png   profile-photo     2016-05-05 0 0           PP90   0
13710 1741 Barry Anderson     male   79 party:52 Conservative and Unionist Party MTW:E05001411 Adel and Wharfedale       http://barryanderson.yourcllr.com/     https://static-candidates.democracyclub.org.uk/media/images/images/1741.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9284.0       PP52   0
13711 2420 David Daniel     male   79 party:85 UK Independence Party (UKIP) MTW:E05001439 Rothwell                       2016-05-05 0 0           PP85   0
13712 4370 Alex Sobel Mr   male 1975.0 79 joint-party:53-119 Labour and Co-operative Party MTW:E05001434 Moortown     https://party.coop/person/alex-sobel/ http://www.alexsobel.org/ https://en.wikipedia.org/wiki/Alex_Sobel http://uk.linkedin.com/pub/alex-sobel/4/71a/627/en https://static-candidates.democracyclub.org.uk/media/images/5481e82fb150e238702c05a8.png   profile-photo     2016-05-05 0 0   4951.0       joint-party:53-119   0
13713 4815 Tim Goodall     male   79 party:63 Green Party MTW:E05001434 Moortown     http://yorkshireandhumber.greenparty.org.uk/candidates/tim-goodall.html       https://static-candidates.democracyclub.org.uk/media/images/54c1999904fa01fd0c8356be.png         2016-05-05 0 0           PP63   0
13714 5052 Luke Barry Senior     male   79 party:85 UK Independence Party (UKIP) MTW:E05001415 Beeston and Holbeck             https://static-candidates.democracyclub.org.uk/media/images/553c0bbcec0766d3759c0473.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/UKIPLeedsC 2016-05-05 0 0           PP85   0
13715 5302 Roger Tattersall     male   79 party:85 UK Independence Party (UKIP) MTW:E05001428 Horsforth     http://ukip-wlp.org.uk/campaigns/general-election-2015/pudsey/     http://uk.linkedin.com/pub/roger-tattersall/11/76a/135/en https://static-candidates.democracyclub.org.uk/media/images/551818e7249b917507bee54f.png   profile-photo JPCarrington   2016-05-05 0 0   16485.0       PP85   0
13716 5537 Ryan Stephenson     male   79 party:52 Conservative and Unionist Party MTW:E05001426 Harewood     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Stephenson_Ryan.aspx       https://static-candidates.democracyclub.org.uk/media/images/550b60213676900a02e16447.png   copyright-assigned RS1 I own the photo 2016-05-05 0 0   42909.0       PP52   0
13717 5691 Bob Buxton     male 1979.0 79 party:2120 Yorkshire First MTW:E05001425 Guiseley and Rawdon             https://static-candidates.democracyclub.org.uk/media/images/54ce7b6595590a102032048e.png         2016-05-05 0 0           PP2120 Custard Creams 0
13718 5835 Paul Anthony Spivey Mr   Male 1960-07-06 79 party:85 UK Independence Party (UKIP) MTW:E05001431 Kippax and Methley                       2016-05-05 0 0   34683.0       PP85   0
13719 5836 Warren Hendon Mr   Male   79 party:85 UK Independence Party (UKIP) MTW:E05001412 Alwoodley             https://static-candidates.democracyclub.org.uk/media/images/55167d2d929f1bbe286be00e.png   public-domain HENDON   2016-05-05 0 0   2353;7703       PP85   0
13720 5837 Mark Stephen Maniatt     Male   79 party:85 UK Independence Party (UKIP) MTW:E05001421 Cross Gates and Whinmoor                       2016-05-05 0 0           PP85   0
13721 6073 Martin Hemingway     male 1953-11-07 79 party:63 Green Party MTW:E05001442 Weetwood     https://my.greenparty.org.uk/candidates/106034 http://martinhemingway.blogspot.com/     https://static-candidates.democracyclub.org.uk/media/images/5526953959bbc5c063445be4.png   profile-photo Sokuto12 I am a Yorkshire regional Green Party officer. 2016-05-05 0 0   157;18891       PP63   0
13722 6074 Emma Carter     female   79 party:63 Green Party MTW:E05001411 Adel and Wharfedale       http://yorkshireandhumber.greenparty.org.uk/candidates/leeds-north-east-emma-carter.html     https://static-candidates.democracyclub.org.uk/media/images/images/6074.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9285.0       PP63   0
13723 6075 Kate Bisson     female 1981.0 79 party:63 Green Party MTW:E05001416 Bramley and Stanningley     http://yorkshireandhumber.greenparty.org.uk/candidates/leeds-east-kate-bisson.html     https://www.linkedin.com/profile/view?id=35457327&trk=nav_responsive_tab_profile https://static-candidates.democracyclub.org.uk/media/images/54ed083eadfdc13b3b0ff458.jpg         2016-05-05 0 0           PP63   0
13724 6181 Ben Mayor     male   79 party:804 Trade Unionist and Socialist Coalition MTW:E05001429 Hyde Park and Woodhouse             https://static-candidates.democracyclub.org.uk/media/images/5517f827249b917507bee51a.png   other SocialistIain This is the photo we have sent to the press for use in articles about Ben 2016-05-05 0 0           PP804   0
13725 6299 Anne Murgatroyd     female   79 party:85 UK Independence Party (UKIP) MTW:E05001416 Bramley and Stanningley             https://static-candidates.democracyclub.org.uk/media/images/552a7ebe5b858ee163ed6365.png   copyright-assigned meganne121 This is my own photograph of myself 2016-05-05 0 0           PP85 Chocolate chip cookie 0
13726 7889 Penny Goodman Dr   female 1976.0 79 party:90 Liberal Democrats MTW:E05001427 Headingley       http://headingley.focusteam.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7889.png   profile-photo penny2 Public profile photo: https://www.facebook.com/headingleylibdems/photos/pb.966475616728891.-2207520000.1459435492./966477350062051/?type=3&theater 2016-05-05 0 0   36627.0       PP90   0
13727 8163 Iain Dalton     Male 1986.0 79 party:804 Trade Unionist and Socialist Coalition MTW:E05001430 Killingbeck and Seacroft             https://static-candidates.democracyclub.org.uk/media/images/images/8163.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   15258.0       PP804   0
13728 8515 Glenn Morley     male   79 party:85 UK Independence Party (UKIP) MTW:E05001411 Adel and Wharfedale                       2016-05-05 0 0           PP85   0
13729 8516 Lindon Dove     male   79 party:85 UK Independence Party (UKIP) MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP85   0
13730 8517 David Caldwell     male   79 party:85 UK Independence Party (UKIP) MTW:E05001414 Armley                       2016-05-05 0 0           PP85   0
13731 8518 Geoff Holloran     male   79 party:85 UK Independence Party (UKIP) MTW:E05001417 Burmantofts and Richmond Hill                       2016-05-05 0 0           PP85   0
13732 8519 Malcolm Steele     male   79 party:85 UK Independence Party (UKIP) MTW:E05001418 Calverley and Farsley                       2016-05-05 0 0           PP85   0
13733 8520 Sheila Valerie Store     female   79 party:85 UK Independence Party (UKIP) MTW:E05001419 Chapel Allerton                       2016-05-05 0 0           PP85   0
13734 8521 Brian Weatherill     male   79 party:85 UK Independence Party (UKIP) MTW:E05001420 City and Hunslet                       2016-05-05 0 0           PP85   0
13735 8524 Tony Roberts     male   79 party:85 UK Independence Party (UKIP) MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP85   0
13736 8525 Terry Harkin     male   79 party:85 UK Independence Party (UKIP) MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP85   0
13737 8526 Khalil Mohammed Kungulilo     male   79 party:85 UK Independence Party (UKIP) MTW:E05001424 Gipton and Harehills                       2016-05-05 0 0           PP85   0
13738 8527 Lynn Christine Parker     female   79 party:85 UK Independence Party (UKIP) MTW:E05001425 Guiseley and Rawdon                       2016-05-05 0 0           PP85   0
13739 8528 Rosemary Marian O'Dea     female   79 party:85 UK Independence Party (UKIP) MTW:E05001426 Harewood                       2016-05-05 0 0           PP85   0
13740 8530 Paul William Thomas Denner     male   79 party:85 UK Independence Party (UKIP) MTW:E05001427 Headingley                       2016-05-05 0 0           PP85   0
13741 8532 Joe Murgatroyd     male   79 party:85 UK Independence Party (UKIP) MTW:E05001429 Hyde Park and Woodhouse                       2016-05-05 0 0           PP85   0
13742 8533 Steve Leak     male   79 party:85 UK Independence Party (UKIP) MTW:E05001430 Killingbeck and Seacroft                       2016-05-05 0 0           PP85   0
13743 8534 Cain Weber     male   79 party:85 UK Independence Party (UKIP) MTW:E05001432 Kirkstall                       2016-05-05 0 0           PP85   0
13744 8535 Craig Sweaton     male   79 party:85 UK Independence Party (UKIP) MTW:E05001433 Middleton Park                       2016-05-05 0 0           PP85   0
13745 8536 Harvey Alexander     male   79 party:85 UK Independence Party (UKIP) MTW:E05001434 Moortown                       2016-05-05 0 0           PP85   0
13746 8537 Peter Morgan     male   79 party:85 UK Independence Party (UKIP) MTW:E05001435 Morley North                       2016-05-05 0 0           PP85   0
13747 8538 David Kent     male   79 party:85 UK Independence Party (UKIP) MTW:E05001436 Morley South                       2016-05-05 0 0           PP85   0
13748 8539 Tom Hollings     male   79 party:85 UK Independence Party (UKIP) MTW:E05001437 Otley and Yeadon                       2016-05-05 0 0           PP85   0
13749 8540 Kath Tattersall     female   79 party:85 UK Independence Party (UKIP) MTW:E05001438 Pudsey                       2016-05-05 0 0           PP85   0
13750 8541 Steven Bell     male   79 party:85 UK Independence Party (UKIP) MTW:E05001440 Roundhay                       2016-05-05 0 0           PP85   0
13751 8542 Phil Moore     male   79 party:85 UK Independence Party (UKIP) MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP85   0
13752 8543 Mike Cullen     male   79 party:85 UK Independence Party (UKIP) MTW:E05001442 Weetwood                       2016-05-05 0 0           PP85   0
13753 8544 Tina Janette Smith     female   79 party:85 UK Independence Party (UKIP) MTW:E05001443 Wetherby                       2016-05-05 0 0           PP85   0
13754 9276 John Hamilton Hardy         79 party:53 Labour Party MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP53   0
13755 9277 Robert Hugh Jacques     male   79 party:90 Liberal Democrats MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP90   0
13756 9278 Hayley Laura Nancolas     female   79 party:52 Conservative and Unionist Party MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP52   0
13757 9286 Cheryl Kebede         79 party:90 Liberal Democrats MTW:E05001411 Adel and Wharfedale                       2016-05-05 0 0           PP90   0
13758 9287 Paul Ian Wray Mr   Male 1986-02-27 79 party:53 Labour Party MTW:E05001411 Adel and Wharfedale       http://www.paulwrayleeds.com     https://static-candidates.democracyclub.org.uk/media/images/images/9287.png   other PaulWray   2016-05-05 0 0           PP53 Bourbon 0
13759 9289 Neil Alan Buckley         79 party:52 Conservative and Unionist Party MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP52   0
13760 9290 Brian Jackson         79 party:67 Alliance For Green Socialism MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP67   0
13761 9291 Miriam Leontine Moss         79 party:63 Green Party MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP63   0
13762 9292 Roderic Parker         79 party:90 Liberal Democrats MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP90   0
13763 9293 Keith Michael White         79 party:53 Labour Party MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP53   0
13764 9306 Tim Atkin         79 party:52 Conservative and Unionist Party MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP52   0
13765 9307 Lyssie Page         79 party:63 Green Party MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP63   0
13766 9308 Karen Renshaw     female   79 party:53 Labour Party MTW:E05001413 Ardsley and Robin Hood             https://static-candidates.democracyclub.org.uk/media/images/images/9308.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=2172921410 2016-05-05 0 0           PP53   0
13767 9309 Benjamin Lloyd Ward         79 party:90 Liberal Democrats MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP90   0
13768 9323 Christine Amy Glover     female   79 party:90 Liberal Democrats MTW:E05001414 Armley                       2016-05-05 0 0           PP90   0
13769 9324 Alison Natalie Kay Lowe     female   79 party:53 Labour Party MTW:E05001414 Armley             https://static-candidates.democracyclub.org.uk/media/images/images/9324.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=2421782210 2016-05-05 0 0           PP53   0
13770 9325 Shane Gary Morgan         79 party:52 Conservative and Unionist Party MTW:E05001414 Armley                       2016-05-05 0 0           PP52   0
13771 9326 David Michael Smith     male   79 party:63 Green Party MTW:E05001414 Armley                       2016-05-05 0 0           PP63   0
13772 9327 Beth Sutcliffe         79 party:804 Trade Unionist and Socialist Coalition MTW:E05001414 Armley                       2016-05-05 0 0           PP804   0
13773 9328 Adam David John Dent     male   79 party:63 Green Party MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP63   0
13774 9329 Angela Gabriel         79 party:53 Labour Party MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP53   0
13775 9330 Kathryn Elizabeth Gagen     female   79 party:90 Liberal Democrats MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP90   0
13776 9331 Kevin Michael Pattison         79 party:804 Trade Unionist and Socialist Coalition MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP804   0
13777 9332 Robert James William Winfield         79 party:52 Conservative and Unionist Party MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP52   0
13778 9343 Serena Samantha Glover         79 party:90 Liberal Democrats MTW:E05001416 Bramley and Stanningley                       2016-05-05 0 0           PP90   0
13779 9344 Caroline Anne Gruen     female   79 party:53 Labour Party MTW:E05001416 Bramley and Stanningley   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/9344.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=4105307241 2016-05-05 0 0           PP53   0
13780 9345 Alex Nancolas         79 party:52 Conservative and Unionist Party MTW:E05001416 Bramley and Stanningley                       2016-05-05 0 0   36989.0       PP52   0
13781 13933 Ines Newell         79 party:52 Conservative and Unionist Party MTW:E05001431 Kippax and Methley                       2016-05-05 0 0           PP52   0
13782 13934 Stephen Paul Terry         79 party:63 Green Party MTW:E05001431 Kippax and Methley                       2016-05-05 0 0           PP63   0
13783 13935 Mary Harland     female   79 party:53 Labour Party MTW:E05001431 Kippax and Methley             https://static-candidates.democracyclub.org.uk/media/images/images/13935.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=3007779129 2016-05-05 0 0           PP53 Shortbread 0
13784 13936 Elizabeth Hindley         79 party:90 Liberal Democrats MTW:E05001431 Kippax and Methley                       2016-05-05 0 0           PP90   0
13785 13999 Malcolm Scott Christie         79 party:67 Alliance For Green Socialism MTW:E05001440 Roundhay                       2016-05-05 0 0           PP67   0
13786 14000 Paul Charles Ellis         79 party:63 Green Party MTW:E05001440 Roundhay                       2016-05-05 0 0           PP63   0
13787 14001 Najeeb Iqbal         79 party:90 Liberal Democrats MTW:E05001440 Roundhay                       2016-05-05 0 0           PP90   0
13788 14002 Michael Lowry         79 party:52 Conservative and Unionist Party MTW:E05001440 Roundhay                       2016-05-05 0 0           PP52   0
13789 14032 David Thomas Corry         79 party:63 Green Party MTW:E05001426 Harewood                       2016-05-05 0 0           PP63   0
13790 14033 Sarah Karen Howell         79 party:90 Liberal Democrats MTW:E05001426 Harewood                       2016-05-05 0 0           PP90   0
13791 14034 Leo Verity         79 party:53 Labour Party MTW:E05001426 Harewood                       2016-05-05 0 0           PP53   0
13792 14171 Debra Coupar     female   79 party:53 Labour Party MTW:E05001441 Temple Newsam             https://static-candidates.democracyclub.org.uk/media/images/images/14171.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=712765683 2016-05-05 0 0           PP53   0
13793 14172 Sarah Ann Crossland         79 party:63 Green Party MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP63   0
13794 14173 Keith Cecil Norman         79 party:90 Liberal Democrats MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP90   0
13795 14174 David Schofield         79 party:52 Conservative and Unionist Party MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP52   0
13796 15255 Elizabeth Mary Hayes         79 party:52 Conservative and Unionist Party MTW:E05001430 Killingbeck and Seacroft                       2016-05-05 0 0           PP52   0
13797 15256 Jaimes Lewis Moran Mr   Male 1994-01-13 79 party:63 Green Party MTW:E05001430 Killingbeck and Seacroft     https://leeds.greenparty.org.uk/people/       https://static-candidates.democracyclub.org.uk/media/images/images/15256_YSgwHTW.png   profile-photo JLMoran I am the candidate, this photo is from a protest I attended, and is my current campaign profile photo. 2016-05-05 0 0   34680.0       PP63   0
13798 15257 Adam Douglas         79 party:90 Liberal Democrats MTW:E05001430 Killingbeck and Seacroft                       2016-05-05 0 0           PP90   0
13799 15259 Graham Hyde         79 party:53 Labour Party MTW:E05001430 Killingbeck and Seacroft   1.0                   2016-05-05 0 0           PP53   0
13800 15260 John Otley     male 1957.0 79 party:2120 Yorkshire First MTW:E05001430 Killingbeck and Seacroft           https://www.linkedin.com/in/john-otley-9362601b/ https://static-candidates.democracyclub.org.uk/media/images/images/15260.png   profile-photo sjorford https://www.facebook.com/john.otley 2016-05-05 0 0           PP2120   0
13801 15850 Daniel Peter Farrell         79 party:52 Conservative and Unionist Party MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP52   0
13802 15851 Mitchell Galdas         79 party:90 Liberal Democrats MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP90   0
13803 15852 Kieran White         79 party:63 Green Party MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP63   0
13804 16482 Ben Hall         79 party:63 Green Party MTW:E05001428 Horsforth                       2016-05-05 0 0           PP63   0
13805 16483 Ian Joseph McCargo Mr   male   79 joint-party:53-119 Labour and Co-operative Party MTW:E05001428 Horsforth     https://party.coop/person/ian-mccargo/       https://static-candidates.democracyclub.org.uk/media/images/images/16483_TUlHx9a.png   profile-photo ianmccargo2017   2016-05-05 0 0           joint-party:53-119   0
13806 16484 Richard John O'Callaghan         79 party:52 Conservative and Unionist Party MTW:E05001428 Horsforth                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.149ms