home / democracyclub

candidates

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

68 rows where election = 92

✎ 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, homepage_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
15002 15002 2524 John Shaw     male   local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004434 Brookvale and Kings Furlong       https://johnshaw.4mp.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/2524.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9690.0       PP90   0
15003 15003 4260 Paul Harvey     male   local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004445 Norden   1.0   http://drpaulharvey4basingstoke.nationbuilder.com/     https://static-candidates.democracyclub.org.uk/media/images/images/4260.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9710.0       PP53   0
15004 15004 5892 Malik Azam     Male   local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004450 Popley West                       2016-05-05 0 0           PP85   0
15005 15005 9681 Alan Geoffrey Ball         local.basingstoke-and-deane.2016-05-05 92 ynmp-party:2 Independent DIW:E05004437 Bramley and Sherfield                       2016-05-05 0 0           ynmp-party:2   0
15006 15006 9682 Stephen David Rothman     male   local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004437 Bramley and Sherfield                       2016-05-05 0 0           PP53   0
15007 15007 9683 Venetia Ann Rowland         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004437 Bramley and Sherfield   1.0                   2016-05-05 0 0           PP52   0
15008 15008 9684 Robert Charles Cooper         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004433 Brighton Hill South                       2016-05-05 0 0           PP90   0
15009 15009 9685 Philip Andrew Heath         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004433 Brighton Hill South                       2016-05-05 0 0           PP85   0
15010 15010 9686 Andrew David McCormick     male   local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004433 Brighton Hill South   1.0                   2016-05-05 0 0           PP53   0
15011 15011 9687 Jack Terence Cousens         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004434 Brookvale and Kings Furlong   1.0                   2016-05-05 0 0           PP53   0
15012 15012 9688 Edward Michael Norman         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004434 Brookvale and Kings Furlong                       2016-05-05 0 0           PP52   0
15013 15013 9689 John Picard         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004434 Brookvale and Kings Furlong                       2016-05-05 0 0           PP85   0
15014 15014 9691 John Barnes         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004435 Buckskin                       2016-05-05 0 0           PP90   0
15015 15015 9692 Tony Jones         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004435 Buckskin   1.0                   2016-05-05 0 0           PP53   0
15016 15016 9693 Brian Robert Simmonds         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004435 Buckskin                       2016-05-05 0 0           PP52   0
15017 15017 9694 David John White     male   local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004435 Buckskin                       2016-05-05 0 0           PP85   0
15018 15018 9695 Madeline Hussey         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004438 Chineham                       2016-05-05 0 0           PP90   0
15019 15019 9696 Peter John King         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004438 Chineham                       2016-05-05 0 0           PP85   0
15020 15020 9697 Laura Jane Morris         local.basingstoke-and-deane.2016-05-05 92 ynmp-party:2 Independent DIW:E05004438 Chineham                       2016-05-05 0 0           ynmp-party:2   0
15021 15021 9698 Elaine Frances Still         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004438 Chineham   1.0                   2016-05-05 0 0           PP52   0
15022 15022 9699 Spencer John Cleary         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004442 Hatch Warren and Beggarwood                       2016-05-05 0 0           PP85   0
15023 15023 9700 James Andrew McKenzie         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004442 Hatch Warren and Beggarwood                       2016-05-05 0 0           PP53   0
15024 15024 9701 Dan Putty         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004442 Hatch Warren and Beggarwood   1.0                   2016-05-05 0 0           PP52   0
15025 15025 9702 Richard Andrew Whitechurch         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004442 Hatch Warren and Beggarwood                       2016-05-05 0 0           PP90   0
15026 15026 9703 Anne Court         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004443 Kempshott   1.0                   2016-05-05 0 0           PP52   0
15027 15027 9704 Mark Hygate         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004443 Kempshott                       2016-05-05 0 0           PP85   0
15028 15028 9705 Walter Bell McCormick         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004443 Kempshott                       2016-05-05 0 0           PP53   0
15029 15029 9706 Ken Rhatigan         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004444 Kingsclere   1.0                   2016-05-05 0 0           PP52   0
15030 15030 9707 John Bernal Rodway         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004444 Kingsclere                       2016-05-05 0 0           PP53   0
15031 15031 9708 Roger Thorpe Ward         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004444 Kingsclere                       2016-05-05 0 0           PP90   0
15032 15032 9709 Mayola Evelien Blagdon         local.basingstoke-and-deane.2016-05-05 92 party:804 Trade Unionist and Socialist Coalition DIW:E05004445 Norden                       2016-05-05 0 0           PP804   0
15033 15033 9711 Jim Holder         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004445 Norden                       2016-05-05 0 0           PP52   0
15034 15034 9712 Doris Jones         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004445 Norden                       2016-05-05 0 0           PP90   0
15035 15035 9713 Duncan Philip Stone         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004445 Norden                       2016-05-05 0 0           PP85   0
15036 15036 9723 Martin John Baker         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004446 Oakley and North Waltham                       2016-05-05 0 0           PP90   0
15037 15037 9724 Julie Katherine Pierce         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004446 Oakley and North Waltham                       2016-05-05 0 0           PP53   0
15038 15038 9725 Diane Marilyn Taylor         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004446 Oakley and North Waltham   1.0                   2016-05-05 0 0           PP52   0
15039 15039 9726 Roger David Gardiner     male   local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004448 Pamber and Silchester   1.0                   2016-05-05 0 0           PP52   0
15040 15040 9727 Lydia Massey         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004448 Pamber and Silchester                       2016-05-05 0 0           PP53   0
15041 15041 9732 Kizzie Fenner     female   local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004449 Popley East             https://static-candidates.democracyclub.org.uk/media/images/images/9732.png   other roy2 Photo is from official parish council site - http://www.oldbasing.gov.uk/council/the-team/ 2016-05-05 0 0           PP52   0
15042 15042 9733 Alan Harvey Stone     male 1964.0 local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004449 Popley East           https://www.linkedin.com/in/alan-stone-41386b63 https://static-candidates.democracyclub.org.uk/media/images/5525efab413cb4432adffa5c.png   profile-photo JPCarrington Profile picture as featured on official party PPC pages here: http://www.myukip.com/parliamentary-candidates-a-b.html 2016-05-05 0 0   5586.0       PP85   0
15043 15043 9734 Janet Elizabeth Westbrook         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004449 Popley East   1.0                   2016-05-05 0 0           PP53   0
15044 15044 9735 Jane Kathleen Frankum         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004450 Popley West   1.0                   2016-05-05 0 0           PP53   0
15045 15045 9736 Jackie Saunders         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004450 Popley West                       2016-05-05 0 0           PP52   0
15046 15046 9737 John Bentham         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004451 Rooksdown ward                       2016-05-05 0 0           PP85   0
15047 15047 9738 Simon Edward Bound         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004451 Rooksdown ward   1.0                   2016-05-05 0 0           PP52   0
15048 15048 9739 Obi Nwasike         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004451 Rooksdown ward                       2016-05-05 0 0           PP90   0
15049 15049 9740 Tom Prince         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004451 Rooksdown ward                       2016-05-05 0 0           PP53   0
15050 15050 9741 Michael David Barham     male   local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004452 Sherborne St John ward                       2016-05-05 0 0           PP53   0
15051 15051 9742 Tristan Wyatt Robinson         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004452 Sherborne St John ward   1.0                   2016-05-05 0 0           PP52   0
15052 15052 9743 Colin David Regan     male   local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004453 South Ham   1.0                   2016-05-05 0 0           PP53   0
15053 15053 9744 Rebecca Anne Sanders         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004453 South Ham                       2016-05-05 0 0           PP52   0
15054 15054 9745 Alan Stretton Simpson         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004453 South Ham                       2016-05-05 0 0   24144.0       PP85   0
15055 15055 9746 Claire Louise Ballard         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004455 Tadley South                       2016-05-05 0 0           PP53   0
15056 15056 9747 David Alan Leeks     male   local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004455 Tadley South   1.0                   2016-05-05 0 0           PP52   0
15057 15057 9748 Jo Slimin         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004455 Tadley South                       2016-05-05 0 0           PP90   0
15058 15058 9749 Chloe Jane Ashfield         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004457 Whitchurch   1.0                   2016-05-05 0 0           PP53   0
15059 15059 9750 Dave George         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004457 Whitchurch                       2016-05-05 0 0           PP52   0
15060 15060 9751 Steve Neilson         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004457 Whitchurch                       2016-05-05 0 0           PP90   0
15061 15061 9752 Mike Bound         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004431 Baughurst and Tadley North   1.0                   2016-05-05 0 0           PP90   0
15062 15062 9753 Nalin Mahinda Jayawardena         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004431 Baughurst and Tadley North                       2016-05-05 0 0           PP52   0
15063 15063 9754 George Whitley Porter         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004431 Baughurst and Tadley North                       2016-05-05 0 0           PP53   0
15064 15064 9755 Sven Howard Godesen         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004430 Basing                       2016-05-05 0 0           PP52   0
15065 15065 9756 Andrew Douglas Mountford         local.basingstoke-and-deane.2016-05-05 92 party:53 Labour Party DIW:E05004430 Basing                       2016-05-05 0 0           PP53   0
15066 15066 9757 Alan John Read         local.basingstoke-and-deane.2016-05-05 92 party:90 Liberal Democrats DIW:E05004430 Basing                       2016-05-05 0 0           PP90   0
15067 15067 9758 Stan Tennison         local.basingstoke-and-deane.2016-05-05 92 party:85 UK Independence Party (UKIP) DIW:E05004430 Basing                       2016-05-05 0 0           PP85   0
15068 15068 17258 Ian Alexander Smith         local.basingstoke-and-deane.2016-05-05 92 party:52 Conservative and Unionist Party DIW:E05004433 Brighton Hill South                       2016-05-05 0 0           PP52   0
15069 15069 17259 Richard Simon Winter     male   local.basingstoke-and-deane.2016-05-05 92 party:63 Green Party DIW:E05004433 Brighton Hill South     https://my.greenparty.org.uk/candidates/105799       https://static-candidates.democracyclub.org.uk/media/images/images/17259.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/105799 2016-05-05 0 0           PP63   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.543ms · Data license: CC-BY-SA · Data source: Democracy Club