home / democracyclub

candidates

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

91 rows where election = 9

View and edit SQL

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