home / democracyclub

democracyclub

Custom SQL query returning 48 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
14954 706 Arshad Khan     male   91 party:157 Justice Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP157   0
14955 5125 Christopher Brown     male   91 party:85 UK Independence Party (UKIP) DIW:E05007631 Bewbush       http://www.chrisbrownukip.org/     https://static-candidates.democracyclub.org.uk/media/images/55268e5859bbc5c063445b83.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 0   11877;31824       PP85   0
14956 11875 Marion Ayling         91 party:53 Labour Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP53   0
14957 11876 Andrew Belben         91 party:52 Conservative and Unionist Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP52   0
14958 11878 Martin Kail         91 party:63 Green Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP63   0
14959 11879 Sarah Smith         91 party:90 Liberal Democrats DIW:E05007631 Bewbush                       2016-05-05 0 0   31825.0       PP90   0
14960 11880 Irshad Jalaldeen         91 party:52 Conservative and Unionist Party DIW:E05007632 Broadfield North                       2016-05-05 0 0           PP52   0
14961 11881 Brian J Quinn         91 party:53 Labour Party DIW:E05007632 Broadfield North                       2016-05-05 0 0           PP53   0
14962 11882 Charlotte Franco         91 party:63 Green Party DIW:E05007633 Broadfield South                       2016-05-05 0 0           PP63   0
14963 11883 Charles Petts         91 party:52 Conservative and Unionist Party DIW:E05007633 Broadfield South                       2016-05-05 0 0           PP52   0
14964 11884 Tahira Rana         91 party:53 Labour Party DIW:E05007633 Broadfield South                       2016-05-05 0 0           PP53   0
14965 11885 Chris Mullins         91 party:53 Labour Party DIW:E05007635 Gossops Green ward                       2016-05-05 0 0           PP53   0
14966 11886 Philip Norville         91 party:52 Conservative and Unionist Party DIW:E05007635 Gossops Green ward                       2016-05-05 0 0           PP52   0
14967 11887 Neil James Setford-Thompson         91 party:85 UK Independence Party (UKIP) DIW:E05007635 Gossops Green ward                       2016-05-05 0 0           PP85   0
14968 11888 George Paul Bird         91 party:85 UK Independence Party (UKIP) DIW:E05007636 Ifield                       2016-05-05 0 0           PP85   0
14969 11889 Andrew Jagger         91 party:52 Conservative and Unionist Party DIW:E05007636 Ifield                       2016-05-05 0 0           PP52   0
14970 11890 Richard Martin Kail Mr   Male 1995-10-05 91 party:63 Green Party DIW:E05007636 Ifield     https://www.facebook.com/richardkailgreenparty/ https://www.midsussex.greenparty.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11890.png   public-domain RichardKail It's my own photograph. 2016-05-05 0 0   34222.0       PP63   0
14971 11891 Mike Sargent         91 party:90 Liberal Democrats DIW:E05007636 Ifield                       2016-05-05 0 0           PP90   0
14972 11892 Peter Smith         91 joint-party:53-119 Labour and Co-operative Party DIW:E05007636 Ifield     http://labourclp7.nationbuilder.com/peter_smith_2016_candidate https://www.crawleylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11892.png   public-domain peter11   2016-05-05 0 0           joint-party:53-119   0
14973 11893 Rudolf Otto Hugh Affolter         91 party:63 Green Party DIW:E05007637 Langley Green                       2016-05-05 0 0           PP63   0
14974 11894 Kevin Hall         91 party:52 Conservative and Unionist Party DIW:E05007637 Langley Green                       2016-05-05 0 0           PP52   0
14975 11895 Sharon Kennett         91 party:85 UK Independence Party (UKIP) DIW:E05007637 Langley Green                       2016-05-05 0 0   31848.0       PP85   0
14976 11896 Marko Scepanovic     Male   91 party:90 Liberal Democrats DIW:E05007637 Langley Green     http://www.libdems.org.uk/marko_scepanovic     https://www.linkedin.com/in/marko-scepanovic-86804075/ https://static-candidates.democracyclub.org.uk/media/images/images/11896.png   profile-photo mark From the Crawley Liberal Democrats website: https://crawley-libdems.org.uk/en/page/marko-scepanovic 2016-05-05 0 0           PP90   0
14977 11897 Brenda Ann Smith         91 party:53 Labour Party DIW:E05007637 Langley Green                       2016-05-05 0 0           PP53   0
14978 11898 Danielle Kail         91 party:63 Green Party DIW:E05007638 Maidenbower                       2016-05-05 0 0           PP63   0
14979 11899 Duncan Peck         91 party:52 Conservative and Unionist Party DIW:E05007638 Maidenbower                       2016-05-05 0 0           PP52   0
14980 11900 Akram Rana         91 party:53 Labour Party DIW:E05007638 Maidenbower                       2016-05-05 0 0           PP53   0
14981 11901 Tina Belben         91 party:52 Conservative and Unionist Party DIW:E05007640 Pound Hill North                       2016-05-05 0 0           PP52   0
14982 11902 Tony Patel         91 party:53 Labour Party DIW:E05007640 Pound Hill North                       2016-05-05 0 0           PP53   0
14983 11903 Valerie Spooner         91 party:90 Liberal Democrats DIW:E05007640 Pound Hill North                       2016-05-05 0 0           PP90   0
14984 11904 Daniel Elliott         91 party:63 Green Party DIW:E05007641 Pound Hill South and Worth                       2016-05-05 0 0           PP63   0
14985 11905 Colin Flack     male   91 party:53 Labour Party DIW:E05007641 Pound Hill South and Worth     https://labourclp7.nationbuilder.com/colin_flack_2018_candidate       https://static-candidates.democracyclub.org.uk/media/images/images/11905.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=715574547949469696 2016-05-05 0 0           PP53   0
14986 11906 Bob Lanzer Mr   male   91 party:52 Conservative and Unionist Party DIW:E05007641 Pound Hill South and Worth             https://static-candidates.democracyclub.org.uk/media/images/images/11906.png   other gregorywilliams https://www.westsussex.gov.uk/find-my-nearest/councillor/details/api/type/councillor/view/mr-bob-lanzer 2016-05-05 0 0           PP52   0
14987 11907 Alison Berridge         91 party:52 Conservative and Unionist Party DIW:E05007642 Southgate                       2016-05-05 0 0           PP52   0
14988 11908 Kevin Osborne         91 party:90 Liberal Democrats DIW:E05007642 Southgate                       2016-05-05 0 0           PP90   0
14989 11909 Mike Pickett         91 party:53 Labour Party DIW:E05007642 Southgate                       2016-05-05 0 0           PP53   0
14990 11910 Brenda Burgess         91 party:52 Conservative and Unionist Party DIW:E05007643 Three Bridges ward                       2016-05-05 0 0           PP52   0
14991 11911 Daryl Lynn Duncan-English         91 party:53 Labour Party DIW:E05007643 Three Bridges ward                       2016-05-05 0 0           PP53   0
14992 11912 Colin Frank Young         91 party:90 Liberal Democrats DIW:E05007643 Three Bridges ward                       2016-05-05 0 0           PP90   0
14993 11913 Allan Peter Griffiths         91 party:85 UK Independence Party (UKIP) DIW:E05007644 Tilgate ward                       2016-05-05 0 0   25456.0       PP85   0
14994 11914 Claire Griffiths Mrs       91 party:52 Conservative and Unionist Party DIW:E05007644 Tilgate ward       https://www.conservatives.com/               2016-05-05 0 0           PP52   0
14995 11915 Derek Andrew Hardman         91 party:63 Green Party DIW:E05007644 Tilgate ward                       2016-05-05 0 0           PP63   0
14996 11916 James Harper         91 party:90 Liberal Democrats DIW:E05007644 Tilgate ward                       2016-05-05 0 0           PP90   0
14997 11917 Carlos Portal Castro         91 party:53 Labour Party DIW:E05007644 Tilgate ward                       2016-05-05 0 0           PP53   0
14998 11918 David Anderson         91 party:90 Liberal Democrats DIW:E05007645 West Green                       2016-05-05 0 0           PP90   0
14999 11919 Ian Anguige         91 party:52 Conservative and Unionist Party DIW:E05007645 West Green                       2016-05-05 0 0           PP52   0
15000 11920 Rory Stuart Fiveash         91 party:53 Labour Party DIW:E05007645 West Green                       2016-05-05 0 0           PP53   0
15001 11921 Carole Lauderdale         91 party:85 UK Independence Party (UKIP) DIW:E05007645 West Green                       2016-05-05 0 0           PP85   0
Powered by Datasette · Query took 0.733ms