home / democracyclub

candidates

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

67 rows where election = 84

✎ 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, 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
14477 14477 5444 Gary Legg     male 1965-04-21 local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001125 Monkseaton South     http://www.ukipnorthtyneside.org/garylegg       https://static-candidates.democracyclub.org.uk/media/images/5516db02929f1bbe286be041.png   profile-photo garyupnorth I am the candidate and it belongs to me. 2016-05-05 0 0   10409.0       PP85   0
14478 14478 8183 Norman John Morse Mr   Male 1954-12-23 local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001118 Chirton     http://ukipnorthtyneside.org       https://static-candidates.democracyclub.org.uk/media/images/images/8183.png   profile-photo scottieh84   2016-05-05 0 0   10312.0       PP85   0
14479 14479 10302 Jessica Erren Jaye Bushbye         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001115 Battle Hill                       2016-05-05 0 0           PP52   0
14480 14480 10303 John David Hoare         local.north-tyneside.2016-05-05 84 party:804 Trade Unionist and Socialist Coalition MTW:E05001115 Battle Hill                       2016-05-05 0 0           PP804   0
14481 14481 10304 Carl John Johnson         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001115 Battle Hill   1.0                   2016-05-05 0 0           PP53   0
14482 14482 10305 David Michael Arthur         local.north-tyneside.2016-05-05 84 ynmp-party:2 Independent MTW:E05001116 Benton                       2016-05-05 0 0           ynmp-party:2   0
14483 14483 10306 Maureen Gallon         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001116 Benton                       2016-05-05 0 0           PP85   0
14484 14484 10307 Pat Oliver         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001116 Benton   1.0                   2016-05-05 0 0           PP53   0
14485 14485 10308 George Mann Partis         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001116 Benton                       2016-05-05 0 0           PP52   0
14486 14486 10309 Jim Allan         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001117 Camperdown   1.0                   2016-05-05 0 0           PP53   0
14487 14487 10310 Paul Bunyan         local.north-tyneside.2016-05-05 84 ynmp-party:2 Independent MTW:E05001117 Camperdown                       2016-05-05 0 0           ynmp-party:2   0
14488 14488 10311 David Alan Sarin         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001117 Camperdown                       2016-05-05 0 0           PP52   0
14489 14489 10313 John James Stirling         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001118 Chirton   1.0                   2016-05-05 0 0           PP53   0
14490 14490 10314 Yasmin Catherine Lisa West         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001118 Chirton                       2016-05-05 0 0           PP52   0
14491 14491 10315 Lewis James Austin         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001119 Collingwood             https://static-candidates.democracyclub.org.uk/media/images/images/10315.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
14492 14492 10316 Debbie Cox         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001119 Collingwood   1.0                   2016-05-05 0 0           PP53   0
14493 14493 10317 Sylvia Marie Simpson         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001119 Collingwood                       2016-05-05 0 0           PP85   0
14494 14494 10318 David Andrew Taws         local.north-tyneside.2016-05-05 84 party:804 Trade Unionist and Socialist Coalition MTW:E05001119 Collingwood                       2016-05-05 0 0           PP804   0
14495 14495 10319 Karen Veronica Lee-Duffy         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001120 Cullercoats   1.0 http://www.tynemouthlabour.uk/cullercoats       https://static-candidates.democracyclub.org.uk/media/images/images/10319.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
14496 14496 10320 Phyl Masters         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001120 Cullercoats                       2016-05-05 0 0           PP85   0
14497 14497 10321 George Crighton Westwater         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001120 Cullercoats             https://static-candidates.democracyclub.org.uk/media/images/images/10321.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
14498 14498 10393 David Jonathan Griffith-Owen         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001121 Howdon                       2016-05-05 0 0           PP52   0
14499 14499 10394 John Hunter         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001121 Howdon   1.0                   2016-05-05 0 0           PP53   0
14500 14500 10395 Robert Dixon Mather         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001121 Howdon                       2016-05-05 0 0           PP85   0
14501 14501 10396 Timothy Peter Wall         local.north-tyneside.2016-05-05 84 party:804 Trade Unionist and Socialist Coalition MTW:E05001121 Howdon                       2016-05-05 0 0           PP804   0
14502 14502 10397 Gary Bell         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001122 Killingworth   1.0                   2016-05-05 0 0           PP53   0
14503 14503 10398 Karen Jane Gabrielle Johnston         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001122 Killingworth                       2016-05-05 0 0           PP52   0
14504 14504 10399 Brian Needham         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001122 Killingworth                       2016-05-05 0 0           PP85   0
14505 14505 10400 Eddie Darke         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001123 Longbenton   1.0                   2016-05-05 0 0           PP53   0
14506 14506 10401 Robin Arthur Underwood         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001123 Longbenton                       2016-05-05 0 0           PP52   0
14507 14507 10402 Alison Austin         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001124 Monkseaton North   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/10402.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
14508 14508 10403 Stephen Borlos         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001124 Monkseaton North                       2016-05-05 0 0           PP85   0
14509 14509 10404 David Nisbet         local.north-tyneside.2016-05-05 84 party:90 Liberal Democrats MTW:E05001124 Monkseaton North                       2016-05-05 0 0           PP90   0
14510 14510 10405 Willie Samuel         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001124 Monkseaton North     http://www.tynemouthlabour.uk/monkseaton_north       https://static-candidates.democracyclub.org.uk/media/images/images/10405.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
14511 14511 10406 Sean Michael Brockbank         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001125 Monkseaton South             https://static-candidates.democracyclub.org.uk/media/images/images/10406.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
14512 14512 10407 Naomi Louise Craven         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001125 Monkseaton South   1.0                   2016-05-05 0 0           PP53   0
14513 14513 10408 Julia Anne Erskine     female   local.north-tyneside.2016-05-05 84 party:63 Green Party MTW:E05001125 Monkseaton South       https://my.greenparty.org.uk/candidates/106260     https://static-candidates.democracyclub.org.uk/media/images/images/35097.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106260 2016-05-05 0 0   35097.0       PP63   0
14514 14514 10412 Joe Kirwin         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001126 Northumberland                       2016-05-05 0 0           PP53   0
14515 14515 10413 Miriam Mary Smith         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001126 Northumberland                       2016-05-05 0 0           PP52   0
14516 14516 11133 Glynis Barrie         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001127 Preston                       2016-05-05 0 0           PP52   0
14517 14517 11134 Catherine Davis         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001127 Preston   1.0 http://www.tynemouthlabour.uk/preston                 2016-05-05 0 0           PP53   0
14518 14518 11135 Sheena Mary Patterson         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001127 Preston                       2016-05-05 0 0           PP85   0
14519 14519 11136 Maureen Jeffrey         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001128 Riverside                       2016-05-05 0 0           PP52   0
14520 14520 11137 Frank Lott         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001128 Riverside   1.0                   2016-05-05 0 0           PP53   0
14521 14521 11138 Neil Mather         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001128 Riverside                       2016-05-05 0 0           PP85   0
14522 14522 11151 Hugh Jackson         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001129 St Mary's                       2016-05-05 0 0           PP85   0
14523 14523 11152 Theresa Maltman         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001129 St Mary's                       2016-05-05 0 0           PP53   0
14524 14524 11153 Judith Anne Wallace         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001129 St Mary's   1.0                   2016-05-05 0 0           PP52   0
14525 14525 11169 David Wallace Lilly         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001130 Tynemouth                       2016-05-05 0 0           PP52   0
14526 14526 11170 Henry Marshall         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001130 Tynemouth                       2016-05-05 0 0           PP85   0
14527 14527 11171 Jean Francis McLaughlin         local.north-tyneside.2016-05-05 84 ynmp-party:2 Independent MTW:E05001130 Tynemouth                       2016-05-05 0 0           ynmp-party:2   0
14528 14528 11172 Frances Helena Weetman         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001130 Tynemouth   1.0                   2016-05-05 0 0           PP53   0
14529 14529 11181 Elizabeth Mary Borlos         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001131 Valley                       2016-05-05 0 0           PP85   0
14530 14530 11182 Joseph Alan Furness         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001131 Valley                       2016-05-05 0 0           PP52   0
14531 14531 11183 Tommy Mulvenna         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001131 Valley   1.0                   2016-05-05 0 0           PP53   0
14532 14532 11184 Margaret Anne Finlay         local.north-tyneside.2016-05-05 84 party:90 Liberal Democrats MTW:E05001132 Wallsend                       2016-05-05 0 0           PP90   0
14533 14533 11185 Claire Julia Griffith-Owen         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001132 Wallsend                       2016-05-05 0 0           PP52   0
14534 14534 11186 Gary Anthony Madden         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001132 Wallsend   1.0                   2016-05-05 0 0           PP53   0
14535 14535 11187 Jane McEachan         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001132 Wallsend                       2016-05-05 0 0           PP85   0
14536 14536 11188 Irene Winifred Davidson         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001133 Weetslade                       2016-05-05 0 0           PP85   0
14537 14537 11189 Andrew Charles Elliott         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001133 Weetslade                       2016-05-05 0 0           PP52   0
14538 14538 11190 Anthony William McMullen         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001133 Weetslade   1.0                   2016-05-05 0 0           PP53   0
14539 14539 11191 Frank Stephen Austin         local.north-tyneside.2016-05-05 84 party:52 Conservative and Unionist Party MTW:E05001134 Whitley Bay                       2016-05-05 0 0           PP52   0
14540 14540 11192 David Cory         local.north-tyneside.2016-05-05 84 party:85 UK Independence Party (UKIP) MTW:E05001134 Whitley Bay                       2016-05-05 0 0           PP85   0
14541 14541 11193 Colin Finlay         local.north-tyneside.2016-05-05 84 party:90 Liberal Democrats MTW:E05001134 Whitley Bay                       2016-05-05 0 0           PP90   0
14542 14542 11194 Sandra Maria Graham         local.north-tyneside.2016-05-05 84 party:53 Labour Party MTW:E05001134 Whitley Bay   1.0                   2016-05-05 0 0           PP53   0
14543 14543 11203 Nigel John Huscroft         local.north-tyneside.2016-05-05 84 party:90 Liberal Democrats MTW:E05001126 Northumberland   1.0                   2016-05-05 0 0           PP90   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.764ms · Data license: CC-BY-SA · Data source: Democracy Club