home / democracyclub

candidates

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

86 rows where election = 3

✎ 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, facebook_personal_url, homepage_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
8117 8117 759 Paul Rogan     male 1955-09-03 local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001374 Greetland and Stainland     http://www.ukipcalderdale.uk/ http://ukipcv.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/5515af42caf202e56580fb27.png   profile-photo CVKipper   2016-05-05 0 0   12927.0       PP85   0
8118 8118 991 Michael Taylor     male 1950-04-07 local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001378 Northowram and Shelf           https://www.linkedin.com/in/michael-taylor-b0586824           2016-05-05 0 0   12944.0       PP90   0
8119 8119 3398 Chris Jackson     male   local.calderdale.2016-05-05 3 party:2707 National Front MTW:E05001385 Todmorden                       2016-05-05 0 0           PP2707   0
8120 8120 4289 Joshua Fenton-Glynn     male   local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001372 Calder     https://vote.labour.org.uk/joshua-fenton-glynn http://www.joshfentonglynn.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/4289.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
8121 8121 4894 Alisdair Calder McGregor     male 1978.0 local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001375 Hipperholme and Lightcliffe     http://www.libdems.org.uk/alisdair_mcgregor http://alisdaircaldermcgregor.4mp.org.uk/   https://www.linkedin.com/in/alisdaircaldermcgregor https://static-candidates.democracyclub.org.uk/media/images/54a3d78ccca5fe1a31e4a7b4.png         2016-05-05 0 0           PP90   0
8122 8122 4980 Jenny Shepherd     female   local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001372 Calder     http://yorkshireandhumber.greenparty.org.uk/candidates/jenny-shepherd.html http://jenny4mp.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/54a1a0b4cca5fe1a31e4a7a6.png         2016-05-05 0 0   12911.0       PP63   0
8123 8123 5786 Rod Sutcliffe Mr   male 1951-06-09 local.calderdale.2016-05-05 3 party:2120 Yorkshire First MTW:E05001377 Luddendenfoot     http://www.yorkshirefirst.org.uk/       https://static-candidates.democracyclub.org.uk/media/images/552edc3942862f047e51ccb2.png   public-domain rod.sutcliffe I am the candidate and it is a photo of me 2016-05-05 0 0           PP2120   0
8124 8124 6570 Ruth Coleman-Taylor     Female   local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001386 Town             https://static-candidates.democracyclub.org.uk/media/images/553b9b6cb9c95afe74c5d31e.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/Coleman2Ruth 2016-05-05 0 0           PP90   0
8125 8125 7553 Adam David Wilkinson Mr   male   local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001384 Sowerby Bridge   1.0   http://adamwilkinsonlabour.com/   https://www.linkedin.com/in/adam-wilkinson-85170533           2016-05-05 0 0           PP53   0
8126 8126 8589 Nick Yates     male   local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001371 Brighouse                       2016-05-05 0 0           PP85   0
8127 8127 8592 Christopher Michael Baksa     male   local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001377 Luddendenfoot             https://static-candidates.democracyclub.org.uk/media/images/images/8592.png   profile-photo yanbad13257   2016-05-05 0 0           PP85   0
8128 8128 8593 Geoffrey Thompson     male   local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001383 Skircoat                       2016-05-05 0 0           PP85   0
8129 8129 8595 Philip Anthony Walters     male   local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001385 Todmorden                       2016-05-05 0 0           PP85   0
8130 8130 8596 Phillip Spencer Charlton     male   local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001386 Town                       2016-05-05 0 0           PP85   0
8131 8131 12909 Janet Mary Battye     female 1949.0 local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001372 Calder             https://static-candidates.democracyclub.org.uk/media/images/images/12909.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=631818144 2016-05-05 0 0           PP90   0
8132 8132 12910 James Ananda Krishnapillai         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001372 Calder                       2016-05-05 0 0           PP52   0
8133 8133 12912 Pat Allen         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001373 Elland   1.0                   2016-05-05 0 0           PP90   0
8134 8134 12913 Mick Clarke         local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001373 Elland                       2016-05-05 0 0           PP85   0
8135 8135 12914 Mohammad Naeem         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001373 Elland                       2016-05-05 0 0           PP53   0
8136 8136 12915 George Andrew Robinson         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001373 Elland                       2016-05-05 0 0           PP52   0
8137 8137 12916 Katharine Maeve Sweeny         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001373 Elland                       2016-05-05 0 0           PP63   0
8138 8138 12917 Ann Martin         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001371 Brighouse                       2016-05-05 0 0           PP53   0
8139 8139 12918 John Richard Ward Nesbitt         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001371 Brighouse                       2016-05-05 0 0           PP63   0
8140 8140 12919 Colin Bryan Peel         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001371 Brighouse   1.0                   2016-05-05 0 0           PP52   0
8141 8141 12920 Jennie Dawn Rigg     female 1977.0 local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001371 Brighouse           https://www.linkedin.com/in/jennierigg/           2016-05-05 0 0           PP90 Gingernut 0
8142 8142 12921 Samuel George Webb         local.calderdale.2016-05-05 3 party:804 Trade Unionist and Socialist Coalition MTW:E05001371 Brighouse                       2016-05-05 0 0           PP804   0
8143 8143 12922 Paul Alexander Bellenger         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001374 Greetland and Stainland   1.0                   2016-05-05 0 0           PP90   0
8144 8144 12923 Christopher Richard Blakey         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP52   0
8145 8145 12924 Christopher Wade Clinton         local.calderdale.2016-05-05 3 party:2120 Yorkshire First MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP2120   0
8146 8146 12925 James Stephen Hepplestone         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP53   0
8147 8147 12926 Mark Richard Mullany         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001374 Greetland and Stainland                       2016-05-05 0 0           PP63   0
8148 8148 12928 Kashif Ali         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001375 Hipperholme and Lightcliffe                       2016-05-05 0 0           PP53   0
8149 8149 12929 Graham Thomas Hall         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001375 Hipperholme and Lightcliffe   1.0                   2016-05-05 0 0           PP52   0
8150 8150 12930 Susan Jane Wardell         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001375 Hipperholme and Lightcliffe                       2016-05-05 0 0           PP63   0
8151 8151 12931 Tessa Gordziejko         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP63   0
8152 8152 12932 Lisa Ruth Lambert         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001376 Illingworth and Mixenden   1.0                   2016-05-05 0 0           PP53   0
8153 8153 12933 Steven Leigh         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP52   0
8154 8154 12934 Seán Loftus         local.calderdale.2016-05-05 3 ynmp-party:2 Independent MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           ynmp-party:2   0
8155 8155 12935 Glen Michael Mattock         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP90   0
8156 8156 12936 Angela Stella Thompson         local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001376 Illingworth and Mixenden                       2016-05-05 0 0           PP85   0
8157 8157 12937 Karl Antony Boggis         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001377 Luddendenfoot                       2016-05-05 0 0           PP90   0
8158 8158 12938 Owen Idris Gilroy         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001377 Luddendenfoot                       2016-05-05 0 0           PP52   0
8159 8159 12939 Pete Darren Lucky Leigh Pitfield         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001377 Luddendenfoot                       2016-05-05 0 0           PP63   0
8160 8160 12940 Jane Scullion         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001377 Luddendenfoot   1.0                   2016-05-05 0 0           PP53   0
8161 8161 12941 Peter Caffrey         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001378 Northowram and Shelf   1.0                   2016-05-05 0 0           PP52   0
8162 8162 12942 Elaine Hey         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001378 Northowram and Shelf                       2016-05-05 0 0           PP63   0
8163 8163 12943 Daniel Richard Manning     male   local.calderdale.2016-05-05 3 party:2120 Yorkshire First MTW:E05001378 Northowram and Shelf                       2016-05-05 0 0           PP2120   0
8164 8164 12945 Gary Walsh         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001378 Northowram and Shelf                       2016-05-05 0 0           PP53   0
8165 8165 12946 Mat Bowles         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001379 Ovenden                       2016-05-05 0 0           PP90   0
8166 8166 12947 Anne Collins         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001379 Ovenden   1.0                   2016-05-05 0 0           PP53   0
8167 8167 12948 Katherine Louise Horner         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001379 Ovenden                       2016-05-05 0 0           PP63   0
8168 8168 12949 John Charles Shoesmith         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001379 Ovenden                       2016-05-05 0 0           PP52   0
8169 8169 12950 Jeff Featherstone         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001380 Park                       2016-05-05 0 0           PP52   0
8170 8170 12951 Charles Gate         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001380 Park                       2016-05-05 0 0           PP63   0
8171 8171 12952 Jenny Lynn         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001380 Park   1.0                   2016-05-05 0 0           PP53   0
8172 8172 12954 Chaudhary Mohammed Saghir         local.calderdale.2016-05-05 3 ynmp-party:2 Independent MTW:E05001380 Park                       2016-05-05 0 0           ynmp-party:2   0
8173 8173 12955 Kathy Haigh-Hutchinson         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001381 Rastrick                       2016-05-05 0 0           PP90   0
8174 8174 12956 Peter Judge         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001381 Rastrick                       2016-05-05 0 0           PP53   0
8175 8175 12957 Elizabeth Jane King         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001381 Rastrick                       2016-05-05 0 0           PP63   0
8176 8176 12958 Lynne Louise Mitchell         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001381 Rastrick   1.0                   2016-05-05 0 0           PP52   0
8177 8177 12959 Geraldine Mary Carter         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001382 Ryburn   1.0                   2016-05-05 0 0           PP52   0
8178 8178 12960 Steve Cliberon         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001382 Ryburn                       2016-05-05 0 0           PP53   0
8179 8179 12961 Freda Mary Davis         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001382 Ryburn                       2016-05-05 0 0           PP63   0
8180 8180 12962 Peter John Hunt         local.calderdale.2016-05-05 3 ynmp-party:2 Independent MTW:E05001382 Ryburn                       2016-05-05 0 0           ynmp-party:2   0
8181 8181 12963 Rosemary Mabel Tatchell         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001382 Ryburn                       2016-05-05 0 0           PP90   0
8182 8182 12964 Dave Draycott         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001383 Skircoat                       2016-05-05 0 0           PP53   0
8183 8183 12965 Eric Fabrizi     male   local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001383 Skircoat     https://calderdale.greenparty.org.uk/people/eric-fabrizi.html       https://static-candidates.democracyclub.org.uk/media/images/images/12965.png   profile-photo sjorford https://calderdale.greenparty.org.uk/people/eric-fabrizi.html 2016-05-05 0 0           PP63   0
8184 8184 12966 Stephen Alexander Gow         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001383 Skircoat                       2016-05-05 0 0           PP90   0
8185 8185 12967 John Cecil David Hardy         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001383 Skircoat   1.0                   2016-05-05 0 0           PP52   0
8186 8186 12968 Darren Stansfield         local.calderdale.2016-05-05 3 party:2120 Yorkshire First MTW:E05001383 Skircoat                       2016-05-05 0 0           PP2120   0
8187 8187 12969 Karen Elizabeth Levin         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP63   0
8188 8188 12970 Rob Oddy         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP52   0
8189 8189 12971 Tom Stringfellow         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP90   0
8190 8190 12972 Roy Charles Thompson         local.calderdale.2016-05-05 3 party:85 UK Independence Party (UKIP) MTW:E05001384 Sowerby Bridge                       2016-05-05 0 0           PP85   0
8191 8191 12973 Gilbert John Hector Gregory         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001385 Todmorden                       2016-05-05 0 0           PP52   0
8192 8192 12974 Alan Patrick McDonald         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001385 Todmorden                       2016-05-05 0 0           PP63   0
8193 8193 12975 Joe Rez         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001385 Todmorden                       2016-05-05 0 0           PP90   0
8194 8194 12976 Steve Sweeney         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001385 Todmorden   1.0                   2016-05-05 0 0           PP53   0
8195 8195 12977 Mark Llewellyn Edwards         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001386 Town                       2016-05-05 0 0   36872.0       PP52   0
8196 8196 12978 Sarah Louise Moakler         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001386 Town                       2016-05-05 0 0           PP63   0
8197 8197 12979 Megan Kathleen Swift     Female   local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001386 Town   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12979.png   copyright-assigned TimSwift   2016-05-05 0 0           PP53   0
8198 8198 12980 Surraya Bibi         local.calderdale.2016-05-05 3 party:53 Labour Party MTW:E05001387 Warley                       2016-05-05 0 0           PP53   0
8199 8199 12981 Hena Chowdhury         local.calderdale.2016-05-05 3 party:63 Green Party MTW:E05001387 Warley                       2016-05-05 0 0           PP63   0
8200 8200 12982 Ashley John Richard Evans         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001387 Warley   1.0                   2016-05-05 0 0           PP90   0
8201 8201 12983 Tony Fall         local.calderdale.2016-05-05 3 party:52 Conservative and Unionist Party MTW:E05001387 Warley                       2016-05-05 0 0           PP52   0
8202 8202 36844 John Reynolds         local.calderdale.2016-05-05 3 party:90 Liberal Democrats MTW:E05001380 Park                       2016-05-05 0 0   12953.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.129ms · Data license: CC-BY-SA · Data source: Democracy Club