home / democracyclub

democracyclub

Custom SQL query returning 54 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
14656 550 Jackie Grunsell     female   88 party:804 Trade Unionist and Socialist Coalition DIW:E05005264 Reedley                       2016-05-05 0 0           PP804   0
14657 5730 Mick Waddington     male   88 party:85 UK Independence Party (UKIP) DIW:E05005250 Barrowford                       2016-05-05 0 0           PP85   0
14658 18916 Ian Barnett     male 1955-09-26 88 party:63 Green Party DIW:E05005250 Barrowford     https://my.greenparty.org.uk/candidates/106129       https://static-candidates.democracyclub.org.uk/media/images/images/18916_dZRGxXg.png   public-domain ian3   2016-05-05 0 0           PP63   0
14659 18917 Sue Nike         88 party:53 Labour Party DIW:E05005250 Barrowford                       2016-05-05 0 0           PP53   0
14660 18918 Robert Andrew Oliver         88 party:53 Labour Party DIW:E05005250 Barrowford                       2016-05-05 0 0           PP53   0
14661 18919 Ken Turner         88 party:52 Conservative and Unionist Party DIW:E05005250 Barrowford                       2016-05-05 0 0           PP52   0
14662 18920 Christian Wakeford         88 party:52 Conservative and Unionist Party DIW:E05005250 Barrowford                       2016-05-05 0 0           PP52   0
14663 18921 Margaret Sarah Foxley         88 party:52 Conservative and Unionist Party DIW:E05005252 Boulsworth                       2016-05-05 0 0           PP52   0
14664 18922 Heather Ann Greaves         88 party:90 Liberal Democrats DIW:E05005252 Boulsworth                       2016-05-05 0 0           PP90   0
14665 18923 David Phillip Johns         88 party:53 Labour Party DIW:E05005252 Boulsworth                       2016-05-05 0 0           PP53   0
14666 18924 Mohammad Aslam         88 party:52 Conservative and Unionist Party DIW:E05005253 Bradley                       2016-05-05 0 0           PP52   0
14667 18925 Mohammad Sakib         88 party:53 Labour Party DIW:E05005253 Bradley                       2016-05-05 0 0           PP53   0
14668 18926 Howard Philip Thomas         88 party:90 Liberal Democrats DIW:E05005253 Bradley                       2016-05-05 0 0           PP90   0
14669 18927 Naeem Hussain Ashraf         88 party:53 Labour Party DIW:E05005254 Brierfield                       2016-05-05 0 0           PP53   0
14670 18928 Keith Wilkinson         88 party:52 Conservative and Unionist Party DIW:E05005254 Brierfield                       2016-05-05 0 0           PP52   0
14671 18929 Eileen Ansar         88 party:53 Labour Party DIW:E05005255 Clover Hill                       2016-05-05 0 0           PP53   0
14672 18930 Janice Taylor         88 party:52 Conservative and Unionist Party DIW:E05005255 Clover Hill                       2016-05-05 0 0           PP52   0
14673 18931 Marjorie Adams         88 party:90 Liberal Democrats DIW:E05005256 Coates                       2016-05-05 0 0           PP90   0
14674 18932 Harry Purcell         88 party:52 Conservative and Unionist Party DIW:E05005256 Coates                       2016-05-05 0 0           PP52   0
14675 18933 Ghulam Abbas Ullah         88 party:53 Labour Party DIW:E05005256 Coates                       2016-05-05 0 0           PP53   0
14676 18934 Jane Veronica Bailes Wood         88 party:63 Green Party DIW:E05005256 Coates                       2016-05-05 0 0           PP63   0
14677 18935 Ken Hartley         88 party:90 Liberal Democrats DIW:E05005257 Craven                       2016-05-05 0 0           PP90   0
14678 18936 Anthony James Lancaster         88 party:90 Liberal Democrats DIW:E05005257 Craven                       2016-05-05 0 0           PP90   0
14679 18937 Valerie Langtree         88 party:52 Conservative and Unionist Party DIW:E05005257 Craven                       2016-05-05 0 0           PP52   0
14680 18938 Richard Michael Oliver         88 party:85 UK Independence Party (UKIP) DIW:E05005257 Craven                       2016-05-05 0 0           PP85   0
14681 18939 Mark Porter         88 party:53 Labour Party DIW:E05005257 Craven                       2016-05-05 0 0           PP53   0
14682 18940 Jenny Purcell         88 party:52 Conservative and Unionist Party DIW:E05005257 Craven                       2016-05-05 0 0           PP52   0
14683 18941 Rosemary Elizabeth Carroll         88 party:52 Conservative and Unionist Party DIW:E05008551 Earby                       2016-05-05 0 0           PP52   0
14684 18942 Ian James Lyons         88 party:90 Liberal Democrats DIW:E05008551 Earby                       2016-05-05 0 0           PP90   0
14685 18943 Russell Tennant         88 party:53 Labour Party DIW:E05008551 Earby                       2016-05-05 0 0           PP53   0
14686 18944 Steve Petty         88 party:52 Conservative and Unionist Party DIW:E05005261 Horsfield                       2016-05-05 0 0           PP52   0
14687 18945 Louise Antoinette Whitehead         88 party:90 Liberal Democrats DIW:E05005261 Horsfield                       2016-05-05 0 0           PP90   0
14688 18946 Ann Marie Wrigley         88 joint-party:53-119 Labour and Co-operative Party DIW:E05005261 Horsfield                       2016-05-05 0 0           joint-party:53-119   0
14689 18947 Tommy Cooney         88 party:52 Conservative and Unionist Party DIW:E05005262 Marsden                       2016-05-05 0 0           PP52   0
14690 18948 John Barry Richardson         88 party:53 Labour Party DIW:E05005262 Marsden                       2016-05-05 0 0           PP53   0
14691 18949 John Rowe         88 party:3960 British National Party DIW:E05005262 Marsden                       2016-05-05 0 0           PP3960   0
14692 18950 Musawar Raza Arshad         88 party:52 Conservative and Unionist Party DIW:E05005264 Reedley                       2016-05-05 0 0           PP52   0
14693 18951 Mohammad Hanif         88 party:53 Labour Party DIW:E05005264 Reedley                       2016-05-05 0 0           PP53   0
14694 18952 Nigel Lofthouse         88 party:85 UK Independence Party (UKIP) DIW:E05005264 Reedley                       2016-05-05 0 0           PP85   0
14695 18953 James Wood         88 party:90 Liberal Democrats DIW:E05005264 Reedley                       2016-05-05 0 0           PP90   0
14696 18954 Saanval Safir         88 party:52 Conservative and Unionist Party DIW:E05005265 Southfield                       2016-05-05 0 0           PP52   0
14697 18955 Sheila Wicks         88 joint-party:53-119 Labour and Co-operative Party DIW:E05005265 Southfield                       2016-05-05 0 0           joint-party:53-119   0
14698 18956 Glennda Louise Clegg         88 party:90 Liberal Democrats DIW:E05005266 Vivary Bridge                       2016-05-05 0 0           PP90   0
14699 18957 Nathan Thomas McCollum         88 party:52 Conservative and Unionist Party DIW:E05005266 Vivary Bridge                       2016-05-05 0 0           PP52   0
14700 18958 Ian William Tweedie         88 party:53 Labour Party DIW:E05005266 Vivary Bridge                       2016-05-05 0 0           PP53   0
14701 18959 George Adam         88 party:53 Labour Party DIW:E05005267 Walverden                       2016-05-05 0 0           PP53   0
14702 18960 Abdul Aziz         88 party:52 Conservative and Unionist Party DIW:E05005267 Walverden                       2016-05-05 0 0           PP52   0
14703 18961 Ian Graham         88 party:53 Labour Party DIW:E05005268 Waterside                       2016-05-05 0 0           PP53   0
14704 18962 Anthony Robert Greaves         88 party:90 Liberal Democrats DIW:E05005268 Waterside                       2016-05-05 0 0           PP90   0
14705 18963 David Richard John Penney         88 party:63 Green Party DIW:E05005268 Waterside                       2016-05-05 0 0           PP63   0
14706 18964 Ash Sutcliffe         88 party:52 Conservative and Unionist Party DIW:E05005268 Waterside                       2016-05-05 0 0           PP52   0
14707 18965 Nadeem Ahmed         88 party:90 Liberal Democrats DIW:E05005269 Whitefield                       2016-05-05 0 0           PP90   0
14708 18966 Adrian Robert Barrett         88 party:53 Labour Party DIW:E05005269 Whitefield                       2016-05-05 0 0           PP53   0
14709 18967 Jess McNamara         88 party:52 Conservative and Unionist Party DIW:E05005269 Whitefield                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 0.698ms