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
11131 166 Paul Scriven     male 1966-02-07 45 party:90 Liberal Democrats MTW:E05010867 Ecclesall   1.0     https://en.wikipedia.org/wiki/Paul_Scriven             2016-05-05 0 0   12329.0       PP90   0
11132 250 Nigel Terence James     male   45 party:85 UK Independence Party (UKIP) MTW:E05010864 Darnall                       2016-05-05 0 0   12274.0       PP85   0
11133 432 Simon William Clement-Jones     male 1969.0 45 party:90 Liberal Democrats MTW:E05010870 Gleadless Valley           https://www.linkedin.com/pub/simon-clement-jones/52/87a/51a https://static-candidates.democracyclub.org.uk/media/images/images/432.png   other Jagusti Candidate profile picture from Sheffield Council 2016-05-05 0 0   12360.0       PP90   0
11134 1381 Jack Scott     male   45 party:53 Labour Party MTW:E05010876 Park & Arbourthorne   1.0   https://labourjack.wordpress.com/   https://www.linkedin.com/in/jack-scott-33372414 https://static-candidates.democracyclub.org.uk/media/images/images/1381.png   profile-photo JeniT from https://twitter.com/Jack_Scott 2016-05-05 0 0   12166.0       PP53   0
11135 1658 Patricia Sullivan     female   45 party:85 UK Independence Party (UKIP) MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP85   0
11136 1665 Jeffrey Shaw     male   45 party:85 UK Independence Party (UKIP) MTW:E05010875 Nether Edge & Sharrow                       2016-05-05 0 0   12430.0       PP85   0
11137 1666 Steve Barnard     male   45 party:63 Green Party MTW:E05010875 Nether Edge & Sharrow                       2016-05-05 0 0           PP63   0
11138 3344 Gail Smith     female   45 party:90 Liberal Democrats MTW:E05010863 Crookes & Crosspool     http://www.libdems.org.uk/gail_smith       https://static-candidates.democracyclub.org.uk/media/images/551afe0513eb34c82843cb40.png   profile-photo JPCarrington Profile picture as featured on national party's PPC page: http://www.libdems.org.uk/gail_smith 2016-05-05 0 0   12267.0       PP90   0
11139 3957 Ian Saunders     male   45 party:53 Labour Party MTW:E05010858 Beighton   1.0                   2016-05-05 0 0   12182.0       PP53   0
11140 4528 Jonathan Graham Harston     male 1969-01-07 45 party:90 Liberal Democrats MTW:E05010882 Walkley     http://www.libdems.org.uk/jonathan_harston     https://www.linkedin.com/in/jgharston/ https://static-candidates.democracyclub.org.uk/media/images/550bf19f36b6dcb123cb4339.png   copyright-assigned jonathan6 My standard mugshot photo. 2016-05-05 0 0   132;12550;25574       PP90   0
11141 4606 Peter Garbutt     male   45 party:63 Green Party MTW:E05010863 Crookes & Crosspool     http://sheffieldgreenparty.org.uk/people/activist/peter-garbutt/       https://static-candidates.democracyclub.org.uk/media/images/images/4606.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
11142 4897 Joe Otten     male   45 party:90 Liberal Democrats MTW:E05010865 Dore & Totley   1.0 http://www.libdems.org.uk/joe-otten http://joe.otten.uk/     https://static-candidates.democracyclub.org.uk/media/images/54f7695bc689026478f43679.png   profile-photo JPCarrington Photo used as profile picture for Facebook campaign page here: https://www.facebook.com/joe.otten4sheffield 2016-05-05 0 0           PP90   0
11143 4950 Rita Wilcock     female   45 party:63 Green Party MTW:E05010857 Beauchief & Greenhill     http://yorkshireandhumber.greenparty.org.uk/candidates/rita-wilcock,-sheffield-heeley.html       https://static-candidates.democracyclub.org.uk/media/images/54a19fe1cca5fe1a31e4a7a1.png         2016-05-05 0 0   9120.0       PP63   0
11144 6369 Penny Baker     female   45 party:90 Liberal Democrats MTW:E05010880 Stannington   1.0                   2016-05-05 0 0           PP90   0
11145 6383 Graeme Waddicar Mr   male 1958-08-09 45 party:85 UK Independence Party (UKIP) MTW:E05010881 Stocksbridge & Upper Don       http://www.ukipstocksbridge.co.uk/   https://uk.linkedin.com/in/graemewaddicar https://static-candidates.democracyclub.org.uk/media/images/55361f994eb6352b1643ebc7.png   profile-photo ruth2 I am the press officer and campaign manager for Graeme Waddicar and he has authorised me to upload this photo. 2016-05-05 0 0   12540.0       PP85   0
11146 6749 Steven Winstone     male 1974.0 45 party:85 UK Independence Party (UKIP) MTW:E05010878 Shiregreen & Brightside     http://sdpuk.nationbuilder.com/steve_winstone     https://www.linkedin.com/profile/view?id=95182951 https://static-candidates.democracyclub.org.uk/media/images/5517f7fb249b917507bee519.png   profile-photo gerv   2016-05-05 0 0   12476;19654;34952       PP85   0
11147 6750 John Booker     male 1963-03-25 45 party:85 UK Independence Party (UKIP) MTW:E05010883 West Ecclesfield   1.0 http://www.ukipstocksbridge.co.uk/?page_id=658       https://static-candidates.democracyclub.org.uk/media/images/551afe3813eb34c82843cb43.png   profile-photo JPCarrington Picture used on local party PPC page: http://www.ukipsheffield.org.uk/candidates.html 2016-05-05 0 0   12556.0       PP85   0
11148 6783 Ian Whitehouse     male   45 party:804 Trade Unionist and Socialist Coalition MTW:E05010884 Woodhouse             https://static-candidates.democracyclub.org.uk/media/images/5517f71b249b917507bee514.png   public-domain alistair I'm his election agent 2016-05-05 0 0           PP804   0
11149 6930 Christine Gilligan     Female   45 party:63 Green Party MTW:E05010872 Hillsborough     https://my.greenparty.org.uk/candidates/106173     https://www.linkedin.com/in/dr-christine-gilligan-232497b/ https://static-candidates.democracyclub.org.uk/media/images/images/6930.png   profile-photo Jagusti   2016-05-05 0 0   12389;19648       PP63   0
11150 9098 Julie Gledhill         45 party:53 Labour Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP53   0
11151 9099 Catherine Sarah Hartley     female   45 party:63 Green Party MTW:E05010857 Beauchief & Greenhill     https://sheffieldgreenparty.org.uk/elections/council-2018/cat-hartley/       https://static-candidates.democracyclub.org.uk/media/images/images/9099.png   profile-photo fbrc https://sheffieldgreenparty.org.uk/elections/council-2018/cat-hartley/ 2016-05-05 0 0           PP63   0
11152 9100 Paul Horada-Bradnum         45 party:63 Green Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP63   0
11153 9101 John Kirby         45 party:53 Labour Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP53   0
11154 9102 Peter Morris         45 party:52 Conservative and Unionist Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP52   0
11155 9103 Roy Munn         45 party:53 Labour Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP53   0
11156 9104 Terry Steven Michael Murphy         45 party:804 Trade Unionist and Socialist Coalition MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP804   0
11157 9105 Andy Nash     male 1975.0 45 party:90 Liberal Democrats MTW:E05010857 Beauchief & Greenhill   1.0 http://www.libdems.org.uk/andy-nash http://andynash4leeds.org     https://static-candidates.democracyclub.org.uk/media/images/images/9105_rv0HVmP.png   copyright-assigned andynash   2016-05-05 0 0           PP90 Choco Leibniz - excellent chocolate to biscuit ratio 0
11158 9106 Bob Pullin         45 party:90 Liberal Democrats MTW:E05010857 Beauchief & Greenhill   1.0                   2016-05-05 0 0           PP90   0
11159 9107 John Scotting         45 party:52 Conservative and Unionist Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0   31445.0       PP52   0
11160 9116 Richard Craig Thomas Shaw         45 party:90 Liberal Democrats MTW:E05010857 Beauchief & Greenhill   1.0                   2016-05-05 0 0           PP90   0
11161 9117 Jean Simpson         45 party:85 UK Independence Party (UKIP) MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP85   0
11162 9118 Andy Taylor         45 party:52 Conservative and Unionist Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0   39058.0       PP52   0
11163 9119 Andrew John Telford         45 party:85 UK Independence Party (UKIP) MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP85   0
11164 12157 Kristopher Connor Barker         45 party:804 Trade Unionist and Socialist Coalition MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP804   0
11165 12158 Jennyfer Barnard     female   45 party:63 Green Party MTW:E05010876 Park & Arbourthorne     https://sheffieldgreenparty.org.uk/elections/council-2018/jen-barnard/       https://static-candidates.democracyclub.org.uk/media/images/images/12158.png   profile-photo fbrc https://sheffieldgreenparty.org.uk/elections/council-2018/jen-barnard/ 2016-05-05 0 0           PP63   0
11166 12159 Dennise Ann Dawson     female   45 party:85 UK Independence Party (UKIP) MTW:E05010876 Park & Arbourthorne             https://static-candidates.democracyclub.org.uk/media/images/images/12159.png   profile-photo yanbad13257   2016-05-05 0 0           PP85   0
11167 12160 Julie Dore     female   45 party:53 Labour Party MTW:E05010876 Park & Arbourthorne   1.0     https://en.wikipedia.org/wiki/Julie_Dore https://uk.linkedin.com/in/julie-dore-8701912b https://static-candidates.democracyclub.org.uk/media/images/images/12160.png   profile-photo drjtwit Sheffield City Council councillor info page: http://democracy.sheffield.gov.uk/mgUserInfo.aspx?UID=118 2016-05-05 0 0           PP53   0
11168 12161 Lyuba Ilieva Herbert         45 party:63 Green Party MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP63   0
11169 12162 Ann Patricia Kingdom         45 party:90 Liberal Democrats MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP90   0
11170 12163 Ben Miskell         45 party:53 Labour Party MTW:E05010876 Park & Arbourthorne   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12163.png   profile-photo drjtwit https://twitter.com/benmiskell 2016-05-05 0 0           PP53   0
11171 12164 Mike Reynolds         45 party:90 Liberal Democrats MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP90   0
11172 12165 Susan Elizabeth Ross         45 party:90 Liberal Democrats MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP90   0
11173 12167 Edward Gordon Squires         45 party:63 Green Party MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP63   0
11174 12168 Francis Henry Woodger         45 party:52 Conservative and Unionist Party MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP52   0
11175 12174 Shirley Diane Clayton         45 party:52 Conservative and Unionist Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP52   0
11176 12175 Brett Colk         45 party:85 UK Independence Party (UKIP) MTW:E05010858 Beighton                       2016-05-05 0 0           PP85   0
11177 12176 Margaret Rose Gray         45 party:804 Trade Unionist and Socialist Coalition MTW:E05010858 Beighton                       2016-05-05 0 0           PP804   0
11178 12177 Richard Matthew Madden         45 party:63 Green Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP63   0
11179 12178 Helen Mirfin-Boukouris         45 party:53 Labour Party MTW:E05010858 Beighton   1.0                   2016-05-05 0 0           PP53   0
11180 12179 Clare Helen Carol Relton         45 party:63 Green Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP63   0
11181 12180 Chris Rosling-Josephs         45 party:53 Labour Party MTW:E05010858 Beighton   1.0                   2016-05-05 0 0           PP53   0
11182 12181 Richard Andrew Sangar         45 party:90 Liberal Democrats MTW:E05010858 Beighton                       2016-05-05 0 0           PP90   0
11183 12183 Kiri Smith         45 party:63 Green Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP63   0
11184 12184 Sophie Thornton     female   45 party:90 Liberal Democrats MTW:E05010858 Beighton                       2016-05-05 0 0           PP90   0
11185 12185 Allan Thomas Wisbey         45 party:90 Liberal Democrats MTW:E05010858 Beighton                       2016-05-05 0 0           PP90   0
11186 12192 Jane Ellen Chapman         45 party:90 Liberal Democrats MTW:E05010859 Birley                       2016-05-05 0 0           PP90   0
11187 12193 Bradley Colk         45 party:85 UK Independence Party (UKIP) MTW:E05010859 Birley                       2016-05-05 0 0           PP85   0
11188 12194 Andrew Christopher Dixon         45 party:90 Liberal Democrats MTW:E05010859 Birley                       2016-05-05 0 0           PP90   0
11189 12195 Denise Fox         45 party:53 Labour Party MTW:E05010859 Birley   1.0                   2016-05-05 0 0           PP53   0
11190 12196 Calum Heaton         45 party:52 Conservative and Unionist Party MTW:E05010859 Birley                       2016-05-05 0 0           PP52   0
11191 12197 Dennis Hobson         45 party:85 UK Independence Party (UKIP) MTW:E05010884 Woodhouse                       2016-05-05 0 0           PP85   0
11192 12198 Bryan Lodge         45 party:53 Labour Party MTW:E05010859 Birley   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12198.png   profile-photo drjtwit Sheffield City Council picture http://democracy.sheffield.gov.uk/mgUserInfo.aspx?UID=137 2016-05-05 0 0           PP53   0
11193 12199 Karen McGowan         45 party:53 Labour Party MTW:E05010859 Birley   1.0 http://birleywardlabourparty.org.uk/?page_id=95                 2016-05-05 0 0           PP53   0
11194 12200 Anthony Richard Naylor     male   45 party:63 Green Party MTW:E05010859 Birley     https://sheffieldgreenparty.org.uk/elections/council-2018/anthony-naylor/       https://static-candidates.democracyclub.org.uk/media/images/images/12200.png   profile-photo drjtwit Official campaign page: http://sheffieldgreenparty.org.uk/people/activist/anthony-naylor/ 2016-05-05 0 0           PP63   0
11195 12201 Ruth Frances Nicol         45 party:63 Green Party MTW:E05010859 Birley                       2016-05-05 0 0           PP63   0
11196 12202 John Joseph Voyse         45 party:804 Trade Unionist and Socialist Coalition MTW:E05010859 Birley                       2016-05-05 0 0           PP804   0
11197 12203 Hilda Wisbey         45 party:90 Liberal Democrats MTW:E05010859 Birley                       2016-05-05 0 0           PP90   0
11198 12204 Alan Bernard Armour Yearsley         45 party:63 Green Party MTW:E05010859 Birley                       2016-05-05 0 0           PP63   0
11199 12210 Toby Abbs         45 party:52 Conservative and Unionist Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP52   0
11200 12211 Saleh Alnoud         45 party:53 Labour Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP53   0
11201 12212 Michelle Cook         45 party:53 Labour Party MTW:E05010860 Broomhill & Sharrow Vale   1.0                   2016-05-05 0 0           PP53   0
11202 12213 Kurtis Jenson Crossland         45 party:90 Liberal Democrats MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP90   0
11203 12214 Bridget Rose Gilbert     female   45 party:804 Trade Unionist and Socialist Coalition MTW:E05010860 Broomhill & Sharrow Vale             https://static-candidates.democracyclub.org.uk/media/images/images/12214.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP804   0
11204 12215 Michael Lawrence Ginn         45 party:52 Conservative and Unionist Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP52   0
11205 12216 Chris Hallam         45 party:52 Conservative and Unionist Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP52   0
11206 12217 Kieran Harpham         45 party:53 Labour Party MTW:E05010860 Broomhill & Sharrow Vale   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12217.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=701773540551499776 2016-05-05 0 0           PP53   0
11207 12218 Magid Mah         45 party:63 Green Party MTW:E05010860 Broomhill & Sharrow Vale   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12218.png   profile-photo drjtwit Green Party Page: http://sheffieldgreenparty.org.uk/people/councillors/magid-magid/ 2016-05-05 0 0           PP63   0
11208 12219 Aodan Patrick Marken         45 party:63 Green Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP63   0
11209 12220 Barbara Wieslawa Masters         45 party:90 Liberal Democrats MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP90   0
11210 12221 Iain Christopher Prest         45 party:90 Liberal Democrats MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP90   0
11211 12222 Brian Webster         45 party:63 Green Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP63   0
11212 12228 Mobeen Arshad         45 party:63 Green Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP63   0
11213 12229 Ashish Bhandari         45 party:85 UK Independence Party (UKIP) MTW:E05010861 Burngreave                       2016-05-05 0 0           PP85   0
11214 12230 Shelley Cockayne         45 party:90 Liberal Democrats MTW:E05010861 Burngreave                       2016-05-05 0 0           PP90   0
11215 12231 Russell Cutts         45 party:52 Conservative and Unionist Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP52   0
11216 12232 Jackie Drayton         45 party:53 Labour Party MTW:E05010861 Burngreave   1.0                   2016-05-05 0 0           PP53   0
11217 12233 Iltaf Hussain         45 party:90 Liberal Democrats MTW:E05010861 Burngreave                       2016-05-05 0 0           PP90   0
11218 12234 Talib Hussain         45 party:53 Labour Party MTW:E05010861 Burngreave   1.0                   2016-05-05 0 0           PP53   0
11219 12235 Mubarak Musa Ismail         45 party:90 Liberal Democrats MTW:E05010861 Burngreave                       2016-05-05 0 0           PP90   0
11220 12236 Mark Jones         45 party:53 Labour Party MTW:E05010861 Burngreave   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12236.png   other drjtwit Sheffield City Council photo 2016-05-05 0 0   39265.0       PP53   0
11221 12237 Timothy Marsh         45 party:52 Conservative and Unionist Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP52   0
11222 12238 Chris Sissons     male   45 party:63 Green Party MTW:E05010861 Burngreave     https://sheffieldgreenparty.org.uk/elections/council-2018/chris-sissons/       https://static-candidates.democracyclub.org.uk/media/images/images/12238.png   profile-photo fbrc https://sheffieldgreenparty.org.uk/elections/council-2018/chris-sissons/ 2016-05-05 0 0           PP63   0
11223 12239 Alexander Taylor         45 party:52 Conservative and Unionist Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP52   0
11224 12240 Stephanie Claire Windle         45 party:63 Green Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP63   0
11225 12246 David Frederick Chapman         45 party:90 Liberal Democrats MTW:E05010862 City                       2016-05-05 0 0           PP90   0
11226 12247 Anders Hanson         45 party:90 Liberal Democrats MTW:E05010862 City                       2016-05-05 0 0           PP90   0
11227 12248 Amar Ilyas         45 party:53 Labour Party MTW:E05010862 City                       2016-05-05 0 0           PP53   0
11228 12249 Douglas Johnson         45 party:63 Green Party MTW:E05010862 City   1.0                   2016-05-05 0 0           PP63   0
11229 12250 Raymond Lawrence         45 party:52 Conservative and Unionist Party MTW:E05010862 City                       2016-05-05 0 0           PP52   0
11230 12251 Sam Morecroft         45 party:804 Trade Unionist and Socialist Coalition MTW:E05010862 City                       2016-05-05 0 0           PP804   0
11231 12252 Robert Murphy     male   45 party:63 Green Party MTW:E05010862 City   1.0   https://robformayor.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/12252.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=466486083 2016-05-05 0 0           PP63   0
Powered by Datasette · Query took 1.246ms