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
12804 604 Daryl Stanbury     male 1986-09-15 67 party:85 UK Independence Party (UKIP) DIW:E05010966 Tuffley ward                       2016-05-05 0 0   17182.0       PP85   0
12805 864 Matthew Sidford     male   67 party:63 Green Party DIW:E05010962 Moreland ward                       2016-05-05 0 0   17136.0       PP63   0
12806 1202 Jeremy Hilton     male 1955.0 67 party:90 Liberal Democrats DIW:E05010958 Kingsholm and Wotton ward   1.0 http://www.libdems.org.uk/jeremy_hilton http://jeremyhilton.mycouncillor.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5481e905b150e238702c0622.png   profile-photo     2016-05-05 0 0   17106.0       PP90   0
12807 4611 Jonathan Ingleby Dr MA, BD, PhD male 1941-02-14 67 party:63 Green Party DIW:E05010955 Elmbridge ward             https://static-candidates.democracyclub.org.uk/media/images/553b8b0c7b9de399275bb495.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/greateconomy 2016-05-05 0 0   17068.0       PP63   0
12808 6174 Sue Powell     female   67 party:804 Trade Unionist and Socialist Coalition DIW:E05010953 Barton and Tredworth ward     http://tusc2015.com/sue-powell-for-gloucester/       https://static-candidates.democracyclub.org.uk/media/images/55477a82ec3a5a0f4103bf0d.png   profile-photo andylolz From party PPC page: http://tusc2015.com/sue-powell-for-gloucester/ 2016-05-05 0 0           PP804   0
12809 13892 Gary Frederick Cleaver         67 party:85 UK Independence Party (UKIP) DIW:E05010961 Matson and Robinswood ward                       2016-05-05 0 0           PP85   0
12810 13893 Tom Coole     male   67 party:53 Labour Party DIW:E05010961 Matson and Robinswood ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13893.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=102406299 2016-05-05 0 0           PP53   0
12811 13894 Ros Durrant         67 party:63 Green Party DIW:E05010961 Matson and Robinswood ward                       2016-05-05 0 0           PP63   0
12812 13895 Simon John Griffiths         67 party:52 Conservative and Unionist Party DIW:E05010961 Matson and Robinswood ward                       2016-05-05 0 0           PP52   0
12813 13896 Kate Haigh     female   67 party:53 Labour Party DIW:E05010961 Matson and Robinswood ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13896.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=19588903 2016-05-05 0 0           PP53   0
12814 13897 Duncan Hall         67 party:52 Conservative and Unionist Party DIW:E05010961 Matson and Robinswood ward                       2016-05-05 0 0           PP52   0
12815 13898 Jan Lugg         67 party:53 Labour Party DIW:E05010961 Matson and Robinswood ward   1.0                   2016-05-05 0 0           PP53   0
12816 13899 Norman John Ravenhill         67 party:52 Conservative and Unionist Party DIW:E05010961 Matson and Robinswood ward                       2016-05-05 0 0           PP52   0
12817 14012 Lauren Marie Fearn         67 party:53 Labour Party DIW:E05010954 Coney Hill ward                       2016-05-05 0 0           PP53   0
12818 14013 Philip Stuart McLellan         67 party:90 Liberal Democrats DIW:E05010954 Coney Hill ward                       2016-05-05 0 0           PP90   0
12819 14014 Phillip Anthony William Nash         67 party:85 UK Independence Party (UKIP) DIW:E05010954 Coney Hill ward                       2016-05-05 0 0           PP85   0
12820 14015 Tarren Anne Randle         67 party:52 Conservative and Unionist Party DIW:E05010954 Coney Hill ward                       2016-05-05 0 0           PP52   0
12821 14152 Tony Hodges         67 party:53 Labour Party DIW:E05010951 Abbeymead ward                       2016-05-05 0 0           PP53   0
12822 14153 Laura Pearsall         67 party:52 Conservative and Unionist Party DIW:E05010951 Abbeymead ward   1.0                   2016-05-05 0 0           PP52   0
12823 14154 Michael Richardson         67 party:63 Green Party DIW:E05010951 Abbeymead ward                       2016-05-05 0 0           PP63   0
12824 14155 Gordon Taylor         67 party:52 Conservative and Unionist Party DIW:E05010951 Abbeymead ward   1.0                   2016-05-05 0 0           PP52   0
12825 14156 Jonathan Michael Whittaker         67 party:90 Liberal Democrats DIW:E05010951 Abbeymead ward                       2016-05-05 0 0           PP90   0
12826 14157 Abigail Wilson         67 party:90 Liberal Democrats DIW:E05010951 Abbeymead ward                       2016-05-05 0 0   32207.0       PP90   0
12827 17000 Collette Jane Finnegan         67 party:52 Conservative and Unionist Party DIW:E05010950 Abbeydale ward   1.0                   2016-05-05 0 0           PP52   0
12828 17001 Andrew Gravells         67 party:52 Conservative and Unionist Party DIW:E05010950 Abbeydale ward   1.0                   2016-05-05 0 0   29992.0       PP52   0
12829 17002 David Harber         67 ynmp-party:2 Independent DIW:E05010950 Abbeydale ward                       2016-05-05 0 0           ynmp-party:2   0
12830 17003 Emily Ann Hoddy         67 party:63 Green Party DIW:E05010950 Abbeydale ward                       2016-05-05 0 0           PP63   0
12831 17004 Steve Lugg         67 party:53 Labour Party DIW:E05010950 Abbeydale ward                       2016-05-05 0 0           PP53   0
12832 17005 Maisie Rose Sanders         67 party:53 Labour Party DIW:E05010950 Abbeydale ward                       2016-05-05 0 0           PP53   0
12833 17006 Danny Sparkes         67 party:85 UK Independence Party (UKIP) DIW:E05010950 Abbeydale ward                       2016-05-05 0 0           PP85   0
12834 17007 Patrick James Wilson         67 party:90 Liberal Democrats DIW:E05010950 Abbeydale ward                       2016-05-05 0 0           PP90   0
12835 17015 Brendan Mark Baker         67 party:63 Green Party DIW:E05010952 Barnwood ward                       2016-05-05 0 0           PP63   0
12836 17016 Joanne Marie Brown         67 party:90 Liberal Democrats DIW:E05010952 Barnwood ward   1.0                   2016-05-05 0 0           PP90   0
12837 17017 Judi Brown         67 party:52 Conservative and Unionist Party DIW:E05010952 Barnwood ward                       2016-05-05 0 0           PP52   0
12838 17018 Trevor Duncan Howard         67 party:53 Labour Party DIW:E05010952 Barnwood ward                       2016-05-05 0 0           PP53   0
12839 17019 Lise Noakes         67 party:52 Conservative and Unionist Party DIW:E05010952 Barnwood ward   1.0                   2016-05-05 0 0           PP52   0
12840 17020 Jess Palmer         67 party:90 Liberal Democrats DIW:E05010952 Barnwood ward                       2016-05-05 0 0           PP90   0
12841 17021 Stephen Leslie Pottage         67 party:85 UK Independence Party (UKIP) DIW:E05010952 Barnwood ward                       2016-05-05 0 0           PP85   0
12842 17022 Cilla Woodman         67 party:53 Labour Party DIW:E05010952 Barnwood ward                       2016-05-05 0 0           PP53   0
12843 17045 Katy Bailey         67 party:804 Trade Unionist and Socialist Coalition DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP804   0
12844 17046 Usman Bhaimia         67 party:53 Labour Party DIW:E05010953 Barton and Tredworth ward   1.0                   2016-05-05 0 0           PP53   0
12845 17047 Charley Bircher         67 party:63 Green Party DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP63   0
12846 17048 Rashid Farooq         67 party:52 Conservative and Unionist Party DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP52   0
12847 17049 Said Hansdot         67 party:53 Labour Party DIW:E05010953 Barton and Tredworth ward   1.0                   2016-05-05 0 0           PP53   0
12848 17050 Paul Harries         67 party:90 Liberal Democrats DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP90   0
12849 17051 Gareth Huw John         67 party:63 Green Party DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP63   0
12850 17052 Garry Mills         67 party:53 Labour Party DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP53   0
12851 17053 Sajid Patel         67 party:52 Conservative and Unionist Party DIW:E05010953 Barton and Tredworth ward   1.0                   2016-05-05 0 0           PP52   0
12852 17054 Kamila Pawlowicz         67 party:85 UK Independence Party (UKIP) DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP85   0
12853 17055 Richard Price         67 party:804 Trade Unionist and Socialist Coalition DIW:E05010953 Barton and Tredworth ward                       2016-05-05 0 0           PP804   0
12854 17056 Daniel Woolf     male 1984.0 67 party:52 Conservative and Unionist Party DIW:E05010953 Barton and Tredworth ward             https://static-candidates.democracyclub.org.uk/media/images/images/17056.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=846390392 2016-05-05 0 0   34945.0       PP52   0
12855 17064 Frances Joan Griffiths         67 party:63 Green Party DIW:E05010955 Elmbridge ward                       2016-05-05 0 0           PP63   0
12856 17065 Shane Aaron Hopkins         67 party:52 Conservative and Unionist Party DIW:E05010955 Elmbridge ward                       2016-05-05 0 0           PP52   0
12857 17066 Justin Oliver Hudson         67 party:52 Conservative and Unionist Party DIW:E05010955 Elmbridge ward                       2016-05-05 0 0           PP52   0
12858 17067 Howard Hyman         67 party:90 Liberal Democrats DIW:E05010955 Elmbridge ward   1.0                   2016-05-05 0 0           PP90   0
12859 17069 Bob Mace         67 party:85 UK Independence Party (UKIP) DIW:E05010955 Elmbridge ward                       2016-05-05 0 0           PP85   0
12860 17070 Emily Sarah Trevithick Ryall         67 party:90 Liberal Democrats DIW:E05010955 Elmbridge ward   1.0                   2016-05-05 0 0           PP90   0
12861 17084 Daryl Baldwin         67 party:53 Labour Party DIW:E05010956 Grange ward                       2016-05-05 0 0           PP53   0
12862 17085 Nigel Joseph Hanman         67 party:52 Conservative and Unionist Party DIW:E05010956 Grange ward   1.0                   2016-05-05 0 0           PP52   0
12863 17086 Rosemarie Jean Marchmont         67 party:85 UK Independence Party (UKIP) DIW:E05010956 Grange ward                       2016-05-05 0 0           PP85   0
12864 17087 Mat McCall         67 party:53 Labour Party DIW:E05010956 Grange ward                       2016-05-05 0 0           PP53   0
12865 17088 Steve Morgan         67 party:52 Conservative and Unionist Party DIW:E05010956 Grange ward   1.0                   2016-05-05 0 0           PP52   0
12866 17089 David John Brown         67 party:90 Liberal Democrats DIW:E05010957 Hucclecote ward   1.0                   2016-05-05 0 0           PP90   0
12867 17090 Lee James Dopson         67 party:52 Conservative and Unionist Party DIW:E05010957 Hucclecote ward                       2016-05-05 0 0           PP52   0
12868 17091 Chris Etheridge         67 party:52 Conservative and Unionist Party DIW:E05010957 Hucclecote ward                       2016-05-05 0 0           PP52   0
12869 17092 Henry Thomas Jones         67 party:63 Green Party DIW:E05010957 Hucclecote ward                       2016-05-05 0 0           PP63   0
12870 17093 Kay Frances Mills         67 party:53 Labour Party DIW:E05010957 Hucclecote ward                       2016-05-05 0 0           PP53   0
12871 17094 Declan Wilson         67 party:90 Liberal Democrats DIW:E05010957 Hucclecote ward   1.0                   2016-05-05 0 0           PP90   0
12872 17103 James Alexander         67 party:85 UK Independence Party (UKIP) DIW:E05010958 Kingsholm and Wotton ward             https://static-candidates.democracyclub.org.uk/media/images/images/17103.png   copyright-assigned james19   2016-05-05 0 0           PP85   0
12873 17104 Isabel Mellonie Brazil         67 party:90 Liberal Democrats DIW:E05010958 Kingsholm and Wotton ward   1.0                   2016-05-05 0 0           PP90   0
12874 17105 Matthew David Francis         67 party:52 Conservative and Unionist Party DIW:E05010958 Kingsholm and Wotton ward                       2016-05-05 0 0           PP52   0
12875 17107 Jonathan Richard Hoad         67 party:53 Labour Party DIW:E05010958 Kingsholm and Wotton ward                       2016-05-05 0 0           PP53   0
12876 17108 Tim Justice         67 party:52 Conservative and Unionist Party DIW:E05010958 Kingsholm and Wotton ward                       2016-05-05 0 0           PP52   0
12877 17109 Mairi Mills         67 party:63 Green Party DIW:E05010958 Kingsholm and Wotton ward                       2016-05-05 0 0           PP63   0
12878 17110 Paul Michael Thompson         67 party:53 Labour Party DIW:E05010958 Kingsholm and Wotton ward                       2016-05-05 0 0           PP53   0
12879 17111 Richard Lawrence Cook         67 party:52 Conservative and Unionist Party DIW:E05010959 Kingsway ward   1.0                   2016-05-05 0 0           PP52   0
12880 17112 Jennie Rotheva Dallimore         67 party:52 Conservative and Unionist Party DIW:E05010959 Kingsway ward   1.0                   2016-05-05 0 0           PP52   0
12881 17113 Emma Jane Ford         67 party:53 Labour Party DIW:E05010959 Kingsway ward                       2016-05-05 0 0           PP53   0
12882 17114 Chloe French         67 party:63 Green Party DIW:E05010959 Kingsway ward                       2016-05-05 0 0           PP63   0
12883 17124 Christopher David Britton         67 party:63 Green Party DIW:E05010960 Longlevens ward                       2016-05-05 0 0           PP63   0
12884 17125 Susannah Collier         67 party:85 UK Independence Party (UKIP) DIW:E05010960 Longlevens ward                       2016-05-05 0 0           PP85   0
12885 17126 Terry Haines         67 party:53 Labour Party DIW:E05010960 Longlevens ward                       2016-05-05 0 0           PP53   0
12886 17127 Paul Harris         67 party:90 Liberal Democrats DIW:E05010960 Longlevens ward                       2016-05-05 0 0           PP90   0
12887 17128 Paul Simon James         67 party:52 Conservative and Unionist Party DIW:E05010960 Longlevens ward   1.0                   2016-05-05 0 0           PP52   0
12888 17129 Jim Porter         67 party:52 Conservative and Unionist Party DIW:E05010960 Longlevens ward   1.0                   2016-05-05 0 0           PP52   0
12889 17130 Kathy Williams         67 party:52 Conservative and Unionist Party DIW:E05010960 Longlevens ward   1.0                   2016-05-05 0 0           PP52   0
12890 17131 Lyn Ackroyd         67 party:52 Conservative and Unionist Party DIW:E05010962 Moreland ward                       2016-05-05 0 0           PP52   0
12891 17132 Simon Collins     male   67 party:85 UK Independence Party (UKIP) DIW:E05010962 Moreland ward                       2016-05-05 0 0   32206.0       PP85   0
12892 17133 Peter Denzil Corry         67 party:52 Conservative and Unionist Party DIW:E05010962 Moreland ward                       2016-05-05 0 0           PP52   0
12893 17134 Neil Hampson         67 party:53 Labour Party DIW:E05010962 Moreland ward   1.0                   2016-05-05 0 0           PP53   0
12894 17135 Terry Pullen         67 party:53 Labour Party DIW:E05010962 Moreland ward   1.0                   2016-05-05 0 0           PP53   0
12895 17137 Kevin Ernest Stephens         67 party:53 Labour Party DIW:E05010962 Moreland ward   1.0                   2016-05-05 0 0           PP53   0
12896 17138 Jane Elizabeth White         67 party:52 Conservative and Unionist Party DIW:E05010962 Moreland ward                       2016-05-05 0 0           PP52   0
12897 17149 Andrew Gilbert Miller         67 party:52 Conservative and Unionist Party DIW:E05010963 Podsmead ward                       2016-05-05 0 0           PP52   0
12898 17150 Deborah Ann Smith         67 party:53 Labour Party DIW:E05010963 Podsmead ward                       2016-05-05 0 0           PP53   0
12899 17151 Jan Garbutt         67 party:53 Labour Party DIW:E05010964 Quedgeley Fieldcourt ward                       2016-05-05 0 0           PP53   0
12900 17152 Ken Garbutt         67 party:53 Labour Party DIW:E05010964 Quedgeley Fieldcourt ward                       2016-05-05 0 0           PP53   0
12901 17153 Lee Hawthorne         67 party:52 Conservative and Unionist Party DIW:E05010964 Quedgeley Fieldcourt ward   1.0                   2016-05-05 0 0           PP52   0
12902 17154 Gordon Heath         67 party:90 Liberal Democrats DIW:E05010964 Quedgeley Fieldcourt ward                       2016-05-05 0 0           PP90   0
12903 17155 David Foley Norman         67 party:52 Conservative and Unionist Party DIW:E05010964 Quedgeley Fieldcourt ward   1.0                   2016-05-05 0 0           PP52   0
12904 17163 Mervyn John Hyde         67 party:53 Labour Party DIW:E05010965 Quedgeley Severn Vale ward                       2016-05-05 0 0           PP53   0
Powered by Datasette · Query took 1.135ms