home / democracyclub

candidates

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

67 rows where election = 28

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, wikipedia_url, linkedin_url, image_url, image_copyright, 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
9572 9572 1429 Ian Curtis     male   local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008531 Ramsey             https://static-candidates.democracyclub.org.uk/media/images/images/1429.png   other JeniT from his councillor page at https://applications.huntingdonshire.gov.uk/moderngov/mgUserInfo.aspx?UID=2680 2016-05-05 0 0   9044.0       PP52   0
9573 9573 1907 Lord Toby Jug     male 1965-12-18 local.huntingdonshire.2016-05-05 28 party:2413 The Eccentric Party of Great Britain DIW:E05008580 St Ives South       http://www.eccentricparty.com/ https://en.wikipedia.org/wiki/Lord_Toby_Jug   https://static-candidates.democracyclub.org.uk/media/images/54e20730438d6af41666ea84.png         2016-05-05 0 0   7384.0       PP2413   0
9574 9574 4359 Nik Johnson Dr   male   local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008533 St Neots Eynesbury     http://www.labour.org.uk/people/detail/nik-johnson       https://static-candidates.democracyclub.org.uk/media/images/images/4359.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9072.0       PP53   0
9575 9575 5035 Paul Bullen     male 1958.0 local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05008937 St Ives East     http://www.huntsukip.org.uk/Paul-Bullen.html       https://static-candidates.democracyclub.org.uk/media/images/5526945c59bbc5c063445bdb.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-f-k.html 2016-05-05 0 0   9056.0       PP85   0
9576 9576 7495 Jason Ablewhite     male   local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008937 St Ives East         https://en.wikipedia.org/wiki/Jason_Ablewhite   https://static-candidates.democracyclub.org.uk/media/images/images/7495.png   profile-photo phil@philrodgers.co.uk From candidate's "Public Figure" page on Facebook at https://www.facebook.com/JasonAblewhitePCC/ 2016-05-05 0 0   9055.0       PP52   0
9577 9577 7611 Lisa Ann Duffy Cllr   Female 1968.0 local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05008531 Ramsey                       2016-05-05 0 0   9045.0       PP85   0
9578 9578 9029 Rob Gardiner     Male   local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05002763 Brampton       http://huntingdonlabourparty.org.uk/               2016-05-05 0 0           PP53   0
9579 9579 9030 John Paul Morris   FCIH MCMI Male   local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05002763 Brampton       http://www.huntingdonlibdems.org.uk/   https://www.linkedin.com/in/johnmorris7543 https://static-candidates.democracyclub.org.uk/media/images/images/9030.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
9580 9580 9031 Lin Sinclair         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002763 Brampton                       2016-05-05 0 0           PP52   0
9581 9581 9032 Keith Warren Stukins         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002769 Godmanchester                       2016-05-05 0 0           PP52   0
9582 9582 9033 Samuel Paul Sweek         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05002769 Godmanchester     http://huntingdonlabourparty.org.uk/samuel-sweek/                 2016-05-05 0 0           PP53   0
9583 9583 9034 David Richard Underwood     male   local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05002769 Godmanchester       https://davidunderwood2.wordpress.com/               2016-05-05 0 0           PP90   0
9584 9584 9035 Tom Fletcher         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002771 Huntingdon East                       2016-05-05 0 0           PP52   0
9585 9585 9036 Marion Kadewere         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05002771 Huntingdon East                       2016-05-05 0 0           PP53   0
9586 9586 9037 Michael Frederick Shellens     Male   local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05002771 Huntingdon East                       2016-05-05 0 0   24510.0       PP90   0
9587 9587 9039 Peter Henry Ashcroft         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05002772 Huntingdon North                       2016-05-05 0 0           PP85   0
9588 9588 9040 Patrick Kadewere     male   local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05002772 Huntingdon North     http://huntingdonlabourparty.org.uk/patrick-kadewere/       https://static-candidates.democracyclub.org.uk/media/images/images/9040.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
9589 9589 9041 Alan James Mackender-Lawrence         local.huntingdonshire.2016-05-05 28 ynmp-party:2 Independent DIW:E05002772 Huntingdon North                       2016-05-05 0 0           ynmp-party:2   0
9590 9590 9042 Richard Valatka         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002772 Huntingdon North                       2016-05-05 0 0           PP52   0
9591 9591 9043 Lakkana Rajiv Peiris Yalagala     male   local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05002772 Huntingdon North       https://libdemhuntingdonnorth.wordpress.com/               2016-05-05 0 0   24519.0       PP90   0
9592 9592 9046 Kevin John Minnette         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008531 Ramsey                       2016-05-05 0 0           PP53   0
9593 9593 9047 Nicholas Vaughan Ashley         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05002784 Sawtry                       2016-05-05 0 0           PP85   0
9594 9594 9048 Nikki Elliott         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002784 Sawtry                       2016-05-05 0 0           PP52   0
9595 9595 9049 Jonathan Hugh Orchard         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05002784 Sawtry                       2016-05-05 0 0           PP53   0
9596 9596 9050 Dick Tuplin         local.huntingdonshire.2016-05-05 28 ynmp-party:2 Independent DIW:E05002784 Sawtry                       2016-05-05 0 0           ynmp-party:2   0
9597 9597 9051 Steve Criswell         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008938 Somersham                       2016-05-05 0 0           PP52   0
9598 9598 9053 Iain Ramsbottom Mr   male 1960-06-17 local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008938 Somersham             https://static-candidates.democracyclub.org.uk/media/images/images/9053.png   other Iain Ramsbottom I took this picture 2016-05-05 0 0           PP53 KitKat 0
9599 9599 9054 Shirley Joy Reeve         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05008938 Somersham                       2016-05-05 0 0           PP85   0
9600 9600 9057 Angela Louise Richards         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008937 St Ives East                       2016-05-05 0 0           PP53   0
9601 9601 9058 Colin Macrae Saunderson         local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05008937 St Ives East                       2016-05-05 0 0           PP90   0
9602 9602 9059 Richard John Allen         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05002779 St Ives West                       2016-05-05 0 0           PP53   0
9603 9603 9060 Ryan Fuller     male   local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002779 St Ives West             https://static-candidates.democracyclub.org.uk/media/images/images/9060.png   other StuBez On council website: https://applications.huntingdonshire.gov.uk/moderngov/mgUserInfo.aspx?UID=2814 2016-05-05 0 0           PP52   0
9604 9604 9061 David Frederick Hodge     male   local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05002779 St Ives West                       2016-05-05 0 0   24520.0       PP90   0
9605 9605 9062 Margaret Teresa King         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05002779 St Ives West                       2016-05-05 0 0           PP85   0
9606 9606 9063 Bob Farrer         local.huntingdonshire.2016-05-05 28 ynmp-party:2 Independent DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           ynmp-party:2   0
9607 9607 9064 Sandie Giles         local.huntingdonshire.2016-05-05 28 ynmp-party:2 Independent DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           ynmp-party:2   0
9608 9608 9065 Anna Elizabeth Hayward         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           PP53   0
9609 9609 9066 Melina LaFirenze         local.huntingdonshire.2016-05-05 28 party:63 Green Party DIW:E05008581 St Neots Eaton Ford             https://static-candidates.democracyclub.org.uk/media/images/images/9066.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
9610 9610 9067 Graham John Welton         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008581 St Neots Eaton Ford                       2016-05-05 0 0           PP52   0
9611 9611 9068 Derek Arthur Giles         local.huntingdonshire.2016-05-05 28 ynmp-party:2 Independent DIW:E05002781 St Neots Eaton Socon                       2016-05-05 0 0           ynmp-party:2   0
9612 9612 9069 Patricia Anne Nicholls         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05002781 St Neots Eaton Socon                       2016-05-05 0 0           PP53   0
9613 9613 9070 Keith Ivan Prentice     male   local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002781 St Neots Eaton Socon       http://www.keithprentice.com/               2016-05-05 0 0           PP52   0
9614 9614 9071 Jim Corley         local.huntingdonshire.2016-05-05 28 ynmp-party:2 Independent DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0   19455;24904       ynmp-party:2   0
9615 9615 9073 Tony McNeill         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0   44401.0       PP53   0
9616 9616 9074 Robert Anthony Moores         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0           PP52   0
9617 9617 9075 Simone Leigh Taylor         local.huntingdonshire.2016-05-05 28 ynmp-party:2 Independent DIW:E05008533 St Neots Eynesbury                       2016-05-05 0 0           ynmp-party:2   0
9618 9618 9076 Adrian Lee Usher         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008533 St Neots Eynesbury           https://www.linkedin.com/in/adrian-usher-82a84688           2016-05-05 0 0           PP52   0
9619 9619 9077 Alison Donaldson         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008535 The Hemingfords                       2016-05-05 0 0           PP52   0
9620 9620 9078 Philip Foster         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05008535 The Hemingfords                       2016-05-05 0 0           PP85   0
9621 9621 9080 David John Priestman     Male   local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05008535 The Hemingfords                       2016-05-05 0 0   24528.0       PP90   0
9622 9622 9081 Kevin Roy Goddard         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008939 Warboys and Bury                       2016-05-05 0 0           PP53   0
9623 9623 9082 Tony Hulme         local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05008939 Warboys and Bury                       2016-05-05 0 0   24529.0       PP90   0
9624 9624 9083 Mick Mean         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05008939 Warboys and Bury                       2016-05-05 0 0           PP85   0
9625 9625 9084 Jill Tavener     female   local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008939 Warboys and Bury                       2016-05-05 0 0           PP52   0
9626 9626 9085 Colin Moody         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05002790 Yaxley and Farcet                       2016-05-05 0 0           PP85   0
9627 9627 9086 Graeme Leslie Watkins         local.huntingdonshire.2016-05-05 28 joint-party:53-119 Labour and Co-operative Party DIW:E05002790 Yaxley and Farcet     https://party.coop/person/graeme-watkins/                 2016-05-05 0 0           joint-party:53-119   0
9628 9628 9087 Desmond Watt         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05002790 Yaxley and Farcet                       2016-05-05 0 0           PP52   0
9629 9629 19414 James Edward Bartrick     Male   local.huntingdonshire.2016-05-05 28 party:90 Liberal Democrats DIW:E05008579 Little Paxton                       2016-05-05 0 0   24527.0       PP90   0
9630 9630 19415 Nicholas Janson Kumbula         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP53   0
9631 9631 19416 Daniel Morris         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP85   0
9632 9632 19417 Laurence Roland Swain         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP52   0
9633 9633 19418 Liz Timms         local.huntingdonshire.2016-05-05 28 party:63 Green Party DIW:E05008579 Little Paxton                       2016-05-05 0 0           PP63   0
9634 9634 19419 Lynne Alexandra Bullen         local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05008580 St Ives South                       2016-05-05 0 0           PP85   0
9635 9635 19420 John Winston Davies         local.huntingdonshire.2016-05-05 28 party:52 Conservative and Unionist Party DIW:E05008580 St Ives South                       2016-05-05 0 0           PP52   0
9636 9636 28047 John Watson         local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008580 St Ives South                       2016-05-05 0 0   19421.0       PP53   0
9637 9637 38136 Rob Leach Mr       local.huntingdonshire.2016-05-05 28 party:53 Labour Party DIW:E05008535 The Hemingfords                       2016-05-05 0 0   9079.0       PP53   0
9638 9638 44368 Tom Varghese     male   local.huntingdonshire.2016-05-05 28 party:85 UK Independence Party (UKIP) DIW:E05002771 Huntingdon East             https://static-candidates.democracyclub.org.uk/media/images/images/44368.png   profile-photo jane38   2016-05-05 0 0   9038.0       PP85   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.771ms · Data license: CC-BY-SA · Data source: Democracy Club