home / democracyclub

candidates

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

7 rows where election = 96

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: email, twitter_username, image_url, image_uploading_user_notes, twitter_user_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
15255 15255 4666 Winston McKenzie     male 1953-10-23 local.croydon.2016-05-05 96 party:17 English Democrats LBW:E05000168 West Thornton     http://ukiplambeth.co.uk/   https://en.wikipedia.org/wiki/Winston_McKenzie   https://static-candidates.democracyclub.org.uk/media/images/55268e7959bbc5c063445b86.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 0   1098;19462       PP17   0
15256 15256 5630 Ace Nnorom     male   local.croydon.2016-05-05 96 party:85 UK Independence Party (UKIP) LBW:E05000168 West Thornton     http://ukiplambeth.co.uk/     https://uk.linkedin.com/pub/ace-nnorom/2a/b72/b71 https://static-candidates.democracyclub.org.uk/media/images/55390a40539d9492693b0973.png   profile-photo JPCarrington Profile picture used on party's official PPC site here: http://www.myukip.com/parliamentary-candidates-t-z.html 2016-05-05 0 0           PP85   0
15257 15257 19461 David Thomas Beall         local.croydon.2016-05-05 96 party:63 Green Party LBW:E05000168 West Thornton                       2016-05-05 0 0           PP63   0
15258 15258 19463 Peter Morgan         local.croydon.2016-05-05 96 party:1918 Independence from Europe LBW:E05000168 West Thornton                       2016-05-05 0 0           PP1918   0
15259 15259 19464 Geoff Morley         local.croydon.2016-05-05 96 party:90 Liberal Democrats LBW:E05000168 West Thornton                       2016-05-05 0 0           PP90   0
15260 15260 19465 Scott James Roche         local.croydon.2016-05-05 96 party:52 Conservative and Unionist Party LBW:E05000168 West Thornton                       2016-05-05 0 0           PP52   0
15261 15261 19466 Callton Lloyd Young         local.croydon.2016-05-05 96 party:53 Labour Party LBW:E05000168 West Thornton                       2016-05-05 0 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.587ms · Data license: CC-BY-SA · Data source: Democracy Club