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
8303 153 Vera Baird     female   8 party:53 Labour Party police:northumbria Police and Crime Commissioner for Northumbria Police   1.0   http://verabaird.info/ https://en.wikipedia.org/wiki/Vera_Baird   https://static-candidates.democracyclub.org.uk/media/images/images/153.png   profile-photo tfgg From her website 2016-05-05 0 0           PP53   0
8304 165 Stewart Golton     male   8 party:90 Liberal Democrats police:west-yorkshire Police and Crime Commissioner for West Yorkshire Police     http://www.libdems.org.uk/stewart_golton http://stewartgolton.mycouncillor.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/553b8d9ce6d2cbcd26e36a2b.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/GoltonStewart 2016-05-05 0 0   8587.0       PP90 Ginger nuts 0
8305 378 Christopher Salmon Mr   male   8 party:52 Conservative and Unionist Party police:dyfed-powys Police and Crime Commissioner for Dyfed-Powys Police       http://www.christophersalmon.org/ https://en.wikipedia.org/wiki/Christopher_Salmon   https://static-candidates.democracyclub.org.uk/media/images/images/378.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   7531.0       PP52   0
8306 411 Victoria Ayling     female   8 party:85 UK Independence Party (UKIP) police:lincolnshire Police and Crime Commissioner for Lincolnshire Police             https://static-candidates.democracyclub.org.uk/media/images/5526940e59bbc5c063445bd3.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-f-k.html 2016-05-05 0 0           PP85   0
8307 778 Matt Wright     male   8 party:52 Conservative and Unionist Party police:north-wales Police and Crime Commissioner for North Wales Police     https://www.conservatives.com/OurTeam/Prospective-Parliamentary-Candidates/Wright-Matt       https://static-candidates.democracyclub.org.uk/media/images/images/778.png   profile-photo huw2 https://www.conservatives.com/OurTeam/Prospective-Parliamentary-Candidates/Wright-Matt 2016-05-05 0 0           PP52   0
8308 917 Michael Jones Mr   male 1976-01-22 8 party:53 Labour Party police:sussex Police and Crime Commissioner for Sussex Police             https://static-candidates.democracyclub.org.uk/media/images/images/917.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   7540;31836       PP53   0
8309 987 Clive Grunshaw     male   8 party:53 Labour Party police:lancashire Police and Crime Commissioner for Lancashire Constabulary   1.0     https://en.wikipedia.org/wiki/Clive_Grunshaw   https://static-candidates.democracyclub.org.uk/media/images/images/987.png   profile-photo gazoakley   2016-05-05 0 0           PP53   0
8310 1020 Stephen Mold     male   8 party:52 Conservative and Unionist Party police:northamptonshire Police and Crime Commissioner for Northamptonshire Police   1.0   http://www.stephenmold.com/ https://en.wikipedia.org/wiki/Stephen_Mold   https://static-candidates.democracyclub.org.uk/media/images/images/1020.png   profile-photo tfgg From Twitter account 2016-05-05 0 0           PP52   0
8311 1031 Daniel Anthony Simpson     male   8 party:733 Lincolnshire Independents Lincolnshire First police:lincolnshire Police and Crime Commissioner for Lincolnshire Police     http://client.attitudecreative.co.uk/pcc2016/ http://danielsimpson.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/1031.png   profile-photo j0e_m official http://www.lincolnshireindependents.org/pcc2016.html 2016-05-05 0 0   19100.0       PP733   0
8312 1068 Richard Younger-Ross     male 1953-01-29 8 party:90 Liberal Democrats police:devon-and-cornwall Police and Crime Commissioner for Devon & Cornwall Police     http://www.libdems.org.uk/richard_younger_ross http://richardyoungerross.org.uk/ https://en.wikipedia.org/wiki/Richard_Younger-Ross https://uk.linkedin.com/pub/richard-younger-ross/4b/9a8/98a https://static-candidates.democracyclub.org.uk/media/images/55322f7d29c5d53959d9e450.png   other andylolz License: Creative Commons Attribution-Share Alike 3.0 Unported license Source: https://en.wikipedia.org/wiki/File:Richard_Younger-Ross_MP_at_Bournemouth.jpg Author: Keith Edkins 2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/11345 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/11345 PP90   0
8313 1194 Patrick Canavan Mr   male 1952-12-10 8 party:53 Labour Party police:dorset Police and Crime Commissioner for Dorset Police             https://static-candidates.democracyclub.org.uk/media/images/550da103d26890164ce32521.png   public-domain PatrickCanavan   2016-05-05 0 0   5415;34914       PP53   0
8314 1204 Linda Jack     female 1955-01-04 8 party:90 Liberal Democrats police:bedfordshire Police and Crime Commissioner for Bedfordshire Police     http://www.libdems.org.uk/linda_jack_pcc       https://static-candidates.democracyclub.org.uk/media/images/551ffd444dbf5aa0774519fc.png   profile-photo humphreycushion   2016-05-05 0 0   7490.0       PP90   0
8315 1206 Jacky Howe     female   8 party:90 Liberal Democrats police:norfolk Police and Crime Commissioner for Norfolk Constabulary     http://www.libdems.org.uk/jacky_howe http://jacky4pcc.org.uk/en/     https://static-candidates.democracyclub.org.uk/media/images/553c9f81e22f98bc5d30fa6d.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/JackyAnnH1 2016-05-05 0 0           PP90   0
8316 1251 Brian Mathew Dr PhD, MA, BA, CEnv, IEng, FRGS male 1960.0 8 party:90 Liberal Democrats police:wiltshire Police and Crime Commissioner for Wiltshire Police     http://www.libdems.org.uk/brian_mathew https://northwiltslibdems.org.uk/en/     https://static-candidates.democracyclub.org.uk/media/images/54cd1ca0668e142f73d3b4c8.png   profile-photo     2016-05-05 0 0   7678.0       PP90   0
8317 1262 Hardyal Dhindsa     male   8 party:53 Labour Party police:derbyshire Police and Crime Commissioner for Derbyshire Constabulary   1.0     https://en.wikipedia.org/wiki/Hardyal_Dhindsa   https://static-candidates.democracyclub.org.uk/media/images/images/1262.png   other goldvote From the Derby City Council Website councillor profile 2016-05-05 0 0   11980;14997       PP53   0
8318 1276 Kevin McKeever     male 1980-10-08 8 party:53 Labour Party police:northamptonshire Police and Crime Commissioner for Northamptonshire Police       http://onyourside.org.uk/ https://en.wikipedia.org/wiki/Kevin_McKeever   https://static-candidates.democracyclub.org.uk/media/images/5515b2d2caf202e56580fb2e.png   copyright-assigned kevinmckeever   2016-05-05 0 0           PP53   0
8319 1297 Julia Mulligan     female   8 party:52 Conservative and Unionist Party police:north-yorkshire Police and Crime Commissioner for North Yorkshire Police   1.0   http://www.juliamulligan.org.uk/ https://en.wikipedia.org/wiki/Julia_Mulligan   https://static-candidates.democracyclub.org.uk/media/images/images/1297.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
8320 1484 Tom Snowdon Mr   male   8 party:90 Liberal Democrats police:derbyshire Police and Crime Commissioner for Derbyshire Constabulary     http://www.libdems.org.uk/tom_snowdon https://chesterfieldlibdems.org.uk/en/     https://static-candidates.democracyclub.org.uk/media/images/5548b5e1e2efb2432db96526.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/tom_snowdon 2016-05-05 0 0   16817.0       PP90   0
8321 2131 Denis Healy Mr   male   8 party:90 Liberal Democrats police:humberside Police and Crime Commissioner for Humberside Police     http://www.libdems.org.uk/denis-healy http://www.libdemsinhullandhessle.org.uk/about_denis_healy     https://static-candidates.democracyclub.org.uk/media/images/54cd1bf7668e142f73d3b4b9.png   profile-photo     2016-05-05 0 0   7586.0       PP90   0
8322 2181 James Blanchard Mr   male 1977.0 8 party:90 Liberal Democrats police:north-yorkshire Police and Crime Commissioner for North Yorkshire Police     http://www.libdems.org.uk/james_blanchard_pcc http://jamesblanchard.lib.dm/     https://static-candidates.democracyclub.org.uk/media/images/553c9e76dcfe1d5b5cf81469.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/jamesblanchard 2016-05-05 0 0   5058.0       PP90   0
8323 2443 Margaret Rowley Cllr Mrs BSc MA MCLIP female   8 party:90 Liberal Democrats police:west-mercia Police and Crime Commissioner for West Mercia Police     http://www.libdems.org.uk/margaret_rowley http://www.midworcslibdems.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/2443.png   profile-photo margaret   2016-05-05 0 0   16938.0       PP90 Plain chocolate hobnob 0
8324 2845 Jonathan Starkey   M.A. (Dist.) male   8 party:85 UK Independence Party (UKIP) police:cheshire Police and Crime Commissioner for Cheshire Constabulary       http://www.ukipepn.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/5522520f328bff5d39338a41.png   profile-photo ukipepn It is the official photograph utilised on campaign literature. 2016-05-05 0 0           PP85   0
8325 2942 Arfon Jones     male   8 party:77 Plaid Cymru - The Party of Wales police:north-wales Police and Crime Commissioner for North Wales Police   1.0   http://arfonjones.cymru/ https://en.wikipedia.org/wiki/Arfon_Jones   https://static-candidates.democracyclub.org.uk/media/images/images/2942.png   other tfgg From his facebook group 2016-05-05 0 0           PP77   0
8326 2952 Alun Michael     male 1943-08-22 8 party:53 Labour Party police:south-wales Police and Crime Commissioner for South Wales Police   1.0     https://en.wikipedia.org/wiki/Alun_Michael   https://static-candidates.democracyclub.org.uk/media/images/images/2952.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/10431 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/10431 PP53   0
8327 3182 James Doyle Cllr   male 1964-10-03 8 party:63 Green Party police:sussex Police and Crime Commissioner for Sussex Police       http://www.jamesdoyle.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5517d30f249b917507bee4ec.png   profile-photo james9   2016-05-05 0 0   7538;33305       PP63   0
8328 3232 Jason Zadrozny     male   8 ynmp-party:2 Independent police:nottinghamshire Police and Crime Commissioner for Nottinghamshire Police     http://www.libdems.org.uk/jason_zadrozny       https://static-candidates.democracyclub.org.uk/media/images/images/3232.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   8771;25730       ynmp-party:2   0
8329 3255 Bob Spink     male 1948-08-01 8 party:85 UK Independence Party (UKIP) police:essex Police and Crime Commissioner for Essex Police       http://backbobspink.co.uk/ https://en.wikipedia.org/wiki/Bob_Spink   https://static-candidates.democracyclub.org.uk/media/images/images/3255.png   profile-photo h2g2bob From facebook campaign https://www.facebook.com/backbobspink/ 2016-05-05 0 0           PP85   0
8330 3767 Chris Briton     male   8 party:63 Green Party police:avon-and-somerset Police and Crime Commissioner for Avon and Somerset Constabulary                       2016-05-05 0 0   10430.0       PP63   0
8331 4206 Matthew Scott Mr   male   8 party:52 Conservative and Unionist Party police:kent Police and Crime Commissioner for Kent Police   1.0 https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Scott_Matthew.aspx http://www.leytonandwanstead.co.uk/ https://en.wikipedia.org/wiki/Matthew_Scott_(police_commissioner) http://uk.linkedin.com/in/matthewscottuk/en https://static-candidates.democracyclub.org.uk/media/images/5481e74ab150e238702c050a.png   profile-photo     2016-05-05 0 0   7521.0       PP52   0
8332 4282 Chris Jones Dr   male   8 party:53 Labour Party police:norfolk Police and Crime Commissioner for Norfolk Constabulary     http://www.labour.org.uk/people/detail/chris-jones http://www.drchrisjones.org/     https://static-candidates.democracyclub.org.uk/media/images/5481e7bdb150e238702c0562.png   profile-photo     2016-05-05 0 0   7597.0       PP53   0
8333 4304 Tristan Osborne Mr   male 1982-11-15 8 party:53 Labour Party police:kent Police and Crime Commissioner for Kent Police     http://www.labour.org.uk/people/detail/tristan-osborne http://www.trisosborne.org.uk/   https://www.linkedin.com/profile/view?id=6419118 https://static-candidates.democracyclub.org.uk/media/images/5481e7d6b150e238702c0577.png   profile-photo     2016-05-05 0 0   7523.0       PP53   0
8334 4305 Chris Vince Mr   male   8 party:53 Labour Party police:essex Police and Crime Commissioner for Essex Police     https://vote.labour.org.uk/christopher-vince     https://www.linkedin.com/in/chris-vince-76371672/ https://static-candidates.democracyclub.org.uk/media/images/images/4305.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1704239983 2016-05-05 0 0   7630.0       PP53 Custard cream 0
8335 4436 Kerry Pollard Mr   male 1944-04-27 8 party:53 Labour Party police:hertfordshire Police and Crime Commissioner for Hertfordshire Constabulary     https://vote.labour.org.uk/kerry-pollard http://www.kerrypollard.co.uk/ https://en.wikipedia.org/wiki/Kerry_Pollard https://www.linkedin.com/in/kerry-pollard-338a637/ https://static-candidates.democracyclub.org.uk/media/images/553a8a553a37ac9054592953.png   profile-photo edent https://twitter.com/kerrypollard_ 2016-05-05 0 0           PP53   0
8336 4466 Daniel Walton     male 1976-08-19 8 party:53 Labour Party police:west-mercia Police and Crime Commissioner for West Mercia Police       http://www.danielwalton.org     https://static-candidates.democracyclub.org.uk/media/images/images/4466.png   public-domain daniel3 It's me and taken by a colleague. 2016-05-05 0 0           PP53   0
8337 4567 Melanie Hurst     female   8 party:85 UK Independence Party (UKIP) police:northumbria Police and Crime Commissioner for Northumbria Police             https://static-candidates.democracyclub.org.uk/media/images/553c975642c427035c8db3e6.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/MelanieHurst9 2016-05-05 0 0           PP85   0
8338 4602 Jonathan Wallace Dr PhD male 1963-11-24 8 party:90 Liberal Democrats police:northumbria Police and Crime Commissioner for Northumbria Police     http://www.libdems.org.uk/jonathan_wallace http://jonathanwallace.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/55159e2c4fb3d15c51926ddb.png   copyright-assigned jonathan5 I am the candidate. This photo was taken on my camera and belongs to me. 2016-05-05 0 0   7692.0       PP90   0
8339 4671 Fran Loi     Male   8 party:85 UK Independence Party (UKIP) police:nottinghamshire Police and Crime Commissioner for Nottinghamshire Police       https://ukipnottingham.org/     https://static-candidates.democracyclub.org.uk/media/images/551ab36de2ac8b7333e6a27e.png   profile-photo Fran   2016-05-05 0 0           PP85   0
8340 4781 Peter Malcolm Cuthbertson     male 1983.0 8 party:52 Conservative and Unionist Party police:durham Police and Crime Commissioner for Durham Constabulary     https://policeandcrimecommissioners-admin.conservativewebsites.org.uk/person/durham-peter-cuthbertson http://www.petercuthbertson.com/     https://static-candidates.democracyclub.org.uk/media/images/images/4781.png   profile-photo tfgg From party profile 2016-05-05 0 0           PP52   0
8341 4845 Marc Jones Mr   male 1972.0 8 party:52 Conservative and Unionist Party police:lincolnshire Police and Crime Commissioner for Lincolnshire Police   1.0   http://www.marcjones.org.uk/ https://en.wikipedia.org/wiki/Marc_Jones_(police_commissioner) https://uk.linkedin.com/in/marcjoneslincoln https://static-candidates.democracyclub.org.uk/media/images/5517cd09249b917507bee4e6.png   profile-photo TimPatmore Facebook profile picture 2016-05-05 0 0   7573.0       PP52   0
8342 4897 Joe Otten     male   8 party:90 Liberal Democrats police:south-yorkshire Police and Crime Commissioner for South Yorkshire Police     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
8343 4992 David Sprason     male 1956-03-01 8 party:85 UK Independence Party (UKIP) police:leicestershire Police and Crime Commissioner for Leicestershire Police       http://ukipleicestershire.org/     https://static-candidates.democracyclub.org.uk/media/images/54e7b07202f716934fefdb7d.png         2016-05-05 0 0   23464.0       PP85   0
8344 5067 Mike Whitehead     male   8 party:85 UK Independence Party (UKIP) police:humberside Police and Crime Commissioner for Humberside Police       http://mikewhiteheadforpcc.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/5067.png   profile-photo RayDuff   2016-05-05 0 0           PP85   0
8345 5072 Paul Kennedy Mr   male   8 party:90 Liberal Democrats police:surrey Police and Crime Commissioner for Surrey Police     http://www.libdems.org.uk/paul-kennedy https://molevalleylibdems.org.uk/en/article/2017/1212686/lib-dem-surge-in-mole-valley     https://static-candidates.democracyclub.org.uk/media/images/553b8e8c81ca637726b503ae.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/PaulKenLD 2016-05-05 0 0   7584;16674       PP90   0
8346 5314 Simon Tobin     Male   8 party:85 UK Independence Party (UKIP) police:suffolk Police and Crime Commissioner for Suffolk Constabulary       http://ukipwaveney.org/     https://static-candidates.democracyclub.org.uk/media/images/551801da249b917507bee545.png   profile-photo ljpfontana https://twitter.com/simontobinukip 2016-05-05 0 0           PP85   0
8347 5471 Graham Roach     male   8 party:90 Liberal Democrats police:lancashire Police and Crime Commissioner for Lancashire Constabulary     http://www.libdems.org.uk/graham_roach     https://uk.linkedin.com/pub/graham-roach/19/8a/796 https://static-candidates.democracyclub.org.uk/media/images/553c2fc162bbab35264e7acc.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/cllr_g_roach 2016-05-05 0 0           PP90   0
8348 5496 Mark Hughes     male 1961-09-23 8 party:85 UK Independence Party (UKIP) police:hertfordshire Police and Crime Commissioner for Hertfordshire Constabulary             https://static-candidates.democracyclub.org.uk/media/images/54f7b071c689026478f43690.png   profile-photo MarkJHughes   2016-05-05 0 0   18717.0       PP85   0
8349 5593 Ian Walker     Male 1958.0 8 party:52 Conservative and Unionist Party police:south-yorkshire Police and Crime Commissioner for South Yorkshire Police     https://policeandcrimecommissioners-admin.conservativewebsites.org.uk/person/south-yorkshire-ian-walker http://www.iangwalker.co.uk/ https://en.wikipedia.org/wiki/Ian_G._Walker   https://static-candidates.democracyclub.org.uk/media/images/54f76a76c689026478f4367d.png   profile-photo JPCarrington Taken from official facebook campaign page here: https://www.facebook.com/fromhallamforhallam/ 2016-05-05 0 0   34951.0       PP52   0
8350 5596 Steve Uncles     Male 1964-03-12 8 party:17 English Democrats police:kent Police and Crime Commissioner for Kent Police       http://steveunclesenglishdemocrats.org/     https://static-candidates.democracyclub.org.uk/media/images/55244e27f0e9e2c82406eba3.png   public-domain gerv Also submitted by Steve Uncles; this one should be OK. 2016-05-05 0 0   1529;5615;7536       PP17   0
8351 5633 Loraine Birchall     female 1968-03-24 8 party:90 Liberal Democrats police:cumbria Police and Crime Commissioner for Cumbria Constabulary     http://www.libdems.org.uk/_loraine_birchall       https://static-candidates.democracyclub.org.uk/media/images/5518407f249b917507bee579.png   profile-photo ljpfontana https://www.facebook.com/loraine.birchall 2016-05-05 0 0   34224.0       PP90   0
8352 5812 David Allen     male   8 party:17 English Democrats police:south-yorkshire Police and Crime Commissioner for South Yorkshire Police             https://static-candidates.democracyclub.org.uk/media/images/5519b490ba7512a07da4793b.png   copyright-assigned steve I am the National Campaign Director for the English Democrats 2016-05-05 0 0           PP17   0
8353 5833 Roy Swales     Male   8 party:85 UK Independence Party (UKIP) police:hampshire Police and Crime Commissioner for Hampshire Constabulary       https://royswales6.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/553aa49034eff6a2551d69dc.png   profile-photo edent https://twitter.com/SwalesRoy 2016-05-05 0 0   7528;34815       PP85   0
8354 5848 Pete Durnell Mr   Male 1963-07-13 8 party:85 UK Independence Party (UKIP) police:west-midlands Police and Crime Commissioner for West Midlands Police     http://www.myukip.com/parliamentary-candidates-t-z.html http://www.petedurnell.com/     https://static-candidates.democracyclub.org.uk/media/images/5534f139b247335574a42e1d.png   profile-photo pete6   2016-05-05 0 0           PP85   0
8355 5866 John Short     Male   8 party:85 UK Independence Party (UKIP) police:wiltshire Police and Crime Commissioner for Wiltshire Police     http://www.ukip-swindon.org.uk/                 2016-05-05 0 0           PP85   0
8356 5884 Howard James Kaye Mr   Male 1963.0 8 party:53 Labour Party police:surrey Police and Crime Commissioner for Surrey Police       http://www.howardkaye.org/     https://static-candidates.democracyclub.org.uk/media/images/553c0bd510284be476aae8bc.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/HKaye_LabourSWS 2016-05-05 0 0   7581.0       PP53   0
8357 5893 Don Jerrard     Male   8 ynmp-party:2 Independent police:hampshire Police and Crime Commissioner for Hampshire Constabulary     http://www.jacparty.org.uk/ http://www.donjerrard4hampshire-pcc.uk     https://static-candidates.democracyclub.org.uk/media/images/images/5893.png   profile-photo JeniT from https://www.choosemypcc.org.uk/candidates/hampshire/don-jerrard/ also used on http://www.jacparty.org.uk/ 2016-05-05 0 0   4853;6219;6330;10296       ynmp-party:2   0
8358 5899 Peter Jewell     Male   8 party:85 UK Independence Party (UKIP) police:west-mercia Police and Crime Commissioner for West Mercia Police       http://www.peterjewell.com/     https://static-candidates.democracyclub.org.uk/media/images/images/5899.png   profile-photo Stockford It was used for his stand for the Police and Crime Commissioner in West Mercia - https://www.choosemypcc.org.uk/candidates/west-mercia/peter-jewell/ 2016-05-05 0 0   27698.0       PP85   0
8359 6236 Des Parkinson     male   8 party:85 UK Independence Party (UKIP) police:dyfed-powys Police and Crime Commissioner for Dyfed-Powys Police     https://ukip.wales/candidate-profile/des-parkinson/ https://ukip.wales/des-parkinson-pcc/     https://static-candidates.democracyclub.org.uk/media/images/images/6236_w3sYiQo.png   profile-photo buchser official UKIP website 2016-05-05 0 0           PP85   0
8360 6238 Simon Wall     male   8 party:85 UK Independence Party (UKIP) police:north-wales Police and Crime Commissioner for North Wales Police     http://www.ukipwales.org.uk/our-branches/4587425490 http://ukip.wales/simon-wall-pcc/     https://static-candidates.democracyclub.org.uk/media/images/5525eeb6413cb4432adffa4e.png   profile-photo JPCarrington Profile picture as featured on official party PPC pages here: http://www.myukip.com/parliamentary-candidates-a-b.html 2016-05-05 0 0           PP85   0
8361 6263 Kevin McNamara Mr   male 1991-02-01 8 party:90 Liberal Democrats police:essex Police and Crime Commissioner for Essex Police     http://www.libdems.org.uk/kevin_mcnamara_pcc http://www.kevinmcnamara.co.uk/   http://uk.linkedin.com/in/kmpmcnamara https://static-candidates.democracyclub.org.uk/media/images/553c9aa3e22f98bc5d30fa5e.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/KevinMcNamaraLD 2016-05-05 0 0           PP90   0
8362 6280 Stuart Yeowart     male   8 party:85 UK Independence Party (UKIP) police:derbyshire Police and Crime Commissioner for Derbyshire Constabulary             https://static-candidates.democracyclub.org.uk/media/images/55268b4f59bbc5c063445b6f.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 0           PP85   0
8363 6293 Rupert Moss-Eccardt Mr   male 1965-06-16 8 party:90 Liberal Democrats police:cambridgeshire Police and Crime Commissioner for Cambridgeshire Constabulary     http://www.libdems.org.uk/rupert_moss_eccardt http://www.rme4pcc.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/6293.png   profile-photo petersteadman http://www.libdems.org.uk/rupert_moss_eccardt - libdem candidate page 2016-05-05 0 0           PP90   0
8364 6345 Stewart Thomas Hay     male   8 party:52 Conservative and Unionist Party police:northumbria Police and Crime Commissioner for Northumbria Police     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Hay_Stewart.aspx       https://static-candidates.democracyclub.org.uk/media/images/553ca04442c427035c8db3f7.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/3147Hay 2016-05-05 0 0   7706.0       PP52   0
8365 6531 John Orrell Howson Prof Cllr   male 1947-05-16 8 party:90 Liberal Democrats police:thames-valley Police and Crime Commissioner for Thames Valley Police     http://www.libdems.org.uk/john-howson https://johnohowson.wordpress.com     https://static-candidates.democracyclub.org.uk/media/images/5525ef70413cb4432adffa57.png   profile-photo JPCarrington On party PPC page: http://www.libdems.org.uk/john_howson 2016-05-05 0 0           PP90 Ginger 0
8366 6619 James Barker     male   8 party:85 UK Independence Party (UKIP) police:lancashire Police and Crime Commissioner for Lancashire Constabulary                       2016-05-05 0 0           PP85   0
8367 6860 Michael Pye     Male   8 party:85 UK Independence Party (UKIP) police:cumbria Police and Crime Commissioner for Cumbria Constabulary             https://static-candidates.democracyclub.org.uk/media/images/55268e3959bbc5c063445b81.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 0           PP85   0
8368 6894 Paul Woodhead Mr MSc, FCIWM male 1970-07-12 8 party:63 Green Party police:staffordshire Police and Crime Commissioner for Staffordshire Police     https://my.greenparty.org.uk/candidates/105872 https://cannockchase.greenparty.org.uk/   https://www.linkedin.com/in/paulewoodhead https://static-candidates.democracyclub.org.uk/media/images/55181ef6249b917507bee55c.png   profile-photo paulewoodhead Ia m the candidate and use this photo for the campaign 2016-05-05 0 0   7566.0       PP63   0
8369 7009 Thérèse Hirst     female 1956.0 8 party:17 English Democrats police:west-yorkshire Police and Crime Commissioner for West Yorkshire Police     https://yorkshireenglishdemocrats.org/bradford-w-therese-hirst/   https://en.wikipedia.org/wiki/Therese_Hirst   https://static-candidates.democracyclub.org.uk/media/images/552cc4cc3d3371cf3592d9c0.png   other steve Candidate prefers this picture (Sorry) - Steve Uncles - English Democrats - Campaign Director 2016-05-05 0 0   7595.0       PP17 All butter ginger biscuit 0
8370 7022 Les Jones Mr   male   8 party:52 Conservative and Unionist Party police:west-midlands Police and Crime Commissioner for West Midlands Police     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Jones_Les.aspx       https://static-candidates.democracyclub.org.uk/media/images/5524a65bf0e9e2c82406ebc9.png   profile-photo TimPatmore PPC profile picture: https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Jones_Les.aspx 2016-05-05 0 0           PP52   0
8371 7471 Judith Woodman Cllr   female   8 party:90 Liberal Democrats police:south-wales Police and Crime Commissioner for South Wales Police     http://www.welshlibdems.wales/judith_woodman                 2016-05-05 0 0           PP90   0
8372 7478 Sue Mountstevens     female 1955.0 8 ynmp-party:2 Independent police:avon-and-somerset Police and Crime Commissioner for Avon and Somerset Constabulary   1.0   http://www.suemountstevens.org/ https://en.wikipedia.org/wiki/Sue_Mountstevens   https://static-candidates.democracyclub.org.uk/media/images/images/7478.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           ynmp-party:2   0
8373 7479 Mark Weston     male   8 party:52 Conservative and Unionist Party police:avon-and-somerset Police and Crime Commissioner for Avon and Somerset Constabulary       http://markweston.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7479.png   profile-photo tfgg From his campaign Facebook https://www.facebook.com/717530348380086/photos/a.719062241560230.1073741825.717530348380086/719062261560228/?type=3&theater 2016-05-05 0 0   10471.0       PP52   0
8374 7480 Kerry Barker     Male   8 party:53 Labour Party police:avon-and-somerset Police and Crime Commissioner for Avon and Somerset Constabulary     http://www.laboursouthwest.org.uk/our_police_and_crime_commissioner_candidates http://www.kerrybarker.org/     https://static-candidates.democracyclub.org.uk/media/images/images/7480.png   profile-photo subutcher http://www.laboursouthwest.org.uk/our_police_and_crime_commissioner_candidates 2016-05-05 0 0           PP53   0
8375 7487 Olly Martins     male 1969-12-17 8 party:53 Labour Party police:bedfordshire Police and Crime Commissioner for Bedfordshire Police       http://www.ollymartins.org/ https://en.wikipedia.org/wiki/Olly_Martins   https://static-candidates.democracyclub.org.uk/media/images/images/7487.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
8376 7488 Kathryn Holloway     female   8 party:52 Conservative and Unionist Party police:bedfordshire Police and Crime Commissioner for Bedfordshire Police   1.0   http://www.kathrynholloway.org.uk/ https://en.wikipedia.org/wiki/Kathryn_Holloway_(police_commissioner)   https://static-candidates.democracyclub.org.uk/media/images/images/7488.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
8377 7493 Toni Bugle     female   8 party:17 English Democrats police:bedfordshire Police and Crime Commissioner for Bedfordshire Police             https://static-candidates.democracyclub.org.uk/media/images/images/7493.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP17   0
8378 7494 Duncan Strachan     male 1954.0 8 party:85 UK Independence Party (UKIP) police:bedfordshire Police and Crime Commissioner for Bedfordshire Police             https://static-candidates.democracyclub.org.uk/media/images/images/7494.png   profile-photo JeniT from choosemypcc page at https://www.choosemypcc.org.uk/candidates/bedfordshire/duncan-anthony-strachan/ 2016-05-05 0 0   28597.0       PP85   0
8379 7495 Jason Ablewhite     male   8 party:52 Conservative and Unionist Party police:cambridgeshire Police and Crime Commissioner for Cambridgeshire Constabulary   1.0     https://en.wikipedia.org/wiki/Jason_Ablewhite   https://static-candidates.democracyclub.org.uk/media/images/images/7495.png   profile-photo phil@philrodgers.co.uk From candidate's "Public Figure" page on Facebook at https://www.facebook.com/JasonAblewhitePCC/ 2016-05-05 0 0   9055.0       PP52   0
8380 7496 Dave Baigent Dr PhD, BA Hons, FHEA, FIFireE male   8 party:53 Labour Party police:cambridgeshire Police and Crime Commissioner for Cambridgeshire Constabulary       http://davebaigent.com/     https://static-candidates.democracyclub.org.uk/media/images/images/7496.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   36177.0       PP53   0
8381 7497 Nick Clarke Mr   male   8 party:85 UK Independence Party (UKIP) police:cambridgeshire Police and Crime Commissioner for Cambridgeshire Constabulary       https://nickclarkecambs.wordpress.com     https://static-candidates.democracyclub.org.uk/media/images/images/7497.png   public-domain nickclarkecambs I am the candidate and own the copyright 2016-05-05 0 0           PP85   0
8382 7513 John Dwyer     male   8 party:52 Conservative and Unionist Party police:cheshire Police and Crime Commissioner for Cheshire Constabulary       http://www.johndwyer.org.uk/ https://en.wikipedia.org/wiki/John_Dwyer_(police_commissioner)   https://static-candidates.democracyclub.org.uk/media/images/images/7513.png   profile-photo chrisspargo It's from his Facebook campaign page: https://www.facebook.com/JohnDwyerforCheshirePCC/ 2016-05-05 0 0           PP52   0
8383 7514 David Keane     male   8 party:53 Labour Party police:cheshire Police and Crime Commissioner for Cheshire Constabulary   1.0   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
8384 7515 Neil Lewis Mr   male 1969.0 8 party:90 Liberal Democrats police:cheshire Police and Crime Commissioner for Cheshire Constabulary       http://www.neillewis.org/     https://static-candidates.democracyclub.org.uk/media/images/images/7515.png   profile-photo chrisspargo It's from his Facebook page: https://www.facebook.com/NeilLewis4CheshirePCC 2016-05-05 0 0           PP90   0
8385 7516 Barry Coppinger     male   8 party:53 Labour Party police:cleveland Police and Crime Commissioner for Cleveland Police   1.0   http://www.coppinger4pcc.org/ https://en.wikipedia.org/wiki/Barry_Coppinger   https://static-candidates.democracyclub.org.uk/media/images/images/7516.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
8386 7517 Matthew Vickers     male   8 party:52 Conservative and Unionist Party police:cleveland Police and Crime Commissioner for Cleveland Police       http://www.mattvickers.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7517.png   profile-photo JeniT photo from Facebook at https://www.facebook.com/matthewvickersforcleveland/ 2016-05-05 0 0           PP52   0
8387 7518 Sultan Alam         8 ynmp-party:2 Independent police:cleveland Police and Crime Commissioner for Cleveland Police       http://www.sultanalam.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7518.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           ynmp-party:2   0
8388 7524 Henry Bolton Mr OBE Male 1963.0 8 party:85 UK Independence Party (UKIP) police:kent Police and Crime Commissioner for Kent Police       http://henrybolton.org/?content=home https://en.wikipedia.org/wiki/Henry_Bolton_(British_politician) https://www.linkedin.com/in/henry-bolton-obe-4b844819 https://static-candidates.democracyclub.org.uk/media/images/images/7524.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP85   0
8389 7535 David Naghi Mr   male   8 party:90 Liberal Democrats police:kent Police and Crime Commissioner for Kent Police     http://www.libdems.org.uk/david_naghi_pcc http://www.davenaghi.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7535.png   profile-photo petersteadman http://www.libdems.org.uk/david_naghi_pcc - libdem candidate page 2016-05-05 0 0           PP90   0
8390 7539 Katy Bourne Mrs   female   8 party:52 Conservative and Unionist Party police:sussex Police and Crime Commissioner for Sussex Police   1.0 http://www.policeandcrimecommissioners.info/person/sussex-katy-bourne http://www.katybourne.com https://en.wikipedia.org/wiki/Katy_Bourne   https://static-candidates.democracyclub.org.uk/media/images/images/7539.png   profile-photo jnicho02   2016-05-05 0 0           PP52   0
8391 7541 James Walsh Dr   male   8 party:90 Liberal Democrats police:sussex Police and Crime Commissioner for Sussex Police                       2016-05-05 0 0           PP90   0
8392 7542 Patrick Lowe     male   8 party:85 UK Independence Party (UKIP) police:sussex Police and Crime Commissioner for Sussex Police             https://static-candidates.democracyclub.org.uk/media/images/images/7542.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   33295.0       PP85   0
8393 7552 Kevin Madge     Male   8 party:53 Labour Party police:dyfed-powys Police and Crime Commissioner for Dyfed-Powys Police             https://static-candidates.democracyclub.org.uk/media/images/images/7552.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   25059.0       PP53   0
8394 7557 John-Paul Campion Mr   male   8 party:52 Conservative and Unionist Party police:west-mercia Police and Crime Commissioner for West Mercia Police   1.0   http://www.campion4westmercia.com/ https://en.wikipedia.org/wiki/John_Campion   https://static-candidates.democracyclub.org.uk/media/images/images/7557.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
8395 7559 Simon Patrick Tipping Mr   Male 1949.0 8 party:53 Labour Party police:nottinghamshire Police and Crime Commissioner for Nottinghamshire Police   1.0 http://www.eastmidslabour.org.uk/paddy_tipping_nottinghamshire   https://en.wikipedia.org/wiki/Paddy_Tipping https://uk.linkedin.com/in/paddy-tipping-89b55344 https://static-candidates.democracyclub.org.uk/media/images/images/7559.png   profile-photo cjsawers http://www.eastmidslabour.org.uk/paddy_tipping_nottinghamshire 2016-05-05 0 0           PP53   0
8396 7562 Tony Harper     Male   8 party:52 Conservative and Unionist Party police:nottinghamshire Police and Crime Commissioner for Nottinghamshire Police       http://www.tonyharper.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/7562_bV5ayLh.png   profile-photo tfgg Photo from his Facebook page. 2016-05-05 0 0           PP52   0
8397 7567 George Adamson Mr   Male   8 party:53 Labour Party police:staffordshire Police and Crime Commissioner for Staffordshire Police     http://www.staffslabour.co.uk/pcc       https://static-candidates.democracyclub.org.uk/media/images/images/7567.png   profile-photo jones   2016-05-05 0 0   39151.0       PP53   0
8398 7568 Matthew Ellis     Male   8 party:52 Conservative and Unionist Party police:staffordshire Police and Crime Commissioner for Staffordshire Police   1.0   http://www.matthewellis.org.uk/ https://en.wikipedia.org/wiki/Matthew_Ellis_(police_commissioner)   https://static-candidates.democracyclub.org.uk/media/images/images/7568.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
8399 7574 Lucinda Preston     female   8 party:53 Labour Party police:lincolnshire Police and Crime Commissioner for Lincolnshire Police             https://static-candidates.democracyclub.org.uk/media/images/images/7574.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   30039.0       PP53   0
8400 7582 David Munro Mr   Male   8 party:52 Conservative and Unionist Party police:surrey Police and Crime Commissioner for Surrey Police   1.0     https://en.wikipedia.org/wiki/David_Munro_(police_commissioner)   https://static-candidates.democracyclub.org.uk/media/images/images/7582.png   profile-photo Cllr_Mark_Brunt This is the official photo of David from his campaign 2016-05-05 0 0           PP52   0
8401 7583 Kevin Barry Hurley Mr TD Male   8 party:1949 Zero Tolerance Policing ex Chief police:surrey Police and Crime Commissioner for Surrey Police         https://en.wikipedia.org/wiki/Kevin_Hurley https://www.linkedin.com/in/kevin-hurley-0357562b https://static-candidates.democracyclub.org.uk/media/images/images/7583.png   profile-photo JeniT image from LinkedIn page https://www.linkedin.com/in/kevin-hurley-0357562b at https://media.licdn.com/media/p/4/000/143/32d/1667205.jpg 2016-05-05 0 0           PP1949   0
8402 7585 Julia Searle     Female   8 party:85 UK Independence Party (UKIP) police:surrey Police and Crime Commissioner for Surrey Police             https://static-candidates.democracyclub.org.uk/media/images/images/7585.png   public-domain Julia4surreypcc   2016-05-05 0 0           PP85   0
8403 7592 Mark Burns-Williamson   OBE Male 1964.0 8 party:53 Labour Party police:west-yorkshire Police and Crime Commissioner for West Yorkshire Police   1.0     https://en.wikipedia.org/wiki/Mark_Burns-Williamson https://www.linkedin.com/in/mark-burns-williamson-bb30592b https://static-candidates.democracyclub.org.uk/media/images/images/7592.png   profile-photo philip2   2016-05-05 0 0           PP53   0
Powered by Datasette · Query took 1.565ms