home / democracyclub

democracyclub

Custom SQL query returning 74 rows

Query parameters

This data as JSON, CSV

rowididnamehonorific_prefixhonorific_suffixgenderbirth_dateelectionparty_idparty_namepost_idpost_labelmapit_urlelectedparty_ppc_page_urlhomepage_urlwikipedia_urllinkedin_urlimage_urlproxy_image_url_templateimage_copyrightimage_uploading_userimage_uploading_user_noteselection_dateelection_currentparty_lists_in_useparty_list_positionold_person_idsgss_codeparlparse_idtheyworkforyou_urlparty_ec_idfavourite_biscuitscancelled_poll
8986 887 Jane Kulka     female   18 party:90 Liberal Democrats DIW:E05007331 Earlswood and Whitebushes     http://reigatelibdems.org.uk/en/contact/jane-kulka       https://static-candidates.democracyclub.org.uk/media/images/images/887_68QISFj.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   18796.0       PP90   0
8987 2821 Leigh Jones     male 1958-03-20 18 party:85 UK Independence Party (UKIP) DIW:E05007340 Redhill East                       2016-05-05 0 0           PP85   0
8988 5488 Nicola Dodgson     female   18 party:63 Green Party DIW:E05007345 South Park and Woodhatch     http://rbgp.org.uk/2015/01/introducing-our-general-election-candidates/ https://nicoladodgson.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/54bf99ae5a9c3744778f9b89.png         2016-05-05 0 0           PP63   0
8989 5937 Liam Ascough     male   18 party:52 Conservative and Unionist Party DIW:E05007334 Horley West     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Ascough_Liam.aspx       https://static-candidates.democracyclub.org.uk/media/images/54cd19df668e142f73d3b4a3.png   profile-photo     2016-05-05 0 0   4812;15002       PP52   0
8990 6028 Anna Tarrant     female 1974.0 18 party:90 Liberal Democrats DIW:E05007336 Meadvale and St John's     http://www.libdems.org.uk/anna_tarrant       https://static-candidates.democracyclub.org.uk/media/images/5548add99b4dcd1028de1cc3.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/anna_tarrant 2016-05-05 0 0   18828.0       PP90   0
8991 8162 Chris Byrne         18 party:85 UK Independence Party (UKIP) DIW:E05007329 Banstead Village                       2016-05-05 0 0           PP85   0
8992 8164 Valerie Ann Moore         18 party:85 UK Independence Party (UKIP) DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP85   0
8993 8165 Steven David Alfred Russell     male   18 party:85 UK Independence Party (UKIP) DIW:E05007330 Chipstead, Hooley and Woodmansterne                       2016-05-05 0 0           PP85   0
8994 8166 Bob Cambridge         18 party:85 UK Independence Party (UKIP) DIW:E05007335 Kingswood with Burgh Heath                       2016-05-05 0 0           PP85   0
8995 8167 Phyl Cambridge         18 party:85 UK Independence Party (UKIP) DIW:E05007337 Merstham                       2016-05-05 0 0           PP85   0
8996 8168 Laurence James Clack         18 party:85 UK Independence Party (UKIP) DIW:E05007343 Reigate Hill                       2016-05-05 0 0           PP85   0
8997 8169 Tim Pearson         18 party:85 UK Independence Party (UKIP) DIW:E05007341 Redhill West                       2016-05-05 0 0           PP85   0
8998 8170 Alastair Richardson         18 party:85 UK Independence Party (UKIP) DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0   41206.0       PP85   0
8999 8171 Gerard Martin Hever         18 party:85 UK Independence Party (UKIP) DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP85   0
9000 8172 Colin Brian Stiff         18 party:85 UK Independence Party (UKIP) DIW:E05007331 Earlswood and Whitebushes                       2016-05-05 0 0           PP85   0
9001 14148 Toby Brampton     male   18 party:53 Labour Party DIW:E05007340 Redhill East     https://vote.labour.org.uk/toby-brampton       https://static-candidates.democracyclub.org.uk/media/images/images/14148_dtxOiBm.png   public-domain TobyBrampton   2016-05-05 0 0           PP53   0
9002 14151 Steve McKenna         18 party:63 Green Party DIW:E05007340 Redhill East                       2016-05-05 0 0           PP63   0
9003 14847 Mark Alan Brunt     Male 1970.0 18 party:52 Conservative and Unionist Party DIW:E05007337 Merstham       http://www.rbca.org.uk/person/mark-brunt-cllr-merstham-and-association-deputy-chairman-political     https://static-candidates.democracyclub.org.uk/media/images/images/14847.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
9004 14953 Natalie Jane Bramhall Mrs   Female   18 party:52 Conservative and Unionist Party DIW:E05007341 Redhill West                       2016-05-05 0 0           PP52   0
9005 14959 Victor William Broad Mr   Male   18 party:52 Conservative and Unionist Party DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP52   0
9006 14979 Roger Charles Newstead Mr       18 party:52 Conservative and Unionist Party DIW:E05007343 Reigate Hill                       2016-05-05 0 0           PP52   0
9007 14980 Helen Jane Foreman Mrs       18 party:52 Conservative and Unionist Party DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP52   0
9008 14986 Eddy Humphreys Mr       18 party:52 Conservative and Unionist Party DIW:E05007329 Banstead Village                       2016-05-05 0 0           PP52   0
9009 14987 James Paul King Mr       18 party:52 Conservative and Unionist Party DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0           PP52   0
9010 14988 James Edward Durrant Mr   male   18 party:52 Conservative and Unionist Party DIW:E05007331 Earlswood and Whitebushes             https://static-candidates.democracyclub.org.uk/media/images/images/14988.png   profile-photo fbrc Twitter profile pic https://twitter.com/cllr_durrant 2016-05-05 0 0           PP52   0
9011 14989 Jane Illingworth         18 party:52 Conservative and Unionist Party DIW:E05007347 Tattenhams                       2016-05-05 0 0           PP52   0
9012 14990 Ben Leslie Mr   male   18 party:52 Conservative and Unionist Party DIW:E05007340 Redhill East             https://static-candidates.democracyclub.org.uk/media/images/images/14990.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   14150.0       PP52   0
9013 14991 Stephen Thomas Bramhall Mr       18 party:52 Conservative and Unionist Party DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0           PP52   0
9014 14992 Simon John Parnall Mr       18 party:52 Conservative and Unionist Party DIW:E05007335 Kingswood with Burgh Heath                       2016-05-05 0 0           PP52   0
9015 14996 Keith Foreman Mr       18 party:52 Conservative and Unionist Party DIW:E05007330 Chipstead, Hooley and Woodmansterne                       2016-05-05 0 0           PP52   0
9016 15000 David Thomas Powell         18 party:52 Conservative and Unionist Party DIW:E05007332 Horley Central                       2016-05-05 0 0           PP52   0
9017 15001 Tony Schofield         18 party:52 Conservative and Unionist Party DIW:E05007333 Horley East                       2016-05-05 0 0           PP52   0
9018 15003 Philip Abimbola Olanipekun     male   18 party:52 Conservative and Unionist Party DIW:E05007338 Nork                       2016-05-05 0 0           PP52   0
9019 18769 James Christopher Fowler     Male   18 party:90 Liberal Democrats DIW:E05007329 Banstead Village                       2016-05-05 0 0   25001.0       PP90   0
9020 18770 Pete Kermally         18 party:53 Labour Party DIW:E05007329 Banstead Village                       2016-05-05 0 0           PP53   0
9021 18783 Evan Patrick Raymond Gregory         18 party:53 Labour Party DIW:E05007330 Chipstead, Hooley and Woodmansterne                       2016-05-05 0 0           PP53   0
9022 18795 Sue Fenton         18 party:63 Green Party DIW:E05007331 Earlswood and Whitebushes                       2016-05-05 0 0           PP63   0
9023 18797 Graham Richard Wildridge         18 party:53 Labour Party DIW:E05007331 Earlswood and Whitebushes                       2016-05-05 0 0           PP53   0
9024 18801 Linda Jane Mabbett         18 party:53 Labour Party DIW:E05007332 Horley Central                       2016-05-05 0 0           PP53   0
9025 18802 Malcolm Roger Brighting         18 party:85 UK Independence Party (UKIP) DIW:E05007332 Horley Central                       2016-05-05 0 0           PP85   0
9026 18806 Joanna Barnett         18 ynmp-party:2 Independent DIW:E05007333 Horley East                       2016-05-05 0 0           ynmp-party:2   0
9027 18818 Sarah Jane Finch         18 party:63 Green Party DIW:E05007334 Horley West                       2016-05-05 0 0           PP63   0
9028 18819 André Edward Grant         18 party:85 UK Independence Party (UKIP) DIW:E05007334 Horley West                       2016-05-05 0 0           PP85   0
9029 18820 Geoffrey Smith         18 party:53 Labour Party DIW:E05007334 Horley West                       2016-05-05 0 0           PP53   0
9030 18821 Geoff Southall     Male   18 party:90 Liberal Democrats DIW:E05007334 Horley West                       2016-05-05 0 0   25004.0       PP90   0
9031 18826 Isabella Lane         18 party:53 Labour Party DIW:E05007335 Kingswood with Burgh Heath                       2016-05-05 0 0           PP53   0
9032 18827 Malcolm Kemp Savidge         18 party:53 Labour Party DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0           PP53   0
9033 18832 Sarah Josephine Vaci         18 party:63 Green Party DIW:E05007336 Meadvale and St John's                       2016-05-05 0 0           PP63   0
9034 18837 Stewart James Dack         18 party:53 Labour Party DIW:E05007337 Merstham                       2016-05-05 0 0           PP53   0
9035 18838 Chris Howell         18 party:90 Liberal Democrats DIW:E05007337 Merstham                       2016-05-05 0 0           PP90   0
9036 18839 Kenneth Tze Ken Yau         18 party:63 Green Party DIW:E05007337 Merstham                       2016-05-05 0 0           PP63   0
9037 18840 Kimberley Marie Griffin         18 party:53 Labour Party DIW:E05007338 Nork                       2016-05-05 0 0           PP53   0
9038 18841 Jonathan Charles White         18 party:138 Nork Residents' Association DIW:E05007338 Nork                       2016-05-05 0 0           PP138   0
9039 18842 Gregory Clack         18 party:53 Labour Party DIW:E05007341 Redhill West                       2016-05-05 0 0           PP53   0
9040 18843 Andrew James Cressy         18 party:90 Liberal Democrats DIW:E05007341 Redhill West                       2016-05-05 0 0           PP90   0
9041 18844 Rob Jarrett         18 party:63 Green Party DIW:E05007341 Redhill West                       2016-05-05 0 0           PP63   0
9042 18845 Soo Abram         18 party:63 Green Party DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP63   0
9043 18846 Helen Mary Samuel         18 party:90 Liberal Democrats DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP90   0
9044 18847 Robin Spencer         18 party:53 Labour Party DIW:E05007342 Reigate Central                       2016-05-05 0 0           PP53   0
9045 18848 Christopher Thomas Henry Whinney         18 ynmp-party:2 Independent DIW:E05007342 Reigate Central                       2016-05-05 0 0           ynmp-party:2   0
9046 18849 Gregory Alec Edwin Ardan     Male   18 party:90 Liberal Democrats DIW:E05007343 Reigate Hill                       2016-05-05 0 0   25005.0       PP90   0
9047 18850 Andrew David Saunders         18 party:53 Labour Party DIW:E05007343 Reigate Hill                       2016-05-05 0 0           PP53   0
9048 18851 Moray William Macleod Carey     Male   18 party:90 Liberal Democrats DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0   25002.0       PP90   0
9049 18852 Mark Peter Collins         18 party:53 Labour Party DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0           PP53   0
9050 18854 Sonja Begley-Moore         18 party:90 Liberal Democrats DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP90   0
9051 18856 Alistair Patrick Galbraith Morten         18 party:63 Green Party DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           PP63   0
9052 18857 Margaret Caroline Deirdre Walkling         18 ynmp-party:2 Independent DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0           ynmp-party:2   0
9053 18858 Jacob David Thomas Bonner         18 party:53 Labour Party DIW:E05007347 Tattenhams                       2016-05-05 0 0           PP53   0
9054 18859 Jill Scott Bray         18 party:141 Tattenhams Residents' Association DIW:E05007347 Tattenhams                       2016-05-05 0 0           PP141   0
9055 18860 Roger Baizeley Ponsford         18 party:63 Green Party DIW:E05007347 Tattenhams     https://surrey.greenparty.org.uk/elections.html                 2016-05-05 0 0   30562.0       PP63   0
9056 25007 Stuart Holmes     Male   18 party:90 Liberal Democrats DIW:E05007340 Redhill East                       2016-05-05 0 0   14149.0       PP90   0
9057 30691 David Anthony Burnley         18 party:53 Labour Party DIW:E05007346 Tadworth and Walton                       2016-05-05 0 0   18855.0       PP53   0
9058 30697 Tom Turner         18 party:53 Labour Party DIW:E05007333 Horley East                       2016-05-05 0 0   18807.0       PP53   0
9059 40178 Joe Fox     male 1948.0 18 party:85 UK Independence Party (UKIP) DIW:E05007345 South Park and Woodhatch                       2016-05-05 0 0   3891.0       PP85   0
Powered by Datasette · Query took 0.918ms