home / democracyclub

democracyclub

Custom SQL query returning 86 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
8117 759 Paul Rogan     male 1955-09-03 3 party:85 UK Independence Party (UKIP) MTW:E05001374 Greetland and Stainland     http://www.ukipcalderdale.uk/ http://ukipcv.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/5515af42caf202e56580fb27.png   profile-photo CVKipper   2016-05-05 0 0   12927.0       PP85   0
8118 991 Michael Taylor     male 1950-04-07 3 party:90 Liberal Democrats MTW:E05001378 Northowram and Shelf           https://www.linkedin.com/in/michael-taylor-b0586824           2016-05-05 0 0   12944.0       PP90   0
8119 3398 Chris Jackson     male   3 party:2707 National Front MTW:E05001385 Todmorden                       2016-05-05 0 0           PP2707   0
8120 4289 Joshua Fenton-Glynn     male   3 party:53 Labour Party MTW:E05001372 Calder     https://vote.labour.org.uk/joshua-fenton-glynn http://www.joshfentonglynn.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/4289.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
8121 4894 Alisdair Calder McGregor     male 1978.0 3 party:90 Liberal Democrats MTW:E05001375 Hipperholme and Lightcliffe     http://www.libdems.org.uk/alisdair_mcgregor http://alisdaircaldermcgregor.4mp.org.uk/   https://www.linkedin.com/in/alisdaircaldermcgregor https://static-candidates.democracyclub.org.uk/media/images/54a3d78ccca5fe1a31e4a7b4.png         2016-05-05 0 0           PP90   0
8122 4980 Jenny Shepherd     female   3 party:63 Green Party MTW:E05001372 Calder     http://yorkshireandhumber.greenparty.org.uk/candidates/jenny-shepherd.html http://jenny4mp.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/54a1a0b4cca5fe1a31e4a7a6.png         2016-05-05 0 0   12911.0       PP63   0
8123 5786 Rod Sutcliffe Mr   male 1951-06-09 3 party:2120 Yorkshire First MTW:E05001377 Luddendenfoot     http://www.yorkshirefirst.org.uk/       https://static-candidates.democracyclub.org.uk/media/images/552edc3942862f047e51ccb2.png   public-domain rod.sutcliffe I am the candidate and it is a photo of me 2016-05-05 0 0           PP2120   0
8124 6570 Ruth Coleman-Taylor     Female   3 party:90 Liberal Democrats MTW:E05001386 Town             https://static-candidates.democracyclub.org.uk/media/images/553b9b6cb9c95afe74c5d31e.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/Coleman2Ruth 2016-05-05 0 0           PP90   0
8125 7553 Adam David Wilkinson Mr   male   3 party:53 Labour Party MTW:E05001384 Sowerby Bridge   1.0   http://adamwilkinsonlabour.com/   https://www.linkedin.com/in/adam-wilkinson-85170533           2016-05-05 0 0           PP53   0
8126 8589 Nick Yates     male   3 party:85 UK Independence Party (UKIP) MTW:E05001371 Brighouse                       2016-05-05 0 0           PP85   0
8127 8592 Christopher Michael Baksa     male   3 party:85 UK Independence Party (UKIP) MTW:E05001377 Luddendenfoot             https://static-candidates.democracyclub.org.uk/media/images/images/8592.png   profile-photo yanbad13257   2016-05-05 0 0           PP85   0
8128 8593 Geoffrey Thompson     male   3 party:85 UK Independence Party (UKIP) MTW:E05001383 Skircoat                       2016-05-05 0 0           PP85   0
8129 8595 Philip Anthony Walters     male   3 party:85 UK Independence Party (UKIP) MTW:E05001385 Todmorden                       2016-05-05 0 0           PP85   0
8130 8596 Phillip Spencer Charlton     male   3 party:85 UK Independence Party (UKIP) MTW:E05001386 Town                       2016-05-05 0 0           PP85   0
8131 12909 Janet Mary Battye     female 1949.0 3 party:90 Liberal Democrats MTW:E05001372 Calder             https://static-candidates.democracyclub.org.uk/media/images/images/12909.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=631818144 2016-05-05 0 0           PP90   0
8132 12910 James Ananda Krishnapillai         3 party:52 Conservative and Unionist Party MTW:E05001372 Calder                       2016-05-05 0 0           PP52   0
8133 12912 Pat Allen         3 party:90 Liberal Democrats MTW:E05001373 Elland   1.0                   2016-05-05 0 0           PP90   0
8134 12913 Mick Clarke         3 party:85 UK Independence Party (UKIP) MTW:E05001373 Elland                       2016-05-05 0 0           PP85   0
8135 12914 Mohammad Naeem         3 party:53 Labour Party MTW:E05001373 Elland                       2016-05-05 0 0           PP53   0
8136 12915 George Andrew Robinson         3 party:52 Conservative and Unionist Party MTW:E05001373 Elland                       2016-05-05 0 0           PP52   0
8137 12916 Katharine Maeve Sweeny         3 party:63 Green Party MTW:E05001373 Elland                       2016-05-05 0 0           PP63   0
8138 12917 Ann Martin         3 party:53 Labour Party MTW:E05001371 Brighouse                       2016-05-05 0 0           PP53   0
8139 12918 John Richard Ward Nesbitt         3 party:63 Green Party MTW:E05001371 Brighouse                       2016-05-05 0 0           PP63   0
8140 12919 Colin Bryan Peel         3 party:52 Conservative and Unionist Party MTW:E05001371 Brighouse   1.0                   2016-05-05 0 0           PP52   0
8141 12920 Jennie Dawn Rigg     female 1977.0 3 party:90 Liberal Democrats MTW:E05001371 Brighouse           https://www.linkedin.com/in/jennierigg/           2016-05-05 0 0           PP90 Gingernut 0
8142 12921 Samuel George Webb         3 party:804 Trade Unionist and Socialist Coalition MTW:E05001371 Brighouse                       2016-05-05 0 0           PP804   0
8143 12922 Paul Alexander Bellenger         3 party:90 Liberal Democrats MTW:E05001374 Greetland and Stainland   1.0                   2016-05-05 0 0           PP90   0
8144 12923 Christopher Richard Blakey         3 party:52 Conservative and Unionist Party MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP52   0
8145 12924 Christopher Wade Clinton         3 party:2120 Yorkshire First MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP2120   0
8146 12925 James Stephen Hepplestone         3 party:53 Labour Party MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP53   0
8147 12926 Mark Richard Mullany         3 party:63 Green Party MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP63   0
8148 12928 Kashif Ali         3 party:53 Labour Party MTW:E05001375 Hipperholme and Lightcliffe                       2016-05-05 0 0           PP53   0
8149 12929 Graham Thomas Hall         3 party:52 Conservative and Unionist Party MTW:E05001375 Hipperholme and Lightcliffe   1.0                   2016-05-05 0 0           PP52   0
8150 12930 Susan Jane Wardell         3 party:63 Green Party MTW:E05001375 Hipperholme and Lightcliffe                       2016-05-05 0 0           PP63   0
8151 12931 Tessa Gordziejko         3 party:63 Green Party MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP63   0
8152 12932 Lisa Ruth Lambert         3 party:53 Labour Party MTW:E05001376 Illingworth and Mixenden   1.0                   2016-05-05 0 0           PP53   0
8153 12933 Steven Leigh         3 party:52 Conservative and Unionist Party MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP52   0
8154 12934 Seán Loftus         3 ynmp-party:2 Independent MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           ynmp-party:2   0
8155 12935 Glen Michael Mattock         3 party:90 Liberal Democrats MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP90   0
8156 12936 Angela Stella Thompson         3 party:85 UK Independence Party (UKIP) MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP85   0
8157 12937 Karl Antony Boggis         3 party:90 Liberal Democrats MTW:E05001377 Luddendenfoot                       2016-05-05 0 0           PP90   0
8158 12938 Owen Idris Gilroy         3 party:52 Conservative and Unionist Party MTW:E05001377 Luddendenfoot                       2016-05-05 0 0           PP52   0
8159 12939 Pete Darren Lucky Leigh Pitfield         3 party:63 Green Party MTW:E05001377 Luddendenfoot                       2016-05-05 0 0           PP63   0
8160 12940 Jane Scullion         3 party:53 Labour Party MTW:E05001377 Luddendenfoot   1.0                   2016-05-05 0 0           PP53   0
8161 12941 Peter Caffrey         3 party:52 Conservative and Unionist Party MTW:E05001378 Northowram and Shelf   1.0                   2016-05-05 0 0           PP52   0
8162 12942 Elaine Hey         3 party:63 Green Party MTW:E05001378 Northowram and Shelf                       2016-05-05 0 0           PP63   0
8163 12943 Daniel Richard Manning     male   3 party:2120 Yorkshire First MTW:E05001378 Northowram and Shelf                       2016-05-05 0 0           PP2120   0
8164 12945 Gary Walsh         3 party:53 Labour Party MTW:E05001378 Northowram and Shelf                       2016-05-05 0 0           PP53   0
8165 12946 Mat Bowles         3 party:90 Liberal Democrats MTW:E05001379 Ovenden                       2016-05-05 0 0           PP90   0
8166 12947 Anne Collins         3 party:53 Labour Party MTW:E05001379 Ovenden   1.0                   2016-05-05 0 0           PP53   0
8167 12948 Katherine Louise Horner         3 party:63 Green Party MTW:E05001379 Ovenden                       2016-05-05 0 0           PP63   0
8168 12949 John Charles Shoesmith         3 party:52 Conservative and Unionist Party MTW:E05001379 Ovenden                       2016-05-05 0 0           PP52   0
8169 12950 Jeff Featherstone         3 party:52 Conservative and Unionist Party MTW:E05001380 Park                       2016-05-05 0 0           PP52   0
8170 12951 Charles Gate         3 party:63 Green Party MTW:E05001380 Park                       2016-05-05 0 0           PP63   0
8171 12952 Jenny Lynn         3 party:53 Labour Party MTW:E05001380 Park   1.0                   2016-05-05 0 0           PP53   0
8172 12954 Chaudhary Mohammed Saghir         3 ynmp-party:2 Independent MTW:E05001380 Park                       2016-05-05 0 0           ynmp-party:2   0
8173 12955 Kathy Haigh-Hutchinson         3 party:90 Liberal Democrats MTW:E05001381 Rastrick                       2016-05-05 0 0           PP90   0
8174 12956 Peter Judge         3 party:53 Labour Party MTW:E05001381 Rastrick                       2016-05-05 0 0           PP53   0
8175 12957 Elizabeth Jane King         3 party:63 Green Party MTW:E05001381 Rastrick                       2016-05-05 0 0           PP63   0
8176 12958 Lynne Louise Mitchell         3 party:52 Conservative and Unionist Party MTW:E05001381 Rastrick   1.0                   2016-05-05 0 0           PP52   0
8177 12959 Geraldine Mary Carter         3 party:52 Conservative and Unionist Party MTW:E05001382 Ryburn   1.0                   2016-05-05 0 0           PP52   0
8178 12960 Steve Cliberon         3 party:53 Labour Party MTW:E05001382 Ryburn                       2016-05-05 0 0           PP53   0
8179 12961 Freda Mary Davis         3 party:63 Green Party MTW:E05001382 Ryburn                       2016-05-05 0 0           PP63   0
8180 12962 Peter John Hunt         3 ynmp-party:2 Independent MTW:E05001382 Ryburn                       2016-05-05 0 0           ynmp-party:2   0
8181 12963 Rosemary Mabel Tatchell         3 party:90 Liberal Democrats MTW:E05001382 Ryburn                       2016-05-05 0 0           PP90   0
8182 12964 Dave Draycott         3 party:53 Labour Party MTW:E05001383 Skircoat                       2016-05-05 0 0           PP53   0
8183 12965 Eric Fabrizi     male   3 party:63 Green Party MTW:E05001383 Skircoat     https://calderdale.greenparty.org.uk/people/eric-fabrizi.html       https://static-candidates.democracyclub.org.uk/media/images/images/12965.png   profile-photo sjorford https://calderdale.greenparty.org.uk/people/eric-fabrizi.html 2016-05-05 0 0           PP63   0
8184 12966 Stephen Alexander Gow         3 party:90 Liberal Democrats MTW:E05001383 Skircoat                       2016-05-05 0 0           PP90   0
8185 12967 John Cecil David Hardy         3 party:52 Conservative and Unionist Party MTW:E05001383 Skircoat   1.0                   2016-05-05 0 0           PP52   0
8186 12968 Darren Stansfield         3 party:2120 Yorkshire First MTW:E05001383 Skircoat                       2016-05-05 0 0           PP2120   0
8187 12969 Karen Elizabeth Levin         3 party:63 Green Party MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP63   0
8188 12970 Rob Oddy         3 party:52 Conservative and Unionist Party MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP52   0
8189 12971 Tom Stringfellow         3 party:90 Liberal Democrats MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP90   0
8190 12972 Roy Charles Thompson         3 party:85 UK Independence Party (UKIP) MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP85   0
8191 12973 Gilbert John Hector Gregory         3 party:52 Conservative and Unionist Party MTW:E05001385 Todmorden                       2016-05-05 0 0           PP52   0
8192 12974 Alan Patrick McDonald         3 party:63 Green Party MTW:E05001385 Todmorden                       2016-05-05 0 0           PP63   0
8193 12975 Joe Rez         3 party:90 Liberal Democrats MTW:E05001385 Todmorden                       2016-05-05 0 0           PP90   0
8194 12976 Steve Sweeney         3 party:53 Labour Party MTW:E05001385 Todmorden   1.0                   2016-05-05 0 0           PP53   0
8195 12977 Mark Llewellyn Edwards         3 party:52 Conservative and Unionist Party MTW:E05001386 Town                       2016-05-05 0 0   36872.0       PP52   0
8196 12978 Sarah Louise Moakler         3 party:63 Green Party MTW:E05001386 Town                       2016-05-05 0 0           PP63   0
8197 12979 Megan Kathleen Swift     Female   3 party:53 Labour Party MTW:E05001386 Town   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12979.png   copyright-assigned TimSwift   2016-05-05 0 0           PP53   0
8198 12980 Surraya Bibi         3 party:53 Labour Party MTW:E05001387 Warley                       2016-05-05 0 0           PP53   0
8199 12981 Hena Chowdhury         3 party:63 Green Party MTW:E05001387 Warley                       2016-05-05 0 0           PP63   0
8200 12982 Ashley John Richard Evans         3 party:90 Liberal Democrats MTW:E05001387 Warley   1.0                   2016-05-05 0 0           PP90   0
8201 12983 Tony Fall         3 party:52 Conservative and Unionist Party MTW:E05001387 Warley                       2016-05-05 0 0           PP52   0
8202 36844 John Reynolds         3 party:90 Liberal Democrats MTW:E05001380 Park                       2016-05-05 0 0   12953.0       PP90   0
Powered by Datasette · Query took 0.986ms