home / democracyclub

democracyclub

Custom SQL query returning 89 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
14710 379 Lynnette Kelly     female   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 606 Mark Taylor     male   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 700 Stephen Gray Mr   male   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 842 Russell Field     male 1971.0 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 851 Dave Nellist     male 1952-07-16 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 1438 Judy Griffiths     female   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 1654 Jayne Innes     female   89 party:53 Labour Party MTW:E05001233 Whoberley   1.0                   2016-05-05 0 0   11850.0       PP53   0
14717 2341 William Sidhu Mr   male   89 party:839 Christian Movement for Great Britain MTW:E05001222 Foleshill                       2016-05-05 0 0   7303;40520       PP839   0
14718 5457 Gary Ridley     male   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 6695 Laura Katherine Vesty     Female 1979-04-26 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 7925 Dave Toulson Dr   male   89 party:53 Labour Party MTW:E05001221 Earlsdon                       2016-05-05 0 0           PP53   0
14721 11740 Dan Crowter         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001218 Bablake                       2016-05-05 0 0           PP804   0
14722 11741 Alan Thomas East         89 party:53 Labour Party MTW:E05001218 Bablake                       2016-05-05 0 0           PP53   0
14723 11742 Tony Middleton Mr       89 party:85 UK Independence Party (UKIP) MTW:E05001218 Bablake                       2016-05-05 0 0           PP85   0
14724 11743 Walter William Milner         89 party:63 Green Party MTW:E05001218 Bablake                       2016-05-05 0 0           PP63   0
14725 11744 Glenn Michael Williams         89 party:52 Conservative and Unionist Party MTW:E05001218 Bablake   1.0                   2016-05-05 0 0           PP52   0
14726 11748 Dave Feetenby         89 party:63 Green Party MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP63   0
14727 11749 Terri-Jay Hersey         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP804   0
14728 11750 Colin Aldous Stubbs         89 party:85 UK Independence Party (UKIP) MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP85   0
14729 11751 Christine Elizabeth Thomas         89 party:53 Labour Party MTW:E05001219 Binley and Willenhall   1.0                   2016-05-05 0 0           PP53   0
14730 11752 Sundeep Singh Virk         89 party:52 Conservative and Unionist Party MTW:E05001219 Binley and Willenhall                       2016-05-05 0 0           PP52   0
14731 11756 Rois Ali         89 party:53 Labour Party MTW:E05001220 Cheylesmore   1.0                   2016-05-05 0 0           PP53   0
14732 11757 Jonathan Howard Idle         89 party:63 Green Party MTW:E05001220 Cheylesmore                       2016-05-05 0 0           PP63   0
14733 11764 Balvinder Dhanjal         89 party:53 Labour Party MTW:E05001222 Foleshill                       2016-05-05 0 0           PP53   0
14734 11765 Simon Evans         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001222 Foleshill                       2016-05-05 0 0           PP804   0
14735 11766 Bhagwant Singh Pandher         89 party:52 Conservative and Unionist Party MTW:E05001222 Foleshill                       2016-05-05 0 0           PP52   0
14736 11767 David Neil Priestley Mr       89 party:63 Green Party MTW:E05001222 Foleshill                       2016-05-05 0 0           PP63   0
14737 11796 Jamie Edgar         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001223 Henley                       2016-05-05 0 0           PP804   0
14738 11797 Ian Arthur Rogers Mr       89 party:85 UK Independence Party (UKIP) MTW:E05001223 Henley                       2016-05-05 0 0           PP85   0
14739 11798 Ed Ruane         89 party:53 Labour Party MTW:E05001223 Henley   1.0                   2016-05-05 0 0           PP53   0
14740 11799 Tessa Eveline Charlotte Steenks         89 party:52 Conservative and Unionist Party MTW:E05001223 Henley                       2016-05-05 0 0           PP52   0
14741 11800 Cathy Wattebot Ms   female   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 11801 Paul David Andrew         89 party:63 Green Party MTW:E05001224 Holbrook                       2016-05-05 0 0           PP63   0
14743 11802 Satveer Singh Bhamra         89 party:85 UK Independence Party (UKIP) MTW:E05001224 Holbrook                       2016-05-05 0 0           PP85   0
14744 11803 Rachel Elizabeth Lancaster         89 party:53 Labour Party MTW:E05001224 Holbrook   1.0                   2016-05-05 0 0           PP53   0
14745 11804 Deepak Robinson         89 party:52 Conservative and Unionist Party MTW:E05001224 Holbrook                       2016-05-05 0 0           PP52   0
14746 11805 Ryan Rochester         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001224 Holbrook                       2016-05-05 0 0           PP804   0
14747 11806 Chantelle Louise Coombes         89 party:85 UK Independence Party (UKIP) MTW:E05001225 Longford                       2016-05-05 0 0           PP85   0
14748 11807 George Arthur Duggins         89 party:53 Labour Party MTW:E05001225 Longford   1.0                   2016-05-05 0 0           PP53   0
14749 11808 Merle Ross Gering Mr       89 party:63 Green Party MTW:E05001225 Longford                       2016-05-05 0 0   16836.0       PP63   0
14750 11809 Tarlochan Singh Jandu Mr       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 11810 Jordan Jefferies         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001225 Longford                       2016-05-05 0 0           PP804   0
14752 11816 Mike Ballinger         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 11817 Christopher Mark Glenn         89 party:90 Liberal Democrats MTW:E05001226 Lower Stoke                       2016-05-05 0 0           PP90   0
14754 11818 Rob McArdle Mr       89 party:804 Trade Unionist and Socialist Coalition MTW:E05001226 Lower Stoke                       2016-05-05 0 0           PP804   0
14755 11819 Catherine Elizabeth Miks         89 party:53 Labour Party MTW:E05001226 Lower Stoke   1.0                   2016-05-05 0 0           PP53   0
14756 11820 Esther Mary Reeves Mrs       89 party:63 Green Party MTW:E05001226 Lower Stoke                       2016-05-05 0 0           PP63   0
14757 11821 Dave Anderson Mr       89 party:804 Trade Unionist and Socialist Coalition MTW:E05001227 Radford                       2016-05-05 0 0           PP804   0
14758 11822 Gavin Lee Collins         89 party:63 Green Party MTW:E05001227 Radford                       2016-05-05 0 0           PP63   0
14759 11823 Asha Masih Ms       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 11824 Mal Mutton         89 party:53 Labour Party MTW:E05001227 Radford   1.0                   2016-05-05 0 0           PP53   0
14761 11825 Matthew Batson Mr       89 party:85 UK Independence Party (UKIP) MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP85   0
14762 11827 Jim Hensman         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP804   0
14763 11829 Jim Simpson         89 party:90 Liberal Democrats MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP90   0
14764 11830 Stefan Spalatelu         89 party:52 Conservative and Unionist Party MTW:E05001229 Sherbourne                       2016-05-05 0 0           PP52   0
14765 11831 Naeem Akhtar         89 party:53 Labour Party MTW:E05001228 St Michael's   1.0                   2016-05-05 0 0           PP53   0
14766 11832 Aimee Challenor     Female 1997-10-01 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 11833 Christopher Michael Noonan Mr       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 11834 Kamran Asif Caan         89 party:53 Labour Party MTW:E05001230 Upper Stoke   1.0                   2016-05-05 0 0           PP53   0
14769 11836 Marcus Luke Paris Fogden         89 party:85 UK Independence Party (UKIP) MTW:E05001230 Upper Stoke                       2016-05-05 0 0           PP85   0
14770 11837 Jagmohan Singh         89 party:52 Conservative and Unionist Party MTW:E05001230 Upper Stoke                       2016-05-05 0 0           PP52   0
14771 11838 Paul Smith         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001230 Upper Stoke                       2016-05-05 0 0           PP804   0
14772 11840 John Anthony Blundell         89 party:52 Conservative and Unionist Party MTW:E05001231 Wainbody   1.0                   2016-05-05 0 0           PP52   0
14773 11841 Abdul Jobbar Mr       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 11842 Gilbert Napier Penlington         89 party:90 Liberal Democrats MTW:E05001231 Wainbody                       2016-05-05 0 0           PP90   0
14775 11843 Ian Wardle         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001231 Wainbody                       2016-05-05 0 0           PP804   0
14776 11844 Niall Webb Mr       89 party:63 Green Party MTW:E05001231 Wainbody                       2016-05-05 0 0           PP63   0
14777 11845 Maya Ali Ms       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 11846 Jim Donnelly         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001232 Westwood                       2016-05-05 0 0           PP804   0
14779 11847 Jess Marshall Ms       89 party:63 Green Party MTW:E05001232 Westwood                       2016-05-05 0 0           PP63   0
14780 11848 Tim Mayer     male   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 11849 Rich Groves         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001233 Whoberley                       2016-05-05 0 0           PP804   0
14782 11851 Steven Keough Mr       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 11852 Brian Rees Lewis         89 party:90 Liberal Democrats MTW:E05001233 Whoberley                       2016-05-05 0 0           PP90   0
14784 11853 Anne Patterson Mrs       89 party:63 Green Party MTW:E05001233 Whoberley                       2016-05-05 0 0           PP63   0
14785 11864 Patricia Maria Hetherton Ms       89 party:53 Labour Party MTW:E05001234 Woodlands           https://uk.linkedin.com/in/patricia-hetherton-12570b51           2016-05-05 0 0           PP53   0
14786 11865 Andy Hilton Mr   male   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 11867 Sarah Smith         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001234 Woodlands                       2016-05-05 0 0           PP804   0
14788 11868 Joy Annette Warren Mrs       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 11869 Stuart Raymond Coles         89 party:90 Liberal Democrats MTW:E05001235 Wyken                       2016-05-05 0 0           PP90   0
14790 11870 Greg Crabb         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001235 Wyken                       2016-05-05 0 0           PP804   0
14791 11871 Malcolm Scott         89 party:85 UK Independence Party (UKIP) MTW:E05001235 Wyken                       2016-05-05 0 0           PP85   0
14792 11872 Myooran Sri         89 party:52 Conservative and Unionist Party MTW:E05001235 Wyken                       2016-05-05 0 0           PP52   0
14793 11873 Robert Richard Thay         89 party:53 Labour Party MTW:E05001235 Wyken                       2016-05-05 0 0           PP53   0
14794 11874 Joe Williams         89 party:63 Green Party MTW:E05001235 Wyken                       2016-05-05 0 0           PP63   0
14795 18861 Allan Robert Andrews         89 party:52 Conservative and Unionist Party MTW:E05001221 Earlsdon   1.0                   2016-05-05 0 0           PP52   0
14796 18862 Jacqueline Bridget Basu         89 party:90 Liberal Democrats MTW:E05001221 Earlsdon                       2016-05-05 0 0           PP90   0
14797 18863 Kieran Gangaram         89 party:804 Trade Unionist and Socialist Coalition MTW:E05001221 Earlsdon                       2016-05-05 0 0           PP804   0
14798 18864 Scott Gordon Redding Mr       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
Powered by Datasette · Query took 1.054ms