home / democracyclub

candidates

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

73 rows where election = 32

✎ 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, favourite_biscuits

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
9980 9980 5012 Barry Hodgson     male   local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001334 Penn     http://ukipwolverhampton.org/m-p-candidates/                 2016-05-05 0 0           PP85   0
9981 9981 5583 Arun Photay     male   local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001338 Tettenhall Wightwick   1.0 https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Photay_Arun.aspx http://www.arunphotay.com/   http://uk.linkedin.com/pub/arun-photay-ba-hons-adcb/49/680/b30/en https://static-candidates.democracyclub.org.uk/media/images/55225af1328bff5d39338a6a.png   profile-photo JPCarrington Used on main page of candidate's campaign website http://www.arunphotay.com/home.html 2016-05-05 0 0           PP52   0
9982 9982 6947 Andrea Cantrill     Female   local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001333 Park     https://my.greenparty.org.uk/candidates/106305       https://static-candidates.democracyclub.org.uk/media/images/554879923c0ead4826d5918a.png   profile-photo andylolz From party PPC page: https://my.greenparty.org.uk/candidates/106305 2016-05-05 0 0   6231.0       PP63 Anything homemade! 0
9983 9983 7124 Ian Jenkins     Male   local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001324 Bushbury North             https://static-candidates.democracyclub.org.uk/media/images/551b3c1413eb34c82843cb66.png   profile-photo JPCarrington On local party's PPC page here: http://www.wolverhamptoneastlibdems.org.uk/2015/03/13/parliamentary-candidates-for-general-election-2015/ 2016-05-05 0 0   3953;17832       PP90   0
9984 9984 16704 Payal Bedi-Chadha         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001321 Bilston East   1.0                   2016-05-05 0 0           PP53   0
9985 9985 16705 Tom Fellows         local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001321 Bilston East                       2016-05-05 0 0           PP85   0
9986 9986 16706 David Mackintosh         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001321 Bilston East                       2016-05-05 0 0           PP52   0
9987 9987 17271 Paula Christine Brookfield     female   local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001340 Wednesfield South   1.0 http://www.wolverhamptonlabour.com/wards/wednesfield-south/paula-brookfield                 2016-05-05 0 0           PP53   0
9988 9988 17272 Steve Hall         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001340 Wednesfield South                       2016-05-05 0 0           PP52   0
9989 9989 17825 Peter William Dobb         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001322 Bilston North                       2016-05-05 0 0           PP52   0
9990 9990 17826 Ray Hollington         local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001322 Bilston North                       2016-05-05 0 0           PP85   0
9991 9991 17827 Linda Mary Leach     female   local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001322 Bilston North   1.0 http://www.wolverhamptonlabour.com/wards/bilston-north/linda-leach                 2016-05-05 0 0           PP53   0
9992 9992 17828 Sera Singh Aulakh         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001323 Blakenhall                       2016-05-05 0 0           PP52   0
9993 9993 17829 Bhajan Singh Devsi         local.wolverhampton.2016-05-05 32 ynmp-party:2 Independent MTW:E05001323 Blakenhall                       2016-05-05 0 0           ynmp-party:2   0
9994 9994 17830 John Jeffrey Rowley         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001323 Blakenhall   1.0                   2016-05-05 0 0           PP53   0
9995 9995 17831 Gerard Fletcher         local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001324 Bushbury North                       2016-05-05 0 0           PP85   0
9996 9996 17833 Hazel Malcolm         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001324 Bushbury North   1.0                   2016-05-05 0 0           PP53   0
9997 9997 17834 Andrew William McNeil         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001324 Bushbury North                       2016-05-05 0 0           PP52   0
9998 9998 17835 Michelle Webster         local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001324 Bushbury North                       2016-05-05 0 0           PP63   0
9999 9999 17844 Peter Alan Bilson         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001325 Bushbury South and Low Hill   1.0                   2016-05-05 0 0           PP53   0
10000 10000 17845 Simon Mark Hewitt         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001325 Bushbury South and Low Hill                       2016-05-05 0 0           PP52   0
10001 10001 17846 Ann Jenkins         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001325 Bushbury South and Low Hill                       2016-05-05 0 0           PP90   0
10002 10002 17847 Aaron Andrew Hall         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001326 East Park                       2016-05-05 0 0           PP52   0
10003 10003 17848 Terry Hancox         local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001326 East Park                       2016-05-05 0 0           PP63   0
10004 10004 17849 James Leyshon         local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001326 East Park                       2016-05-05 0 0           PP85   0
10005 10005 17850 Anwen Dawn Muston Ms   Female 1956-01-09 local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001326 East Park   1.0   https://eastparklabour.wordpress.com/               2016-05-05 0 0           PP53   0
10006 10006 17851 William of Shropshire         local.wolverhampton.2016-05-05 32 ynmp-party:2 Independent MTW:E05001326 East Park                       2016-05-05 0 0           ynmp-party:2   0
10007 10007 17852 Adam Ansari         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001327 Ettingshall                       2016-05-05 0 0           PP52   0
10008 10008 17853 Jennifer Cooper         local.wolverhampton.2016-05-05 32 party:73 Socialist Labour Party MTW:E05001327 Ettingshall                       2016-05-05 0 0           PP73   0
10009 10009 17854 Zee Russell         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001327 Ettingshall   1.0                   2016-05-05 0 0           PP53   0
10010 10010 17855 Ian Brookfield         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001328 Fallings Park   1.0                   2016-05-05 0 0           PP53   0
10011 10011 17856 Tracey Dawn Jukes         local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001328 Fallings Park                       2016-05-05 0 0           PP85   0
10012 10012 17857 Peter Nixon         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001328 Fallings Park                       2016-05-05 0 0           PP90   0
10013 10013 17858 Giuliano Ivanov Pisarski         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001328 Fallings Park                       2016-05-05 0 0           PP52   0
10014 10014 17859 David John Belcher         local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001329 Graiseley                       2016-05-05 0 0           PP63   0
10015 10015 17860 Jas Boparai         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001329 Graiseley                       2016-05-05 0 0           PP52   0
10016 10016 17861 John Charles Reynolds         local.wolverhampton.2016-05-05 32 joint-party:53-119 Labour and Co-operative Party MTW:E05001329 Graiseley   1.0                   2016-05-05 0 0           joint-party:53-119   0
10017 10017 17862 Kieran Patrick Smith         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001329 Graiseley                       2016-05-05 0 0           PP90   0
10018 10018 17863 Alan William Bamber         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001330 Heath Town                       2016-05-05 0 0           PP90   0
10019 10019 17864 Jasbir Kaur Jaspal     Female   local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001330 Heath Town   1.0 http://www.wolverhamptonlabour.com/wards/heath-town/jasbir-jaspal                 2016-05-05 0 0           PP53   0
10020 10020 17865 Fortune Sibanda         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001330 Heath Town                       2016-05-05 0 0           PP52   0
10021 10021 17866 Jarrad Williams         local.wolverhampton.2016-05-05 32 party:804 Trade Unionist and Socialist Coalition MTW:E05001330 Heath Town                       2016-05-05 0 0           PP804   0
10022 10022 17867 Alan David Bolshaw     Male   local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001331 Merry Hill   1.0 http://www.wolverhamptonlabour.com/wards/merry-hill/alan-bolshaw       https://static-candidates.democracyclub.org.uk/media/images/images/17867.png   profile-photo ClaireDarke From Labour party website 2016-05-05 0 0           PP53   0
10023 10023 17868 Carl James Husted         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001331 Merry Hill                       2016-05-05 0 0           PP52   0
10024 10024 17869 Henry Obi         local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001331 Merry Hill                       2016-05-05 0 0           PP63   0
10025 10025 17870 Jessica Rose Pringle         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001331 Merry Hill                       2016-05-05 0 0           PP90   0
10026 10026 17871 Louise Margaret Miles         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001332 Oxley   1.0                   2016-05-05 0 0           PP53   0
10027 10027 17872 Robert Edward Quarmby         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001332 Oxley                       2016-05-05 0 0           PP90   0
10028 10028 17873 Neil David Turner         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001332 Oxley                       2016-05-05 0 0           PP52   0
10029 10029 17874 Claire Darke     female   local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001333 Park   1.0 http://www.wolverhamptonlabour.com/wards/park/claire-darke       https://static-candidates.democracyclub.org.uk/media/images/images/17874.png   copyright-assigned ClaireDarke   2016-05-05 0 0           PP53   0
10030 10030 17875 Kamran Khan         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001333 Park                       2016-05-05 0 0           PP52   0
10031 10031 17876 Bryan Hamer Lewis         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001333 Park                       2016-05-05 0 0           PP90   0
10032 10032 17882 Simon Bennett Mr   male 1989-04-25 local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001334 Penn           https://uk.linkedin.com/in/simonbennett89 https://static-candidates.democracyclub.org.uk/media/images/images/17882.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52 Chocolate covered Malted Milks 0
10033 10033 17883 Jeffrey William Hemsley         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001334 Penn                       2016-05-05 0 0           PP90   0
10034 10034 17884 Martin Wintour Waite         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001334 Penn   1.0                   2016-05-05 0 0           PP53   0
10035 10035 17886 Savita Sehdev         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001336 Spring Vale                       2016-05-05 0 0           PP52   0
10036 10036 17887 Mak Singh         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001336 Spring Vale   1.0                   2016-05-05 0 0           PP53   0
10037 10037 17888 Hazel Thomas         local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001336 Spring Vale                       2016-05-05 0 0           PP85   0
10038 10038 17889 Rachel Arnold         local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001335 St Peter's                       2016-05-05 0 0           PP63   0
10039 10039 17890 Sohail Khan         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001335 St Peter's                       2016-05-05 0 0           PP52   0
10040 10040 17891 Roger Charles Lawrence     Male   local.wolverhampton.2016-05-05 32 joint-party:53-119 Labour and Co-operative Party MTW:E05001335 St Peter's   1.0 http://www.wolverhamptonlabour.com/wards/st-peters/roger-lawrence                 2016-05-05 0 0           joint-party:53-119   0
10041 10041 17892 Mark Edmund Evans         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP52   0
10042 10042 17893 Peter George Hollis         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP90   0
10043 10043 17894 Doug Hope         local.wolverhampton.2016-05-05 32 party:85 UK Independence Party (UKIP) MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP85   0
10044 10044 17895 Chester Morrison         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP53   0
10045 10045 17896 Udey Singh Cllr   Male   local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001337 Tettenhall Regis   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/17896.png   copyright-assigned Udey   2016-05-05 0 0           PP52 Cream Custard 0
10046 10046 17897 Frances Kathleen Heap         local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001338 Tettenhall Wightwick                       2016-05-05 0 0           PP90   0
10047 10047 17898 John Pitt         local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001338 Tettenhall Wightwick                       2016-05-05 0 0           PP63   0
10048 10048 17899 Phil Walker         local.wolverhampton.2016-05-05 32 party:53 Labour Party MTW:E05001338 Tettenhall Wightwick                       2016-05-05 0 0           PP53   0
10049 10049 17900 Philip Thomas Alexander Bateman         local.wolverhampton.2016-05-05 32 joint-party:53-119 Labour and Co-operative Party MTW:E05001339 Wednesfield North   1.0                   2016-05-05 0 0           joint-party:53-119   0
10050 10050 17901 Lee Harris         local.wolverhampton.2016-05-05 32 party:63 Green Party MTW:E05001339 Wednesfield North                       2016-05-05 0 0           PP63   0
10051 10051 17902 Andrew Scott Randle         local.wolverhampton.2016-05-05 32 party:52 Conservative and Unionist Party MTW:E05001339 Wednesfield North                       2016-05-05 0 0           PP52   0
10052 10052 34181 Sarah Quarmby Mrs   female 1991.0 local.wolverhampton.2016-05-05 32 party:90 Liberal Democrats MTW:E05001336 Spring Vale     http://www.libdems.org.uk/sarah_quarmby       https://static-candidates.democracyclub.org.uk/media/images/images/17885.png   copyright-assigned sarahquarmby Candidate is allowing the use 2016-05-05 0 0   17885.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 9.347ms · Data license: CC-BY-SA · Data source: Democracy Club