home / democracyclub

democracyclub

Custom SQL query returning 80 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
10959 89 Mark Barlow     male   40 party:85 UK Independence Party (UKIP) DIW:E05006967 Chesterton                       2016-05-05 0 0   13784;37052       PP85   0
10960 3488 Peter Emil Andras     male   40 party:90 Liberal Democrats DIW:E05006981 Seabridge     http://www.libdems.org.uk/peter_andras https://andras-stoke.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/3488.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   13919.0       PP90   0
10961 5462 Ian Wilkes     male 1962-08-30 40 party:90 Liberal Democrats DIW:E05006964 Audley and Bignall End   1.0 http://www.libdems.org.uk/ian_wilkes http://www.newcastlelibdems.org.uk/ian-wilkes-for-newcastle/     https://static-candidates.democracyclub.org.uk/media/images/55474695a534c89955aeff6b.png   public-domain NuL_Lib_Dems This photo was taken from the Newcastle-under-Lyme Liberal Democrat webpage - I (the person uploading the photo) am a member of the Newcastle-under-Lyme Liberal Democrat executive committee and am currently designated as the parties webmaster. Please contact webmaster@newcastlelibdems.org.uk for confirmation if required. See: http://www.newcastlelibdems.org.uk/contacts/ 2016-05-05 0 0   13776;37039       PP90   0
10962 5907 Geoff Locke     Male   40 party:85 UK Independence Party (UKIP) DIW:E05006980 Ravenscliffe                       2016-05-05 0 0   1576;13863;37279       PP85   0
10963 6143 Sean Alexander Adam     Male 1956-03-22 40 party:63 Green Party DIW:E05006977 May Bank             https://static-candidates.democracyclub.org.uk/media/images/5516b2ae929f1bbe286be025.png   public-domain Jamatrad My wife and are a team and a team I am proud of. Without her I would not be able to take up my political beliefs formally 2016-05-05 0 0   13822;37365       PP63   0
10964 7031 Nigel Jones     Male 1944-12-11 40 party:90 Liberal Democrats DIW:E05006969 Cross Heath     http://www.libdems.org.uk/nigel_joneswn       https://static-candidates.democracyclub.org.uk/media/images/551a6869600f97ed464f28be.png   profile-photo Roythinkingaloud   2016-05-05 0 0   3657;13795       PP90   0
10965 13769 Anne Adam         40 party:63 Green Party DIW:E05006987 Wolstanton                       2016-05-05 0 0           PP63   0
10966 13770 David John Cooper         40 party:52 Conservative and Unionist Party DIW:E05006987 Wolstanton                       2016-05-05 0 0   37054.0       PP52   0
10967 13771 Eric Durber         40 party:90 Liberal Democrats DIW:E05006987 Wolstanton                       2016-05-05 0 0           PP90   0
10968 13772 Edward Arthur Evans         40 party:85 UK Independence Party (UKIP) DIW:E05006987 Wolstanton                       2016-05-05 0 0           PP85   0
10969 13773 Mark Joseph Olszewski         40 party:53 Labour Party DIW:E05006987 Wolstanton                       2016-05-05 0 0   37952.0       PP53   0
10970 13774 David Charles Cooper         40 party:52 Conservative and Unionist Party DIW:E05006964 Audley and Bignall End                       2016-05-05 0 0   37170.0       PP52   0
10971 13775 Sue Moffat         40 party:53 Labour Party DIW:E05006964 Audley and Bignall End                       2016-05-05 0 0   37035.0       PP53   0
10972 13777 Alan Robert Humphreys         40 party:52 Conservative and Unionist Party DIW:E05006965 Bradwell                       2016-05-05 0 0           PP52   0
10973 13778 Dave Jones     Male   40 joint-party:53-119 Labour and Co-operative Party DIW:E05006965 Bradwell   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13778.png   profile-photo kdcm87 https://twitter.com/DaveMazzJones 2016-05-05 0 0           joint-party:53-119   0
10974 13779 Wendy Rees         40 party:85 UK Independence Party (UKIP) DIW:E05006965 Bradwell                       2016-05-05 0 0           PP85   0
10975 13780 Richard Hugh Virr         40 party:90 Liberal Democrats DIW:E05006965 Bradwell                       2016-05-05 0 0   37047.0       PP90   0
10976 13781 Silvia Burgess         40 party:53 Labour Party DIW:E05006966 Butt Lane   1.0                   2016-05-05 0 0   37251.0       PP53   0
10977 13782 Pamela Jellyman         40 party:52 Conservative and Unionist Party DIW:E05006966 Butt Lane                       2016-05-05 0 0   37528.0       PP52   0
10978 13783 Ray Williams         40 party:85 UK Independence Party (UKIP) DIW:E05006966 Butt Lane                       2016-05-05 0 0           PP85   0
10979 13785 Angela Craig         40 party:804 Trade Unionist and Socialist Coalition DIW:E05006967 Chesterton                       2016-05-05 0 0           PP804   0
10980 13786 Allison Clare Elizabeth Gardner         40 party:53 Labour Party DIW:E05006967 Chesterton             https://static-candidates.democracyclub.org.uk/media/images/images/37055.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=17755776 2016-05-05 0 0   37055.0       PP53   0
10981 13787 Chris Moore         40 party:90 Liberal Democrats DIW:E05006967 Chesterton                       2016-05-05 0 0   37183.0       PP90   0
10982 13788 Rachel Victoria Mundy         40 party:52 Conservative and Unionist Party DIW:E05006967 Chesterton                       2016-05-05 0 0           PP52   0
10983 13789 Michael Coventry         40 party:85 UK Independence Party (UKIP) DIW:E05006968 Clayton                       2016-05-05 0 0           PP85   0
10984 13790 Andrew David Parker         40 party:52 Conservative and Unionist Party DIW:E05006968 Clayton                       2016-05-05 0 0   37621.0       PP52   0
10985 13791 Michael Timothy Shenton         40 party:53 Labour Party DIW:E05006968 Clayton                       2016-05-05 0 0   37050.0       PP53   0
10986 13792 Robin Studd         40 party:90 Liberal Democrats DIW:E05006968 Clayton                       2016-05-05 0 0           PP90   0
10987 13793 Lynn June Dean         40 party:85 UK Independence Party (UKIP) DIW:E05006969 Cross Heath                       2016-05-05 0 0   27049.0       PP85   0
10988 13794 Rita Margaret Gilmore         40 party:52 Conservative and Unionist Party DIW:E05006969 Cross Heath                       2016-05-05 0 0   37153.0       PP52   0
10989 13796 Jamie Victoria Rogers         40 party:63 Green Party DIW:E05006969 Cross Heath                       2016-05-05 0 0           PP63   0
10990 13797 Joan Mary Winfield         40 party:53 Labour Party DIW:E05006969 Cross Heath                       2016-05-05 0 0   37955.0       PP53   0
10991 13798 Laura Bloor         40 party:52 Conservative and Unionist Party DIW:E05006970 Halmerend   1.0                   2016-05-05 0 0           PP52   0
10992 13799 Neil Anthony Farrow         40 party:85 UK Independence Party (UKIP) DIW:E05006970 Halmerend                       2016-05-05 0 0           PP85   0
10993 13800 Hilary Ann Jones         40 party:90 Liberal Democrats DIW:E05006970 Halmerend                       2016-05-05 0 0   37574.0       PP90   0
10994 13801 Marie Joyce         40 party:53 Labour Party DIW:E05006970 Halmerend                       2016-05-05 0 0           PP53   0
10995 13802 Rupert Nicholas Adcock         40 party:52 Conservative and Unionist Party DIW:E05006971 Holditch                       2016-05-05 0 0           PP52   0
10996 13803 Gordon Davies         40 party:85 UK Independence Party (UKIP) DIW:E05006971 Holditch                       2016-05-05 0 0   37175.0       PP85   0
10997 13804 Bryn Richards         40 party:90 Liberal Democrats DIW:E05006971 Holditch                       2016-05-05 0 0           PP90   0
10998 13805 Chris Spence         40 party:53 Labour Party DIW:E05006971 Holditch   1.0                   2016-05-05 0 0   37199.0       PP53   0
10999 13806 Jack Williams         40 party:804 Trade Unionist and Socialist Coalition DIW:E05006971 Holditch                       2016-05-05 0 0           PP804   0
11000 13807 Andrew Fox-Hewitt     Man   40 party:53 Labour Party DIW:E05006986 Westlands           https://uk.linkedin.com/in/andrew-fox-hewitt-35404064           2016-05-05 0 0   37043.0       PP53   0
11001 13808 Linda Hailstones         40 party:52 Conservative and Unionist Party DIW:E05006986 Westlands   1.0                   2016-05-05 0 0   37030.0       PP52   0
11002 13809 Katharine Shirley Mitchell         40 party:90 Liberal Democrats DIW:E05006986 Westlands                       2016-05-05 0 0           PP90   0
11003 13810 Gordon John Pearson         40 party:63 Green Party DIW:E05006986 Westlands                       2016-05-05 0 0   37562.0       PP63   0
11004 13811 Bernadette Wilde         40 party:85 UK Independence Party (UKIP) DIW:E05006986 Westlands                       2016-05-05 0 0           PP85   0
11005 13812 Reginald Bailey         40 party:53 Labour Party DIW:E05006973 Kidsgrove                       2016-05-05 0 0           PP53   0
11006 13813 Becky Carter         40 party:804 Trade Unionist and Socialist Coalition DIW:E05006973 Kidsgrove                       2016-05-05 0 0           PP804   0
11007 13814 John Heesom         40 party:52 Conservative and Unionist Party DIW:E05006973 Kidsgrove                       2016-05-05 0 0   37154.0       PP52   0
11008 13815 Alexander Wright         40 party:85 UK Independence Party (UKIP) DIW:E05006973 Kidsgrove                       2016-05-05 0 0           PP85   0
11009 13817 Maria Teresa Foy         40 party:85 UK Independence Party (UKIP) DIW:E05006975 Loggerheads and Whitmore                       2016-05-05 0 0           PP85   0
11010 13818 David Ralph Lee         40 party:53 Labour Party DIW:E05006975 Loggerheads and Whitmore                       2016-05-05 0 0   37364.0       PP53   0
11011 13819 Barry James Panter         40 party:52 Conservative and Unionist Party DIW:E05006975 Loggerheads and Whitmore                       2016-05-05 0 0   37321.0       PP52   0
11012 13820 Verity Venter         40 party:63 Green Party DIW:E05006975 Loggerheads and Whitmore                       2016-05-05 0 0           PP63   0
11013 13821 Gary White         40 ynmp-party:2 Independent DIW:E05006975 Loggerheads and Whitmore                       2016-05-05 0 0   37345.0       ynmp-party:2   0
11014 13823 Mick Clarke         40 party:53 Labour Party DIW:E05006977 May Bank                       2016-05-05 0 0           PP53   0
11015 13824 Ian John Matthews         40 party:52 Conservative and Unionist Party DIW:E05006977 May Bank   1.0                   2016-05-05 0 0           PP52   0
11016 13825 Edward Alexander Moss         40 party:90 Liberal Democrats DIW:E05006977 May Bank                       2016-05-05 0 0           PP90   0
11017 13826 Kay Rees         40 party:85 UK Independence Party (UKIP) DIW:E05006977 May Bank                       2016-05-05 0 0           PP85   0
11018 13835 Lionel Owen Burch         40 party:53 Labour Party DIW:E05006978 Newchapel   1.0                   2016-05-05 0 0           PP53   0
11019 13836 Jill Waring         40 party:52 Conservative and Unionist Party DIW:E05006978 Newchapel                       2016-05-05 0 0   33043;37390       PP52   0
11020 13847 John Cooper         40 party:52 Conservative and Unionist Party DIW:E05006979 Porthill   1.0                   2016-05-05 0 0   37366.0       PP52   0
11021 13848 Dean Lawrence Page         40 party:85 UK Independence Party (UKIP) DIW:E05006979 Porthill                       2016-05-05 0 0           PP85   0
11022 13849 Tom Snape         40 party:53 Labour Party DIW:E05006979 Porthill                       2016-05-05 0 0           PP53   0
11023 13861 Gill Burnett         40 party:52 Conservative and Unionist Party DIW:E05006980 Ravenscliffe                       2016-05-05 0 0   37252.0       PP52   0
11024 13862 Laura Ann Dillon         40 party:53 Labour Party DIW:E05006980 Ravenscliffe   1.0                   2016-05-05 0 0   37254.0       PP53   0
11025 13920 Gary Fedtschyschak         40 party:85 UK Independence Party (UKIP) DIW:E05006981 Seabridge                       2016-05-05 0 0   37048.0       PP85   0
11026 13921 Chloe Mancey     female   40 party:52 Conservative and Unionist Party DIW:E05006981 Seabridge   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13921.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=275800452 2016-05-05 0 0           PP52   0
11027 13922 Imogen Grace Wilkes         40 party:53 Labour Party DIW:E05006981 Seabridge                       2016-05-05 0 0   37864.0       PP53   0
11028 13937 Robert Julian Owen Cooper         40 party:52 Conservative and Unionist Party DIW:E05006983 Talke                       2016-05-05 0 0           PP52   0
11029 13938 David Stringer         40 party:90 Liberal Democrats DIW:E05006983 Talke                       2016-05-05 0 0           PP90   0
11030 13939 Mike Stubbs     male   40 joint-party:53-119 Labour and Co-operative Party DIW:E05006983 Talke             https://static-candidates.democracyclub.org.uk/media/images/images/13939.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=570894777 2016-05-05 0 0   37503.0       joint-party:53-119   0
11031 13955 Sue Forrester-O'Neill         40 party:53 Labour Party DIW:E05006984 Thistleberry                       2016-05-05 0 0   37515.0       PP53   0
11032 13956 Marion Lynne Reddish         40 party:90 Liberal Democrats DIW:E05006984 Thistleberry   1.0                   2016-05-05 0 0   37563.0       PP90   0
11033 13957 Rob Tring         40 party:85 UK Independence Party (UKIP) DIW:E05006984 Thistleberry                       2016-05-05 0 0           PP85   0
11034 13958 James Vernon         40 party:52 Conservative and Unionist Party DIW:E05006984 Thistleberry                       2016-05-05 0 0   37460.0       PP52   0
11035 13975 Alan Slater Fox         40 party:52 Conservative and Unionist Party DIW:E05006985 Town                       2016-05-05 0 0           PP52   0
11036 13976 Morgan Inwood         40 party:90 Liberal Democrats DIW:E05006985 Town                       2016-05-05 0 0           PP90   0
11037 13977 Kevin Raftery         40 party:17 English Democrats DIW:E05006985 Town                       2016-05-05 0 0           PP17   0
11038 13978 Ruth Wright     female   40 party:53 Labour Party DIW:E05006985 Town   1.0                   2016-05-05 0 0   37601.0       PP53   0
Powered by Datasette · Query took 0.969ms