home / democracyclub

democracyclub

Custom SQL query returning 56 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
12131 3248 Nigel Knowles     male 1946-12-05 56 party:53 Labour Party DIW:E05010508 Franche & Habberley North   1.0 http://www.labour.org.uk/people/detail/nigel-knowles       https://static-candidates.democracyclub.org.uk/media/images/images/3248.png   other Aisha Candidates agent emailed it to us (NUT). 2016-05-05 0 0   32019.0       PP53   0
12132 10014 John Cedric Aston         56 ynmp-party:2 Independent DIW:E05010502 Aggborough & Spennells   1.0                   2016-05-05 0 0   13523.0       ynmp-party:2   0
12133 10015 Anna Coleman     female   56 party:52 Conservative and Unionist Party DIW:E05010502 Aggborough & Spennells     https://www.wyreforestconservatives.com/people/anna-coleman       https://static-candidates.democracyclub.org.uk/media/images/images/10015.png   profile-photo sjorford https://www.wyreforestconservatives.com/people/anna-coleman 2016-05-05 0 0           PP52   0
12134 10016 Doug Hine         56 party:63 Green Party DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0           PP63   0
12135 10017 Philip Howard Jeanes         56 party:85 UK Independence Party (UKIP) DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0   13524.0       PP85   0
12136 10018 Keith Robertson         56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0   14443.0       PP44   0
12137 10019 Brian Alan Rushbrook         56 party:53 Labour Party DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0   13525.0       PP53   0
12138 10059 Berenice Susan Dawes         56 party:85 UK Independence Party (UKIP) DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0           PP85   0
12139 10060 Lin Henderson         56 party:52 Conservative and Unionist Party DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0           PP52   0
12140 10061 Vi Higgs         56 party:53 Labour Party DIW:E05010503 Areley Kings & Riverside   1.0                   2016-05-05 0 0           PP53   0
12141 10062 John William Roland Thomas         56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0           PP44   0
12142 13052 Gilda Maria Davis         56 party:63 Green Party DIW:E05010510 Mitton                       2016-05-05 0 0           PP63   0
12143 13053 Jill Hawes         56 party:53 Labour Party DIW:E05010510 Mitton                       2016-05-05 0 0           PP53   0
12144 13054 John Holden         56 party:85 UK Independence Party (UKIP) DIW:E05010510 Mitton                       2016-05-05 0 0           PP85   0
12145 13055 Nicky Martin         56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010510 Mitton   1.0                   2016-05-05 0 0           PP44   0
12146 13056 Tony Muir         56 party:52 Conservative and Unionist Party DIW:E05010510 Mitton                       2016-05-05 0 0           PP52   0
12147 14125 Linda Anne Candlin         56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP44   0
12148 14128 David John Field         56 party:85 UK Independence Party (UKIP) DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP85   0
12149 14816 John Davis         56 party:63 Green Party DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0           PP63   0
12150 14817 Paul Bernard Harrison         56 party:52 Conservative and Unionist Party DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0           PP52   0
12151 14818 Bill Hopkins         56 party:85 UK Independence Party (UKIP) DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0   32018.0       PP85   0
12152 14819 Caroline Marie Shellie         56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0           PP44   0
12153 15073 Meriel Rose Acton         56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP44   0
12154 15074 Brett Caulfield     Male   56 party:63 Green Party DIW:E05010511 Offmore & Comberton     https://my.greenparty.org.uk/candidates/106312 https://wyreforest.greenparty.org.uk/local-elections.html     https://static-candidates.democracyclub.org.uk/media/images/images/15074.png   profile-photo yanbad13257 http://www.redditchadvertiser.co.uk/news/regional/15267834.Brett_Caulfield_to_contest_Wyre_Forest_seat_for_the_Green_Party_in_General_Election/ 2016-05-05 0 0           PP63   0
12155 15075 Mike Cheeseman     Male   56 party:52 Conservative and Unionist Party DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP52   0
12156 15076 Shazu Miah     male   56 party:90 Liberal Democrats DIW:E05010511 Offmore & Comberton   1.0 http://www.libdems.org.uk/shazu-miah       https://static-candidates.democracyclub.org.uk/media/images/images/15076.png   profile-photo yanbad13257 http://www.wyreforest.gov.uk/council/councillors/mem109.htm 2016-05-05 0 0           PP90   0
12157 15077 Nick Savage         56 party:53 Labour Party DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP53   0
12158 15078 Martin John Stooke         56 party:85 UK Independence Party (UKIP) DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP85   0
12159 19066 Rachel Louise Akathiotis         56 party:90 Liberal Democrats DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP90   0
12160 19067 Dave Finch         56 party:63 Green Party DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP63   0
12161 19068 William Paul Stephen Mack         56 party:52 Conservative and Unionist Party DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP52   0
12162 19069 Steven John Walker         56 party:53 Labour Party DIW:E05010506 Broadwaters   1.0                   2016-05-05 0 0           PP53   0
12163 19070 Paul Wooldridge         56 party:85 UK Independence Party (UKIP) DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP85   0
12164 19071 Peter Winston Montgomery Young         56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP44   0
12165 19194 Dan Collins         56 party:85 UK Independence Party (UKIP) DIW:E05010513 Wyre Forest Rural                       2016-05-05 0 0           PP85   0
12166 19196 Stephen John Williams         56 party:52 Conservative and Unionist Party DIW:E05010513 Wyre Forest Rural   1.0                   2016-05-05 0 0           PP52   0
12167 19198 Maurice Andrew Alton         56 party:85 UK Independence Party (UKIP) DIW:E05010504 Bewdley & Rock                       2016-05-05 0 0           PP85   0
12168 19199 Calne Edginton-White     female   56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010504 Bewdley & Rock             https://static-candidates.democracyclub.org.uk/media/images/images/19199.png   profile-photo sjorford http://www.ichcbewdley.co.uk/index.php?page=Calne-Edginton-White 2016-05-05 0 0           PP44   0
12169 19200 Phil Oliver         56 party:63 Green Party DIW:E05010504 Bewdley & Rock                       2016-05-05 0 0           PP63   0
12170 19201 Rod Stanczyszyn         56 party:53 Labour Party DIW:E05010504 Bewdley & Rock                       2016-05-05 0 0           PP53   0
12171 19202 Rod Wilson         56 party:52 Conservative and Unionist Party DIW:E05010504 Bewdley & Rock   1.0                   2016-05-05 0 0           PP52   0
12172 19203 Adrian Stanley Beavis         56 party:90 Liberal Democrats DIW:E05010505 Blakebrook & Habberley South                       2016-05-05 0 0           PP90   0
12173 19204 George Connolly mr   male 1997-05-15 56 party:85 UK Independence Party (UKIP) DIW:E05010505 Blakebrook & Habberley South             https://static-candidates.democracyclub.org.uk/media/images/images/19204.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP85   0
12174 19205 Bernadette Connor         56 party:53 Labour Party DIW:E05010505 Blakebrook & Habberley South                       2016-05-05 0 0           PP53   0
12175 19206 Vicky Lea         56 party:63 Green Party DIW:E05010505 Blakebrook & Habberley South                       2016-05-05 0 0           PP63   0
12176 19207 Juliet Denise Smith         56 party:52 Conservative and Unionist Party DIW:E05010505 Blakebrook & Habberley South   1.0                   2016-05-05 0 0           PP52   0
12177 19208 Leia Rachael Devon Beavis         56 party:90 Liberal Democrats DIW:E05010507 Foley Park & Hoobrook                       2016-05-05 0 0           PP90   0
12178 19209 John Byng     male   56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010507 Foley Park & Hoobrook             https://static-candidates.democracyclub.org.uk/media/images/images/19209.png   profile-photo sjorford http://www.ichcbewdley.co.uk/index.php?page=john-byng 2016-05-05 0 0           PP44   0
12179 19210 Gerald Crumpton         56 party:53 Labour Party DIW:E05010507 Foley Park & Hoobrook                       2016-05-05 0 0           PP53   0
12180 19211 Nicky Gale         56 party:52 Conservative and Unionist Party DIW:E05010507 Foley Park & Hoobrook   1.0                   2016-05-05 0 0           PP52   0
12181 19212 Michael James William Wrench         56 party:85 UK Independence Party (UKIP) DIW:E05010507 Foley Park & Hoobrook                       2016-05-05 0 0           PP85   0
12182 19213 Daniel John Crampton         56 party:53 Labour Party DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP53   0
12183 19214 Martin Layton         56 party:63 Green Party DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP63   0
12184 19215 Rebecca Vale         56 party:52 Conservative and Unionist Party DIW:E05010512 Wribbenhall & Arley   1.0                   2016-05-05 0 0           PP52   0
12185 32003 Nicholas Dean Atkinson         56 party:63 Green Party DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0   10058.0       PP63   0
12186 32024 Dave Jones         56 party:53 Labour Party DIW:E05010513 Wyre Forest Rural                       2016-05-05 0 0   19195.0       PP53   0
Powered by Datasette · Query took 0.761ms