home / democracyclub

democracyclub

Custom SQL query returning 89 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
11746 1359 Jack Easton Mr   male   52 party:63 Green Party DIW:E05004800 St Stephen     https://stalbans.greenparty.org.uk/news/2017/04/28/jack-easton-selected-as-general-election-candidate/ https://stalbans.greenparty.org.uk/   https://www.linkedin.com/in/jack-easton-65a7a057/ https://static-candidates.democracyclub.org.uk/media/images/images/1359.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1444635962 2016-05-05 0 0   26599.0       PP63   0
11747 7797 Chris White Mr   male   52 party:90 Liberal Democrats DIW:E05004787 Clarence   1.0 http://www.libdems.org.uk/chris_white http://chriswhite.mycouncillor.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7797.png   profile-photo petersteadman http://www.libdems.org.uk/chris_white - libdem candidate page 2016-05-05 0 0   15759.0       PP90   0
11748 11392 David John Yates Mr   Male 1954-05-29 52 party:90 Liberal Democrats DIW:E05004797 Park Street   1.0       https://www.linkedin.com/in/davidjyates https://static-candidates.democracyclub.org.uk/media/images/images/11392.png   copyright-assigned cllr.d.yates@stalbans.gov.uk   2016-05-05 0 0           PP90   0
11749 13903 Richard Patrick Curthoys         52 party:52 Conservative and Unionist Party DIW:E05004796 Marshalswick South   1.0                   2016-05-05 0 0           PP52   0
11750 13904 David Francis Dickson         52 party:85 UK Independence Party (UKIP) DIW:E05004796 Marshalswick South                       2016-05-05 0 0           PP85   0
11751 13905 John Hale         52 party:90 Liberal Democrats DIW:E05004796 Marshalswick South                       2016-05-05 0 0   26558.0       PP90   0
11752 13906 Richard George Harris         52 party:53 Labour Party DIW:E05004796 Marshalswick South                       2016-05-05 0 0           PP53   0
11753 13907 Jill Mills         52 party:63 Green Party DIW:E05004796 Marshalswick South                       2016-05-05 0 0           PP63   0
11754 13970 Robert Anthony Dunster     male   52 party:52 Conservative and Unionist Party DIW:E05004785 Ashley                       2016-05-05 0 0           PP52   0
11755 13971 Lydia El-Khouri         52 party:63 Green Party DIW:E05004785 Ashley                       2016-05-05 0 0           PP63   0
11756 13972 Matt Farrell         52 party:90 Liberal Democrats DIW:E05004785 Ashley   1.0                   2016-05-05 0 0           PP90   0
11757 13973 Charles Michael Mason     male   52 party:85 UK Independence Party (UKIP) DIW:E05004785 Ashley                       2016-05-05 0 0           PP85   0
11758 13974 Momotaz Rahim         52 party:53 Labour Party DIW:E05004785 Ashley                       2016-05-05 0 0           PP53   0
11759 15027 Jennifer Corsbie         52 party:85 UK Independence Party (UKIP) DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP85   0
11760 15028 Michael Philip Gray-Higgins         52 party:53 Labour Party DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP53   0
11761 15029 Anna Meg Kinnersley         52 party:63 Green Party DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP63   0
11762 15030 Jeffrey Kyndon Phillips         52 party:90 Liberal Democrats DIW:E05004793 Harpenden West                       2016-05-05 0 0           PP90   0
11763 15031 Matthew David Stephens         52 party:52 Conservative and Unionist Party DIW:E05004793 Harpenden West   1.0                   2016-05-05 0 0           PP52   0
11764 15742 Scott Clyne         52 party:52 Conservative and Unionist Party DIW:E05004786 Batchwood                       2016-05-05 0 0           PP52   0
11765 15743 Matthew Dovey         52 party:85 UK Independence Party (UKIP) DIW:E05004786 Batchwood                       2016-05-05 0 0           PP85   0
11766 15744 Ellie Hudspith         52 party:90 Liberal Democrats DIW:E05004786 Batchwood                       2016-05-05 0 0           PP90   0
11767 15745 Mal Pakenham         52 party:53 Labour Party DIW:E05004786 Batchwood   1.0                   2016-05-05 0 0           PP53   0
11768 15755 Keith Brian Hussey         52 party:804 Trade Unionist and Socialist Coalition DIW:E05004787 Clarence                       2016-05-05 0 0           PP804   0
11769 15756 Liz Mills         52 party:53 Labour Party DIW:E05004787 Clarence                       2016-05-05 0 0           PP53   0
11770 15757 Tim Robinson         52 party:63 Green Party DIW:E05004787 Clarence                       2016-05-05 0 0           PP63   0
11771 15758 Barry Paul Sumpter         52 party:52 Conservative and Unionist Party DIW:E05004787 Clarence                       2016-05-05 0 0           PP52   0
11772 15760 Geoff Harrison         52 party:90 Liberal Democrats DIW:E05004789 Cunningham   1.0                   2016-05-05 0 0           PP90   0
11773 15761 Alan Robert Malin         52 party:85 UK Independence Party (UKIP) DIW:E05004789 Cunningham                       2016-05-05 0 0           PP85   0
11774 15762 John Paton         52 party:53 Labour Party DIW:E05004789 Cunningham                       2016-05-05 0 0   26585.0       PP53   0
11775 15763 Gregory Scott Riener         52 party:63 Green Party DIW:E05004789 Cunningham                       2016-05-05 0 0           PP63   0
11776 15764 Nadine Standish     female   52 party:52 Conservative and Unionist Party DIW:E05004789 Cunningham                       2016-05-05 0 0           PP52   0
11777 15770 Paul David De Kort         52 party:90 Liberal Democrats DIW:E05004790 Harpenden East                       2016-05-05 0 0           PP90   0
11778 15771 Rosemary Anne Farmer         52 party:52 Conservative and Unionist Party DIW:E05004790 Harpenden East   1.0                   2016-05-05 0 0           PP52   0
11779 15773 Lester MacKenzie         52 party:85 UK Independence Party (UKIP) DIW:E05004790 Harpenden East                       2016-05-05 0 0           PP85   0
11780 15774 Rosemary Elsbeth Ross         52 party:53 Labour Party DIW:E05004790 Harpenden East                       2016-05-05 0 0           PP53   0
11781 15781 John Hansen         52 ynmp-party:2 Independent DIW:E05004791 Harpenden North                       2016-05-05 0 0           ynmp-party:2   0
11782 15782 Stephen John Hodgson Mr BEng (Hons) ACA CTA Male   52 party:52 Conservative and Unionist Party DIW:E05004791 Harpenden North   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/15782.png   profile-photo sjhodgson I am the candidate 2016-05-05 0 0           PP52   0
11783 15783 Stephen Andrew Hughes         52 party:85 UK Independence Party (UKIP) DIW:E05004791 Harpenden North                       2016-05-05 0 0           PP85   0
11784 15784 Aileen Margaret King         52 party:90 Liberal Democrats DIW:E05004791 Harpenden North                       2016-05-05 0 0           PP90   0
11785 15785 Linda Ann Spiri         52 party:53 Labour Party DIW:E05004791 Harpenden North                       2016-05-05 0 0           PP53   0
11786 15786 George Murray Fraser     male   52 party:53 Labour Party DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP53   0
11787 15787 Mick Hawkes         52 party:85 UK Independence Party (UKIP) DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP85   0
11788 15788 David Peter Heritage         52 party:52 Conservative and Unionist Party DIW:E05004792 Harpenden South   1.0                   2016-05-05 0 0           PP52   0
11789 15789 Maria Louise Moyses         52 party:90 Liberal Democrats DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP90   0
11790 15790 Suheil Shahryar         52 party:63 Green Party DIW:E05004792 Harpenden South                       2016-05-05 0 0           PP63   0
11791 15795 Patrick Alderman         52 party:52 Conservative and Unionist Party DIW:E05004794 London Colney                       2016-05-05 0 0           PP52   0
11792 15796 Dreda Gordon         52 party:53 Labour Party DIW:E05004794 London Colney   1.0                   2016-05-05 0 0           PP53   0
11793 15797 Jessica Frances Kay Halliday         52 party:90 Liberal Democrats DIW:E05004794 London Colney                       2016-05-05 0 0           PP90   0
11794 15798 James Richard Lomas         52 party:63 Green Party DIW:E05004794 London Colney                       2016-05-05 0 0           PP63   0
11795 15799 John Midgley         52 party:85 UK Independence Party (UKIP) DIW:E05004794 London Colney                       2016-05-05 0 0           PP85   0
11796 15805 Janet Churchard         52 party:90 Liberal Democrats DIW:E05004795 Marshalswick North   1.0                   2016-05-05 0 0           PP90   0
11797 15806 Claudio Duran     male   52 party:52 Conservative and Unionist Party DIW:E05004795 Marshalswick North           https://uk.linkedin.com/in/g-claudio-duran-38286b20           2016-05-05 0 0           PP52   0
11798 15807 Claire Gilbert         52 party:63 Green Party DIW:E05004795 Marshalswick North                       2016-05-05 0 0           PP63   0
11799 15808 Michael David Hollins         52 party:85 UK Independence Party (UKIP) DIW:E05004795 Marshalswick North                       2016-05-05 0 0           PP85   0
11800 15809 Paul Francis Walker         52 party:53 Labour Party DIW:E05004795 Marshalswick North                       2016-05-05 0 0           PP53   0
11801 15822 Linda Lennard         52 party:63 Green Party DIW:E05004797 Park Street                       2016-05-05 0 0           PP63   0
11802 15823 Martin Gerard McGrath         52 party:53 Labour Party DIW:E05004797 Park Street                       2016-05-05 0 0           PP53   0
11803 15824 Michael Brian Roth         52 party:52 Conservative and Unionist Party DIW:E05004797 Park Street                       2016-05-05 0 0           PP52   0
11804 15825 Peter James Whitehead         52 party:85 UK Independence Party (UKIP) DIW:E05004797 Park Street                       2016-05-05 0 0           PP85   0
11805 15826 Daragh Gerald Patrick Cahalane         52 party:85 UK Independence Party (UKIP) DIW:E05004798 Redbourn                       2016-05-05 0 0           PP85   0
11806 15827 Maria Bridget Theresa Maynard         52 party:52 Conservative and Unionist Party DIW:E05004798 Redbourn                       2016-05-05 0 0           PP52   0
11807 15828 Anthony Eric Neville         52 party:53 Labour Party DIW:E05004798 Redbourn                       2016-05-05 0 0           PP53   0
11808 15829 Tony Swendell         52 ynmp-party:2 Independent DIW:E05004798 Redbourn   1.0                   2016-05-05 0 0           ynmp-party:2   0
11809 15845 Valerie Linda Hargrave         52 party:85 UK Independence Party (UKIP) DIW:E05004802 Sopwell                       2016-05-05 0 0           PP85   0
11810 15846 Gail Jackson         52 party:63 Green Party DIW:E05004802 Sopwell                       2016-05-05 0 0           PP63   0
11811 15847 Shakir Rahman     male   52 party:90 Liberal Democrats DIW:E05004802 Sopwell     http://www.stalbanslibdems.org.uk/sopwell     https://uk.linkedin.com/in/shakir-rahman-80498564 https://static-candidates.democracyclub.org.uk/media/images/images/15847.png   profile-photo mattl From http://www.stalbanslibdems.org.uk/election_team_2018 2016-05-05 0 0           PP90   0
11812 15848 Heather Christine Rench         52 party:52 Conservative and Unionist Party DIW:E05004802 Sopwell                       2016-05-05 0 0           PP52   0
11813 15849 Janet Smith         52 party:53 Labour Party DIW:E05004802 Sopwell   1.0                   2016-05-05 0 0           PP53   0
11814 15856 Nick Bishop         52 party:52 Conservative and Unionist Party DIW:E05004799 St Peters                       2016-05-05 0 0           PP52   0
11815 15857 Michael Douglas         52 party:85 UK Independence Party (UKIP) DIW:E05004799 St Peters                       2016-05-05 0 0           PP85   0
11816 15858 Simon Grover     Male 1966.0 52 party:63 Green Party DIW:E05004799 St Peters   1.0 http://www.sagreens.org.uk                 2016-05-05 0 0   27109.0       PP63   0
11817 15859 Matt Jones         52 party:90 Liberal Democrats DIW:E05004799 St Peters                       2016-05-05 0 0           PP90   0
11818 15860 Alex Veitch         52 party:53 Labour Party DIW:E05004799 St Peters                       2016-05-05 0 0           PP53   0
11819 15861 Janet Elizabeth Blackwell         52 party:53 Labour Party DIW:E05004800 St Stephen                       2016-05-05 0 0           PP53   0
11820 15862 Brian William Gibbard         52 party:52 Conservative and Unionist Party DIW:E05004800 St Stephen   1.0                   2016-05-05 0 0           PP52   0
11821 15863 Tina Lomax         52 party:85 UK Independence Party (UKIP) DIW:E05004800 St Stephen                       2016-05-05 0 0           PP85   0
11822 15864 Alison Ross     female   52 party:90 Liberal Democrats DIW:E05004800 St Stephen             https://static-candidates.democracyclub.org.uk/media/images/images/15864.png   profile-photo mattl From http://www.stalbanslibdems.org.uk/election_team_2018 2016-05-05 0 0           PP90   0
11823 15865 Michael Bartlet         52 party:53 Labour Party DIW:E05004803 Verulam                       2016-05-05 0 0           PP53   0
11824 15866 Chris Davies         52 party:90 Liberal Democrats DIW:E05004803 Verulam   1.0                   2016-05-05 0 0           PP90   0
11825 15867 Colin Stewart Donald         52 party:85 UK Independence Party (UKIP) DIW:E05004803 Verulam                       2016-05-05 0 0           PP85   0
11826 15868 Mark Antony Ewington         52 party:63 Green Party DIW:E05004803 Verulam                       2016-05-05 0 0           PP63   0
11827 15869 Stella Maria Nita Nash         52 party:52 Conservative and Unionist Party DIW:E05004803 Verulam                       2016-05-05 0 0           PP52   0
11828 15870 Gillian Mary Clark         52 party:52 Conservative and Unionist Party DIW:E05004804 Wheathampstead   1.0                   2016-05-05 0 0           PP52   0
11829 15871 Beverley Rands         52 party:85 UK Independence Party (UKIP) DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP85   0
11830 15872 Neill Sankey         52 party:53 Labour Party DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP53   0
11831 15873 Harriet Sherlock         52 party:90 Liberal Democrats DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP90   0
11832 15874 Ian Troughton         52 party:63 Green Party DIW:E05004804 Wheathampstead                       2016-05-05 0 0           PP63   0
11833 19425 Anne James     Female   52 ynmp-party:2 Independent DIW:E05004790 Harpenden East                       2016-05-05 0 0           ynmp-party:2   0
11834 26600 Lesley Charlotte Baker         52 party:63 Green Party DIW:E05004786 Batchwood                       2016-05-05 0 0   15741.0       PP63   0
Powered by Datasette · Query took 1.024ms