home / democracyclub

candidates

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

50 rows where election = 70

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_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
13024 13024 5876 Alan Durrant     male   local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004538 Forton     https://www.gosportlabour.co.uk/gosport-elections-2018/chris-percival-christchurch-2-2/ http://www.alandurrant4gosport.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/5876.png   profile-photo gosportlabour1 Most recent photo of candidate 2016-05-05 0 0   15935;38402       PP53   0
13025 13025 13840 Diane Hilda Furlong         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004540 Hardway                       2016-05-05 0 0           PP52   0
13026 13026 13841 Stephen James Marshall         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004540 Hardway                       2016-05-05 0 0           PP90   0
13027 13027 13842 Mark Smith     male   local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004540 Hardway     https://www.gosportlabour.co.uk/gosport-elections-2018/mark-smith-for-hardway/       https://static-candidates.democracyclub.org.uk/media/images/images/13842.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/mark-smith-for-hardway/ 2016-05-05 0 0           PP53   0
13028 13028 14161 Philip Iain Raffaelli         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004532 Anglesey                       2016-05-05 0 0           PP52   0
13029 13029 14162 David Langton Waite         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004532 Anglesey                       2016-05-05 0 0           PP53   0
13030 13030 15887 Jonathan Eaton     male   local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004531 Alverstoke     https://www.gosportlabour.co.uk/gosport-elections-2018/jonathan-eaton-alverstoke/                 2016-05-05 0 0   15885.0       PP53   0
13031 13031 15888 Mark William Paul Hook         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004531 Alverstoke                       2016-05-05 0 0           PP52   0
13032 13032 15895 Tasha Hook         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004533 Bridgemary North                       2016-05-05 0 0           PP52   0
13033 13033 15896 Jill Madeline Wright         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004533 Bridgemary North                       2016-05-05 0 0           PP53   0
13034 13034 15902 Peter Batty         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004534 Bridgemary South                       2016-05-05 0 0           PP53   0
13035 13035 15903 Kath Jones         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004534 Bridgemary South                       2016-05-05 0 0           PP52   0
13036 13036 15909 James Fox     male   local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004535 Brockhurst     https://www.gosportlabour.co.uk/gosport-elections-2018/jim-fox-bridgemary-south/                 2016-05-05 0 0           PP53   0
13037 13037 15910 Robert Leonard Hylands         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004535 Brockhurst                       2016-05-05 0 0           PP90   0
13038 13038 15911 Jane Staffieri         local.gosport.2016-05-05 70 party:63 Green Party DIW:E05004535 Brockhurst                       2016-05-05 0 0           PP63   0
13039 13039 15912 Gary David Walker     male 1967.0 local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004535 Brockhurst     http://www.gosportconservatives.org/person/mr-gary-walker       https://static-candidates.democracyclub.org.uk/media/images/images/15912.png   profile-photo JeniT from their party page at http://www.gosportconservatives.org/person/mr-gary-walker 2016-05-05 0 0           PP52   0
13040 13040 15922 Richard James Dickson         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004536 Christchurch                       2016-05-05 0 0           PP52   0
13041 13041 15923 Dawn Christina Kelly         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004536 Christchurch                       2016-05-05 0 0           PP90   0
13042 13042 15924 Charis Noakes     female   local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004536 Christchurch     https://www.gosportlabour.co.uk/gosport-elections-2018/charis-noakes-leesland/       https://static-candidates.democracyclub.org.uk/media/images/images/15924.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/charis-noakes-leesland/ 2016-05-05 0 0           PP53   0
13043 13043 15929 Richard Philip Earle         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004537 Elson                       2016-05-05 0 0           PP90   0
13044 13044 15930 Craig Thomas Hazel         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004537 Elson                       2016-05-05 0 0           PP52   0
13045 13045 15931 Louie Christina Sykes         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004537 Elson                       2016-05-05 0 0           PP53   0
13046 13046 15936 Dale Fletcher         local.gosport.2016-05-05 70 ynmp-party:2 Independent DIW:E05004538 Forton                       2016-05-05 0 0           ynmp-party:2   0
13047 13047 15937 Chloe Marie Palmer     Female 1989.0 local.gosport.2016-05-05 70 party:85 UK Independence Party (UKIP) DIW:E05004538 Forton     http://www.ukip.org/candidates2017     https://www.linkedin.com/in/chloe-palmer-4295107a/ https://static-candidates.democracyclub.org.uk/media/images/images/15937.png   copyright-assigned PrincessChloe   2016-05-05 0 0           PP85   0
13048 13048 15938 Angela Jane Prickett         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004538 Forton                       2016-05-05 0 0           PP90   0
13049 13049 15939 Rebecca Stares         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004538 Forton                       2016-05-05 0 0           PP52   0
13050 13050 15949 John Alan Bowles         local.gosport.2016-05-05 70 party:85 UK Independence Party (UKIP) DIW:E05004539 Grange                       2016-05-05 0 0           PP85   0
13051 13051 15950 Sean Evans         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004539 Grange                       2016-05-05 0 0           PP90   0
13052 13052 15951 Maggie Morgan         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004539 Grange                       2016-05-05 0 0           PP52   0
13053 13053 15952 David Malcolm Pollard         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004539 Grange                       2016-05-05 0 0           PP53   0
13054 13054 15957 Graham Burgess         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004541 Lee East                       2016-05-05 0 0           PP52   0
13055 13055 15958 Nancy Ruth Hurworth         local.gosport.2016-05-05 70 party:63 Green Party DIW:E05004541 Lee East                       2016-05-05 0 0           PP63   0
13056 13056 15959 Caroline Osborne     female   local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004541 Lee East     https://www.gosportlabour.co.uk/gosport-elections-2018/caroline-osborne-lee-on-solent-east/       https://static-candidates.democracyclub.org.uk/media/images/images/15959.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/caroline-osborne-lee-on-solent-east/ 2016-05-05 0 0           PP53   0
13057 13057 15960 John Beavis         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004542 Lee West                       2016-05-05 0 0           PP52   0
13058 13058 15961 Peter Hurworth         local.gosport.2016-05-05 70 party:63 Green Party DIW:E05004542 Lee West                       2016-05-05 0 0           PP63   0
13059 13059 15962 Jill Whitcher     female   local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004542 Lee West     https://www.gosportlabour.co.uk/gosport-elections-2018/jill-whitcher-lee-on-solent-west/       https://static-candidates.democracyclub.org.uk/media/images/images/15962.png   profile-photo sjorford https://www.gosportlabour.co.uk/gosport-elections-2018/jill-whitcher-lee-on-solent-west/ 2016-05-05 0 0           PP53   0
13060 13060 15963 Steve Butterworth         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004543 Leesland                       2016-05-05 0 0           PP52   0
13061 13061 15964 Maria Jane Diffey         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004543 Leesland                       2016-05-05 0 0           PP90   0
13062 13062 15965 Michael John Madgwick         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004543 Leesland                       2016-05-05 0 0           PP53   0
13063 13063 15966 David Eugen Sekules         local.gosport.2016-05-05 70 party:63 Green Party DIW:E05004543 Leesland                       2016-05-05 0 0           PP63   0
13064 13064 15967 Paul Noakes         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004544 Peel Common     https://www.gosportlabour.co.uk/gosport-elections-2018/paul-noakes-for-anglesey/                 2016-05-05 0 0           PP53   0
13065 13065 15968 Stephen Philpott         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004544 Peel Common                       2016-05-05 0 0           PP52   0
13066 13066 15969 Zoe Huggins         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004545 Privett                       2016-05-05 0 0           PP52   0
13067 13067 15970 James Bertram Tomlinson         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004545 Privett                       2016-05-05 0 0           PP53   0
13068 13068 15971 Jean Ann Batterbury         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004546 Rowner and Holbrook                       2016-05-05 0 0           PP53   0
13069 13069 15972 Karen Elizabeth Bergin         local.gosport.2016-05-05 70 party:85 UK Independence Party (UKIP) DIW:E05004546 Rowner and Holbrook                       2016-05-05 0 0           PP85   0
13070 13070 15973 Marcus Thomas Murphy         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004546 Rowner and Holbrook                       2016-05-05 0 0           PP52   0
13071 13071 15974 Keith Cyril Farr         local.gosport.2016-05-05 70 party:53 Labour Party DIW:E05004547 Town                       2016-05-05 0 0           PP53   0
13072 13072 15975 Sam Matthias Hayward-Vernon         local.gosport.2016-05-05 70 party:90 Liberal Democrats DIW:E05004547 Town                       2016-05-05 0 0           PP90   0
13073 13073 15976 Simon Barry Lockyer         local.gosport.2016-05-05 70 party:52 Conservative and Unionist Party DIW:E05004547 Town                       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 7.052ms · Data license: CC-BY-SA · Data source: Democracy Club