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
10839 1151 Nick Bent     male   39 joint-party:53-119 Labour and Co-operative Party UTW:E05001598 Appleton ward     http://www.labour.org.uk/people/detail/nick-bent       https://static-candidates.democracyclub.org.uk/media/images/images/1151.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           joint-party:53-119   0
10840 4117 Valerie Margaret Allen     female 1958.0 39 party:52 Conservative and Unionist Party UTW:E05001602 Culcheth, Glazebury and Croft ward     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Allen_Valerie.aspx       https://static-candidates.democracyclub.org.uk/media/images/images/4117.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
10841 5068 Stefan Krizanac     male   39 party:90 Liberal Democrats UTW:E05001618 Westbrook ward   1.0 http://www.libdems.org.uk/zeljko-krizanac http://www.warringtonlibdems.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/553be5b5ec0766d3759c0466.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/canazirk 2016-05-05 0 0           PP90   0
10842 6190 Kevin Bennett     male   39 party:804 Trade Unionist and Socialist Coalition UTW:E05001603 Fairfield and Howley ward             https://static-candidates.democracyclub.org.uk/media/images/550553e0071d4f1362bc8033.png         2016-05-05 0 0           PP804   0
10843 6901 Malcolm Lingley     male 1958-06-02 39 party:85 UK Independence Party (UKIP) UTW:E05001613 Poplars and Hulme ward             https://static-candidates.democracyclub.org.uk/media/images/55187a59249b917507bee580.png   profile-photo malling51 was taken by my wife 2016-05-05 0 0           PP85   0
10844 6904 Trevor Nicholls     male   39 party:85 UK Independence Party (UKIP) UTW:E05001613 Poplars and Hulme ward                       2016-05-05 0 0           PP85   0
10845 7514 David Keane     male   39 party:53 Labour Party UTW:E05001612 Penketh and Cuerdley ward       http://davidkeane4cheshirepcc.co.uk/ https://en.wikipedia.org/wiki/David_Keane   https://static-candidates.democracyclub.org.uk/media/images/images/7514.png   profile-photo chrisspargo It's from his Facebook campaign page: https://www.facebook.com/David-Keane-4-Cheshire-PCC-218353745171671/ 2016-05-05 0 0           PP53   0
10846 8794 Brian Axcell     male   39 party:90 Liberal Democrats UTW:E05001598 Appleton ward   1.0                   2016-05-05 0 0           PP90   0
10847 8805 David Bilton     male   39 party:63 Green Party UTW:E05001598 Appleton ward                       2016-05-05 0 0           PP63   0
10848 8823 Sharon Harris     female   39 party:90 Liberal Democrats UTW:E05001598 Appleton ward   1.0                   2016-05-05 0 0           PP90   0
10849 8846 Ian Houghton     male   39 party:52 Conservative and Unionist Party UTW:E05001598 Appleton ward                       2016-05-05 0 0           PP52   0
10850 8847 Basil Mitchell     male   39 party:52 Conservative and Unionist Party UTW:E05001598 Appleton ward                       2016-05-05 0 0           PP52   0
10851 8848 Barbara Price     female   39 party:52 Conservative and Unionist Party UTW:E05001598 Appleton ward                       2016-05-05 0 0           PP52   0
10852 8851 Judith Wheeler     female   39 party:90 Liberal Democrats UTW:E05001598 Appleton ward   1.0                   2016-05-05 0 0           PP90   0
10853 8876 Irina Axcell     female   39 party:90 Liberal Democrats UTW:E05001599 Bewsey and Whitecross ward                       2016-05-05 0 0           PP90   0
10854 8877 Shelley Bennett     female   39 party:804 Trade Unionist and Socialist Coalition UTW:E05001599 Bewsey and Whitecross ward                       2016-05-05 0 0           PP804   0
10855 8878 Rowland Blackstock     male   39 party:52 Conservative and Unionist Party UTW:E05001599 Bewsey and Whitecross ward                       2016-05-05 0 0           PP52   0
10856 8879 Sarah Edith Hall     female   39 party:53 Labour Party UTW:E05001599 Bewsey and Whitecross ward             https://static-candidates.democracyclub.org.uk/media/images/images/8879.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
10857 8880 Tom Jennings     male   39 party:53 Labour Party UTW:E05001599 Bewsey and Whitecross ward           https://www.linkedin.com/in/itstomjennings           2016-05-05 0 0           PP53   0
10858 8881 Pat Smith         39 party:52 Conservative and Unionist Party UTW:E05001599 Bewsey and Whitecross ward                       2016-05-05 0 0           PP52   0
10859 8882 Bob Timmis     male   39 party:90 Liberal Democrats UTW:E05001599 Bewsey and Whitecross ward                       2016-05-05 0 0           PP90   0
10860 8889 Judith Walker     female   39 party:90 Liberal Democrats UTW:E05001599 Bewsey and Whitecross ward                       2016-05-05 0 0           PP90   0
10861 8890 Steve Wright     male   39 party:53 Labour Party UTW:E05001599 Bewsey and Whitecross ward                       2016-05-05 0 0           PP53   0
10862 8891 Nigel Balding     male   39 party:52 Conservative and Unionist Party UTW:E05001600 Birchwood ward                       2016-05-05 0 0           PP52   0
10863 8892 Russ Bowden     male   39 party:53 Labour Party UTW:E05001600 Birchwood ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8892.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
10864 8893 John Davies     male   39 party:90 Liberal Democrats UTW:E05001600 Birchwood ward                       2016-05-05 0 0           PP90   0
10865 8894 Chris Fitzsimmons         39 party:53 Labour Party UTW:E05001600 Birchwood ward   1.0                   2016-05-05 0 0           PP53   0
10866 8895 Amy Elizabeth Linton     female   39 ynmp-party:2 Independent UTW:E05001600 Birchwood ward                       2016-05-05 0 0           ynmp-party:2   0
10867 8896 Peter Linton     male   39 party:52 Conservative and Unionist Party UTW:E05001600 Birchwood ward                       2016-05-05 0 0           PP52   0
10868 8897 Pauline Nelson     female   39 party:53 Labour Party UTW:E05001600 Birchwood ward   1.0                   2016-05-05 0 0           PP53   0
10869 8898 Cathy Mitchell     female   39 party:53 Labour Party UTW:E05001601 Burtonwood and Winwick ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8898.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
10870 8899 Timothy James Muttock     male   39 party:90 Liberal Democrats UTW:E05001601 Burtonwood and Winwick ward                       2016-05-05 0 0           PP90   0
10871 8900 Terry O'Neill     male   39 party:53 Labour Party UTW:E05001601 Burtonwood and Winwick ward   1.0                   2016-05-05 0 0           PP53   0
10872 8901 Robin Sloan         39 party:52 Conservative and Unionist Party UTW:E05001601 Burtonwood and Winwick ward                       2016-05-05 0 0           PP52   0
10873 8988 Frank Richard Allen     male   39 party:52 Conservative and Unionist Party UTW:E05001602 Culcheth, Glazebury and Croft ward                       2016-05-05 0 0           PP52   0
10874 8989 Sue Bland     female   39 party:52 Conservative and Unionist Party UTW:E05001602 Culcheth, Glazebury and Croft ward                       2016-05-05 0 0           PP52   0
10875 8990 Jan Davidson     female   39 party:53 Labour Party UTW:E05001602 Culcheth, Glazebury and Croft ward   1.0                   2016-05-05 0 0           PP53   0
10876 8991 Joan Grime     female   39 party:53 Labour Party UTW:E05001602 Culcheth, Glazebury and Croft ward   1.0                   2016-05-05 0 0           PP53   0
10877 8992 Eddie Sloane         39 party:90 Liberal Democrats UTW:E05001602 Culcheth, Glazebury and Croft ward                       2016-05-05 0 0           PP90   0
10878 8993 Matt Smith     male   39 party:53 Labour Party UTW:E05001602 Culcheth, Glazebury and Croft ward   1.0                   2016-05-05 0 0           PP53   0
10879 8994 Peter Carey     male   39 party:53 Labour Party UTW:E05001603 Fairfield and Howley ward   1.0                   2016-05-05 0 0           PP53   0
10880 8995 Jean Flaherty     female   39 party:53 Labour Party UTW:E05001603 Fairfield and Howley ward   1.0                   2016-05-05 0 0           PP53   0
10881 8996 Tony Higgins     male   39 party:53 Labour Party UTW:E05001603 Fairfield and Howley ward   1.0                   2016-05-05 0 0           PP53   0
10882 8997 Simone Johnson     female   39 party:52 Conservative and Unionist Party UTW:E05001603 Fairfield and Howley ward                       2016-05-05 0 0           PP52   0
10883 8998 Lyndsay McAteer     female 1968.0 39 party:63 Green Party UTW:E05001603 Fairfield and Howley ward                       2016-05-05 0 0           PP63   0
10884 8999 Ann Oldbury     female   39 party:90 Liberal Democrats UTW:E05001603 Fairfield and Howley ward                       2016-05-05 0 0           PP90   0
10885 9011 Sonia Wendy Boggan     female   39 party:52 Conservative and Unionist Party UTW:E05001606 Great Sankey South ward                       2016-05-05 0 0           PP52   0
10886 9012 Jean Carter     female   39 party:53 Labour Party UTW:E05001606 Great Sankey South ward                       2016-05-05 0 0           PP53   0
10887 9013 Peter Elton     male   39 party:52 Conservative and Unionist Party UTW:E05001606 Great Sankey South ward                       2016-05-05 0 0           PP52   0
10888 9014 Andrew Ford     male   39 party:804 Trade Unionist and Socialist Coalition UTW:E05001606 Great Sankey South ward                       2016-05-05 0 0           PP804   0
10889 9015 Tim Harwood     male   39 party:90 Liberal Democrats UTW:E05001606 Great Sankey South ward                       2016-05-05 0 0           PP90   0
10890 9016 Sue Jenkin     female   39 party:52 Conservative and Unionist Party UTW:E05001606 Great Sankey South ward                       2016-05-05 0 0           PP52   0
10891 9017 Amanda King     female   39 party:53 Labour Party UTW:E05001606 Great Sankey South ward           https://www.linkedin.com/in/amanda-king-0b773a5 https://static-candidates.democracyclub.org.uk/media/images/images/9017_svMQYSe.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
10892 9018 Hitesh Patel     male   39 party:53 Labour Party UTW:E05001606 Great Sankey South ward             https://static-candidates.democracyclub.org.uk/media/images/images/9018.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
10893 9298 Rupert Budgen         39 party:90 Liberal Democrats UTW:E05001608 Latchford East ward                       2016-05-05 0 0           PP90   0
10894 9299 Julian Craddock         39 party:52 Conservative and Unionist Party UTW:E05001608 Latchford East ward                       2016-05-05 0 0           PP52   0
10895 9300 Sue Hayes         39 party:804 Trade Unionist and Socialist Coalition UTW:E05001608 Latchford East ward                       2016-05-05 0 0           PP804   0
10896 9301 John Kennedy Lappin         39 party:63 Green Party UTW:E05001608 Latchford East ward                       2016-05-05 0 0           PP63   0
10897 9302 Hans Josef Mundry         39 joint-party:53-119 Labour and Co-operative Party UTW:E05001608 Latchford East ward   1.0                   2016-05-05 0 0           joint-party:53-119   0
10898 9303 Karen Mundry         39 joint-party:53-119 Labour and Co-operative Party UTW:E05001608 Latchford East ward   1.0                   2016-05-05 0 0           joint-party:53-119   0
10899 9304 Tim Price         39 party:90 Liberal Democrats UTW:E05001608 Latchford East ward                       2016-05-05 0 0           PP90   0
10900 9305 Ken Scates         39 party:52 Conservative and Unionist Party UTW:E05001608 Latchford East ward                       2016-05-05 0 0           PP52   0
10901 9316 Dave Cundy         39 party:804 Trade Unionist and Socialist Coalition UTW:E05001609 Latchford West ward                       2016-05-05 0 0           PP804   0
10902 9317 Michael Haworth         39 party:52 Conservative and Unionist Party UTW:E05001609 Latchford West ward                       2016-05-05 0 0           PP52   0
10903 9318 Celia Jordan         39 party:90 Liberal Democrats UTW:E05001609 Latchford West ward                       2016-05-05 0 0           PP90   0
10904 9319 Maureen McLaughlin         39 party:53 Labour Party UTW:E05001609 Latchford West ward   1.0                   2016-05-05 0 0           PP53   0
10905 9320 Les Morgan         39 party:53 Labour Party UTW:E05001609 Latchford West ward   1.0                   2016-05-05 0 0           PP53   0
10906 9321 Ann Raymond         39 party:90 Liberal Democrats UTW:E05001609 Latchford West ward                       2016-05-05 0 0           PP90   0
10907 9322 David Woodyatt     male   39 party:52 Conservative and Unionist Party UTW:E05001609 Latchford West ward                       2016-05-05 0 0           PP52   0
10908 9363 Dion Eric Challinor         39 party:85 UK Independence Party (UKIP) UTW:E05001611 Orford ward                       2016-05-05 0 0           PP85   0
10909 9364 Mike Hannon         39 party:53 Labour Party UTW:E05001611 Orford ward   1.0                   2016-05-05 0 0           PP53   0
10910 9365 Clive Lawrinson Mr   male 1975.0 39 ynmp-party:2 Independent UTW:E05001611 Orford ward             https://static-candidates.democracyclub.org.uk/media/images/images/9365.png   copyright-assigned befriendings Selfie in the town market. 2016-05-05 0 0           ynmp-party:2   0
10911 9366 Pam Marks         39 party:90 Liberal Democrats UTW:E05001611 Orford ward                       2016-05-05 0 0           PP90   0
10912 9367 Kerri Louise Morris         39 party:53 Labour Party UTW:E05001611 Orford ward   1.0                   2016-05-05 0 0           PP53   0
10913 9368 Ian Andrew Richards         39 party:85 UK Independence Party (UKIP) UTW:E05001611 Orford ward                       2016-05-05 0 0           PP85   0
10914 9369 Sid Simmons         39 party:85 UK Independence Party (UKIP) UTW:E05001611 Orford ward                       2016-05-05 0 0           PP85   0
10915 9370 Morgan Tarr         39 party:53 Labour Party UTW:E05001611 Orford ward   1.0                   2016-05-05 0 0           PP53   0
10916 9371 Jan Woning         39 party:52 Conservative and Unionist Party UTW:E05001611 Orford ward                       2016-05-05 0 0           PP52   0
10917 9382 Sam Baxter         39 party:52 Conservative and Unionist Party UTW:E05001612 Penketh and Cuerdley ward                       2016-05-05 0 0           PP52   0
10918 9383 Allin Dirir         39 party:53 Labour Party UTW:E05001612 Penketh and Cuerdley ward                       2016-05-05 0 0           PP53   0
10919 9384 Linda Susan Dirir         39 party:53 Labour Party UTW:E05001612 Penketh and Cuerdley ward                       2016-05-05 0 0           PP53   0
10920 9385 Matt Jones         39 party:52 Conservative and Unionist Party UTW:E05001612 Penketh and Cuerdley ward                       2016-05-05 0 0           PP52   0
10921 9386 Denis Patrick McAllister         39 party:90 Liberal Democrats UTW:E05001612 Penketh and Cuerdley ward                       2016-05-05 0 0           PP90   0
10922 9387 Kevin Morton         39 party:52 Conservative and Unionist Party UTW:E05001612 Penketh and Cuerdley ward                       2016-05-05 0 0           PP52   0
10923 9407 Mike Byrne         39 party:85 UK Independence Party (UKIP) UTW:E05001613 Poplars and Hulme ward                       2016-05-05 0 0           PP85   0
10924 9408 Hilary Cooksey         39 party:53 Labour Party UTW:E05001613 Poplars and Hulme ward   1.0                   2016-05-05 0 0           PP53   0
10925 9409 John Kerr-Brown         39 party:53 Labour Party UTW:E05001613 Poplars and Hulme ward   1.0                   2016-05-05 0 0           PP53   0
10926 9410 Francine Leslie         39 party:52 Conservative and Unionist Party UTW:E05001613 Poplars and Hulme ward                       2016-05-05 0 0           PP52   0
10927 9411 Brian Maher         39 party:53 Labour Party UTW:E05001613 Poplars and Hulme ward   1.0                   2016-05-05 0 0           PP53   0
10928 9412 Pam Todd         39 party:90 Liberal Democrats UTW:E05001613 Poplars and Hulme ward                       2016-05-05 0 0           PP90   0
10929 9422 Diana Bennett         39 party:53 Labour Party UTW:E05001614 Poulton North ward   1.0                   2016-05-05 0 0           PP53   0
10930 9423 Philip Eastty         39 party:52 Conservative and Unionist Party UTW:E05001614 Poulton North ward                       2016-05-05 0 0           PP52   0
10931 9424 Graham Friend         39 party:53 Labour Party UTW:E05001614 Poulton North ward   1.0                   2016-05-05 0 0           PP53   0
10932 9425 Chris Oliver         39 party:90 Liberal Democrats UTW:E05001614 Poulton North ward                       2016-05-05 0 0           PP90   0
10933 9426 Russell Purnell         39 party:53 Labour Party UTW:E05001614 Poulton North ward   1.0                   2016-05-05 0 0           PP53   0
10934 9427 Maureen Creaghan         39 party:53 Labour Party UTW:E05001615 Poulton South ward   1.0                   2016-05-05 0 0           PP53   0
10935 9428 Colin Froggatt         39 party:53 Labour Party UTW:E05001615 Poulton South ward   1.0                   2016-05-05 0 0           PP53   0
10936 9429 Dave Hockenhull         39 party:90 Liberal Democrats UTW:E05001615 Poulton South ward                       2016-05-05 0 0           PP90   0
10937 9430 Emma Sloan         39 party:52 Conservative and Unionist Party UTW:E05001615 Poulton South ward                       2016-05-05 0 0           PP52   0
10938 9431 Bob Taylor         39 party:804 Trade Unionist and Socialist Coalition UTW:E05001615 Poulton South ward                       2016-05-05 0 0           PP804   0
10939 9436 Paul Francis Bretherton         39 ynmp-party:2 Independent UTW:E05001616 Rixton and Woolston ward                       2016-05-05 0 0           ynmp-party:2   0
Powered by Datasette · Query took 1.122ms