home / democracyclub

candidates

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

33 rows where election = 17

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, image_url, image_uploading_user, image_uploading_user_notes, 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
8953 8953 5956 Janet Brown     Female   local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005206 Altham             https://static-candidates.democracyclub.org.uk/media/images/552694a459bbc5c063445be1.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-f-k.html 2016-05-05 0 0           PP85   0
8954 8954 7091 Liam Clark     Male 1990-07-24 local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005217 Peel             https://static-candidates.democracyclub.org.uk/media/images/5525f49e413cb4432adffa76.png   profile-photo Roger_Cornwell Taken from Facebook profile page 2016-05-05 0 0   7075;17409       PP85   0
8955 8955 14082 Munsif Dad         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005221 Spring Hill   1.0                   2016-05-05 0 0           PP53   0
8956 8956 14083 Abdul Qayyum         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005221 Spring Hill                       2016-05-05 0 0           PP52   0
8957 8957 17389 John Frank Bargh         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005206 Altham                       2016-05-05 0 0           PP52   0
8958 8958 17390 Patrick Bolam         local.hyndburn.2016-05-05 17 party:63 Green Party DIW:E05005206 Altham                       2016-05-05 0 0           PP63   0
8959 8959 17391 Stephen Button         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005206 Altham   1.0                   2016-05-05 0 0           PP53   0
8960 8960 17392 Tony Dobson         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005207 Barnfield   1.0                   2016-05-05 0 0           PP52   0
8961 8961 17393 John Errol Taylor         local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005207 Barnfield                       2016-05-05 0 0           PP85   0
8962 8962 17394 Jodie Travis         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005207 Barnfield                       2016-05-05 0 0           PP53   0
8963 8963 17395 David Hartley         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005208 Baxenden                       2016-05-05 0 0           PP53   0
8964 8964 17396 Terence Keith Hurn         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005208 Baxenden   1.0                   2016-05-05 0 0           PP52   0
8965 8965 17397 Stewart Ian Scott         local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005208 Baxenden                       2016-05-05 0 0           PP85   0
8966 8966 17398 Abdul Ghafar Khan         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005209 Central   1.0                   2016-05-05 0 0           PP53   0
8967 8967 17399 Kazi Siddique         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005209 Central                       2016-05-05 0 0           PP52   0
8968 8968 17400 Jean Battle         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005210 Church   1.0                   2016-05-05 0 0           PP53   0
8969 8969 17401 Marion Raynor         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005210 Church                       2016-05-05 0 0           PP52   0
8970 8970 17402 Noordad Aziz         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005215 Netherton   1.0                   2016-05-05 0 0           PP53   0
8971 8971 17403 Tom Linklater         local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005215 Netherton                       2016-05-05 0 0           PP85   0
8972 8972 17404 Liz McGinley         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005215 Netherton                       2016-05-05 0 0           PP52   0
8973 8973 17405 Stephanie Haworth         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005216 Overton   1.0                   2016-05-05 0 0           PP53   0
8974 8974 17406 Patrick John Luke McGinley         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005216 Overton                       2016-05-05 0 0           PP52   0
8975 8975 17407 Ian Robinson         local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005216 Overton                       2016-05-05 0 0           PP85   0
8976 8976 17408 Joan Elizabeth West     female   local.hyndburn.2016-05-05 17 party:63 Green Party DIW:E05005216 Overton             https://static-candidates.democracyclub.org.uk/media/images/images/17408.png   profile-photo gregorywilliams   2016-05-05 0 0           PP63   0
8977 8977 17410 Paddy Short         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005217 Peel   1.0                   2016-05-05 0 0           PP53   0
8978 8978 17411 David George Dowling         local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005218 Rishton                       2016-05-05 0 0           PP85   0
8979 8979 17412 Ann Scaife         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005218 Rishton                       2016-05-05 0 0           PP52   0
8980 8980 17413 Jeff Scales         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005218 Rishton   1.0                   2016-05-05 0 0           PP53   0
8981 8981 17414 Josh Blayne Allen         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005219 St Andrew's                       2016-05-05 0 0           PP52   0
8982 8982 17415 Stewart Thurston Eaves         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005219 St Andrew's   1.0                   2016-05-05 0 0           PP53   0
8983 8983 17416 Glen Kevin Harrison         local.hyndburn.2016-05-05 17 party:53 Labour Party DIW:E05005220 St Oswald's   1.0                   2016-05-05 0 0           PP53   0
8984 8984 17417 Marlene Heather Haworth         local.hyndburn.2016-05-05 17 party:52 Conservative and Unionist Party DIW:E05005220 St Oswald's                       2016-05-05 0 0           PP52   0
8985 8985 17418 Bret Christopher Matthew         local.hyndburn.2016-05-05 17 party:85 UK Independence Party (UKIP) DIW:E05005220 St Oswald's                       2016-05-05 0 0           PP85   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 6.01ms · Data license: CC-BY-SA · Data source: Democracy Club