home / democracyclub

candidates

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

89 rows where election = 52

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, homepage_url, linkedin_url, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id post_label 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
11746 11746 1359 Jack Easton Mr   male   local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004800 St Stephen     https://stalbans.greenparty.org.uk/news/2017/04/28/jack-easton-selected-as-general-election-candidate/ https://stalbans.greenparty.org.uk/   https://www.linkedin.com/in/jack-easton-65a7a057/ https://static-candidates.democracyclub.org.uk/media/images/images/1359.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1444635962 2016-05-05 0 0   26599.0       PP63   0
11747 11747 7797 Chris White Mr   male   local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004787 Clarence   1.0 http://www.libdems.org.uk/chris_white http://chriswhite.mycouncillor.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7797.png   profile-photo petersteadman http://www.libdems.org.uk/chris_white - libdem candidate page 2016-05-05 0 0   15759.0       PP90   0
11748 11748 11392 David John Yates Mr   Male 1954-05-29 local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004797 Park Street   1.0       https://www.linkedin.com/in/davidjyates https://static-candidates.democracyclub.org.uk/media/images/images/11392.png   copyright-assigned cllr.d.yates@stalbans.gov.uk   2016-05-05 0 0           PP90   0
11749 11749 13903 Richard Patrick Curthoys         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004796 Marshalswick South   1.0                   2016-05-05 0 0           PP52   0
11750 11750 13904 David Francis Dickson         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004796 Marshalswick South                       2016-05-05 0 0           PP85   0
11751 11751 13905 John Hale         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004796 Marshalswick South                       2016-05-05 0 0   26558.0       PP90   0
11752 11752 13906 Richard George Harris         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004796 Marshalswick South                       2016-05-05 0 0           PP53   0
11753 11753 13907 Jill Mills         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004796 Marshalswick South                       2016-05-05 0 0           PP63   0
11754 11754 13970 Robert Anthony Dunster     male   local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004785 Ashley                       2016-05-05 0 0           PP52   0
11755 11755 13971 Lydia El-Khouri         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004785 Ashley                       2016-05-05 0 0           PP63   0
11756 11756 13972 Matt Farrell         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004785 Ashley   1.0                   2016-05-05 0 0           PP90   0
11757 11757 13973 Charles Michael Mason     male   local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004785 Ashley                       2016-05-05 0 0           PP85   0
11758 11758 13974 Momotaz Rahim         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004785 Ashley                       2016-05-05 0 0           PP53   0
11759 11759 15027 Jennifer Corsbie         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP85   0
11760 11760 15028 Michael Philip Gray-Higgins         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP53   0
11761 11761 15029 Anna Meg Kinnersley         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP63   0
11762 11762 15030 Jeffrey Kyndon Phillips         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP90   0
11763 11763 15031 Matthew David Stephens         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004793 Harpenden West   1.0                   2016-05-05 0 0           PP52   0
11764 11764 15742 Scott Clyne         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004786 Batchwood                       2016-05-05 0 0           PP52   0
11765 11765 15743 Matthew Dovey         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004786 Batchwood                       2016-05-05 0 0           PP85   0
11766 11766 15744 Ellie Hudspith         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004786 Batchwood                       2016-05-05 0 0           PP90   0
11767 11767 15745 Mal Pakenham         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004786 Batchwood   1.0                   2016-05-05 0 0           PP53   0
11768 11768 15755 Keith Brian Hussey         local.st-albans.2016-05-05 52 party:804 Trade Unionist and Socialist Coalition DIW:E05004787 Clarence                       2016-05-05 0 0           PP804   0
11769 11769 15756 Liz Mills         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004787 Clarence                       2016-05-05 0 0           PP53   0
11770 11770 15757 Tim Robinson         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004787 Clarence                       2016-05-05 0 0           PP63   0
11771 11771 15758 Barry Paul Sumpter         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004787 Clarence                       2016-05-05 0 0           PP52   0
11772 11772 15760 Geoff Harrison         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004789 Cunningham   1.0                   2016-05-05 0 0           PP90   0
11773 11773 15761 Alan Robert Malin         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004789 Cunningham                       2016-05-05 0 0           PP85   0
11774 11774 15762 John Paton         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004789 Cunningham                       2016-05-05 0 0   26585.0       PP53   0
11775 11775 15763 Gregory Scott Riener         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004789 Cunningham                       2016-05-05 0 0           PP63   0
11776 11776 15764 Nadine Standish     female   local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004789 Cunningham                       2016-05-05 0 0           PP52   0
11777 11777 15770 Paul David De Kort         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004790 Harpenden East                       2016-05-05 0 0           PP90   0
11778 11778 15771 Rosemary Anne Farmer         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004790 Harpenden East   1.0                   2016-05-05 0 0           PP52   0
11779 11779 15773 Lester MacKenzie         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004790 Harpenden East                       2016-05-05 0 0           PP85   0
11780 11780 15774 Rosemary Elsbeth Ross         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004790 Harpenden East                       2016-05-05 0 0           PP53   0
11781 11781 15781 John Hansen         local.st-albans.2016-05-05 52 ynmp-party:2 Independent DIW:E05004791 Harpenden North                       2016-05-05 0 0           ynmp-party:2   0
11782 11782 15782 Stephen John Hodgson Mr BEng (Hons) ACA CTA Male   local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004791 Harpenden North   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/15782.png   profile-photo sjhodgson I am the candidate 2016-05-05 0 0           PP52   0
11783 11783 15783 Stephen Andrew Hughes         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004791 Harpenden North                       2016-05-05 0 0           PP85   0
11784 11784 15784 Aileen Margaret King         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004791 Harpenden North                       2016-05-05 0 0           PP90   0
11785 11785 15785 Linda Ann Spiri         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004791 Harpenden North                       2016-05-05 0 0           PP53   0
11786 11786 15786 George Murray Fraser     male   local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP53   0
11787 11787 15787 Mick Hawkes         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP85   0
11788 11788 15788 David Peter Heritage         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004792 Harpenden South   1.0                   2016-05-05 0 0           PP52   0
11789 11789 15789 Maria Louise Moyses         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP90   0
11790 11790 15790 Suheil Shahryar         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP63   0
11791 11791 15795 Patrick Alderman         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004794 London Colney                       2016-05-05 0 0           PP52   0
11792 11792 15796 Dreda Gordon         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004794 London Colney   1.0                   2016-05-05 0 0           PP53   0
11793 11793 15797 Jessica Frances Kay Halliday         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004794 London Colney                       2016-05-05 0 0           PP90   0
11794 11794 15798 James Richard Lomas         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004794 London Colney                       2016-05-05 0 0           PP63   0
11795 11795 15799 John Midgley         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004794 London Colney                       2016-05-05 0 0           PP85   0
11796 11796 15805 Janet Churchard         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004795 Marshalswick North   1.0                   2016-05-05 0 0           PP90   0
11797 11797 15806 Claudio Duran     male   local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004795 Marshalswick North           https://uk.linkedin.com/in/g-claudio-duran-38286b20           2016-05-05 0 0           PP52   0
11798 11798 15807 Claire Gilbert         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004795 Marshalswick North                       2016-05-05 0 0           PP63   0
11799 11799 15808 Michael David Hollins         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004795 Marshalswick North                       2016-05-05 0 0           PP85   0
11800 11800 15809 Paul Francis Walker         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004795 Marshalswick North                       2016-05-05 0 0           PP53   0
11801 11801 15822 Linda Lennard         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004797 Park Street                       2016-05-05 0 0           PP63   0
11802 11802 15823 Martin Gerard McGrath         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004797 Park Street                       2016-05-05 0 0           PP53   0
11803 11803 15824 Michael Brian Roth         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004797 Park Street                       2016-05-05 0 0           PP52   0
11804 11804 15825 Peter James Whitehead         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004797 Park Street                       2016-05-05 0 0           PP85   0
11805 11805 15826 Daragh Gerald Patrick Cahalane         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004798 Redbourn                       2016-05-05 0 0           PP85   0
11806 11806 15827 Maria Bridget Theresa Maynard         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004798 Redbourn                       2016-05-05 0 0           PP52   0
11807 11807 15828 Anthony Eric Neville         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004798 Redbourn                       2016-05-05 0 0           PP53   0
11808 11808 15829 Tony Swendell         local.st-albans.2016-05-05 52 ynmp-party:2 Independent DIW:E05004798 Redbourn   1.0                   2016-05-05 0 0           ynmp-party:2   0
11809 11809 15845 Valerie Linda Hargrave         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004802 Sopwell                       2016-05-05 0 0           PP85   0
11810 11810 15846 Gail Jackson         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004802 Sopwell                       2016-05-05 0 0           PP63   0
11811 11811 15847 Shakir Rahman     male   local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004802 Sopwell     http://www.stalbanslibdems.org.uk/sopwell     https://uk.linkedin.com/in/shakir-rahman-80498564 https://static-candidates.democracyclub.org.uk/media/images/images/15847.png   profile-photo mattl From http://www.stalbanslibdems.org.uk/election_team_2018 2016-05-05 0 0           PP90   0
11812 11812 15848 Heather Christine Rench         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004802 Sopwell                       2016-05-05 0 0           PP52   0
11813 11813 15849 Janet Smith         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004802 Sopwell   1.0                   2016-05-05 0 0           PP53   0
11814 11814 15856 Nick Bishop         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004799 St Peters                       2016-05-05 0 0           PP52   0
11815 11815 15857 Michael Douglas         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004799 St Peters                       2016-05-05 0 0           PP85   0
11816 11816 15858 Simon Grover     Male 1966.0 local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004799 St Peters   1.0 http://www.sagreens.org.uk                 2016-05-05 0 0   27109.0       PP63   0
11817 11817 15859 Matt Jones         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004799 St Peters                       2016-05-05 0 0           PP90   0
11818 11818 15860 Alex Veitch         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004799 St Peters                       2016-05-05 0 0           PP53   0
11819 11819 15861 Janet Elizabeth Blackwell         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004800 St Stephen                       2016-05-05 0 0           PP53   0
11820 11820 15862 Brian William Gibbard         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004800 St Stephen   1.0                   2016-05-05 0 0           PP52   0
11821 11821 15863 Tina Lomax         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004800 St Stephen                       2016-05-05 0 0           PP85   0
11822 11822 15864 Alison Ross     female   local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004800 St Stephen             https://static-candidates.democracyclub.org.uk/media/images/images/15864.png   profile-photo mattl From http://www.stalbanslibdems.org.uk/election_team_2018 2016-05-05 0 0           PP90   0
11823 11823 15865 Michael Bartlet         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004803 Verulam                       2016-05-05 0 0           PP53   0
11824 11824 15866 Chris Davies         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004803 Verulam   1.0                   2016-05-05 0 0           PP90   0
11825 11825 15867 Colin Stewart Donald         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004803 Verulam                       2016-05-05 0 0           PP85   0
11826 11826 15868 Mark Antony Ewington         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004803 Verulam                       2016-05-05 0 0           PP63   0
11827 11827 15869 Stella Maria Nita Nash         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004803 Verulam                       2016-05-05 0 0           PP52   0
11828 11828 15870 Gillian Mary Clark         local.st-albans.2016-05-05 52 party:52 Conservative and Unionist Party DIW:E05004804 Wheathampstead   1.0                   2016-05-05 0 0           PP52   0
11829 11829 15871 Beverley Rands         local.st-albans.2016-05-05 52 party:85 UK Independence Party (UKIP) DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP85   0
11830 11830 15872 Neill Sankey         local.st-albans.2016-05-05 52 party:53 Labour Party DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP53   0
11831 11831 15873 Harriet Sherlock         local.st-albans.2016-05-05 52 party:90 Liberal Democrats DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP90   0
11832 11832 15874 Ian Troughton         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP63   0
11833 11833 19425 Anne James     Female   local.st-albans.2016-05-05 52 ynmp-party:2 Independent DIW:E05004790 Harpenden East                       2016-05-05 0 0           ynmp-party:2   0
11834 11834 26600 Lesley Charlotte Baker         local.st-albans.2016-05-05 52 party:63 Green Party DIW:E05004786 Batchwood                       2016-05-05 0 0   15741.0       PP63   0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "candidates" (
"id" INTEGER,
  "name" TEXT,
  "honorific_prefix" REAL,
  "honorific_suffix" REAL,
  "gender" TEXT,
  "birth_date" REAL,
  "election" INTEGER,
  "party_id" TEXT,
  "party_name" TEXT,
  "post_id" TEXT,
  "post_label" TEXT,
  "mapit_url" INTEGER,
  "elected" REAL,
  "email" TEXT,
  "twitter_username" REAL,
  "facebook_page_url" REAL,
  "party_ppc_page_url" REAL,
  "facebook_personal_url" REAL,
  "homepage_url" REAL,
  "wikipedia_url" REAL,
  "linkedin_url" REAL,
  "image_url" REAL,
  "proxy_image_url_template" INTEGER,
  "image_copyright" REAL,
  "image_uploading_user" REAL,
  "image_uploading_user_notes" REAL,
  "twitter_user_id" INTEGER,
  "election_date" TEXT,
  "election_current" INTEGER,
  "party_lists_in_use" INTEGER,
  "party_list_position" INTEGER,
  "old_person_ids" REAL,
  "gss_code" INTEGER,
  "parlparse_id" REAL,
  "theyworkforyou_url" REAL,
  "party_ec_id" TEXT,
  "favourite_biscuits" REAL,
  "cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))
Powered by Datasette · Query took 9.155ms · Data license: CC-BY-SA · Data source: Democracy Club