home / democracyclub

candidates

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

46 rows where election = 99

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, twitter_username, party_ppc_page_url, homepage_url, image_url, 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
15488 15488 1346 Kevin White     male 1972-12-16 local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007876 Lodge Park     https://my.greenparty.org.uk/candidates/106146 http://www.redditchgreens.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/54bd390bead6762e54811af6.png         2016-05-05 0 0           PP63   0
15489 15489 4011 Jonathan Oakton     male   local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007872 Church Hill                       2016-05-05 0 0           PP85   0
15490 15490 4255 John Fisher     male   local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007877 Matchborough     https://vote.labour.org.uk/gary-john-fisher       https://static-candidates.democracyclub.org.uk/media/images/5481e796b150e238702c0548.png   profile-photo     2016-05-05 0 0   18262.0       PP53   0
15491 15491 18189 Ann Gee         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0           PP90   0
15492 15492 18190 Len Harris         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0           PP85   0
15493 15493 18191 Pattie Hill     Female   local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007870 Batchley & Brockhill       http://worcestershire.moderngov.co.uk/mgUserInfo.aspx?UID=72     https://static-candidates.democracyclub.org.uk/media/images/images/18191.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
15494 15494 18192 Scott Royston Torrington         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0           PP52   0
15495 15495 18202 Salman Akbar         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007871 Central                       2016-05-05 0 0           PP52   0
15496 15496 18203 Trevor Stephen Blake         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007871 Central                       2016-05-05 0 0           PP85   0
15497 15497 18204 Tom Bowes         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007871 Central                       2016-05-05 0 0           PP63   0
15498 15498 18205 Greg Chance         local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007871 Central                       2016-05-05 0 0           PP53   0
15499 15499 18206 Diane Elizabeth Thomas         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007871 Central                       2016-05-05 0 0           PP90   0
15500 15500 18217 David Howard Gee         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007872 Church Hill                       2016-05-05 0 0   24235.0       PP90   0
15501 15501 18218 Bill Hartnett         local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007872 Church Hill                       2016-05-05 0 0           PP53   0
15502 15502 18219 Robert Daniel Wardell         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007872 Church Hill                       2016-05-05 0 0   24238.0       PP63   0
15503 15503 18220 Pamela Mary Williams         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007872 Church Hill                       2016-05-05 0 0           PP52   0
15504 15504 18221 Agnes Beatrix Winczek         local.redditch.2016-05-05 99 ynmp-party:2 Independent DIW:E05007872 Church Hill                       2016-05-05 0 0           ynmp-party:2   0
15505 15505 18231 Joe Baker         local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007874 Greenlands                       2016-05-05 0 0   24231.0       PP53   0
15506 15506 18232 Chris Harrison         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007874 Greenlands                       2016-05-05 0 0           PP85   0
15507 15507 18233 Tony Pitt         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007874 Greenlands                       2016-05-05 0 0           PP90   0
15508 15508 18234 Mal Ullah         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007874 Greenlands                       2016-05-05 0 0           PP52   0
15509 15509 18235 Rylma Elaine White         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007874 Greenlands                       2016-05-05 0 0   24239.0       PP63   0
15510 15510 18236 Roger Michael Bennett         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP52   0
15511 15511 18237 Margaret Hindle         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP90   0
15512 15512 18238 Nayab Patel     female   local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP53   0
15513 15513 18239 Scott Duncan Preston         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP85   0
15514 15514 18240 Alistair Derek Waugh         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP63   0
15515 15515 18257 Les Rogers         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP85   0
15516 15516 18258 Mark Henry Shurmer         local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP53   0
15517 15517 18259 Craig Warhurst         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP52   0
15518 15518 18260 Ian David Webster         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP90   0
15519 15519 18261 Louise Deveney         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007877 Matchborough                       2016-05-05 0 0           PP63   0
15520 15520 18263 Simon Brookes Oliver         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007877 Matchborough                       2016-05-05 0 0           PP90   0
15521 15521 18264 Jim Swansborough         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007877 Matchborough                       2016-05-05 0 0           PP85   0
15522 15522 18265 Alexandra Beverley Kay Williams         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007877 Matchborough                       2016-05-05 0 0           PP52   0
15523 15523 18266 Matt Dormer         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007878 West                       2016-05-05 0 0           PP52   0
15524 15524 18267 Mike Lewington         local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007878 West                       2016-05-05 0 0           PP53   0
15525 15525 18268 Russell Patrick Taylor         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007878 West                       2016-05-05 0 0           PP90   0
15526 15526 18269 Simon Edward Venables         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007878 West                       2016-05-05 0 0           PP63   0
15527 15527 18270 Julie Ann Walford         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007878 West                       2016-05-05 0 0           PP85   0
15528 15528 18271 Emma Louise Bradley         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007879 Winyates                       2016-05-05 0 0           PP63   0
15529 15529 18272 Kathy Haslam         local.redditch.2016-05-05 99 party:85 UK Independence Party (UKIP) DIW:E05007879 Winyates                       2016-05-05 0 0           PP85   0
15530 15530 18273 John Hyams         local.redditch.2016-05-05 99 party:52 Conservative and Unionist Party DIW:E05007879 Winyates                       2016-05-05 0 0           PP52   0
15531 15531 18274 Yvonne Smith         local.redditch.2016-05-05 99 party:53 Labour Party DIW:E05007879 Winyates                       2016-05-05 0 0           PP53   0
15532 15532 18275 Hans Windheuser         local.redditch.2016-05-05 99 party:90 Liberal Democrats DIW:E05007879 Winyates                       2016-05-05 0 0   24240.0       PP90   0
15533 15533 19423 Steve Pound         local.redditch.2016-05-05 99 party:63 Green Party DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0   32798.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.122ms · Data license: CC-BY-SA · Data source: Democracy Club