Data license: CC-BY-SA · Data source: Democracy Club
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 | twitter_username | facebook_page_url | party_ppc_page_url | facebook_personal_url | homepage_url | wikipedia_url | linkedin_url | image_url | proxy_image_url_template | image_copyright | image_uploading_user | image_uploading_user_notes | twitter_user_id | 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://www.facebook.com/glyn.redican | 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 | VTurton | https://victurton.wordpress.com/eu-and-my-thoughts/ | https://static-candidates.democracyclub.org.uk/media/images/images/7228.png | other | ripperger2345 | 555313916 | 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 | https://www.facebook.com/Strongvoiceforyou/ | 2016-05-05 | 0 | 0 | PP52 | 0 |
JSON shape: default, array, newline-delimited
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))