home / democracyclub

candidates

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

91 rows where election = 9

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