home / democracyclub

democracyclub

Custom SQL query returning 88 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
10053 2831 Neil Miney     male   33 party:85 UK Independence Party (UKIP) MTW:E05010944 St Gabriels             https://static-candidates.democracyclub.org.uk/media/images/images/2831.png   profile-photo TangoKid   2016-05-05 0 0   6878;17972       PP85   0
10054 4508 Carl Cashman     male 1991-10-25 33 party:90 Liberal Democrats MTW:E05010940 Prescot North   1.0 http://www.libdems.org.uk/carl_cashman http://www.carlcashman.org.uk/ https://en.wikipedia.org/wiki/Carl_Cashman   https://static-candidates.democracyclub.org.uk/media/images/5481e91ab150e238702c062f.png   profile-photo     2016-05-05 0 0           PP90   0
10055 17877 Sean Phillip Donnelly         33 party:53 Labour Party MTW:E05010949 Whitefield   1.0                   2016-05-05 0 0           PP53   0
10056 17878 Brian Johns         33 ynmp-party:2 Independent MTW:E05010949 Whitefield                       2016-05-05 0 0           ynmp-party:2   0
10057 17879 Norman Frederick Keats         33 party:53 Labour Party MTW:E05010949 Whitefield   1.0                   2016-05-05 0 0           PP53   0
10058 17880 Geraldine Veronica Robertson         33 party:704 First For Kirkby MTW:E05010949 Whitefield                       2016-05-05 0 0           PP704   0
10059 17881 Ros Smith         33 party:53 Labour Party MTW:E05010949 Whitefield   1.0                   2016-05-05 0 0           PP53   0
10060 17911 Jayne Elizabeth Aston         33 party:53 Labour Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP53   0
10061 17912 Jenny Bamber         33 party:704 First For Kirkby MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP704   0
10062 17913 Adam William Butler         33 party:52 Conservative and Unionist Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP52   0
10063 17914 Jackie Harris         33 party:53 Labour Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP53   0
10064 17915 David Mark Lonergan         33 party:53 Labour Party MTW:E05010935 Cherryfield                       2016-05-05 0 0           PP53   0
10065 17916 Alan John Flute         33 party:53 Labour Party MTW:E05010936 Halewood North   1.0                   2016-05-05 0 0           PP53   0
10066 17917 Shelley Powell         33 party:53 Labour Party MTW:E05010936 Halewood North   1.0                   2016-05-05 0 0           PP53   0
10067 17918 Terry Powell         33 party:53 Labour Party MTW:E05010936 Halewood North   1.0                   2016-05-05 0 0           PP53   0
10068 17919 Matthew Paul Smith         33 party:52 Conservative and Unionist Party MTW:E05010936 Halewood North                       2016-05-05 0 0           PP52   0
10069 17920 Bob Swann         33 ynmp-party:2 Independent MTW:E05010936 Halewood North                       2016-05-05 0 0           ynmp-party:2   0
10070 17921 Phil Williamson         33 party:63 Green Party MTW:E05010936 Halewood North                       2016-05-05 0 0           PP63   0
10071 17927 Edna Finneran         33 party:53 Labour Party MTW:E05010937 Halewood South   1.0                   2016-05-05 0 0           PP53   0
10072 17928 Tina Harris         33 party:53 Labour Party MTW:E05010937 Halewood South   1.0                   2016-05-05 0 0           PP53   0
10073 17929 Allan Harvey         33 ynmp-party:2 Independent MTW:E05010937 Halewood South                       2016-05-05 0 0           ynmp-party:2   0
10074 17930 Gary Eric See     male   33 party:53 Labour Party MTW:E05010937 Halewood South   1.0   https://cllrseeblog.org/     https://static-candidates.democracyclub.org.uk/media/images/images/17930.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1446112092 2016-05-05 0 0           PP53   0
10075 17931 Paula Marjorie Thomas         33 party:804 Trade Unionist and Socialist Coalition MTW:E05010937 Halewood South                       2016-05-05 0 0           PP804   0
10076 17932 Andy Tomo         33 party:804 Trade Unionist and Socialist Coalition MTW:E05010937 Halewood South                       2016-05-05 0 0           PP804   0
10077 17933 Graham Tubey         33 party:52 Conservative and Unionist Party MTW:E05010937 Halewood South                       2016-05-05 0 0           PP52   0
10078 17934 Bren Tyrrell         33 party:804 Trade Unionist and Socialist Coalition MTW:E05010937 Halewood South                       2016-05-05 0 0           PP804   0
10079 17935 Eddie Connor         33 party:53 Labour Party MTW:E05010938 Northwood   1.0                   2016-05-05 0 0           PP53   0
10080 17936 Philip McKuhen         33 party:704 First For Kirkby MTW:E05010938 Northwood                       2016-05-05 0 0           PP704   0
10081 17937 Mike Murphy         33 party:53 Labour Party MTW:E05010938 Northwood   1.0                   2016-05-05 0 0           PP53   0
10082 17938 Marie Ellen Stuart         33 party:53 Labour Party MTW:E05010938 Northwood   1.0                   2016-05-05 0 0           PP53   0
10083 17939 Ken McGlashan         33 joint-party:53-119 Labour and Co-operative Party MTW:E05010939 Page Moss   1.0                   2016-05-05 0 0           joint-party:53-119   0
10084 17940 Veronica McNeill         33 joint-party:53-119 Labour and Co-operative Party MTW:E05010939 Page Moss   1.0                   2016-05-05 0 0           joint-party:53-119   0
10085 17941 Andy Moorhead         33 joint-party:53-119 Labour and Co-operative Party MTW:E05010939 Page Moss   1.0                   2016-05-05 0 0           joint-party:53-119   0
10086 17942 Kirk Anthony Sandringham     Man   33 party:63 Green Party MTW:E05010939 Page Moss             https://static-candidates.democracyclub.org.uk/media/images/images/17942.png   profile-photo j0e_m https://www.facebook.com/Huytongreens/posts/2183939895169910 2016-05-05 0 0           PP63   0
10087 17943 Robert Peter Allan Avery         33 party:52 Conservative and Unionist Party MTW:E05010940 Prescot North                       2016-05-05 0 0           PP52   0
10088 17944 Mike Kearns         33 party:53 Labour Party MTW:E05010940 Prescot North                       2016-05-05 0 0           PP53   0
10089 17945 Lynn O'Keeffe         33 party:53 Labour Party MTW:E05010940 Prescot North                       2016-05-05 0 0   38384.0       PP53   0
10090 17946 Ian Smith         33 party:90 Liberal Democrats MTW:E05010940 Prescot North   1.0                   2016-05-05 0 0           PP90   0
10091 17947 Bill Weightman         33 party:53 Labour Party MTW:E05010940 Prescot North                       2016-05-05 0 0           PP53   0
10092 17948 Steve Whatham         33 party:804 Trade Unionist and Socialist Coalition MTW:E05010940 Prescot North                       2016-05-05 0 0           PP804   0
10093 17949 Mike Wynn         33 party:90 Liberal Democrats MTW:E05010940 Prescot North   1.0                   2016-05-05 0 0           PP90   0
10094 17950 Denise Allen         33 party:53 Labour Party MTW:E05010941 Prescot South   1.0                   2016-05-05 0 0           PP53   0
10095 17952 Paul Terence Shaw         33 party:90 Liberal Democrats MTW:E05010941 Prescot South                       2016-05-05 0 0           PP90   0
10096 17953 Sophia April Smith         33 party:90 Liberal Democrats MTW:E05010941 Prescot South                       2016-05-05 0 0           PP90   0
10097 17954 Sheila Mary Webster         33 party:52 Conservative and Unionist Party MTW:E05010941 Prescot South                       2016-05-05 0 0           PP52   0
10098 17955 John Loftus Wickham         33 party:90 Liberal Democrats MTW:E05010941 Prescot South                       2016-05-05 0 0           PP90   0
10099 17956 Dave Williams         33 party:53 Labour Party MTW:E05010941 Prescot South   1.0                   2016-05-05 0 0           PP53   0
10100 17957 Ray Cleary         33 party:85 UK Independence Party (UKIP) MTW:E05010942 Roby                       2016-05-05 0 0           PP85   0
10101 17958 Maggie Harvey         33 party:53 Labour Party MTW:E05010942 Roby   1.0                   2016-05-05 0 0           PP53   0
10102 17959 Martin Peter Mackarel         33 party:63 Green Party MTW:E05010942 Roby                       2016-05-05 0 0           PP63   0
10103 17960 Tyrone Noon         33 party:52 Conservative and Unionist Party MTW:E05010942 Roby                       2016-05-05 0 0           PP52   0
10104 17961 Gary John Robertson         33 party:85 UK Independence Party (UKIP) MTW:E05010942 Roby                       2016-05-05 0 0           PP85   0
10105 17962 Sam Robertson         33 party:85 UK Independence Party (UKIP) MTW:E05010942 Roby                       2016-05-05 0 0           PP85   0
10106 17963 Pam Spall         33 party:53 Labour Party MTW:E05010942 Roby   1.0                   2016-05-05 0 0           PP53   0
10107 17964 Sarah Joanne Spall         33 party:53 Labour Party MTW:E05010942 Roby   1.0                   2016-05-05 0 0           PP53   0
10108 17965 Johnny Webster         33 ynmp-party:2 Independent MTW:E05010942 Roby                       2016-05-05 0 0           ynmp-party:2   0
10109 17966 Tony Brennan         33 party:53 Labour Party MTW:E05010943 Shevington   1.0                   2016-05-05 0 0           PP53   0
10110 17967 Neill Thomas John Dunne         33 party:804 Trade Unionist and Socialist Coalition MTW:E05010943 Shevington                       2016-05-05 0 0           PP804   0
10111 17968 Ray Halpin         33 party:53 Labour Party MTW:E05010943 Shevington   1.0                   2016-05-05 0 0           PP53   0
10112 17969 Linda Mooney         33 party:53 Labour Party MTW:E05010943 Shevington   1.0                   2016-05-05 0 0           PP53   0
10113 17970 Fred Fricker     male   33 party:85 UK Independence Party (UKIP) MTW:E05010944 St Gabriels                       2016-05-05 0 0           PP85   0
10114 17971 Sharon Marie Fricker         33 party:85 UK Independence Party (UKIP) MTW:E05010944 St Gabriels                       2016-05-05 0 0           PP85   0
10115 17973 Brian Michael O'Hare         33 party:53 Labour Party MTW:E05010944 St Gabriels   1.0                   2016-05-05 0 0           PP53   0
10116 17974 Christina Maria O'Hare         33 party:53 Labour Party MTW:E05010944 St Gabriels   1.0                   2016-05-05 0 0           PP53   0
10117 17975 Tony Read         33 party:52 Conservative and Unionist Party MTW:E05010944 St Gabriels                       2016-05-05 0 0   38387.0       PP52   0
10118 17976 Frank Walsh         33 party:53 Labour Party MTW:E05010944 St Gabriels   1.0                   2016-05-05 0 0           PP53   0
10119 17977 Ron Ford         33 party:52 Conservative and Unionist Party MTW:E05010945 St Michaels                       2016-05-05 0 0           PP52   0
10120 17978 Vickie Lamb         33 party:53 Labour Party MTW:E05010945 St Michaels   1.0                   2016-05-05 0 0           PP53   0
10121 17979 Joan Elizabeth Lilly         33 party:53 Labour Party MTW:E05010945 St Michaels   1.0                   2016-05-05 0 0           PP53   0
10122 17980 Kay Moorhead         33 party:53 Labour Party MTW:E05010945 St Michaels   1.0                   2016-05-05 0 0           PP53   0
10123 17981 John David Price         33 party:85 UK Independence Party (UKIP) MTW:E05010945 St Michaels                       2016-05-05 0 0           PP85   0
10124 17982 Dennis John Baum         33 party:53 Labour Party MTW:E05010946 Stockbridge   1.0                   2016-05-05 0 0           PP53   0
10125 17983 John Jason Donnelly         33 party:53 Labour Party MTW:E05010946 Stockbridge   1.0                   2016-05-05 0 0           PP53   0
10126 17985 Paul Gary Woods         33 ynmp-party:2 Independent MTW:E05010946 Stockbridge                       2016-05-05 0 0           ynmp-party:2   0
10127 17986 Chris Bannon         33 party:53 Labour Party MTW:E05010947 Swanside   1.0                   2016-05-05 0 0           PP53   0
10128 17987 Colin Dever         33 party:53 Labour Party MTW:E05010947 Swanside   1.0                   2016-05-05 0 0           PP53   0
10129 17988 Paul Kenneth Robert Marshall         33 party:63 Green Party MTW:E05010947 Swanside                       2016-05-05 0 0           PP63   0
10130 17989 Graham James Morgan         33 party:53 Labour Party MTW:E05010947 Swanside   1.0                   2016-05-05 0 0           PP53   0
10131 17990 Ray Newland         33 party:52 Conservative and Unionist Party MTW:E05010947 Swanside                       2016-05-05 0 0           PP52   0
10132 17991 Terry Byron         33 party:53 Labour Party MTW:E05010948 Whiston & Cronton   1.0                   2016-05-05 0 0           PP53   0
10133 17992 Carl Robert Cross         33 party:52 Conservative and Unionist Party MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP52   0
10134 17993 Gillian Flatley         33 party:53 Labour Party MTW:E05010948 Whiston & Cronton   1.0                   2016-05-05 0 0           PP53   0
10135 17994 Tony Newman         33 party:53 Labour Party MTW:E05010948 Whiston & Cronton   1.0                   2016-05-05 0 0           PP53   0
10136 17995 Dave O'Hara         33 party:90 Liberal Democrats MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP90   0
10137 17996 Samantha Clare Smith         33 party:90 Liberal Democrats MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP90   0
10138 17997 Marjorie Elizabeth Sommerfield         33 party:90 Liberal Democrats MTW:E05010948 Whiston & Cronton                       2016-05-05 0 0           PP90   0
10139 19396 Steff O'Keeffe         33 party:53 Labour Party MTW:E05010941 Prescot South   1.0                   2016-05-05 0 0           PP53   0
10140 19405 Margi O'Mara         33 party:53 Labour Party MTW:E05010946 Stockbridge   1.0                   2016-05-05 0 0   17984.0       PP53   0
Powered by Datasette · Query took 0.964ms