home / democracyclub

candidates

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

87 rows where election = 94

✎ 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, 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
15163 15163 277 Martin Fitzpatrick Mr   male 1968.0 local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001776 Derwent             https://static-candidates.democracyclub.org.uk/media/images/images/277.png   other JeniT photo from http://ukpollingreport.co.uk/guide/seat-profiles/sheffieldhallam/comment-page-22/ 2016-05-05 0 0   6617.0       PP85   0
15164 15164 1262 Hardyal Dhindsa     male   local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001780 Normanton         https://en.wikipedia.org/wiki/Hardyal_Dhindsa   https://static-candidates.democracyclub.org.uk/media/images/images/1262.png   other goldvote From the Derby City Council Website councillor profile 2016-05-05 0 0   11980;14997       PP53   0
15165 15165 2662 Cheryl Pidgeon     female   local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001777 Littleover     http://www.labour.org.uk/people/detail/cheryl-pidgeon       https://static-candidates.democracyclub.org.uk/media/images/5481e87cb150e238702c05d4.png   profile-photo     2016-05-05 0 0   11967.0       PP53   0
15166 15166 3123 Joe Naitta     male 1963-11-18 local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001771 Blagreaves     http://www.libdems.org.uk/joe_naitta     http://uk.linkedin.com/pub/joe-naitta/17/a28/ba/en https://static-candidates.democracyclub.org.uk/media/images/images/3123.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
15167 15167 4184 Evonne Williams     female   local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001783 Spondon     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Williams_Evonne.aspx     http://uk.linkedin.com/pub/evonne-williams/3b/635/124/en https://static-candidates.democracyclub.org.uk/media/images/5481e722b150e238702c04ec.png   profile-photo     2016-05-05 0 0           PP52   0
15168 15168 5344 Chris Fernandez mr   male   local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001775 Darley     http://tusc2015.com/chris-fernandez-for-derby-south/     http://uk.linkedin.com/pub/chris-fernandez/15/701/155/en https://static-candidates.democracyclub.org.uk/media/images/5547799ed0888cd84349ceba.png   profile-photo andylolz From party PPC page: http://tusc2015.com/chris-fernandez-for-derby-south/ 2016-05-05 0 0   7785.0       PP804   0
15169 15169 5559 David Batey     male 1980-07-25 local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001770 Arboretum     http://eastmidslibdems.org.uk/en/contact/david-batey                 2016-05-05 0 0   106;11936       PP90   0
15170 15170 7661 David Gale     male 1959-01-22 local.derby.2016-05-05 94 party:2165 British Independents UTW:E05001769 Alvaston       https://derbyshireindependent.co.uk/2016/05/02/david-gale-alvaston-ward/   https://uk.linkedin.com/in/davidgaleuk https://static-candidates.democracyclub.org.uk/media/images/images/7661.png   public-domain DavidGaleUK Loaded by agent: www.BritishIndependents.org 2016-05-05 0 0   7281;7666;11931       PP2165   0
15171 15171 7786 Terry Anderson Mr       local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001780 Normanton                       2016-05-05 0 0           PP804   0
15172 15172 7787 Lesley Butler         local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001770 Arboretum                       2016-05-05 0 0           PP804   0
15173 15173 7788 Shaun Christopher Stuart         local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001772 Boulton                       2016-05-05 0 0           PP804   0
15174 15174 7789 Jo Warren         local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001769 Alvaston                       2016-05-05 0 0           PP804   0
15175 15175 7790 Stevie Rosso         local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001778 Mackworth                       2016-05-05 0 0           PP804   0
15176 15176 7791 Zbigniew Wojcik         local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001782 Sinfin                       2016-05-05 0 0           PP804   0
15177 15177 7792 Jonathan Sykes         local.derby.2016-05-05 94 party:804 Trade Unionist and Socialist Coalition UTW:E05001767 Abbey                       2016-05-05 0 0           PP804   0
15178 15178 8108 Marten Kats Mr.   Male 1980-08-27 local.derby.2016-05-05 94 party:63 Green Party UTW:E05001775 Darley       https://martenkats.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/8108.png   public-domain MartenKats   2016-05-05 0 0   34423.0       PP63   0
15179 15179 8109 George Hind Miss   Female 1998-03-07 local.derby.2016-05-05 94 party:63 Green Party UTW:E05001767 Abbey                       2016-05-05 0 0           PP63   0
15180 15180 8110 Kayleigh Beth Skipper Ms.   Female 1985-12-15 local.derby.2016-05-05 94 party:63 Green Party UTW:E05001782 Sinfin                       2016-05-05 0 0           PP63   0
15181 15181 11923 Ajit Singh Atwal         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001767 Abbey                       2016-05-05 0 0           PP90   0
15182 15182 11924 Jordan Kemp         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001767 Abbey                       2016-05-05 0 0           PP52   0
15183 15183 11925 Sarah Elizabeth Russell         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001767 Abbey   1.0                   2016-05-05 0 0           PP53   0
15184 15184 11926 Frank Leeming         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001768 Allestree                       2016-05-05 0 0           PP85   0
15185 15185 11927 Richard Jason Smalley         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001768 Allestree   1.0                   2016-05-05 0 0           PP52   0
15186 15186 11928 Deena Smith         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001768 Allestree                       2016-05-05 0 0           PP90   0
15187 15187 11929 Oleg Sotnicenko         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001768 Allestree                       2016-05-05 0 0           PP53   0
15188 15188 11930 John Evans         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001769 Alvaston                       2016-05-05 0 0           PP85   0
15189 15189 11932 Christopher Philip King         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001769 Alvaston                       2016-05-05 0 0           PP52   0
15190 15190 11933 Robert John Mason         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001769 Alvaston                       2016-05-05 0 0           PP90   0
15191 15191 11934 Mark Stuart Tittley         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001769 Alvaston                       2016-05-05 0 0           PP53   0
15192 15192 11935 Jhanzab Arif         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001770 Arboretum                       2016-05-05 0 0           PP85   0
15193 15193 11937 Matlub Hussain         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001770 Arboretum                       2016-05-05 0 0           PP52   0
15194 15194 11938 Gulfraz Nawaz         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001770 Arboretum   1.0                   2016-05-05 0 0           PP53   0
15195 15195 11939 Ian Sleeman     male   local.derby.2016-05-05 94 party:63 Green Party UTW:E05001770 Arboretum     https://my.greenparty.org.uk/candidates/105917       https://static-candidates.democracyclub.org.uk/media/images/images/11939.png   profile-photo J https://my.greenparty.org.uk/candidates/105917 2016-05-05 0 0           PP63   0
15196 15196 11940 Vincent Davis Mr   Male   local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001771 Blagreaves                       2016-05-05 0 0   36080.0       PP85   0
15197 15197 11941 David Rodney Jennings         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001771 Blagreaves                       2016-05-05 0 0           PP52   0
15198 15198 11942 Cecile Yvonne Wright         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001771 Blagreaves                       2016-05-05 0 0           PP53   0
15199 15199 11943 Dom Anderson         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001772 Boulton                       2016-05-05 0 0           PP53   0
15200 15200 11944 Leon Adam Nixon         local.derby.2016-05-05 94 party:63 Green Party UTW:E05001772 Boulton                       2016-05-05 0 0           PP63   0
15201 15201 11945 Gaurav Pandey         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001772 Boulton                       2016-05-05 0 0           PP85   0
15202 15202 11946 Greg Webb         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001772 Boulton                       2016-05-05 0 0           PP90   0
15203 15203 11947 Steve Willoughby         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001772 Boulton                       2016-05-05 0 0           PP52   0
15204 15204 11948 Sue Cowlishaw         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001773 Chaddesden                       2016-05-05 0 0           PP53   0
15205 15205 11949 Anthony Joseph Crawley         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001773 Chaddesden                       2016-05-05 0 0           PP85   0
15206 15206 11950 Tim Hallam     male   local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001773 Chaddesden     http://www.libdems.org.uk/tim_hallam_ppc http://www.timhallam.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/11950.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   34101.0       PP90   0
15207 15207 11951 Paul Hilliard         local.derby.2016-05-05 94 ynmp-party:2 Independent UTW:E05001773 Chaddesden                       2016-05-05 0 0           ynmp-party:2   0
15208 15208 11952 Jonathan Charles Smale         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001773 Chaddesden                       2016-05-05 0 0           PP52   0
15209 15209 11953 Ian Edward Crompton         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001774 Chellaston                       2016-05-05 0 0           PP85   0
15210 15210 11954 Sean William Marshall         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001774 Chellaston   1.0                   2016-05-05 0 0           PP52   0
15211 15211 11955 Jane Elizabeth Katharine Webb         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001774 Chellaston                       2016-05-05 0 0           PP90   0
15212 15212 11956 James Matthew West         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001774 Chellaston                       2016-05-05 0 0           PP53   0
15213 15213 11958 Stephen Francis Connolly         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001775 Darley                       2016-05-05 0 0           PP90   0
15214 15214 11959 Ged Potter         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001775 Darley                       2016-05-05 0 0           PP52   0
15215 15215 11960 Jack Stanton         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001775 Darley   1.0                   2016-05-05 0 0           PP53   0
15216 15216 11961 Simon Ferrigno         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001776 Derwent                       2016-05-05 0 0           PP90   0
15217 15217 11962 Richard Hudson         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001776 Derwent                       2016-05-05 0 0           PP52   0
15218 15218 11963 Margaret Eileen Redfern         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001776 Derwent                       2016-05-05 0 0           PP53   0
15219 15219 11964 Eric Ashburner         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001777 Littleover                       2016-05-05 0 0           PP90   0
15220 15220 11965 Peter Stanley Berry         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001777 Littleover                       2016-05-05 0 0           PP52   0
15221 15221 11966 Arron Mathew Marsden         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001777 Littleover                       2016-05-05 0 0           PP85   0
15222 15222 11968 Tony Welch Mr   male   local.derby.2016-05-05 94 party:4038 Link Party UTW:E05001777 Littleover                       2016-05-05 0 0           PP4038   0
15223 15223 11969 Kyle Mark Bolderson         local.derby.2016-05-05 94 party:63 Green Party UTW:E05001778 Mackworth                       2016-05-05 0 0           PP63   0
15224 15224 11970 Ian Colin Deuchar Care         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001778 Mackworth                       2016-05-05 0 0           PP90   0
15225 15225 11971 Rob Cooper         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001778 Mackworth                       2016-05-05 0 0           PP85   0
15226 15226 11972 Adrian Michael Pegg         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001778 Mackworth                       2016-05-05 0 0           PP52   0
15227 15227 11973 Paul James Pegg         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001778 Mackworth                       2016-05-05 0 0           PP53   0
15228 15228 11974 Maggie Hird         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001779 Mickleover                       2016-05-05 0 0           PP90   0
15229 15229 11975 Matthew Edward Holmes         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001779 Mickleover                       2016-05-05 0 0           PP52   0
15230 15230 11976 Kirk Lewis Kus         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001779 Mickleover                       2016-05-05 0 0           PP85   0
15231 15231 11977 Craig Lee Thomson         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001779 Mickleover                       2016-05-05 0 0           PP53   0
15232 15232 11978 Shaikh Mushtaq Ahmed         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001780 Normanton                       2016-05-05 0 0           PP85   0
15233 15233 11979 Preetinder Kaur Butter         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001780 Normanton                       2016-05-05 0 0           PP90   0
15234 15234 11981 Fred Gough Mr   Male 1989-02-25 local.derby.2016-05-05 94 party:63 Green Party UTW:E05001780 Normanton             https://static-candidates.democracyclub.org.uk/media/images/images/11981.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
15235 15235 11982 Habib Iqbal         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001780 Normanton                       2016-05-05 0 0           PP52   0
15236 15236 11983 Joanna Rachel Beck         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001781 Oakwood                       2016-05-05 0 0           PP85   0
15237 15237 11984 Alex Dann     female   local.derby.2016-05-05 94 ynmp-party:2 Independent UTW:E05001781 Oakwood       https://independentalexblog.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/images/11984.png   profile-photo sjorford https://www.facebook.com/IndependentAlexOakwood/ 2016-05-05 0 0           ynmp-party:2   0
15238 15238 11985 Frank Harwood         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001781 Oakwood                       2016-05-05 0 0           PP52   0
15239 15239 11986 Roger Anthony Jackson         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001781 Oakwood                       2016-05-05 0 0           PP90   0
15240 15240 11987 Neil Wilson         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001781 Oakwood                       2016-05-05 0 0           PP53   0
15241 15241 11998 Adam Mark Hurt         local.derby.2016-05-05 94 party:52 Conservative and Unionist Party UTW:E05001782 Sinfin                       2016-05-05 0 0           PP52   0
15242 15242 11999 Jayprakash Joshi         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001782 Sinfin                       2016-05-05 0 0           PP85   0
15243 15243 12000 Paul John Lind         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001782 Sinfin                       2016-05-05 0 0           PP90   0
15244 15244 12001 Baggy Shanker         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001782 Sinfin                       2016-05-05 0 0           PP53   0
15245 15245 12005 John-Paul Keane         local.derby.2016-05-05 94 party:90 Liberal Democrats UTW:E05001783 Spondon                       2016-05-05 0 0           PP90   0
15246 15246 12006 Vaughan Saxby         local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001783 Spondon                       2016-05-05 0 0           PP85   0
15247 15247 12007 Michael Steven Winfield         local.derby.2016-05-05 94 party:53 Labour Party UTW:E05001783 Spondon                       2016-05-05 0 0           PP53   0
15248 15248 36087 Andrew Bennett Mr       local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001775 Darley                       2016-05-05 0 0   11957.0       PP85   0
15249 15249 36090 Barry Appleby Mr JP     local.derby.2016-05-05 94 party:85 UK Independence Party (UKIP) UTW:E05001767 Abbey                       2016-05-05 0 0   11922.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.062ms · Data license: CC-BY-SA · Data source: Democracy Club