home / democracyclub

candidates

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

61 rows where election = 62

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, homepage_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 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
12479 12479 739 Roy Leonard Sandison     male   local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008981 New Bilton                       2016-05-05 0 0   18545.0       PP63   0
12480 12480 5529 Pete McLaren     male   local.rugby.2016-05-05 62 party:804 Trade Unionist and Socialist Coalition DIW:E05010760 Wolston and the Lawfords       http://www.rugbytusc.com/     https://static-candidates.democracyclub.org.uk/media/images/5547b16ff0745ae61e5c2791.png   profile-photo andylolz From party PPC page: http://tusc2015.com/pete-mclaren-for-rugby/ 2016-05-05 0 0           PP804   0
12481 12481 5530 Terence White     male 1992-09-17 local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008979 Hillmorton             https://static-candidates.democracyclub.org.uk/media/images/551a0a4bb989d5e837ae99e2.png   profile-photo terry I own this photo 2016-05-05 0 0   18527.0       PP90   0
12482 12482 14111 Peter James Butlin         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP52   0
12483 12483 14112 Lee Martin Chase         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP90   0
12484 12484 14113 Steve Edkins         local.rugby.2016-05-05 62 party:804 Trade Unionist and Socialist Coalition DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP804   0
12485 12485 14114 Hamish Livingstone         local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP53   0
12486 12486 14115 Graham Bliss     male   local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008974 Benn     https://my.greenparty.org.uk/candidates/106159       https://static-candidates.democracyclub.org.uk/media/images/images/14115.png   profile-photo J https://my.greenparty.org.uk/candidates/106159 2016-05-05 0 0           PP63   0
12487 12487 14116 Charlie Hull         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008974 Benn                       2016-05-05 0 0           PP52   0
12488 12488 14117 Maggie O'Rourke     female   local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008974 Benn     http://www.rugbylabour.co.uk/maggie_o_rourke                 2016-05-05 0 0           PP53   0
12489 12489 14118 Alex Speirs         local.rugby.2016-05-05 62 party:85 UK Independence Party (UKIP) DIW:E05008974 Benn                       2016-05-05 0 0           PP85   0
12490 12490 14119 Hugh Trimble         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008974 Benn                       2016-05-05 0 0   33257.0       PP90   0
12491 12491 14135 Julie Beverly A'Barrow         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008975 Bilton                       2016-05-05 0 0           PP52   0
12492 12492 14136 Elizabeth Bull         local.rugby.2016-05-05 62 party:85 UK Independence Party (UKIP) DIW:E05008975 Bilton                       2016-05-05 0 0           PP85   0
12493 12493 14137 Lesley Mary George         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008975 Bilton                       2016-05-05 0 0           PP90   0
12494 12494 14138 Pawel Lukas Ignatowicz         local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008975 Bilton                       2016-05-05 0 0           PP53   0
12495 12495 14139 Steven Michael Wright         local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008975 Bilton                       2016-05-05 0 0           PP63   0
12496 12496 14158 Leigh Simone Hunt         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008976 Clifton, Newton and Churchover ward                       2016-05-05 0 0           PP52   0
12497 12497 14159 Catherine Lisa Rose         local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008976 Clifton, Newton and Churchover ward                       2016-05-05 0 0           PP53   0
12498 12498 14160 Keith Ward         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008976 Clifton, Newton and Churchover ward                       2016-05-05 0 0           PP90   0
12499 12499 14180 Gwendoline Hotten         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008977 Coton and Boughton                       2016-05-05 0 0           PP90   0
12500 12500 14181 David Mclean         local.rugby.2016-05-05 62 party:85 UK Independence Party (UKIP) DIW:E05008977 Coton and Boughton                       2016-05-05 0 0           PP85   0
12501 12501 14182 Carolyn Ann Robbins         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008977 Coton and Boughton                       2016-05-05 0 0           PP52   0
12502 12502 14183 Alan Charles Webb     male   local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008977 Coton and Boughton     http://www.rugbylabour.co.uk/alan_webb                 2016-05-05 0 0           PP53   0
12503 12503 18476 Bob Hughes     male   local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05010759 Dunsmore     http://www.rugbylabour.co.uk/bob_hughes       https://static-candidates.democracyclub.org.uk/media/images/images/18476.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
12504 12504 18477 Ian James Picker         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05010759 Dunsmore                       2016-05-05 0 0           PP52   0
12505 12505 18478 Howard David Roberts         local.rugby.2016-05-05 62 ynmp-party:2 Independent DIW:E05010759 Dunsmore                       2016-05-05 0 0           ynmp-party:2   0
12506 12506 18496 Robert Johnson         local.rugby.2016-05-05 62 party:804 Trade Unionist and Socialist Coalition DIW:E05008986 Eastlands                       2016-05-05 0 0           PP804   0
12507 12507 18497 Frank McGowan         local.rugby.2016-05-05 62 party:85 UK Independence Party (UKIP) DIW:E05008986 Eastlands                       2016-05-05 0 0           PP85   0
12508 12508 18498 Tony Meeson         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008986 Eastlands                       2016-05-05 0 0           PP52   0
12509 12509 18499 Peter Stephen Reynolds         local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008986 Eastlands                       2016-05-05 0 0           PP63   0
12510 12510 18500 Sue Roodhouse         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008986 Eastlands                       2016-05-05 0 0           PP90   0
12511 12511 18501 Steve Weston         local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008986 Eastlands                       2016-05-05 0 0           PP53   0
12512 12512 18524 David Dick Cranham         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008979 Hillmorton                       2016-05-05 0 0           PP52   0
12513 12513 18525 Jim Ellis     male   local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008979 Hillmorton     http://www.rugbylabour.co.uk/jim_ellis https://d3n8a8pro7vhmx.cloudfront.net/labourclp140/pages/298/attachments/original/1523396688/hillmorton_final_.pdf?1523396688     https://static-candidates.democracyclub.org.uk/media/images/images/18525.png   profile-photo sjorford http://www.rugbylabour.co.uk/jim_ellis 2016-05-05 0 0           PP53   0
12514 12514 18526 Paul Machin         local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008979 Hillmorton                       2016-05-05 0 0           PP63   0
12515 12515 18528 Patricia Wyatt         local.rugby.2016-05-05 62 party:85 UK Independence Party (UKIP) DIW:E05008979 Hillmorton                       2016-05-05 0 0           PP85   0
12516 12516 18542 Ally MacGregor         local.rugby.2016-05-05 62 party:804 Trade Unionist and Socialist Coalition DIW:E05008981 New Bilton                       2016-05-05 0 0           PP804   0
12517 12517 18543 Kevin Paul McLoughlin         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008981 New Bilton                       2016-05-05 0 0           PP52   0
12518 12518 18544 Ish Mistry     male   local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008981 New Bilton     http://www.rugbylabour.co.uk/ish_mistry                 2016-05-05 0 0           PP53   0
12519 12519 18546 Hossain Tafazzal         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008981 New Bilton                       2016-05-05 0 0           PP90   0
12520 12520 18547 Kieren Richard George Brown     male   local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008982 Newbold and Brownsover             https://static-candidates.democracyclub.org.uk/media/images/images/18547.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
12521 12521 18548 Lorna Dunleavy         local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008982 Newbold and Brownsover                       2016-05-05 0 0           PP63   0
12522 12522 18549 Sara Elizabeth Last         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008982 Newbold and Brownsover                       2016-05-05 0 0           PP52   0
12523 12523 18550 Jerome Vincent Perrier         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008982 Newbold and Brownsover                       2016-05-05 0 0           PP90   0
12524 12524 18551 Kenneth Armstrong         local.rugby.2016-05-05 62 party:85 UK Independence Party (UKIP) DIW:E05008983 Paddox                       2016-05-05 0 0           PP85   0
12525 12525 18552 Tim Douglas         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008983 Paddox                       2016-05-05 0 0           PP90   0
12526 12526 18553 Greg Lyttle         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008983 Paddox                       2016-05-05 0 0           PP52   0
12527 12527 18554 Julie-Ann Machin         local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008983 Paddox                       2016-05-05 0 0           PP63   0
12528 12528 18555 Janine O'Brien         local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008983 Paddox                       2016-05-05 0 0           PP53   0
12529 12529 18562 Rob Bevin         local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008984 Revel and Binley Woods                       2016-05-05 0 0           PP53   0
12530 12530 18563 John Edward Birch         local.rugby.2016-05-05 62 party:85 UK Independence Party (UKIP) DIW:E05008984 Revel and Binley Woods                       2016-05-05 0 0           PP85   0
12531 12531 18564 Tony Gillias         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008984 Revel and Binley Woods                       2016-05-05 0 0           PP52   0
12532 12532 18565 Howard Avis     male   local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05008985 Rokeby and Overslade           https://www.linkedin.com/in/howard-avis-73b0b126/           2016-05-05 0 0           PP53   0
12533 12533 18566 Kate Crowley         local.rugby.2016-05-05 62 party:63 Green Party DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP63   0
12534 12534 18567 Carie-Anne Dumbleton         local.rugby.2016-05-05 62 party:90 Liberal Democrats DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP90   0
12535 12535 18568 Ravi Bipin Mistry         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP52   0
12536 12536 18569 Julie Dawn Weekes         local.rugby.2016-05-05 62 party:804 Trade Unionist and Socialist Coalition DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP804   0
12537 12537 18579 Sally Drayton Bragg         local.rugby.2016-05-05 62 party:52 Conservative and Unionist Party DIW:E05010760 Wolston and the Lawfords                       2016-05-05 0 0           PP52   0
12538 12538 18580 Doreen Cox         local.rugby.2016-05-05 62 party:53 Labour Party DIW:E05010760 Wolston and the Lawfords                       2016-05-05 0 0           PP53   0
12539 12539 18581 Elanor Roderick         local.rugby.2016-05-05 62 party:63 Green Party DIW:E05010760 Wolston and the Lawfords                       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.66ms · Data license: CC-BY-SA · Data source: Democracy Club