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
13508 1452 Nick Smith Mr   male 1962-11-15 77 party:85 UK Independence Party (UKIP) DIW:E05010790 Hartsholme       http://lincolngainsboro.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/54fb5a5eac1daeda13b59edb.png   copyright-assigned NickSmithUKIP   2016-05-05 0 0           PP85   0
13509 2066 Tony Wells     male   77 party:85 UK Independence Party (UKIP) DIW:E05010785 Birchwood                       2016-05-05 0 0           PP85   0
13510 5555 Ross David Pepper     male 1986.0 77 party:90 Liberal Democrats DIW:E05010792 Moorland     http://www.lsnhlibdems.org.uk/ross_pepper http://www.lsnhlibdems.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5501a4a0551f41c939045335.png   profile-photo artesea From Facebook https://m.facebook.com/photo.php?fbid=10155273723395704&id=755900703&set=a.10150274732560704.523107.755900703&source=11 2016-05-05 0 0   17504.0       PP90   0
13511 14057 Graham Bratby         77 party:52 Conservative and Unionist Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP52   0
13512 14058 Kathleen Emma Brothwell         77 party:53 Labour Party DIW:E05010784 Abbey   1.0                   2016-05-05 0 0           PP53   0
13513 14059 Michael Edward Brown         77 party:90 Liberal Democrats DIW:E05010784 Abbey                       2016-05-05 0 0           PP90   0
13514 14060 Chris Butler         77 party:85 UK Independence Party (UKIP) DIW:E05010784 Abbey                       2016-05-05 0 0           PP85   0
13515 14061 Douglas Vincent Collison         77 party:52 Conservative and Unionist Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP52   0
13516 14062 Gavyn Graham         77 party:804 Trade Unionist and Socialist Coalition DIW:E05010784 Abbey                       2016-05-05 0 0           PP804   0
13517 14063 Jac Green         77 party:804 Trade Unionist and Socialist Coalition DIW:E05010784 Abbey                       2016-05-05 0 0           PP804   0
13518 14064 Caleb Joseph Smith Harris         77 party:52 Conservative and Unionist Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP52   0
13519 14065 Nick Parker         77 party:804 Trade Unionist and Socialist Coalition DIW:E05010784 Abbey                       2016-05-05 0 0           PP804   0
13520 14066 Clare Smalley         77 party:90 Liberal Democrats DIW:E05010784 Abbey                       2016-05-05 0 0           PP90   0
13521 14067 Fay Smith         77 party:53 Labour Party DIW:E05010784 Abbey   1.0                   2016-05-05 0 0           PP53   0
13522 14068 Peter John West         77 party:53 Labour Party DIW:E05010784 Abbey   1.0                   2016-05-05 0 0           PP53   0
13523 14069 Kenneth George Yates         77 party:63 Green Party DIW:E05010784 Abbey                       2016-05-05 0 0           PP63   0
13524 17419 Morgan Fae Aran         77 party:90 Liberal Democrats DIW:E05010785 Birchwood                       2016-05-05 0 0   25624.0       PP90   0
13525 17420 Jenine Emilie Butroid         77 party:52 Conservative and Unionist Party DIW:E05010785 Birchwood                       2016-05-05 0 0           PP52   0
13526 17421 David Denman         77 party:52 Conservative and Unionist Party DIW:E05010785 Birchwood                       2016-05-05 0 0           PP52   0
13527 17422 Paul Alan Gowen         77 joint-party:53-119 Labour and Co-operative Party DIW:E05010785 Birchwood   1.0                   2016-05-05 0 0           joint-party:53-119   0
13528 17423 Anthony John Gray         77 joint-party:53-119 Labour and Co-operative Party DIW:E05010785 Birchwood                       2016-05-05 0 0           joint-party:53-119   0
13529 17424 Rosanne Christina Kirk         77 joint-party:53-119 Labour and Co-operative Party DIW:E05010785 Birchwood   1.0                   2016-05-05 0 0           joint-party:53-119   0
13530 17425 John Anthony Radford         77 party:63 Green Party DIW:E05010785 Birchwood                       2016-05-05 0 0   45755.0       PP63   0
13531 17426 Eddie Strengiel         77 party:52 Conservative and Unionist Party DIW:E05010785 Birchwood   1.0                   2016-05-05 0 0           PP52   0
13532 17427 Elaine Elizabeth Warde         77 party:85 UK Independence Party (UKIP) DIW:E05010785 Birchwood                       2016-05-05 0 0           PP85   0
13533 17428 Alan William Briggs         77 party:52 Conservative and Unionist Party DIW:E05010786 Boultham                       2016-05-05 0 0           PP52   0
13534 17429 Gill Clayton-Hewson         77 party:53 Labour Party DIW:E05010786 Boultham   1.0                   2016-05-05 0 0           PP53   0
13535 17430 Heather Elizabeth Cullen         77 party:90 Liberal Democrats DIW:E05010786 Boultham                       2016-05-05 0 0           PP90   0
13536 17431 Ryan Thomas Cullen         77 party:90 Liberal Democrats DIW:E05010786 Boultham                       2016-05-05 0 0           PP90   0
13537 17432 Roger Joseph Hansard         77 party:52 Conservative and Unionist Party DIW:E05010786 Boultham                       2016-05-05 0 0           PP52   0
13538 17433 Gary Trevor Hewson         77 party:53 Labour Party DIW:E05010786 Boultham   1.0                   2016-05-05 0 0           PP53   0
13539 17434 Hannah Poppy Smith     female   77 party:85 UK Independence Party (UKIP) DIW:E05010786 Boultham                       2016-05-05 0 0           PP85   0
13540 17435 Ralph Toofany         77 party:53 Labour Party DIW:E05010786 Boultham   1.0                   2016-05-05 0 0           PP53   0
13541 17436 Caroline Wilson         77 party:52 Conservative and Unionist Party DIW:E05010786 Boultham                       2016-05-05 0 0           PP52   0
13542 17437 Matthew Fido     Male 1993-01-26 77 party:52 Conservative and Unionist Party DIW:E05010787 Carholme             https://static-candidates.democracyclub.org.uk/media/images/images/17437.png   profile-photo matthew4   2016-05-05 0 0           PP52   0
13543 17438 Karen Lee     female   77 party:53 Labour Party DIW:E05010787 Carholme   1.0 http://www.lincolnlabourparty.org.uk/karen-lee/   https://en.wikipedia.org/wiki/Karen_Lee_(politician)   https://static-candidates.democracyclub.org.uk/media/images/images/17438_88idLbJ.png   profile-photo nick2   2016-05-05 0 0           PP53   0
13544 17439 Ben Loryman     male   77 party:63 Green Party DIW:E05010787 Carholme     https://my.greenparty.org.uk/candidates/106046       https://static-candidates.democracyclub.org.uk/media/images/images/17439.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1165771298 2016-05-05 0 0           PP63   0
13545 17440 Neil McElhinney Murray         77 party:53 Labour Party DIW:E05010787 Carholme   1.0                   2016-05-05 0 0           PP53   0
13546 17441 Christopher Padley         77 party:63 Green Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP63   0
13547 17442 Katya Roures Salvador         77 party:52 Conservative and Unionist Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP52   0
13548 17443 Charles William Shaw         77 party:90 Liberal Democrats DIW:E05010787 Carholme                       2016-05-05 0 0           PP90   0
13549 17444 David Vincent Smith         77 party:52 Conservative and Unionist Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP52   0
13550 17445 Tony Speakman         77 party:53 Labour Party DIW:E05010787 Carholme   1.0                   2016-05-05 0 0           PP53   0
13551 17446 Nicola Watson         77 party:63 Green Party DIW:E05010787 Carholme                       2016-05-05 0 0           PP63   0
13552 17447 Rod Archer         77 party:52 Conservative and Unionist Party DIW:E05010788 Castle                       2016-05-05 0 0           PP52   0
13553 17448 Malcolm Roger Barham         77 party:52 Conservative and Unionist Party DIW:E05010788 Castle                       2016-05-05 0 0           PP52   0
13554 17449 Jim Hanrahan         77 party:53 Labour Party DIW:E05010788 Castle   1.0                   2016-05-05 0 0           PP53   0
13555 17450 Donald James Nannestad         77 party:53 Labour Party DIW:E05010788 Castle   1.0                   2016-05-05 0 0           PP53   0
13556 17451 Daphne Alexandra Shaw         77 party:90 Liberal Democrats DIW:E05010788 Castle                       2016-05-05 0 0           PP90   0
13557 17452 David Frank Warde         77 party:85 UK Independence Party (UKIP) DIW:E05010788 Castle                       2016-05-05 0 0           PP85   0
13558 17453 Loraine Karen Woolley         77 party:53 Labour Party DIW:E05010788 Castle   1.0                   2016-05-05 0 0           PP53   0
13559 17454 David Wright         77 party:52 Conservative and Unionist Party DIW:E05010788 Castle                       2016-05-05 0 0           PP52   0
13560 17455 Jamie Luke Bartch         77 party:52 Conservative and Unionist Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP52   0
13561 17456 Andrew Peter Bradley         77 party:52 Conservative and Unionist Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP52   0
13562 17457 Norman Haigh         77 party:63 Green Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP63   0
13563 17458 Adam Jacob Holman         77 party:63 Green Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP63   0
13564 17459 Jackie Lisa Kirk         77 party:53 Labour Party DIW:E05010789 Glebe   1.0                   2016-05-05 0 0           PP53   0
13565 17460 Stephen Peter Lonsdale         77 party:90 Liberal Democrats DIW:E05010789 Glebe                       2016-05-05 0 0           PP90   0
13566 17461 Keri Lowe         77 party:804 Trade Unionist and Socialist Coalition DIW:E05010789 Glebe                       2016-05-05 0 0           PP804   0
13567 17462 Fiona McKenna     female   77 party:63 Green Party DIW:E05010789 Glebe     https://my.greenparty.org.uk/candidates/106183       https://static-candidates.democracyclub.org.uk/media/images/images/17462.png   profile-photo J https://my.greenparty.org.uk/candidates/106183 2016-05-05 0 0           PP63   0
13568 17463 Peter Francis McNeill         77 party:52 Conservative and Unionist Party DIW:E05010789 Glebe                       2016-05-05 0 0           PP52   0
13569 17464 Ric Metcalfe         77 party:53 Labour Party DIW:E05010789 Glebe   1.0                   2016-05-05 0 0           PP53   0
13570 17465 Patrick Joseph Vaughan         77 party:53 Labour Party DIW:E05010789 Glebe   1.0                   2016-05-05 0 0           PP53   0
13571 17466 Biff Bean         77 party:53 Labour Party DIW:E05010790 Hartsholme   1.0                   2016-05-05 0 0           PP53   0
13572 17467 Adelle Ellis         77 party:53 Labour Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP53   0
13573 17468 David Anthony Gaskell         77 party:90 Liberal Democrats DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP90   0
13574 17469 Ron Hills         77 party:52 Conservative and Unionist Party DIW:E05010790 Hartsholme   1.0                   2016-05-05 0 0           PP52   0
13575 17470 Mervyn Keith Hobden         77 party:90 Liberal Democrats DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP90   0
13576 17471 Andy Kerry         77 party:52 Conservative and Unionist Party DIW:E05010790 Hartsholme   1.0                   2016-05-05 0 0           PP52   0
13577 17472 Liz Massey         77 party:53 Labour Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP53   0
13578 17473 Jeff McGeachie         77 party:85 UK Independence Party (UKIP) DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP85   0
13579 17474 Angela Jane Porter         77 party:63 Green Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP63   0
13580 17475 Marika Susan Riddick         77 party:52 Conservative and Unionist Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP52   0
13581 17476 Nicola Jane Smith     female   77 party:85 UK Independence Party (UKIP) DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP85   0
13582 17477 Peaceful Warrior         77 party:63 Green Party DIW:E05010790 Hartsholme                       2016-05-05 0 0           PP63   0
13583 17478 Yvonne Bodger         77 party:52 Conservative and Unionist Party DIW:E05010791 Minster   1.0                   2016-05-05 0 0           PP52   0
13584 17479 Dave Callow         77 party:53 Labour Party DIW:E05010791 Minster                       2016-05-05 0 0           PP53   0
13585 17480 James Robert Easter         77 party:90 Liberal Democrats DIW:E05010791 Minster                       2016-05-05 0 0           PP90   0
13586 17481 Tony Plato Higgs         77 party:52 Conservative and Unionist Party DIW:E05010791 Minster                       2016-05-05 0 0           PP52   0
13587 17482 Liz Maxwell         77 party:53 Labour Party DIW:E05010791 Minster   1.0                   2016-05-05 0 0           PP53   0
13588 17483 Nicole Danielle Pouncey Mrs   Female 1986-07-12 77 party:90 Liberal Democrats DIW:E05010791 Minster                       2016-05-05 0 0           PP90   0
13589 17484 Christopher Edward Reid         77 party:52 Conservative and Unionist Party DIW:E05010791 Minster                       2016-05-05 0 0           PP52   0
13590 17485 Naomi Tweddle         77 party:53 Labour Party DIW:E05010791 Minster   1.0                   2016-05-05 0 0           PP53   0
13591 17496 Bob Bushell         77 party:53 Labour Party DIW:E05010792 Moorland   1.0                   2016-05-05 0 0           PP53   0
13592 17497 Geoff Ellis         77 party:53 Labour Party DIW:E05010792 Moorland   1.0                   2016-05-05 0 0           PP53   0
13593 17498 Kevin John Harrington     male   77 party:85 UK Independence Party (UKIP) DIW:E05010792 Moorland                       2016-05-05 0 0           PP85   0
13594 17499 David Graham Kerry         77 party:52 Conservative and Unionist Party DIW:E05010792 Moorland                       2016-05-05 0 0           PP52   0
13595 17500 Sharon Dawn Longthorne         77 party:52 Conservative and Unionist Party DIW:E05010792 Moorland                       2016-05-05 0 0           PP52   0
13596 17501 Adrianna McNulty         77 party:53 Labour Party DIW:E05010792 Moorland   1.0                   2016-05-05 0 0           PP53   0
13597 17502 Vasos Stavros Melides         77 party:52 Conservative and Unionist Party DIW:E05010792 Moorland                       2016-05-05 0 0           PP52   0
13598 17503 Lynn Joan Pepper         77 party:90 Liberal Democrats DIW:E05010792 Moorland                       2016-05-05 0 0           PP90   0
13599 17510 Roly Bunce         77 party:85 UK Independence Party (UKIP) DIW:E05010793 Park                       2016-05-05 0 0           PP85   0
13600 17511 Chris Burke         77 party:53 Labour Party DIW:E05010793 Park   1.0                   2016-05-05 0 0           PP53   0
13601 17512 Sue Burke         77 party:53 Labour Party DIW:E05010793 Park   1.0                   2016-05-05 0 0           PP53   0
13602 17513 Richard David Butroid     male   77 party:52 Conservative and Unionist Party DIW:E05010793 Park                       2016-05-05 0 0   45732.0       PP52   0
13603 17514 Natasha Seeta Chapman         77 party:90 Liberal Democrats DIW:E05010793 Park                       2016-05-05 0 0           PP90   0
13604 17515 Lauren Robin Finka         77 party:63 Green Party DIW:E05010793 Park                       2016-05-05 0 0           PP63   0
13605 17516 Sally Anne Horscroft         77 party:63 Green Party DIW:E05010793 Park                       2016-05-05 0 0           PP63   0
13606 17517 Janusz Jerzy Kala         77 party:52 Conservative and Unionist Party DIW:E05010793 Park                       2016-05-05 0 0           PP52   0
13607 17518 Helena Mavis Mair         77 party:53 Labour Party DIW:E05010793 Park   1.0                   2016-05-05 0 0   30032.0       PP53   0
13608 17519 Sean Alexander Oxspring         77 party:90 Liberal Democrats DIW:E05010793 Park                       2016-05-05 0 0           PP90   0
Powered by Datasette · Query took 1.052ms