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
13895 107 Eileen Baxendale     female 1945-04-16 81 party:90 Liberal Democrats gss:S17000009 Central Scotland     http://www.scotlibdems.org.uk/eileen_baxendale                 2016-05-05 0 1 2         PP90   0
13896 140 Paul Wheelhouse     male 1970-06-20 81 party:102 Scottish National Party (SNP) gss:S17000015 South Scotland   1.0   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 1 5         PP102   0
13897 154 Maurice Golden     male   81 party:52 Conservative and Unionist Party gss:S17000016 West Scotland   1.0 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 1 3 8099.0       PP52   0
13898 521 Steve Burgess     male   81 party:130 Scottish Green Party gss:S17000012 Lothian             https://static-candidates.democracyclub.org.uk/media/images/images/521.png   profile-photo   Auto imported from Twitter 2016-05-05 0 1 6         PP130   0
13899 524 Iain McGill     male 1976.0 81 party:52 Conservative and Unionist Party gss:S17000012 Lothian     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 1 5         PP52   0
13900 537 Donnie MacLeod     male   81 party:130 Scottish Green Party gss:S17000011 Highlands and Islands                       2016-05-05 0 1 7         PP130   0
13901 737 Ruth Davidson     female 1978-11-10 81 party:52 Conservative and Unionist Party gss:S17000012 Lothian         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 1 1 8037.0       PP52   0
13902 839 Fiona O'Donnell Ms   female 1960-01-27 81 party:53 Labour Party gss:S17000015 South Scotland         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 1 6 9165.0   uk.org.publicwhip/person/uk.org.publicwhip/person/24723 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/24723 PP53   0
13903 1113 John Stanyer Mr   male 1964-03-12 81 party:85 UK Independence Party (UKIP) gss:S17000015 South Scotland             https://static-candidates.democracyclub.org.uk/media/images/55292412b6a860ed1648be5a.png   copyright-assigned StanyerB my photo owned by me 2016-05-05 0 1 4         PP85   0
13904 1212 Philip Anderson     male 1942-04-16 81 party:85 UK Independence Party (UKIP) gss:S17000011 Highlands and Islands             https://static-candidates.democracyclub.org.uk/media/images/5525fa35413cb4432adffa7e.png   profile-photo gordonjstewart This is the photograph used on the UKIP candidates website. 2016-05-05 0 1 4         PP85   0
13905 1350 Jean Davis     female 1954-05-26 81 party:90 Liberal Democrats gss:S17000011 Highlands and Islands             https://static-candidates.democracyclub.org.uk/media/images/images/1350.png   profile-photo vclaw Photo from Facebook campaign page. https://www.facebook.com/JeanDavis4RSL 2016-05-05 0 1 7         PP90   0
13906 1383 Anas Sarwar     male 1983-03-14 81 party:53 Labour Party gss:S17000010 Glasgow   1.0   http://www.anassarwar.org/ https://en.wikipedia.org/wiki/Anas_Sarwar   https://static-candidates.democracyclub.org.uk/media/images/553ba20cec0766d3759c0449.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/AnasSarwar 2016-05-05 0 1 1 7641.0   uk.org.publicwhip/person/uk.org.publicwhip/person/24738 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/24738 PP53   0
13907 1388 Katy Gordon     female 1966-01-23 81 party:90 Liberal Democrats gss:S17000016 West Scotland     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 1 1         PP90   0
13908 1404 Mark Ruskell     male 1972-05-14 81 party:130 Scottish Green Party gss:S17000013 Mid Scotland and Fife   1.0 http://www.stirlinggreens.org.uk/?p=467   https://en.wikipedia.org/wiki/Mark_Ruskell   https://static-candidates.democracyclub.org.uk/media/images/553b433e81ca637726b5039c.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/markruskell 2016-05-05 0 1 1         PP130   0
13909 1405 Kirsten Robb     female   81 party:130 Scottish Green Party gss:S17000009 Central Scotland     https://greens.scot/region/central-scotland       https://static-candidates.democracyclub.org.uk/media/images/images/1405.png   profile-photo   Auto imported from Twitter 2016-05-05 0 1 1 19879.0       PP130   0
13910 1516 Donald Mackay     male 1960-01-02 81 party:85 UK Independence Party (UKIP) gss:S17000009 Central Scotland           https://uk.linkedin.com/pub/donald-mackay/3a/983/ab0           2016-05-05 0 1 2         PP85   0
13911 1535 Thomas Docherty     male 1975-01-28 81 party:53 Labour Party gss:S17000013 Mid Scotland and Fife         https://en.wikipedia.org/wiki/Thomas_Docherty_(politician)   https://static-candidates.democracyclub.org.uk/media/images/553b4eab81ca637726b503a5.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/Thomas_Docherty 2016-05-05 0 1 3     uk.org.publicwhip/person/uk.org.publicwhip/person/24730 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/24730 PP53   0
13912 1646 Miles Briggs     male   81 party:52 Conservative and Unionist Party gss:S17000012 Lothian   1.0 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 1 2         PP52   0
13913 1792 Rod Campbell     male   81 party:102 Scottish National Party (SNP) gss:S17000013 Mid Scotland and Fife                       2016-05-05 0 1 8         PP102   0
13914 1795 Jean Urquhart     female 1949-05-17 81 party:2871 RISE - Respect, Independence, Socialism and Environmentalism gss:S17000011 Highlands and Islands       http://jeanurquhart.com/ https://en.wikipedia.org/wiki/Jean_Urquhart   https://static-candidates.democracyclub.org.uk/media/images/images/1795.png   profile-photo   Auto imported from Twitter 2016-05-05 0 1 1         PP2871   0
13915 2076 Chic Brodie     male 1944-05-08 81 party:102 Scottish National Party (SNP) gss:S17000015 South Scotland     http://www.snp.org/chic_brodie   https://en.wikipedia.org/wiki/Chic_Brodie_(politician)             2016-05-05 0 1 7         PP102   0
13916 2152 Kevin McVey     male   81 party:2871 RISE - Respect, Independence, Socialism and Environmentalism gss:S17000009 Central Scotland         https://en.wikipedia.org/wiki/Kevin_McVey_%28socialist%29             2016-05-05 0 1 1         PP2871   0
13917 2243 Richard Brodie     male   81 party:90 Liberal Democrats gss:S17000015 South Scotland     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 1 4 6596.0       PP90   0
13918 2279 Claudia Beamish     female 1952-08-09 81 party:53 Labour Party gss:S17000015 South Scotland     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 1 2         PP53   0
13919 2292 Mike MacKenzie     male 1958-11-18 81 party:102 Scottish National Party (SNP) gss:S17000011 Highlands and Islands     http://www.snp.org/mike_mackenzie http://mikemackenzie.org/ https://en.wikipedia.org/wiki/Mike_MacKenzie_(politician)   https://static-candidates.democracyclub.org.uk/media/images/images/2292.png   profile-photo   Auto imported from Twitter 2016-05-05 0 1 3         PP102   0
13920 2329 Elisabeth Mary Wilson Dr   female   81 party:90 Liberal Democrats gss:S17000013 Mid Scotland and Fife     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 1 4 6613;34630       PP90   0
13921 2355 Ashay Ghai     male   81 party:90 Liberal Democrats gss:S17000016 West Scotland                       2016-05-05 0 1 2         PP90   0
13922 2679 Kristian Chapman     male   81 party:90 Liberal Democrats gss:S17000015 South Scotland                       2016-05-05 0 1 2 10986.0       PP90   0
13923 2704 Clare Adamson     female 1967-08-01 81 party:102 Scottish National Party (SNP) gss:S17000009 Central Scotland     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 1 6 7508.0       PP102   0
13924 2708 Sophia Coyle     female   81 party:102 Scottish National Party (SNP) gss:S17000009 Central Scotland                       2016-05-05 0 1 3 8289.0       PP102   0
13925 2713 Annabelle Ewing     female 1960-08-20 81 party:102 Scottish National Party (SNP) gss:S17000013 Mid Scotland and Fife     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 1 2         PP102   0
13926 2756 Douglas Ross     male 1983.0 81 party:52 Conservative and Unionist Party gss:S17000011 Highlands and Islands   1.0 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 1 1         PP52   0
13927 2797 Mark McDonald     male 1980-06-07 81 party:102 Scottish National Party (SNP) gss:S17000014 North East Scotland       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 1 8         PP102   0
13928 2801 Peter Anthony Barrett     male 1961.0 81 party:90 Liberal Democrats gss:S17000013 Mid Scotland and Fife     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 1 2 15334.0       PP90   0
13929 2842 David Wilson     male   81 party:52 Conservative and Unionist Party gss:S17000016 West Scotland             https://static-candidates.democracyclub.org.uk/media/images/images/2842_MpXRNhZ.png   public-domain Jimbo   2016-05-05 0 1 6         PP52   0
13930 2865 Ross Thomson Cllr   male 1987-09-21 81 party:52 Conservative and Unionist Party gss:S17000014 North East Scotland   1.0 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 1 3         PP52   0
13931 3098 Tommy Sheridan     male 1964-03-07 81 party:2897 Solidarity - Scotland's Socialist Movement gss:S17000010 Glasgow         https://en.wikipedia.org/wiki/Tommy_Sheridan   https://static-candidates.democracyclub.org.uk/media/images/images/3098.png   profile-photo   Auto imported from Twitter 2016-05-05 0 1 1         PP2897   0
13932 3134 Isabel Nelson     female 1940.0 81 party:90 Liberal Democrats gss:S17000010 Glasgow     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 1 2 21656.0       PP90   0
13933 3164 Jamie Glackin     male 1972-09-18 81 party:53 Labour Party gss:S17000013 Mid Scotland and Fife                       2016-05-05 0 1 7         PP53   0
13934 3231 Alan Reid     male 1954-08-07 81 party:90 Liberal Democrats gss:S17000011 Highlands and Islands     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 1 5     uk.org.publicwhip/person/uk.org.publicwhip/person/11185 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/11185 PP90   0
13935 3468 Jamie Paterson     male   81 party:90 Liberal Democrats gss:S17000011 Highlands and Islands     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 1 3 34804.0       PP90   0
13936 3500 Julie Hepburn     female   81 party:102 Scottish National Party (SNP) gss:S17000009 Central Scotland       http://juliehepburn.scot     https://static-candidates.democracyclub.org.uk/media/images/images/3500.png   profile-photo   Auto imported from Twitter 2016-05-05 0 1 4 7529.0       PP102   0
13937 3510 John Finnie     male 1956-12-31 81 party:130 Scottish Green Party gss:S17000011 Highlands and Islands   1.0   http://johnfinniemsp.org/ https://en.wikipedia.org/wiki/John_Finnie             2016-05-05 0 1 1         PP130   0
13938 3560 Colin Beattie     male 1951-10-17 81 party:102 Scottish National Party (SNP) gss:S17000012 Lothian       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 1 8         PP102   0
13939 3580 Donald MacLeod Boyd Dr M.B.Ch.B. male   81 party:2893 Christian Party "Proclaiming Christ's Lordship" gss:S17000011 Highlands and Islands     http://www.ukchristianparty.org/scottish-annual-conference-and-agm1.html http://www.donaldboyd.org/     https://static-candidates.democracyclub.org.uk/media/images/5516b1f4929f1bbe286be023.png   profile-photo BillyDonohoe https://twitter.com/DonaldBoyd7?original_referer=http%3A%2F%2Fwww.highlandscp.org%2Fcandidates%2F&profile_id=561625179&tw_i=580793366130069505&tw_p=embeddedtimeline&tw_w=271781070964408320 2016-05-05 0 1 1         PP2893   0
13940 3653 Willie Rennie     male 1967-09-27 81 party:90 Liberal Democrats gss:S17000013 Mid Scotland and Fife     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 1 1         PP90   0
13941 4033 Charles Dundas     male 1978-07-19 81 party:90 Liberal Democrats gss:S17000012 Lothian     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 1 6         PP90   0
13942 4075 Graham Simpson     male   81 party:52 Conservative and Unionist Party gss:S17000009 Central Scotland   1.0 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 1 2         PP52   0
13943 4216 Huw Bell   BSc (Hons) Male 1981-04-15 81 party:52 Conservative and Unionist Party gss:S17000013 Mid Scotland and 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 1 5         PP52   0
13944 4246 Alexander Burnett     male 1973-07-30 81 party:52 Conservative and Unionist Party gss:S17000014 North East Scotland     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 1 2         PP52   0
13945 4288 John Erskine     male   81 party:53 Labour Party gss:S17000011 Highlands and Islands     http://www.labour.org.uk/people/detail/john-erskine http://www.johnerskine.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5481e7c5b150e238702c0569.png   profile-photo     2016-05-05 0 1 6 13022.0       PP53   0
13946 4324 Lesley Brennan     female 1972.0 81 party:53 Labour Party gss:S17000014 North East Scotland     http://www.labour.org.uk/people/detail/lesley-brennan http://www.lesleybrennan.com/ https://en.wikipedia.org/wiki/Lesley_Brennan https://www.linkedin.com/in/lesleybrennan https://static-candidates.democracyclub.org.uk/media/images/5481e7f2b150e238702c0588.png   profile-photo     2016-05-05 0 1 3         PP53   0
13947 4384 Sean Morton     male   81 party:53 Labour Party gss:S17000011 Highlands and Islands     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 1 4 22394.0       PP53   0
13948 4441 Johanna Boyd     female   81 party:53 Labour Party gss:S17000013 Mid Scotland and Fife       http://johannaboyd.com/     https://static-candidates.democracyclub.org.uk/media/images/5519d82cba7512a07da47942.png   profile-photo RodBegbie   2016-05-05 0 1 6         PP53   0
13949 4681 Ettie Spencer     female   81 party:90 Liberal Democrats gss:S17000015 South Scotland     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 1 3         PP90   0
13950 4851 Caroline Santos     female   81 party:85 UK Independence Party (UKIP) gss:S17000015 South Scotland             https://static-candidates.democracyclub.org.uk/media/images/5525eed3413cb4432adffa50.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 1 2         PP85   0
13951 4993 Sarah Beattie-Smith     female   81 party:130 Scottish Green Party gss:S17000015 South Scotland     https://greens.scot/region/south-of-scotland https://sarahbeattiesmith.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/images/4993.png   profile-photo ayrshiregreens   2016-05-05 0 1 1         PP130   0
13952 4995 Paul McGarry Mr   male   81 party:90 Liberal Democrats gss:S17000009 Central Scotland     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 1 1 7525;21145       PP90   0
13953 5004 Jason Rose     male   81 party:130 Scottish Green Party gss:S17000015 South Scotland     http://eastlothiangreens.blogspot.co.uk/2014/12/east-lothian-greens-select-jason-rose.html https://jasonroseblog.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/images/5004.png   profile-photo kdcm87 https://www.facebook.com/jasonrosegreen 2016-05-05 0 1 6         PP130   0
13954 5036 Lee Lyons     Male   81 party:52 Conservative and Unionist Party gss:S17000015 South Scotland     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 1 8         PP52   0
13955 5041 Finlay Carson     Male 1967-10-18 81 party:52 Conservative and Unionist Party gss:S17000015 South Scotland     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 1 4         PP52   0
13956 5042 James Reekie     Male   81 party:52 Conservative and Unionist Party gss:S17000013 Mid Scotland and Fife     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 1 6         PP52   0
13957 5044 Gordon Lindhurst     male   81 party:52 Conservative and Unionist Party gss:S17000012 Lothian   1.0 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 1 3         PP52   0
13958 5045 Alison Harris     female   81 party:52 Conservative and Unionist Party gss:S17000009 Central Scotland   1.0 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 1 3         PP52   0
13959 5046 Colin Clark     male 1969-05-20 81 party:52 Conservative and Unionist Party gss:S17000014 North East Scotland     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 1 8         PP52   0
13960 5047 Dave Dempsey     male 1951-09-18 81 party:52 Conservative and Unionist Party gss:S17000013 Mid Scotland and Fife     http://fifeconservatives.uk/index.php/inverkeithing-dalgety-bay       https://static-candidates.democracyclub.org.uk/media/images/550570d2071d4f1362bc8037.png         2016-05-05 0 1 7         PP52   0
13961 5048 Edward Mountain     male   81 party:52 Conservative and Unionist Party gss:S17000011 Highlands and Islands   1.0 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 1 2         PP52   0
13962 5050 Taylor Muir     Male 1995-07-18 81 party:52 Conservative and Unionist Party gss:S17000010 Glasgow     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 1 8         PP52   0
13963 5051 Michelle Ballantyne     female   81 party:52 Conservative and Unionist Party gss:S17000015 South Scotland     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 1 6 8104.0       PP52   0
13964 5053 Alex Allison     male   81 party:52 Conservative and Unionist Party gss:S17000015 South Scotland     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 1 7         PP52   0
13965 5139 Alexander Stewart     male   81 party:52 Conservative and Unionist Party gss:S17000013 Mid Scotland and Fife   1.0 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 1 4         PP52   0
13966 5163 Peter McColl     Male 1980-05-09 81 party:130 Scottish Green Party gss:S17000012 Lothian     http://www.scottishgreens.org.uk/westminster2015-2/ http://petermccoll.wordpress.com/ https://en.wikipedia.org/wiki/Peter_McColl   https://static-candidates.democracyclub.org.uk/media/images/54bfa9905a9c3744778f9b8f.png         2016-05-05 0 1 4 8293.0       PP130   0
13967 5169 Veronika Tudhope     female   81 party:130 Scottish Green Party gss:S17000016 West Scotland     http://www.scottishgreens.org.uk/westminster2015-2/       https://static-candidates.democracyclub.org.uk/media/images/54fb34e4ac1daeda13b59ed0.png         2016-05-05 0 1 2 7768.0       PP130   0
13968 5279 Sandra Webster     female   81 party:2871 RISE - Respect, Independence, Socialism and Environmentalism gss:S17000016 West Scotland       http://sandrawebster.info/ https://en.wikipedia.org/wiki/Sandra_Webster   https://static-candidates.democracyclub.org.uk/media/images/553bd0feec0766d3759c0462.png   profile-photo andylolz From the candidate’s facebook campaign page: https://www.facebook.com/pages/Sandra-Webster-4-Paisley-Renfrewshire-South/1530441287198021 2016-05-05 0 1 2         PP2871   0
13969 5285 David Coburn     male 1959-02-11 81 party:85 UK Independence Party (UKIP) gss:S17000011 Highlands and Islands       https://www.davidcoburnmep.co.uk/ http://en.wikipedia.org/wiki/David_Coburn_(politician)   https://static-candidates.democracyclub.org.uk/media/images/5526919d59bbc5c063445baf.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 1 1 2583;34702       PP85   0
13970 5365 Craig Duncan Mr   male 1962.0 81 party:90 Liberal Democrats gss:S17000014 North East Scotland     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 1 5 7693.0       PP90   0
13971 5367 Ross Greer     male 1994-06-01 81 party:130 Scottish Green Party gss:S17000016 West Scotland   1.0 https://greens.scot/region/west-of-scotland http://scottishyounggreens.org/blog/introducing-ross-greer/ https://en.wikipedia.org/wiki/Ross_Greer_(politician)   https://static-candidates.democracyclub.org.uk/media/images/551ab3e0e2ac8b7333e6a27f.png   profile-photo syqul This is the candidate's profile photo from his Facebook campaign page. https://scontent-lhr.xx.fbcdn.net/hphotos-xpf1/t31.0-8/s960x960/10321071_601715373262682_604421492369651213_o.jpg 2016-05-05 0 1 1 7481.0       PP130   0
13972 5517 Kenryck Lloyd-Jones     male   81 party:53 Labour Party gss:S17000015 South Scotland             https://static-candidates.democracyclub.org.uk/media/images/550fe93f53de37dd471e05d3.png         2016-05-05 0 1 5         PP53   0
13973 5521 David Evans Mr   male 1992-03-07 81 party:90 Liberal Democrats gss:S17000014 North East Scotland     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 1 7 8249.0       PP90   0
13974 5522 Bill Bowman     male 1950-05-30 81 party:52 Conservative and Unionist Party gss:S17000014 North East Scotland     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 1 6         PP52   0
13975 5764 Suzanne McLaughlin     female   81 party:102 Scottish National Party (SNP) gss:S17000010 Glasgow                       2016-05-05 0 1 7         PP102   0
13976 5773 Patricia Black     female   81 party:130 Scottish Green Party gss:S17000012 Lothian     http://www.edinburghgreens.org.uk/site/westminster-2015/       https://static-candidates.democracyclub.org.uk/media/images/553b49b27b9de399275bb48e.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/patkinnearblack 2016-05-05 0 1 7         PP130   0
13977 5896 Kyle Thornton Mr   male   81 party:52 Conservative and Unionist Party gss:S17000010 Glasgow     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 1 4 7638.0       PP52   0
13978 5901 Nicola Ross     female   81 party:52 Conservative and Unionist Party gss:S17000014 North East Scotland     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 1 7         PP52   0
13979 6005 Andy Morrison     male   81 party:52 Conservative and Unionist Party gss:S17000009 Central Scotland     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 1 4         PP52   0
13980 6009 Annie Wells     female   81 party:52 Conservative and Unionist Party gss:S17000010 Glasgow   1.0 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 1 2         PP52   0
13981 6011 Sharon McGonigal     Female   81 party:85 UK Independence Party (UKIP) gss:S17000016 West Scotland             https://static-candidates.democracyclub.org.uk/media/images/553c979442c427035c8db3e7.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/shazza1uk 2016-05-05 0 1 1         PP85   0
13982 6018 Kim Long     Female 1990-06-24 81 party:130 Scottish Green Party gss:S17000010 Glasgow     http://www.scottishgreens.org.uk/westminster2015-2/       https://static-candidates.democracyclub.org.uk/media/images/553c983341b868785b1fe674.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/CaptainKim 2016-05-05 0 1 8         PP130   0
13983 6046 Emma Harper     female   81 party:102 Scottish National Party (SNP) gss:S17000015 South Scotland   1.0 http://www.snp.org/people/emma-harper http://emmaharper.scot/ https://en.wikipedia.org/wiki/Emma_Harper   https://static-candidates.democracyclub.org.uk/media/images/552ffb2a7fce6de164f2fdf8.png   profile-photo jamesm3 http://www.emmaharper.scot/ 2016-05-05 0 1 4         PP102   0
13984 6077 Isla O'Reilly     Female 1979-12-18 81 party:130 Scottish Green Party gss:S17000011 Highlands and Islands     http://www.scottishgreens.org.uk/westminster2015-2/ http://higreens.org/     https://static-candidates.democracyclub.org.uk/media/images/54e7805202f716934fefdb75.jpg         2016-05-05 0 1 2 7485.0       PP130   0
13985 6078 Andy Collins Mr MMRS Male 1950-05-22 81 party:130 Scottish Green Party gss:S17000013 Mid Scotland and Fife     https://greens.scot/team/council-candidate/andy-collins https://greens.scot/ https://en.wikipedia.org/wiki/Scottish_Green_Party   https://static-candidates.democracyclub.org.uk/media/images/55073ee95399523471f7e1ae.png         2016-05-05 0 1 5 7896.0       PP130   0
13986 6081 Zara Kitson     Female 1986-01-21 81 party:130 Scottish Green Party gss:S17000010 Glasgow     http://www.scottishgreens.org.uk/westminster2015-2/ http://zarakitson.org/   http://uk.linkedin.com/in/zarakitson/en https://static-candidates.democracyclub.org.uk/media/images/553a4d7f10a500d1762bf1ba.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/ZaraKitson 2016-05-05 0 1 2         PP130   0
13987 6083 Sean Templeton     Male   81 party:130 Scottish Green Party gss:S17000010 Glasgow     http://www.scottishgreens.org.uk/westminster2015-2/       https://static-candidates.democracyclub.org.uk/media/images/553c2fd062bbab35264e7acd.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/lexsum1 2016-05-05 0 1 3         PP130   0
13988 6084 Anne Thomas     Female   81 party:130 Scottish Green Party gss:S17000011 Highlands and Islands     http://www.scottishgreens.org.uk/westminster2015-2/ https://higp.scottishgreens.org.uk/               2016-05-05 0 1 6         PP130   0
13989 6133 Ryan Morrison     Male 1993-07-29 81 party:130 Scottish Green Party gss:S17000016 West Scotland     http://www.scottishgreens.org.uk/westminster2015-2/                 2016-05-05 0 1 7 13050.0       PP130   0
13990 6149 John Anderson     male   81 party:52 Conservative and Unionist Party gss:S17000010 Glasgow     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 1 5         PP52   0
13991 6239 Dan Yeats     male 1982-05-29 81 party:130 Scottish Green Party gss:S17000014 North East Scotland     http://www.scottishgreens.org.uk/westminster2015-2/ http://www.danyeats.co.uk/   http://uk.linkedin.com/in/danyeats https://static-candidates.democracyclub.org.uk/media/images/images/6239.png   profile-photo   Auto imported from Twitter 2016-05-05 0 1 2         PP130   0
13992 6300 Euan Davidson     male 1994-07-07 81 party:90 Liberal Democrats gss:S17000014 North East Scotland     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 1 6 8248.0       PP90   0
13993 6302 James Harrison     male 1990-03-03 81 party:90 Liberal Democrats gss:S17000010 Glasgow     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 1 4 8357.0       PP90   0
13994 6304 Martin Veart     male   81 party:90 Liberal Democrats gss:S17000012 Lothian     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 1 5         PP90   0
13995 6353 Jamie Greene     male 1980-03-19 81 party:52 Conservative and Unionist Party gss:S17000016 West Scotland   1.0 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 1 2         PP52   0
Powered by Datasette · Query took 1.455ms