home / democracyclub

democracyclub

Custom SQL query returning 101 rows

Query parameters

rowididnamehonorific_prefixhonorific_suffixgenderbirth_dateelectionparty_idparty_namepost_idmapit_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
15262 24 Lynn Worthington     female   97 party:804 Trade Unionist and Socialist Coalition MTW:E05000689             https://static-candidates.democracyclub.org.uk/media/images/55055676071d4f1362bc8035.png       2016-05-05 0 0           PP804   0
15263 1554 John Leech Cllr.   male 1971-04-11 97 party:90 Liberal Democrats MTW:E05000700       http://www.johnleech.org.uk/ https://en.wikipedia.org/wiki/John_Leech_%28politician%29   https://static-candidates.democracyclub.org.uk/media/images/images/1554.png   johnleechmcr   2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/11707 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/11707 PP90 Lily O'Brien's Uglies Cocoa Cookie 0
15264 1843 Robert Gutfreund-Walmsley     male   97 party:85 UK Independence Party (UKIP) MTW:E05000700                     2016-05-05 0 0           PP85   0
15265 3406 Mark Breeze     male 1984.0 97 ynmp-party:2 Independent MTW:E05000707             https://static-candidates.democracyclub.org.uk/media/images/images/3406.png     Auto imported from Twitter 2016-05-05 0 0   7440;14210       ynmp-party:2   0
15266 4385 Amina Lone Miss   female   97 party:53 Labour Party MTW:E05000706     http://www.labour.org.uk/people/detail/amina-lone       https://static-candidates.democracyclub.org.uk/media/images/550c34d83be3632f3135c9f0.png   tfgg   2016-05-05 0 0           PP53   0
15267 4635 Laura Bannister     female 1985-08-30 97 party:63 Green Party MTW:E05000701     https://my.greenparty.org.uk/candidates/106062 http://www.manchestergreenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5548767a3c0ead4826d59186.png   andylolz From local party PPC page: http://www.manchestergreenparty.org.uk/people/ 2016-05-05 0 0   14189.0       PP63   0
15268 4636 Lucy Bannister Ms   female 1993-08-23 97 party:63 Green Party MTW:E05000717     http://www.manchestergreenparty.org.uk/people/       https://static-candidates.democracyclub.org.uk/media/images/550bf03336b6dcb123cb4331.png   lucy It is my picture as the candidate. Picture was taken by George King and all rights go to him. I give full permission to this to be displayed on this website. 2016-05-05 0 0   14481.0       PP63   0
15269 4829 Fiona Green     female   97 party:52 Conservative and Unionist Party MTW:E05000712     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Green_Fiona.aspx https://www.wseconservatives.com     https://static-candidates.democracyclub.org.uk/media/images/5481e78fb150e238702c0543.png       2016-05-05 0 0   14779.0       PP52   0
15270 5469 Dave Page     male   97 party:90 Liberal Democrats MTW:E05000711     http://www.libdems.org.uk/dave_page http://davepage.me.uk/     https://static-candidates.democracyclub.org.uk/media/images/553b8ec981ca637726b503af.png   edent This is the candidate’s twitter profile image, from https://twitter.com/davepage_mcr 2016-05-05 0 0           PP90   0
15271 5534 Robert Manning     male   97 party:52 Conservative and Unionist Party MTW:E05000699     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Manning_Robert.aspx       https://static-candidates.democracyclub.org.uk/media/images/54cd199a668e142f73d3b492.png       2016-05-05 0 0   14419.0       PP52   0
15272 5975 Martin Power     Male 1967-07-02 97 party:85 UK Independence Party (UKIP) MTW:E05000705             https://static-candidates.democracyclub.org.uk/media/images/54edde4708de75df104c6b62.png       2016-05-05 0 0           PP85   0
15273 6223 Phil Eckersley Mr   male   97 party:85 UK Independence Party (UKIP) MTW:E05000711     https://www.crowdpac.co.uk/campaigns/1818/phil-eckersley https://www.ukipmanchester.com     https://static-candidates.democracyclub.org.uk/media/images/images/6223_Bxim3Ab.png   kdcm87 phileckersley assigned the copyright to Democracy Club Limited phileckersley's justification for use of this photo was: “The old photo is dated, this photo is current” 2016-05-05 0 0           PP85 Chocolate hobnobs 0
15274 6225 Richard Kilpatrick     male   97 party:90 Liberal Democrats MTW:E05000709             https://static-candidates.democracyclub.org.uk/media/images/553b9d45a8c0192f732ca8c2.png   edent This is the candidate’s twitter profile image, from https://twitter.com/RichKilpatrick1 2016-05-05 0 0   14757.0       PP90   0
15275 6458 Mark Davies     male   97 party:85 UK Independence Party (UKIP) MTW:E05000699       http://markdaviesukip.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/6458.png   duncanparkes Displayed at http://www.myukip.com/parliamentary-candidates-l-o.html. Image URL: http://www.myukip.com/uploads/2/1/5/3/21536724/1426695125.png 2016-05-05 0 0   46078.0       PP85   0
15276 6755 Johnny Disco     male 1980.0 97 party:66 Official Monster Raving Loony Party MTW:E05000712             https://static-candidates.democracyclub.org.uk/media/images/images/6755.png   hugovk From the party's website https://www.loonyparty.com/1018/5912/disco-for-gorton 2016-05-05 0 0   24941.0       PP66   0
15277 6823 Anne Power     female   97 party:63 Green Party MTW:E05000705     https://northlancs.greenparty.org.uk/news/2015/04/08/anne-power-%E2%80%93-general-election-candidate-for-wyre-and-preston-north-2015/       https://static-candidates.democracyclub.org.uk/media/images/554879467779865b25b01bf7.png   andylolz From party PPC page: https://my.greenparty.org.uk/candidates/106311 2016-05-05 0 0   14749.0       PP63   0
15278 8193 Lord Cameron of Roundwood         97 party:66 Official Monster Raving Loony Party MTW:E05000689                     2016-05-05 0 0           PP66   0
15279 8194 Sir Oink A-Lot     male   97 party:66 Official Monster Raving Loony Party MTW:E05000715             https://static-candidates.democracyclub.org.uk/media/images/images/8194.png   siroinkalot this is from my personal page on facebook 2016-05-05 0 0   46005.0       PP66   0
15280 10243 Mary Candeland     Female   97 party:63 Green Party MTW:E05000704                     2016-05-05 0 0           PP63   0
15281 10244 Emma Clark     female   97 party:804 Trade Unionist and Socialist Coalition MTW:E05000704                     2016-05-05 0 0           PP804   0
15282 10245 Mandy Michelle Howard     female   97 party:85 UK Independence Party (UKIP) MTW:E05000704                     2016-05-05 0 0           PP85   0
15283 10247 Richard Charles Leese Sir   male 1951-04-21 97 party:53 Labour Party MTW:E05000698         https://en.wikipedia.org/wiki/Richard_Leese   https://static-candidates.democracyclub.org.uk/media/images/images/10247.png   rob2 Photo taken from Local Government Executive website http://www.localgovernmentexecutive.co.uk/roundtable/directly-elected-mayors - his picture is in the public domain 2016-05-05 0 0           PP53   0
15284 10248 Patrick Charles Karney     male   97 party:53 Labour Party MTW:E05000704             https://static-candidates.democracyclub.org.uk/media/images/images/10248.png   rob2 this his his twitter picture 2016-05-05 0 0           PP53   0
15285 10250 Rodney Isherwood     male   97 party:90 Liberal Democrats MTW:E05000704                     2016-05-05 0 0           PP90   0
15286 10251 Alexandru Stelian Stancu     male   97 party:52 Conservative and Unionist Party MTW:E05000704                     2016-05-05 0 0           PP52   0
15287 10252 Iain Colin Donaldson     male   97 party:90 Liberal Democrats MTW:E05000698             https://static-candidates.democracyclub.org.uk/media/images/images/10252.png   rob2 uploaded from a Liberal Democrat page http://southlincslibdems.org.uk/en/article/2015/1132462/communty-politics-putting-people-first - Iain Donaldson is a former Manchester City Councillor 2016-05-05 0 0           PP90   0
15288 12714 Ken Dobson         97 ynmp-party:2 Independent MTW:E05000687             https://static-candidates.democracyclub.org.uk/media/images/images/12714.png   rob2 https://www.facebook.com/kenny.dobson.12?fref=ts 2016-05-05 0 0           ynmp-party:2   0
15289 12715 Denis Kostyan     Male   97 party:52 Conservative and Unionist Party MTW:E05000687           https://www.linkedin.com/in/denis-kostyan-56a02277 https://static-candidates.democracyclub.org.uk/media/images/images/12715.png   rob2 It is the same photograph as the election material when he stood last time in Moss Side - https://pbs.twimg.com/media/CDrUvSPWAAA94ey.jpg 2016-05-05 0 0           PP52   0
15290 12716 Ollie Manco         97 party:53 Labour Party MTW:E05000687     http://www.manchester.gov.uk/councillors/270/ollie_manco     https://www.linkedin.com/in/olivermanco https://static-candidates.democracyclub.org.uk/media/images/images/12716.png   rob2 This is from his facebook page 2016-05-05 0 0           PP53   0
15291 12717 Steffeny McGiffen         97 party:63 Green Party MTW:E05000687             https://static-candidates.democracyclub.org.uk/media/images/images/12717.png   rob2 this is from her facebook page - https://www.facebook.com/photo.php?fbid=10153038940761560&set=a.430509801559.229436.680261559&type=3&theater 2016-05-05 0 0           PP63   0
15292 12718 Chris Wilkinson         97 party:90 Liberal Democrats MTW:E05000687                     2016-05-05 0 0   45352.0       PP90   0
15293 12722 Akbar Ali Arif         97 party:52 Conservative and Unionist Party MTW:E05000688             https://static-candidates.democracyclub.org.uk/media/images/images/12722.png   rob2 https://www.facebook.com/akbar.arif 2016-05-05 0 0           PP52   0
15294 12723 Charles Richard George Gadsen         97 party:90 Liberal Democrats MTW:E05000688                     2016-05-05 0 0           PP90   0
15295 12724 Tarjuah Tina Hewitson         97 party:53 Labour Party MTW:E05000688                     2016-05-05 0 0   46062.0       PP53   0
15296 12725 Kara Ng         97 party:63 Green Party MTW:E05000688                     2016-05-05 0 0           PP63   0
15297 12726 John Neill         97 party:804 Trade Unionist and Socialist Coalition MTW:E05000688                     2016-05-05 0 0           PP804   0
15298 13843 Hannah Jane Gee     female   97 party:90 Liberal Democrats MTW:E05000706             https://static-candidates.democracyclub.org.uk/media/images/images/13843_nRg2OaZ.png   mattl From Twitter acct: https://twitter.com/hannahgee87 (current democlub photo seems to be the wrong person) 2016-05-05 0 0           PP90   0
15299 13844 Deyika Nzeribe         97 party:63 Green Party MTW:E05000706                     2016-05-05 0 0           PP63   0
15300 13845 Kevin Gerard O'Neill         97 party:52 Conservative and Unionist Party MTW:E05000706                     2016-05-05 0 0           PP52   0
15301 13846 Martin Shaw         97 party:804 Trade Unionist and Socialist Coalition MTW:E05000706                     2016-05-05 0 0           PP804   0
15302 14188 Zahra Alijah     female   97 party:53 Labour Party MTW:E05000701             https://static-candidates.democracyclub.org.uk/media/images/images/14188.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=213395556 2016-05-05 0 0           PP53   0
15303 14190 Luke Aidan Dyks         97 party:52 Conservative and Unionist Party MTW:E05000701                     2016-05-05 0 0           PP52   0
15304 14191 Christopher Jones         97 party:90 Liberal Democrats MTW:E05000701                     2016-05-05 0 0           PP90   0
15305 14192 Aidan Ryan Matthews         97 party:804 Trade Unionist and Socialist Coalition MTW:E05000701                     2016-05-05 0 0           PP804   0
15306 14193 Aden Hassan     male   97 party:52 Conservative and Unionist Party MTW:E05000710                     2016-05-05 0 0           PP52   0
15307 14194 Annie Jackson         97 party:90 Liberal Democrats MTW:E05000710                     2016-05-05 0 0           PP90   0
15308 14195 Muhammad Anwar Shahzad         97 party:63 Green Party MTW:E05000710                     2016-05-05 0 0           PP63   0
15309 14196 Mahadi Hussein Sharif Mahamed     male   97 party:53 Labour Party MTW:E05000710                     2016-05-05 0 0           PP53   0
15310 14208 Liaqat Ali         97 party:90 Liberal Democrats MTW:E05000707                     2016-05-05 0 0           PP90   0
15311 14209 Nasrin Bibi Ali     female   97 party:53 Labour Party MTW:E05000707             https://static-candidates.democracyclub.org.uk/media/images/images/14209.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=910414424 2016-05-05 0 0           PP53   0
15312 14211 Calum Tudur James Davies     male   97 party:52 Conservative and Unionist Party MTW:E05000707           https://www.linkedin.com/in/calum-davies-370b25138/         2016-05-05 0 0           PP52   0
15313 14212 Joe Mcardle         97 party:804 Trade Unionist and Socialist Coalition MTW:E05000707                     2016-05-05 0 0           PP804   0
15314 14213 Dick Venes     Male 1950-08-20 97 party:63 Green Party MTW:E05000707                     2016-05-05 0 0   47374.0       PP63   0
15315 14256 Ahmed Ali     male   97 party:53 Labour Party MTW:E05000714             https://static-candidates.democracyclub.org.uk/media/images/images/14256.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=548787601 2016-05-05 0 0           PP53   0
15316 14257 Abu Mohiuddin Chowdhury         97 party:90 Liberal Democrats MTW:E05000714                     2016-05-05 0 0           PP90   0
15317 14258 Archie Stuart Galbraith         97 party:52 Conservative and Unionist Party MTW:E05000714                     2016-05-05 0 0           PP52   0
15318 14259 Rob Jones         97 party:63 Green Party MTW:E05000714                     2016-05-05 0 0           PP63   0
15319 14401 John Bridges     male   97 party:90 Liberal Democrats MTW:E05000697       https://johnbridges.mycouncillor.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/14401.png   frankstaiger https://johnbridges.mycouncillor.org.uk 2016-05-05 0 0           PP90   0
15320 14402 Joan Elizabeth Davies         97 party:53 Labour Party MTW:E05000697                     2016-05-05 0 0           PP53   0
15321 14403 Paul Wan         97 party:52 Conservative and Unionist Party MTW:E05000697                     2016-05-05 0 0           PP52   0
15322 14417 Dominic Hardwick     male   97 party:90 Liberal Democrats MTW:E05000699     http://www.libdems.org.uk/dominic_hardwick       https://static-candidates.democracyclub.org.uk/media/images/images/14417.png   sjorford http://www.libdems.org.uk/dominic_hardwick 2016-05-05 0 0           PP90   0
15323 14418 Wendy Ann Lynas         97 party:63 Green Party MTW:E05000699                     2016-05-05 0 0           PP63   0
15324 14420 Kelly Suzanne Simcock     female   97 party:53 Labour Party MTW:E05000699             https://static-candidates.democracyclub.org.uk/media/images/images/14420.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=4099475055 2016-05-05 0 0           PP53   0
15325 14472 Max Dowling         97 party:52 Conservative and Unionist Party MTW:E05000700                     2016-05-05 0 0           PP52   0
15326 14473 Barnaby Edward Lane         97 party:53 Labour Party MTW:E05000700                     2016-05-05 0 0           PP53   0
15327 14474 Arnold James Spencer         97 party:63 Green Party MTW:E05000700                     2016-05-05 0 0           PP63   0
15328 14475 Mercedes Caccia Mesorio         97 party:804 Trade Unionist and Socialist Coalition MTW:E05000708                     2016-05-05 0 0           PP804   0
15329 14476 Timothy Charles Crump         97 party:90 Liberal Democrats MTW:E05000708                     2016-05-05 0 0           PP90   0
15330 14477 Anjenarra Huque         97 party:52 Conservative and Unionist Party MTW:E05000708                     2016-05-05 0 0           PP52   0
15331 14478 Raees Ahmad Khan         97 ynmp-party:2 Independent MTW:E05000708                     2016-05-05 0 0           ynmp-party:2   0
15332 14479 Vicky Matthews         97 party:63 Green Party MTW:E05000708                     2016-05-05 0 0           PP63   0
15333 14480 Luthfur Rahman     male   97 party:53 Labour Party MTW:E05000708             https://static-candidates.democracyclub.org.uk/media/images/images/14480.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=974822455 2016-05-05 0 0           PP53   0
15334 14482 Zoë Brunswick         97 party:804 Trade Unionist and Socialist Coalition MTW:E05000717                     2016-05-05 0 0           PP804   0
15335 14483 Shaden Jaradat     male   97 party:52 Conservative and Unionist Party MTW:E05000717     https://www.manchesterconservatives.com/people/shaden-jaradat       https://static-candidates.democracyclub.org.uk/media/images/images/14483.png   sjorford https://www.manchesterconservatives.com/people/shaden-jaradat 2016-05-05 0 0           PP52   0
15336 14484 Simon David Wheale         97 party:90 Liberal Democrats MTW:E05000717     http://www.johnleech.org.uk/simon_wheale       https://static-candidates.democracyclub.org.uk/media/images/images/14484.png     Auto imported from Twitter 2016-05-05 0 0           PP90   0
15337 14485 Chris Wills     male   97 joint-party:53-119 Labour and Co-operative Party MTW:E05000717             https://static-candidates.democracyclub.org.uk/media/images/images/14485.png     Auto imported from Twitter 2016-05-05 0 0   39606.0       joint-party:53-119   0
15338 14486 Luke Oisin Bourke Costello         97 party:52 Conservative and Unionist Party MTW:E05000696                     2016-05-05 0 0           PP52   0
15339 14487 Norman Lewis         97 party:90 Liberal Democrats MTW:E05000696     http://www.johnleech.org.uk/normanlewis       https://static-candidates.democracyclub.org.uk/media/images/images/14487.png     Auto imported from Twitter 2016-05-05 0 0           PP90   0
15340 14488 Joanna Rachel Midgley     female   97 party:53 Labour Party MTW:E05000696             https://static-candidates.democracyclub.org.uk/media/images/images/14488.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=221353177 2016-05-05 0 0           PP53   0
15341 14489 Hannah Lisa Richmond         97 party:63 Green Party MTW:E05000696                     2016-05-05 0 0           PP63   0
15342 14490 Katie Elizabeth Fanning         97 party:85 UK Independence Party (UKIP) MTW:E05000702                     2016-05-05 0 0           PP85   0
15343 14491 Andrew Peter Hickey         97 party:90 Liberal Democrats MTW:E05000702                     2016-05-05 0 0           PP90   0
15344 14492 Afia Begum Kamal         97 party:53 Labour Party MTW:E05000702                     2016-05-05 0 0           PP53   0
15345 14493 Phelim Rowe         97 party:52 Conservative and Unionist Party MTW:E05000702                     2016-05-05 0 0           PP52   0
15346 14494 Karl Wardlaw     male   97 party:63 Green Party MTW:E05000702     https://stockport.greenparty.org.uk/local-candidates/karl-wardlaw.html       https://static-candidates.democracyclub.org.uk/media/images/images/14494.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=19685424 2016-05-05 0 0           PP63   0
15347 14495 Sarah Louise Brown     Female 1984.0 97 party:90 Liberal Democrats MTW:E05000703     http://www.libdems.org.uk/sarah_brown       https://static-candidates.democracyclub.org.uk/media/images/images/14495.png   sjorford http://www.libdems.org.uk/sarah_brown 2016-05-05 0 0           PP90   0
15348 14496 Martin Burke         97 ynmp-party:2 Independent MTW:E05000703                     2016-05-05 0 0           ynmp-party:2   0
15349 14497 Bob Catterall         97 party:85 UK Independence Party (UKIP) MTW:E05000703                     2016-05-05 0 0           PP85   0
15350 14498 Melvyn Newton         97 party:63 Green Party MTW:E05000703                     2016-05-05 0 0           PP63   0
15351 14499 Tmo Opesan         97 party:52 Conservative and Unionist Party MTW:E05000703                     2016-05-05 0 0           PP52   0
15352 14500 Bernard Eric Stone     male   97 party:53 Labour Party MTW:E05000703             https://static-candidates.democracyclub.org.uk/media/images/images/14500.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=20765119 2016-05-05 0 0   43553.0       PP53   0
15353 14503 Rhona Eva Elizabeth Cowan Brown         97 party:90 Liberal Democrats MTW:E05000716                     2016-05-05 0 0           PP90   0
15354 14504 Liam David Curless         97 party:804 Trade Unionist and Socialist Coalition MTW:E05000716                     2016-05-05 0 0           PP804   0
15355 14505 Ben Godfrey         97 party:63 Green Party MTW:E05000716                     2016-05-05 0 0           PP63   0
15356 14506 David Robert Semple     male   97 party:52 Conservative and Unionist Party MTW:E05000716             https://static-candidates.democracyclub.org.uk/media/images/images/14506.png     Auto imported from Twitter 2016-05-05 0 0           PP52   0
15357 14507 Angeliki Stogia     female   97 party:53 Labour Party MTW:E05000716             https://static-candidates.democracyclub.org.uk/media/images/images/14507.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=20104698 2016-05-05 0 0           PP53   0
15358 14524 Ralph John Ellerton         97 party:52 Conservative and Unionist Party MTW:E05000689                     2016-05-05 0 0           PP52   0
15359 14525 Bonnie Mercer         97 party:63 Green Party MTW:E05000689                     2016-05-05 0 0           PP63   0
15360 14526 Luke John Raikes     male   97 party:53 Labour Party MTW:E05000689             https://static-candidates.democracyclub.org.uk/media/images/images/14526.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=21235602 2016-05-05 0 0           PP53   0
15361 14527 Phil Stubbs         97 party:90 Liberal Democrats MTW:E05000689                     2016-05-05 0 0   44021.0       PP90   0
15362 14537 Michael Charles Barnes         97 party:52 Conservative and Unionist Party MTW:E05000690                     2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 1.177ms