home / democracyclub

candidates

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

84 rows where election = 78

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, twitter_username, homepage_url, image_url, image_copyright, image_uploading_user, 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
13622 13622 6071 Mark Hollinrake     male 1963-12-24 local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000746 Kingsway       https://www.greenparty.org.uk     https://static-candidates.democracyclub.org.uk/media/images/5506fbe35399523471f7e19e.png   profile-photo markhollinrake   2016-05-05 0 0           PP63   0
13623 13623 11154 Ed Aadahl         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP85   0
13624 13624 11155 John Hartley         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP53   0
13625 13625 11156 Robert James McLean         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP52   0
13626 13626 11157 AJ Rennie         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP63   0
13627 13627 11158 John Leo Swarbrick         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP90   0
13628 13628 12458 Will Candlin         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP85   0
13629 13629 12459 Edward Carpenter         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP52   0
13630 13630 12460 Richard George Farnell         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP53   0
13631 13631 12461 James Martin O'Meara         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP63   0
13632 13632 12462 Liz Thirsk         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP90   0
13633 13633 12477 Mohammad Arshad         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000740 Bamford                       2016-05-05 0 0           PP53   0
13634 13634 12478 Peter Clegg         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000740 Bamford                       2016-05-05 0 0           PP90   0
13635 13635 12479 Sarah Louise Croke         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000740 Bamford                       2016-05-05 0 0           PP63   0
13636 13636 12480 Michael John Foster         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000740 Bamford                       2016-05-05 0 0           PP85   0
13637 13637 12481 Jane Elizabeth Ann Howard     female   local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000740 Bamford             https://static-candidates.democracyclub.org.uk/media/images/images/12481.png   profile-photo yanbad13257   2016-05-05 0 0           PP52   0
13638 13638 12482 Jonathan Edward Kershaw         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000741 Castleton                       2016-05-05 0 0           PP63   0
13639 13639 12483 Stephen Sanderson         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000741 Castleton                       2016-05-05 0 0           PP85   0
13640 13640 12484 Billy Sheerin         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000741 Castleton                       2016-05-05 0 0           PP53   0
13641 13641 12485 Karen Winkler         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000741 Castleton                       2016-05-05 0 0           PP52   0
13642 13642 12502 Iftikhar Ahmed         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP53   0
13643 13643 12503 David Vincent Fenwick-Finn         local.rochdale.2016-05-05 78 party:804 Trade Unionist and Socialist Coalition MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP804   0
13644 13644 12504 Roger Howarth         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP52   0
13645 13645 12505 Andy Littlewood     male   local.rochdale.2016-05-05 78 ynmp-party:2 Independent MTW:E05000742 Central Rochdale             https://static-candidates.democracyclub.org.uk/media/images/images/12505_QN5XFQY.png   copyright-assigned andy16   2016-05-05 0 0           ynmp-party:2   0
13646 13646 12506 Rifat Mahmood         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP90   0
13647 13647 12507 Neil Gavin Rutter         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP63   0
13648 13648 12508 Malcolm Boriss         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000743 East Middleton                       2016-05-05 0 0           PP53   0
13649 13649 12509 Rebecca Daisy Ann Howard         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000743 East Middleton                       2016-05-05 0 0           PP52   0
13650 13650 12510 Robert Mudd         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000743 East Middleton                       2016-05-05 0 0           PP85   0
13651 13651 12524 Thomas Benedict Butterworth         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000744 Healey                       2016-05-05 0 0           PP63   0
13652 13652 12525 Maureen Kershaw         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000744 Healey                       2016-05-05 0 0           PP85   0
13653 13653 12526 Andrew Neilson         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000744 Healey                       2016-05-05 0 0           PP52   0
13654 13654 12527 Shaun O'Neill         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000744 Healey                       2016-05-05 0 0           PP53   0
13655 13655 12528 John Robert Rodgers         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000744 Healey                       2016-05-05 0 0           PP90   0
13656 13656 12633 Paul Simon Ellison         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000745 Hopwood Hall                       2016-05-05 0 0   45534.0       PP52   0
13657 13657 12634 Angela Christine Gardner         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000745 Hopwood Hall                       2016-05-05 0 0           PP85   0
13658 13658 12635 Linda Robinson         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000745 Hopwood Hall                       2016-05-05 0 0           PP53   0
13659 13659 12636 Shakil Ahmed         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000746 Kingsway                       2016-05-05 0 0           PP53   0
13660 13660 12637 David John Clayton         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000746 Kingsway                       2016-05-05 0 0           PP90   0
13661 13661 12638 Richard James Duckworth         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000746 Kingsway                       2016-05-05 0 0           PP52   0
13662 13662 12639 Allen John Brett         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP53   0
13663 13663 12640 Angela Coric         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP90   0
13664 13664 12641 Jacqueline Elaine Holt         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP52   0
13665 13665 12642 Abdus Sami Mir         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP63   0
13666 13666 12643 Alan James Ashworth         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP63   0
13667 13667 12644 Irene Elizabeth Davidson         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP90   0
13668 13668 12645 Duncan Hannant         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP53   0
13669 13669 12646 Michael O'Brien         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0   46833.0       PP85   0
13670 13670 12647 Ahmed Orakzai         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP52   0
13671 13671 12660 Susan June Campbell         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000750 Norden                       2016-05-05 0 0           PP63   0
13672 13672 12661 James Travis Gartside         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000750 Norden                       2016-05-05 0 0           PP52   0
13673 13673 12662 Dobir Miah         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000750 Norden                       2016-05-05 0 0           PP53   0
13674 13674 12663 Stephen Mitchell         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000750 Norden                       2016-05-05 0 0           PP85   0
13675 13675 12664 Keith Swift         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000750 Norden                       2016-05-05 0 0           PP90   0
13676 13676 12665 Derrick Drysdale         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000751 North Heywood                       2016-05-05 0 0           PP90   0
13677 13677 12666 Liam Joseph O'Rourke         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000751 North Heywood                       2016-05-05 0 0           PP53   0
13678 13678 12667 Anne Shorrock         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000751 North Heywood                       2016-05-05 0 0           PP52   0
13679 13679 12668 John Kershaw         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000752 North Middleton                       2016-05-05 0 0           PP52   0
13680 13680 12669 Donna Maria Williams         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000752 North Middleton                       2016-05-05 0 0           PP53   0
13681 13681 12670 Dave Winder         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000752 North Middleton                       2016-05-05 0 0           PP85   0
13682 13682 12671 Leonard Keith Branton         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP52   0
13683 13683 12672 Kitt Budd         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP90   0
13684 13684 12673 Amna Mir         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP53   0
13685 13685 12674 Neville Westerman         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP85   0
13686 13686 12680 Bernard Thomas Braiden         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000754 South Middleton                       2016-05-05 0 0           PP52   0
13687 13687 12681 Peter Cloran         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000754 South Middleton                       2016-05-05 0 0           PP63   0
13688 13688 12682 Peter Joinson         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000754 South Middleton                       2016-05-05 0 0           PP53   0
13689 13689 12683 Richard John Whitaker         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000754 South Middleton                       2016-05-05 0 0           PP85   0
13690 13690 12684 John Britton Wilkins         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000754 South Middleton                       2016-05-05 0 0           PP90   0
13691 13691 12688 Matthew Allen         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP90   0
13692 13692 12689 Mick Coats         local.rochdale.2016-05-05 78 party:63 Green Party MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP63   0
13693 13693 12690 Wendy Ann Cocks         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP53   0
13694 13694 12691 Carl Faulkner Mr   Male   local.rochdale.2016-05-05 78 ynmp-party:2 Independent MTW:E05000755 Spotland and Falinge       http://spotlandindependen.wixsite.com/sind               2016-05-05 0 0           ynmp-party:2   0
13695 13695 12692 Steven Scholes         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP52   0
13696 13696 12698 Stefan Cholewka         local.rochdale.2016-05-05 78 joint-party:53-119 Labour and Co-operative Party MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           joint-party:53-119   0
13697 13697 12699 Cathie Cox         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           PP85   0
13698 13698 12700 Ashley Howard Dearnley         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           PP52   0
13699 13699 12701 Joe Kelly         local.rochdale.2016-05-05 78 party:90 Liberal Democrats MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           PP90   0
13700 13700 12702 Peter Malcolm         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000757 West Heywood                       2016-05-05 0 0           PP53   0
13701 13701 12704 Keith Taylor         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000757 West Heywood                       2016-05-05 0 0           PP52   0
13702 13702 12705 Rachel Christine McLachlan         local.rochdale.2016-05-05 78 party:52 Conservative and Unionist Party MTW:E05000758 West Middleton                       2016-05-05 0 0   46829.0       PP52   0
13703 13703 12706 Warren Mitchell         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000758 West Middleton                       2016-05-05 0 0           PP85   0
13704 13704 12707 Susan Smith         local.rochdale.2016-05-05 78 party:53 Labour Party MTW:E05000758 West Middleton                       2016-05-05 0 0           PP53   0
13705 13705 34688 Lee Seville         local.rochdale.2016-05-05 78 party:85 UK Independence Party (UKIP) MTW:E05000757 West Heywood                       2016-05-05 0 0   12703.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 8.716ms · Data license: CC-BY-SA · Data source: Democracy Club