home / democracyclub

democracyclub

Custom SQL query returning 101 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
9639 353 Tony Popham     male   29 party:20 The Molesey Residents Association DIW:E05007259 Molesey East ward   1.0                   2016-05-05 0 0   17033.0       PP20   0
9640 3455 Bernard Collignon     male   29 party:85 UK Independence Party (UKIP) DIW:E05007251 Claygate ward                       2016-05-05 0 0   17023.0       PP85   0
9641 4367 Lee Godfrey     male   29 party:53 Labour Party DIW:E05011089 Weybridge St George's Hill     http://www.labour.org.uk/people/detail/lee-godfrey http://www.leegodfrey.info/     https://static-candidates.democracyclub.org.uk/media/images/5481e82bb150e238702c05a5.png   profile-photo     2016-05-05 0 0   17173.0       PP53   0
9642 5240 Redvers Cunningham     male 1968-09-08 29 party:85 UK Independence Party (UKIP) DIW:E05007258 Long Ditton ward       http://www.spelthorneukip.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5516c1f0929f1bbe286be02d.png   profile-photo UKIPRedvers   2016-05-05 0 0   16993.0       PP85   0
9643 5243 Nicholas David Wood Dr   male   29 party:85 UK Independence Party (UKIP) DIW:E05011077 Hersham Village             https://static-candidates.democracyclub.org.uk/media/images/5526910759bbc5c063445ba5.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 0   17123.0       PP85   0
9644 5575 Xingang Wang     male   29 party:52 Conservative and Unionist Party DIW:E05007251 Claygate ward     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Wang_Xingang.aspx http://www.xingangwang.com/     https://static-candidates.democracyclub.org.uk/media/images/553b4e5e81ca637726b503a4.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/XXingang 2016-05-05 0 0           PP52   0
9645 6309 Andrew Davis     male   29 party:90 Liberal Democrats DIW:E05011088 Weybridge Riverside     http://www.libdems.org.uk/andrew_davis http://www.andrewdavis.me.uk/     https://static-candidates.democracyclub.org.uk/media/images/553c9b6be22f98bc5d30fa60.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/CllrAndrewDavis 2016-05-05 0 0   17140.0       PP90   0
9646 6680 Shweta Kapadia     female   29 party:90 Liberal Democrats DIW:E05007258 Long Ditton ward   1.0 http://www.libdems.org.uk/shweta_kapadia       https://static-candidates.democracyclub.org.uk/media/images/5540043147e19ee153d7d22b.png   profile-photo SK   2016-05-05 0 0   16996.0       PP90   0
9647 6708 Olivia Joy Palmer     Female 1986.0 29 party:63 Green Party DIW:E05011077 Hersham Village     https://surrey.greenparty.org.uk/elections.html       https://static-candidates.democracyclub.org.uk/media/images/55357026367dc5383f552cbe.png   profile-photo Olivia   2016-05-05 0 0   17120.0       PP63   0
9648 8133 Chris Elmer Mrs   female   29 party:52 Conservative and Unionist Party DIW:E05007269 Walton South ward   1.0 http://www.esherwalton.com/person/cllr-christine-elmer       https://static-candidates.democracyclub.org.uk/media/images/images/8133.png   profile-photo jmnish http://www.esherwalton.com/sites/www.esherwalton.com/files/imagecache/news_small/christineelmer_0.jpg 2016-05-05 0 0           PP52   0
9649 8134 Chris Cross     female   29 party:52 Conservative and Unionist Party DIW:E05007269 Walton South ward   1.0 http://www.esherwalton.com/person/cllr-chris-cross       https://static-candidates.democracyclub.org.uk/media/images/images/8134.png   profile-photo jmnish http://www.esherwalton.com/sites/www.esherwalton.com/files/imagecache/news_small/cllrmrscross.jpg 2016-05-05 0 0           PP52   0
9650 8135 Malcolm Forbes Howard Mr   male   29 party:52 Conservative and Unionist Party DIW:E05007269 Walton South ward   1.0 http://www.esherwalton.com/person/malcolm-howard       https://static-candidates.democracyclub.org.uk/media/images/images/8135.png   profile-photo jmnish http://www.esherwalton.com/sites/www.esherwalton.com/files/imagecache/news_small/malcolm_howard_2.jpg 2016-05-05 0 0           PP52   0
9651 14004 Ruby Robjan Ahmed         29 party:20 The Molesey Residents Association DIW:E05011081 Molesey West   1.0                   2016-05-05 0 0           PP20   0
9652 14005 Jamal Ajjane         29 party:53 Labour Party DIW:E05011081 Molesey West                       2016-05-05 0 0           PP53   0
9653 14006 Mike Axton         29 party:20 The Molesey Residents Association DIW:E05011081 Molesey West   1.0                   2016-05-05 0 0           PP20   0
9654 14007 Philippe Daniel Bassett         29 party:52 Conservative and Unionist Party DIW:E05011081 Molesey West                       2016-05-05 0 0           PP52   0
9655 14008 Richard Simon William Doxford         29 party:52 Conservative and Unionist Party DIW:E05011081 Molesey West                       2016-05-05 0 0           PP52   0
9656 14009 Vic Eldridge         29 party:20 The Molesey Residents Association DIW:E05011081 Molesey West   1.0                   2016-05-05 0 0           PP20   0
9657 14010 Paul Nagle     male   29 party:90 Liberal Democrats DIW:E05011081 Molesey West             https://static-candidates.democracyclub.org.uk/media/images/images/14010.png   profile-photo sjorford http://elmbridgelibdems.org.uk/councillors/ 2016-05-05 0 0           PP90   0
9658 14011 Inna Spektor         29 party:52 Conservative and Unionist Party DIW:E05011081 Molesey West                       2016-05-05 0 0           PP52   0
9659 16981 David John Archer         29 party:52 Conservative and Unionist Party DIW:E05007254 Esher ward                       2016-05-05 0 0           PP52   0
9660 16982 Sue Citron         29 party:59 Esher Residents Association DIW:E05007254 Esher ward                       2016-05-05 0 0           PP59   0
9661 16983 Terry Reginald Duhig         29 party:1874 Hersham Village Society DIW:E05007254 Esher ward                       2016-05-05 0 0           PP1874   0
9662 16984 Laura Jayne Harmour         29 party:63 Green Party DIW:E05007254 Esher ward     https://surrey.greenparty.org.uk/elections.html                 2016-05-05 0 0           PP63   0
9663 16985 Peter Richard Charles Heaney         29 party:59 Esher Residents Association DIW:E05007254 Esher ward                       2016-05-05 0 0           PP59   0
9664 16986 Joyce Denise Keen         29 party:59 Esher Residents Association DIW:E05007254 Esher ward                       2016-05-05 0 0           PP59   0
9665 16987 Timothy Gerald Oliver         29 party:52 Conservative and Unionist Party DIW:E05007254 Esher ward                       2016-05-05 0 0           PP52   0
9666 16988 Simon Jonathan Waugh         29 party:52 Conservative and Unionist Party DIW:E05007254 Esher ward                       2016-05-05 0 0           PP52   0
9667 16994 Barry Arthur Fairbank         29 party:90 Liberal Democrats DIW:E05007258 Long Ditton ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/16994.png   profile-photo sjorford http://elmbridgelibdems.org.uk/councillors/ 2016-05-05 0 0           PP90   0
9668 16995 Neil Houston         29 party:90 Liberal Democrats DIW:E05007258 Long Ditton ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/16995.png   profile-photo sjorford http://elmbridgelibdems.org.uk/councillors/ 2016-05-05 0 0           PP90   0
9669 16997 Jerry Mills         29 party:52 Conservative and Unionist Party DIW:E05007258 Long Ditton ward                       2016-05-05 0 0           PP52   0
9670 16998 Natasha Tara Maria Bonifacio Odone         29 party:52 Conservative and Unionist Party DIW:E05007258 Long Ditton ward                       2016-05-05 0 0           PP52   0
9671 16999 Derek Martin Williamson         29 party:52 Conservative and Unionist Party DIW:E05007258 Long Ditton ward                       2016-05-05 0 0           PP52   0
9672 17008 Jaska Alanko         29 party:90 Liberal Democrats DIW:E05007265 Thames Ditton ward                       2016-05-05 0 0           PP90   0
9673 17009 Tricia Bland         29 party:64 Thames Ditton / Weston Green Residents' Association DIW:E05007265 Thames Ditton ward   1.0                   2016-05-05 0 0           PP64   0
9674 17010 Ruth Jennifer Meirion Lyon         29 party:64 Thames Ditton / Weston Green Residents' Association DIW:E05007265 Thames Ditton ward   1.0                   2016-05-05 0 0           PP64   0
9675 17011 Joanna Karen Randolph         29 party:64 Thames Ditton / Weston Green Residents' Association DIW:E05007265 Thames Ditton ward   1.0                   2016-05-05 0 0           PP64   0
9676 17012 Andrew Reid         29 party:52 Conservative and Unionist Party DIW:E05007265 Thames Ditton ward                       2016-05-05 0 0           PP52   0
9677 17013 Mandy Sansom         29 party:52 Conservative and Unionist Party DIW:E05007265 Thames Ditton ward                       2016-05-05 0 0           PP52   0
9678 17014 Graham Edward West         29 party:52 Conservative and Unionist Party DIW:E05007265 Thames Ditton ward                       2016-05-05 0 0           PP52   0
9679 17024 Alex Coomes     male   29 party:90 Liberal Democrats DIW:E05007251 Claygate ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/17024.png   profile-photo sjorford http://elmbridgelibdems.org.uk/contact/ 2016-05-05 0 0           PP90   0
9680 17025 Kim Cross         29 party:90 Liberal Democrats DIW:E05007251 Claygate ward   1.0                   2016-05-05 0 0           PP90   0
9681 17026 Geoff Herbert         29 party:52 Conservative and Unionist Party DIW:E05007251 Claygate ward                       2016-05-05 0 0           PP52   0
9682 17027 Mary Marshall     female   29 party:90 Liberal Democrats DIW:E05007251 Claygate ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/17027.png   profile-photo sjorford http://elmbridgelibdems.org.uk/councillors/ 2016-05-05 0 0           PP90   0
9683 17028 Felix Graham Riley         29 party:53 Labour Party DIW:E05007251 Claygate ward                       2016-05-05 0 0           PP53   0
9684 17029 Mark Sugden         29 party:52 Conservative and Unionist Party DIW:E05007251 Claygate ward                       2016-05-05 0 0           PP52   0
9685 17030 Steve Bax     male   29 party:52 Conservative and Unionist Party DIW:E05007259 Molesey East ward     https://www.esherwalton.com/people/steve-bax http://moleseyconservatives.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/17030.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=104962274 2016-05-05 0 0           PP52   0
9686 17031 Trevor Gregory Marshall         29 party:85 UK Independence Party (UKIP) DIW:E05007259 Molesey East ward                       2016-05-05 0 0           PP85   0
9687 17032 Debi Oliver         29 party:52 Conservative and Unionist Party DIW:E05007259 Molesey East ward                       2016-05-05 0 0           PP52   0
9688 17034 Ivan Regan         29 party:20 The Molesey Residents Association DIW:E05007259 Molesey East ward   1.0                   2016-05-05 0 0           PP20   0
9689 17035 Stuart John Selleck         29 party:20 The Molesey Residents Association DIW:E05007259 Molesey East ward   1.0                   2016-05-05 0 0           PP20   0
9690 17036 Sarah Elizabeth Spencer-Bowdage         29 party:63 Green Party DIW:E05007259 Molesey East ward     https://surrey.greenparty.org.uk/elections.html                 2016-05-05 0 0           PP63   0
9691 17037 Surraya Sumner         29 party:53 Labour Party DIW:E05007259 Molesey East ward                       2016-05-05 0 0           PP53   0
9692 17038 Peter Jacob Szanto     male   29 party:52 Conservative and Unionist Party DIW:E05007259 Molesey East ward     https://www.esherwalton.com/people/peter-szanto                 2016-05-05 0 0           PP52   0
9693 17039 David Colin Bellchamber         29 party:90 Liberal Democrats DIW:E05007252 Cobham and Downside ward                       2016-05-05 0 0           PP90   0
9694 17040 Mike Bennison         29 party:52 Conservative and Unionist Party DIW:E05007252 Cobham and Downside ward   1.0                   2016-05-05 0 0           PP52   0
9695 17041 James William Browne         29 party:52 Conservative and Unionist Party DIW:E05007252 Cobham and Downside ward   1.0                   2016-05-05 0 0   42966.0       PP52   0
9696 17042 Lana Hylands     female   29 party:53 Labour Party DIW:E05007252 Cobham and Downside ward     https://vote.labour.org.uk/lana-hylands     https://www.linkedin.com/in/lana-hylands-58b163107/ https://static-candidates.democracyclub.org.uk/media/images/images/17042.png   profile-photo andylolz From official campaign page: https://esher-and-walton-constituency-labour-party.org.uk/elections/4th-may-2017-votelabour-lana-hylands-cobham/ 2016-05-05 0 0           PP53   0
9697 17043 Elaine Linda Kingston         29 party:85 UK Independence Party (UKIP) DIW:E05007252 Cobham and Downside ward                       2016-05-05 0 0           PP85   0
9698 17044 Dorothy Margaret Mitchell         29 party:52 Conservative and Unionist Party DIW:E05007252 Cobham and Downside ward   1.0                   2016-05-05 0 0           PP52   0
9699 17057 Richard Farquhar Atkins         29 party:85 UK Independence Party (UKIP) DIW:E05007263 Oxshott and Stoke D'Abernon ward                       2016-05-05 0 0           PP85   0
9700 17058 Philip Michael Birch         29 party:85 UK Independence Party (UKIP) DIW:E05007263 Oxshott and Stoke D'Abernon ward                       2016-05-05 0 0           PP85   0
9701 17059 Hugh David Bryant         29 party:53 Labour Party DIW:E05007263 Oxshott and Stoke D'Abernon ward                       2016-05-05 0 0           PP53   0
9702 17060 Andrew Peter Burley         29 party:52 Conservative and Unionist Party DIW:E05007263 Oxshott and Stoke D'Abernon ward   1.0                   2016-05-05 0 0           PP52   0
9703 17061 Oliver Terence Chappell         29 party:52 Conservative and Unionist Party DIW:E05007263 Oxshott and Stoke D'Abernon ward   1.0                   2016-05-05 0 0           PP52   0
9704 17062 Simon Davies         29 party:90 Liberal Democrats DIW:E05007263 Oxshott and Stoke D'Abernon ward                       2016-05-05 0 0           PP90   0
9705 17063 James Arthur Vickers         29 party:52 Conservative and Unionist Party DIW:E05007263 Oxshott and Stoke D'Abernon ward   1.0                   2016-05-05 0 0           PP52   0
9706 17071 Andrew Alistair Anderson         29 party:52 Conservative and Unionist Party DIW:E05007267 Walton Central ward                       2016-05-05 0 0           PP52   0
9707 17072 Margaret Hawkes     female   29 party:53 Labour Party DIW:E05007267 Walton Central ward             https://static-candidates.democracyclub.org.uk/media/images/images/17072.png   profile-photo sjorford http://elmbridgelibdems.org.uk/councillors/ 2016-05-05 0 0           PP53   0
9708 17073 Paul Anthony Liptrot         29 party:52 Conservative and Unionist Party DIW:E05007267 Walton Central ward                       2016-05-05 0 0           PP52   0
9709 17074 Alan Ralph Palmer         29 party:75 The Walton Society DIW:E05007267 Walton Central ward   1.0                   2016-05-05 0 0           PP75   0
9710 17075 Christine Jean Richardson         29 party:52 Conservative and Unionist Party DIW:E05007267 Walton Central ward                       2016-05-05 0 0           PP52   0
9711 17076 Chris Sadler         29 party:75 The Walton Society DIW:E05007267 Walton Central ward   1.0                   2016-05-05 0 0           PP75   0
9712 17077 Graham Leonard Woolgar         29 party:75 The Walton Society DIW:E05007267 Walton Central ward   1.0                   2016-05-05 0 0           PP75   0
9713 17078 Linda Alanko         29 party:90 Liberal Democrats DIW:E05007268 Walton North ward                       2016-05-05 0 0           PP90   0
9714 17079 David William Ions     male   29 party:85 UK Independence Party (UKIP) DIW:E05007268 Walton North ward             https://static-candidates.democracyclub.org.uk/media/images/images/17079.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP85   0
9715 17080 Andrew Christopher Kelly         29 party:52 Conservative and Unionist Party DIW:E05007268 Walton North ward   1.0                   2016-05-05 0 0           PP52   0
9716 17081 Alan Harvey Kopitko         29 party:52 Conservative and Unionist Party DIW:E05007268 Walton North ward   1.0                   2016-05-05 0 0           PP52   0
9717 17082 Rachael Isabel Lake     female   29 party:52 Conservative and Unionist Party DIW:E05007268 Walton North ward   1.0 https://www.esherwalton.com/people/cty-cllr-rachael-lake       https://static-candidates.democracyclub.org.uk/media/images/images/17082.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
9718 17083 Richard John Leonard         29 party:53 Labour Party DIW:E05007268 Walton North ward                       2016-05-05 0 0           PP53   0
9719 17095 Vera-Anne Anderson     female   29 party:53 Labour Party DIW:E05007269 Walton South ward     https://walton-and-hersham-labour-party.org.uk/walton-south-ward/     https://www.linkedin.com/in/vera-anne-anderson-5816034b https://static-candidates.democracyclub.org.uk/media/images/images/17095.png   profile-photo jmnish Publicly available by local Labour website: https://walton-and-hersham-labour-party.org.uk/walton-south-ward/ 2016-05-05 0 0           PP53   0
9720 17096 Alastair Graham Russell Sturgis         29 party:90 Liberal Democrats DIW:E05007269 Walton South ward           https://www.linkedin.com/in/alastair-sturgis-b7108784           2016-05-05 0 0           PP90   0
9721 17097 Martin George Fox         29 party:52 Conservative and Unionist Party DIW:E05011078 Hinchley Wood & Weston Green                       2016-05-05 0 0           PP52   0
9722 17098 Nigel Haig-Brown         29 party:15 Hinchley Wood Residents Association DIW:E05011078 Hinchley Wood & Weston Green   1.0                   2016-05-05 0 0           PP15   0
9723 17099 Craig David Harrison         29 party:52 Conservative and Unionist Party DIW:E05011078 Hinchley Wood & Weston Green                       2016-05-05 0 0           PP52   0
9724 17100 Charlotte Alexandra Sharman         29 party:52 Conservative and Unionist Party DIW:E05011078 Hinchley Wood & Weston Green                       2016-05-05 0 0           PP52   0
9725 17101 Tannia Shipley         29 party:15 Hinchley Wood Residents Association DIW:E05011078 Hinchley Wood & Weston Green   1.0                   2016-05-05 0 0           PP15   0
9726 17102 Janet Rita Turner         29 party:15 Hinchley Wood Residents Association DIW:E05011078 Hinchley Wood & Weston Green   1.0                   2016-05-05 0 0           PP15   0
9727 17115 Roy Green         29 party:1874 Hersham Village Society DIW:E05011077 Hersham Village   1.0                   2016-05-05 0 0           PP1874   0
9728 17116 Anne Elizabeth Hill         29 party:1874 Hersham Village Society DIW:E05011077 Hersham Village   1.0                   2016-05-05 0 0           PP1874   0
9729 17117 Peter Arthur Jepson         29 party:53 Labour Party DIW:E05011077 Hersham Village                       2016-05-05 0 0           PP53   0
9730 17118 Florence Ruth Court Mitchell         29 party:52 Conservative and Unionist Party DIW:E05011077 Hersham Village                       2016-05-05 0 0           PP52   0
9731 17119 Michael John O'Reilly         29 party:52 Conservative and Unionist Party DIW:E05011077 Hersham Village                       2016-05-05 0 0           PP52   0
9732 17121 Mary Carlisle Sheldon         29 party:52 Conservative and Unionist Party DIW:E05011077 Hersham Village   1.0                   2016-05-05 0 0           PP52   0
9733 17122 Janet Shell         29 party:90 Liberal Democrats DIW:E05011077 Hersham Village                       2016-05-05 0 0           PP90   0
9734 17139 Barbara Ann Cowin         29 party:52 Conservative and Unionist Party DIW:E05011088 Weybridge Riverside                       2016-05-05 0 0           PP52   0
9735 17141 Adriana Dredge         29 party:90 Liberal Democrats DIW:E05011088 Weybridge Riverside                       2016-05-05 0 0           PP90   0
9736 17142 Stephanie Clare Franklin         29 party:53 Labour Party DIW:E05011088 Weybridge Riverside                       2016-05-05 0 0           PP53   0
9737 17143 Michael John Freeman         29 party:52 Conservative and Unionist Party DIW:E05011088 Weybridge Riverside                       2016-05-05 0 0           PP52   0
9738 17145 Vicki Macleod         29 party:90 Liberal Democrats DIW:E05011088 Weybridge Riverside             https://static-candidates.democracyclub.org.uk/media/images/images/17145.png   profile-photo sjorford http://elmbridgelibdems.org.uk/councillors/ 2016-05-05 0 0           PP90   0
9739 17146 Andy Muddyman         29 party:52 Conservative and Unionist Party DIW:E05011088 Weybridge Riverside                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.143ms