home / democracyclub

candidates

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

97 rows where election = 75

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, homepage_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
13353 13353 1964 Peter Harper     male   local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000946 Molyneux                       2016-05-05 0 0           PP85   0
13354 13354 2627 Pat Gaskell     female   local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000947 Netherton and Orrell                       2016-05-05 0 0           PP85   0
13355 13355 3751 Terry Durrance Mr   male 1944.0 local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000941 Kew       http://ukipnw.org.uk/branches/merseyside/ukip-southport/               2016-05-05 0 0   16157.0       PP85   0
13356 13356 3978 John Gibson     male   local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000944 Manor                       2016-05-05 0 0           PP90   0
13357 13357 7085 Laurence Rankin     Male   local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000947 Netherton and Orrell     https://my.greenparty.org.uk/candidates/106212       https://static-candidates.democracyclub.org.uk/media/images/551ab471e2ac8b7333e6a280.png   profile-photo rgwillis   2016-05-05 0 0   16214.0       PP63   0
13358 13358 16087 Duncan Browne         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000932 Ainsdale                       2016-05-05 0 0           PP85   0
13359 13359 16088 Mhairi McLeod Johnstone Doyle     female   local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000932 Ainsdale                       2016-05-05 0 0   41394.0       PP53   0
13360 13360 16089 Barbara Ann Dutton         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000932 Ainsdale                       2016-05-05 0 0           PP63   0
13361 13361 16090 Jamie Halsall         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000932 Ainsdale                       2016-05-05 0 0           PP52   0
13362 13362 16091 Lynne Thompson         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000932 Ainsdale   1.0                   2016-05-05 0 0           PP90   0
13363 13363 16095 Bernhard Frank         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000933 Birkdale                       2016-05-05 0 0           PP63   0
13364 13364 16096 Linda Julia Ann Gunn-Russo         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000933 Birkdale                       2016-05-05 0 0           PP85   0
13365 13365 16097 Richard Ronald Hands         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000933 Birkdale   1.0                   2016-05-05 0 0           PP90   0
13366 13366 16098 John Charles Lyon-Taylor         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000933 Birkdale                       2016-05-05 0 0           PP52   0
13367 13367 16099 Ged Wright         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000933 Birkdale                       2016-05-05 0 0           PP53   0
13368 13368 16103 Aaron Hugh Ellis         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000934 Blundellsands                       2016-05-05 0 0           PP52   0
13369 13369 16104 Diane Elizabeth Roscoe     female   local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000934 Blundellsands   1.0                   2016-05-05 0 0           PP53   0
13370 13370 16105 Michael James Walsh         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000934 Blundellsands                       2016-05-05 0 0           PP63   0
13371 13371 16113 David William Collins         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000935 Cambridge                       2016-05-05 0 0           PP63   0
13372 13372 16114 Stephen James Jowett         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000935 Cambridge                       2016-05-05 0 0           PP53   0
13373 13373 16115 Pat Keith         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000935 Cambridge   1.0                   2016-05-05 0 0           PP90   0
13374 13374 16116 Jordan Thomas Shandley         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000935 Cambridge                       2016-05-05 0 0           PP52   0
13375 13375 16117 Michael Skarratts         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000935 Cambridge                       2016-05-05 0 0           PP85   0
13376 13376 16126 Helen Louise Barber         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000936 Church                       2016-05-05 0 0           PP52   0
13377 13377 16127 Mike Carter     male   local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000936 Church     https://my.greenparty.org.uk/candidates/106170 https://sefton.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/16127.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106170 2016-05-05 0 0           PP63   0
13378 13378 16128 Paul Paschal Cummins         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000936 Church   1.0                   2016-05-05 0 0           PP53   0
13379 13379 16129 Alwynne Ann Cartmell         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000937 Derby                       2016-05-05 0 0           PP63   0
13380 13380 16130 Susan Brenda Hughes         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000937 Derby                       2016-05-05 0 0           PP85   0
13381 13381 16131 Angela Rankin         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000937 Derby                       2016-05-05 0 0           PP52   0
13382 13382 16132 Anne Margaret Thompson         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000937 Derby   1.0                   2016-05-05 0 0           PP53   0
13383 13383 16137 Jacky Bliss         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000938 Duke's                       2016-05-05 0 0           PP52   0
13384 13384 16138 Tony Dawson         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000938 Duke's   1.0                   2016-05-05 0 0           PP90   0
13385 13385 16139 Bernie Draper         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000938 Duke's                       2016-05-05 0 0           PP63   0
13386 13386 16140 Frank Hanley         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000938 Duke's                       2016-05-05 0 0           PP53   0
13387 13387 16141 Matthew James Hubbard         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000938 Duke's                       2016-05-05 0 0           PP85   0
13388 13388 16144 Lynne Margaret Bold         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000939 Ford                       2016-05-05 0 0           PP52   0
13389 13389 16145 Alan De Ledger St Claire         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000939 Ford                       2016-05-05 0 0           PP63   0
13390 13390 16146 Paulette Lappin         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000939 Ford   1.0                   2016-05-05 0 0           PP53   0
13391 13391 16147 Philip James Wordley         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000939 Ford                       2016-05-05 0 0           PP85   0
13392 13392 16150 Alf Doran         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000940 Harington                       2016-05-05 0 0           PP53   0
13393 13393 16151 Stephen Thomas McCluskie         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000940 Harington                       2016-05-05 0 0           PP90   0
13394 13394 16152 Michael Ronald Pitt     male   local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000940 Harington   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/16152.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=913207880 2016-05-05 0 0           PP52   0
13395 13395 16153 Richard Graham Willis         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000940 Harington                       2016-05-05 0 0           PP63   0
13396 13396 16156 Tina Bliss         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000941 Kew                       2016-05-05 0 0           PP52   0
13397 13397 16158 Richard James Furness         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000941 Kew                       2016-05-05 0 0           PP63   0
13398 13398 16159 Janet Catherine Harrison         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000941 Kew                       2016-05-05 0 0           PP53   0
13399 13399 16160 David Gwyn Pullin         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000941 Kew   1.0                   2016-05-05 0 0           PP90   0
13400 13400 16164 Iain Beckett         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000942 Linacre                       2016-05-05 0 0           PP52   0
13401 13401 16165 Jake Michael Bowness         local.sefton.2016-05-05 75 ynmp-party:2 Independent MTW:E05000942 Linacre                       2016-05-05 0 0           ynmp-party:2   0
13402 13402 16166 Barbara Ann Bryan Ms   Female 1952.0 local.sefton.2016-05-05 75 party:73 Socialist Labour Party MTW:E05000942 Linacre                       2016-05-05 0 0           PP73   0
13403 13403 16167 Brenda O'Brien         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000942 Linacre   1.0                   2016-05-05 0 0           PP53   0
13404 13404 16168 Marion Wykes         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000942 Linacre                       2016-05-05 0 0   41163.0       PP63   0
13405 13405 16172 Trish Hardy         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000943 Litherland   1.0                   2016-05-05 0 0           PP53   0
13406 13406 16173 Jessamine Miles Hounslea         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000943 Litherland                       2016-05-05 0 0           PP52   0
13407 13407 16174 Ethan Wykes         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000943 Litherland                       2016-05-05 0 0           PP63   0
13408 13408 16185 Paul Martyn Barber         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000953 Victoria                       2016-05-05 0 0           PP52   0
13409 13409 16186 Alison Gibbon     female   local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000944 Manor     https://my.greenparty.org.uk/candidates/105835       https://static-candidates.democracyclub.org.uk/media/images/images/16186.png   profile-photo sjorford https://www.facebook.com/125157814711098/photos/a.125159658044247.1073741827.125157814711098/125159661377580/ 2016-05-05 0 0           PP63   0
13410 13410 16187 Craig Anthony John Hughes         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000944 Manor                       2016-05-05 0 0           PP85   0
13411 13411 16188 John Kelly     male   local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000944 Manor   1.0                   2016-05-05 0 0           PP53   0
13412 13412 16192 Debbie Bannon         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000945 Meols                       2016-05-05 0 0           PP53   0
13413 13413 16193 Katy Bonney         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000945 Meols                       2016-05-05 0 0           PP85   0
13414 13414 16194 John Dodd         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000945 Meols   1.0   http://localfocusnews.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/16194.png   public-domain John_Dodd   2016-05-05 0 0           PP90   0
13415 13415 16195 Sarah-Jayne McIntosh         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000945 Meols                       2016-05-05 0 0           PP63   0
13416 13416 16196 Luke Anthony Thompson         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000945 Meols                       2016-05-05 0 0           PP52   0
13417 13417 16205 Marcus Julian Romaine Bleasdale         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000946 Molyneux                       2016-05-05 0 0           PP52   0
13418 13418 16206 Paula Mary Murphy         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000946 Molyneux   1.0                   2016-05-05 0 0           PP53   0
13419 13419 16207 Pierre Laurence Vicary         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000946 Molyneux                       2016-05-05 0 0           PP63   0
13420 13420 16212 Robert John Brennan         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000947 Netherton and Orrell   1.0                   2016-05-05 0 0           PP53   0
13421 13421 16213 John Malcolm Rankin         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000947 Netherton and Orrell                       2016-05-05 0 0           PP52   0
13422 13422 16248 Roy Greason         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000949 Park                       2016-05-05 0 0           PP63   0
13423 13423 16249 Pat From Lydiate         local.sefton.2016-05-05 75 ynmp-party:2 Independent MTW:E05000949 Park   1.0                   2016-05-05 0 0           ynmp-party:2   0
13424 13424 16250 Andy Wilson         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000949 Park                       2016-05-05 0 0           PP53   0
13425 13425 16251 Lesley Delves         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000948 Norwood                       2016-05-05 0 0           PP53   0
13426 13426 16252 Peter Noel Gregson         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000948 Norwood                       2016-05-05 0 0           PP85   0
13427 13427 16253 Poppy Elise Jones         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000948 Norwood                       2016-05-05 0 0           PP52   0
13428 13428 16254 David McIntosh         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000948 Norwood                       2016-05-05 0 0           PP63   0
13429 13429 16255 Bill Welsh         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000948 Norwood   1.0                   2016-05-05 0 0           PP90   0
13430 13430 16264 Jean Boardman         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000950 Ravenmeols                       2016-05-05 0 0           PP85   0
13431 13431 16265 Tim Hale         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000950 Ravenmeols                       2016-05-05 0 0           PP53   0
13432 13432 16266 Bob McCann         local.sefton.2016-05-05 75 party:2232 Community Action Party MTW:E05000950 Ravenmeols   1.0                   2016-05-05 0 0           PP2232   0
13433 13433 16267 Wendy Moore         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000950 Ravenmeols                       2016-05-05 0 0           PP52   0
13434 13434 16268 Kim Bryan Dr   female 1960.0 local.sefton.2016-05-05 75 party:73 Socialist Labour Party MTW:E05000951 St Oswald       http://www.socialist-labour-party.org.uk/index.html https://en.wikipedia.org/wiki/Socialist_Labour_Party_(UK)   https://static-candidates.democracyclub.org.uk/media/images/images/16268.png   profile-photo Kim Bryan   2016-05-05 0 0           PP73   0
13435 13435 16269 Linda Cluskey         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000951 St Oswald   1.0                   2016-05-05 0 0           PP53   0
13436 13436 16270 Peter Robert Papworth         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000951 St Oswald                       2016-05-05 0 0           PP52   0
13437 13437 16271 Shaun Smyth         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000951 St Oswald                       2016-05-05 0 0           PP63   0
13438 13438 16272 Carla Maria Thomas         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000951 St Oswald   1.0                   2016-05-05 0 0           PP53   0
13439 13439 16273 Janice Blanchard         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000952 Sudell                       2016-05-05 0 0           PP52   0
13440 13440 16274 Carla Jane Fox     female   local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000952 Sudell                       2016-05-05 0 0           PP63   0
13441 13441 16275 Matt Gannon         local.sefton.2016-05-05 75 ynmp-party:2 Independent MTW:E05000952 Sudell   1.0                   2016-05-05 0 0           ynmp-party:2   0
13442 13442 16276 Bruce Lock Hubbard         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000952 Sudell                       2016-05-05 0 0           PP90   0
13443 13443 16277 Sarah Patricia Hughes         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000952 Sudell                       2016-05-05 0 0           PP85   0
13444 13444 16278 Nina Killen     female   local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000952 Sudell             https://static-candidates.democracyclub.org.uk/media/images/images/16278.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=19936226 2016-05-05 0 0           PP53   0
13445 13445 16279 Andrew Roy Donegan         local.sefton.2016-05-05 75 party:63 Green Party MTW:E05000953 Victoria                       2016-05-05 0 0           PP63   0
13446 13446 16280 Joseph Graeme Hedgecock         local.sefton.2016-05-05 75 party:85 UK Independence Party (UKIP) MTW:E05000953 Victoria                       2016-05-05 0 0           PP85   0
13447 13447 16281 Michael Roche         local.sefton.2016-05-05 75 party:53 Labour Party MTW:E05000953 Victoria   1.0                   2016-05-05 0 0           PP53   0
13448 13448 16282 Carol Tonkiss         local.sefton.2016-05-05 75 party:90 Liberal Democrats MTW:E05000953 Victoria                       2016-05-05 0 0           PP90   0
13449 13449 19092 Martyn Paul Barber         local.sefton.2016-05-05 75 party:52 Conservative and Unionist Party MTW:E05000944 Manor                       2016-05-05 0 0           PP52   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.68ms · Data license: CC-BY-SA · Data source: Democracy Club