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
8582 263 Jordan Newell     male   10 party:53 Labour Party DIW:E05010828 Castle     http://www.labour.org.uk/people/detail/jordan-newell       https://static-candidates.democracyclub.org.uk/media/images/5481e7e2b150e238702c057c.png   profile-photo     2016-05-05 0 0   15367.0       PP53   0
8583 264 Peter Lynn     male   10 party:63 Green Party DIW:E05010834 Mile End           https://uk.linkedin.com/in/peter-lynn-13a8135 https://static-candidates.democracyclub.org.uk/media/images/images/264.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   15482.0       PP63   0
8584 833 Tim Glover     male   10 party:63 Green Party DIW:E05010843 Wivenhoe                       2016-05-05 0 0           PP63   0
8585 836 John Spademan     male 1960-06-01 10 party:53 Labour Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP53   0
8586 2193 John Pitts     male   10 party:85 UK Independence Party (UKIP) DIW:E05010832 Marks Tey & Layer             https://static-candidates.democracyclub.org.uk/media/images/55268e1159bbc5c063445b7e.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 0           PP85   0
8587 4312 Tim Young Mr   male 1961.0 10 party:53 Labour Party DIW:E05010829 Greenstead     http://vote.labour.org.uk/tim-young     https://www.linkedin.com/in/tim-young-561b2637/ https://static-candidates.democracyclub.org.uk/media/images/553b8c847b9de399275bb49b.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/Tim4Clacton 2016-05-05 0 0           PP53   0
8588 5001 Mark Goacher Mr   male 1969.0 10 party:63 Green Party DIW:E05010828 Castle     https://my.greenparty.org.uk/candidates/105898 http://markgoachergreen.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/5001.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/105898 2016-05-05 0 0   7915.0       PP63   0
8589 5181 David Alexander Hough Mr   male 1959-08-29 10 party:53 Labour Party DIW:E05010841 Stanway             https://static-candidates.democracyclub.org.uk/media/images/553aa4eec0ff2778587ee2b7.png   profile-photo edent From alternate Twitter account https://twitter.com/colchester1648 2016-05-05 0 0   15569.0       PP53   0
8590 5435 Maria Vigneau     female   10 party:85 UK Independence Party (UKIP) DIW:E05010833 Mersea & Pyefleet             https://static-candidates.democracyclub.org.uk/media/images/5526947559bbc5c063445bde.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-f-k.html 2016-05-05 0 0           PP85   0
8591 5497 Dominic Graham Mr   male   10 party:90 Liberal Democrats DIW:E05010834 Mile End       https://northeastessexlibdems.org.uk/en/contact/dominic-graham     https://static-candidates.democracyclub.org.uk/media/images/55191aef4ff096f44902d233.png   profile-photo domgraham@hotmail.co.uk http://northeastessexlibdems.org.uk/en/ 2016-05-05 0 0   15480.0       PP90   0
8592 6228 Jo Hayes     Female   10 party:90 Liberal Democrats DIW:E05010828 Castle       http://johayes.mycouncillor.org.uk/about/#page-content     https://static-candidates.democracyclub.org.uk/media/images/553aa77c319151d456c24fab.png   profile-photo edent https://twitter.com/JoHayesLibDem 2016-05-05 0 0   24560.0       PP90   0
8593 7138 Chris Flossman Mr   Male 1994-01-25 10 party:63 Green Party DIW:E05010829 Greenstead     https://my.greenparty.org.uk/candidates/105988       https://static-candidates.democracyclub.org.uk/media/images/551d7140570782f7747687d6.png   copyright-assigned CFlossman   2016-05-05 0 0           PP63   0
8594 7916 Phil Finn     male   10 joint-party:53-119 Labour and Co-operative Party DIW:E05010843 Wivenhoe                       2016-05-05 0 0           joint-party:53-119   0
8595 7917 Cyril Liddy Cllr.   male   10 joint-party:53-119 Labour and Co-operative Party DIW:E05010843 Wivenhoe     http://www.colchesterlabour.com/wivenhoe                 2016-05-05 0 0           joint-party:53-119   0
8596 7918 Rosalind Scott Cllr.   female   10 joint-party:53-119 Labour and Co-operative Party DIW:E05010843 Wivenhoe     http://vote.labour.org.uk/janice-rosalind-scott http://rosalindscott.org.uk/   https://www.linkedin.com/in/rosalindscott/ https://static-candidates.democracyclub.org.uk/media/images/images/7918.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           joint-party:53-119 Jaffa cake 0
8597 8136 Chris Hill     Male 1983-02-18 10 party:52 Conservative and Unionist Party DIW:E05010829 Greenstead     https://www.colchesterindependents.co.uk/candidates https://www.colchesterindependents.co.uk/   https://www.linkedin.com/in/chrismarkhill/ https://static-candidates.democracyclub.org.uk/media/images/images/8136.png   public-domain Minkus Photo from official candidate election literature 2016-05-05 0 0   24270;48696       PP52   0
8598 14097 Susan Lorna Allen         10 party:63 Green Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP63   0
8599 14098 Richard George Issard Brown         10 party:52 Conservative and Unionist Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP52   0
8600 14099 Andrew Lawrence Canessa         10 party:63 Green Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP63   0
8601 14100 Adam Daniel Fox         10 party:53 Labour Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP53   0
8602 14101 Liam Henry Gallagher         10 party:52 Conservative and Unionist Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0   48718.0       PP52   0
8603 14102 Julia Pauline Havis         10 party:90 Liberal Democrats DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP90   0
8604 14103 Janet Mary Knight         10 party:90 Liberal Democrats DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP90   0
8605 14104 Justin Knight         10 party:90 Liberal Democrats DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP90   0
8606 14105 Michael Edward Charles Lilley         10 party:53 Labour Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP53   0
8607 14106 Janet Christina Plummer         10 party:63 Green Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP63   0
8608 14107 Alan Herbert Scattergood         10 party:52 Conservative and Unionist Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP52   0
8609 14108 Lee Paul Scordis         10 party:53 Labour Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP53   0
8610 15337 Sam Borley         10 party:63 Green Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP63   0
8611 15338 Chris Brown         10 party:52 Conservative and Unionist Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP52   0
8612 15339 Michael James Brown         10 party:52 Conservative and Unionist Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP52   0
8613 15340 Annabel Rose Fay Glayzer Mrs   Female 1991.0 10 party:52 Conservative and Unionist Party DIW:E05010827 Berechurch             https://static-candidates.democracyclub.org.uk/media/images/images/15340.png   profile-photo annabel_glayzer   2016-05-05 0 0           PP52   0
8614 15341 Dave Harris         10 party:53 Labour Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP53   0
8615 15342 Katie Lily Francis Hood         10 party:90 Liberal Democrats DIW:E05010827 Berechurch                       2016-05-05 0 0           PP90   0
8616 15343 Jakub Makowski         10 party:90 Liberal Democrats DIW:E05010827 Berechurch                       2016-05-05 0 0           PP90   0
8617 15344 Ralph George Morse         10 party:85 UK Independence Party (UKIP) DIW:E05010827 Berechurch                       2016-05-05 0 0           PP85   0
8618 15345 Chris Pearson         10 party:53 Labour Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP53   0
8619 15346 George Edward Penny         10 party:90 Liberal Democrats DIW:E05010827 Berechurch                       2016-05-05 0 0           PP90   0
8620 15347 Martyn Keith Warnes         10 party:53 Labour Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP53   0
8621 15358 Nick Barlow         10 party:90 Liberal Democrats DIW:E05010828 Castle                       2016-05-05 0 0           PP90   0
8622 15359 Daniel John Ellis         10 party:52 Conservative and Unionist Party DIW:E05010828 Castle                       2016-05-05 0 0           PP52   0
8623 15360 Bill Frame         10 party:90 Liberal Democrats DIW:E05010828 Castle                       2016-05-05 0 0           PP90   0
8624 15361 Barry Gilheany         10 party:53 Labour Party DIW:E05010828 Castle                       2016-05-05 0 0   48690.0       PP53   0
8625 15362 Charles David Ham         10 party:63 Green Party DIW:E05010828 Castle                       2016-05-05 0 0           PP63   0
8626 15363 Amanda Jane Kirke         10 party:63 Green Party DIW:E05010828 Castle                       2016-05-05 0 0           PP63   0
8627 15364 Darius Grant Laws         10 party:52 Conservative and Unionist Party DIW:E05010828 Castle                       2016-05-05 0 0           PP52   0
8628 15365 Kate Martin         10 party:52 Conservative and Unionist Party DIW:E05010828 Castle                       2016-05-05 0 0           PP52   0
8629 15366 Isobel Claire Merry         10 party:53 Labour Party DIW:E05010828 Castle                       2016-05-05 0 0           PP53   0
8630 15382 Owen Leslie Bartholomew     Male   10 party:90 Liberal Democrats DIW:E05010829 Greenstead                       2016-05-05 0 0   24556.0       PP90   0
8631 15383 Tina Jane Bourne         10 party:53 Labour Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP53   0
8632 15384 Asa Michael Brotherton         10 party:63 Green Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP63   0
8633 15385 Poppy Eloise Gerrard-Abbott         10 party:63 Green Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP63   0
8634 15386 Paul Gordon Hanslow         10 party:52 Conservative and Unionist Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP52   0
8635 15387 Andrew John Higginson         10 party:52 Conservative and Unionist Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP52   0
8636 15388 Christopher John Lee     male   10 ynmp-party:2 Independent DIW:E05010829 Greenstead     https://www.colchesterindependents.co.uk/candidates https://www.colchesterindependents.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/15388.png   profile-photo Minkus Sourced from campaign page: https://www.colchesterindependents.co.uk/candidates 2016-05-05 0 0           ynmp-party:2   0
8637 15389 James Anthony Middleditch         10 party:85 UK Independence Party (UKIP) DIW:E05010829 Greenstead                       2016-05-05 0 0           PP85   0
8638 15390 Josef Schumacher         10 party:90 Liberal Democrats DIW:E05010829 Greenstead                       2016-05-05 0 0           PP90   0
8639 15391 Julie Ann Young Mrs   Female 1959-07-26 10 party:53 Labour Party DIW:E05010829 Greenstead             https://static-candidates.democracyclub.org.uk/media/images/images/15391.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1209083954 2016-05-05 0 0   24273.0       PP53   0
8640 15400 John Baker         10 party:90 Liberal Democrats DIW:E05010830 Highwoods                       2016-05-05 0 0           PP90   0
8641 15401 Gary David Braddy         10 party:53 Labour Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP53   0
8642 15402 James Simon Child         10 party:52 Conservative and Unionist Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP52   0
8643 15403 Chris Hayter         10 party:52 Conservative and Unionist Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP52   0
8644 15404 Steph Hayward         10 party:52 Conservative and Unionist Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP52   0
8645 15405 Alex Knupffer         10 party:85 UK Independence Party (UKIP) DIW:E05010830 Highwoods                       2016-05-05 0 0           PP85   0
8646 15406 David Charles McCulloch         10 party:53 Labour Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP53   0
8647 15407 Bonnie Jayne Murphy         10 party:63 Green Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP63   0
8648 15408 Bev Oxford         10 ynmp-party:2 Independent DIW:E05010830 Highwoods                       2016-05-05 0 0           ynmp-party:2   0
8649 15409 Gerard Paul Oxford         10 ynmp-party:2 Independent DIW:E05010830 Highwoods                       2016-05-05 0 0           ynmp-party:2   0
8650 15410 Phil Oxford         10 ynmp-party:2 Independent DIW:E05010830 Highwoods                       2016-05-05 0 0           ynmp-party:2   0
8651 15411 Leo Palmer         10 party:63 Green Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP63   0
8652 15412 Robbie Spence         10 party:63 Green Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP63   0
8653 15413 Diane Stevens         10 party:53 Labour Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP53   0
8654 15428 Lewis Charles Barber         10 party:52 Conservative and Unionist Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP52   0
8655 15429 Sioux Blair-Jordan         10 party:53 Labour Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP53   0
8656 15430 Emmanuel Blondel         10 party:63 Green Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP63   0
8657 15431 Rosa Belle Chandler         10 party:63 Green Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP63   0
8658 15432 Stephen George Ford         10 party:63 Green Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP63   0
8659 15433 Gemma Marie Graham         10 party:90 Liberal Democrats DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP90   0
8660 15434 Alison Jane Inman         10 party:53 Labour Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP53   0
8661 15435 Brian David Henry Jarvis         10 party:52 Conservative and Unionist Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP52   0
8662 15436 Megan Joanne Saliu         10 party:53 Labour Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP53   0
8663 15438 Susan Mary Waite         10 party:90 Liberal Democrats DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP90   0
8664 15439 Dennis Willetts         10 party:52 Conservative and Unionist Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP52   0
8665 15440 Kevin Paul Bentley         10 party:52 Conservative and Unionist Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP52   0
8666 15441 Gillian Mary Collings         10 party:90 Liberal Democrats DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP90   0
8667 15442 Andrew John Ellis         10 party:52 Conservative and Unionist Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP52   0
8668 15443 Jackie Maclean         10 party:52 Conservative and Unionist Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP52   0
8669 15444 Clare Teresa Palmer         10 party:63 Green Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP63   0
8670 15445 Matthew James Stemp         10 party:63 Green Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP63   0
8671 15446 Michael Kenneth Wagstaff         10 party:53 Labour Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP53   0
8672 15447 John Christopher Wood         10 party:53 Labour Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP53   0
8673 15457 Peter Douglas Cameron Banks Mr BSc FMPRS Male   10 party:63 Green Party DIW:E05010833 Mersea & Pyefleet     https://www.facebook.com/colchestergreenparty/ http://banksyboy.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/15457.png   profile-photo BoyBanksy photo taken by family member 2016-05-05 0 0           PP63   0
8674 15458 Neil Martin Belcher         10 party:53 Labour Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP53   0
8675 15459 Lisa Britton         10 party:63 Green Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP63   0
8676 15460 David Roger Broise         10 party:85 UK Independence Party (UKIP) DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP85   0
8677 15461 Robert Alec Davidson         10 party:52 Conservative and Unionist Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP52   0
8678 15462 David Holmes         10 party:85 UK Independence Party (UKIP) DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP85   0
8679 15463 John Gilbert Jowers         10 party:52 Conservative and Unionist Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP52   0
8680 15464 Bartosz Mizgier         10 party:63 Green Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP63   0
8681 15465 Bry Whittle Mogridge         10 party:53 Labour Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP53   0
8682 15466 Patricia Ann Moore         10 party:52 Conservative and Unionist Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.107ms