home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

185 rows where election = 79

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, wikipedia_url, linkedin_url, image_copyright, image_uploading_user, image_uploading_user_notes, old_person_ids, party_ec_id, favourite_biscuits

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id post_label mapit_url elected party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes election_date election_current party_lists_in_use party_list_position old_person_ids gss_code parlparse_id theyworkforyou_url party_ec_id favourite_biscuits cancelled_poll
13706 13706 156 David Blackburn     male   local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP63   0
13707 13707 482 Mike Davies     male   local.leeds.2016-05-05 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 13708 503 Eleanor Tunnicliffe     female   local.leeds.2016-05-05 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 13709 992 Aqila Choudhry     female   local.leeds.2016-05-05 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 13710 1741 Barry Anderson     male   local.leeds.2016-05-05 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 13711 2420 David Daniel     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001439 Rothwell                       2016-05-05 0 0           PP85   0
13712 13712 4370 Alex Sobel Mr   male 1975.0 local.leeds.2016-05-05 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 13713 4815 Tim Goodall     male   local.leeds.2016-05-05 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 13714 5052 Luke Barry Senior     male   local.leeds.2016-05-05 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 13715 5302 Roger Tattersall     male   local.leeds.2016-05-05 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 13716 5537 Ryan Stephenson     male   local.leeds.2016-05-05 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 13717 5691 Bob Buxton     male 1979.0 local.leeds.2016-05-05 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 13718 5835 Paul Anthony Spivey Mr   Male 1960-07-06 local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001431 Kippax and Methley                       2016-05-05 0 0   34683.0       PP85   0
13719 13719 5836 Warren Hendon Mr   Male   local.leeds.2016-05-05 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 13720 5837 Mark Stephen Maniatt     Male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001421 Cross Gates and Whinmoor                       2016-05-05 0 0           PP85   0
13721 13721 6073 Martin Hemingway     male 1953-11-07 local.leeds.2016-05-05 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 13722 6074 Emma Carter     female   local.leeds.2016-05-05 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 13723 6075 Kate Bisson     female 1981.0 local.leeds.2016-05-05 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 13724 6181 Ben Mayor     male   local.leeds.2016-05-05 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 13725 6299 Anne Murgatroyd     female   local.leeds.2016-05-05 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 13726 7889 Penny Goodman Dr   female 1976.0 local.leeds.2016-05-05 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 13727 8163 Iain Dalton     Male 1986.0 local.leeds.2016-05-05 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 13728 8515 Glenn Morley     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001411 Adel and Wharfedale                       2016-05-05 0 0           PP85   0
13729 13729 8516 Lindon Dove     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP85   0
13730 13730 8517 David Caldwell     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001414 Armley                       2016-05-05 0 0           PP85   0
13731 13731 8518 Geoff Holloran     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001417 Burmantofts and Richmond Hill                       2016-05-05 0 0           PP85   0
13732 13732 8519 Malcolm Steele     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001418 Calverley and Farsley                       2016-05-05 0 0           PP85   0
13733 13733 8520 Sheila Valerie Store     female   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001419 Chapel Allerton                       2016-05-05 0 0           PP85   0
13734 13734 8521 Brian Weatherill     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001420 City and Hunslet                       2016-05-05 0 0           PP85   0
13735 13735 8524 Tony Roberts     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP85   0
13736 13736 8525 Terry Harkin     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP85   0
13737 13737 8526 Khalil Mohammed Kungulilo     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001424 Gipton and Harehills                       2016-05-05 0 0           PP85   0
13738 13738 8527 Lynn Christine Parker     female   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001425 Guiseley and Rawdon                       2016-05-05 0 0           PP85   0
13739 13739 8528 Rosemary Marian O'Dea     female   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001426 Harewood                       2016-05-05 0 0           PP85   0
13740 13740 8530 Paul William Thomas Denner     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001427 Headingley                       2016-05-05 0 0           PP85   0
13741 13741 8532 Joe Murgatroyd     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001429 Hyde Park and Woodhouse                       2016-05-05 0 0           PP85   0
13742 13742 8533 Steve Leak     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001430 Killingbeck and Seacroft                       2016-05-05 0 0           PP85   0
13743 13743 8534 Cain Weber     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001432 Kirkstall                       2016-05-05 0 0           PP85   0
13744 13744 8535 Craig Sweaton     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001433 Middleton Park                       2016-05-05 0 0           PP85   0
13745 13745 8536 Harvey Alexander     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001434 Moortown                       2016-05-05 0 0           PP85   0
13746 13746 8537 Peter Morgan     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001435 Morley North                       2016-05-05 0 0           PP85   0
13747 13747 8538 David Kent     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001436 Morley South                       2016-05-05 0 0           PP85   0
13748 13748 8539 Tom Hollings     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001437 Otley and Yeadon                       2016-05-05 0 0           PP85   0
13749 13749 8540 Kath Tattersall     female   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001438 Pudsey                       2016-05-05 0 0           PP85   0
13750 13750 8541 Steven Bell     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001440 Roundhay                       2016-05-05 0 0           PP85   0
13751 13751 8542 Phil Moore     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP85   0
13752 13752 8543 Mike Cullen     male   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001442 Weetwood                       2016-05-05 0 0           PP85   0
13753 13753 8544 Tina Janette Smith     female   local.leeds.2016-05-05 79 party:85 UK Independence Party (UKIP) MTW:E05001443 Wetherby                       2016-05-05 0 0           PP85   0
13754 13754 9276 John Hamilton Hardy         local.leeds.2016-05-05 79 party:53 Labour Party MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP53   0
13755 13755 9277 Robert Hugh Jacques     male   local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP90   0
13756 13756 9278 Hayley Laura Nancolas     female   local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001422 Farnley and Wortley                       2016-05-05 0 0           PP52   0
13757 13757 9286 Cheryl Kebede         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001411 Adel and Wharfedale                       2016-05-05 0 0           PP90   0
13758 13758 9287 Paul Ian Wray Mr   Male 1986-02-27 local.leeds.2016-05-05 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 13759 9289 Neil Alan Buckley         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP52   0
13760 13760 9290 Brian Jackson         local.leeds.2016-05-05 79 party:67 Alliance For Green Socialism MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP67   0
13761 13761 9291 Miriam Leontine Moss         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP63   0
13762 13762 9292 Roderic Parker         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP90   0
13763 13763 9293 Keith Michael White         local.leeds.2016-05-05 79 party:53 Labour Party MTW:E05001412 Alwoodley                       2016-05-05 0 0           PP53   0
13764 13764 9306 Tim Atkin         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP52   0
13765 13765 9307 Lyssie Page         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP63   0
13766 13766 9308 Karen Renshaw     female   local.leeds.2016-05-05 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 13767 9309 Benjamin Lloyd Ward         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001413 Ardsley and Robin Hood                       2016-05-05 0 0           PP90   0
13768 13768 9323 Christine Amy Glover     female   local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001414 Armley                       2016-05-05 0 0           PP90   0
13769 13769 9324 Alison Natalie Kay Lowe     female   local.leeds.2016-05-05 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 13770 9325 Shane Gary Morgan         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001414 Armley                       2016-05-05 0 0           PP52   0
13771 13771 9326 David Michael Smith     male   local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001414 Armley                       2016-05-05 0 0           PP63   0
13772 13772 9327 Beth Sutcliffe         local.leeds.2016-05-05 79 party:804 Trade Unionist and Socialist Coalition MTW:E05001414 Armley                       2016-05-05 0 0           PP804   0
13773 13773 9328 Adam David John Dent     male   local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP63   0
13774 13774 9329 Angela Gabriel         local.leeds.2016-05-05 79 party:53 Labour Party MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP53   0
13775 13775 9330 Kathryn Elizabeth Gagen     female   local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP90   0
13776 13776 9331 Kevin Michael Pattison         local.leeds.2016-05-05 79 party:804 Trade Unionist and Socialist Coalition MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP804   0
13777 13777 9332 Robert James William Winfield         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001415 Beeston and Holbeck                       2016-05-05 0 0           PP52   0
13778 13778 9343 Serena Samantha Glover         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001416 Bramley and Stanningley                       2016-05-05 0 0           PP90   0
13779 13779 9344 Caroline Anne Gruen     female   local.leeds.2016-05-05 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 13780 9345 Alex Nancolas         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001416 Bramley and Stanningley                       2016-05-05 0 0   36989.0       PP52   0
13781 13781 13933 Ines Newell         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001431 Kippax and Methley                       2016-05-05 0 0           PP52   0
13782 13782 13934 Stephen Paul Terry         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001431 Kippax and Methley                       2016-05-05 0 0           PP63   0
13783 13783 13935 Mary Harland     female   local.leeds.2016-05-05 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 13784 13936 Elizabeth Hindley         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001431 Kippax and Methley                       2016-05-05 0 0           PP90   0
13785 13785 13999 Malcolm Scott Christie         local.leeds.2016-05-05 79 party:67 Alliance For Green Socialism MTW:E05001440 Roundhay                       2016-05-05 0 0           PP67   0
13786 13786 14000 Paul Charles Ellis         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001440 Roundhay                       2016-05-05 0 0           PP63   0
13787 13787 14001 Najeeb Iqbal         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001440 Roundhay                       2016-05-05 0 0           PP90   0
13788 13788 14002 Michael Lowry         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001440 Roundhay                       2016-05-05 0 0           PP52   0
13789 13789 14032 David Thomas Corry         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001426 Harewood                       2016-05-05 0 0           PP63   0
13790 13790 14033 Sarah Karen Howell         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001426 Harewood                       2016-05-05 0 0           PP90   0
13791 13791 14034 Leo Verity         local.leeds.2016-05-05 79 party:53 Labour Party MTW:E05001426 Harewood                       2016-05-05 0 0           PP53   0
13792 13792 14171 Debra Coupar     female   local.leeds.2016-05-05 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 13793 14172 Sarah Ann Crossland         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP63   0
13794 13794 14173 Keith Cecil Norman         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP90   0
13795 13795 14174 David Schofield         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001441 Temple Newsam                       2016-05-05 0 0           PP52   0
13796 13796 15255 Elizabeth Mary Hayes         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001430 Killingbeck and Seacroft                       2016-05-05 0 0           PP52   0
13797 13797 15256 Jaimes Lewis Moran Mr   Male 1994-01-13 local.leeds.2016-05-05 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 13798 15257 Adam Douglas         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001430 Killingbeck and Seacroft                       2016-05-05 0 0           PP90   0
13799 13799 15259 Graham Hyde         local.leeds.2016-05-05 79 party:53 Labour Party MTW:E05001430 Killingbeck and Seacroft   1.0                   2016-05-05 0 0           PP53   0
13800 13800 15260 John Otley     male 1957.0 local.leeds.2016-05-05 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 13801 15850 Daniel Peter Farrell         local.leeds.2016-05-05 79 party:52 Conservative and Unionist Party MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP52   0
13802 13802 15851 Mitchell Galdas         local.leeds.2016-05-05 79 party:90 Liberal Democrats MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP90   0
13803 13803 15852 Kieran White         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001423 Garforth and Swillington                       2016-05-05 0 0           PP63   0
13804 13804 16482 Ben Hall         local.leeds.2016-05-05 79 party:63 Green Party MTW:E05001428 Horsforth                       2016-05-05 0 0           PP63   0
13805 13805 16483 Ian Joseph McCargo Mr   male   local.leeds.2016-05-05 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "candidates" (
"id" INTEGER,
  "name" TEXT,
  "honorific_prefix" REAL,
  "honorific_suffix" REAL,
  "gender" TEXT,
  "birth_date" REAL,
  "election" INTEGER,
  "party_id" TEXT,
  "party_name" TEXT,
  "post_id" TEXT,
  "post_label" TEXT,
  "mapit_url" INTEGER,
  "elected" REAL,
  "email" TEXT,
  "twitter_username" REAL,
  "facebook_page_url" REAL,
  "party_ppc_page_url" REAL,
  "facebook_personal_url" REAL,
  "homepage_url" REAL,
  "wikipedia_url" REAL,
  "linkedin_url" REAL,
  "image_url" REAL,
  "proxy_image_url_template" INTEGER,
  "image_copyright" REAL,
  "image_uploading_user" REAL,
  "image_uploading_user_notes" REAL,
  "twitter_user_id" INTEGER,
  "election_date" TEXT,
  "election_current" INTEGER,
  "party_lists_in_use" INTEGER,
  "party_list_position" INTEGER,
  "old_person_ids" REAL,
  "gss_code" INTEGER,
  "parlparse_id" REAL,
  "theyworkforyou_url" REAL,
  "party_ec_id" TEXT,
  "favourite_biscuits" REAL,
  "cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))
Powered by Datasette · Query took 10.713ms · Data license: CC-BY-SA · Data source: Democracy Club