home / democracyclub

democracyclub

Custom SQL query returning 51 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
11648 4725 Stephen Watson     male   49 party:53 Labour Party DIW:E05005153 Cliviger with Worsthorne       http://bedfordbypass.com/               2016-05-05 0 0           PP53   0
11649 5527 Tom Commis     male   49 party:85 UK Independence Party (UKIP) DIW:E05005153 Cliviger with Worsthorne             https://static-candidates.democracyclub.org.uk/media/images/images/5527.png   profile-photo BURNLEY UKIP   2016-05-05 0 0           PP85   0
11650 7081 Laura Fisk Ms   Female   49 party:63 Green Party DIW:E05005159 Lanehead     https://my.greenparty.org.uk/candidates/105863 https://burnleypendle.greenparty.org.uk     https://static-candidates.democracyclub.org.uk/media/images/5531360c0eda8c847a39084b.png   profile-photo ian3 Laura Fisks Election Agent 2016-05-05 0 0           PP63   0
11651 13876 Andrew Robert Newhouse         49 party:52 Conservative and Unionist Party DIW:E05005153 Cliviger with Worsthorne                       2016-05-05 0 0           PP52   0
11652 13994 Stephanie Forrest         49 party:90 Liberal Democrats DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP90   0
11653 13995 Marcus Johnstone         49 joint-party:53-119 Labour and Co-operative Party DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           joint-party:53-119   0
11654 13996 Ceri Jane Carmichael         49 party:63 Green Party DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP63   0
11655 13997 Mark Henry Girven         49 party:85 UK Independence Party (UKIP) DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP85   0
11656 13998 Christopher Vanns         49 party:3960 British National Party DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP3960   0
11657 14824 Peter Michael Bradley         49 party:90 Liberal Democrats DIW:E05005150 Bank Hall                       2016-05-05 0 0           PP90   0
11658 14825 Lubna Khan         49 party:53 Labour Party DIW:E05005150 Bank Hall                       2016-05-05 0 0           PP53   0
11659 15063 Syd Khan         49 party:53 Labour Party DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP53   0
11660 15064 Margaret Ann Lishman         49 party:90 Liberal Democrats DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP90   0
11661 15065 James MacDonald         49 party:63 Green Party DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP63   0
11662 15066 Ian Metcalf         49 party:85 UK Independence Party (UKIP) DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP85   0
11663 15067 Tom Watson         49 party:52 Conservative and Unionist Party DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP52   0
11664 15081 Sandra Ann Byrne         49 party:90 Liberal Democrats DIW:E05005152 Brunshaw                       2016-05-05 0 0           PP90   0
11665 15082 Jamie McGowan         49 party:85 UK Independence Party (UKIP) DIW:E05005152 Brunshaw                       2016-05-05 0 0           PP85   0
11666 15083 Lian Pate         49 party:53 Labour Party DIW:E05005152 Brunshaw                       2016-05-05 0 0           PP53   0
11667 15088 Ibrahim Ali         49 party:53 Labour Party DIW:E05005154 Coal Clough with Deerplay                       2016-05-05 0 0           PP53   0
11668 15089 Bill Brindle         49 party:90 Liberal Democrats DIW:E05005154 Coal Clough with Deerplay                       2016-05-05 0 0           PP90   0
11669 15090 Anne Whittles         49 party:63 Green Party DIW:E05005154 Coal Clough with Deerplay                       2016-05-05 0 0           PP63   0
11670 15091 Mubashir Aftab         49 party:90 Liberal Democrats DIW:E05005155 Daneshouse with Stoneyholme                       2016-05-05 0 0           PP90   0
11671 15092 Saeed Akhtar Chaudhary         49 party:53 Labour Party DIW:E05005155 Daneshouse with Stoneyholme                       2016-05-05 0 0           PP53   0
11672 15095 Christopher Barnett         49 party:3960 British National Party DIW:E05005156 Gannow                       2016-05-05 0 0           PP3960   0
11673 15096 Mark Payne         49 party:90 Liberal Democrats DIW:E05005156 Gannow                       2016-05-05 0 0           PP90   0
11674 15097 Jai Redman         49 party:63 Green Party DIW:E05005156 Gannow                       2016-05-05 0 0           PP63   0
11675 15098 Christine Sollis         49 party:53 Labour Party DIW:E05005156 Gannow                       2016-05-05 0 0           PP53   0
11676 15099 Brendan John Morris         49 party:90 Liberal Democrats DIW:E05005157 Gawthorpe                       2016-05-05 0 0           PP90   0
11677 15100 Andy Tatchell         49 party:53 Labour Party DIW:E05005157 Gawthorpe                       2016-05-05 0 0           PP53   0
11678 15101 Ivor Christopher Emo         49 party:52 Conservative and Unionist Party DIW:E05005158 Hapton with Park                       2016-05-05 0 0           PP52   0
11679 15102 Alan Hosker         49 party:85 UK Independence Party (UKIP) DIW:E05005158 Hapton with Park             https://static-candidates.democracyclub.org.uk/media/images/images/15102.png   public-domain noel This photo is Cllr Hosker's pic on the Burnley Council web site 2016-05-05 0 0           PP85   0
11680 15103 Howard Leigh Hudson         49 party:53 Labour Party DIW:E05005158 Hapton with Park                       2016-05-05 0 0           PP53   0
11681 15104 Leslie Williams         49 party:90 Liberal Democrats DIW:E05005158 Hapton with Park                       2016-05-05 0 0           PP90   0
11682 15105 Asif Raja         49 party:53 Labour Party DIW:E05005159 Lanehead                       2016-05-05 0 0           PP53   0
11683 15106 Paula Christine Riley         49 party:90 Liberal Democrats DIW:E05005159 Lanehead                       2016-05-05 0 0           PP90   0
11684 15115 Gavin Mark Hartley         49 party:804 Trade Unionist and Socialist Coalition DIW:E05005160 Queensgate                       2016-05-05 0 0           PP804   0
11685 15116 Arif Khan         49 party:53 Labour Party DIW:E05005160 Queensgate                       2016-05-05 0 0           PP53   0
11686 15117 Arthur Gordon Lishman         49 party:90 Liberal Democrats DIW:E05005160 Queensgate                       2016-05-05 0 0           PP90   0
11687 15118 Paul Campbell         49 party:53 Labour Party DIW:E05005162 Rosehill with Burnley Wood                       2016-05-05 0 0           PP53   0
11688 15119 Georgina Hannah Ormrod         49 party:63 Green Party DIW:E05005162 Rosehill with Burnley Wood                       2016-05-05 0 0           PP63   0
11689 15120 Christine Eleanor White         49 party:90 Liberal Democrats DIW:E05005162 Rosehill with Burnley Wood                       2016-05-05 0 0           PP90   0
11690 15129 Stewart Bone         49 party:90 Liberal Democrats DIW:E05005163 Trinity                       2016-05-05 0 0           PP90   0
11691 15130 Andy Fewings     male   49 party:63 Green Party DIW:E05005163 Trinity             https://static-candidates.democracyclub.org.uk/media/images/images/15130.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1132279039 2016-05-05 0 0           PP63   0
11692 15131 Tony Martin         49 joint-party:53-119 Labour and Co-operative Party DIW:E05005163 Trinity                       2016-05-05 0 0           joint-party:53-119   0
11693 15132 Andy Devanney         49 party:53 Labour Party DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP53   0
11694 15133 Alfie Jones         49 party:63 Green Party DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP63   0
11695 15134 Tony Moores         49 party:52 Conservative and Unionist Party DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP52   0
11696 15135 Chris Rawson         49 party:85 UK Independence Party (UKIP) DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP85   0
11697 15136 David Roper         49 party:90 Liberal Democrats DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP90   0
11698 19086 Kathryn Haworth         49 party:90 Liberal Democrats DIW:E05005153 Cliviger with Worsthorne                       2016-05-05 0 0           PP90   0
Powered by Datasette · Query took 0.71ms