home / democracyclub

democracyclub

Custom SQL query returning 98 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
13078 4106 Chris Took Mr   Male 1980-05-13 72 party:90 Liberal Democrats DIW:E05010804 St John's     http://www.libdems.org.uk/chris_took     https://www.linkedin.com/in/christook https://static-candidates.democracyclub.org.uk/media/images/5481e980b150e238702c0676.png   profile-photo     2016-05-05 0 0   24632.0       PP90   0
13079 5078 Ann-Marie Barker     Female 1966-03-10 72 party:90 Liberal Democrats DIW:E05010797 Goldsworth Park   1.0 https://wokinglibdems.org.uk/en/contact/cllr-ann-marie-barker       https://static-candidates.democracyclub.org.uk/media/images/553b8e66e6d2cbcd26e36a2d.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/AnnMarie4SHeath 2016-05-05 0 0   13474;24642       PP90   0
13080 13429 John Edwin Bond     Male   72 ynmp-party:2 Independent DIW:E05010795 Byfleet & West Byfleet   1.0                   2016-05-05 0 0   23937.0       ynmp-party:2   0
13081 13430 Amanda Jayne Boote Miss BA (hons), FCIM, Dip. M, MMRS, MIDM Female 1967.0 72 ynmp-party:2 Independent DIW:E05010795 Byfleet & West Byfleet   1.0       https://www.linkedin.com/in/amanda-boote-3665363/ https://static-candidates.democracyclub.org.uk/media/images/images/13430.png   public-domain AmandaJayneB It is my own personal photograph 2016-05-05 0 0           ynmp-party:2 Stroop Waffle 0
13082 13431 Mary Ann Bridgeman         72 ynmp-party:2 Independent DIW:E05010795 Byfleet & West Byfleet   1.0                   2016-05-05 0 0           ynmp-party:2   0
13083 13432 Gary William Elson     male   72 party:52 Conservative and Unionist Party DIW:E05010795 Byfleet & West Byfleet             https://static-candidates.democracyclub.org.uk/media/images/images/13432.png   profile-photo sjorford https://www.wokingconservatives.org.uk/byfleets 2016-05-05 0 0           PP52   0
13084 13433 Andy Grimshaw         72 party:90 Liberal Democrats DIW:E05010795 Byfleet & West Byfleet                       2016-05-05 0 0           PP90   0
13085 13434 Pauline Mary Hedges         72 party:52 Conservative and Unionist Party DIW:E05010795 Byfleet & West Byfleet                       2016-05-05 0 0           PP52   0
13086 13435 Karon Jane Read         72 party:90 Liberal Democrats DIW:E05010795 Byfleet & West Byfleet                       2016-05-05 0 0           PP90   0
13087 13436 Anne Elizabeth Roberts     Female   72 party:90 Liberal Democrats DIW:E05010795 Byfleet & West Byfleet     https://wokinglibdems.org.uk/en/contact/anne-roberts                 2016-05-05 0 0           PP90   0
13088 13437 Neil James Willetts         72 party:85 UK Independence Party (UKIP) DIW:E05010795 Byfleet & West Byfleet                       2016-05-05 0 0           PP85   0
13089 13438 Richard Arthur Gillard Wilson         72 party:52 Conservative and Unionist Party DIW:E05010795 Byfleet & West Byfleet                       2016-05-05 0 0           PP52   0
13090 13443 Mohammad Ali         72 party:53 Labour Party DIW:E05010796 Canalside   1.0                   2016-05-05 0 0           PP53   0
13091 13444 Tahir Aziz         72 party:53 Labour Party DIW:E05010796 Canalside   1.0                   2016-05-05 0 0           PP53   0
13092 13445 Gareth Davies         72 party:90 Liberal Democrats DIW:E05010796 Canalside                       2016-05-05 0 0           PP90   0
13093 13446 Topher Dykes         72 party:63 Green Party DIW:E05010796 Canalside                       2016-05-05 0 0           PP63   0
13094 13447 Norman Grenville Johns         72 party:90 Liberal Democrats DIW:E05010796 Canalside                       2016-05-05 0 0           PP90   0
13095 13448 Paula Jane Marcus         72 party:52 Conservative and Unionist Party DIW:E05010796 Canalside                       2016-05-05 0 0           PP52   0
13096 13449 Matt Provost         72 party:52 Conservative and Unionist Party DIW:E05010796 Canalside                       2016-05-05 0 0           PP52   0
13097 13450 Mohammad Ilyas Raja         72 party:53 Labour Party DIW:E05010796 Canalside   1.0                   2016-05-05 0 0           PP53   0
13098 13451 David Simon Roe         72 party:85 UK Independence Party (UKIP) DIW:E05010796 Canalside                       2016-05-05 0 0           PP85   0
13099 13452 Colin Patrick Scott         72 party:52 Conservative and Unionist Party DIW:E05010796 Canalside                       2016-05-05 0 0           PP52   0
13100 13453 Judith Diana Squire         72 party:85 UK Independence Party (UKIP) DIW:E05010796 Canalside                       2016-05-05 0 0   42928.0       PP85   0
13101 13454 Rebecca Elisabeth Whale         72 party:90 Liberal Democrats DIW:E05010796 Canalside                       2016-05-05 0 0           PP90   0
13102 13473 Laura Ashall         72 party:52 Conservative and Unionist Party DIW:E05010797 Goldsworth Park                       2016-05-05 0 0           PP52   0
13103 13475 Eve Catherine Carnall         72 party:63 Green Party DIW:E05010797 Goldsworth Park                       2016-05-05 0 0           PP63   0
13104 13476 Troy De Leon     male 1961.0 72 party:85 UK Independence Party (UKIP) DIW:E05010797 Goldsworth Park           https://www.linkedin.com/in/troy-de-leon-68b78289/ https://static-candidates.democracyclub.org.uk/media/images/images/13476.png   profile-photo Edward From LinkedIn 2016-05-05 0 0           PP85   0
13105 13477 Ian Eastwood         72 party:90 Liberal Democrats DIW:E05010797 Goldsworth Park   1.0                   2016-05-05 0 0           PP90   0
13106 13478 William Eric Owen         72 party:53 Labour Party DIW:E05010797 Goldsworth Park                       2016-05-05 0 0           PP53   0
13107 13479 Chitra Rana         72 party:52 Conservative and Unionist Party DIW:E05010797 Goldsworth Park   1.0                   2016-05-05 0 0           PP52   0
13108 13480 James Richard Sanderson         72 party:90 Liberal Democrats DIW:E05010797 Goldsworth Park                       2016-05-05 0 0           PP90   0
13109 13481 John Scott-Morgan         72 party:53 Labour Party DIW:E05010797 Goldsworth Park                       2016-05-05 0 0           PP53   0
13110 13482 Rizwan Shah         72 party:52 Conservative and Unionist Party DIW:E05010797 Goldsworth Park                       2016-05-05 0 0           PP52   0
13111 13483 Robina Shaheen         72 party:53 Labour Party DIW:E05010797 Goldsworth Park                       2016-05-05 0 0           PP53   0
13112 13488 Ayesha Azad     Female   72 party:52 Conservative and Unionist Party DIW:E05010798 Heathlands   1.0 https://www.wokingconservatives.org.uk/person/ayesha-azad     https://www.linkedin.com/in/cllr-ayesha-azad-1675b95b/           2016-05-05 0 0           PP52   0
13113 13489 Kevin Mark Davis         72 party:52 Conservative and Unionist Party DIW:E05010798 Heathlands   1.0                   2016-05-05 0 0           PP52   0
13114 13490 Margaret Marion Hill         72 party:90 Liberal Democrats DIW:E05010798 Heathlands                       2016-05-05 0 0           PP90   0
13115 13491 Henry David Kay     Male   72 party:90 Liberal Democrats DIW:E05010798 Heathlands     https://wokinglibdems.org.uk/en/contact/henry-kay       https://static-candidates.democracyclub.org.uk/media/images/images/13491.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   24653.0       PP90   0
13116 13492 John Kingsbury         72 party:52 Conservative and Unionist Party DIW:E05010798 Heathlands   1.0                   2016-05-05 0 0           PP52   0
13117 13493 John Martin         72 party:53 Labour Party DIW:E05010798 Heathlands                       2016-05-05 0 0           PP53   0
13118 13494 Alison Jane Sanderson         72 party:90 Liberal Democrats DIW:E05010798 Heathlands                       2016-05-05 0 0           PP90   0
13119 13495 Richard Peter Farr Squire         72 party:85 UK Independence Party (UKIP) DIW:E05010798 Heathlands                       2016-05-05 0 0           PP85   0
13120 13496 Anna Katharine Wright         72 party:63 Green Party DIW:E05010798 Heathlands                       2016-05-05 0 0           PP63   0
13121 13558 Natalie Bourne         72 party:52 Conservative and Unionist Party DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP52   0
13122 13559 Frances Louise Carpenter         72 party:53 Labour Party DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP53   0
13123 13560 Will Forster     Male   72 party:90 Liberal Democrats DIW:E05010799 Hoe Valley   1.0 https://wokinglibdems.org.uk/en/contact/cllr-william-forster       https://static-candidates.democracyclub.org.uk/media/images/images/13560.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   24626.0       PP90   0
13124 13561 Deborah Elizabeth Hughes     female   72 party:90 Liberal Democrats DIW:E05010799 Hoe Valley   1.0                   2016-05-05 0 0           PP90   0
13125 13562 Nigel Peter Jackson         72 party:53 Labour Party DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP53   0
13126 13563 John Frederick Lawrence         72 party:52 Conservative and Unionist Party DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP52   0
13127 13564 Christopher David Martin         72 party:53 Labour Party DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP53   0
13128 13565 Louise Mary Nell Morales         72 party:90 Liberal Democrats DIW:E05010799 Hoe Valley   1.0                   2016-05-05 0 0           PP90   0
13129 13566 Bob Shatwell         72 party:85 UK Independence Party (UKIP) DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP85   0
13130 13567 Daryl Martin Smith         72 party:52 Conservative and Unionist Party DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP52   0
13131 13577 Colin Robert Bright         72 party:53 Labour Party DIW:E05010800 Horsell                       2016-05-05 0 0           PP53   0
13132 13578 Lucy Rhodes Dykes         72 party:63 Green Party DIW:E05010800 Horsell                       2016-05-05 0 0           PP63   0
13133 13579 Elizabeth Anne Evans         72 party:53 Labour Party DIW:E05010800 Horsell                       2016-05-05 0 0           PP53   0
13134 13580 Stephen Anthony Herbert         72 party:85 UK Independence Party (UKIP) DIW:E05010800 Horsell                       2016-05-05 0 0           PP85   0
13135 13581 Beryl Ann Hunwicks         72 party:52 Conservative and Unionist Party DIW:E05010800 Horsell   1.0                   2016-05-05 0 0           PP52   0
13136 13582 Rosemary Peta Johnson         72 party:90 Liberal Democrats DIW:E05010800 Horsell                       2016-05-05 0 0           PP90   0
13137 13583 Colin Sidney Kemp         72 party:52 Conservative and Unionist Party DIW:E05010800 Horsell   1.0                   2016-05-05 0 0           PP52   0
13138 13584 Tony Kremer         72 party:90 Liberal Democrats DIW:E05010800 Horsell                       2016-05-05 0 0           PP90   0
13139 13585 Anne Elizabeth Murray         72 party:52 Conservative and Unionist Party DIW:E05010800 Horsell   1.0                   2016-05-05 0 0           PP52   0
13140 13586 Samuel David Watts         72 party:90 Liberal Democrats DIW:E05010800 Horsell                       2016-05-05 0 0           PP90   0
13141 13587 Tom Willis         72 party:53 Labour Party DIW:E05010800 Horsell                       2016-05-05 0 0           PP53   0
13142 13588 David Geoffrey Barker         72 party:90 Liberal Democrats DIW:E05007448 Knaphill ward                       2016-05-05 0 0           PP90   0
13143 13589 James William Brierley     Male   72 party:63 Green Party DIW:E05007448 Knaphill ward     https://my.greenparty.org.uk/candidates/106301 http://www.wokinggreens.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/13589.png   profile-photo Jparkin   2016-05-05 0 0           PP63   0
13144 13590 Vanessa Ellicott         72 party:90 Liberal Democrats DIW:E05007448 Knaphill ward                       2016-05-05 0 0           PP90   0
13145 13591 Peter Ford         72 party:53 Labour Party DIW:E05007448 Knaphill ward                       2016-05-05 0 0           PP53   0
13146 13592 Debbie Harlow         72 party:52 Conservative and Unionist Party DIW:E05007448 Knaphill ward   1.0                   2016-05-05 0 0           PP52   0
13147 13593 Saj Hussain         72 party:52 Conservative and Unionist Party DIW:E05007448 Knaphill ward   1.0                   2016-05-05 0 0           PP52   0
13148 13594 Syed Waqar Haider Jaffri         72 party:90 Liberal Democrats DIW:E05007448 Knaphill ward                       2016-05-05 0 0           PP90   0
13149 13595 Terry Knight         72 party:85 UK Independence Party (UKIP) DIW:E05007448 Knaphill ward                       2016-05-05 0 0           PP85   0
13150 13596 Melanie Anne Whitehand         72 party:52 Conservative and Unionist Party DIW:E05007448 Knaphill ward   1.0                   2016-05-05 0 0           PP52   0
13151 13597 David John Bittleston         72 party:52 Conservative and Unionist Party DIW:E05010802 Mount Hermon   1.0                   2016-05-05 0 0           PP52   0
13152 13598 Ian Johnson         72 party:90 Liberal Democrats DIW:E05010802 Mount Hermon   1.0                   2016-05-05 0 0           PP90   0
13153 13599 Liam Lyons     male   72 party:90 Liberal Democrats DIW:E05010802 Mount Hermon     https://wokinglibdems.org.uk/en/contact/liam-lyons       https://static-candidates.democracyclub.org.uk/media/images/images/13599.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=298827215 2016-05-05 0 0   24661.0       PP90   0
13154 13600 John Robert George Parkin         72 party:63 Green Party DIW:E05010802 Mount Hermon                       2016-05-05 0 0           PP63   0
13155 13601 Mark Russell John Pengelly         72 party:52 Conservative and Unionist Party DIW:E05010802 Mount Hermon   1.0                   2016-05-05 0 0           PP52   0
13156 13602 Lyn Sage         72 party:85 UK Independence Party (UKIP) DIW:E05010802 Mount Hermon                       2016-05-05 0 0   43178.0       PP85   0
13157 13603 Carl William Thomson         72 party:52 Conservative and Unionist Party DIW:E05010802 Mount Hermon                       2016-05-05 0 0           PP52   0
13158 13604 Sinclair Aubrey Webster         72 party:90 Liberal Democrats DIW:E05010802 Mount Hermon                       2016-05-05 0 0           PP90   0
13159 13612 Ashley Christian Lawrence Bowes         72 party:52 Conservative and Unionist Party DIW:E05007454 Pyrford ward   1.0                   2016-05-05 0 0           PP52   0
13160 13613 Graham Gray Chrystie         72 party:52 Conservative and Unionist Party DIW:E05007454 Pyrford ward   1.0                   2016-05-05 0 0           PP52   0
13161 13614 Guy Tuson Cosnahan         72 party:90 Liberal Democrats DIW:E05007454 Pyrford ward                       2016-05-05 0 0           PP90   0
13162 13615 Ian Michael Lachowicz         72 party:90 Liberal Democrats DIW:E05007454 Pyrford ward                       2016-05-05 0 0           PP90   0
13163 13616 Robin Deller Milner         72 party:85 UK Independence Party (UKIP) DIW:E05007454 Pyrford ward                       2016-05-05 0 0           PP85   0
13164 13617 Rashid Mohammed         72 party:52 Conservative and Unionist Party DIW:E05007454 Pyrford ward   1.0                   2016-05-05 0 0           PP52   0
13165 13618 Richard Peter John Sanderson         72 party:90 Liberal Democrats DIW:E05007454 Pyrford ward                       2016-05-05 0 0           PP90   0
13166 13619 David Williams         72 party:53 Labour Party DIW:E05007454 Pyrford ward                       2016-05-05 0 0           PP53   0
13167 13620 Misbah Zahid         72 party:53 Labour Party DIW:E05007454 Pyrford ward                       2016-05-05 0 0           PP53   0
13168 13621 Hilary Jane Addison         72 party:52 Conservative and Unionist Party DIW:E05010804 St John's   1.0                   2016-05-05 0 0           PP52   0
13169 13622 Graham Stephen Cundy         72 party:52 Conservative and Unionist Party DIW:E05010804 St John's   1.0                   2016-05-05 0 0           PP52   0
13170 13623 Ken Howard         72 party:90 Liberal Democrats DIW:E05010804 St John's   1.0   http://wokinglibdems.org.uk/en/contact/cllr-ken-howard               2016-05-05 0 0           PP90   0
13171 13624 Tina Liddington         72 party:90 Liberal Democrats DIW:E05010804 St John's       http://wokinglibdems.org.uk/en/contact/tina-liddington               2016-05-05 0 0           PP90   0
13172 13625 Tim Read         72 party:85 UK Independence Party (UKIP) DIW:E05010804 St John's                       2016-05-05 0 0           PP85   0
13173 13626 Paul Graham Smith         72 party:52 Conservative and Unionist Party DIW:E05010804 St John's                       2016-05-05 0 0           PP52   0
13174 13627 Joel Benjamin Street         72 party:63 Green Party DIW:E05010804 St John's                       2016-05-05 0 0           PP63   0
13175 19090 Jim Gore         72 party:85 UK Independence Party (UKIP) DIW:E05010799 Hoe Valley                       2016-05-05 0 0           PP85   0
Powered by Datasette · Query took 1.087ms