Data license: CC-BY-SA · Data source: Democracy Club
This data as JSON, CSV (advanced)
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, 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 | twitter_username | facebook_page_url | party_ppc_page_url | facebook_personal_url | homepage_url | wikipedia_url | linkedin_url | image_url | proxy_image_url_template | image_copyright | image_uploading_user | image_uploading_user_notes | twitter_user_id | 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14799 | 14799 | 1011 | Martin Tod | male | 1964-08-22 | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011005 | St Paul | martin@meonvalleylibdems.org.uk | mpntod | https://www.facebook.com/cllr.martin.tod/ | http://www.libdems.org.uk/martin_tod | https://www.facebook.com/martin.tod | http://www.martintod.org.uk | https://uk.linkedin.com/in/martintod | https://static-candidates.democracyclub.org.uk/media/images/images/1011_57vYvFC.png | profile-photo | mpntod | Original of photo displayed here - https://twitter.com/mpntod | 1691801 | 2016-05-05 | 0 | 0 | 17769.0 | PP90 | Dark Chocolate Florentine. | 0 | ||||||||||
| 14800 | 14800 | 2269 | Patrick Davies | male | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011003 | St Luke | patrickdavies@74canon.freeserve.co.uk | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||
| 14801 | 14801 | 4542 | Jackie Porter | Female | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011007 | The Worthys | jackie@jackieporter.co.uk | jackielibdem | http://www.facebook.com/Jackie4Winchester | http://www.libdems.org.uk/jackie_porter | http://www.jackieporter.co.uk | https://www.linkedin.com/in/jackielibdem | https://static-candidates.democracyclub.org.uk/media/images/images/4542.png | profile-photo | Auto imported from Twitter | 1897390027 | 2016-05-05 | 0 | 0 | PP90 | 0 | |||||||||||||||
| 14802 | 14802 | 5273 | Andrew Adams | Mr | male | 1982.0 | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011003 | St Luke | andy@andovernwhlabour.org.uk | _AndyAdams_ | http://facebook.com/andovernwhlabour | http://www.andovernwhlabour.org.uk/andy | http://www.andovernwhlabour.org.uk/ | https://static-candidates.democracyclub.org.uk/media/images/551ac34b13eb34c82843cb2e.png | other | _AndyAdams_ | I'm the candidate - photo owned by me and free of copyright. | 35598574 | 2016-05-05 | 0 | 0 | 5356;17722;42925 | PP53 | Jaffa Cake | 0 | |||||||||||
| 14803 | 14803 | 6036 | Michael Wilks | Male | local.winchester.2016-05-05 90 | party:63 | Green Party | DIW:E05011002 | St Bartholomew | mwilks@bma.org.uk | WilksMwilks | https://static-candidates.democracyclub.org.uk/media/images/553b8f3be6d2cbcd26e36a2e.png | profile-photo | edent | This is the candidate’s twitter profile image, from https://twitter.com/WilksMwilks | 516685934 | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||
| 14804 | 14804 | 6392 | Eleanor Bell | female | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010996 | Badger Farm & Oliver's Battery | eleanor.bell@southampton-libdems.org.uk | EleanorBell2015 | https://static-candidates.democracyclub.org.uk/media/images/553c97bd41b868785b1fe672.png | profile-photo | edent | This is the candidate’s twitter profile image, from https://twitter.com/EleanorBell2015 | 3053609033 | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||
| 14805 | 14805 | 7732 | Mike Read | male | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP52 | 0 | |||||||||||||||||||||||||
| 14806 | 14806 | 14965 | Chris Barton-Briddon | local.winchester.2016-05-05 90 | party:85 | UK Independence Party (UKIP) | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 14807 | 14807 | 14966 | Gavin Craig Dick | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14808 | 14808 | 14967 | Rob Ducker | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14809 | 14809 | 14968 | Brian Leslie Laming | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010996 | Badger Farm & Oliver's Battery | http://www.winld.org.uk/your_candidate_badgers_farm_and_olivers_battery | https://static-candidates.democracyclub.org.uk/media/images/images/14968.png | profile-photo | jtonline | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||
| 14810 | 14810 | 14969 | Alun Glyn Rees | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14811 | 14811 | 14970 | Peter Rees | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14812 | 14812 | 14971 | John Louis Romero | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14813 | 14813 | 14972 | Jonathan Paul Tettmar | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14814 | 14814 | 14973 | Jan Warwick | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010996 | Badger Farm & Oliver's Battery | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14815 | 14815 | 15008 | Sudhakar Kedareshwar Achwal | local.winchester.2016-05-05 90 | ynmp-party:2 | Independent | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | ||||||||||||||||||||||||||
| 14816 | 14816 | 15009 | Laurie Clough | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14817 | 14817 | 15010 | Steve Haines | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14818 | 14818 | 15011 | Thomas Houghton | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14819 | 14819 | 15012 | Rob Humby | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14820 | 14820 | 15013 | Steven John Jakubowski | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14821 | 14821 | 15014 | David Charles Leon McLean | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14822 | 14822 | 15016 | Benjamin Russell Mackintosh Stoneham | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14823 | 14823 | 15017 | Vivienne Angela Young | local.winchester.2016-05-05 90 | party:85 | UK Independence Party (UKIP) | DIW:E05010997 | Bishop's Waltham | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 14824 | 14824 | 15018 | Keith Eric Divall | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14825 | 14825 | 15019 | Russell Digby Gordon-Smith | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14826 | 14826 | 15020 | Kim Alexander Gottlieb | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14827 | 14827 | 15021 | Lisa Suzanne Griffiths | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14828 | 14828 | 15022 | Lee Arthur Hayes | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14829 | 14829 | 15023 | Ernie Jeffs | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14830 | 14830 | 15024 | James Edwin Leppard | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14831 | 14831 | 15025 | Margot Julia Power | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010995 | Alresford & Itchen Valley | margot.power@legworkalresford.co.uk | http://www.winld.org.uk/your_candidate_alresford_itchen_valley_margot_power | https://www.facebook.com/margot.power.568 | https://static-candidates.democracyclub.org.uk/media/images/images/15025.png | profile-photo | jtonline | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||
| 14832 | 14832 | 15026 | Ian Duncan Wight | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010995 | Alresford & Itchen Valley | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14833 | 14833 | 17605 | Sheila Mary Campbell | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010998 | Central Meon Valley | http://www.winld.org.uk/your_candidate_central_meon_valley_sheila_campbell | https://static-candidates.democracyclub.org.uk/media/images/images/17605.png | profile-photo | jtonline | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||
| 14834 | 14834 | 17606 | Stan Evans | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14835 | 14835 | 17607 | Linda Eileen Elizabeth Gemmell | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14836 | 14836 | 17608 | Alex Graft | Alex Graft | 1983.0 | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010998 | Central Meon Valley | alex.graft@yahoo.co.uk | alex_graft | https://static-candidates.democracyclub.org.uk/media/images/images/17608.png | public-domain | alex19 | 1901810017 | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||
| 14837 | 14837 | 17609 | Leslie Thomas Mitchell | local.winchester.2016-05-05 90 | party:85 | UK Independence Party (UKIP) | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 14838 | 14838 | 17610 | Frank Richard Pearson | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14839 | 14839 | 17611 | Margaret Scriven | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14840 | 14840 | 17612 | Anne Kristine Mackintosh Stoneham | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14841 | 14841 | 17613 | Nicola Ann Wardrop | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14842 | 14842 | 17614 | Vicki Weston | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010998 | Central Meon Valley | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14843 | 14843 | 17621 | Paul James Brown | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010999 | Colden Common & Twyford | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14844 | 14844 | 17622 | Sue J Cook | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010999 | Colden Common & Twyford | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14845 | 14845 | 17623 | Sonia Frances Critcher | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05010999 | Colden Common & Twyford | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14846 | 14846 | 17624 | Julia Ellen Hallmann | local.winchester.2016-05-05 90 | party:63 | Green Party | DIW:E05010999 | Colden Common & Twyford | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 14847 | 14847 | 17625 | Richard Charles Izard | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010999 | Colden Common & Twyford | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14848 | 14848 | 17626 | Robert Johnston | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05010999 | Colden Common & Twyford | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14849 | 14849 | 17627 | Maureen Anne Rees | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05010999 | Colden Common & Twyford | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14850 | 14850 | 17640 | Caroline Lorraine Brook | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14851 | 14851 | 17641 | Jacqueline June Carroll | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14852 | 14852 | 17642 | Steve Della Mora | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14853 | 14853 | 17643 | Andrew Negus | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14854 | 14854 | 17644 | Claire Louise Sorensen | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14855 | 14855 | 17645 | Patricia Grace Stallard | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14856 | 14856 | 17646 | Simon Paul Wernick | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011000 | Denmead | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14857 | 14857 | 17658 | Mags Brown | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14858 | 14858 | 17659 | Angela Clear | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14859 | 14859 | 17660 | Neil Richard Cutler | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011006 | Southwick & Wickham | http://www.winld.org.uk/your_candidate_southwick_wickham_neil_cutler | https://static-candidates.democracyclub.org.uk/media/images/images/17660.png | profile-photo | jtonline | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||
| 14860 | 14860 | 17661 | Leon George Dabbs | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14861 | 14861 | 17662 | Therese Evans | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14862 | 14862 | 17663 | Gary Allan Gray | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14863 | 14863 | 17664 | Paul Francis Harris | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14864 | 14864 | 17665 | Neil Harold Lander-Brinkley | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14865 | 14865 | 17666 | Ian James Norgate | local.winchester.2016-05-05 90 | party:85 | UK Independence Party (UKIP) | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 14866 | 14866 | 17667 | Paul Thomas Sony | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011006 | Southwick & Wickham | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14867 | 14867 | 17681 | Eileen Mary Berry | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14868 | 14868 | 17682 | Adrian John Paul Field | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14869 | 14869 | 17683 | Hannah Valentine Field | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14870 | 14870 | 17684 | Kezia Melissa Louise Hoffman | local.winchester.2016-05-05 90 | ynmp-party:2 | Independent | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | ||||||||||||||||||||||||||
| 14871 | 14871 | 17685 | Cameron Thomas Strachan Johnson | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14872 | 14872 | 17686 | Kelsie Learney | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14873 | 14873 | 17687 | Paul Charles Twelftree | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14874 | 14874 | 17688 | Tessa Susan Valentine | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14875 | 14875 | 17689 | Anne Helen Weir | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011001 | St Barnabas | http://www.winld.org.uk/your_candidate_st_barnabas_anne_weir | https://static-candidates.democracyclub.org.uk/media/images/images/17689.png | profile-photo | jtonline | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||
| 14876 | 14876 | 17690 | Angie Wilkinson | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011001 | St Barnabas | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14877 | 14877 | 17707 | Bob Barnes | local.winchester.2016-05-05 90 | party:85 | UK Independence Party (UKIP) | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 14878 | 14878 | 17708 | Rose Burns | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14879 | 14879 | 17709 | Lucy Emma Clement | local.winchester.2016-05-05 90 | party:63 | Green Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 14880 | 14880 | 17710 | Michael Frederick Coker-Davies | local.winchester.2016-05-05 90 | ynmp-party:2 | Independent | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | ||||||||||||||||||||||||||
| 14881 | 14881 | 17711 | David James Crudgington | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14882 | 14882 | 17712 | Kathleen Frances Alice East | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14883 | 14883 | 17713 | Nicki Elks | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14884 | 14884 | 17714 | Sue Falconer | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14885 | 14885 | 17715 | Clive Malcolm Gosling | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14886 | 14886 | 17716 | Rhian Louise Harrison | local.winchester.2016-05-05 90 | party:63 | Green Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 14887 | 14887 | 17717 | Dominic Charles Alan Hiscock | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14888 | 14888 | 17718 | Lawrence Andreas Leslie Mason | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011002 | St Bartholomew | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 14889 | 14889 | 17723 | Derek Green | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011003 | St Luke | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14890 | 14890 | 17724 | Tomos Owain James | local.winchester.2016-05-05 90 | party:4047 | Winchester Independents | DIW:E05011003 | St Luke | 2016-05-05 | 0 | 0 | PP4047 | 0 | ||||||||||||||||||||||||||
| 14891 | 14891 | 17725 | George Edward Marshall-James | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011003 | St Luke | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14892 | 14892 | 17726 | Kia Robert Pope | local.winchester.2016-05-05 90 | party:63 | Green Party | DIW:E05011003 | St Luke | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 14893 | 14893 | 17727 | Harry William Sampson | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011003 | St Luke | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14894 | 14894 | 17728 | Jamie Robert Jonathan Scott | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011003 | St Luke | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14895 | 14895 | 17738 | Guy Julian Claude Ashton | local.winchester.2016-05-05 90 | party:52 | Conservative and Unionist Party | DIW:E05011004 | St Michael | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 14896 | 14896 | 17739 | David Banks | local.winchester.2016-05-05 90 | party:90 | Liberal Democrats | DIW:E05011004 | St Michael | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 14897 | 14897 | 17740 | Dinah June Caroline Barton | local.winchester.2016-05-05 90 | party:63 | Green Party | DIW:E05011004 | St Michael | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 14898 | 14898 | 17741 | Janet Mary Berry | local.winchester.2016-05-05 90 | party:53 | Labour Party | DIW:E05011004 | St Michael | 2016-05-05 | 0 | 0 | PP53 | 0 |
JSON shape: default, array, newline-delimited
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))