home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

51 rows where election = 49

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, homepage_url, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, party_ec_id

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id post_label mapit_url elected party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes election_date election_current party_lists_in_use party_list_position old_person_ids gss_code parlparse_id theyworkforyou_url party_ec_id favourite_biscuits cancelled_poll
11648 11648 4725 Stephen Watson     male   local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005153 Cliviger with Worsthorne       http://bedfordbypass.com/               2016-05-05 0 0           PP53   0
11649 11649 5527 Tom Commis     male   local.burnley.2016-05-05 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 11650 7081 Laura Fisk Ms   Female   local.burnley.2016-05-05 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 11651 13876 Andrew Robert Newhouse         local.burnley.2016-05-05 49 party:52 Conservative and Unionist Party DIW:E05005153 Cliviger with Worsthorne                       2016-05-05 0 0           PP52   0
11652 11652 13994 Stephanie Forrest         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP90   0
11653 11653 13995 Marcus Johnstone         local.burnley.2016-05-05 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 11654 13996 Ceri Jane Carmichael         local.burnley.2016-05-05 49 party:63 Green Party DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP63   0
11655 11655 13997 Mark Henry Girven         local.burnley.2016-05-05 49 party:85 UK Independence Party (UKIP) DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP85   0
11656 11656 13998 Christopher Vanns         local.burnley.2016-05-05 49 party:3960 British National Party DIW:E05005161 Rosegrove with Lowerhouse                       2016-05-05 0 0           PP3960   0
11657 11657 14824 Peter Michael Bradley         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005150 Bank Hall                       2016-05-05 0 0           PP90   0
11658 11658 14825 Lubna Khan         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005150 Bank Hall                       2016-05-05 0 0           PP53   0
11659 11659 15063 Syd Khan         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP53   0
11660 11660 15064 Margaret Ann Lishman         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP90   0
11661 11661 15065 James MacDonald         local.burnley.2016-05-05 49 party:63 Green Party DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP63   0
11662 11662 15066 Ian Metcalf         local.burnley.2016-05-05 49 party:85 UK Independence Party (UKIP) DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP85   0
11663 11663 15067 Tom Watson         local.burnley.2016-05-05 49 party:52 Conservative and Unionist Party DIW:E05005151 Briercliffe                       2016-05-05 0 0           PP52   0
11664 11664 15081 Sandra Ann Byrne         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005152 Brunshaw                       2016-05-05 0 0           PP90   0
11665 11665 15082 Jamie McGowan         local.burnley.2016-05-05 49 party:85 UK Independence Party (UKIP) DIW:E05005152 Brunshaw                       2016-05-05 0 0           PP85   0
11666 11666 15083 Lian Pate         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005152 Brunshaw                       2016-05-05 0 0           PP53   0
11667 11667 15088 Ibrahim Ali         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005154 Coal Clough with Deerplay                       2016-05-05 0 0           PP53   0
11668 11668 15089 Bill Brindle         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005154 Coal Clough with Deerplay                       2016-05-05 0 0           PP90   0
11669 11669 15090 Anne Whittles         local.burnley.2016-05-05 49 party:63 Green Party DIW:E05005154 Coal Clough with Deerplay                       2016-05-05 0 0           PP63   0
11670 11670 15091 Mubashir Aftab         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005155 Daneshouse with Stoneyholme                       2016-05-05 0 0           PP90   0
11671 11671 15092 Saeed Akhtar Chaudhary         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005155 Daneshouse with Stoneyholme                       2016-05-05 0 0           PP53   0
11672 11672 15095 Christopher Barnett         local.burnley.2016-05-05 49 party:3960 British National Party DIW:E05005156 Gannow                       2016-05-05 0 0           PP3960   0
11673 11673 15096 Mark Payne         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005156 Gannow                       2016-05-05 0 0           PP90   0
11674 11674 15097 Jai Redman         local.burnley.2016-05-05 49 party:63 Green Party DIW:E05005156 Gannow                       2016-05-05 0 0           PP63   0
11675 11675 15098 Christine Sollis         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005156 Gannow                       2016-05-05 0 0           PP53   0
11676 11676 15099 Brendan John Morris         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005157 Gawthorpe                       2016-05-05 0 0           PP90   0
11677 11677 15100 Andy Tatchell         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005157 Gawthorpe                       2016-05-05 0 0           PP53   0
11678 11678 15101 Ivor Christopher Emo         local.burnley.2016-05-05 49 party:52 Conservative and Unionist Party DIW:E05005158 Hapton with Park                       2016-05-05 0 0           PP52   0
11679 11679 15102 Alan Hosker         local.burnley.2016-05-05 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 11680 15103 Howard Leigh Hudson         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005158 Hapton with Park                       2016-05-05 0 0           PP53   0
11681 11681 15104 Leslie Williams         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005158 Hapton with Park                       2016-05-05 0 0           PP90   0
11682 11682 15105 Asif Raja         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005159 Lanehead                       2016-05-05 0 0           PP53   0
11683 11683 15106 Paula Christine Riley         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005159 Lanehead                       2016-05-05 0 0           PP90   0
11684 11684 15115 Gavin Mark Hartley         local.burnley.2016-05-05 49 party:804 Trade Unionist and Socialist Coalition DIW:E05005160 Queensgate                       2016-05-05 0 0           PP804   0
11685 11685 15116 Arif Khan         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005160 Queensgate                       2016-05-05 0 0           PP53   0
11686 11686 15117 Arthur Gordon Lishman         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005160 Queensgate                       2016-05-05 0 0           PP90   0
11687 11687 15118 Paul Campbell         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005162 Rosehill with Burnley Wood                       2016-05-05 0 0           PP53   0
11688 11688 15119 Georgina Hannah Ormrod         local.burnley.2016-05-05 49 party:63 Green Party DIW:E05005162 Rosehill with Burnley Wood                       2016-05-05 0 0           PP63   0
11689 11689 15120 Christine Eleanor White         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005162 Rosehill with Burnley Wood                       2016-05-05 0 0           PP90   0
11690 11690 15129 Stewart Bone         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005163 Trinity                       2016-05-05 0 0           PP90   0
11691 11691 15130 Andy Fewings     male   local.burnley.2016-05-05 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 11692 15131 Tony Martin         local.burnley.2016-05-05 49 joint-party:53-119 Labour and Co-operative Party DIW:E05005163 Trinity                       2016-05-05 0 0           joint-party:53-119   0
11693 11693 15132 Andy Devanney         local.burnley.2016-05-05 49 party:53 Labour Party DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP53   0
11694 11694 15133 Alfie Jones         local.burnley.2016-05-05 49 party:63 Green Party DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP63   0
11695 11695 15134 Tony Moores         local.burnley.2016-05-05 49 party:52 Conservative and Unionist Party DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP52   0
11696 11696 15135 Chris Rawson         local.burnley.2016-05-05 49 party:85 UK Independence Party (UKIP) DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP85   0
11697 11697 15136 David Roper         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005164 Whittlefield with Ightenhill                       2016-05-05 0 0           PP90   0
11698 11698 19086 Kathryn Haworth         local.burnley.2016-05-05 49 party:90 Liberal Democrats DIW:E05005153 Cliviger with Worsthorne                       2016-05-05 0 0           PP90   0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "candidates" (
"id" INTEGER,
  "name" TEXT,
  "honorific_prefix" REAL,
  "honorific_suffix" REAL,
  "gender" TEXT,
  "birth_date" REAL,
  "election" INTEGER,
  "party_id" TEXT,
  "party_name" TEXT,
  "post_id" TEXT,
  "post_label" TEXT,
  "mapit_url" INTEGER,
  "elected" REAL,
  "email" TEXT,
  "twitter_username" REAL,
  "facebook_page_url" REAL,
  "party_ppc_page_url" REAL,
  "facebook_personal_url" REAL,
  "homepage_url" REAL,
  "wikipedia_url" REAL,
  "linkedin_url" REAL,
  "image_url" REAL,
  "proxy_image_url_template" INTEGER,
  "image_copyright" REAL,
  "image_uploading_user" REAL,
  "image_uploading_user_notes" REAL,
  "twitter_user_id" INTEGER,
  "election_date" TEXT,
  "election_current" INTEGER,
  "party_lists_in_use" INTEGER,
  "party_list_position" INTEGER,
  "old_person_ids" REAL,
  "gss_code" INTEGER,
  "parlparse_id" REAL,
  "theyworkforyou_url" REAL,
  "party_ec_id" TEXT,
  "favourite_biscuits" REAL,
  "cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))
Powered by Datasette · Query took 7.426ms · Data license: CC-BY-SA · Data source: Democracy Club