home / democracyclub

candidates

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

313 rows where election = 38

View and edit SQL

Suggested facets: honorific_prefix, honorific_suffix, gender, party_id, party_name, linkedin_url, image_copyright, parlparse_id, theyworkforyou_url, party_ec_id, favourite_biscuits

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id 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
10526 107 Eileen Baxendale     female 1945-04-16 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000124     http://www.scotlibdems.org.uk/eileen_baxendale               2016-05-05 0 0           PP90   0
10527 140 Paul Wheelhouse     male 1970-06-20 sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000111       http://www.paul-wheelhouse.scot/ https://en.wikipedia.org/wiki/Paul_Wheelhouse   https://static-candidates.democracyclub.org.uk/media/images/images/140.png     Auto imported from Twitter 2016-05-05 0 0           PP102   0
10528 141 John Lamont     male 1976-04-15 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000111   1.0 https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Lamont_John.aspx http://www.johnlamont.org/ http://en.wikipedia.org/wiki/John_Lamont_%28Scottish_politician%29   https://static-candidates.democracyclub.org.uk/media/images/550437b71b7be75c206f17d8.png   ross   2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/14026 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/14026 PP52   0
10529 154 Maurice Golden     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000089     http://www.scottishconservatives.com/people/candidates-2/   https://en.wikipedia.org/wiki/Maurice_Golden   https://static-candidates.democracyclub.org.uk/media/images/images/8099.png   UnionSaltire Used on official campaign page - https://www.facebook.com/319311441526405/photos/a.319312201526329.1073741825.319311441526405/321003498023866/?type=3&theater 2016-05-05 0 0   8099.0       PP52   0
10530 327 Clive Sneddon     male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000082     http://www.libdems.org.uk/clive_sneddon       https://static-candidates.democracyclub.org.uk/media/images/images/327.png   sjorford http://www.libdems.org.uk/clive_sneddon 2016-05-05 0 0           PP90   0
10531 524 Iain McGill     male 1976.0 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000106     https://www.edinburghconservatives.org.uk/people/iain-mcgill http://www.iainmcgill.co.uk/   https://www.linkedin.com/in/iainmcgill/ https://static-candidates.democracyclub.org.uk/media/images/550b5c583676900a02e16436.png   IainMcGill   2016-05-05 0 0           PP52   0
10532 737 Ruth Davidson     female 1978-11-10 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000104   1.0     http://en.wikipedia.org/wiki/Ruth_Davidson   https://static-candidates.democracyclub.org.uk/media/images/images/737.png     Auto imported from Twitter 2016-05-05 0 0   8037.0       PP52   0
10533 839 Fiona O'Donnell Ms   female 1960-01-27 sp.c.2016-05-05 38 party:53 Labour Party gss:S16000114         https://en.wikipedia.org/wiki/Fiona_O'Donnell   https://static-candidates.democracyclub.org.uk/media/images/551a087db989d5e837ae99dd.png   fionaodonnell   2016-05-05 0 0   9165.0   uk.org.publicwhip/person/uk.org.publicwhip/person/24723 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/24723 PP53   0
10534 1388 Katy Gordon     female 1966-01-23 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000145     http://www.westscotlibdems.org.uk/katy http://www.westscotlibdems.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/1388.png   ross3 Photo from https://www.facebook.com/LibDemKaty/ - is an official profile photo for publicity purposes 2016-05-05 0 0           PP90   0
10535 1646 Miles Briggs     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000108     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Briggs_Miles.aspx   https://en.wikipedia.org/wiki/Miles_Briggs   https://static-candidates.democracyclub.org.uk/media/images/5481e72cb150e238702c04f4.png       2016-05-05 0 0           PP52   0
10536 1792 Rod Campbell     male   sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000134                     2016-05-05 0 0           PP102   0
10537 1793 John Mason     male 1957-05-15 sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000121   1.0 http://www.snp.org/john-mason http://www.john-mason.org/ https://en.wikipedia.org/wiki/John_Mason_%28Scottish_politician%29           2016-05-05 0 0           PP102   0
10538 2243 Richard Brodie     male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000097     http://www.scotlibdems.org.uk/richard_brodie       https://static-candidates.democracyclub.org.uk/media/images/5547b311dffdc1c81f66829b.png   andylolz From local party page: http://www.scotlibdems.org.uk/richard_brodie 2016-05-05 0 0   6596.0       PP90   0
10539 2279 Claudia Beamish     female 1952-08-09 sp.c.2016-05-05 38 party:53 Labour Party gss:S16000090     http://www.scottishlabour.org.uk/people/entry/claudia-beamish http://www.claudiabeamish.com/ https://en.wikipedia.org/wiki/Claudia_Beamish   https://static-candidates.democracyclub.org.uk/media/images/images/2279.png     Auto imported from Twitter 2016-05-05 0 0           PP53   0
10540 2329 Elisabeth Mary Wilson Dr   female   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000144     http://www.scotlibdems.org.uk/elisabeth_wilson       https://static-candidates.democracyclub.org.uk/media/images/images/2329_8uEDA0Q.png   elis_wilson   2016-05-05 0 0   6613;34630       PP90   0
10541 2464 Jim McFarlane     male   sp.c.2016-05-05 38 party:804 Trade Unionist and Socialist Coalition gss:S16000099             https://static-candidates.democracyclub.org.uk/media/images/5547961ca57e7ec942ad8e2d.png   andylolz From party PPC page: http://tusc2015.com/jim-mcfarlane-for-dundee-west/ 2016-05-05 0 0           PP804   0
10542 2704 Clare Adamson     female 1967-08-01 sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000133   1.0 http://www.snp.org/clare_adamson   https://en.wikipedia.org/wiki/Clare_Adamson   https://static-candidates.democracyclub.org.uk/media/images/images/2704.png     Auto imported from Twitter 2016-05-05 0 0   7508.0       PP102   0
10543 2713 Annabelle Ewing     female 1960-08-20 sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000092   1.0 http://www.snp.org/annabelle_ewing http://www.snp-annabelle-ewing.org/ https://en.wikipedia.org/wiki/Annabelle_Ewing   https://static-candidates.democracyclub.org.uk/media/images/images/2713.png     Auto imported from Twitter 2016-05-05 0 0           PP102   0
10544 2756 Douglas Ross     male 1983.0 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000132     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ross_Douglas.aspx   https://en.wikipedia.org/wiki/Douglas_Ross_(Scottish_politician)   https://static-candidates.democracyclub.org.uk/media/images/553c0fd4ec0766d3759c0477.png   edent This is the candidate’s twitter profile image, from https://twitter.com/Douglas4Moray 2016-05-05 0 0           PP52   0
10545 2797 Mark McDonald     male 1980-06-07 sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000075   1.0   http://www.markmcdonald.org/ https://en.wikipedia.org/wiki/Mark_McDonald_(politician)   https://static-candidates.democracyclub.org.uk/media/images/images/2797.png     Auto imported from Twitter 2016-05-05 0 0           PP102   0
10546 2801 Peter Anthony Barrett     male 1961.0 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000137     http://www.libdems.org.uk/peter_barrett       https://static-candidates.democracyclub.org.uk/media/images/553bb920a8c0192f732ca8e2.png   edent This is the candidate’s twitter profile image, from https://twitter.com/CllrPeterBarret 2016-05-05 0 0   15334.0       PP90   0
10547 2842 David Wilson     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000139             https://static-candidates.democracyclub.org.uk/media/images/images/2842_MpXRNhZ.png   Jimbo   2016-05-05 0 0           PP52   0
10548 2865 Ross Thomson Cllr   male 1987-09-21 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000076     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Thomson_Ross.aspx http://rossthomson.net/ https://en.wikipedia.org/wiki/Ross_Thomson   https://static-candidates.democracyclub.org.uk/media/images/551896e8249b917507bee58b.png   RossThomson   2016-05-05 0 0           PP52   0
10549 3134 Isabel Nelson     female 1940.0 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000119     http://www.libdems.org.uk/isabel_nelson       https://static-candidates.democracyclub.org.uk/media/images/images/3134.png   buchser http://www.glasgowlibdems.org.uk/isabel_nelson_selected_for_pollok 2016-05-05 0 0   21656.0       PP90   0
10550 3231 Alan Reid     male 1954-08-07 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000083     http://www.scotlibdems.org.uk/alan_reid http://www.alanreid.org/ https://en.wikipedia.org/wiki/Alan_Reid_%28politician%29   https://static-candidates.democracyclub.org.uk/media/images/5525eebf413cb4432adffa4f.png   JPCarrington On central party PPC page: http://www.libdems.org.uk/alan_reid 2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/11185 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/11185 PP90   0
10551 3285 Greg Williams     male   sp.c.2016-05-05 38 party:53 Labour Party gss:S16000075       http://gregwilliamslabour.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/8219.png   JeniT on campaign site at http://gregwilliamslabour.blogspot.co.uk/ 2016-05-05 0 0   8219.0       PP53   0
10552 3288 Dennis Robertson     male 1956-08-14 sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000078     http://www.snp.org/dennis_robertson http://www.dennisrobertsonmsp.net/ https://en.wikipedia.org/wiki/Dennis_Robertson_(politician)   https://static-candidates.democracyclub.org.uk/media/images/images/3288.png     Auto imported from Twitter 2016-05-05 0 0           PP102   0
10553 3468 Jamie Paterson     male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000132     http://www.scotlibdems.org.uk/jamie_paterson       https://static-candidates.democracyclub.org.uk/media/images/images/3468.png   buchser twitter page image 2016-05-05 0 0   34804.0       PP90   0
10554 3560 Colin Beattie     male 1951-10-17 sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000130   1.0   http://www.colinbeattiemsp.org/ https://en.wikipedia.org/wiki/Colin_Beattie   https://static-candidates.democracyclub.org.uk/media/images/images/3560.png     Auto imported from Twitter 2016-05-05 0 0           PP102   0
10555 3638 Jacquie Bell     female 1958-05-21 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000130     http://www.libdems.org.uk/jacqueline_bell       https://static-candidates.democracyclub.org.uk/media/images/5548b5b7c0821aec2c24221c.png   andylolz From party PPC page: http://www.libdems.org.uk/jacqueline_bell 2016-05-05 0 0   5313.0       PP90   0
10556 3653 Willie Rennie     male 1967-09-27 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000134   1.0 http://www.libdems.org.uk/willie_rennie   https://en.wikipedia.org/wiki/Willie_Rennie   https://static-candidates.democracyclub.org.uk/media/images/images/3653.png     Auto imported from Twitter 2016-05-05 0 0           PP90   0
10557 3744 Brian Smith     male   sp.c.2016-05-05 38 party:804 Trade Unionist and Socialist Coalition gss:S16000116             https://static-candidates.democracyclub.org.uk/media/images/5515951c4fb3d15c51926dc3.png   briansmith1969 I am brian smith 2016-05-05 0 0           PP804   0
10558 4033 Charles Dundas     male 1978-07-19 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000080     http://www.libdems.org.uk/charles_dundas       https://static-candidates.democracyclub.org.uk/media/images/550e993c9253711a232cfb92.png   cdundas I am the candidate 2016-05-05 0 0           PP90   0
10559 4075 Graham Simpson     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000101     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Simpson_Graham.aspx http://www.southlanconservatives.org.uk/person/cllr-graham-simpson https://en.wikipedia.org/wiki/Graham_Simpson_(Scottish_politician)   https://static-candidates.democracyclub.org.uk/media/images/55291d88b6a860ed1648be41.png   TimPatmore Twitter profile picture: https://twitter.com/cllrgsimpson 2016-05-05 0 0           PP52   0
10560 4216 Huw Bell   BSc (Hons) Male 1981-04-15 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000134     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Bell_Huw.aspx http://www.huwbell.org/     https://static-candidates.democracyclub.org.uk/media/images/55361ece4eb6352b1643ebc4.png   HuwBell1 I am the candidate and I authorise your use. 2016-05-05 0 0           PP52   0
10561 4246 Alexander Burnett     male 1973-07-30 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000078   1.0 https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Burnett_Alexander.aspx http://www.alexanderburnett.com/ https://en.wikipedia.org/wiki/Alexander_Burnett_(politician)   https://static-candidates.democracyclub.org.uk/media/images/5481e786b150e238702c053c.png       2016-05-05 0 0           PP52   0
10562 4384 Sean Morton     male   sp.c.2016-05-05 38 party:53 Labour Party gss:S16000132     http://www.moraylabour.co.uk/seanmorton/       https://static-candidates.democracyclub.org.uk/media/images/553b9d81a8c0192f732ca8c5.png   edent This is the candidate’s twitter profile image, from https://twitter.com/SeanMortonUK 2016-05-05 0 0   22394.0       PP53   0
10563 4499 Christine Jardine     female 1960.0 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000077     http://www.libdems.org.uk/christine_jardine http://www.christinejardine.com https://en.wikipedia.org/wiki/Christine_Jardine   https://static-candidates.democracyclub.org.uk/media/images/5481e907b150e238702c0623.png       2016-05-05 0 0           PP90   0
10564 4681 Ettie Spencer     female   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000102     http://www.libdems.org.uk/ettie_spencer       https://static-candidates.democracyclub.org.uk/media/images/553c17c1a51642637514d658.png   edent This is the candidate’s twitter profile image, from https://twitter.com/ettiespencer 2016-05-05 0 0           PP90   0
10565 4995 Paul McGarry Mr   male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000101     http://www.libdems.org.uk/paul_mcgarry http://www.central.scot/     https://static-candidates.democracyclub.org.uk/media/images/54cd1c37668e142f73d3b4c0.png       2016-05-05 0 0   7525;21145       PP90   0
10566 5036 Lee Lyons     Male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000087     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Lyons_Lee.aspx http://www.southayrshireconservatives.org.uk/person/lee-lyons-ppc-ayr-carrick-and-cumnock     https://static-candidates.democracyclub.org.uk/media/images/54e1f209438d6af41666ea71.png       2016-05-05 0 0           PP52   0
10567 5041 Finlay Carson     Male 1967-10-18 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000114   1.0 https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Carson_Finlay.aspx http://www.finlaycarson.co.uk/ https://en.wikipedia.org/wiki/Finlay_Carson   https://static-candidates.democracyclub.org.uk/media/images/55159cfd4fb3d15c51926dd5.png   fincarson I am candidate and happy for image to be used 2016-05-05 0 0           PP52   0
10568 5042 James Reekie     Male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000100     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Reekie_James.aspx       https://static-candidates.democracyclub.org.uk/media/images/5524a616f0e9e2c82406ebc6.png   TimPatmore Facebook page profile picture: https://www.facebook.com/James4Dunfermline 2016-05-05 0 0           PP52   0
10569 5044 Gordon Lindhurst     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000107     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Lindhurst_Gordon.aspx   https://en.wikipedia.org/wiki/Gordon_Lindhurst   https://static-candidates.democracyclub.org.uk/media/images/5524a544f0e9e2c82406ebbf.png   TimPatmore PPC profile picture: https://www.facebook.com/862501313779030/photos/a.862503500445478.1073741825.862501313779030/864238230272005/?type=1&theater 2016-05-05 0 0           PP52   0
10570 5045 Alison Harris     female   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000113     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Harris_Alison.aspx   https://en.wikipedia.org/wiki/Alison_Harris   https://static-candidates.democracyclub.org.uk/media/images/55491250928393ab513ec902.png   andylolz From national party PPC page: http://www.scottishconservatives.com/people/candidates-2/ 2016-05-05 0 0           PP52   0
10571 5046 Colin Clark     male 1969-05-20 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000077     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Clark_Colin.aspx http://www.colinclark.org.uk/ https://en.wikipedia.org/wiki/Colin_Clark_(politician)   https://static-candidates.democracyclub.org.uk/media/images/550b5d343676900a02e1643b.png   Gordon2015   2016-05-05 0 0           PP52   0
10572 5047 Dave Dempsey     male 1951-09-18 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000092     http://fifeconservatives.uk/index.php/inverkeithing-dalgety-bay       https://static-candidates.democracyclub.org.uk/media/images/550570d2071d4f1362bc8037.png       2016-05-05 0 0           PP52   0
10573 5048 Edward Mountain     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000125     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Mountain_Edward.aspx   https://en.wikipedia.org/wiki/Edward_Mountain_(politician)   https://static-candidates.democracyclub.org.uk/media/images/553ca160deda58bc5cca66ec.png   edent This is the candidate’s twitter profile image, from https://twitter.com/1edmountain 2016-05-05 0 0           PP52   0
10574 5050 Taylor Muir     Male 1995-07-18 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000141     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Muir_Taylor.aspx       https://static-candidates.democracyclub.org.uk/media/images/553c2e78fc4fe0dc23f26c61.png   edent He's the one on the right :-) https://www.facebook.com/DeltaCh 2016-05-05 0 0           PP52   0
10575 5051 Michelle Ballantyne     female   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000131     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ballantyne_Michelle.aspx       https://static-candidates.democracyclub.org.uk/media/images/55491264928393ab513ec903.png   andylolz From national party PPC page: http://www.scottishconservatives.com/people/candidates-2/ 2016-05-05 0 0   8104.0       PP52   0
10576 5053 Alex Allison     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000090     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Allison_Alex.aspx       https://static-candidates.democracyclub.org.uk/media/images/554911a3fcaae5a24f99b343.png   andylolz From national party PPC page: http://www.scottishconservatives.com/people/candidates-2/ 2016-05-05 0 0           PP52   0
10577 5139 Alexander Stewart     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000088     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Stewart_Alexander.aspx http://www.perthshireconservatives.org.uk/ https://en.wikipedia.org/wiki/Alexander_Stewart_(MSP)   https://static-candidates.democracyclub.org.uk/media/images/5548f7e15639864752d05ba2.png   andylolz From party PPC page: https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Stewart_Alexander 2016-05-05 0 0           PP52   0
10578 5271 Daniel Coleman     male 1995-05-17 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000099     http://www.libdems.org.uk/daniel_coleman http://dundeelibdems.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5504cdeeba680dc746e7d5ce.png       2016-05-05 0 0   5355.0       PP90   0
10579 5352 Jim Halfpenny     male   sp.c.2016-05-05 38 party:804 Trade Unionist and Socialist Coalition gss:S16000139             https://static-candidates.democracyclub.org.uk/media/images/551a88d1e2ac8b7333e6a261.png   matt3 www.facebook.com/TUSCRen 2016-05-05 0 0           PP804   0
10580 5365 Craig Duncan Mr   male 1962.0 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000098     http://www.libdems.org.uk/craig_duncan http://dundeelibdems.org.uk/en/   https://www.linkedin.com/pub/craig-duncan/54/3a3/3b5 https://static-candidates.democracyclub.org.uk/media/images/550a97af3676900a02e1642e.png   fraser I am his election agent - photo also used at https://twitter.com/duncandundee 2016-05-05 0 0   7693.0       PP90   0
10581 5521 David Evans Mr   male 1992-03-07 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000085     http://www.scotlibdems.org.uk/david_evans http://banffandbuchanlibdems.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/5521_6XFF9O6.png   DE4B+BC I am the candidate and I own this photo. 2016-05-05 0 0   8249.0       PP90   0
10582 5522 Bill Bowman     male 1950-05-30 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000098     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Bowman_Bill.aspx     https://uk.linkedin.com/in/billabowman https://static-candidates.democracyclub.org.uk/media/images/55224f3a328bff5d39338a36.png   ljpfontana https://twitter.com/bbuch2 2016-05-05 0 0           PP52   0
10583 5896 Kyle Thornton Mr   male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000116     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Thornton_Kyle.aspx     http://uk.linkedin.com/pub/kyle-thornton/46/104/684/en https://static-candidates.democracyclub.org.uk/media/images/553ba433b9c95afe74c5d326.png   edent This is the candidate’s twitter profile image, from https://twitter.com/kyleakthornton 2016-05-05 0 0   7638.0       PP52   0
10584 5901 Nicola Ross     female   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000099     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ross_Nicola.aspx       https://static-candidates.democracyclub.org.uk/media/images/5524a62df0e9e2c82406ebc7.png   TimPatmore PPC profile picture: https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ross_Nicola.aspx 2016-05-05 0 0           PP52   0
10585 6005 Andy Morrison     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000146     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Morrison_Andy.aspx     http://uk.linkedin.com/in/andrewemorrison/en https://static-candidates.democracyclub.org.uk/media/images/553c9630deda58bc5cca66df.png   edent https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Morrison_Andy.aspx 2016-05-05 0 0           PP52   0
10586 6009 Annie Wells     female   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000120     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Wells_Carol_Ann.aspx   https://en.wikipedia.org/wiki/Annie_Wells_(politician) http://uk.linkedin.com/pub/annie-wells/a5/b87/61/en https://static-candidates.democracyclub.org.uk/media/images/5517ccac249b917507bee4e3.png   TimPatmore Facebook page picture 2016-05-05 0 0           PP52   0
10587 6149 John Anderson     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000118     https://www.scottishbordersconservatives.org.uk/people/john-anderson http://www.votejohnanderson.com/     https://static-candidates.democracyclub.org.uk/media/images/5549116fe5ee37a15064546f.png   andylolz From national party PPC page: http://www.scottishconservatives.com/people/candidates-2/ 2016-05-05 0 0           PP52   0
10588 6172 Jamie Cocozza     male   sp.c.2016-05-05 38 party:804 Trade Unionist and Socialist Coalition gss:S16000121       http://www.tusc.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/552ff9ec7fce6de164f2fdf5.png   astrophell Photo from Facebook page and leaflet 2016-05-05 0 0   5351;6199       PP804   0
10589 6298 Dan Farthing Mr   Male 1977-06-22 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000128     http://www.edinburghlibdems.org/dan http://www.libdemdan.com/   https://uk.linkedin.com/in/dan-farthing-sykes-b0251215 https://static-candidates.democracyclub.org.uk/media/images/5525f643413cb4432adffa79.png   dan3 It is on the candidates website https://libdemdan.files.wordpress.com/2015/02/dan-official.jpg 2016-05-05 0 0           PP90   0
10590 6300 Euan Davidson     male 1994-07-07 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000081     http://www.scotlibdems.org.uk/euan_davidson       https://static-candidates.democracyclub.org.uk/media/images/551afd8c13eb34c82843cb3a.png   JPCarrington Is candidate's twitter profile picture: https://twitter.com/euandavidson 2016-05-05 0 0   8248.0       PP90   0
10591 6302 James Harrison     male 1990-03-03 sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000118     http://www.libdems.org.uk/james_harrison     http://uk.linkedin.com/pub/james-harrison/57/767/757/en https://static-candidates.democracyclub.org.uk/media/images/5517f357249b917507bee508.png   JamesWHarrison This is a campaign photo which is intended to be used for the election campaign in as many areas as possible. 2016-05-05 0 0   8357.0       PP90   0
10592 6304 Martin Veart     male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000106     http://www.scotlibdems.org.uk/martinveart http://martinveart.blogspot.co.uk/   https://www.linkedin.com/in/martin-veart-8a988047/ https://static-candidates.democracyclub.org.uk/media/images/553bbc54b9c95afe74c5d33a.png   edent This is the candidate’s twitter profile image, from https://twitter.com/Martin_Veart 2016-05-05 0 0           PP90   0
10593 6353 Jamie Greene     male 1980-03-19 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000094     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Greene_Jamie.aspx http://www.northayrshireconservatives.org.uk/ https://en.wikipedia.org/wiki/Jamie_Greene   https://static-candidates.democracyclub.org.uk/media/images/images/6353.png     Auto imported from Twitter 2016-05-05 0 0           PP52   0
10594 6444 Danus Skene     Male   sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000142     http://www.snp.org/danus_skene http://danusskenesnp.org/ https://en.wikipedia.org/wiki/Danus_Skene   https://static-candidates.democracyclub.org.uk/media/images/553bb04610284be476aae8a0.png   edent This is the candidate’s twitter profile image, from https://twitter.com/DanusSkene 2016-05-05 0 0           PP102   0
10595 6492 Brian Whittle     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000126     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Whittle_Brian.aspx   https://en.wikipedia.org/wiki/Brian_Whittle   https://static-candidates.democracyclub.org.uk/media/images/553c9c59e22f98bc5d30fa62.png   edent This is the candidate’s twitter profile image, from https://twitter.com/brianwhittle 2016-05-05 0 0           PP52   0
10596 6493 Sandy Batho     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000109     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Batho_Sandy.aspx       https://static-candidates.democracyclub.org.uk/media/images/553ca17de22f98bc5d30fa72.png   edent This is the candidate’s twitter profile image, from https://twitter.com/SandyBatho 2016-05-05 0 0           PP52   0
10597 6501 Meghan Gallacher Miss   female 1992-01-17 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000133     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Gallacher_Meghan.aspx       https://static-candidates.democracyclub.org.uk/media/images/551b36ea13eb34c82843cb4d.png   TimPatmore From Scottish Conservatives website. 2016-05-05 0 0   7510.0       PP52   0
10598 6548 Ruby Kirkwood     female   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000095     http://www.ayrshirelibdems.org.uk/local-party/ruby-kirkwood       https://static-candidates.democracyclub.org.uk/media/images/5526959859bbc5c063445be6.png   lumisota Photo from party page (http://www.ayrshirelibdems.org.uk/local-party/ruby-kirkwood) 2016-05-05 0 0           PP90   0
10599 6565 Alex Johnstone   MSP male 1961-07-31 sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000081     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Johnstone_Alex_MSP.aspx   https://en.wikipedia.org/wiki/Alex_Johnstone   https://static-candidates.democracyclub.org.uk/media/images/54fdeee11ccf185f0d8cc4c9.png   alexjohnstone61   2016-05-05 0 0   2593.0   uk.org.publicwhip/person/uk.org.publicwhip/person/14020 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/14020 PP52   0
10600 6569 Eric Holford     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000079     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Holford_Eric.aspx       https://static-candidates.democracyclub.org.uk/media/images/5525ee76413cb4432adffa48.png   JPCarrington As on official party PPC page here: http://www.scottishconservatives.com/people/candidates-2/ 2016-05-05 0 0           PP52   0
10601 6598 John Duncan     Male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000103     http://www.scotlibdems.org.uk/john_duncan       https://static-candidates.democracyclub.org.uk/media/images/5547b322f0745ae61e5c2793.png   andylolz From local party page: http://www.scotlibdems.org.uk/john_duncan 2016-05-05 0 0   13070.0       PP90   0
10602 6599 Andrew Metcalf Mr   Male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000114     http://www.libdems.org.uk/andrew_metcalf       https://static-candidates.democracyclub.org.uk/media/images/5548c2d2e2efb2432db96528.png   andylolz From party PPC page: http://www.libdems.org.uk/andrew_metcalf 2016-05-05 0 0   10988.0       PP90   0
10603 6605 Jane Ann Liston     Female   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000129     http://www.libdems.org.uk/jane_liston       https://static-candidates.democracyclub.org.uk/media/images/5548c308e2efb2432db9652a.png   andylolz From party PPC page: http://www.libdems.org.uk/jane_liston 2016-05-05 0 0           PP90   0
10604 6606 Rod Ackland     Male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000139     http://www.scotlibdems.org.uk/rod_ackland       https://static-candidates.democracyclub.org.uk/media/images/images/6606.png   sjorford http://www.scotlibdems.org.uk/rod_ackland 2016-05-05 0 0   3499.0       PP90   0
10605 6607 Emma Farthing-Sykes     Female   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000107     http://www.libdems.org.uk/emma_farthing-sykes     https://www.linkedin.com/in/emma-farthing-sykes-98236527/ https://static-candidates.democracyclub.org.uk/media/images/553c9d0b42c427035c8db3ee.png   edent This is the candidate’s twitter profile image, from https://twitter.com/emasykes 2016-05-05 0 0   8280;21084       PP90   0
10606 6612 Eileen McCartin     Female   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000136     http://www.scotlibdems.org.uk/eileen_mccartin       https://static-candidates.democracyclub.org.uk/media/images/images/6612.png   griff7023 Taken from her official Lib Dem candidate page (note: they have her name wrong but pic checks out compared to Renfrewshire Council and local news articles) - http://www.libdems.org.uk/eileen-mccartin 2016-05-05 0 0   6611.0       PP90   0
10607 6614 Aileen Morton Cllr   Female   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000096     http://www.libdems.org.uk/aileen_morton     https://uk.linkedin.com/pub/aileen-morton/7a/967/431 https://static-candidates.democracyclub.org.uk/media/images/54fc9e3009c0bb66180a629c.png   jack   2016-05-05 0 0           PP90   0
10608 6651 Scott Nicholson     male   sp.c.2016-05-05 38 party:53 Labour Party gss:S16000138             https://static-candidates.democracyclub.org.uk/media/images/553b9f79ec0766d3759c0445.png   edent This is the candidate’s twitter profile image, from https://twitter.com/scott993 2016-05-05 0 0           PP53   0
10609 6652 John Watson     male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000123     http://www.libdems.org.uk/john_watson http://www.inverclydelibdems.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/5547b1e8da8374e520fa5d4d.png   andylolz From party PPC page: http://www.libdems.org.uk/john_watson 2016-05-05 0 0   13069.0       PP90   0
10610 6666 Maurice Corry     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000096     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Corry_Maurice.aspx   https://en.wikipedia.org/wiki/Maurice_Corry   https://static-candidates.democracyclub.org.uk/media/images/551ce6a0209513973bc512c1.png   syqul http://www.argyll-conservatives.org/sites/www.argyll-conservatives.org/files/imagecache/news_small/110strtcrop02artsta.jpg Used on Maurice Corry's profile on the Argyll Conservatives website: http://www.argyll-conservatives.org/person/maurice-corry 2016-05-05 0 0           PP52   0
10611 6731 Gerry McGarvey     male 1962-07-13 sp.c.2016-05-05 38 party:53 Labour Party gss:S16000135       http://www.orkneylabour.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5501a38c551f41c939045331.png   gerry   2016-05-05 0 0           PP53   0
10612 6732 John Cormack     male   sp.c.2016-05-05 38 party:2893 Christian Party "Proclaiming Christ's Lordship" gss:S16000110             https://static-candidates.democracyclub.org.uk/media/images/553a198b10534e264e17b376.png   edent http://www.ukchristianparty.org/candidates-for-general-election.html 2016-05-05 0 0           PP2893   0
10613 6752 Alex Stewart-Clark mr   male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000129     https://www.wandsworthconservatives.co.uk/latchmere http://www.stewart-clark.com/   https://www.linkedin.com/in/alexander-stewart-clark-b30b3a6a/ https://static-candidates.democracyclub.org.uk/media/images/552ba71562eb6fa83a5483ae.png   mark It's the profile photo currently being used here https://twitter.com/StewartClark_ 2016-05-05 0 0   9223.0       PP52   0
10614 6816 Donald Cameron     Male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000083     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Cameron_Donald.aspx   https://en.wikipedia.org/wiki/Donald_Cameron_(Scottish_politician)   https://static-candidates.democracyclub.org.uk/media/images/553badae10284be476aae89d.png   edent This is the candidate’s twitter profile image, from https://twitter.com/DAJCameron 2016-05-05 0 0   1922.0       PP52   0
10615 6962 James Douglas Speirs     Male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000115     http://www.libdems.org.uk/james_speirs       https://static-candidates.democracyclub.org.uk/media/images/images/8333.png   buchser official party website 2016-05-05 0 0   8333.0       PP90   0
10616 7361 Robert Simpson     male   sp.c.2016-05-05 38 party:90 Liberal Democrats gss:S16000084     http://www.scotlibdems.org.uk/robert_simpson       https://static-candidates.democracyclub.org.uk/media/images/5542b6584fa35c463ab98f61.png   dunnid http://www.scotlibdems.org.uk/robert_simpson 2016-05-05 0 0           PP90   0
10617 7449 Patrick Harvie     male 1973-05-01 sp.c.2016-05-05 38 party:130 Scottish Green Party gss:S16000117       http://www.patrickharviemsp.com/ https://en.wikipedia.org/wiki/Patrick_Harvie   https://static-candidates.democracyclub.org.uk/media/images/images/7449.png   vclaw   2016-05-05 0 0           PP130   0
10618 7451 Andrew Polson     male   sp.c.2016-05-05 38 party:52 Conservative and Unionist Party gss:S16000145     http://www.scottishconservatives.com/people/candidates-2/       https://static-candidates.democracyclub.org.uk/media/images/images/7451.png   UnionSaltire Source: https://www.facebook.com/AndrewPolsonForEastDunbartonshire I am a member of Andrew's campaign team and he had approved use of this image. 2016-05-05 0 0   5260.0       PP52   0
10619 7482 John Wilson     male 1956-11-28 sp.c.2016-05-05 38 party:130 Scottish Green Party gss:S16000091     https://greens.scot/region/central-scotland http://www.johnwilsonmsp.com/ https://en.wikipedia.org/wiki/John_Wilson_(Scottish_politician)   https://static-candidates.democracyclub.org.uk/media/images/images/7482.png     Auto imported from Twitter 2016-05-05 0 0           PP130   0
10620 7483 Alison Johnstone   MSP female 1965-10-11 sp.c.2016-05-05 38 party:130 Scottish Green Party gss:S16000104     https://greens.scot/region/lothian   https://en.wikipedia.org/wiki/Alison_Johnstone   https://static-candidates.democracyclub.org.uk/media/images/images/7483.png     Auto imported from Twitter 2016-05-05 0 0           PP130   0
10621 7491 Jackie Baillie     female 1964-01-15 sp.c.2016-05-05 38 party:53 Labour Party gss:S16000096   1.0 http://www.scottishlabour.org.uk/people/entry/jackie-baillie   https://en.wikipedia.org/wiki/Jackie_Baillie   https://static-candidates.democracyclub.org.uk/media/images/images/7491.png   syqul Candidate's public Facebook profile picture at https://www.facebook.com/jackie.baillie/ 2016-05-05 0 0           PP53   0
10622 7492 Neil Bibby     male 1983-09-06 sp.c.2016-05-05 38 party:53 Labour Party gss:S16000136     http://www.scottishlabour.org.uk/people/entry/neil-bibby   https://en.wikipedia.org/wiki/Neil_Bibby   https://static-candidates.democracyclub.org.uk/media/images/images/7492.png     Auto imported from Twitter 2016-05-05 0 0           PP53   0
10623 7498 Gail Robertson     female   sp.c.2016-05-05 38 party:102 Scottish National Party (SNP) gss:S16000096     http://www.snp.org/gail_robertson       https://static-candidates.democracyclub.org.uk/media/images/images/7498.png   syqul Candidate's public profile on their facebook campaign page at https://www.facebook.com/GailforHolyrood. 2016-05-05 0 0           PP102   0
10624 7499 Andrew Muir     male   sp.c.2016-05-05 38 ynmp-party:2 Independent gss:S16000096             https://static-candidates.democracyclub.org.uk/media/images/images/7499.png     Auto imported from Twitter 2016-05-05 0 0           ynmp-party:2   0
10625 7509 John Pentland     male   sp.c.2016-05-05 38 party:53 Labour Party gss:S16000133     http://www.scottishlabour.org.uk/people/entry/john-pentland http://johnpentland.org/ https://en.wikipedia.org/wiki/John_Pentland           2016-05-05 0 0           PP53   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 9.992ms · Data license: CC-BY-SA · Data source: Democracy Club