home / democracyclub

democracyclub

Custom SQL query returning 67 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
9572 1429 Ian Curtis     male   28 party:52 Conservative and Unionist Party DIW:E05008531 Ramsey             https://static-candidates.democracyclub.org.uk/media/images/images/1429.png   other JeniT from his councillor page at https://applications.huntingdonshire.gov.uk/moderngov/mgUserInfo.aspx?UID=2680 2016-05-05 0 0   9044.0       PP52   0
9573 1907 Lord Toby Jug     male 1965-12-18 28 party:2413 The Eccentric Party of Great Britain DIW:E05008580 St Ives South       http://www.eccentricparty.com/ https://en.wikipedia.org/wiki/Lord_Toby_Jug   https://static-candidates.democracyclub.org.uk/media/images/54e20730438d6af41666ea84.png         2016-05-05 0 0   7384.0       PP2413   0
9574 4359 Nik Johnson Dr   male   28 party:53 Labour Party DIW:E05008533 St Neots Eynesbury     http://www.labour.org.uk/people/detail/nik-johnson       https://static-candidates.democracyclub.org.uk/media/images/images/4359.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9072.0       PP53   0
9575 5035 Paul Bullen     male 1958.0 28 party:85 UK Independence Party (UKIP) DIW:E05008937 St Ives East     http://www.huntsukip.org.uk/Paul-Bullen.html       https://static-candidates.democracyclub.org.uk/media/images/5526945c59bbc5c063445bdb.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   9056.0       PP85   0
9576 7495 Jason Ablewhite     male   28 party:52 Conservative and Unionist Party DIW:E05008937 St Ives East         https://en.wikipedia.org/wiki/Jason_Ablewhite   https://static-candidates.democracyclub.org.uk/media/images/images/7495.png   profile-photo phil@philrodgers.co.uk From candidate's "Public Figure" page on Facebook at https://www.facebook.com/JasonAblewhitePCC/ 2016-05-05 0 0   9055.0       PP52   0
9577 7611 Lisa Ann Duffy Cllr   Female 1968.0 28 party:85 UK Independence Party (UKIP) DIW:E05008531 Ramsey                       2016-05-05 0 0   9045.0       PP85   0
9578 9029 Rob Gardiner     Male   28 party:53 Labour Party DIW:E05002763 Brampton       http://huntingdonlabourparty.org.uk/               2016-05-05 0 0           PP53   0
9579 9030 John Paul Morris   FCIH MCMI Male   28 party:90 Liberal Democrats DIW:E05002763 Brampton       http://www.huntingdonlibdems.org.uk/   https://www.linkedin.com/in/johnmorris7543 https://static-candidates.democracyclub.org.uk/media/images/images/9030.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
9580 9031 Lin Sinclair         28 party:52 Conservative and Unionist Party DIW:E05002763 Brampton                       2016-05-05 0 0           PP52   0
9581 9032 Keith Warren Stukins         28 party:52 Conservative and Unionist Party DIW:E05002769 Godmanchester                       2016-05-05 0 0           PP52   0
9582 9033 Samuel Paul Sweek         28 party:53 Labour Party DIW:E05002769 Godmanchester     http://huntingdonlabourparty.org.uk/samuel-sweek/                 2016-05-05 0 0           PP53   0
9583 9034 David Richard Underwood     male   28 party:90 Liberal Democrats DIW:E05002769 Godmanchester       https://davidunderwood2.wordpress.com/               2016-05-05 0 0           PP90   0
9584 9035 Tom Fletcher         28 party:52 Conservative and Unionist Party DIW:E05002771 Huntingdon East                       2016-05-05 0 0           PP52   0
9585 9036 Marion Kadewere         28 party:53 Labour Party DIW:E05002771 Huntingdon East                       2016-05-05 0 0           PP53   0
9586 9037 Michael Frederick Shellens     Male   28 party:90 Liberal Democrats DIW:E05002771 Huntingdon East                       2016-05-05 0 0   24510.0       PP90   0
9587 9039 Peter Henry Ashcroft         28 party:85 UK Independence Party (UKIP) DIW:E05002772 Huntingdon North                       2016-05-05 0 0           PP85   0
9588 9040 Patrick Kadewere     male   28 party:53 Labour Party DIW:E05002772 Huntingdon North     http://huntingdonlabourparty.org.uk/patrick-kadewere/       https://static-candidates.democracyclub.org.uk/media/images/images/9040.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
9589 9041 Alan James Mackender-Lawrence         28 ynmp-party:2 Independent DIW:E05002772 Huntingdon North                       2016-05-05 0 0           ynmp-party:2   0
9590 9042 Richard Valatka         28 party:52 Conservative and Unionist Party DIW:E05002772 Huntingdon North                       2016-05-05 0 0           PP52   0
9591 9043 Lakkana Rajiv Peiris Yalagala     male   28 party:90 Liberal Democrats DIW:E05002772 Huntingdon North       https://libdemhuntingdonnorth.wordpress.com/               2016-05-05 0 0   24519.0       PP90   0
9592 9046 Kevin John Minnette         28 party:53 Labour Party DIW:E05008531 Ramsey                       2016-05-05 0 0           PP53   0
9593 9047 Nicholas Vaughan Ashley         28 party:85 UK Independence Party (UKIP) DIW:E05002784 Sawtry                       2016-05-05 0 0           PP85   0
9594 9048 Nikki Elliott         28 party:52 Conservative and Unionist Party DIW:E05002784 Sawtry                       2016-05-05 0 0           PP52   0
9595 9049 Jonathan Hugh Orchard         28 party:53 Labour Party DIW:E05002784 Sawtry                       2016-05-05 0 0           PP53   0
9596 9050 Dick Tuplin         28 ynmp-party:2 Independent DIW:E05002784 Sawtry                       2016-05-05 0 0           ynmp-party:2   0
9597 9051 Steve Criswell         28 party:52 Conservative and Unionist Party DIW:E05008938 Somersham                       2016-05-05 0 0           PP52   0
9598 9053 Iain Ramsbottom Mr   male 1960-06-17 28 party:53 Labour Party DIW:E05008938 Somersham             https://static-candidates.democracyclub.org.uk/media/images/images/9053.png   other Iain Ramsbottom I took this picture 2016-05-05 0 0           PP53 KitKat 0
9599 9054 Shirley Joy Reeve         28 party:85 UK Independence Party (UKIP) DIW:E05008938 Somersham                       2016-05-05 0 0           PP85   0
9600 9057 Angela Louise Richards         28 party:53 Labour Party DIW:E05008937 St Ives East                       2016-05-05 0 0           PP53   0
9601 9058 Colin Macrae Saunderson         28 party:90 Liberal Democrats DIW:E05008937 St Ives East                       2016-05-05 0 0           PP90   0
9602 9059 Richard John Allen         28 party:53 Labour Party DIW:E05002779 St Ives West                       2016-05-05 0 0           PP53   0
9603 9060 Ryan Fuller     male   28 party:52 Conservative and Unionist Party DIW:E05002779 St Ives West             https://static-candidates.democracyclub.org.uk/media/images/images/9060.png   other StuBez On council website: https://applications.huntingdonshire.gov.uk/moderngov/mgUserInfo.aspx?UID=2814 2016-05-05 0 0           PP52   0
9604 9061 David Frederick Hodge     male   28 party:90 Liberal Democrats DIW:E05002779 St Ives West                       2016-05-05 0 0   24520.0       PP90   0
9605 9062 Margaret Teresa King         28 party:85 UK Independence Party (UKIP) DIW:E05002779 St Ives West                       2016-05-05 0 0           PP85   0
9606 9063 Bob Farrer         28 ynmp-party:2 Independent DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           ynmp-party:2   0
9607 9064 Sandie Giles         28 ynmp-party:2 Independent DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           ynmp-party:2   0
9608 9065 Anna Elizabeth Hayward         28 party:53 Labour Party DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           PP53   0
9609 9066 Melina LaFirenze         28 party:63 Green Party DIW:E05008581 St Neots Eaton Ford             https://static-candidates.democracyclub.org.uk/media/images/images/9066.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
9610 9067 Graham John Welton         28 party:52 Conservative and Unionist Party DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           PP52   0
9611 9068 Derek Arthur Giles         28 ynmp-party:2 Independent DIW:E05002781 St Neots Eaton Socon                       2016-05-05 0 0           ynmp-party:2   0
9612 9069 Patricia Anne Nicholls         28 party:53 Labour Party DIW:E05002781 St Neots Eaton Socon                       2016-05-05 0 0           PP53   0
9613 9070 Keith Ivan Prentice     male   28 party:52 Conservative and Unionist Party DIW:E05002781 St Neots Eaton Socon       http://www.keithprentice.com/               2016-05-05 0 0           PP52   0
9614 9071 Jim Corley         28 ynmp-party:2 Independent DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0   19455;24904       ynmp-party:2   0
9615 9073 Tony McNeill         28 party:53 Labour Party DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0   44401.0       PP53   0
9616 9074 Robert Anthony Moores         28 party:52 Conservative and Unionist Party DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0           PP52   0
9617 9075 Simone Leigh Taylor         28 ynmp-party:2 Independent DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0           ynmp-party:2   0
9618 9076 Adrian Lee Usher         28 party:52 Conservative and Unionist Party DIW:E05008533 St Neots Eynesbury           https://www.linkedin.com/in/adrian-usher-82a84688           2016-05-05 0 0           PP52   0
9619 9077 Alison Donaldson         28 party:52 Conservative and Unionist Party DIW:E05008535 The Hemingfords                       2016-05-05 0 0           PP52   0
9620 9078 Philip Foster         28 party:85 UK Independence Party (UKIP) DIW:E05008535 The Hemingfords                       2016-05-05 0 0           PP85   0
9621 9080 David John Priestman     Male   28 party:90 Liberal Democrats DIW:E05008535 The Hemingfords                       2016-05-05 0 0   24528.0       PP90   0
9622 9081 Kevin Roy Goddard         28 party:53 Labour Party DIW:E05008939 Warboys and Bury                       2016-05-05 0 0           PP53   0
9623 9082 Tony Hulme         28 party:90 Liberal Democrats DIW:E05008939 Warboys and Bury                       2016-05-05 0 0   24529.0       PP90   0
9624 9083 Mick Mean         28 party:85 UK Independence Party (UKIP) DIW:E05008939 Warboys and Bury                       2016-05-05 0 0           PP85   0
9625 9084 Jill Tavener     female   28 party:52 Conservative and Unionist Party DIW:E05008939 Warboys and Bury                       2016-05-05 0 0           PP52   0
9626 9085 Colin Moody         28 party:85 UK Independence Party (UKIP) DIW:E05002790 Yaxley and Farcet                       2016-05-05 0 0           PP85   0
9627 9086 Graeme Leslie Watkins         28 joint-party:53-119 Labour and Co-operative Party DIW:E05002790 Yaxley and Farcet     https://party.coop/person/graeme-watkins/                 2016-05-05 0 0           joint-party:53-119   0
9628 9087 Desmond Watt         28 party:52 Conservative and Unionist Party DIW:E05002790 Yaxley and Farcet                       2016-05-05 0 0           PP52   0
9629 19414 James Edward Bartrick     Male   28 party:90 Liberal Democrats DIW:E05008579 Little Paxton                       2016-05-05 0 0   24527.0       PP90   0
9630 19415 Nicholas Janson Kumbula         28 party:53 Labour Party DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP53   0
9631 19416 Daniel Morris         28 party:85 UK Independence Party (UKIP) DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP85   0
9632 19417 Laurence Roland Swain         28 party:52 Conservative and Unionist Party DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP52   0
9633 19418 Liz Timms         28 party:63 Green Party DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP63   0
9634 19419 Lynne Alexandra Bullen         28 party:85 UK Independence Party (UKIP) DIW:E05008580 St Ives South                       2016-05-05 0 0           PP85   0
9635 19420 John Winston Davies         28 party:52 Conservative and Unionist Party DIW:E05008580 St Ives South                       2016-05-05 0 0           PP52   0
9636 28047 John Watson         28 party:53 Labour Party DIW:E05008580 St Ives South                       2016-05-05 0 0   19421.0       PP53   0
9637 38136 Rob Leach Mr       28 party:53 Labour Party DIW:E05008535 The Hemingfords                       2016-05-05 0 0   9079.0       PP53   0
9638 44368 Tom Varghese     male   28 party:85 UK Independence Party (UKIP) DIW:E05002771 Huntingdon East             https://static-candidates.democracyclub.org.uk/media/images/images/44368.png   profile-photo jane38   2016-05-05 0 0   9038.0       PP85   0
Powered by Datasette · Query took 1.347ms