home / democracyclub

candidates

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

71 rows where election = 61

View and edit SQL

Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_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 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
12408 4373 Chris Worsey     male   local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001266     http://www.labour.org.uk/people/detail/chris-worsey       https://static-candidates.democracyclub.org.uk/media/images/5481e832b150e238702c05aa.png       2016-05-05 0 0           PP53   0
12409 5373 Rob Buckman Mr   male 1978-04-21 local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001278     https://my.greenparty.org.uk/candidates/106270       https://static-candidates.democracyclub.org.uk/media/images/5517e05f249b917507bee500.png   Rob_Buckman I am the candidate 2016-05-05 0 0   18385;34547       PP63   0
12410 5848 Pete Durnell Mr   Male 1963-07-13 local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001262     http://www.myukip.com/parliamentary-candidates-t-z.html http://www.petedurnell.com/     https://static-candidates.democracyclub.org.uk/media/images/5534f139b247335574a42e1d.png   pete6   2016-05-05 0 0           PP85   0
12411 6386 Mark Redding     Male 1972-06-12 local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001262     https://my.greenparty.org.uk/candidates/106270       https://static-candidates.democracyclub.org.uk/media/images/551aa9cee2ac8b7333e6a271.png   markredding   2016-05-05 0 0   18971.0       PP63   0
12412 14094 Michael Gary Allen     Male 1968-02-16 local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001260             https://static-candidates.democracyclub.org.uk/media/images/images/14094.png   Mike Allen - GP The photo used here is my official profile image. 2016-05-05 0 0           PP63 Plain Chocolate Digestive 0
12413 14095 Ann Jaron     female   local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001260             https://static-candidates.democracyclub.org.uk/media/images/images/14095.png   mike.astill Sandwell District Council web site 2016-05-05 0 0           PP53   0
12414 14096 Richard Antony Kemp         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001260                     2016-05-05 0 0           PP52   0
12415 14145 Marie Louise Butler         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001279                     2016-05-05 0 0           PP85   0
12416 14146 Donald Henry Griffiths         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001279                     2016-05-05 0 0           PP52   0
12417 14147 Ian Jones         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001279                     2016-05-05 0 0           PP53   0
12418 14810 John Anthony Edwards         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001268                     2016-05-05 0 0           PP53   0
12419 14811 Sandra Vickers         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001268                     2016-05-05 0 0           PP52   0
12420 18386 Farut Shaeen         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001278                     2016-05-05 0 0           PP53   0
12421 18387 Derran Stokes         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001278                     2016-05-05 0 0           PP52   0
12422 18870 Ray Crawford         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001267                     2016-05-05 0 0           PP85   0
12423 18871 Ann Jarvis         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001267                     2016-05-05 0 0           PP53   0
12424 18872 Steve Simcox         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001267                     2016-05-05 0 0           PP52   0
12425 18873 David Dean Fisher         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001266                     2016-05-05 0 0           PP85   0
12426 18874 Suki Nandra         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001266                     2016-05-05 0 0           PP52   0
12427 18968 Kerry Carmichael         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001261                     2016-05-05 0 0           PP53   0
12428 18969 Shirley Lesley Ching         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001261                     2016-05-05 0 0           PP52   0
12429 18970 Elaine Mary Giles         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001262                     2016-05-05 0 0           PP53   0
12430 18972 Richard Toye         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001262                     2016-05-05 0 0           PP52   0
12431 18973 John Dell Macefield Mr   male 1979.0 local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001263     https://sandwell.greenparty.org.uk/local-elections       https://static-candidates.democracyclub.org.uk/media/images/images/18973.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=283226910 2016-05-05 0 0           PP63   0
12432 18974 Graham Thomas Nock         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001263                     2016-05-05 0 0           PP85   0
12433 18975 Liam Vincent Preece         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001263                     2016-05-05 0 0           PP53   0
12434 18976 Tony Ward         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001263                     2016-05-05 0 0           PP52   0
12435 18977 Ben Groom         local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001264                     2016-05-05 0 0           PP63   0
12436 18978 Robert Owen Johns         local.sandwell.2016-05-05 61 party:90 Liberal Democrats MTW:E05001264                     2016-05-05 0 0           PP90   0
12437 18979 Tilton Tobias Storer         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001264                     2016-05-05 0 0           PP52   0
12438 18980 Caroline Anne White         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001264                     2016-05-05 0 0           PP53   0
12439 18981 Geoff Lewis         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001265                     2016-05-05 0 0           PP53   0
12440 18982 Bal Singh         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001265                     2016-05-05 0 0           PP85   0
12441 18983 Robert White         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001265                     2016-05-05 0 0           PP52   0
12442 18984 Jacqueline Nock         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001269                     2016-05-05 0 0           PP85   0
12443 18985 Paul Sandars         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001269                     2016-05-05 0 0           PP53   0
12444 18986 John Vickers         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001269                     2016-05-05 0 0           PP52   0
12445 18987 Brian David Crockett         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001270                     2016-05-05 0 0           PP52   0
12446 18988 Sharon Pearl Davies         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001270                     2016-05-05 0 0           PP53   0
12447 18989 Joyce Underhill         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001271                     2016-05-05 0 0           PP53   0
12448 18990 Keith Victor Vaughan         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001271                     2016-05-05 0 0           PP52   0
12449 18991 Peter Shaw Banks         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001272                     2016-05-05 0 0           PP85   0
12450 18992 Sue Crumpton         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001272                     2016-05-05 0 0           PP53   0
12451 18993 Bryan Manley-Green     male   local.sandwell.2016-05-05 61 party:90 Liberal Democrats MTW:E05001272     http://www.libdems.org.uk/bryan_manley_green       https://static-candidates.democracyclub.org.uk/media/images/images/18993.png   fholland http://www.libdems.org.uk/bryan_manley_green# 2016-05-05 0 0           PP90   0
12452 18994 John Duncan McHard         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001272                     2016-05-05 0 0           PP52   0
12453 18995 Aldo Mussi     male   local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001272     https://sandwell.greenparty.org.uk/local-elections       https://static-candidates.democracyclub.org.uk/media/images/images/18995.png   john44 On party's site https://sandwell.greenparty.org.uk/local-elections 2016-05-05 0 0           PP63   0
12454 18996 Isa Luqman Darby         local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001273                     2016-05-05 0 0           PP63   0
12455 18997 Sue Downing         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001273                     2016-05-05 0 0           PP53   0
12456 18998 Richard Nicholas Williams         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001273                     2016-05-05 0 0           PP52   0
12457 18999 Scott Chapman         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001274                     2016-05-05 0 0           PP52   0
12458 19000 Bill Cherrington         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001274                     2016-05-05 0 0           PP53   0
12459 19001 Ric Keeling         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001274                     2016-05-05 0 0           PP85   0
12460 19002 Zac Colledge         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001275                     2016-05-05 0 0           PP52   0
12461 19003 Susan Eaves         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001275                     2016-05-05 0 0           PP53   0
12462 19004 Monika Kasnickas         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001275                     2016-05-05 0 0           PP85   0
12463 19005 Stephanie Buckman         local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001277                     2016-05-05 0 0           PP63   0
12464 19006 Colin Lloyd Clark         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001277                     2016-05-05 0 0           PP52   0
12465 19007 Linda Rosaleen Horton         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001277                     2016-05-05 0 0           PP53   0
12466 19008 Elizabeth Brown         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001276                     2016-05-05 0 0           PP52   0
12467 19009 Preet Gill     female 1972.0 local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001276     https://party.coop/person/preet-gill/ http://www.preetkaurgill.com/ https://en.wikipedia.org/wiki/Preet_Gill   https://static-candidates.democracyclub.org.uk/media/images/images/19009_tc6cO5z.png   kdcm87 http://preetkaurgill.com/about/ 2016-05-05 0 0           PP53   0
12468 19010 Ben Bebbington         local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001280                     2016-05-05 0 0           PP63   0
12469 19011 Maria Crompton         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001280                     2016-05-05 0 0           PP53   0
12470 19012 John Stockall         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001280                     2016-05-05 0 0           PP52   0
12471 19013 Peter Hughes         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001281                     2016-05-05 0 0           PP53   0
12472 19014 Matthew Longville         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001281                     2016-05-05 0 0           PP52   0
12473 19015 Pam Hughes         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001282                     2016-05-05 0 0           PP53   0
12474 19016 Michael David Middleton         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001282                     2016-05-05 0 0           PP52   0
12475 19017 Mohammed Shariff Nadine Umar-Azeemi         local.sandwell.2016-05-05 61 party:85 UK Independence Party (UKIP) MTW:E05001282                     2016-05-05 0 0           PP85   0
12476 19018 Laura Maeve Hickey         local.sandwell.2016-05-05 61 party:53 Labour Party MTW:E05001283                     2016-05-05 0 0           PP53   0
12477 19019 Anne Charlotte Hughes         local.sandwell.2016-05-05 61 party:52 Conservative and Unionist Party MTW:E05001283                     2016-05-05 0 0           PP52   0
12478 19020 Neil Ashley Price         local.sandwell.2016-05-05 61 party:63 Green Party MTW:E05001283                     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 8.264ms · Data license: CC-BY-SA · Data source: Democracy Club