home / democracyclub

candidates

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

12 rows where election = 59

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, birth_date, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, wikipedia_url, linkedin_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, parlparse_id, theyworkforyou_url, favourite_biscuits

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
12390 12390 502 Zac Goldsmith     male 1975-01-20 mayor.london.2016-05-05 59 party:52 Conservative and Unionist Party mayor:london Mayor of London     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Goldsmith_Zac.aspx http://www.zacgoldsmith.com/ https://en.wikipedia.org/wiki/Zac_Goldsmith   https://static-candidates.democracyclub.org.uk/media/images/55351f40b247335574a42e7e.png   other andylolz License: Creative Commons Attribution 2.0 Generic license Source: https://commons.wikimedia.org/wiki/File:Zac_Goldsmith_KewGardens.jpg Author: Annie Mole 2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/24911 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/24911 PP52 Chocolate digestive 0
12391 12391 1551 Paul Golding     male   mayor.london.2016-05-05 59 party:2214 Britain First mayor:london Mayor of London     https://www.britainfirst.org/people/paul-golding/   https://en.wikipedia.org/wiki/Paul_Golding https://uk.linkedin.com/in/paul-golding-410426ab https://static-candidates.democracyclub.org.uk/media/images/images/7927.png   profile-photo carlc Facebook profile photo: https://www.facebook.com/people/Paul-Golding/100009362546312 2016-05-05 0 0   7927;7963       PP2214   0
12392 12392 3068 Dave Furness     male 1966.0 mayor.london.2016-05-05 59 party:3960 British National Party mayor:london Mayor of London     https://bnp.org.uk/bnp-candidate-david-furness/       https://static-candidates.democracyclub.org.uk/media/images/images/3068.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=784900120563290112 2016-05-05 0 0   7926;34739       PP3960   0
12393 12393 4754 George Galloway     male 1954-08-16 mayor.london.2016-05-05 59 party:362 The Respect Party mayor:london Mayor of London       http://georgegalloway.com/v2/ https://en.wikipedia.org/wiki/George_Galloway   https://static-candidates.democracyclub.org.uk/media/images/54b9e5cfcb19ebca71e2af6e.png         2016-05-05 0 0   1175.0   uk.org.publicwhip/person/uk.org.publicwhip/person/10218 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/10218 PP362   0
12394 12394 7455 Sadiq Khan     male 1970-10-08 mayor.london.2016-05-05 59 party:53 Labour Party mayor:london Mayor of London   1.0 http://www.sadiq.london/ http://www.sadiqkhan.org.uk/ https://en.wikipedia.org/wiki/Sadiq_Khan   https://static-candidates.democracyclub.org.uk/media/images/images/7455.png   other tfgg From https://en.wikipedia.org/wiki/Sadiq_Khan#/media/File:Sadiq_Khan.jpg , under OGL 2016-05-05 0 0   3385.0   uk.org.publicwhip/person/uk.org.publicwhip/person/11878 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/11878 PP53 Chocolate Hobnob 0
12395 12395 7456 Caroline Pidgeon   MBE female 1972-09-29 mayor.london.2016-05-05 59 party:90 Liberal Democrats mayor:london Mayor of London     http://www.londonlibdems.org.uk/caroline_pidgeon http://www.carolinepidgeon.org/ https://en.wikipedia.org/wiki/Caroline_Pidgeon   https://static-candidates.democracyclub.org.uk/media/images/images/7456.png   profile-photo j0e_m Caroline's official twitter directed me to this photo. https://twitter.com/CarolinePidgeon/status/706872961538658304 2016-05-05 0 0   2173;7853       PP90   0
12396 12396 7457 Peter Whittle     male 1961-01-06 mayor.london.2016-05-05 59 party:85 UK Independence Party (UKIP) mayor:london Mayor of London       http://www.peterwhittle.london/ https://en.wikipedia.org/wiki/Peter_Whittle_(British_politician)   https://static-candidates.democracyclub.org.uk/media/images/images/7457.png   profile-photo tfgg From www.peterwhittle.london 2016-05-05 0 0   4936.0       PP85   0
12397 12397 7545 Sophie Walker     Female 1971-05-27 mayor.london.2016-05-05 59 party:2755 Women's Equality Party mayor:london Mayor of London     http://www.womensequality.org.uk/shipley_announcement   https://en.wikipedia.org/wiki/Sophie_Walker https://www.linkedin.com/in/sophie-walker-2117a847 https://static-candidates.democracyclub.org.uk/media/images/images/7545.png   profile-photo louisecrow   2016-05-05 0 0           PP2755   0
12398 12398 7647 John Zylinski Prince   male 1951.0 mayor.london.2016-05-05 59 ynmp-party:2 Independent mayor:london Mayor of London       http://www.zylinski.london     https://static-candidates.democracyclub.org.uk/media/images/images/7647.png   profile-photo carlc Official photo from facebook: https://www.facebook.com/JanZylinskiUK/photos/a.761385753974837.1073741827.761383517308394/874783709301707/?type=3&theater 2016-05-05 0 0           ynmp-party:2   0
12399 12399 7677 Lee Harris     male 1936.0 mayor.london.2016-05-05 59 party:2552 Cannabis is Safer than Alcohol mayor:london Mayor of London     http://cista.org/candidates/34 http://lee4mayor.com https://en.wikipedia.org/wiki/Lee_Harris_(South_African_artist)   https://static-candidates.democracyclub.org.uk/media/images/images/7677.png   profile-photo Zhyl Used on his Twitter 2016-05-05 0 0           PP2552   0
12400 12400 7928 Ankit Love     male 1983-08-07 mayor.london.2016-05-05 59 party:2838 One Love Party mayor:london Mayor of London     http://oneloveparty.eu/london2016 http://ankitlove.com/   https://www.linkedin.com/in/ankit-love-58085372 https://static-candidates.democracyclub.org.uk/media/images/images/7928.png   profile-photo carlc Facebook Page profile photo:https://www.facebook.com/ankitlove/?pnref=story 2016-05-05 0 0           PP2838   0
12401 12401 34835 Siân Berry     female 1974-07-09 mayor.london.2016-05-05 59 party:63 Green Party mayor:london Mayor of London     https://my.greenparty.org.uk/candidates/106004 http://sianberry.london/ https://en.wikipedia.org/wiki/Si%C3%A2n_Berry https://www.linkedin.com/in/sian-berry-23917524/ https://static-candidates.democracyclub.org.uk/media/images/images/7452.png   public-domain tfgg Declared public domain here https://en.wikipedia.org/wiki/Si%C3%A2n_Berry#/media/File:Sian_berry.jpg 2016-05-05 0 0   7452.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 6.515ms · Data license: CC-BY-SA · Data source: Democracy Club