home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

372 rows where election = 45

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, facebook_page_url, facebook_personal_url, homepage_url, wikipedia_url, linkedin_url, image_copyright, image_uploading_user, old_person_ids, party_ec_id, favourite_biscuits

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id post_label mapit_url elected party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes election_date election_current party_lists_in_use party_list_position old_person_ids gss_code parlparse_id theyworkforyou_url party_ec_id favourite_biscuits cancelled_poll
11131 11131 166 Paul Scriven     male 1966-02-07 local.sheffield.2016-05-05 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 11132 250 Nigel Terence James     male   local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010864 Darnall                       2016-05-05 0 0   12274.0       PP85   0
11133 11133 432 Simon William Clement-Jones     male 1969.0 local.sheffield.2016-05-05 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 11134 1381 Jack Scott     male   local.sheffield.2016-05-05 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 11135 1658 Patricia Sullivan     female   local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP85   0
11136 11136 1665 Jeffrey Shaw     male   local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010875 Nether Edge & Sharrow                       2016-05-05 0 0   12430.0       PP85   0
11137 11137 1666 Steve Barnard     male   local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010875 Nether Edge & Sharrow                       2016-05-05 0 0           PP63   0
11138 11138 3344 Gail Smith     female   local.sheffield.2016-05-05 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 11139 3957 Ian Saunders     male   local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010858 Beighton   1.0                   2016-05-05 0 0   12182.0       PP53   0
11140 11140 4528 Jonathan Graham Harston     male 1969-01-07 local.sheffield.2016-05-05 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 11141 4606 Peter Garbutt     male   local.sheffield.2016-05-05 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 11142 4897 Joe Otten     male   local.sheffield.2016-05-05 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 11143 4950 Rita Wilcock     female   local.sheffield.2016-05-05 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 11144 6369 Penny Baker     female   local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010880 Stannington   1.0                   2016-05-05 0 0           PP90   0
11145 11145 6383 Graeme Waddicar Mr   male 1958-08-09 local.sheffield.2016-05-05 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 11146 6749 Steven Winstone     male 1974.0 local.sheffield.2016-05-05 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 11147 6750 John Booker     male 1963-03-25 local.sheffield.2016-05-05 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 11148 6783 Ian Whitehouse     male   local.sheffield.2016-05-05 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 11149 6930 Christine Gilligan     Female   local.sheffield.2016-05-05 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 11150 9098 Julie Gledhill         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP53   0
11151 11151 9099 Catherine Sarah Hartley     female   local.sheffield.2016-05-05 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 11152 9100 Paul Horada-Bradnum         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP63   0
11153 11153 9101 John Kirby         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP53   0
11154 11154 9102 Peter Morris         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP52   0
11155 11155 9103 Roy Munn         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP53   0
11156 11156 9104 Terry Steven Michael Murphy         local.sheffield.2016-05-05 45 party:804 Trade Unionist and Socialist Coalition MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP804   0
11157 11157 9105 Andy Nash     male 1975.0 local.sheffield.2016-05-05 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 11158 9106 Bob Pullin         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010857 Beauchief & Greenhill   1.0                   2016-05-05 0 0           PP90   0
11159 11159 9107 John Scotting         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0   31445.0       PP52   0
11160 11160 9116 Richard Craig Thomas Shaw         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010857 Beauchief & Greenhill   1.0                   2016-05-05 0 0           PP90   0
11161 11161 9117 Jean Simpson         local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP85   0
11162 11162 9118 Andy Taylor         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0   39058.0       PP52   0
11163 11163 9119 Andrew John Telford         local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010857 Beauchief & Greenhill                       2016-05-05 0 0           PP85   0
11164 11164 12157 Kristopher Connor Barker         local.sheffield.2016-05-05 45 party:804 Trade Unionist and Socialist Coalition MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP804   0
11165 11165 12158 Jennyfer Barnard     female   local.sheffield.2016-05-05 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 11166 12159 Dennise Ann Dawson     female   local.sheffield.2016-05-05 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 11167 12160 Julie Dore     female   local.sheffield.2016-05-05 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 11168 12161 Lyuba Ilieva Herbert         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP63   0
11169 11169 12162 Ann Patricia Kingdom         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP90   0
11170 11170 12163 Ben Miskell         local.sheffield.2016-05-05 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 11171 12164 Mike Reynolds         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP90   0
11172 11172 12165 Susan Elizabeth Ross         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP90   0
11173 11173 12167 Edward Gordon Squires         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP63   0
11174 11174 12168 Francis Henry Woodger         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010876 Park & Arbourthorne                       2016-05-05 0 0           PP52   0
11175 11175 12174 Shirley Diane Clayton         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP52   0
11176 11176 12175 Brett Colk         local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010858 Beighton                       2016-05-05 0 0           PP85   0
11177 11177 12176 Margaret Rose Gray         local.sheffield.2016-05-05 45 party:804 Trade Unionist and Socialist Coalition MTW:E05010858 Beighton                       2016-05-05 0 0           PP804   0
11178 11178 12177 Richard Matthew Madden         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP63   0
11179 11179 12178 Helen Mirfin-Boukouris         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010858 Beighton   1.0                   2016-05-05 0 0           PP53   0
11180 11180 12179 Clare Helen Carol Relton         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP63   0
11181 11181 12180 Chris Rosling-Josephs         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010858 Beighton   1.0                   2016-05-05 0 0           PP53   0
11182 11182 12181 Richard Andrew Sangar         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010858 Beighton                       2016-05-05 0 0           PP90   0
11183 11183 12183 Kiri Smith         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010858 Beighton                       2016-05-05 0 0           PP63   0
11184 11184 12184 Sophie Thornton     female   local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010858 Beighton                       2016-05-05 0 0           PP90   0
11185 11185 12185 Allan Thomas Wisbey         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010858 Beighton                       2016-05-05 0 0           PP90   0
11186 11186 12192 Jane Ellen Chapman         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010859 Birley                       2016-05-05 0 0           PP90   0
11187 11187 12193 Bradley Colk         local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010859 Birley                       2016-05-05 0 0           PP85   0
11188 11188 12194 Andrew Christopher Dixon         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010859 Birley                       2016-05-05 0 0           PP90   0
11189 11189 12195 Denise Fox         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010859 Birley   1.0                   2016-05-05 0 0           PP53   0
11190 11190 12196 Calum Heaton         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010859 Birley                       2016-05-05 0 0           PP52   0
11191 11191 12197 Dennis Hobson         local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010884 Woodhouse                       2016-05-05 0 0           PP85   0
11192 11192 12198 Bryan Lodge         local.sheffield.2016-05-05 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 11193 12199 Karen McGowan         local.sheffield.2016-05-05 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 11194 12200 Anthony Richard Naylor     male   local.sheffield.2016-05-05 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 11195 12201 Ruth Frances Nicol         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010859 Birley                       2016-05-05 0 0           PP63   0
11196 11196 12202 John Joseph Voyse         local.sheffield.2016-05-05 45 party:804 Trade Unionist and Socialist Coalition MTW:E05010859 Birley                       2016-05-05 0 0           PP804   0
11197 11197 12203 Hilda Wisbey         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010859 Birley                       2016-05-05 0 0           PP90   0
11198 11198 12204 Alan Bernard Armour Yearsley         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010859 Birley                       2016-05-05 0 0           PP63   0
11199 11199 12210 Toby Abbs         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP52   0
11200 11200 12211 Saleh Alnoud         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP53   0
11201 11201 12212 Michelle Cook         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010860 Broomhill & Sharrow Vale   1.0                   2016-05-05 0 0           PP53   0
11202 11202 12213 Kurtis Jenson Crossland         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP90   0
11203 11203 12214 Bridget Rose Gilbert     female   local.sheffield.2016-05-05 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 11204 12215 Michael Lawrence Ginn         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP52   0
11205 11205 12216 Chris Hallam         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP52   0
11206 11206 12217 Kieran Harpham         local.sheffield.2016-05-05 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 11207 12218 Magid Mah         local.sheffield.2016-05-05 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 11208 12219 Aodan Patrick Marken         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP63   0
11209 11209 12220 Barbara Wieslawa Masters         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP90   0
11210 11210 12221 Iain Christopher Prest         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP90   0
11211 11211 12222 Brian Webster         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010860 Broomhill & Sharrow Vale                       2016-05-05 0 0           PP63   0
11212 11212 12228 Mobeen Arshad         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP63   0
11213 11213 12229 Ashish Bhandari         local.sheffield.2016-05-05 45 party:85 UK Independence Party (UKIP) MTW:E05010861 Burngreave                       2016-05-05 0 0           PP85   0
11214 11214 12230 Shelley Cockayne         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010861 Burngreave                       2016-05-05 0 0           PP90   0
11215 11215 12231 Russell Cutts         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP52   0
11216 11216 12232 Jackie Drayton         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010861 Burngreave   1.0                   2016-05-05 0 0           PP53   0
11217 11217 12233 Iltaf Hussain         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010861 Burngreave                       2016-05-05 0 0           PP90   0
11218 11218 12234 Talib Hussain         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010861 Burngreave   1.0                   2016-05-05 0 0           PP53   0
11219 11219 12235 Mubarak Musa Ismail         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010861 Burngreave                       2016-05-05 0 0           PP90   0
11220 11220 12236 Mark Jones         local.sheffield.2016-05-05 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 11221 12237 Timothy Marsh         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP52   0
11222 11222 12238 Chris Sissons     male   local.sheffield.2016-05-05 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 11223 12239 Alexander Taylor         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP52   0
11224 11224 12240 Stephanie Claire Windle         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010861 Burngreave                       2016-05-05 0 0           PP63   0
11225 11225 12246 David Frederick Chapman         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010862 City                       2016-05-05 0 0           PP90   0
11226 11226 12247 Anders Hanson         local.sheffield.2016-05-05 45 party:90 Liberal Democrats MTW:E05010862 City                       2016-05-05 0 0           PP90   0
11227 11227 12248 Amar Ilyas         local.sheffield.2016-05-05 45 party:53 Labour Party MTW:E05010862 City                       2016-05-05 0 0           PP53   0
11228 11228 12249 Douglas Johnson         local.sheffield.2016-05-05 45 party:63 Green Party MTW:E05010862 City   1.0                   2016-05-05 0 0           PP63   0
11229 11229 12250 Raymond Lawrence         local.sheffield.2016-05-05 45 party:52 Conservative and Unionist Party MTW:E05010862 City                       2016-05-05 0 0           PP52   0
11230 11230 12251 Sam Morecroft         local.sheffield.2016-05-05 45 party:804 Trade Unionist and Socialist Coalition MTW:E05010862 City                       2016-05-05 0 0           PP804   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "candidates" (
"id" INTEGER,
  "name" TEXT,
  "honorific_prefix" REAL,
  "honorific_suffix" REAL,
  "gender" TEXT,
  "birth_date" REAL,
  "election" INTEGER,
  "party_id" TEXT,
  "party_name" TEXT,
  "post_id" TEXT,
  "post_label" TEXT,
  "mapit_url" INTEGER,
  "elected" REAL,
  "email" TEXT,
  "twitter_username" REAL,
  "facebook_page_url" REAL,
  "party_ppc_page_url" REAL,
  "facebook_personal_url" REAL,
  "homepage_url" REAL,
  "wikipedia_url" REAL,
  "linkedin_url" REAL,
  "image_url" REAL,
  "proxy_image_url_template" INTEGER,
  "image_copyright" REAL,
  "image_uploading_user" REAL,
  "image_uploading_user_notes" REAL,
  "twitter_user_id" INTEGER,
  "election_date" TEXT,
  "election_current" INTEGER,
  "party_lists_in_use" INTEGER,
  "party_list_position" INTEGER,
  "old_person_ids" REAL,
  "gss_code" INTEGER,
  "parlparse_id" REAL,
  "theyworkforyou_url" REAL,
  "party_ec_id" TEXT,
  "favourite_biscuits" REAL,
  "cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))
Powered by Datasette · Query took 11.072ms · Data license: CC-BY-SA · Data source: Democracy Club