home / democracyclub

democracyclub

Custom SQL query returning 94 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
12926 882 Alex Williams     male   68 party:52 Conservative and Unionist Party MTW:E05000819   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/882.png     Auto imported from Twitter 2016-05-05 0 0           PP52   0
12927 1432 Jane Brophy Cllr   female 1963.0 68 party:90 Liberal Democrats MTW:E05000837   1.0 http://www.libdems.org.uk/jane_brophy http://www.janebrophy.com/   http://uk.linkedin.com/pub/jane-brophy/24/911/b17/en https://static-candidates.democracyclub.org.uk/media/images/images/1432.png     Auto imported from Twitter 2016-05-05 0 0   13757;19707       PP90   0
12928 1434 Tom Ross     male   68 party:53 Labour Party MTW:E05000836   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/1434.png     Auto imported from Twitter 2016-05-05 0 0   13754.0       PP53   0
12929 4579 James Wright     male   68 party:53 Labour Party MTW:E05000824   1.0   http://wright4asw.org/     https://static-candidates.democracyclub.org.uk/media/images/553bafc3ec0766d3759c0459.png   edent This is the candidate’s twitter profile image, from https://twitter.com/wright4asw 2016-05-05 0 0           PP53   0
12930 4639 Geraldine Coggins     female 1975-10-01 68 party:63 Green Party MTW:E05000838     https://my.greenparty.org.uk/candidates/105786 https://trafford.greenparty.org.uk     https://static-candidates.democracyclub.org.uk/media/images/550bf92d4aa4fdc23cc90904.png   geraldine I am the candidate and happy for you to use it. It is on my Facebook profile https://www.facebook.com/GeraldineCogginsGreen and Twitter https://twitter.com/CogginsGeraldin 2016-05-05 0 0   13761.0       PP63   0
12931 5060 Nick Robertson-Brown     male   68 party:63 Green Party MTW:E05000834     https://my.greenparty.org.uk/candidates/105786     http://uk.linkedin.com/pub/nick-robertson-brown/72/786/5b9/en https://static-candidates.democracyclub.org.uk/media/images/54b82f9a7089b96b50247a29.png       2016-05-05 0 0   13751.0       PP63   0
12932 5422 Jess Mayo     female 1981.0 68 party:63 Green Party MTW:E05000825     https://manchestergreenparty.org.uk/jess-mayo-for-manchester.html http://www.manchestergreenparty.org.uk     https://static-candidates.democracyclub.org.uk/media/images/54c6a6b3808848fe5d74a611.png       2016-05-05 0 0           PP63   0
12933 7900 Owain Sutton     Male 1980-06-18 68 party:63 Green Party MTW:E05000822                     2016-05-05 0 0           PP63   0
12934 10410 Julian Newgrosh         68 party:90 Liberal Democrats MTW:E05000819                     2016-05-05 0 0           PP90   0
12935 10411 Amy Marie Whyte         68 party:53 Labour Party MTW:E05000819             https://static-candidates.democracyclub.org.uk/media/images/images/10411.png     Auto imported from Twitter 2016-05-05 0 0           PP53   0
12936 10414 Ben Hartley     male   68 party:53 Labour Party MTW:E05000820             https://static-candidates.democracyclub.org.uk/media/images/images/10414.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=302594496 2016-05-05 0 0           PP53   0
12937 10415 Chris Marritt         68 party:90 Liberal Democrats MTW:E05000820                     2016-05-05 0 0           PP90   0
12938 10416 Brian Rigby         68 party:52 Conservative and Unionist Party MTW:E05000820   1.0                 2016-05-05 0 0           PP52   0
12939 10417 Caroline Robertson-Brown         68 party:63 Green Party MTW:E05000820                     2016-05-05 0 0           PP63   0
12940 10418 Sean Anstee     male   68 party:52 Conservative and Unionist Party MTW:E05000821   1.0   http://www.seananstee.com/   https://uk.linkedin.com/in/sean-anstee-b7792574 https://static-candidates.democracyclub.org.uk/media/images/images/10418.png   J https://twitter.com/seananstee 2016-05-05 0 0           PP52   0
12941 10419 Kirstie Davidson         68 party:90 Liberal Democrats MTW:E05000821                     2016-05-05 0 0           PP90   0
12942 10420 Charlie Mayer         68 party:53 Labour Party MTW:E05000821                     2016-05-05 0 0           PP53   0
12943 10421 Daniel Wadsworth         68 party:63 Green Party MTW:E05000821                     2016-05-05 0 0           PP63   0
12944 10422 Pauline Cliff         68 party:90 Liberal Democrats MTW:E05000822                     2016-05-05 0 0           PP90   0
12945 10423 Stephen John Farndon Mr.       68 ynmp-party:2 Independent MTW:E05000822                     2016-05-05 0 0           ynmp-party:2   0
12946 10424 Neil Ferguson         68 party:52 Conservative and Unionist Party MTW:E05000822                     2016-05-05 0 0           PP52   0
12947 10425 Denise Western         68 party:53 Labour Party MTW:E05000822   1.0                 2016-05-05 0 0           PP53   0
12948 10426 Chris Boyes         68 party:52 Conservative and Unionist Party MTW:E05000823   1.0                 2016-05-05 0 0           PP52   0
12949 10427 Serena Carr         68 party:53 Labour Party MTW:E05000823                     2016-05-05 0 0           PP53   0
12950 10428 Meenakshi Minnis         68 party:90 Liberal Democrats MTW:E05000823                     2016-05-05 0 0           PP90   0
12951 10429 Joe Ryan         68 party:63 Green Party MTW:E05000823             https://static-candidates.democracyclub.org.uk/media/images/images/10429.png   sjorford https://trafford.greenparty.org.uk/local-elections.html 2016-05-05 0 0           PP63   0
12952 10445 Thea Johnson         68 party:63 Green Party MTW:E05000824                     2016-05-05 0 0           PP63   0
12953 10446 Steve Jones         68 party:85 UK Independence Party (UKIP) MTW:E05000824                     2016-05-05 0 0           PP85   0
12954 10447 Graham Rogers         68 party:90 Liberal Democrats MTW:E05000824                     2016-05-05 0 0           PP90   0
12955 10448 Tony Rudden         68 ynmp-party:2 Independent MTW:E05000824                     2016-05-05 0 0           ynmp-party:2   0
12956 10449 Geoff Turner         68 party:52 Conservative and Unionist Party MTW:E05000824                     2016-05-05 0 0           PP52   0
12957 10450 Alex Finney         68 party:52 Conservative and Unionist Party MTW:E05000825                     2016-05-05 0 0           PP52   0
12958 10451 Whit Stennett         68 party:53 Labour Party MTW:E05000825   1.0                 2016-05-05 0 0           PP53   0
12959 10452 Simon Wright         68 party:90 Liberal Democrats MTW:E05000825                     2016-05-05 0 0           PP90   0
12960 10461 Linda Blackburn         68 party:52 Conservative and Unionist Party MTW:E05000826   1.0                 2016-05-05 0 0           PP52   0
12961 10462 Jayne Dillon     female   68 party:53 Labour Party MTW:E05000826                     2016-05-05 0 0           PP53   0
12962 10463 David Kierman         68 party:90 Liberal Democrats MTW:E05000826                     2016-05-05 0 0           PP90   0
12963 10464 Ian Royle         68 party:85 UK Independence Party (UKIP) MTW:E05000826                     2016-05-05 0 0           PP85   0
12964 10465 Steven Tennant         68 party:63 Green Party MTW:E05000826                     2016-05-05 0 0           PP63   0
12965 11196 Louise Claire Bird         68 party:90 Liberal Democrats MTW:E05000834       http://www.traffordlibdems.org.uk/             2016-05-05 0 0           PP90   0
12966 13712 Sally Carr Ms MBE Female   68 party:53 Labour Party MTW:E05000827     http://www.womensequality.org.uk/sallyge       https://static-candidates.democracyclub.org.uk/media/images/images/13712_7W7rEDA.png   SarahG   2016-05-05 0 0           PP53   0
12967 13713 James Adam Eisen         68 party:90 Liberal Democrats MTW:E05000827                     2016-05-05 0 0           PP90   0
12968 13714 Paul John Regan         68 party:85 UK Independence Party (UKIP) MTW:E05000827                     2016-05-05 0 0           PP85   0
12969 13715 Paul Barry Syrett         68 party:63 Green Party MTW:E05000827                     2016-05-05 0 0           PP63   0
12970 13716 Brian Shaw         68 party:52 Conservative and Unionist Party MTW:E05000827   1.0                 2016-05-05 0 0           PP52   0
12971 13717 Mike Bayley-Sanderson     male   68 party:85 UK Independence Party (UKIP) MTW:E05000828           https://www.linkedin.com/in/mike-bayley-sanderson-42173a3a https://static-candidates.democracyclub.org.uk/media/images/images/13717.png   hugovk Cropped header photo from Twitter: https://twitter.com/mikebs1966 2016-05-05 0 0           PP85   0
12972 13718 Paul Michael David Lally         68 party:52 Conservative and Unionist Party MTW:E05000828   1.0                 2016-05-05 0 0           PP52   0
12973 13719 David Harold Martin         68 party:90 Liberal Democrats MTW:E05000828                     2016-05-05 0 0           PP90   0
12974 13720 Christine Bridget Theresa McLaughlin         68 party:63 Green Party MTW:E05000828                     2016-05-05 0 0           PP63   0
12975 13721 Simon Garfield Thomas         68 party:53 Labour Party MTW:E05000828                     2016-05-05 0 0           PP53   0
12976 13722 Lijo John         68 party:52 Conservative and Unionist Party MTW:E05000829                     2016-05-05 0 0           PP52   0
12977 13723 Simon Lepori Mr   Male 1981-03-07 68 party:90 Liberal Democrats MTW:E05000829             https://static-candidates.democracyclub.org.uk/media/images/images/13723.png   sjorford https://www.facebook.com/photo.php?fbid=101873096921380&set=a.101873120254711.1073741826.100012960691780&type=3&theater 2016-05-05 0 0           PP90   0
12978 13724 Pauline Brenda Royle         68 party:85 UK Independence Party (UKIP) MTW:E05000829                     2016-05-05 0 0           PP85   0
12979 13725 Jennie Patricia Wadsworth         68 party:63 Green Party MTW:E05000829                     2016-05-05 0 0           PP63   0
12980 13726 Laurence James Walsh         68 party:53 Labour Party MTW:E05000829   1.0                 2016-05-05 0 0           PP53   0
12981 13727 Richard Martin Elliott         68 party:90 Liberal Democrats MTW:E05000830                     2016-05-05 0 0           PP90   0
12982 13728 Deborah Jean Leftwich         68 party:63 Green Party MTW:E05000830                     2016-05-05 0 0           PP63   0
12983 13729 Patrick John Myers         68 party:52 Conservative and Unionist Party MTW:E05000830   1.0                 2016-05-05 0 0           PP52   0
12984 13730 Barbara Ruth Twiney         68 joint-party:53-119 Labour and Co-operative Party MTW:E05000830                     2016-05-05 0 0           joint-party:53-119   0
12985 13731 Giulio Tiziano Forcolin         68 party:63 Green Party MTW:E05000831                     2016-05-05 0 0           PP63   0
12986 13732 Denise Louise Haddad     female 1960.0 68 party:52 Conservative and Unionist Party MTW:E05000831   1.0                 2016-05-05 0 0           PP52   0
12987 13733 Beverley Jill Harrison         68 joint-party:53-119 Labour and Co-operative Party MTW:E05000831                     2016-05-05 0 0           joint-party:53-119   0
12988 13734 Wayne Joseph Harrison         68 party:90 Liberal Democrats MTW:E05000831                     2016-05-05 0 0           PP90   0
12989 13735 Val Bayley-Sanderson         68 party:85 UK Independence Party (UKIP) MTW:E05000832                     2016-05-05 0 0           PP85   0
12990 13736 Cathy Conchie         68 party:52 Conservative and Unionist Party MTW:E05000832                     2016-05-05 0 0           PP52   0
12991 13737 Judith Ann Lloyd         68 party:53 Labour Party MTW:E05000832   1.0                 2016-05-05 0 0           PP53   0
12992 13738 Chris Lovell         68 party:90 Liberal Democrats MTW:E05000832                     2016-05-05 0 0           PP90   0
12993 13739 Margaret Emily Westbrook         68 party:63 Green Party MTW:E05000832     https://northwest.greenparty.org.uk/people/margaret-westbrook.html       https://static-candidates.democracyclub.org.uk/media/images/images/13739.png   duncanparkes From the party campaign page: https://northwest.greenparty.org.uk/people/margaret-westbrook.html 2016-05-05 0 0           PP63   0
12994 13740 Barry Brotherton     male   68 party:53 Labour Party MTW:E05000833   1.0 http://traffordlabour.org.uk/our-candidates-for-2016/36-barry-brotherton-priory-ward     https://uk.linkedin.com/in/barry-brotherton-a8783940 https://static-candidates.democracyclub.org.uk/media/images/images/13740.png     Auto imported from Twitter 2016-05-05 0 0           PP53   0
12995 13741 Kevin Grime     male   68 party:85 UK Independence Party (UKIP) MTW:E05000833                     2016-05-05 0 0           PP85   0
12996 13742 Paul Joseph Jay     male   68 party:52 Conservative and Unionist Party MTW:E05000833                     2016-05-05 0 0           PP52   0
12997 13743 Mandy King     female   68 party:63 Green Party MTW:E05000833                     2016-05-05 0 0           PP63   0
12998 13744 Michael MacDonald     male   68 party:90 Liberal Democrats MTW:E05000833                     2016-05-05 0 0           PP90   0
12999 13745 Mike Freeman         68 party:53 Labour Party MTW:E05000835   1.0                 2016-05-05 0 0           PP53   0
13000 13746 William Jones Mr   male   68 party:90 Liberal Democrats MTW:E05000835     http://www.libdems.org.uk/william_jones     https://www.linkedin.com/in/william-jones-b6430911 https://static-candidates.democracyclub.org.uk/media/images/images/34174.png   brycx http://www.libdems.org.uk/william_jones 2016-05-05 0 0   34174.0       PP90 Hobnob 0
13001 13747 Jane Frances Leicester         68 party:63 Green Party MTW:E05000835                     2016-05-05 0 0           PP63   0
13002 13748 Stephen James McHugh         68 party:52 Conservative and Unionist Party MTW:E05000835                     2016-05-05 0 0           PP52   0
13003 13749 John Charles Holden         68 party:52 Conservative and Unionist Party MTW:E05000834   1.0                 2016-05-05 0 0           PP52   0
13004 13750 Gary William Keary         68 party:53 Labour Party MTW:E05000834                     2016-05-05 0 0           PP53   0
13005 13752 Shaun Gavin Ennis         68 party:90 Liberal Democrats MTW:E05000836                     2016-05-05 0 0           PP90   0
13006 13753 Colin Ralph Hooley         68 party:52 Conservative and Unionist Party MTW:E05000836                     2016-05-05 0 0           PP52   0
13007 13755 Liz O'Neill         68 party:63 Green Party MTW:E05000836                     2016-05-05 0 0   41361.0       PP63   0
13008 13756 Mo Ahmed         68 party:53 Labour Party MTW:E05000837                     2016-05-05 0 0           PP53   0
13009 13758 Jadwiga Teresa Leigh         68 party:63 Green Party MTW:E05000837                     2016-05-05 0 0           PP63   0
13010 13759 Carol Mounfield         68 party:52 Conservative and Unionist Party MTW:E05000837                     2016-05-05 0 0           PP52   0
13011 13760 Andrew Beaumont     male 1965.0 68 party:85 UK Independence Party (UKIP) MTW:E05000838     http://kalvinchapman.co.uk/stretford---urmston-ge2017.html       https://static-candidates.democracyclub.org.uk/media/images/images/13760.png   J http://kalvinchapman.co.uk/stretford---urmston-ge2017.html 2016-05-05 0 0           PP85   0
13012 13762 Kirsty Cullen         68 party:90 Liberal Democrats MTW:E05000838                     2016-05-05 0 0           PP90   0
13013 13763 Catherine Louise Hynes         68 party:53 Labour Party MTW:E05000838   1.0                 2016-05-05 0 0           PP53   0
13014 13764 Christine Turner         68 party:52 Conservative and Unionist Party MTW:E05000838                     2016-05-05 0 0           PP52   0
13015 13765 Ray Bowker         68 party:90 Liberal Democrats MTW:E05000839   1.0                 2016-05-05 0 0           PP90   0
13016 13766 Thomas John Patrick Carey     male   68 party:52 Conservative and Unionist Party MTW:E05000839     http://www.traffordconservatives.com/village-ward-thomas-carey/       https://static-candidates.democracyclub.org.uk/media/images/images/13766.png     Auto imported from Twitter: https://twitter.com/intent/user?user_id=35905106 2016-05-05 0 0           PP52   0
13017 13767 Tony O'Brien         68 party:53 Labour Party MTW:E05000839                     2016-05-05 0 0   41555.0       PP53   0
13018 13768 Matthew John Westbrook         68 party:63 Green Party MTW:E05000839                     2016-05-05 0 0           PP63   0
13019 34696 Dan Jerrome     male   68 party:63 Green Party MTW:E05000819     https://my.greenparty.org.uk/candidates/106313 https://trafford.greenparty.org.uk/   https://www.linkedin.com/in/daniel-jerrome-b5379551 https://static-candidates.democracyclub.org.uk/media/images/images/34696.png   hugovk From his Facebook campaign page: https://www.facebook.com/danjerrome/photos/a.859258790881210.1073741826.859257787547977/859258794214543/?type=1&theater 2016-05-05 0 0   7898.0       PP63   0
Powered by Datasette · Query took 1.088ms