home / democracyclub

candidates

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

71 rows where election = 61

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