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
10526 107 Eileen Baxendale     female 1945-04-16 38 party:90 Liberal Democrats gss:S16000124 Hamilton, Larkhall and Stonehouse     http://www.scotlibdems.org.uk/eileen_baxendale                 2016-05-05 0 0           PP90   0
10527 140 Paul Wheelhouse     male 1970-06-20 38 party:102 Scottish National Party (SNP) gss:S16000111 Ettrick, Roxburgh and Berwickshire       http://www.paul-wheelhouse.scot/ https://en.wikipedia.org/wiki/Paul_Wheelhouse   https://static-candidates.democracyclub.org.uk/media/images/images/140.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP102   0
10528 141 John Lamont     male 1976-04-15 38 party:52 Conservative and Unionist Party gss:S16000111 Ettrick, Roxburgh and Berwickshire   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   copyright-assigned 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   38 party:52 Conservative and Unionist Party gss:S16000089 Clydebank and Milngavie     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   profile-photo 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   38 party:90 Liberal Democrats gss:S16000082 Angus South     http://www.libdems.org.uk/clive_sneddon       https://static-candidates.democracyclub.org.uk/media/images/images/327.png   profile-photo sjorford http://www.libdems.org.uk/clive_sneddon 2016-05-05 0 0           PP90   0
10531 524 Iain McGill     male 1976.0 38 party:52 Conservative and Unionist Party gss:S16000106 Edinburgh Northern and Leith     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   copyright-assigned IainMcGill   2016-05-05 0 0           PP52   0
10532 737 Ruth Davidson     female 1978-11-10 38 party:52 Conservative and Unionist Party gss:S16000104 Edinburgh Central   1.0     http://en.wikipedia.org/wiki/Ruth_Davidson   https://static-candidates.democracyclub.org.uk/media/images/images/737.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   8037.0       PP52   0
10533 839 Fiona O'Donnell Ms   female 1960-01-27 38 party:53 Labour Party gss:S16000114 Galloway and West Dumfries         https://en.wikipedia.org/wiki/Fiona_O'Donnell   https://static-candidates.democracyclub.org.uk/media/images/551a087db989d5e837ae99dd.png   copyright-assigned 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 38 party:90 Liberal Democrats gss:S16000145 Strathkelvin and Bearsden     http://www.westscotlibdems.org.uk/katy http://www.westscotlibdems.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/1388.png   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000108 Edinburgh Southern     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   profile-photo     2016-05-05 0 0           PP52   0
10536 1792 Rod Campbell     male   38 party:102 Scottish National Party (SNP) gss:S16000134 North East Fife                       2016-05-05 0 0           PP102   0
10537 1793 John Mason     male 1957-05-15 38 party:102 Scottish National Party (SNP) gss:S16000121 Glasgow Shettleston   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   38 party:90 Liberal Democrats gss:S16000097 Dumfriesshire     http://www.scotlibdems.org.uk/richard_brodie       https://static-candidates.democracyclub.org.uk/media/images/5547b311dffdc1c81f66829b.png   other 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 38 party:53 Labour Party gss:S16000090 Clydesdale     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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
10540 2329 Elisabeth Mary Wilson Dr   female   38 party:90 Liberal Democrats gss:S16000144 Stirling     http://www.scotlibdems.org.uk/elisabeth_wilson       https://static-candidates.democracyclub.org.uk/media/images/images/2329_8uEDA0Q.png   copyright-assigned elis_wilson   2016-05-05 0 0   6613;34630       PP90   0
10541 2464 Jim McFarlane     male   38 party:804 Trade Unionist and Socialist Coalition gss:S16000099 Dundee City West             https://static-candidates.democracyclub.org.uk/media/images/5547961ca57e7ec942ad8e2d.png   profile-photo 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 38 party:102 Scottish National Party (SNP) gss:S16000133 Motherwell and Wishaw   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   profile-photo   Auto imported from Twitter 2016-05-05 0 0   7508.0       PP102   0
10543 2713 Annabelle Ewing     female 1960-08-20 38 party:102 Scottish National Party (SNP) gss:S16000092 Cowdenbeath   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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP102   0
10544 2756 Douglas Ross     male 1983.0 38 party:52 Conservative and Unionist Party gss:S16000132 Moray     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   profile-photo 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 38 party:102 Scottish National Party (SNP) gss:S16000075 Aberdeen Donside   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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP102   0
10546 2801 Peter Anthony Barrett     male 1961.0 38 party:90 Liberal Democrats gss:S16000137 Perthshire North     http://www.libdems.org.uk/peter_barrett       https://static-candidates.democracyclub.org.uk/media/images/553bb920a8c0192f732ca8e2.png   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000139 Renfrewshire North and West             https://static-candidates.democracyclub.org.uk/media/images/images/2842_MpXRNhZ.png   public-domain Jimbo   2016-05-05 0 0           PP52   0
10548 2865 Ross Thomson Cllr   male 1987-09-21 38 party:52 Conservative and Unionist Party gss:S16000076 Aberdeen South and North Kincardine     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   public-domain RossThomson   2016-05-05 0 0           PP52   0
10549 3134 Isabel Nelson     female 1940.0 38 party:90 Liberal Democrats gss:S16000119 Glasgow Pollok     http://www.libdems.org.uk/isabel_nelson       https://static-candidates.democracyclub.org.uk/media/images/images/3134.png   profile-photo 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 38 party:90 Liberal Democrats gss:S16000083 Argyll and Bute     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   profile-photo 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   38 party:53 Labour Party gss:S16000075 Aberdeen Donside       http://gregwilliamslabour.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/8219.png   profile-photo 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 38 party:102 Scottish National Party (SNP) gss:S16000078 Aberdeenshire West     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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP102   0
10553 3468 Jamie Paterson     male   38 party:90 Liberal Democrats gss:S16000132 Moray     http://www.scotlibdems.org.uk/jamie_paterson       https://static-candidates.democracyclub.org.uk/media/images/images/3468.png   profile-photo buchser twitter page image 2016-05-05 0 0   34804.0       PP90   0
10554 3560 Colin Beattie     male 1951-10-17 38 party:102 Scottish National Party (SNP) gss:S16000130 Midlothian North and Musselburgh   1.0   http://www.colinbeattiemsp.org/ https://en.wikipedia.org/wiki/Colin_Beattie   https://static-candidates.democracyclub.org.uk/media/images/images/3560.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP102   0
10555 3638 Jacquie Bell     female 1958-05-21 38 party:90 Liberal Democrats gss:S16000130 Midlothian North and Musselburgh     http://www.libdems.org.uk/jacqueline_bell       https://static-candidates.democracyclub.org.uk/media/images/5548b5b7c0821aec2c24221c.png   profile-photo 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 38 party:90 Liberal Democrats gss:S16000134 North East Fife   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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
10557 3744 Brian Smith     male   38 party:804 Trade Unionist and Socialist Coalition gss:S16000116 Glasgow Cathcart             https://static-candidates.democracyclub.org.uk/media/images/5515951c4fb3d15c51926dc3.png   public-domain briansmith1969 I am brian smith 2016-05-05 0 0           PP804   0
10558 4033 Charles Dundas     male 1978-07-19 38 party:90 Liberal Democrats gss:S16000080 Almond Valley     http://www.libdems.org.uk/charles_dundas       https://static-candidates.democracyclub.org.uk/media/images/550e993c9253711a232cfb92.png   copyright-assigned cdundas I am the candidate 2016-05-05 0 0           PP90   0
10559 4075 Graham Simpson     male   38 party:52 Conservative and Unionist Party gss:S16000101 East Kilbride     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   profile-photo 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 38 party:52 Conservative and Unionist Party gss:S16000134 North East Fife     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   public-domain 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 38 party:52 Conservative and Unionist Party gss:S16000078 Aberdeenshire West   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   profile-photo     2016-05-05 0 0           PP52   0
10562 4384 Sean Morton     male   38 party:53 Labour Party gss:S16000132 Moray     http://www.moraylabour.co.uk/seanmorton/       https://static-candidates.democracyclub.org.uk/media/images/553b9d81a8c0192f732ca8c5.png   profile-photo 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 38 party:90 Liberal Democrats gss:S16000077 Aberdeenshire East     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   profile-photo     2016-05-05 0 0           PP90   0
10564 4681 Ettie Spencer     female   38 party:90 Liberal Democrats gss:S16000102 East Lothian     http://www.libdems.org.uk/ettie_spencer       https://static-candidates.democracyclub.org.uk/media/images/553c17c1a51642637514d658.png   profile-photo 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   38 party:90 Liberal Democrats gss:S16000101 East Kilbride     http://www.libdems.org.uk/paul_mcgarry http://www.central.scot/     https://static-candidates.democracyclub.org.uk/media/images/54cd1c37668e142f73d3b4c0.png   profile-photo     2016-05-05 0 0   7525;21145       PP90   0
10566 5036 Lee Lyons     Male   38 party:52 Conservative and Unionist Party gss:S16000087 Carrick, Cumnock and Doon Valley     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 38 party:52 Conservative and Unionist Party gss:S16000114 Galloway and West Dumfries   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   profile-photo fincarson I am candidate and happy for image to be used 2016-05-05 0 0           PP52   0
10568 5042 James Reekie     Male   38 party:52 Conservative and Unionist Party gss:S16000100 Dunfermline     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Reekie_James.aspx       https://static-candidates.democracyclub.org.uk/media/images/5524a616f0e9e2c82406ebc6.png   profile-photo TimPatmore Facebook page profile picture: https://www.facebook.com/James4Dunfermline 2016-05-05 0 0           PP52   0
10569 5044 Gordon Lindhurst     male   38 party:52 Conservative and Unionist Party gss:S16000107 Edinburgh Pentlands     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   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000113 Falkirk West     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   profile-photo 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 38 party:52 Conservative and Unionist Party gss:S16000077 Aberdeenshire East     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   profile-photo Gordon2015   2016-05-05 0 0           PP52   0
10572 5047 Dave Dempsey     male 1951-09-18 38 party:52 Conservative and Unionist Party gss:S16000092 Cowdenbeath     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   38 party:52 Conservative and Unionist Party gss:S16000125 Inverness and Nairn     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   profile-photo 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 38 party:52 Conservative and Unionist Party gss:S16000141 Rutherglen     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Muir_Taylor.aspx       https://static-candidates.democracyclub.org.uk/media/images/553c2e78fc4fe0dc23f26c61.png   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000131 Midlothian South, Tweeddale and Lauderdale     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ballantyne_Michelle.aspx       https://static-candidates.democracyclub.org.uk/media/images/55491264928393ab513ec903.png   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000090 Clydesdale     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Allison_Alex.aspx       https://static-candidates.democracyclub.org.uk/media/images/554911a3fcaae5a24f99b343.png   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000088 Clackmannanshire and Dunblane     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   profile-photo 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 38 party:90 Liberal Democrats gss:S16000099 Dundee City West     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   38 party:804 Trade Unionist and Socialist Coalition gss:S16000139 Renfrewshire North and West             https://static-candidates.democracyclub.org.uk/media/images/551a88d1e2ac8b7333e6a261.png   profile-photo matt3 www.facebook.com/TUSCRen 2016-05-05 0 0           PP804   0
10580 5365 Craig Duncan Mr   male 1962.0 38 party:90 Liberal Democrats gss:S16000098 Dundee City East     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   profile-photo 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 38 party:90 Liberal Democrats gss:S16000085 Banffshire and Buchan Coast     http://www.scotlibdems.org.uk/david_evans http://banffandbuchanlibdems.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/5521_6XFF9O6.png   profile-photo 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 38 party:52 Conservative and Unionist Party gss:S16000098 Dundee City East     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   profile-photo ljpfontana https://twitter.com/bbuch2 2016-05-05 0 0           PP52   0
10583 5896 Kyle Thornton Mr   male   38 party:52 Conservative and Unionist Party gss:S16000116 Glasgow Cathcart     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   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000099 Dundee City West     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ross_Nicola.aspx       https://static-candidates.democracyclub.org.uk/media/images/5524a62df0e9e2c82406ebc7.png   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000146 Uddingston and Bellshill     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   profile-photo edent https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Morrison_Andy.aspx 2016-05-05 0 0           PP52   0
10586 6009 Annie Wells     female   38 party:52 Conservative and Unionist Party gss:S16000120 Glasgow Provan     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   profile-photo TimPatmore Facebook page picture 2016-05-05 0 0           PP52   0
10587 6149 John Anderson     male   38 party:52 Conservative and Unionist Party gss:S16000118 Glasgow Maryhill and Springburn     https://www.scottishbordersconservatives.org.uk/people/john-anderson http://www.votejohnanderson.com/     https://static-candidates.democracyclub.org.uk/media/images/5549116fe5ee37a15064546f.png   profile-photo 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   38 party:804 Trade Unionist and Socialist Coalition gss:S16000121 Glasgow Shettleston       http://www.tusc.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/552ff9ec7fce6de164f2fdf5.png   profile-photo 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 38 party:90 Liberal Democrats gss:S16000128 Linlithgow     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   profile-photo 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 38 party:90 Liberal Democrats gss:S16000081 Angus North and Mearns     http://www.scotlibdems.org.uk/euan_davidson       https://static-candidates.democracyclub.org.uk/media/images/551afd8c13eb34c82843cb3a.png   profile-photo 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 38 party:90 Liberal Democrats gss:S16000118 Glasgow Maryhill and Springburn     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   public-domain 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   38 party:90 Liberal Democrats gss:S16000106 Edinburgh Northern and Leith     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   profile-photo 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 38 party:52 Conservative and Unionist Party gss:S16000094 Cunninghame North     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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
10594 6444 Danus Skene     Male   38 party:102 Scottish National Party (SNP) gss:S16000142 Shetland Islands     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   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000126 Kilmarnock and Irvine Valley     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   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000109 Edinburgh Western     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Batho_Sandy.aspx       https://static-candidates.democracyclub.org.uk/media/images/553ca17de22f98bc5d30fa72.png   profile-photo 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 38 party:52 Conservative and Unionist Party gss:S16000133 Motherwell and Wishaw     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Gallacher_Meghan.aspx       https://static-candidates.democracyclub.org.uk/media/images/551b36ea13eb34c82843cb4d.png   profile-photo TimPatmore From Scottish Conservatives website. 2016-05-05 0 0   7510.0       PP52   0
10598 6548 Ruby Kirkwood     female   38 party:90 Liberal Democrats gss:S16000095 Cunninghame South     http://www.ayrshirelibdems.org.uk/local-party/ruby-kirkwood       https://static-candidates.democracyclub.org.uk/media/images/5526959859bbc5c063445be6.png   profile-photo 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 38 party:52 Conservative and Unionist Party gss:S16000081 Angus North and Mearns     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   public-domain 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   38 party:52 Conservative and Unionist Party gss:S16000079 Airdrie and Shotts     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Holford_Eric.aspx       https://static-candidates.democracyclub.org.uk/media/images/5525ee76413cb4432adffa48.png   profile-photo 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   38 party:90 Liberal Democrats gss:S16000103 Eastwood     http://www.scotlibdems.org.uk/john_duncan       https://static-candidates.democracyclub.org.uk/media/images/5547b322f0745ae61e5c2793.png   profile-photo 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   38 party:90 Liberal Democrats gss:S16000114 Galloway and West Dumfries     http://www.libdems.org.uk/andrew_metcalf       https://static-candidates.democracyclub.org.uk/media/images/5548c2d2e2efb2432db96528.png   profile-photo 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   38 party:90 Liberal Democrats gss:S16000129 Mid Fife and Glenrothes     http://www.libdems.org.uk/jane_liston       https://static-candidates.democracyclub.org.uk/media/images/5548c308e2efb2432db9652a.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/jane_liston 2016-05-05 0 0           PP90   0
10604 6606 Rod Ackland     Male   38 party:90 Liberal Democrats gss:S16000139 Renfrewshire North and West     http://www.scotlibdems.org.uk/rod_ackland       https://static-candidates.democracyclub.org.uk/media/images/images/6606.png   profile-photo sjorford http://www.scotlibdems.org.uk/rod_ackland 2016-05-05 0 0   3499.0       PP90   0
10605 6607 Emma Farthing-Sykes     Female   38 party:90 Liberal Democrats gss:S16000107 Edinburgh Pentlands     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   profile-photo 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   38 party:90 Liberal Democrats gss:S16000136 Paisley     http://www.scotlibdems.org.uk/eileen_mccartin       https://static-candidates.democracyclub.org.uk/media/images/images/6612.png   profile-photo 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   38 party:90 Liberal Democrats gss:S16000096 Dumbarton     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   profile-photo jack   2016-05-05 0 0           PP90   0
10608 6651 Scott Nicholson     male   38 party:53 Labour Party gss:S16000138 Perthshire South and Kinross-shire             https://static-candidates.democracyclub.org.uk/media/images/553b9f79ec0766d3759c0445.png   profile-photo 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   38 party:90 Liberal Democrats gss:S16000123 Greenock and Inverclyde     http://www.libdems.org.uk/john_watson http://www.inverclydelibdems.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/5547b1e8da8374e520fa5d4d.png   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000096 Dumbarton     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   profile-photo 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 38 party:53 Labour Party gss:S16000135 Orkney Islands       http://www.orkneylabour.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5501a38c551f41c939045331.png   public-domain gerry   2016-05-05 0 0           PP53   0
10612 6732 John Cormack     male   38 party:2893 Christian Party "Proclaiming Christ's Lordship" gss:S16000110 Na h-Eileanan an Iar             https://static-candidates.democracyclub.org.uk/media/images/553a198b10534e264e17b376.png   profile-photo edent http://www.ukchristianparty.org/candidates-for-general-election.html 2016-05-05 0 0           PP2893   0
10613 6752 Alex Stewart-Clark mr   male   38 party:52 Conservative and Unionist Party gss:S16000129 Mid Fife and Glenrothes     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   profile-photo 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   38 party:52 Conservative and Unionist Party gss:S16000083 Argyll and Bute     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   profile-photo 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   38 party:90 Liberal Democrats gss:S16000115 Glasgow Anniesland     http://www.libdems.org.uk/james_speirs       https://static-candidates.democracyclub.org.uk/media/images/images/8333.png   profile-photo buchser official party website 2016-05-05 0 0   8333.0       PP90   0
10616 7361 Robert Simpson     male   38 party:90 Liberal Democrats gss:S16000084 Ayr     http://www.scotlibdems.org.uk/robert_simpson       https://static-candidates.democracyclub.org.uk/media/images/5542b6584fa35c463ab98f61.png   profile-photo dunnid http://www.scotlibdems.org.uk/robert_simpson 2016-05-05 0 0           PP90   0
10617 7449 Patrick Harvie     male 1973-05-01 38 party:130 Scottish Green Party gss:S16000117 Glasgow Kelvin       http://www.patrickharviemsp.com/ https://en.wikipedia.org/wiki/Patrick_Harvie   https://static-candidates.democracyclub.org.uk/media/images/images/7449.png   profile-photo vclaw   2016-05-05 0 0           PP130   0
10618 7451 Andrew Polson     male   38 party:52 Conservative and Unionist Party gss:S16000145 Strathkelvin and Bearsden     http://www.scottishconservatives.com/people/candidates-2/       https://static-candidates.democracyclub.org.uk/media/images/images/7451.png   profile-photo 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 38 party:130 Scottish Green Party gss:S16000091 Coatbridge and Chryston     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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP130   0
10620 7483 Alison Johnstone   MSP female 1965-10-11 38 party:130 Scottish Green Party gss:S16000104 Edinburgh Central     https://greens.scot/region/lothian   https://en.wikipedia.org/wiki/Alison_Johnstone   https://static-candidates.democracyclub.org.uk/media/images/images/7483.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP130   0
10621 7491 Jackie Baillie     female 1964-01-15 38 party:53 Labour Party gss:S16000096 Dumbarton   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   profile-photo 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 38 party:53 Labour Party gss:S16000136 Paisley     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   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
10623 7498 Gail Robertson     female   38 party:102 Scottish National Party (SNP) gss:S16000096 Dumbarton     http://www.snp.org/gail_robertson       https://static-candidates.democracyclub.org.uk/media/images/images/7498.png   profile-photo 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   38 ynmp-party:2 Independent gss:S16000096 Dumbarton             https://static-candidates.democracyclub.org.uk/media/images/images/7499.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           ynmp-party:2   0
10625 7509 John Pentland     male   38 party:53 Labour Party gss:S16000133 Motherwell and Wishaw     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
10626 7511 Alex Neil     male 1951-08-22 38 party:102 Scottish National Party (SNP) gss:S16000079 Airdrie and Shotts   1.0 http://www.snp.org/alex_neil http://www.alexneilmsp.net/ https://en.wikipedia.org/wiki/Alex_Neil_%28politician%29   https://static-candidates.democracyclub.org.uk/media/images/images/7511.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP102   0
Powered by Datasette · Query took 1.439ms