home / democracyclub

candidates

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

13 rows where election = 4

View and edit SQL

Suggested facets: gender, party_id, party_name, post_id, post_label, email, twitter_username, party_ppc_page_url, image_url, 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 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
8203 19601 Kate Bramson         local.southwark.2016-05-05 4 party:52 Conservative and Unionist Party LBW:E05000538                     2016-05-05 0 0           PP52   0
8204 19602 Brigid Gardner Ms   Female   local.southwark.2016-05-05 4 party:90 Liberal Democrats LBW:E05000538     http://www.southwark-libdems.org.uk/dulwich_village_candidates       https://static-candidates.democracyclub.org.uk/media/images/images/36112.png   JackyC123 The photo is on the candidate's website 2016-05-05 0 0   36112.0       PP90   0
8205 19603 Denis Pougin         local.southwark.2016-05-05 4 party:2137 All People's Party LBW:E05000538                     2016-05-05 0 0           PP2137   0
8206 19604 Toby Prescott         local.southwark.2016-05-05 4 party:85 UK Independence Party (UKIP) LBW:E05000538                     2016-05-05 0 0           PP85   0
8207 19605 Dale Leslie Rapley     male   local.southwark.2016-05-05 4 party:63 Green Party LBW:E05000538             https://static-candidates.democracyclub.org.uk/media/images/images/19605.png   bookshelf   2016-05-05 0 0           PP63   0
8208 19611 Siobhan Gite Aarons         local.southwark.2016-05-05 4 party:52 Conservative and Unionist Party LBW:E05000544                     2016-05-05 0 0           PP52   0
8209 19612 Terry Adewale         local.southwark.2016-05-05 4 party:2137 All People's Party LBW:E05000544                     2016-05-05 0 0           PP2137   0
8210 19613 Michelle Deborah Baharier         local.southwark.2016-05-05 4 ynmp-party:2 Independent LBW:E05000544                     2016-05-05 0 0           ynmp-party:2   0
8211 19614 James Coldwell     male   local.southwark.2016-05-05 4 party:53 Labour Party LBW:E05000544     http://www.southwarklabour.co.uk/2018wards/newington.aspx       https://static-candidates.democracyclub.org.uk/media/images/images/19614.png   roy2 Photo is from Southwark Labour party website - http://www.southwarklabour.co.uk/2018wards/newington.aspx 2016-05-05 0 0           PP53   0
8212 19615 Nick Hooper         local.southwark.2016-05-05 4 party:63 Green Party LBW:E05000544                     2016-05-05 0 0           PP63   0
8213 19616 Martin Shapland         local.southwark.2016-05-05 4 party:90 Liberal Democrats LBW:E05000544                     2016-05-05 0 0           PP90   0
8214 19617 Gawain Howard Wilkinson Towler         local.southwark.2016-05-05 4 party:85 UK Independence Party (UKIP) LBW:E05000544                     2016-05-05 0 0           PP85   0
8215 48117 Catherine Rose         local.southwark.2016-05-05 4 party:53 Labour Party LBW:E05000538                     2016-05-05 0 0   19606.0       PP53   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.417ms · Data license: CC-BY-SA · Data source: Democracy Club