home / democracyclub

democracyclub

Custom SQL query returning 84 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
13622 6071 Mark Hollinrake     male 1963-12-24 78 party:63 Green Party MTW:E05000746 Kingsway       https://www.greenparty.org.uk     https://static-candidates.democracyclub.org.uk/media/images/5506fbe35399523471f7e19e.png   profile-photo markhollinrake   2016-05-05 0 0           PP63   0
13623 11154 Ed Aadahl         78 party:85 UK Independence Party (UKIP) MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP85   0
13624 11155 John Hartley         78 party:53 Labour Party MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP53   0
13625 11156 Robert James McLean         78 party:52 Conservative and Unionist Party MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP52   0
13626 11157 AJ Rennie         78 party:63 Green Party MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP63   0
13627 11158 John Leo Swarbrick         78 party:90 Liberal Democrats MTW:E05000747 Littleborough Lakeside                       2016-05-05 0 0           PP90   0
13628 12458 Will Candlin         78 party:85 UK Independence Party (UKIP) MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP85   0
13629 12459 Edward Carpenter         78 party:52 Conservative and Unionist Party MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP52   0
13630 12460 Richard George Farnell         78 party:53 Labour Party MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP53   0
13631 12461 James Martin O'Meara         78 party:63 Green Party MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP63   0
13632 12462 Liz Thirsk         78 party:90 Liberal Democrats MTW:E05000739 Balderstone and Kirkholt                       2016-05-05 0 0           PP90   0
13633 12477 Mohammad Arshad         78 party:53 Labour Party MTW:E05000740 Bamford                       2016-05-05 0 0           PP53   0
13634 12478 Peter Clegg         78 party:90 Liberal Democrats MTW:E05000740 Bamford                       2016-05-05 0 0           PP90   0
13635 12479 Sarah Louise Croke         78 party:63 Green Party MTW:E05000740 Bamford                       2016-05-05 0 0           PP63   0
13636 12480 Michael John Foster         78 party:85 UK Independence Party (UKIP) MTW:E05000740 Bamford                       2016-05-05 0 0           PP85   0
13637 12481 Jane Elizabeth Ann Howard     female   78 party:52 Conservative and Unionist Party MTW:E05000740 Bamford             https://static-candidates.democracyclub.org.uk/media/images/images/12481.png   profile-photo yanbad13257   2016-05-05 0 0           PP52   0
13638 12482 Jonathan Edward Kershaw         78 party:63 Green Party MTW:E05000741 Castleton                       2016-05-05 0 0           PP63   0
13639 12483 Stephen Sanderson         78 party:85 UK Independence Party (UKIP) MTW:E05000741 Castleton                       2016-05-05 0 0           PP85   0
13640 12484 Billy Sheerin         78 party:53 Labour Party MTW:E05000741 Castleton                       2016-05-05 0 0           PP53   0
13641 12485 Karen Winkler         78 party:52 Conservative and Unionist Party MTW:E05000741 Castleton                       2016-05-05 0 0           PP52   0
13642 12502 Iftikhar Ahmed         78 party:53 Labour Party MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP53   0
13643 12503 David Vincent Fenwick-Finn         78 party:804 Trade Unionist and Socialist Coalition MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP804   0
13644 12504 Roger Howarth         78 party:52 Conservative and Unionist Party MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP52   0
13645 12505 Andy Littlewood     male   78 ynmp-party:2 Independent MTW:E05000742 Central Rochdale             https://static-candidates.democracyclub.org.uk/media/images/images/12505_QN5XFQY.png   copyright-assigned andy16   2016-05-05 0 0           ynmp-party:2   0
13646 12506 Rifat Mahmood         78 party:90 Liberal Democrats MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP90   0
13647 12507 Neil Gavin Rutter         78 party:63 Green Party MTW:E05000742 Central Rochdale                       2016-05-05 0 0           PP63   0
13648 12508 Malcolm Boriss         78 party:53 Labour Party MTW:E05000743 East Middleton                       2016-05-05 0 0           PP53   0
13649 12509 Rebecca Daisy Ann Howard         78 party:52 Conservative and Unionist Party MTW:E05000743 East Middleton                       2016-05-05 0 0           PP52   0
13650 12510 Robert Mudd         78 party:85 UK Independence Party (UKIP) MTW:E05000743 East Middleton                       2016-05-05 0 0           PP85   0
13651 12524 Thomas Benedict Butterworth         78 party:63 Green Party MTW:E05000744 Healey                       2016-05-05 0 0           PP63   0
13652 12525 Maureen Kershaw         78 party:85 UK Independence Party (UKIP) MTW:E05000744 Healey                       2016-05-05 0 0           PP85   0
13653 12526 Andrew Neilson         78 party:52 Conservative and Unionist Party MTW:E05000744 Healey                       2016-05-05 0 0           PP52   0
13654 12527 Shaun O'Neill         78 party:53 Labour Party MTW:E05000744 Healey                       2016-05-05 0 0           PP53   0
13655 12528 John Robert Rodgers         78 party:90 Liberal Democrats MTW:E05000744 Healey                       2016-05-05 0 0           PP90   0
13656 12633 Paul Simon Ellison         78 party:52 Conservative and Unionist Party MTW:E05000745 Hopwood Hall                       2016-05-05 0 0   45534.0       PP52   0
13657 12634 Angela Christine Gardner         78 party:85 UK Independence Party (UKIP) MTW:E05000745 Hopwood Hall                       2016-05-05 0 0           PP85   0
13658 12635 Linda Robinson         78 party:53 Labour Party MTW:E05000745 Hopwood Hall                       2016-05-05 0 0           PP53   0
13659 12636 Shakil Ahmed         78 party:53 Labour Party MTW:E05000746 Kingsway                       2016-05-05 0 0           PP53   0
13660 12637 David John Clayton         78 party:90 Liberal Democrats MTW:E05000746 Kingsway                       2016-05-05 0 0           PP90   0
13661 12638 Richard James Duckworth         78 party:52 Conservative and Unionist Party MTW:E05000746 Kingsway                       2016-05-05 0 0           PP52   0
13662 12639 Allen John Brett         78 party:53 Labour Party MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP53   0
13663 12640 Angela Coric         78 party:90 Liberal Democrats MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP90   0
13664 12641 Jacqueline Elaine Holt         78 party:52 Conservative and Unionist Party MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP52   0
13665 12642 Abdus Sami Mir         78 party:63 Green Party MTW:E05000748 Milkstone and Deeplish                       2016-05-05 0 0           PP63   0
13666 12643 Alan James Ashworth         78 party:63 Green Party MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP63   0
13667 12644 Irene Elizabeth Davidson         78 party:90 Liberal Democrats MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP90   0
13668 12645 Duncan Hannant         78 party:53 Labour Party MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP53   0
13669 12646 Michael O'Brien         78 party:85 UK Independence Party (UKIP) MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0   46833.0       PP85   0
13670 12647 Ahmed Orakzai         78 party:52 Conservative and Unionist Party MTW:E05000749 Milnrow and Newhey                       2016-05-05 0 0           PP52   0
13671 12660 Susan June Campbell         78 party:63 Green Party MTW:E05000750 Norden                       2016-05-05 0 0           PP63   0
13672 12661 James Travis Gartside         78 party:52 Conservative and Unionist Party MTW:E05000750 Norden                       2016-05-05 0 0           PP52   0
13673 12662 Dobir Miah         78 party:53 Labour Party MTW:E05000750 Norden                       2016-05-05 0 0           PP53   0
13674 12663 Stephen Mitchell         78 party:85 UK Independence Party (UKIP) MTW:E05000750 Norden                       2016-05-05 0 0           PP85   0
13675 12664 Keith Swift         78 party:90 Liberal Democrats MTW:E05000750 Norden                       2016-05-05 0 0           PP90   0
13676 12665 Derrick Drysdale         78 party:90 Liberal Democrats MTW:E05000751 North Heywood                       2016-05-05 0 0           PP90   0
13677 12666 Liam Joseph O'Rourke         78 party:53 Labour Party MTW:E05000751 North Heywood                       2016-05-05 0 0           PP53   0
13678 12667 Anne Shorrock         78 party:52 Conservative and Unionist Party MTW:E05000751 North Heywood                       2016-05-05 0 0           PP52   0
13679 12668 John Kershaw         78 party:52 Conservative and Unionist Party MTW:E05000752 North Middleton                       2016-05-05 0 0           PP52   0
13680 12669 Donna Maria Williams         78 party:53 Labour Party MTW:E05000752 North Middleton                       2016-05-05 0 0           PP53   0
13681 12670 Dave Winder         78 party:85 UK Independence Party (UKIP) MTW:E05000752 North Middleton                       2016-05-05 0 0           PP85   0
13682 12671 Leonard Keith Branton         78 party:52 Conservative and Unionist Party MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP52   0
13683 12672 Kitt Budd         78 party:90 Liberal Democrats MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP90   0
13684 12673 Amna Mir         78 party:53 Labour Party MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP53   0
13685 12674 Neville Westerman         78 party:85 UK Independence Party (UKIP) MTW:E05000753 Smallbridge and Firgrove                       2016-05-05 0 0           PP85   0
13686 12680 Bernard Thomas Braiden         78 party:52 Conservative and Unionist Party MTW:E05000754 South Middleton                       2016-05-05 0 0           PP52   0
13687 12681 Peter Cloran         78 party:63 Green Party MTW:E05000754 South Middleton                       2016-05-05 0 0           PP63   0
13688 12682 Peter Joinson         78 party:53 Labour Party MTW:E05000754 South Middleton                       2016-05-05 0 0           PP53   0
13689 12683 Richard John Whitaker         78 party:85 UK Independence Party (UKIP) MTW:E05000754 South Middleton                       2016-05-05 0 0           PP85   0
13690 12684 John Britton Wilkins         78 party:90 Liberal Democrats MTW:E05000754 South Middleton                       2016-05-05 0 0           PP90   0
13691 12688 Matthew Allen         78 party:90 Liberal Democrats MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP90   0
13692 12689 Mick Coats         78 party:63 Green Party MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP63   0
13693 12690 Wendy Ann Cocks         78 party:53 Labour Party MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP53   0
13694 12691 Carl Faulkner Mr   Male   78 ynmp-party:2 Independent MTW:E05000755 Spotland and Falinge       http://spotlandindependen.wixsite.com/sind               2016-05-05 0 0           ynmp-party:2   0
13695 12692 Steven Scholes         78 party:52 Conservative and Unionist Party MTW:E05000755 Spotland and Falinge                       2016-05-05 0 0           PP52   0
13696 12698 Stefan Cholewka         78 joint-party:53-119 Labour and Co-operative Party MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           joint-party:53-119   0
13697 12699 Cathie Cox         78 party:85 UK Independence Party (UKIP) MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           PP85   0
13698 12700 Ashley Howard Dearnley         78 party:52 Conservative and Unionist Party MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           PP52   0
13699 12701 Joe Kelly         78 party:90 Liberal Democrats MTW:E05000756 Wardle and West Littleborough                       2016-05-05 0 0           PP90   0
13700 12702 Peter Malcolm         78 party:53 Labour Party MTW:E05000757 West Heywood                       2016-05-05 0 0           PP53   0
13701 12704 Keith Taylor         78 party:52 Conservative and Unionist Party MTW:E05000757 West Heywood                       2016-05-05 0 0           PP52   0
13702 12705 Rachel Christine McLachlan         78 party:52 Conservative and Unionist Party MTW:E05000758 West Middleton                       2016-05-05 0 0   46829.0       PP52   0
13703 12706 Warren Mitchell         78 party:85 UK Independence Party (UKIP) MTW:E05000758 West Middleton                       2016-05-05 0 0           PP85   0
13704 12707 Susan Smith         78 party:53 Labour Party MTW:E05000758 West Middleton                       2016-05-05 0 0           PP53   0
13705 34688 Lee Seville         78 party:85 UK Independence Party (UKIP) MTW:E05000757 West Heywood                       2016-05-05 0 0   12703.0       PP85   0
Powered by Datasette · Query took 0.984ms