home / democracyclub

candidates

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

86 rows where election = 3

View and edit SQL

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