home / democracyclub

candidates

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

57 rows where election = 82

✎ 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_personal_url, linkedin_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
14414 14414 10134 Saleem Kapadi     Male 1967.0 local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001620 Audley ward             https://static-candidates.democracyclub.org.uk/media/images/images/10134.png   profile-photo alexsdutton   2016-05-05 0 0           PP52   0
14415 14415 10135 Raja Basharat Hussin Khan         local.blackburn-with-darwen.2016-05-05 82 ynmp-party:2 Independent UTW:E05001620 Audley ward                       2016-05-05 0 0           ynmp-party:2   0
14416 14416 10136 Zamir Khan         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001620 Audley ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/10136.png   other alexsdutton From http://blackburn.cmis.uk.com/blackburn/Councillors/tabid/63/ctl/ViewCMIS_Person/mid/383/id/51/Default.aspx?dnn_ctr383_ViewCMIS_Person_grdRadCommitteesPastChangePage=3_5 - a council member listing 2016-05-05 0 0           PP53   0
14417 14417 10137 Sabir Esa     Male 1961.0 local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001621 Bastwell ward           https://www.linkedin.com/in/sabir-esa-74a44327 https://static-candidates.democracyclub.org.uk/media/images/images/10137.png   profile-photo alexsdutton On campaign page; cropped from http://blackburnconservatives.co.uk/wp-content/uploads/2016/02/Sabir-Esa.jpg 2016-05-05 0 0           PP52   0
14418 14418 10138 Shaukat Hussain     Male   local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001621 Bastwell ward   1.0 http://blackburnlabour.org/whereyoulive/bastwell/     https://www.linkedin.com/in/shaukat-hussain-60740695 https://static-candidates.democracyclub.org.uk/media/images/images/10138.png   profile-photo alexsdutton Twitter profile pic: https://twitter.com/cllrshaukat 2016-05-05 0 0           PP53   0
14419 14419 10139 Julie Margaret Daley         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001622 Beardwood with Lammack ward   1.0                   2016-05-05 0 0           PP52   0
14420 14420 10140 Paul Mason         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001622 Beardwood with Lammack ward                       2016-05-05 0 0           PP53   0
14421 14421 11251 Tassy Fazal         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001623 Corporation Park ward   1.0                   2016-05-05 0 0           PP53   0
14422 14422 11252 Riaz Valli         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001623 Corporation Park ward                       2016-05-05 0 0           PP52   0
14423 14423 11253 Stephanie Rose Brookfield         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001624 Earcroft ward   1.0                   2016-05-05 0 0           PP53   0
14424 14424 11254 John East         local.blackburn-with-darwen.2016-05-05 82 party:90 Liberal Democrats UTW:E05001624 Earcroft ward                       2016-05-05 0 0           PP90   0
14425 14425 11255 Lynn Perkins         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001624 Earcroft ward                       2016-05-05 0 0           PP52   0
14426 14426 11256 Jamie Groves         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001626 Ewood ward   1.0                   2016-05-05 0 0           PP53   0
14427 14427 11257 Eleanor Sutcliffe         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001626 Ewood ward                       2016-05-05 0 0           PP52   0
14428 14428 11258 John Slater         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001627 Fernhurst ward   1.0                   2016-05-05 0 0           PP52   0
14429 14429 11259 Donna Marie Talbot         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001627 Fernhurst ward                       2016-05-05 0 0           PP53   0
14430 14430 11260 Michael Aaron Brooks         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001628 Higher Croft                       2016-05-05 0 0           PP52   0
14431 14431 11261 Don McKinlay         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001628 Higher Croft   1.0                   2016-05-05 0 0           PP53   0
14432 14432 11262 Liz Lawson         local.blackburn-with-darwen.2016-05-05 82 party:85 UK Independence Party (UKIP) UTW:E05001629 Little Harwood ward                       2016-05-05 0 0           PP85   0
14433 14433 11263 Abdul Samad Patel         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001629 Little Harwood ward   1.0                   2016-05-05 0 0           PP53   0
14434 14434 11264 Ghulam Sabir         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001629 Little Harwood ward                       2016-05-05 0 0           PP52   0
14435 14435 11265 Adam Holden         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001630 Livesey with Pleasington ward                       2016-05-05 0 0           PP53   0
14436 14436 11266 Paul Marrow         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001630 Livesey with Pleasington ward   1.0                   2016-05-05 0 0   42368.0       PP52   0
14437 14437 11267 Madeline Allen-Holmes         local.blackburn-with-darwen.2016-05-05 82 party:85 UK Independence Party (UKIP) UTW:E05001631 Marsh House                       2016-05-05 0 0           PP85   0
14438 14438 11268 Frank Connor         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001631 Marsh House                       2016-05-05 0 0           PP53   0
14439 14439 11269 Simon Huggill         local.blackburn-with-darwen.2016-05-05 82 party:90 Liberal Democrats UTW:E05001631 Marsh House                       2016-05-05 0 0           PP90   0
14440 14440 11270 Neil Slater         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001631 Marsh House   1.0                   2016-05-05 0 0           PP52   0
14441 14441 11271 Keith Murray         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001632 Meadowhead ward   1.0                   2016-05-05 0 0           PP52   0
14442 14442 11272 Ashley Richard Whalley         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001632 Meadowhead ward                       2016-05-05 0 0           PP53   0
14443 14443 11277 Michael Longbottom         local.blackburn-with-darwen.2016-05-05 82 party:85 UK Independence Party (UKIP) UTW:E05001633 Mill Hill ward                       2016-05-05 0 0           PP85   0
14444 14444 11278 Carl Peter Nuttall         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001633 Mill Hill ward   1.0                   2016-05-05 0 0           PP53   0
14445 14445 11279 Ann Marie Tolley     female   local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001633 Mill Hill ward                       2016-05-05 0 0           PP52   0
14446 14446 11280 Phil McDermott         local.blackburn-with-darwen.2016-05-05 82 ynmp-party:2 Independent UTW:E05001634 North Turton with Tockholes ward                       2016-05-05 0 0           ynmp-party:2   0
14447 14447 11281 Colin Rigby         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001634 North Turton with Tockholes ward   1.0                   2016-05-05 0 0           PP52   0
14448 14448 11282 Diane Cathrine Waddington         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001634 North Turton with Tockholes ward                       2016-05-05 0 0           PP53   0
14449 14449 11283 Faryad Hussain         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001635 Queen's Park ward   1.0                   2016-05-05 0 0           PP53   0
14450 14450 11284 Imraan Valimulla         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001635 Queen's Park ward                       2016-05-05 0 0           PP52   0
14451 14451 11285 Sylvia Liddle         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001636 Roe Lee ward   1.0                   2016-05-05 0 0           PP53   0
14452 14452 11286 Maureen McGarvey         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001636 Roe Lee ward                       2016-05-05 0 0           PP52   0
14453 14453 11287 Michael Andrew Madigan         local.blackburn-with-darwen.2016-05-05 82 party:85 UK Independence Party (UKIP) UTW:E05001637 Shadsworth with Whitebirk ward                       2016-05-05 0 0           PP85   0
14454 14454 11288 Vicky McGurk Mrs   Female 1981-03-24 local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001637 Shadsworth with Whitebirk ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11288.png   public-domain vickyandgeorge It’s my photo 2016-05-05 0 0           PP53 Digestive 0
14455 14455 11289 Margaret Rawlinson         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001637 Shadsworth with Whitebirk ward                       2016-05-05 0 0           PP52   0
14456 14456 11292 Irfan Mohmed Balapatel         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001638 Shear Brow ward                       2016-05-05 0 0           PP52   0
14457 14457 11293 Suleman Khonat         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001638 Shear Brow ward   1.0                   2016-05-05 0 0           PP53   0
14458 14458 11295 Jean Brindle         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001639 Sudell ward                       2016-05-05 0 0           PP52   0
14459 14459 11296 Roy Davies         local.blackburn-with-darwen.2016-05-05 82 party:90 Liberal Democrats UTW:E05001639 Sudell ward   1.0                   2016-05-05 0 0   42920.0       PP90   0
14460 14460 11297 Kate Stirton         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001639 Sudell ward                       2016-05-05 0 0           PP53   0
14461 14461 11298 Travis Frain         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001640 Sunnyhurst ward                       2016-05-05 0 0           PP52   0
14462 14462 11299 Ian Grimshaw     male   local.blackburn-with-darwen.2016-05-05 82 party:85 UK Independence Party (UKIP) UTW:E05001640 Sunnyhurst ward                       2016-05-05 0 0           PP85   0
14463 14463 11300 Peter Andrew Hollings         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001640 Sunnyhurst ward   1.0                   2016-05-05 0 0           PP53   0
14464 14464 11301 Ros Myers         local.blackburn-with-darwen.2016-05-05 82 party:90 Liberal Democrats UTW:E05001640 Sunnyhurst ward                       2016-05-05 0 0           PP90   0
14465 14465 11302 Dave Harling         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001641 Wensley Fold ward   1.0                   2016-05-05 0 0           PP53   0
14466 14466 11303 Tariq Mahmood         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001641 Wensley Fold ward                       2016-05-05 0 0           PP52   0
14467 14467 11304 Joanne Sarah Birkner         local.blackburn-with-darwen.2016-05-05 82 party:53 Labour Party UTW:E05001642 Whitehall ward                       2016-05-05 0 0           PP53   0
14468 14468 11305 Steve Duncan         local.blackburn-with-darwen.2016-05-05 82 party:52 Conservative and Unionist Party UTW:E05001642 Whitehall ward                       2016-05-05 0 0           PP52   0
14469 14469 11306 Karimeh Foster         local.blackburn-with-darwen.2016-05-05 82 party:90 Liberal Democrats UTW:E05001642 Whitehall ward   1.0                   2016-05-05 0 0           PP90   0
14470 14470 11307 Austin Molloy         local.blackburn-with-darwen.2016-05-05 82 party:85 UK Independence Party (UKIP) UTW:E05001642 Whitehall ward                       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 7.373ms · Data license: CC-BY-SA · Data source: Democracy Club