home / democracyclub

democracyclub

Custom SQL query returning 77 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
11571 198 Eddie Devoy     male 1951-02-09 48 party:2120 Yorkshire First MTW:E05000987 North East                       2016-05-05 0 0           PP2120   0
11572 5809 Kevin David Riddiough Mr   Male 1964-12-18 48 party:17 English Democrats MTW:E05000991 Rockingham     https://yorkshireenglishdemocrats.wordpress.com/short-biography/barnsley-e-kevin-riddiough/ http://opinionsofthemasses.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/551a495eb989d5e837ae99ea.png   other steve I am the English Democrats National Campaign Director 2016-05-05 0 0           PP17   0
11573 5816 Colin Porter     Male 1962-01-01 48 party:17 English Democrats MTW:E05000976 Central     https://yorkshireenglishdemocrats.wordpress.com/short-biography/penistone-s-colin-porter/       https://static-candidates.democracyclub.org.uk/media/images/551a5249fb1a251c355566c1.png   copyright-assigned steve I am the English Democrats National Campaign Director 2016-05-05 0 0   1626.0       PP17   0
11574 7015 Justin Saxton     male 1970-02-28 48 party:17 English Democrats MTW:E05000984 Hoyland Milton     https://yorkshireenglishdemocrats.wordpress.com/short-biography/sheffield-b-h-justin-saxton/       https://static-candidates.democracyclub.org.uk/media/images/551aae26e2ac8b7333e6a275.png   profile-photo steve I am the English Democrats National Campaign Director 2016-05-05 0 0           PP17   0
11575 7226 Tony Devoy     Male   48 party:2120 Yorkshire First MTW:E05000977 Cudworth       http://www.yorkshireparty.org.uk/candidates     https://static-candidates.democracyclub.org.uk/media/images/553b8f8681ca637726b503b5.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/tonydevoy 2016-05-05 0 0   209;48110       PP2120   0
11576 9524 Douglas Birkinshaw         48 party:53 Labour Party MTW:E05000976 Central   1.0                   2016-05-05 0 0           PP53   0
11577 9525 Mark James Brook         48 party:52 Conservative and Unionist Party MTW:E05000976 Central                       2016-05-05 0 0           PP52   0
11578 9526 Estelle Marie Mageean         48 party:804 Trade Unionist and Socialist Coalition MTW:E05000976 Central                       2016-05-05 0 0           PP804   0
11579 9528 Elizabeth Hill         48 party:52 Conservative and Unionist Party MTW:E05000977 Cudworth                       2016-05-05 0 0   48112.0       PP52   0
11580 9529 Stephen Geoffrey Houghton         48 party:53 Labour Party MTW:E05000977 Cudworth   1.0                   2016-05-05 0 0           PP53   0
11581 9530 Caroline Saunders         48 party:53 Labour Party MTW:E05000978 Darfield   1.0                   2016-05-05 0 0           PP53   0
11582 9531 Trevor Smith         48 party:85 UK Independence Party (UKIP) MTW:E05000978 Darfield                       2016-05-05 0 0           PP85   0
11583 9532 Delia Mary Weldon         48 party:52 Conservative and Unionist Party MTW:E05000978 Darfield                       2016-05-05 0 0           PP52   0
11584 9533 Gail Charlesworth         48 party:53 Labour Party MTW:E05000979 Darton East   1.0                   2016-05-05 0 0           PP53   0
11585 9534 Sharon Love         48 party:530 Barnsley Independent Group MTW:E05000979 Darton East                       2016-05-05 0 0           PP530   0
11586 9535 John Race         48 ynmp-party:2 Independent MTW:E05000979 Darton East                       2016-05-05 0 0           ynmp-party:2   0
11587 9536 Gordon Wilkinson         48 party:52 Conservative and Unionist Party MTW:E05000979 Darton East                       2016-05-05 0 0           PP52   0
11588 9537 Alice Cave         48 party:53 Labour Party MTW:E05000980 Darton West   1.0                   2016-05-05 0 0           PP53   0
11589 9538 Lee Ogden         48 party:52 Conservative and Unionist Party MTW:E05000980 Darton West                       2016-05-05 0 0           PP52   0
11590 9539 Peter John Murray         48 party:52 Conservative and Unionist Party MTW:E05000981 Dearne North                       2016-05-05 0 0           PP52   0
11591 9540 Pauline Ann Phillips         48 party:53 Labour Party MTW:E05000981 Dearne North   1.0                   2016-05-05 0 0           PP53   0
11592 9541 Cicely Anne Cowgill         48 party:52 Conservative and Unionist Party MTW:E05000982 Dearne South                       2016-05-05 0 0           PP52   0
11593 9542 David Peter Hunter     male   48 ynmp-party:2 Independent MTW:E05000982 Dearne South                       2016-05-05 0 0           ynmp-party:2   0
11594 9543 Charlotte Ann Johnson         48 party:53 Labour Party MTW:E05000982 Dearne South   1.0                   2016-05-05 0 0           PP53   0
11595 9544 Phillip Birkinshaw         48 party:530 Barnsley Independent Group MTW:E05000983 Dodworth   1.0                   2016-05-05 0 0           PP530   0
11596 9545 Ian David Parker     male   48 party:63 Green Party MTW:E05000983 Dodworth                       2016-05-05 0 0           PP63   0
11597 9546 David Lee Webster     male   48 party:53 Labour Party MTW:E05000983 Dodworth                       2016-05-05 0 0           PP53   0
11598 9548 Brian Caton         48 party:804 Trade Unionist and Socialist Coalition MTW:E05000984 Hoyland Milton                       2016-05-05 0 0           PP804   0
11599 9549 Louise Marie Holliday         48 party:85 UK Independence Party (UKIP) MTW:E05000984 Hoyland Milton                       2016-05-05 0 0           PP85   0
11600 9550 Andrew Simpson         48 party:2413 The Eccentric Party of Great Britain MTW:E05000984 Hoyland Milton                       2016-05-05 0 0           PP2413   0
11601 9551 James Michael Stowe         48 party:53 Labour Party MTW:E05000984 Hoyland Milton   1.0                   2016-05-05 0 0           PP53   0
11602 9552 Lesley Anne Watkinson         48 party:52 Conservative and Unionist Party MTW:E05000984 Hoyland Milton                       2016-05-05 0 0           PP52   0
11603 9553 Steven John Burkinshaw         48 party:52 Conservative and Unionist Party MTW:E05000985 Kingstone                       2016-05-05 0 0           PP52   0
11604 9554 Donna Marie Green         48 party:53 Labour Party MTW:E05000985 Kingstone   1.0                   2016-05-05 0 0           PP53   0
11605 9555 Tracey Ann Holland         48 party:804 Trade Unionist and Socialist Coalition MTW:E05000985 Kingstone                       2016-05-05 0 0           PP804   0
11606 9556 Christopher Houston         48 party:3960 British National Party MTW:E05000985 Kingstone                       2016-05-05 0 0           PP3960   0
11607 9557 Chris Scarfe         48 party:63 Green Party MTW:E05000985 Kingstone                       2016-05-05 0 0           PP63   0
11608 9558 Kirk Stuart Dyson         48 party:52 Conservative and Unionist Party MTW:E05000986 Monk Bretton                       2016-05-05 0 0           PP52   0
11609 9559 Steve Green         48 party:53 Labour Party MTW:E05000986 Monk Bretton   1.0                   2016-05-05 0 0           PP53   0
11610 9560 Sharon Louise Taylor         48 party:804 Trade Unionist and Socialist Coalition MTW:E05000986 Monk Bretton                       2016-05-05 0 0           PP804   0
11611 9561 Jeff Ennis         48 party:53 Labour Party MTW:E05000987 North East   1.0                   2016-05-05 0 0           PP53   0
11612 9562 Peter Leslie Makinson         48 party:530 Barnsley Independent Group MTW:E05000987 North East                       2016-05-05 0 0           PP530   0
11613 9563 Ian Dennis Richardson         48 party:52 Conservative and Unionist Party MTW:E05000987 North East                       2016-05-05 0 0           PP52   0
11614 9564 Phil Lofts         48 party:53 Labour Party MTW:E05000988 Old Town   1.0                   2016-05-05 0 0           PP53   0
11615 9565 Gillian Ruth Millner         48 party:52 Conservative and Unionist Party MTW:E05000988 Old Town                       2016-05-05 0 0           PP52   0
11616 9566 Louise Jane Sowerby         48 party:530 Barnsley Independent Group MTW:E05000988 Old Town                       2016-05-05 0 0           PP530   0
11617 9567 Amy Louise Walker         48 party:63 Green Party MTW:E05000988 Old Town                       2016-05-05 0 0           PP63   0
11618 9568 Jill Hayler         48 party:53 Labour Party MTW:E05000989 Penistone East                       2016-05-05 0 0           PP53   0
11619 9569 Dale Turner         48 party:63 Green Party MTW:E05000989 Penistone East                       2016-05-05 0 0           PP63   0
11620 9570 John Major Wilson         48 party:52 Conservative and Unionist Party MTW:E05000989 Penistone East   1.0                   2016-05-05 0 0           PP52   0
11621 9571 Dave Griffin         48 party:53 Labour Party MTW:E05000990 Penistone West   1.0                   2016-05-05 0 0           PP53   0
11622 9572 Mike Ogle         48 party:52 Conservative and Unionist Party MTW:E05000990 Penistone West                       2016-05-05 0 0           PP52   0
11623 9573 Richard Thomas James Trotman     male 1958.0 48 party:63 Green Party MTW:E05000990 Penistone West             https://static-candidates.democracyclub.org.uk/media/images/images/9573.png   profile-photo sjorford https://www.facebook.com/GreenPartyBarnsley/photos/rpp.717687631644082/1341824442563728/ 2016-05-05 0 0           PP63   0
11624 9574 Steve Webber         48 ynmp-party:2 Independent MTW:E05000990 Penistone West                       2016-05-05 0 0           ynmp-party:2   0
11625 9575 Emma Patricia Dures         48 party:53 Labour Party MTW:E05000991 Rockingham   1.0                   2016-05-05 0 0           PP53   0
11626 9576 Shaun Andrew Fletcher         48 party:804 Trade Unionist and Socialist Coalition MTW:E05000991 Rockingham                       2016-05-05 0 0           PP804   0
11627 9577 Steve Sylvester         48 party:85 UK Independence Party (UKIP) MTW:E05000991 Rockingham                       2016-05-05 0 0           PP85   0
11628 9578 Debbie Toon         48 party:52 Conservative and Unionist Party MTW:E05000991 Rockingham                       2016-05-05 0 0           PP52   0
11629 9579 Karen Jane Fletcher         48 party:804 Trade Unionist and Socialist Coalition MTW:E05000992 Royston                       2016-05-05 0 0           PP804   0
11630 9580 Edward Alan Gouthwaite         48 ynmp-party:2 Independent MTW:E05000992 Royston                       2016-05-05 0 0           ynmp-party:2   0
11631 9581 Caroline Makinson         48 party:53 Labour Party MTW:E05000992 Royston   1.0                   2016-05-05 0 0           PP53   0
11632 9582 Nichola Jayne Richardson         48 party:52 Conservative and Unionist Party MTW:E05000992 Royston                       2016-05-05 0 0           PP52   0
11633 9583 Wayne Johnson         48 party:53 Labour Party MTW:E05000994 Stairfoot   1.0                   2016-05-05 0 0           PP53   0
11634 9584 Clive Watkinson         48 party:52 Conservative and Unionist Party MTW:E05000994 Stairfoot             https://static-candidates.democracyclub.org.uk/media/images/images/9584.png   profile-photo sjorford http://www.barnsleyconservatives.co.uk/blog.php 2016-05-05 0 0           PP52   0
11635 9594 Jan Campbell         48 party:804 Trade Unionist and Socialist Coalition MTW:E05000993 St Helens                       2016-05-05 0 0           PP804   0
11636 9595 George Hill         48 party:52 Conservative and Unionist Party MTW:E05000993 St Helens                       2016-05-05 0 0           PP52   0
11637 9596 Jim Johnson         48 party:85 UK Independence Party (UKIP) MTW:E05000993 St Helens                       2016-05-05 0 0           PP85   0
11638 9597 Alan Jones         48 party:63 Green Party MTW:E05000993 St Helens                       2016-05-05 0 0           PP63   0
11639 9598 Sarah Jane Tattersall         48 party:53 Labour Party MTW:E05000993 St Helens   1.0                   2016-05-05 0 0           PP53   0
11640 9599 Daniel James Griffin         48 party:53 Labour Party MTW:E05000995 Wombwell   1.0                   2016-05-05 0 0           PP53   0
11641 9600 Mike Toon         48 party:52 Conservative and Unionist Party MTW:E05000995 Wombwell                       2016-05-05 0 0   35471.0       PP52   0
11642 9601 Gill Carr         48 party:530 Barnsley Independent Group MTW:E05000996 Worsbrough   1.0                   2016-05-05 0 0           PP530   0
11643 9602 Lauren Elizabeth Conway         48 party:63 Green Party MTW:E05000996 Worsbrough                       2016-05-05 0 0           PP63   0
11644 9603 Jake Michael Lodge         48 party:53 Labour Party MTW:E05000996 Worsbrough                       2016-05-05 0 0           PP53   0
11645 9604 Stuart Nicholas Wilkinson         48 party:52 Conservative and Unionist Party MTW:E05000996 Worsbrough                       2016-05-05 0 0           PP52   0
11646 46420 Kate Raynor     female   48 party:63 Green Party MTW:E05000976 Central             https://static-candidates.democracyclub.org.uk/media/images/images/46420.png   profile-photo sjorford https://twitter.com/barnsley_greens/status/595917897718996992 2016-05-05 0 0   9527.0       PP63   0
11647 47650 Alex Wilkinson         48 party:52 Conservative and Unionist Party MTW:E05000983 Dodworth                       2016-05-05 0 0   9547.0       PP52   0
Powered by Datasette · Query took 0.925ms