home / democracyclub

democracyclub

Custom SQL query returning 101 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
13250 93 Stuart Kelly     male   74 party:90 Liberal Democrats MTW:E05000968 Oxton   1.0                   2016-05-05 0 0           PP90   0
13251 413 Peter Reisdorf     male 1962-06-26 74 party:90 Liberal Democrats MTW:E05000963 Hoylake and Meols     http://www.libdems.org.uk/peter_reisdorf       https://static-candidates.democracyclub.org.uk/media/images/images/413.png   profile-photo brycx http://www.libdems.org.uk/peter_reisdorf 2016-05-05 0 0           PP90   0
13252 5006 James Laing     male 1967-04-05 74 party:53 Labour Party MTW:E05000975 West Kirby and Thurstaston       http://www.eddisburylabour.org/     https://static-candidates.democracyclub.org.uk/media/images/550bf52c4aa4fdc23cc908f4.png   other Eddisburylabour I own the copyright and allow its use on this site 2016-05-05 0 0           PP53   0
13253 5203 Kenny Peers     male   74 party:63 Green Party MTW:E05000971 Rock Ferry     https://my.greenparty.org.uk/candidates/105813       https://static-candidates.democracyclub.org.uk/media/images/5519aedaba7512a07da47939.png   profile-photo kierant https://my.greenparty.org.uk/candidates/105813 2016-05-05 0 0           PP63   0
13254 5428 Allan Brame     male 1952-01-20 74 party:90 Liberal Democrats MTW:E05000970 Prenton     http://www.libdems.org.uk/allan_brame     http://uk.linkedin.com/pub/allan-brame/67/832/448/en https://static-candidates.democracyclub.org.uk/media/images/550bdea336b6dcb123cb431e.png         2016-05-05 0 0           PP90   0
13255 6881 Adam Heatherington Mr   Male 1975.0 74 party:85 UK Independence Party (UKIP) MTW:E05000974 Wallasey             https://static-candidates.democracyclub.org.uk/media/images/images/6881.png   profile-photo ripperger2345   2016-05-05 0 0           PP85 Custard cream 0
13256 11204 Jim Bradshaw         74 party:85 UK Independence Party (UKIP) MTW:E05000954 Bebington                       2016-05-05 0 0           PP85   0
13257 11205 Des Drury     male   74 party:52 Conservative and Unionist Party MTW:E05000954 Bebington     https://www.wirralconservatives.com/desdrury       https://static-candidates.democracyclub.org.uk/media/images/images/11205.png   profile-photo fbrc https://www.wirralconservatives.com/desdrury 2016-05-05 0 0           PP52   0
13258 11206 Penelope Ruth Golby         74 party:90 Liberal Democrats MTW:E05000954 Bebington                       2016-05-05 0 0           PP90   0
13259 11207 Christina Claire Muspratt         74 party:53 Labour Party MTW:E05000954 Bebington   1.0                   2016-05-05 0 0           PP53   0
13260 11208 Anthony James Smith         74 party:63 Green Party MTW:E05000954 Bebington                       2016-05-05 0 0           PP63   0
13261 11209 Debbie Caplin     Female 1961-12-18 74 party:85 UK Independence Party (UKIP) MTW:E05000955 Bidston and St James             https://static-candidates.democracyclub.org.uk/media/images/images/11209_H6NLrVK.png   profile-photo j0e_m Emailed to DemoClub by the candidate for use on the site. 2016-05-05 0 0           PP85   0
13262 11211 Brian Gill         74 party:90 Liberal Democrats MTW:E05000955 Bidston and St James                       2016-05-05 0 0           PP90   0
13263 11212 Benjamin Halligan         74 party:804 Trade Unionist and Socialist Coalition MTW:E05000955 Bidston and St James                       2016-05-05 0 0           PP804   0
13264 11213 Nick Hanna         74 party:52 Conservative and Unionist Party MTW:E05000955 Bidston and St James                       2016-05-05 0 0           PP52   0
13265 11214 Julie McManus         74 party:53 Labour Party MTW:E05000955 Bidston and St James   1.0                   2016-05-05 0 0           PP53   0
13266 11215 June Cowin         74 party:52 Conservative and Unionist Party MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP52   0
13267 11216 Graeme Foster         74 party:85 UK Independence Party (UKIP) MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP85   0
13268 11217 Steve Hayes     male   74 party:63 Green Party MTW:E05000956 Birkenhead and Tranmere             https://static-candidates.democracyclub.org.uk/media/images/images/11217.png   public-domain harryrossgorman Portrait of candidate. https://drive.google.com/file/d/1lzlqOSxs2OlmXBQKbIw1Lytnglpy9ocN/view 2016-05-05 0 0           PP63   0
13269 11218 Mary Price         74 party:90 Liberal Democrats MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP90   0
13270 11219 Jean Stapleton         74 party:53 Labour Party MTW:E05000956 Birkenhead and Tranmere   1.0                   2016-05-05 0 0           PP53   0
13271 11220 Jack Yarlett         74 party:804 Trade Unionist and Socialist Coalition MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP804   0
13272 11221 Mark Halligan         74 party:804 Trade Unionist and Socialist Coalition MTW:E05000957 Bromborough                       2016-05-05 0 0           PP804   0
13273 11222 Percy Hogg         74 party:63 Green Party MTW:E05000957 Bromborough                       2016-05-05 0 0           PP63   0
13274 11223 Jennifer Lane         74 party:90 Liberal Democrats MTW:E05000957 Bromborough                       2016-05-05 0 0           PP90   0
13275 11224 Steve Niblock     male   74 ynmp-party:2 Independent MTW:E05000957 Bromborough           https://uk.linkedin.com/in/steve-niblock-0a17753a           2016-05-05 0 0           ynmp-party:2   0
13276 11225 Warren Ward Cllr   Male 1997-09-27 74 party:53 Labour Party MTW:E05000957 Bromborough   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11225.png   copyright-assigned WAW_97 As it is my photo 2016-05-05 0 0           PP53   0
13277 11226 Pete Welch         74 party:52 Conservative and Unionist Party MTW:E05000957 Bromborough                       2016-05-05 0 0           PP52   0
13278 11227 Jan Cambridge         74 party:90 Liberal Democrats MTW:E05000958 Clatterbridge                       2016-05-05 0 0           PP90   0
13279 11228 Jenny Holliday         74 party:53 Labour Party MTW:E05000958 Clatterbridge                       2016-05-05 0 0           PP53   0
13280 11229 Jim McGinley         74 party:63 Green Party MTW:E05000958 Clatterbridge                       2016-05-05 0 0           PP63   0
13281 11230 Cherry Povall         74 party:52 Conservative and Unionist Party MTW:E05000958 Clatterbridge   1.0                   2016-05-05 0 0           PP52   0
13282 11231 George Davies         74 party:53 Labour Party MTW:E05000959 Claughton   1.0                   2016-05-05 0 0           PP53   0
13283 11232 Moira Gommon         74 party:63 Green Party MTW:E05000959 Claughton                       2016-05-05 0 0           PP63   0
13284 11233 Phil Simpson         74 party:804 Trade Unionist and Socialist Coalition MTW:E05000959 Claughton                       2016-05-05 0 0           PP804   0
13285 11234 Barbara Vera Sinclair         74 party:52 Conservative and Unionist Party MTW:E05000959 Claughton                       2016-05-05 0 0           PP52   0
13286 11235 Christopher Teggin         74 party:90 Liberal Democrats MTW:E05000959 Claughton                       2016-05-05 0 0           PP90   0
13287 11236 Phillip Gilchrist         74 party:90 Liberal Democrats MTW:E05000960 Eastham   1.0                   2016-05-05 0 0           PP90   0
13288 11237 Giuseppe Roberto         74 party:53 Labour Party MTW:E05000960 Eastham                       2016-05-05 0 0   42533.0       PP53   0
13289 11238 Perle Sheldricks         74 party:63 Green Party MTW:E05000960 Eastham                       2016-05-05 0 0           PP63   0
13290 11239 Peter Taylor         74 party:52 Conservative and Unionist Party MTW:E05000960 Eastham                       2016-05-05 0 0           PP52   0
13291 11240 Tom Anderson     male   74 party:52 Conservative and Unionist Party MTW:E05000961 Greasby, Frankby and Irby   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11240.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=361126012 2016-05-05 0 0           PP52   0
13292 11241 John Cresswell         74 party:90 Liberal Democrats MTW:E05000961 Greasby, Frankby and Irby                       2016-05-05 0 0           PP90   0
13293 11242 Frank Harrison         74 party:53 Labour Party MTW:E05000961 Greasby, Frankby and Irby                       2016-05-05 0 0           PP53   0
13294 11243 Cathy Page   MBE female   74 party:63 Green Party MTW:E05000961 Greasby, Frankby and Irby                       2016-05-05 0 0           PP63   0
13295 11244 Barbara Burton         74 party:63 Green Party MTW:E05000962 Heswall                       2016-05-05 0 0           PP63   0
13296 11245 Kathryn Hodson         74 party:52 Conservative and Unionist Party MTW:E05000962 Heswall   1.0                   2016-05-05 0 0           PP52   0
13297 11246 Jeff Judge         74 party:53 Labour Party MTW:E05000962 Heswall                       2016-05-05 0 0           PP53   0
13298 11247 David Tyrrell         74 party:90 Liberal Democrats MTW:E05000962 Heswall                       2016-05-05 0 0           PP90   0
13299 11248 Alix Cockcroft         74 party:63 Green Party MTW:E05000963 Hoylake and Meols                       2016-05-05 0 0           PP63   0
13300 11249 John Hale         74 party:52 Conservative and Unionist Party MTW:E05000963 Hoylake and Meols   1.0                   2016-05-05 0 0           PP52   0
13301 11250 Jean Robinson         74 party:53 Labour Party MTW:E05000963 Hoylake and Meols             https://static-candidates.democracyclub.org.uk/media/images/images/11250.png   profile-photo fbrc https://twitter.com/UptonLabour/status/1053391342213234688 2016-05-05 0 0   49212.0       PP53   0
13302 12284 Tony Jones         74 party:53 Labour Party MTW:E05000967 New Brighton   1.0                   2016-05-05 0 0           PP53   0
13303 12285 Gregory William North         74 party:804 Trade Unionist and Socialist Coalition MTW:E05000967 New Brighton                       2016-05-05 0 0           PP804   0
13304 12286 Tony Pritchard         74 party:52 Conservative and Unionist Party MTW:E05000967 New Brighton                       2016-05-05 0 0           PP52   0
13305 12287 Cynthia Stonall         74 party:63 Green Party MTW:E05000967 New Brighton                       2016-05-05 0 0           PP63   0
13306 12288 Jackie Usher         74 party:90 Liberal Democrats MTW:E05000967 New Brighton                       2016-05-05 0 0           PP90   0
13307 12289 Paula Walters Ms   Female   74 party:85 UK Independence Party (UKIP) MTW:E05000967 New Brighton       http://ukbestweb.co.uk/paulawaltersukip/     https://static-candidates.democracyclub.org.uk/media/images/images/12289.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   22861.0       PP85   0
13308 12579 William Eborall         74 party:52 Conservative and Unionist Party MTW:E05000964 Leasowe and Moreton East                       2016-05-05 0 0           PP52   0
13309 12580 Gillian Homeri         74 party:63 Green Party MTW:E05000964 Leasowe and Moreton East                       2016-05-05 0 0           PP63   0
13310 12581 Anita Leech         74 party:53 Labour Party MTW:E05000964 Leasowe and Moreton East   1.0                   2016-05-05 0 0           PP53   0
13311 12582 Daniel Clein         74 party:90 Liberal Democrats MTW:E05000965 Liscard                       2016-05-05 0 0           PP90   0
13312 12583 Trevor Desrosiers         74 party:63 Green Party MTW:E05000965 Liscard                       2016-05-05 0 0           PP63   0
13313 12584 Ann Lavin         74 party:52 Conservative and Unionist Party MTW:E05000965 Liscard                       2016-05-05 0 0           PP52   0
13314 12585 Ann Parry         74 party:52 Conservative and Unionist Party MTW:E05000965 Liscard                       2016-05-05 0 0           PP52   0
13315 12586 Tom Usher         74 party:53 Labour Party MTW:E05000965 Liscard   1.0                   2016-05-05 0 0           PP53   0
13316 12587 Lynda Williams         74 party:85 UK Independence Party (UKIP) MTW:E05000965 Liscard                       2016-05-05 0 0           PP85   0
13317 12588 Janette Williamson         74 party:53 Labour Party MTW:E05000965 Liscard   1.0                   2016-05-05 0 0           PP53   0
13318 12605 Chris Blakeley     male   74 party:52 Conservative and Unionist Party MTW:E05000966 Moreton West and Saughall Massie   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12605.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=23207410 2016-05-05 0 0           PP52   0
13319 12606 Karl Greaney     male   74 party:53 Labour Party MTW:E05000966 Moreton West and Saughall Massie                       2016-05-05 0 0           PP53   0
13320 12608 Lindsey Stowell-Smith         74 party:63 Green Party MTW:E05000966 Moreton West and Saughall Massie                       2016-05-05 0 0           PP63   0
13321 12685 Liz Heydon         74 party:63 Green Party MTW:E05000968 Oxton                       2016-05-05 0 0           PP63   0
13322 12686 Philip Merry         74 party:52 Conservative and Unionist Party MTW:E05000968 Oxton                       2016-05-05 0 0           PP52   0
13323 12687 Vicky Nowak         74 party:53 Labour Party MTW:E05000968 Oxton                       2016-05-05 0 0           PP53   0
13324 12708 Allen Burton         74 party:63 Green Party MTW:E05000969 Pensby and Thingwall                       2016-05-05 0 0           PP63   0
13325 12709 Damien Cummins         74 party:90 Liberal Democrats MTW:E05000969 Pensby and Thingwall                       2016-05-05 0 0           PP90   0
13326 12710 Jan Davison         74 party:85 UK Independence Party (UKIP) MTW:E05000969 Pensby and Thingwall                       2016-05-05 0 0           PP85   0
13327 12711 Andrew Gardner     male   74 party:52 Conservative and Unionist Party MTW:E05000969 Pensby and Thingwall       http://andrewgardner.campaigningforyou.com/     https://static-candidates.democracyclub.org.uk/media/images/images/12711.png   profile-photo JeniT https://twitter.com/AmgM600 2016-05-05 0 0           PP52   0
13328 12712 Mike Sullivan         74 party:53 Labour Party MTW:E05000969 Pensby and Thingwall   1.0                   2016-05-05 0 0           PP53   0
13329 12719 Chris Cooke     male   74 party:63 Green Party MTW:E05000970 Prenton             https://static-candidates.democracyclub.org.uk/media/images/images/12719.png   other harry14 This photograph comes from election literature from the Prenton ward. 2016-05-05 0 0           PP63   0
13330 12720 Hilary Jones         74 party:52 Conservative and Unionist Party MTW:E05000970 Prenton                       2016-05-05 0 0           PP52   0
13331 12721 Tony Norbury         74 party:53 Labour Party MTW:E05000970 Prenton   1.0                   2016-05-05 0 0           PP53   0
13332 12727 Bill Davies         74 party:53 Labour Party MTW:E05000971 Rock Ferry   1.0                   2016-05-05 0 0           PP53   0
13333 12728 Billy Foster         74 party:85 UK Independence Party (UKIP) MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP85   0
13334 12729 Leah Halligan         74 party:804 Trade Unionist and Socialist Coalition MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP804   0
13335 12730 Robert Hughes         74 party:52 Conservative and Unionist Party MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP52   0
13336 12731 Edward Smith         74 party:90 Liberal Democrats MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP90   0
13337 12732 John Laing         74 party:52 Conservative and Unionist Party MTW:E05000972 Seacombe                       2016-05-05 0 0           PP52   0
13338 12733 Paul Stuart         74 party:53 Labour Party MTW:E05000972 Seacombe   1.0                   2016-05-05 0 0           PP53   0
13339 12734 Lily Clough     female   74 party:63 Green Party MTW:E05000973 Upton     https://my.greenparty.org.uk/candidates/106264       https://static-candidates.democracyclub.org.uk/media/images/images/12734.png   profile-photo J https://my.greenparty.org.uk/candidates/106264 2016-05-05 0 0           PP63   0
13340 12735 Alan Davies         74 party:90 Liberal Democrats MTW:E05000973 Upton                       2016-05-05 0 0           PP90   0
13341 12736 Geoffrey Gubb         74 party:52 Conservative and Unionist Party MTW:E05000973 Upton                       2016-05-05 0 0           PP52   0
13342 12737 Philip Jones         74 party:804 Trade Unionist and Socialist Coalition MTW:E05000973 Upton                       2016-05-05 0 0           PP804   0
13343 12738 Matthew Patrick         74 party:53 Labour Party MTW:E05000973 Upton   1.0                   2016-05-05 0 0           PP53   0
13344 12739 John Codling         74 party:90 Liberal Democrats MTW:E05000974 Wallasey                       2016-05-05 0 0           PP90   0
13345 12740 Ian Lewis     male   74 party:52 Conservative and Unionist Party MTW:E05000974 Wallasey   1.0 https://www.wirralconservatives.com/ianlewis       https://static-candidates.democracyclub.org.uk/media/images/images/12740.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=728602309542985732 2016-05-05 0 0           PP52   0
13346 12741 Bill McGenity         74 party:53 Labour Party MTW:E05000974 Wallasey                       2016-05-05 0 0           PP53   0
13347 12742 John Rodgers         74 party:63 Green Party MTW:E05000974 Wallasey                       2016-05-05 0 0           PP63   0
13348 12745 Yvonne McGinley         74 party:63 Green Party MTW:E05000975 West Kirby and Thurstaston                       2016-05-05 0 0           PP63   0
13349 12746 Mike Redfern         74 party:90 Liberal Democrats MTW:E05000975 West Kirby and Thurstaston                       2016-05-05 0 0           PP90   0
13350 12747 Geoffrey Watt         74 party:52 Conservative and Unionist Party MTW:E05000975 West Kirby and Thurstaston   1.0                   2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.126ms