home / democracyclub

candidates

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

89 rows where election = 89

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_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
14710 14710 379 Lynnette Kelly     female   local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001229 Sherbourne   1.0 http://www.labour.org.uk/people/detail/lynnette-kelly       https://static-candidates.democracyclub.org.uk/media/images/5481e8a9b150e238702c05eb.png   profile-photo     2016-05-05 0 0   4458;11828       PP53   0
14711 14711 606 Mark Taylor     male   local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001220 Cheylesmore             https://static-candidates.democracyclub.org.uk/media/images/553ca113deda58bc5cca66eb.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/MarkTaylorUKIP 2016-05-05 0 0   11758.0       PP52   0
14712 14712 700 Stephen Gray Mr   male   local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001229 Sherbourne     https://my.greenparty.org.uk/candidates/105904 http://greenchristian.co.uk/               2016-05-05 0 0   11826.0       PP63   0
14713 14713 842 Russell Field     male 1971.0 local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001230 Upper Stoke     http://www.libdems.org.uk/russellfield       https://static-candidates.democracyclub.org.uk/media/images/55489b374b5e770f130e5ab4.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/russellfield 2016-05-05 0 0   11835.0       PP90   0
14714 14714 851 Dave Nellist     male 1952-07-16 local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001228 St Michael's       http://coventrysocialists.com/ https://en.wikipedia.org/wiki/Dave_Nellist   https://static-candidates.democracyclub.org.uk/media/images/54beddb25a9c3744778f9b75.png         2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/18584 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/18584 PP804   0
14715 14715 1438 Judy Griffiths     female   local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001220 Cheylesmore       http://coventrysocialists.com/     https://static-candidates.democracyclub.org.uk/media/images/55046ea6ba680dc746e7d5c3.png   public-domain CoventrySocialists   2016-05-05 0 0           PP804   0
14716 14716 1654 Jayne Innes     female   local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001233 Whoberley   1.0                   2016-05-05 0 0   11850.0       PP53   0
14717 14717 2341 William Sidhu Mr   male   local.coventry.2016-05-05 89 party:839 Christian Movement for Great Britain MTW:E05001222 Foleshill                       2016-05-05 0 0   7303;40520       PP839   0
14718 14718 5457 Gary Ridley     male   local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001234 Woodlands     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ridley_Gary.aspx     http://uk.linkedin.com/pub/gary-ridley/5a/b52/695/en https://static-candidates.democracyclub.org.uk/media/images/550855297a8b511079bc5bcf.png         2016-05-05 0 0   841;11866       PP52   0
14719 14719 6695 Laura Katherine Vesty     Female 1979-04-26 local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001230 Upper Stoke     https://my.greenparty.org.uk/candidates/105904       https://static-candidates.democracyclub.org.uk/media/images/551a8cfbe2ac8b7333e6a266.png   public-domain lauravesty   2016-05-05 0 0   11839.0       PP63   0
14720 14720 7925 Dave Toulson Dr   male   local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001221 Earlsdon                       2016-05-05 0 0           PP53   0
14721 14721 11740 Dan Crowter         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001218 Bablake                       2016-05-05 0 0           PP804   0
14722 14722 11741 Alan Thomas East         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001218 Bablake                       2016-05-05 0 0           PP53   0
14723 14723 11742 Tony Middleton Mr       local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001218 Bablake                       2016-05-05 0 0           PP85   0
14724 14724 11743 Walter William Milner         local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001218 Bablake                       2016-05-05 0 0           PP63   0
14725 14725 11744 Glenn Michael Williams         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001218 Bablake   1.0                   2016-05-05 0 0           PP52   0
14726 14726 11748 Dave Feetenby         local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP63   0
14727 14727 11749 Terri-Jay Hersey         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP804   0
14728 14728 11750 Colin Aldous Stubbs         local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP85   0
14729 14729 11751 Christine Elizabeth Thomas         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001219 Binley and Willenhall   1.0                   2016-05-05 0 0           PP53   0
14730 14730 11752 Sundeep Singh Virk         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP52   0
14731 14731 11756 Rois Ali         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001220 Cheylesmore   1.0                   2016-05-05 0 0           PP53   0
14732 14732 11757 Jonathan Howard Idle         local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001220 Cheylesmore                       2016-05-05 0 0           PP63   0
14733 14733 11764 Balvinder Dhanjal         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001222 Foleshill                       2016-05-05 0 0           PP53   0
14734 14734 11765 Simon Evans         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001222 Foleshill                       2016-05-05 0 0           PP804   0
14735 14735 11766 Bhagwant Singh Pandher         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001222 Foleshill                       2016-05-05 0 0           PP52   0
14736 14736 11767 David Neil Priestley Mr       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001222 Foleshill                       2016-05-05 0 0           PP63   0
14737 14737 11796 Jamie Edgar         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001223 Henley                       2016-05-05 0 0           PP804   0
14738 14738 11797 Ian Arthur Rogers Mr       local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001223 Henley                       2016-05-05 0 0           PP85   0
14739 14739 11798 Ed Ruane         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001223 Henley   1.0                   2016-05-05 0 0           PP53   0
14740 14740 11799 Tessa Eveline Charlotte Steenks         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001223 Henley                       2016-05-05 0 0           PP52   0
14741 14741 11800 Cathy Wattebot Ms   female   local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001223 Henley           https://uk.linkedin.com/in/cathy-wattebot-a6257495 https://static-candidates.democracyclub.org.uk/media/images/images/11800.png   public-domain baluut   2016-05-05 0 0           PP63   0
14742 14742 11801 Paul David Andrew         local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001224 Holbrook                       2016-05-05 0 0           PP63   0
14743 14743 11802 Satveer Singh Bhamra         local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001224 Holbrook                       2016-05-05 0 0           PP85   0
14744 14744 11803 Rachel Elizabeth Lancaster         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001224 Holbrook   1.0                   2016-05-05 0 0           PP53   0
14745 14745 11804 Deepak Robinson         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001224 Holbrook                       2016-05-05 0 0           PP52   0
14746 14746 11805 Ryan Rochester         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001224 Holbrook                       2016-05-05 0 0           PP804   0
14747 14747 11806 Chantelle Louise Coombes         local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001225 Longford                       2016-05-05 0 0           PP85   0
14748 14748 11807 George Arthur Duggins         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001225 Longford   1.0                   2016-05-05 0 0           PP53   0
14749 14749 11808 Merle Ross Gering Mr       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001225 Longford                       2016-05-05 0 0   16836.0       PP63   0
14750 14750 11809 Tarlochan Singh Jandu Mr       local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001225 Longford     https://www.coventryconservatives.com/people/tarlochan-singh-jandu-candidate-holbrook-ward-may-2018     https://uk.linkedin.com/in/tarlochan-jandu-05591731           2016-05-05 0 0           PP52   0
14751 14751 11810 Jordan Jefferies         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001225 Longford                       2016-05-05 0 0           PP804   0
14752 14752 11816 Mike Ballinger         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001226 Lower Stoke       https://www.coventryconservatives.com/people/mike-ballinger-candidate-earlsdon-ward-may-2018   https://uk.linkedin.com/in/mike-ballinger-b535a533           2016-05-05 0 0           PP52   0
14753 14753 11817 Christopher Mark Glenn         local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001226 Lower Stoke                       2016-05-05 0 0           PP90   0
14754 14754 11818 Rob McArdle Mr       local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001226 Lower Stoke                       2016-05-05 0 0           PP804   0
14755 14755 11819 Catherine Elizabeth Miks         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001226 Lower Stoke   1.0                   2016-05-05 0 0           PP53   0
14756 14756 11820 Esther Mary Reeves Mrs       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001226 Lower Stoke                       2016-05-05 0 0           PP63   0
14757 14757 11821 Dave Anderson Mr       local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001227 Radford                       2016-05-05 0 0           PP804   0
14758 14758 11822 Gavin Lee Collins         local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001227 Radford                       2016-05-05 0 0           PP63   0
14759 14759 11823 Asha Masih Ms       local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001227 Radford             https://static-candidates.democracyclub.org.uk/media/images/images/11823.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=952962392010448897 2016-05-05 0 0           PP52   0
14760 14760 11824 Mal Mutton         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001227 Radford   1.0                   2016-05-05 0 0           PP53   0
14761 14761 11825 Matthew Batson Mr       local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP85   0
14762 14762 11827 Jim Hensman         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP804   0
14763 14763 11829 Jim Simpson         local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP90   0
14764 14764 11830 Stefan Spalatelu         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP52   0
14765 14765 11831 Naeem Akhtar         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001228 St Michael's   1.0                   2016-05-05 0 0           PP53   0
14766 14766 11832 Aimee Challenor     Female 1997-10-01 local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001228 St Michael's       https://aimee2018.uk   https://uk.linkedin.com/in/aimeechallenor https://static-candidates.democracyclub.org.uk/media/images/images/11832_91iUo2t.png   profile-photo GPEWAimee I am the candidate. 2016-05-05 0 0           PP63 Chocolate Chip Cookie 0
14767 14767 11833 Christopher Michael Noonan Mr       local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001228 St Michael's           https://uk.linkedin.com/in/christopher-noonan-637a0876           2016-05-05 0 0           PP52   0
14768 14768 11834 Kamran Asif Caan         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001230 Upper Stoke   1.0                   2016-05-05 0 0           PP53   0
14769 14769 11836 Marcus Luke Paris Fogden         local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001230 Upper Stoke                       2016-05-05 0 0           PP85   0
14770 14770 11837 Jagmohan Singh         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001230 Upper Stoke                       2016-05-05 0 0           PP52   0
14771 14771 11838 Paul Smith         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001230 Upper Stoke                       2016-05-05 0 0           PP804   0
14772 14772 11840 John Anthony Blundell         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001231 Wainbody   1.0                   2016-05-05 0 0           PP52   0
14773 14773 11841 Abdul Jobbar Mr       local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001231 Wainbody             https://static-candidates.democracyclub.org.uk/media/images/images/11841.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=3014502778 2016-05-05 0 0           PP53   0
14774 14774 11842 Gilbert Napier Penlington         local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001231 Wainbody                       2016-05-05 0 0           PP90   0
14775 14775 11843 Ian Wardle         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001231 Wainbody                       2016-05-05 0 0           PP804   0
14776 14776 11844 Niall Webb Mr       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001231 Wainbody                       2016-05-05 0 0           PP63   0
14777 14777 11845 Maya Ali Ms       local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001232 Westwood           https://uk.linkedin.com/in/cllr-maya-ali-b0a529117           2016-05-05 0 0           PP53   0
14778 14778 11846 Jim Donnelly         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001232 Westwood                       2016-05-05 0 0           PP804   0
14779 14779 11847 Jess Marshall Ms       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001232 Westwood                       2016-05-05 0 0           PP63   0
14780 14780 11848 Tim Mayer     male   local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001232 Westwood   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11848.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
14781 14781 11849 Rich Groves         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001233 Whoberley                       2016-05-05 0 0           PP804   0
14782 14782 11851 Steven Keough Mr       local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001233 Whoberley           https://uk.linkedin.com/in/steven-keough-0343029b           2016-05-05 0 0           PP52   0
14783 14783 11852 Brian Rees Lewis         local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001233 Whoberley                       2016-05-05 0 0           PP90   0
14784 14784 11853 Anne Patterson Mrs       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001233 Whoberley                       2016-05-05 0 0           PP63   0
14785 14785 11864 Patricia Maria Hetherton Ms       local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001234 Woodlands           https://uk.linkedin.com/in/patricia-hetherton-12570b51           2016-05-05 0 0           PP53   0
14786 14786 11865 Andy Hilton Mr   male   local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001234 Woodlands     https://www.libdems.org.uk/andy_hilton       https://static-candidates.democracyclub.org.uk/media/images/images/11865.png   profile-photo sjorford https://www.facebook.com/pg/Andy4CovNW/ 2016-05-05 0 0           PP90   0
14787 14787 11867 Sarah Smith         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001234 Woodlands                       2016-05-05 0 0           PP804   0
14788 14788 11868 Joy Annette Warren Mrs       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001234 Woodlands             https://static-candidates.democracyclub.org.uk/media/images/images/11868.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=127630661 2016-05-05 0 0           PP63   0
14789 14789 11869 Stuart Raymond Coles         local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001235 Wyken                       2016-05-05 0 0           PP90   0
14790 14790 11870 Greg Crabb         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001235 Wyken                       2016-05-05 0 0           PP804   0
14791 14791 11871 Malcolm Scott         local.coventry.2016-05-05 89 party:85 UK Independence Party (UKIP) MTW:E05001235 Wyken                       2016-05-05 0 0           PP85   0
14792 14792 11872 Myooran Sri         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001235 Wyken                       2016-05-05 0 0           PP52   0
14793 14793 11873 Robert Richard Thay         local.coventry.2016-05-05 89 party:53 Labour Party MTW:E05001235 Wyken                       2016-05-05 0 0           PP53   0
14794 14794 11874 Joe Williams         local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001235 Wyken                       2016-05-05 0 0           PP63   0
14795 14795 18861 Allan Robert Andrews         local.coventry.2016-05-05 89 party:52 Conservative and Unionist Party MTW:E05001221 Earlsdon   1.0                   2016-05-05 0 0           PP52   0
14796 14796 18862 Jacqueline Bridget Basu         local.coventry.2016-05-05 89 party:90 Liberal Democrats MTW:E05001221 Earlsdon                       2016-05-05 0 0           PP90   0
14797 14797 18863 Kieran Gangaram         local.coventry.2016-05-05 89 party:804 Trade Unionist and Socialist Coalition MTW:E05001221 Earlsdon                       2016-05-05 0 0           PP804   0
14798 14798 18864 Scott Gordon Redding Mr       local.coventry.2016-05-05 89 party:63 Green Party MTW:E05001221 Earlsdon           https://uk.linkedin.com/in/scott-redding-99434794 https://static-candidates.democracyclub.org.uk/media/images/images/18864.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=16647735 2016-05-05 0 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.45ms · Data license: CC-BY-SA · Data source: Democracy Club