home / democracyclub

democracyclub

Custom SQL query returning 53 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
8825 6872 Glyn Redican     Male 1949.0 13 party:85 UK Independence Party (UKIP) UTW:E05001593 Mersey             https://static-candidates.democracyclub.org.uk/media/images/5547439c70823d2655a7c7a1.png   profile-photo mark It's his Facebook cover photo, from: https://www.facebook.com/glyn.redican 2016-05-05 0 0           PP85   0
8826 7228 Victor Turton Mr   male   13 ynmp-party:2 Independent UTW:E05001577 Appleton       https://victurton.wordpress.com/eu-and-my-thoughts/     https://static-candidates.democracyclub.org.uk/media/images/images/7228.png   other ripperger2345   2016-05-05 0 0   15993.0       ynmp-party:2   0
8827 13854 Lauren Rhea Cassidy         13 party:53 Labour Party UTW:E05001594 Norton North                       2016-05-05 0 0           PP53   0
8828 13855 Diane Marie Inch         13 party:90 Liberal Democrats UTW:E05001594 Norton North                       2016-05-05 0 0           PP90   0
8829 13856 Matthew Keith Lambert         13 party:52 Conservative and Unionist Party UTW:E05001594 Norton North                       2016-05-05 0 0           PP52   0
8830 14246 Brad Bradshaw         13 party:85 UK Independence Party (UKIP) UTW:E05001592 Kingsway                       2016-05-05 0 0           PP85   0
8831 14247 Margaret Horabin         13 party:53 Labour Party UTW:E05001592 Kingsway                       2016-05-05 0 0           PP53   0
8832 14248 John Robert Powell         13 party:52 Conservative and Unionist Party UTW:E05001592 Kingsway                       2016-05-05 0 0   39246.0       PP52   0
8833 14612 Pauline Sinnott         13 party:53 Labour Party UTW:E05001593 Mersey                       2016-05-05 0 0           PP53   0
8834 14613 Granville Spencer         13 party:90 Liberal Democrats UTW:E05001593 Mersey                       2016-05-05 0 0   39282.0       PP90   0
8835 15991 Eddie Jones         13 party:53 Labour Party UTW:E05001577 Appleton                       2016-05-05 0 0           PP53   0
8836 15992 Colin Rowan     male   13 party:52 Conservative and Unionist Party UTW:E05001577 Appleton                       2016-05-05 0 0   39254.0       PP52   0
8837 15998 Adam Burnett         13 party:52 Conservative and Unionist Party UTW:E05001578 Beechwood                       2016-05-05 0 0   39375.0       PP52   0
8838 15999 Philip Busow         13 party:85 UK Independence Party (UKIP) UTW:E05001578 Beechwood                       2016-05-05 0 0   39284.0       PP85   0
8839 16000 Geoffrey Michael Logan         13 party:53 Labour Party UTW:E05001578 Beechwood                       2016-05-05 0 0           PP53   0
8840 16001 Linda Redhead         13 party:90 Liberal Democrats UTW:E05001578 Beechwood                       2016-05-05 0 0   39264.0       PP90   0
8841 16007 Callum Hough         13 party:52 Conservative and Unionist Party UTW:E05001579 Birchfield                       2016-05-05 0 0           PP52   0
8842 16008 Bill Woolfall         13 party:53 Labour Party UTW:E05001579 Birchfield                       2016-05-05 0 0           PP53   0
8843 16018 Tony McDermott         13 party:53 Labour Party UTW:E05001580 Broadheath   1.0                   2016-05-05 0 0           PP53   0
8844 16023 Marjorie Bradshaw         13 party:52 Conservative and Unionist Party UTW:E05001582 Daresbury                       2016-05-05 0 0           PP52   0
8845 16024 Miriam Lorraine Hodge         13 party:90 Liberal Democrats UTW:E05001582 Daresbury                       2016-05-05 0 0   39376.0       PP90   0
8846 16025 Colin William Hughes         13 party:53 Labour Party UTW:E05001582 Daresbury                       2016-05-05 0 0           PP53   0
8847 16026 Paul David Griffiths         13 party:52 Conservative and Unionist Party UTW:E05001583 Ditton                       2016-05-05 0 0   39329.0       PP52   0
8848 16027 Kieran Reed         13 ynmp-party:2 Independent UTW:E05001583 Ditton                       2016-05-05 0 0           ynmp-party:2   0
8849 16028 Marie Wright         13 party:53 Labour Party UTW:E05001583 Ditton                       2016-05-05 0 0           PP53   0
8850 16029 Colleen Mary Harper         13 party:52 Conservative and Unionist Party UTW:E05001584 Farnworth                       2016-05-05 0 0           PP52   0
8851 16030 Val Hill         13 party:53 Labour Party UTW:E05001584 Farnworth                       2016-05-05 0 0           PP53   0
8852 16038 John Bernard Abbott         13 party:53 Labour Party UTW:E05001585 Grange                       2016-05-05 0 0           PP53   0
8853 16039 Peter Hallwood         13 party:85 UK Independence Party (UKIP) UTW:E05001585 Grange                       2016-05-05 0 0           PP85   0
8854 16040 Joanna Allison Rowe         13 party:90 Liberal Democrats UTW:E05001585 Grange                       2016-05-05 0 0           PP90   0
8855 16045 Stef Nelson         13 party:53 Labour Party UTW:E05001587 Halton Brook                       2016-05-05 0 0           PP53   0
8856 16046 Tracey Spencer         13 party:90 Liberal Democrats UTW:E05001587 Halton Brook                       2016-05-05 0 0           PP90   0
8857 16047 Rochelle Carney         13 party:85 UK Independence Party (UKIP) UTW:E05001581 Halton Castle                       2016-05-05 0 0           PP85   0
8858 16048 Harry Neil Howard         13 party:53 Labour Party UTW:E05001581 Halton Castle                       2016-05-05 0 0           PP53   0
8859 16049 Darrin Whyte         13 ynmp-party:2 Independent UTW:E05001581 Halton Castle                       2016-05-05 0 0           ynmp-party:2   0
8860 16054 Ruth Elizabeth Rowan         13 party:52 Conservative and Unionist Party UTW:E05001588 Halton Lea                       2016-05-05 0 0           PP52   0
8861 16055 Dave Thompson         13 party:53 Labour Party UTW:E05001588 Halton Lea                       2016-05-05 0 0           PP53   0
8862 16056 Jayne Busow         13 party:85 UK Independence Party (UKIP) UTW:E05001589 Halton View                       2016-05-05 0 0           PP85   0
8863 16057 Duncan James Robert Harper         13 party:52 Conservative and Unionist Party UTW:E05001589 Halton View                       2016-05-05 0 0           PP52   0
8864 16058 Rob Polhill         13 party:53 Labour Party UTW:E05001589 Halton View                       2016-05-05 0 0           PP53   0
8865 16063 Ian John Adams         13 party:52 Conservative and Unionist Party UTW:E05001590 Heath                       2016-05-05 0 0           PP52   0
8866 16064 Rosie Leck         13 party:53 Labour Party UTW:E05001590 Heath                       2016-05-05 0 0   39361.0       PP53   0
8867 16065 Gareth Charles Stockton         13 party:90 Liberal Democrats UTW:E05001590 Heath                       2016-05-05 0 0           PP90   0
8868 16066 Michelle Watson         13 party:85 UK Independence Party (UKIP) UTW:E05001590 Heath                       2016-05-05 0 0           PP85   0
8869 16071 Joanne McLean         13 party:52 Conservative and Unionist Party UTW:E05001591 Hough Green                       2016-05-05 0 0           PP52   0
8870 16072 Paul Nolan         13 party:53 Labour Party UTW:E05001591 Hough Green                       2016-05-05 0 0           PP53   0
8871 16073 Ronald John Hignett         13 party:53 Labour Party UTW:E05001595 Norton South                       2016-05-05 0 0           PP53   0
8872 16074 William John Ring         13 party:52 Conservative and Unionist Party UTW:E05001595 Norton South                       2016-05-05 0 0           PP52   0
8873 16079 Thomas Michael Glynn         13 party:85 UK Independence Party (UKIP) UTW:E05001596 Riverside                       2016-05-05 0 0   39326.0       PP85   0
8874 16080 Stan Hill         13 party:53 Labour Party UTW:E05001596 Riverside                       2016-05-05 0 0           PP53   0
8875 16085 Philip Harper         13 party:52 Conservative and Unionist Party UTW:E05001597 Windmill Hill ward                       2016-05-05 0 0   39241.0       PP52   0
8876 16086 Pauline Hignett         13 party:53 Labour Party UTW:E05001597 Windmill Hill ward                       2016-05-05 0 0           PP53   0
8877 19433 Daniel Clarke     male   13 party:52 Conservative and Unionist Party UTW:E05001593 Mersey                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 0.726ms