home / democracyclub

candidates

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

105 rows where election = 86

✎ 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, facebook_page_url, facebook_personal_url, homepage_url, wikipedia_url, linkedin_url, image_copyright, image_uploading_user, image_uploading_user_notes, 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
14547 14547 1051 Sarah Janet Edwards     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006568 Wolvercote     http://www.greenoxfordshire.com/sarah_edwards       https://static-candidates.democracyclub.org.uk/media/images/images/1051.png   profile-photo Danby http://www.greenoxfordshire.com/sarah_edwards 2016-05-05 0 0           PP63   0
14548 14548 4545 Larry Sanders     male 1935-04-25 local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006567 Summertown     http://www.greenoxfordshire.com/larry   https://en.wikipedia.org/wiki/Larry_Sanders_(politician)   https://static-candidates.democracyclub.org.uk/media/images/images/4545.png   profile-photo davidrnewman It is the one we used on his Freepost leaflet 2016-05-05 0 0           PP63   0
14549 14549 4559 Ann Alice Duncan     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006551 Headington     https://my.greenparty.org.uk/candidates/106127 http://www.greenoxfordshire.com/oxford_east2015     https://static-candidates.democracyclub.org.uk/media/images/552ba7e262eb6fa83a5483b0.png   profile-photo OxfordshireGreenParty   2016-05-05 0 0           PP63   0
14550 14550 5075 Kate Prendergast     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006547 Carfax     https://my.greenparty.org.uk/candidates/106269       https://static-candidates.democracyclub.org.uk/media/images/554878db7779865b25b01bf6.png   profile-photo andylolz From party PPC page: https://my.greenparty.org.uk/candidates/106269 2016-05-05 0 0           PP63   0
14551 14551 6184 James Daniel Paul Morbin     Male   local.oxford.2016-05-05 86 party:804 Trade Unionist and Socialist Coalition DIW:E05006561 Northfield Brook     http://tusc2015.com/james-morbin-for-oxford-east/       https://static-candidates.democracyclub.org.uk/media/images/552ff40c7fce6de164f2fdef.png   profile-photo mark Taken from his official party candidate page here: http://tusc2015.com/james-morbin-for-oxford-east/ 2016-05-05 0 0           PP804   0
14552 14552 6529 Alasdair Murray     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006559 Marston     http://www.libdems.org.uk/alasdair_murray http://www.oxfordeastlibdems.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/550b5a933676900a02e16431.png   copyright-assigned ConorMcKenzie   2016-05-05 0 0   2431.0       PP90   0
14553 14553 6747 Mad Hatter     male   local.oxford.2016-05-05 86 party:66 Official Monster Raving Loony Party DIW:E05006547 Carfax       http://www.votemadhatter.info/   https://www.linkedin.com/profile/view?id=409537128&trk=nav_responsive_tab_profile https://static-candidates.democracyclub.org.uk/media/images/5506ff5e5399523471f7e1a9.png   copyright-assigned VoteMadHatter.info   2016-05-05 0 0           PP66   0
14554 14554 7244 Chaka Artwell     male 1968.0 local.oxford.2016-05-05 86 ynmp-party:2 Independent DIW:E05006545 Barton and Sandhills             https://static-candidates.democracyclub.org.uk/media/images/553f8378ab2d96380345a59f.png   profile-photo tfgg From https://electionleaflets.org/leaflets/11353/ 2016-05-05 0 0   10621;23535       ynmp-party:2   0
14555 14555 7920 Conor McKenzie     Male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006556 Jericho and Osney     http://www.oxonlibdems.uk/carfax http://conor.oxonlibdems.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7920_yOfexnS.png   profile-photo ConorMcKenzie https://www.facebook.com/ConorMcKenzieUK/photos/a.585490118128421.1073741825.585487071462059/1870667229610697/?type=1&theater 2016-05-05 0 0           PP90   0
14556 14556 7921 Andy McKay     Male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006554 Holywell     http://www.oxonlibdems.uk/andymckay https://students.oxfordeastlibdems.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/7921.png   copyright-assigned ConorMcKenzie   2016-05-05 0 0           PP90   0
14557 14557 8100 Ruth Elaine Wilkinson     female   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006551 Headington   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8100.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP90   0
14558 14558 8101 Mick Haines     male   local.oxford.2016-05-05 86 ynmp-party:2 Independent DIW:E05006559 Marston   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8101.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           ynmp-party:2   0
14559 14559 8419 James Fry     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006560 North   1.0 http://www.oxfordlabour.org.uk/james_fry http://www.oxfordlabour.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/8419.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP53   0
14560 14560 8757 Frances Baxter         local.oxford.2016-05-05 86 party:85 UK Independence Party (UKIP) DIW:E05006545 Barton and Sandhills                       2016-05-05 0 0           PP85   0
14561 14561 8758 Timothy Stephen Hamer         local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006545 Barton and Sandhills                       2016-05-05 0 0           PP52   0
14562 14562 8759 Ray Hitchens         local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006545 Barton and Sandhills                       2016-05-05 0 0           PP63   0
14563 14563 8761 Barbara Lesley Mallinder         local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006545 Barton and Sandhills                       2016-05-05 0 0           PP90   0
14564 14564 8762 Mike Rowley     male   local.oxford.2016-05-05 86 joint-party:53-119 Labour and Co-operative Party DIW:E05006545 Barton and Sandhills   1.0 http://www.oxfordlabour.org.uk/mike_rowley       https://static-candidates.democracyclub.org.uk/media/images/images/8762.png   profile-photo nlawrence This is the current councillor photo displayed on Oxford City Council website 2016-05-05 0 0           joint-party:53-119   0
14565 14565 8763 Vanessa Elizabeth Bhagwandin         local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006546 Blackbird Leys                       2016-05-05 0 0           PP52   0
14566 14566 8764 Simon Andrew Blakey     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006546 Blackbird Leys                       2016-05-05 0 0           PP90   0
14567 14567 8766 Greg Collier     male   local.oxford.2016-05-05 86 party:804 Trade Unionist and Socialist Coalition DIW:E05006546 Blackbird Leys                       2016-05-05 0 0           PP804   0
14568 14568 8767 Joseph Lawes     male   local.oxford.2016-05-05 86 party:85 UK Independence Party (UKIP) DIW:E05006546 Blackbird Leys                       2016-05-05 0 0           PP85   0
14569 14569 8768 Matthew Ledbury     male   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006546 Blackbird Leys                       2016-05-05 0 0           PP63   0
14570 14570 8769 Linda Kay Smith     female   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006546 Blackbird Leys   1.0 http://www.oxfordlabour.org.uk/linda_smith       https://static-candidates.democracyclub.org.uk/media/images/images/8769.png   profile-photo nlawrence Photo from Labour Party candidate website http://www.oxfordlabour.org.uk/linda_smith 2016-05-05 0 0           PP53   0
14571 14571 8772 Alex Curtis     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006547 Carfax             https://static-candidates.democracyclub.org.uk/media/images/images/8772.png   profile-photo AC97   2016-05-05 0 0           PP52   0
14572 14572 8777 Alex Hollingsworth     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006547 Carfax   1.0 http://www.oxfordlabour.org.uk/alex_hollingsworth3       https://static-candidates.democracyclub.org.uk/media/images/images/8777.png   profile-photo nlawrence Photo from Oxford City Councillors page 2016-05-05 0 0           PP53   0
14573 14573 8780 Harry Samuels     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006547 Carfax     http://www.oxonlibdems.uk/harrysamuels       https://static-candidates.democracyclub.org.uk/media/images/images/8780.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
14574 14574 8782 Mark Lygo     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006548 Churchill   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8782.png   profile-photo nlawrence Councillor photo on Oxford City Council website 2016-05-05 0 0           PP53   0
14575 14575 8783 Kevin Nicholas McGlynn Mr   male 1976.0 local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006548 Churchill     http://www.greenoxfordshire.com/kevin_mcglynn_2018 https://about.me/kevin.mcglynn   https://www.linkedin.com/in/kevinmcglynn https://static-candidates.democracyclub.org.uk/media/images/images/8783_2dl1i7U.png   profile-photo roselondonbrighton   2016-05-05 0 0           PP63   0
14576 14576 8784 Allan Selway     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006548 Churchill                       2016-05-05 0 0           PP52   0
14577 14577 8785 Gary Dixon Mr   male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006549 Cowley             https://static-candidates.democracyclub.org.uk/media/images/images/8785.png   public-domain Markb_gt I own it 2016-05-05 0 0   25938.0       PP52   0
14578 14578 8786 David Henwood     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006549 Cowley   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8786.png   profile-photo nlawrence   2016-05-05 0 0           PP53   0
14579 14579 8787 Claire Murray     female   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006549 Cowley                       2016-05-05 0 0           PP90   0
14580 14580 8788 Tony Brett     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006550 Cowley Marsh             https://static-candidates.democracyclub.org.uk/media/images/images/8788.png   other dwbowkett Photo supplied by candidate 2016-05-05 0 0           PP90   0
14581 14581 8789 Judith Anne Harley     female   local.oxford.2016-05-05 86 ynmp-party:2 Independent DIW:E05006550 Cowley Marsh                       2016-05-05 0 0   25446.0       ynmp-party:2   0
14582 14582 8790 Liam Hatch     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006550 Cowley Marsh                       2016-05-05 0 0           PP52   0
14583 14583 8791 Saj Malik     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006550 Cowley Marsh   1.0 http://www.oxfordlabour.org.uk/saj_malik       https://static-candidates.democracyclub.org.uk/media/images/images/8791.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP53   0
14584 14584 8792 Tony Gearing     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006551 Headington                       2016-05-05 0 0           PP52   0
14585 14585 8793 Marco Pontecorvi     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006551 Headington     http://www.oxfordlabour.org.uk/marco_pontecorvi       https://static-candidates.democracyclub.org.uk/media/images/images/8793.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
14586 14586 8795 Mark Bhagwandin Mr   male 1974.0 local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006552 Headington Hill and Northway           https://www.linkedin.com/in/mark-bhagwandin-56091342?trk=nav_responsive_tab_profile_pic https://static-candidates.democracyclub.org.uk/media/images/images/8795.png   profile-photo nlawrence   2016-05-05 0 0           PP52   0
14587 14587 8796 Maria Bourbon     female   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006552 Headington Hill and Northway     http://www.oxonlibdems.uk/mariabourbon                 2016-05-05 0 0           PP90   0
14588 14588 8797 Nigel Chapman     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006552 Headington Hill and Northway   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8797.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
14589 14589 8798 Oliver Fairey     male   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006552 Headington Hill and Northway                       2016-05-05 0 0           PP63   0
14590 14590 8799 Ben Carter Mr. MSc male 1976.0 local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006553 Hinksey Park       http://www.greenoxfordshire.com/benjamin_carter     https://static-candidates.democracyclub.org.uk/media/images/images/8799.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   19996.0       PP63   0
14591 14591 8800 Siddo Deva Mr   Male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006553 Hinksey Park             https://static-candidates.democracyclub.org.uk/media/images/images/8800_nvOaueu.png   public-domain Siddodeva   2016-05-05 0 0           PP52   0
14592 14592 8801 Nicholas Harding     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006553 Hinksey Park                       2016-05-05 0 0           PP90   0
14593 14593 8802 Marie Tidball     female   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006553 Hinksey Park   1.0 https://vote.labour.org.uk/marie-tidball http://www.oxfordlabour.org.uk/   https://www.linkedin.com/in/dr-marie-tidball-32328b20/ https://static-candidates.democracyclub.org.uk/media/images/images/8802.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
14594 14594 8803 Dan Iley-Williamson     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006554 Holywell   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/8803.png   copyright-assigned dan.ileywilliamson It's my (the candidate's) own photo. 2016-05-05 0 0           PP53   0
14595 14595 8804 Fiona Kelly Joines     female 1977.0 local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006554 Holywell             https://static-candidates.democracyclub.org.uk/media/images/images/8804.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
14596 14596 8806 George Walker     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006554 Holywell                       2016-05-05 0 0           PP52   0
14597 14597 8807 Simon James Bazley Mr   male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006555 Iffley Fields           https://www.linkedin.com/in/simon-bazley-491b88b https://static-candidates.democracyclub.org.uk/media/images/images/8807.png   public-domain TimPatmore   2016-05-05 0 0   25692.0       PP52   0
14598 14598 8808 Elise Danielle Benjamin     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006555 Iffley Fields             https://static-candidates.democracyclub.org.uk/media/images/images/8808.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP63   0
14599 14599 8809 Peter Bergamin     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006555 Iffley Fields                       2016-05-05 0 0           PP90   0
14600 14600 8810 Steve Curran     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006555 Iffley Fields   1.0 http://www.oxfordlabour.org.uk/steve_curran       https://static-candidates.democracyclub.org.uk/media/images/images/8811.png   profile-photo nlawrence   2016-05-05 0 0   8811.0       PP53   0
14601 14601 8812 Colin Cook     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006556 Jericho and Osney   1.0 http://www.oxfordlabour.org.uk/colin_cook       https://static-candidates.democracyclub.org.uk/media/images/images/8812.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP53   0
14602 14602 8815 Lucy Irene Fitchett Ayrton     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006557 Littlemore                       2016-05-05 0 0           PP63   0
14603 14603 8816 Charles James Bidwell     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006557 Littlemore                       2016-05-05 0 0           PP90   0
14604 14604 8817 Daniel Stafford Mr   male 1986.0 local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006557 Littlemore       http://www.danielstafford.co.uk   https://www.linkedin.com/in/daniel-stafford-858b98135/ https://static-candidates.democracyclub.org.uk/media/images/images/8817.png   profile-photo duverger This is used on the candidate's party platform page. 2016-05-05 0 0           PP52 Cream Cracker 0
14605 14605 8818 John Stuart Tanner     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006557 Littlemore   1.0 http://www.oxfordlabour.org.uk/john_tanner       https://static-candidates.democracyclub.org.uk/media/images/images/8818.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP53   0
14606 14606 8819 Pat Kennedy     female   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006558 Lye Valley   1.0 http://www.oxfordlabour.org.uk/pat_kennedy http://www.oxfordlabour.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/8819.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP53   0
14607 14607 8820 Johnson Mackline Kyeswa Mr   male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006558 Lye Valley             https://static-candidates.democracyclub.org.uk/media/images/images/8820.png   public-domain TimPatmore   2016-05-05 0 0           PP52   0
14608 14608 8821 Mandy Machado     female   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006558 Lye Valley                       2016-05-05 0 0           PP90   0
14609 14609 8822 Tim Peter Pizey     male   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006558 Lye Valley                       2016-05-05 0 0           PP63   0
14610 14610 8824 Charlie Haynes     male   local.oxford.2016-05-05 86 ynmp-party:2 Independent DIW:E05006559 Marston                       2016-05-05 0 0           ynmp-party:2   0
14611 14611 8825 Tim Patmore Mr   male 1983-05-25 local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006559 Marston           https://www.linkedin.com/in/tim-patmore-a4041726/ https://static-candidates.democracyclub.org.uk/media/images/images/8825.png   profile-photo nlawrence   2016-05-05 0 0   25761;36138       PP52 Chocolate HobNob 0
14612 14612 8826 Miranda Shaw     female 1987.0 local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006559 Marston     http://www.greenoxfordshire.com/miranda_shaw       https://static-candidates.democracyclub.org.uk/media/images/images/8826.png   profile-photo Danby http://www.greenoxfordshire.com/miranda_shaw 2016-05-05 0 0           PP63   0
14613 14613 8827 Nick Walker     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006559 Marston             https://static-candidates.democracyclub.org.uk/media/images/images/8827.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
14614 14614 8828 Claire Margaret El Mouden     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006560 North                       2016-05-05 0 0           PP63   0
14615 14615 8829 Louis Joseph Simborowski Gill     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006560 North                       2016-05-05 0 0           PP90   0
14616 14616 8830 Robert Vernon Porter     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006560 North                       2016-05-05 0 0           PP52   0
14617 14617 8831 Pat Jones Ms   female   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006561 Northfield Brook             https://static-candidates.democracyclub.org.uk/media/images/images/8831.png   profile-photo nlawrence   2016-05-05 0 0           PP52   0
14618 14618 8832 Rosemary Anne Beatrice Morlin     female   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006561 Northfield Brook             https://static-candidates.democracyclub.org.uk/media/images/images/8832.png   public-domain dwbowkett   2016-05-05 0 0   25434.0       PP90   0
14619 14619 8833 Robert James Henry Paynter     male   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006561 Northfield Brook     http://www.greenoxfordshire.com/Robert_Paynter       https://static-candidates.democracyclub.org.uk/media/images/images/8833.png   profile-photo Danby http://www.greenoxfordshire.com/Robert_Paynter 2016-05-05 0 0           PP63   0
14620 14620 8834 Sian Taylor     female   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006561 Northfield Brook   1.0 http://www.oxfordlabour.org.uk/sian_taylor http://www.oxfordlabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/8834.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0           PP53   0
14621 14621 8835 Bill Clare     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006562 Quarry and Risinghurst                       2016-05-05 0 0           PP52   0
14622 14622 8836 Chewe Edgar Munkonge     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006562 Quarry and Risinghurst   1.0 http://www.oxfordlabour.org.uk/chewe_munkonge       https://static-candidates.democracyclub.org.uk/media/images/images/8836.png   profile-photo nlawrence   2016-05-05 0 0           PP53   0
14623 14623 8837 Roz Smith     female   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006562 Quarry and Risinghurst     http://www.oxonlibdems.uk/rozsmith       https://static-candidates.democracyclub.org.uk/media/images/images/8837.png   other nlawrence Councillor photo from Oxfordshire County Council website 2016-05-05 0 0   20559.0       PP90   0
14624 14624 8838 Liz Taylor     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006562 Quarry and Risinghurst     http://www.greenoxfordshire.com/liz_taylor       https://static-candidates.democracyclub.org.uk/media/images/images/8838.png   profile-photo Danby http://www.greenoxfordshire.com/liz_taylor 2016-05-05 0 0           PP63   0
14625 14625 8839 Janet Mary Wallis Hall     female   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006563 Rose Hill and Iffley                       2016-05-05 0 0           PP63   0
14626 14626 8840 Lilian Julia Sherwood     female   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006563 Rose Hill and Iffley     http://oxfordshireconservatives.com/2013/?page_id=8       https://static-candidates.democracyclub.org.uk/media/images/images/8840.png   profile-photo edent http://oxfordshireconservatives.com/2013/?page_id=8 2016-05-05 0 0           PP52   0
14627 14627 8841 Edward Owen Turner     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006563 Rose Hill and Iffley   1.0 http://www.oxfordlabour.org.uk/ed_turner       https://static-candidates.democracyclub.org.uk/media/images/images/8841.png   profile-photo nlawrence   2016-05-05 0 0           PP53   0
14628 14628 8842 Ruvi Ziegler Dr   male 1979.0 local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006563 Rose Hill and Iffley     http://www.oxonlibdems.uk/northward     https://www.linkedin.com/in/dr-reuven-ruvi-ziegler-0b797414 https://static-candidates.democracyclub.org.uk/media/images/images/8842.png   profile-photo edent https://www.linkedin.com/in/dr-reuven-ruvi-ziegler-0b797414 2016-05-05 0 0           PP90   0
14629 14629 8843 Jamila Begum Azad     female   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006564 St Clement's   1.0 http://www.oxfordlabour.org.uk/jamila_azad                 2016-05-05 0 0           PP53   0
14630 14630 8844 Timothy John Robert Eden Mr   male 1989.0 local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006564 St Clement's     http://www.greenoxfordshire.com/oxford_candidates_2016 http://www.greenoxfordshire.com/     https://static-candidates.democracyclub.org.uk/media/images/images/8844.png   copyright-assigned TJRE It is my picture 2016-05-05 0 0           PP63   0
14631 14631 8849 Graham Roderick Jones     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006564 St Clement's             https://static-candidates.democracyclub.org.uk/media/images/images/8849.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
14632 14632 8850 Tom Landell Mills     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006565 St Margaret's   1.0                   2016-05-05 0 0           PP90   0
14633 14633 8852 Penelope Lenon Mrs   female   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006565 St Margaret's             https://static-candidates.democracyclub.org.uk/media/images/images/8852.png   profile-photo TimPatmore   2016-05-05 0 0           PP52   0
14634 14634 8853 Catrin Roberts     female   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006565 St Margaret's                       2016-05-05 0 0           PP53   0
14635 14635 8854 Al Wilson     male   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006565 St Margaret's     http://www.greenoxfordshire.com/al_wilson       https://static-candidates.democracyclub.org.uk/media/images/images/8854.png   profile-photo Danby http://www.greenoxfordshire.com/al_wilson 2016-05-05 0 0           PP63   0
14636 14636 8855 Mohammed Azad     male   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006566 St Mary's                       2016-05-05 0 0           PP53   0
14637 14637 8856 Dominic Heaney     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006566 St Mary's                       2016-05-05 0 0           PP52   0
14638 14638 8857 Craig Simmons     male   local.oxford.2016-05-05 86 party:63 Green Party DIW:E05006566 St Mary's   1.0 http://www.greenoxfordshire.com/Craig_Simmons       https://static-candidates.democracyclub.org.uk/media/images/images/8857.png   profile-photo nlawrence Councillor photo from Oxford City Council website 2016-05-05 0 0   25832.0       PP63   0
14639 14639 8858 Mike Tait     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006566 St Mary's             https://static-candidates.democracyclub.org.uk/media/images/images/8858.png   profile-photo nlawrence   2016-05-05 0 0           PP90   0
14640 14640 8867 Andrew Gant     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006567 Summertown   1.0 http://www.libdems.org.uk/andrew_gant   https://en.wikipedia.org/wiki/Andrew_Gant   https://static-candidates.democracyclub.org.uk/media/images/images/8867.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
14641 14641 8868 Graham Stanton Jones     male   local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006567 Summertown                       2016-05-05 0 0           PP52   0
14642 14642 8873 Jane Marilyn Stockton     female   local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006567 Summertown     http://www.oxfordlabour.org.uk/jane_stockton                 2016-05-05 0 0           PP53   0
14643 14643 10618 Angie Goff         local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006568 Wolvercote   1.0                   2016-05-05 0 0           PP90   0
14644 14644 10619 Rosie Hilliard         local.oxford.2016-05-05 86 party:52 Conservative and Unionist Party DIW:E05006568 Wolvercote                       2016-05-05 0 0           PP52   0
14645 14645 10620 Hugh Michael Tappin         local.oxford.2016-05-05 86 party:53 Labour Party DIW:E05006568 Wolvercote                       2016-05-05 0 0           PP53   0
14646 14646 25443 Peter Charles Coggins     male   local.oxford.2016-05-05 86 party:90 Liberal Democrats DIW:E05006548 Churchill     http://www.oxonlibdems.uk/petercoggins       https://static-candidates.democracyclub.org.uk/media/images/images/25443.png   profile-photo Danby http://www.oxonlibdems.uk/petercoggins 2016-05-05 0 0   8781.0       PP90   0

Next page

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.168ms · Data license: CC-BY-SA · Data source: Democracy Club