home / democracyclub

democracyclub

Custom SQL query returning 91 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
8491 3947 Alan Belmore     male 1990-04-16 9 party:90 Liberal Democrats MTW:E05000732 Saddleworth South             https://static-candidates.democracyclub.org.uk/media/images/images/3947.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   14942.0       PP90   0
8492 4520 Garth Harkness     male   9 party:90 Liberal Democrats MTW:E05000731 Saddleworth North     http://www.libdems.org.uk/garth_harkness http://garthharkness.mycouncillor.org.uk/   https://www.linkedin.com/pub/garth-harkness/5a/370/785 https://static-candidates.democracyclub.org.uk/media/images/5481e937b150e238702c0646.png   profile-photo     2016-05-05 0 0           PP90   0
8493 4637 Miranda Meadowcroft     female   9 party:63 Green Party MTW:E05000735 St Mary's     https://my.greenparty.org.uk/candidates/106124       https://static-candidates.democracyclub.org.uk/media/images/5548779f3c0ead4826d59189.png   profile-photo andylolz From party PPC page: https://my.greenparty.org.uk/candidates/106124 2016-05-05 0 0           PP63   0
8494 6992 Francis Arbour     male   9 party:85 UK Independence Party (UKIP) MTW:E05000720 Chadderton Central                       2016-05-05 0 0   14890.0       PP85   0
8495 8883 David Carter     male   9 party:85 UK Independence Party (UKIP) MTW:E05000719 Alexandra                       2016-05-05 0 0           PP85   0
8496 8884 Zahid Mehmood Chauhan     male   9 party:53 Labour Party MTW:E05000719 Alexandra                       2016-05-05 0 0           PP53   0
8497 8885 Richard Neville Darlington     male   9 party:90 Liberal Democrats MTW:E05000719 Alexandra                       2016-05-05 0 0           PP90   0
8498 8886 Terry Hopkinson         9 party:52 Conservative and Unionist Party MTW:E05000719 Alexandra                       2016-05-05 0 0           PP52   0
8499 8887 Matloob Hussain     male   9 ynmp-party:2 Independent MTW:E05000719 Alexandra                       2016-05-05 0 0           ynmp-party:2   0
8500 8888 Irfat Ahmed Shajahan         9 party:63 Green Party MTW:E05000719 Alexandra                       2016-05-05 0 0           PP63   0
8501 14891 Robert Barnes         9 party:52 Conservative and Unionist Party MTW:E05000720 Chadderton Central                       2016-05-05 0 0           PP52   0
8502 14892 Derek Clayton         9 party:90 Liberal Democrats MTW:E05000720 Chadderton Central                       2016-05-05 0 0           PP90   0
8503 14893 Susan Dearden         9 party:53 Labour Party MTW:E05000720 Chadderton Central                       2016-05-05 0 0           PP53   0
8504 14894 Jessica Stott         9 party:63 Green Party MTW:E05000720 Chadderton Central                       2016-05-05 0 0           PP63   0
8505 14896 Fazlul Haque         9 party:53 Labour Party MTW:E05000721 Chadderton North                       2016-05-05 0 0           PP53   0
8506 14897 Adam King     male   9 party:63 Green Party MTW:E05000721 Chadderton North     https://my.greenparty.org.uk/candidates/106125 http://manchestergreenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/14897.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106125 2016-05-05 0 0           PP63   0
8507 14898 Lewis Quigg         9 party:52 Conservative and Unionist Party MTW:E05000721 Chadderton North                       2016-05-05 0 0           PP52   0
8508 14899 Steve Connor         9 party:85 UK Independence Party (UKIP) MTW:E05000722 Chadderton South                       2016-05-05 0 0           PP85   0
8509 14900 Chris Goodwin         9 party:53 Labour Party MTW:E05000722 Chadderton South                       2016-05-05 0 0           PP53   0
8510 14901 Tabirul Islam         9 party:90 Liberal Democrats MTW:E05000722 Chadderton South                       2016-05-05 0 0           PP90   0
8511 14902 Chris Parr         9 party:63 Green Party MTW:E05000722 Chadderton South                       2016-05-05 0 0           PP63   0
8512 14903 Jamie Curley         9 party:52 Conservative and Unionist Party MTW:E05000723 Coldhurst                       2016-05-05 0 0           PP52   0
8513 14904 Abdul Jabbar         9 party:53 Labour Party MTW:E05000723 Coldhurst                       2016-05-05 0 0           PP53   0
8514 14905 Saleh Uddin Talukdar         9 party:63 Green Party MTW:E05000723 Coldhurst                       2016-05-05 0 0           PP63   0
8515 14906 Nuruz Zaman         9 party:90 Liberal Democrats MTW:E05000723 Coldhurst                       2016-05-05 0 0           PP90   0
8516 14907 Phelyp Bennett         9 party:52 Conservative and Unionist Party MTW:E05000724 Crompton                       2016-05-05 0 0           PP52   0
8517 14908 Nicholas Adam Godleman         9 party:85 UK Independence Party (UKIP) MTW:E05000724 Crompton                       2016-05-05 0 0           PP85   0
8518 14909 Bernard Judge         9 party:53 Labour Party MTW:E05000724 Crompton                       2016-05-05 0 0           PP53   0
8519 14910 Diane Williamson         9 party:90 Liberal Democrats MTW:E05000724 Crompton                       2016-05-05 0 0           PP90   0
8520 14911 Cherryl Anne Brock         9 party:53 Labour Party MTW:E05000725 Failsworth East                       2016-05-05 0 0           PP53   0
8521 14912 Antony Cahill         9 party:52 Conservative and Unionist Party MTW:E05000725 Failsworth East                       2016-05-05 0 0           PP52   0
8522 14913 Andy Hunter-Rossall     male   9 party:63 Green Party MTW:E05000725 Failsworth East     https://my.greenparty.org.uk/candidates/105791       https://static-candidates.democracyclub.org.uk/media/images/images/14913.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=860870939155759104 2016-05-05 0 0           PP63   0
8523 14914 Chris Wise         9 party:90 Liberal Democrats MTW:E05000725 Failsworth East                       2016-05-05 0 0           PP90   0
8524 14915 Sean Eric Fielding         9 party:53 Labour Party MTW:E05000726 Failsworth West                       2016-05-05 0 0           PP53   0
8525 14916 Louie Michael Hamblett         9 party:90 Liberal Democrats MTW:E05000726 Failsworth West                       2016-05-05 0 0           PP90   0
8526 14917 Paul Martin         9 party:52 Conservative and Unionist Party MTW:E05000726 Failsworth West                       2016-05-05 0 0           PP52   0
8527 14918 Joan Spencer         9 party:85 UK Independence Party (UKIP) MTW:E05000726 Failsworth West                       2016-05-05 0 0           PP85   0
8528 14919 Brian Ames         9 party:53 Labour Party MTW:E05000727 Hollinwood                       2016-05-05 0 0           PP53   0
8529 14920 Martin Alexander Dinoff         9 party:90 Liberal Democrats MTW:E05000727 Hollinwood                       2016-05-05 0 0           PP90   0
8530 14921 Nicola Jeffery-Sykes         9 party:52 Conservative and Unionist Party MTW:E05000727 Hollinwood                       2016-05-05 0 0           PP52   0
8531 14922 Imran Sarwar         9 party:85 UK Independence Party (UKIP) MTW:E05000727 Hollinwood                       2016-05-05 0 0           PP85   0
8532 14923 Hasin Amin         9 party:52 Conservative and Unionist Party MTW:E05000728 Medlock Vale                       2016-05-05 0 0           PP52   0
8533 14924 Ur-Rehman Ateeque         9 party:53 Labour Party MTW:E05000728 Medlock Vale                       2016-05-05 0 0           PP53   0
8534 14925 John Christopher Berry         9 party:85 UK Independence Party (UKIP) MTW:E05000728 Medlock Vale                       2016-05-05 0 0           PP85   0
8535 14926 Jean Betteridge         9 party:63 Green Party MTW:E05000728 Medlock Vale                       2016-05-05 0 0           PP63   0
8536 14927 Mohammed Zakaullah         9 party:90 Liberal Democrats MTW:E05000728 Medlock Vale                       2016-05-05 0 0           PP90   0
8537 14928 Russell John Thomas Gosling         9 party:90 Liberal Democrats MTW:E05000729 Royton North                       2016-05-05 0 0           PP90   0
8538 14929 Ruth Keating         9 party:85 UK Independence Party (UKIP) MTW:E05000729 Royton North                       2016-05-05 0 0           PP85   0
8539 14930 James Anthony Larkin         9 party:53 Labour Party MTW:E05000729 Royton North                       2016-05-05 0 0           PP53   0
8540 14931 Lauren Pickering         9 party:63 Green Party MTW:E05000729 Royton North                       2016-05-05 0 0           PP63   0
8541 14932 Michele Stockton         9 party:52 Conservative and Unionist Party MTW:E05000729 Royton North                       2016-05-05 0 0           PP52   0
8542 14933 Amanda Clare Chadderton         9 party:53 Labour Party MTW:E05000730 Royton South                       2016-05-05 0 0           PP53   0
8543 14934 Allan Robert Fish         9 party:52 Conservative and Unionist Party MTW:E05000730 Royton South                       2016-05-05 0 0           PP52   0
8544 14935 Vipran Srivastava         9 party:90 Liberal Democrats MTW:E05000730 Royton South                       2016-05-05 0 0           PP90   0
8545 14936 Jim Stidworthy         9 party:63 Green Party MTW:E05000730 Royton South                       2016-05-05 0 0           PP63   0
8546 14937 Sean Raymond Curley         9 party:52 Conservative and Unionist Party MTW:E05000731 Saddleworth North                       2016-05-05 0 0           PP52   0
8547 14938 Catherine Hunter-Rossall         9 party:63 Green Party MTW:E05000731 Saddleworth North                       2016-05-05 0 0           PP63   0
8548 14939 Rob Knotts         9 ynmp-party:2 Independent MTW:E05000731 Saddleworth North                       2016-05-05 0 0           ynmp-party:2   0
8549 14940 Valerie Leach         9 party:53 Labour Party MTW:E05000731 Saddleworth North                       2016-05-05 0 0           PP53   0
8550 14941 Harry Moore         9 party:85 UK Independence Party (UKIP) MTW:E05000731 Saddleworth North                       2016-05-05 0 0           PP85   0
8551 14943 John Hudson         9 party:52 Conservative and Unionist Party MTW:E05000732 Saddleworth South                       2016-05-05 0 0           PP52   0
8552 14944 Ian Brian Manners         9 party:53 Labour Party MTW:E05000732 Saddleworth South                       2016-05-05 0 0           PP53   0
8553 14945 Stephen Barrow         9 party:90 Liberal Democrats MTW:E05000733 Saddleworth West and Lees                       2016-05-05 0 0   49223.0       PP90   0
8554 14946 Andris D'Adamo         9 party:52 Conservative and Unionist Party MTW:E05000733 Saddleworth West and Lees                       2016-05-05 0 0   44713.0       PP52   0
8555 14947 Stephen Gordon Hewitt         9 party:53 Labour Party MTW:E05000733 Saddleworth West and Lees                       2016-05-05 0 0           PP53   0
8556 14948 Ian Nurse         9 party:85 UK Independence Party (UKIP) MTW:E05000733 Saddleworth West and Lees                       2016-05-05 0 0           PP85   0
8557 14949 Ian James Bond         9 party:85 UK Independence Party (UKIP) MTW:E05000736 Shaw                       2016-05-05 0 0           PP85   0
8558 14950 Pam Byrne         9 party:52 Conservative and Unionist Party MTW:E05000736 Shaw                       2016-05-05 0 0           PP52   0
8559 14951 Hemmy Spiggott         9 party:53 Labour Party MTW:E05000736 Shaw                       2016-05-05 0 0           PP53   0
8560 14952 Howard David Sykes         9 party:90 Liberal Democrats MTW:E05000736 Shaw                       2016-05-05 0 0           PP90   0
8561 14954 Cath Ball         9 party:53 Labour Party MTW:E05000734 St James'                       2016-05-05 0 0           PP53   0
8562 14955 John David Caddick         9 party:52 Conservative and Unionist Party MTW:E05000734 St James'                       2016-05-05 0 0           PP52   0
8563 14956 Kevin Anthony Dawson         9 party:90 Liberal Democrats MTW:E05000734 St James'                       2016-05-05 0 0           PP90   0
8564 14957 Joseph Christopher Fitzpatrick         9 party:85 UK Independence Party (UKIP) MTW:E05000734 St James'                       2016-05-05 0 0           PP85   0
8565 14958 Roger Mark Pakeman         9 party:63 Green Party MTW:E05000734 St James'                       2016-05-05 0 0           PP63   0
8566 14960 Hussain Aftab         9 ynmp-party:2 Independent MTW:E05000735 St Mary's                       2016-05-05 0 0           ynmp-party:2   0
8567 14961 David Andrew Atherton         9 party:52 Conservative and Unionist Party MTW:E05000735 St Mary's                       2016-05-05 0 0           PP52   0
8568 14962 Angie Farrell         9 party:90 Liberal Democrats MTW:E05000735 St Mary's                       2016-05-05 0 0           PP90   0
8569 14963 Donna Elaine Godleman         9 party:85 UK Independence Party (UKIP) MTW:E05000735 St Mary's                       2016-05-05 0 0           PP85   0
8570 14964 Arooj Shah         9 party:53 Labour Party MTW:E05000735 St Mary's                       2016-05-05 0 0           PP53   0
8571 14974 Neil Allsopp         9 party:52 Conservative and Unionist Party MTW:E05000737 Waterhead                       2016-05-05 0 0           PP52   0
8572 14975 Linda Dawson         9 party:90 Liberal Democrats MTW:E05000737 Waterhead                       2016-05-05 0 0           PP90   0
8573 14976 Criona Franklin         9 party:63 Green Party MTW:E05000737 Waterhead                       2016-05-05 0 0           PP63   0
8574 14977 Ajawat Hussain         9 party:85 UK Independence Party (UKIP) MTW:E05000737 Waterhead                       2016-05-05 0 0           PP85   0
8575 14978 Vita Rose Price         9 party:53 Labour Party MTW:E05000737 Waterhead                       2016-05-05 0 0           PP53   0
8576 14981 Rehman Attiq         9 ynmp-party:2 Independent MTW:E05000738 Werneth                       2016-05-05 0 0           ynmp-party:2   0
8577 14982 Fida Hussain         9 party:53 Labour Party MTW:E05000738 Werneth                       2016-05-05 0 0           PP53   0
8578 14983 Jawaad Hussain         9 party:52 Conservative and Unionist Party MTW:E05000738 Werneth                       2016-05-05 0 0           PP52   0
8579 14984 Keith Pendlebury         9 party:90 Liberal Democrats MTW:E05000738 Werneth                       2016-05-05 0 0           PP90   0
8580 14985 Melodey Walker         9 party:63 Green Party MTW:E05000738 Werneth                       2016-05-05 0 0           PP63   0
8581 44698 John Hall         9 party:90 Liberal Democrats MTW:E05000721 Chadderton North                       2016-05-05 0 0   14895.0       PP90   0
Powered by Datasette · Query took 1.015ms