home / democracyclub

candidates

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

519 rows where election = 81

View and edit SQL

Suggested facets: honorific_prefix, honorific_suffix, gender, party_id, party_name, post_id, post_label, image_copyright, party_list_position, 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
13895 107 Eileen Baxendale     female 1945-04-16 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000009     http://www.scotlibdems.org.uk/eileen_baxendale               2016-05-05 0 1 2         PP90   0
13896 140 Paul Wheelhouse     male 1970-06-20 sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000015   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     Auto imported from Twitter 2016-05-05 0 1 5         PP102   0
13897 154 Maurice Golden     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000016   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   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   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000012             https://static-candidates.democracyclub.org.uk/media/images/images/521.png     Auto imported from Twitter 2016-05-05 0 1 6         PP130   0
13899 524 Iain McGill     male 1976.0 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000012     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 1 5         PP52   0
13900 537 Donnie MacLeod     male   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000011                     2016-05-05 0 1 7         PP130   0
13901 737 Ruth Davidson     female 1978-11-10 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000012         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 1 1 8037.0       PP52   0
13902 839 Fiona O'Donnell Ms   female 1960-01-27 sp.r.2016-05-05 81 party:53 Labour Party gss:S17000015         https://en.wikipedia.org/wiki/Fiona_O'Donnell   https://static-candidates.democracyclub.org.uk/media/images/551a087db989d5e837ae99dd.png   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 sp.r.2016-05-05 81 party:85 UK Independence Party (UKIP) gss:S17000015             https://static-candidates.democracyclub.org.uk/media/images/55292412b6a860ed1648be5a.png   StanyerB my photo owned by me 2016-05-05 0 1 4         PP85   0
13904 1212 Philip Anderson     male 1942-04-16 sp.r.2016-05-05 81 party:85 UK Independence Party (UKIP) gss:S17000011             https://static-candidates.democracyclub.org.uk/media/images/5525fa35413cb4432adffa7e.png   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 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000011             https://static-candidates.democracyclub.org.uk/media/images/images/1350.png   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 sp.r.2016-05-05 81 party:53 Labour Party gss:S17000010   1.0   http://www.anassarwar.org/ https://en.wikipedia.org/wiki/Anas_Sarwar   https://static-candidates.democracyclub.org.uk/media/images/553ba20cec0766d3759c0449.png   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 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000016     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 1 1         PP90   0
13908 1404 Mark Ruskell     male 1972-05-14 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000013   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   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   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000009     https://greens.scot/region/central-scotland       https://static-candidates.democracyclub.org.uk/media/images/images/1405.png     Auto imported from Twitter 2016-05-05 0 1 1 19879.0       PP130   0
13910 1516 Donald Mackay     male 1960-01-02 sp.r.2016-05-05 81 party:85 UK Independence Party (UKIP) gss:S17000009           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 sp.r.2016-05-05 81 party:53 Labour Party gss:S17000013         https://en.wikipedia.org/wiki/Thomas_Docherty_(politician)   https://static-candidates.democracyclub.org.uk/media/images/553b4eab81ca637726b503a5.png   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   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000012   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       2016-05-05 0 1 2         PP52   0
13913 1792 Rod Campbell     male   sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000013                     2016-05-05 0 1 8         PP102   0
13914 1795 Jean Urquhart     female 1949-05-17 sp.r.2016-05-05 81 party:2871 RISE - Respect, Independence, Socialism and Environmentalism gss:S17000011       http://jeanurquhart.com/ https://en.wikipedia.org/wiki/Jean_Urquhart   https://static-candidates.democracyclub.org.uk/media/images/images/1795.png     Auto imported from Twitter 2016-05-05 0 1 1         PP2871   0
13915 2076 Chic Brodie     male 1944-05-08 sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000015     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   sp.r.2016-05-05 81 party:2871 RISE - Respect, Independence, Socialism and Environmentalism gss:S17000009         https://en.wikipedia.org/wiki/Kevin_McVey_%28socialist%29           2016-05-05 0 1 1         PP2871   0
13917 2243 Richard Brodie     male   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000015     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 1 4 6596.0       PP90   0
13918 2279 Claudia Beamish     female 1952-08-09 sp.r.2016-05-05 81 party:53 Labour Party gss:S17000015     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 1 2         PP53   0
13919 2292 Mike MacKenzie     male 1958-11-18 sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000011     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     Auto imported from Twitter 2016-05-05 0 1 3         PP102   0
13920 2329 Elisabeth Mary Wilson Dr   female   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000013     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 1 4 6613;34630       PP90   0
13921 2355 Ashay Ghai     male   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000016                     2016-05-05 0 1 2         PP90   0
13922 2679 Kristian Chapman     male   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000015                     2016-05-05 0 1 2 10986.0       PP90   0
13923 2704 Clare Adamson     female 1967-08-01 sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000009     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 1 6 7508.0       PP102   0
13924 2708 Sophia Coyle     female   sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000009                     2016-05-05 0 1 3 8289.0       PP102   0
13925 2713 Annabelle Ewing     female 1960-08-20 sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000013     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 1 2         PP102   0
13926 2756 Douglas Ross     male 1983.0 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000011   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   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 sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000014       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 1 8         PP102   0
13928 2801 Peter Anthony Barrett     male 1961.0 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000013     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 1 2 15334.0       PP90   0
13929 2842 David Wilson     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000016             https://static-candidates.democracyclub.org.uk/media/images/images/2842_MpXRNhZ.png   Jimbo   2016-05-05 0 1 6         PP52   0
13930 2865 Ross Thomson Cllr   male 1987-09-21 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000014   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   RossThomson   2016-05-05 0 1 3         PP52   0
13931 3098 Tommy Sheridan     male 1964-03-07 sp.r.2016-05-05 81 party:2897 Solidarity - Scotland's Socialist Movement gss:S17000010         https://en.wikipedia.org/wiki/Tommy_Sheridan   https://static-candidates.democracyclub.org.uk/media/images/images/3098.png     Auto imported from Twitter 2016-05-05 0 1 1         PP2897   0
13932 3134 Isabel Nelson     female 1940.0 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000010     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 1 2 21656.0       PP90   0
13933 3164 Jamie Glackin     male 1972-09-18 sp.r.2016-05-05 81 party:53 Labour Party gss:S17000013                     2016-05-05 0 1 7         PP53   0
13934 3231 Alan Reid     male 1954-08-07 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000011     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 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   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000011     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 1 3 34804.0       PP90   0
13936 3500 Julie Hepburn     female   sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000009       http://juliehepburn.scot     https://static-candidates.democracyclub.org.uk/media/images/images/3500.png     Auto imported from Twitter 2016-05-05 0 1 4 7529.0       PP102   0
13937 3510 John Finnie     male 1956-12-31 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000011   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 sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000012       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 1 8         PP102   0
13939 3580 Donald MacLeod Boyd Dr M.B.Ch.B. male   sp.r.2016-05-05 81 party:2893 Christian Party "Proclaiming Christ's Lordship" gss:S17000011     http://www.ukchristianparty.org/scottish-annual-conference-and-agm1.html http://www.donaldboyd.org/     https://static-candidates.democracyclub.org.uk/media/images/5516b1f4929f1bbe286be023.png   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 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000013     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 1 1         PP90   0
13941 4033 Charles Dundas     male 1978-07-19 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000012     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 1 6         PP90   0
13942 4075 Graham Simpson     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000009   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   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 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000013     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 1 5         PP52   0
13944 4246 Alexander Burnett     male 1973-07-30 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000014     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 1 2         PP52   0
13945 4288 John Erskine     male   sp.r.2016-05-05 81 party:53 Labour Party gss:S17000011     http://www.labour.org.uk/people/detail/john-erskine http://www.johnerskine.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5481e7c5b150e238702c0569.png       2016-05-05 0 1 6 13022.0       PP53   0
13946 4324 Lesley Brennan     female 1972.0 sp.r.2016-05-05 81 party:53 Labour Party gss:S17000014     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       2016-05-05 0 1 3         PP53   0
13947 4384 Sean Morton     male   sp.r.2016-05-05 81 party:53 Labour Party gss:S17000011     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 1 4 22394.0       PP53   0
13948 4441 Johanna Boyd     female   sp.r.2016-05-05 81 party:53 Labour Party gss:S17000013       http://johannaboyd.com/     https://static-candidates.democracyclub.org.uk/media/images/5519d82cba7512a07da47942.png   RodBegbie   2016-05-05 0 1 6         PP53   0
13949 4681 Ettie Spencer     female   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000015     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 1 3         PP90   0
13950 4851 Caroline Santos     female   sp.r.2016-05-05 81 party:85 UK Independence Party (UKIP) gss:S17000015             https://static-candidates.democracyclub.org.uk/media/images/5525eed3413cb4432adffa50.png   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   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000015     https://greens.scot/region/south-of-scotland https://sarahbeattiesmith.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/images/4993.png   ayrshiregreens   2016-05-05 0 1 1         PP130   0
13952 4995 Paul McGarry Mr   male   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000009     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 1 1 7525;21145       PP90   0
13953 5004 Jason Rose     male   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000015     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   kdcm87 https://www.facebook.com/jasonrosegreen 2016-05-05 0 1 6         PP130   0
13954 5036 Lee Lyons     Male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000015     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 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000015     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 1 4         PP52   0
13956 5042 James Reekie     Male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000013     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 1 6         PP52   0
13957 5044 Gordon Lindhurst     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000012   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   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   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000009   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   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 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000014     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 1 8         PP52   0
13960 5047 Dave Dempsey     male 1951-09-18 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000013     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   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000011   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   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 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000010     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 1 8         PP52   0
13963 5051 Michelle Ballantyne     female   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000015     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 1 6 8104.0       PP52   0
13964 5053 Alex Allison     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000015     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 1 7         PP52   0
13965 5139 Alexander Stewart     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000013   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   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 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000012     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   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000016     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   sp.r.2016-05-05 81 party:2871 RISE - Respect, Independence, Socialism and Environmentalism gss:S17000016       http://sandrawebster.info/ https://en.wikipedia.org/wiki/Sandra_Webster   https://static-candidates.democracyclub.org.uk/media/images/553bd0feec0766d3759c0462.png   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 sp.r.2016-05-05 81 party:85 UK Independence Party (UKIP) gss:S17000011       https://www.davidcoburnmep.co.uk/ http://en.wikipedia.org/wiki/David_Coburn_(politician)   https://static-candidates.democracyclub.org.uk/media/images/5526919d59bbc5c063445baf.png   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 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000014     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 1 5 7693.0       PP90   0
13971 5367 Ross Greer     male 1994-06-01 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000016   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   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   sp.r.2016-05-05 81 party:53 Labour Party gss:S17000015             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 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000014     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 1 7 8249.0       PP90   0
13974 5522 Bill Bowman     male 1950-05-30 sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000014     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 1 6         PP52   0
13975 5764 Suzanne McLaughlin     female   sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000010                     2016-05-05 0 1 7         PP102   0
13976 5773 Patricia Black     female   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000012     http://www.edinburghgreens.org.uk/site/westminster-2015/       https://static-candidates.democracyclub.org.uk/media/images/553b49b27b9de399275bb48e.png   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   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000010     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 1 4 7638.0       PP52   0
13978 5901 Nicola Ross     female   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000014     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 1 7         PP52   0
13979 6005 Andy Morrison     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000009     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 1 4         PP52   0
13980 6009 Annie Wells     female   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000010   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   TimPatmore Facebook page picture 2016-05-05 0 1 2         PP52   0
13981 6011 Sharon McGonigal     Female   sp.r.2016-05-05 81 party:85 UK Independence Party (UKIP) gss:S17000016             https://static-candidates.democracyclub.org.uk/media/images/553c979442c427035c8db3e7.png   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 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000010     http://www.scottishgreens.org.uk/westminster2015-2/       https://static-candidates.democracyclub.org.uk/media/images/553c983341b868785b1fe674.png   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   sp.r.2016-05-05 81 party:102 Scottish National Party (SNP) gss:S17000015   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   jamesm3 http://www.emmaharper.scot/ 2016-05-05 0 1 4         PP102   0
13984 6077 Isla O'Reilly     Female 1979-12-18 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000011     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 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000013     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 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000010     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   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   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000010     http://www.scottishgreens.org.uk/westminster2015-2/       https://static-candidates.democracyclub.org.uk/media/images/553c2fd062bbab35264e7acd.png   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   sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000011     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 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000016     http://www.scottishgreens.org.uk/westminster2015-2/               2016-05-05 0 1 7 13050.0       PP130   0
13990 6149 John Anderson     male   sp.r.2016-05-05 81 party:52 Conservative and Unionist Party gss:S17000010     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 1 5         PP52   0
13991 6239 Dan Yeats     male 1982-05-29 sp.r.2016-05-05 81 party:130 Scottish Green Party gss:S17000014     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     Auto imported from Twitter 2016-05-05 0 1 2         PP130   0
13992 6300 Euan Davidson     male 1994-07-07 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000014     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 1 6 8248.0       PP90   0
13993 6302 James Harrison     male 1990-03-03 sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000010     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 1 4 8357.0       PP90   0
13994 6304 Martin Veart     male   sp.r.2016-05-05 81 party:90 Liberal Democrats gss:S17000012     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 1 5         PP90   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 10.714ms · Data license: CC-BY-SA · Data source: Democracy Club