home / democracyclub

candidates

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

53 rows where election = 13

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, image_url, image_copyright, image_uploading_user, 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
8825 8825 6872 Glyn Redican     Male 1949.0 local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001593 Mersey             https://static-candidates.democracyclub.org.uk/media/images/5547439c70823d2655a7c7a1.png   profile-photo mark It's his Facebook cover photo, from: https://www.facebook.com/glyn.redican 2016-05-05 0 0           PP85   0
8826 8826 7228 Victor Turton Mr   male   local.halton.2016-05-05 13 ynmp-party:2 Independent UTW:E05001577 Appleton       https://victurton.wordpress.com/eu-and-my-thoughts/     https://static-candidates.democracyclub.org.uk/media/images/images/7228.png   other ripperger2345   2016-05-05 0 0   15993.0       ynmp-party:2   0
8827 8827 13854 Lauren Rhea Cassidy         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001594 Norton North                       2016-05-05 0 0           PP53   0
8828 8828 13855 Diane Marie Inch         local.halton.2016-05-05 13 party:90 Liberal Democrats UTW:E05001594 Norton North                       2016-05-05 0 0           PP90   0
8829 8829 13856 Matthew Keith Lambert         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001594 Norton North                       2016-05-05 0 0           PP52   0
8830 8830 14246 Brad Bradshaw         local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001592 Kingsway                       2016-05-05 0 0           PP85   0
8831 8831 14247 Margaret Horabin         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001592 Kingsway                       2016-05-05 0 0           PP53   0
8832 8832 14248 John Robert Powell         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001592 Kingsway                       2016-05-05 0 0   39246.0       PP52   0
8833 8833 14612 Pauline Sinnott         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001593 Mersey                       2016-05-05 0 0           PP53   0
8834 8834 14613 Granville Spencer         local.halton.2016-05-05 13 party:90 Liberal Democrats UTW:E05001593 Mersey                       2016-05-05 0 0   39282.0       PP90   0
8835 8835 15991 Eddie Jones         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001577 Appleton                       2016-05-05 0 0           PP53   0
8836 8836 15992 Colin Rowan     male   local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001577 Appleton                       2016-05-05 0 0   39254.0       PP52   0
8837 8837 15998 Adam Burnett         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001578 Beechwood                       2016-05-05 0 0   39375.0       PP52   0
8838 8838 15999 Philip Busow         local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001578 Beechwood                       2016-05-05 0 0   39284.0       PP85   0
8839 8839 16000 Geoffrey Michael Logan         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001578 Beechwood                       2016-05-05 0 0           PP53   0
8840 8840 16001 Linda Redhead         local.halton.2016-05-05 13 party:90 Liberal Democrats UTW:E05001578 Beechwood                       2016-05-05 0 0   39264.0       PP90   0
8841 8841 16007 Callum Hough         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001579 Birchfield                       2016-05-05 0 0           PP52   0
8842 8842 16008 Bill Woolfall         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001579 Birchfield                       2016-05-05 0 0           PP53   0
8843 8843 16018 Tony McDermott         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001580 Broadheath   1.0                   2016-05-05 0 0           PP53   0
8844 8844 16023 Marjorie Bradshaw         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001582 Daresbury                       2016-05-05 0 0           PP52   0
8845 8845 16024 Miriam Lorraine Hodge         local.halton.2016-05-05 13 party:90 Liberal Democrats UTW:E05001582 Daresbury                       2016-05-05 0 0   39376.0       PP90   0
8846 8846 16025 Colin William Hughes         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001582 Daresbury                       2016-05-05 0 0           PP53   0
8847 8847 16026 Paul David Griffiths         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001583 Ditton                       2016-05-05 0 0   39329.0       PP52   0
8848 8848 16027 Kieran Reed         local.halton.2016-05-05 13 ynmp-party:2 Independent UTW:E05001583 Ditton                       2016-05-05 0 0           ynmp-party:2   0
8849 8849 16028 Marie Wright         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001583 Ditton                       2016-05-05 0 0           PP53   0
8850 8850 16029 Colleen Mary Harper         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001584 Farnworth                       2016-05-05 0 0           PP52   0
8851 8851 16030 Val Hill         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001584 Farnworth                       2016-05-05 0 0           PP53   0
8852 8852 16038 John Bernard Abbott         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001585 Grange                       2016-05-05 0 0           PP53   0
8853 8853 16039 Peter Hallwood         local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001585 Grange                       2016-05-05 0 0           PP85   0
8854 8854 16040 Joanna Allison Rowe         local.halton.2016-05-05 13 party:90 Liberal Democrats UTW:E05001585 Grange                       2016-05-05 0 0           PP90   0
8855 8855 16045 Stef Nelson         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001587 Halton Brook                       2016-05-05 0 0           PP53   0
8856 8856 16046 Tracey Spencer         local.halton.2016-05-05 13 party:90 Liberal Democrats UTW:E05001587 Halton Brook                       2016-05-05 0 0           PP90   0
8857 8857 16047 Rochelle Carney         local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001581 Halton Castle                       2016-05-05 0 0           PP85   0
8858 8858 16048 Harry Neil Howard         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001581 Halton Castle                       2016-05-05 0 0           PP53   0
8859 8859 16049 Darrin Whyte         local.halton.2016-05-05 13 ynmp-party:2 Independent UTW:E05001581 Halton Castle                       2016-05-05 0 0           ynmp-party:2   0
8860 8860 16054 Ruth Elizabeth Rowan         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001588 Halton Lea                       2016-05-05 0 0           PP52   0
8861 8861 16055 Dave Thompson         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001588 Halton Lea                       2016-05-05 0 0           PP53   0
8862 8862 16056 Jayne Busow         local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001589 Halton View                       2016-05-05 0 0           PP85   0
8863 8863 16057 Duncan James Robert Harper         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001589 Halton View                       2016-05-05 0 0           PP52   0
8864 8864 16058 Rob Polhill         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001589 Halton View                       2016-05-05 0 0           PP53   0
8865 8865 16063 Ian John Adams         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001590 Heath                       2016-05-05 0 0           PP52   0
8866 8866 16064 Rosie Leck         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001590 Heath                       2016-05-05 0 0   39361.0       PP53   0
8867 8867 16065 Gareth Charles Stockton         local.halton.2016-05-05 13 party:90 Liberal Democrats UTW:E05001590 Heath                       2016-05-05 0 0           PP90   0
8868 8868 16066 Michelle Watson         local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001590 Heath                       2016-05-05 0 0           PP85   0
8869 8869 16071 Joanne McLean         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001591 Hough Green                       2016-05-05 0 0           PP52   0
8870 8870 16072 Paul Nolan         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001591 Hough Green                       2016-05-05 0 0           PP53   0
8871 8871 16073 Ronald John Hignett         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001595 Norton South                       2016-05-05 0 0           PP53   0
8872 8872 16074 William John Ring         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001595 Norton South                       2016-05-05 0 0           PP52   0
8873 8873 16079 Thomas Michael Glynn         local.halton.2016-05-05 13 party:85 UK Independence Party (UKIP) UTW:E05001596 Riverside                       2016-05-05 0 0   39326.0       PP85   0
8874 8874 16080 Stan Hill         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001596 Riverside                       2016-05-05 0 0           PP53   0
8875 8875 16085 Philip Harper         local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001597 Windmill Hill ward                       2016-05-05 0 0   39241.0       PP52   0
8876 8876 16086 Pauline Hignett         local.halton.2016-05-05 13 party:53 Labour Party UTW:E05001597 Windmill Hill ward                       2016-05-05 0 0           PP53   0
8877 8877 19433 Daniel Clarke     male   local.halton.2016-05-05 13 party:52 Conservative and Unionist Party UTW:E05001593 Mersey                       2016-05-05 0 0           PP52   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 6.515ms · Data license: CC-BY-SA · Data source: Democracy Club