home / democracyclub

democracyclub

Custom SQL query returning 51 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
11942 5788 Leonard Amos     male 1957-11-20 54 party:53 Labour Party DIW:E05008993 Fernhill     http://www.labour.org.uk/people/detail/leonard-amos       https://static-candidates.democracyclub.org.uk/media/images/54cd1b0b668e142f73d3b4b4.png   profile-photo     2016-05-05 0 0           PP53   0
11943 6333 Carl Hewitt     male 1965-11-02 54 ynmp-party:2 Independent DIW:E05008999 St Mark's             https://static-candidates.democracyclub.org.uk/media/images/images/6333.png   profile-photo carlosfandango1st   2016-05-05 0 0   18659.0       ynmp-party:2 Digestive 0
11944 7555 Martin Anthony Coule Mr   male 1963.0 54 party:63 Green Party DIW:E05008993 Fernhill                       2016-05-05 0 0           PP63   0
11945 10294 Richard James Adair Mr   Male   54 party:90 Liberal Democrats DIW:E05008995 Manor Park     http://www.portsmouthlibdems.org.uk/richard_adair2       https://static-candidates.democracyclub.org.uk/media/images/images/10294.png   profile-photo petersteadman http://www.libdems.org.uk/richard_adair - libdem candidate page 2016-05-05 0 0           PP90   0
11946 15977 Harry Dagger Nelson         54 party:85 UK Independence Party (UKIP) DIW:E05008993 Fernhill                       2016-05-05 0 0           PP85   0
11947 15978 John Edward Woolley     male   54 party:52 Conservative and Unionist Party DIW:E05008993 Fernhill                       2016-05-05 0 0   18869.0       PP52   0
11948 18591 Derek Roy Cornwell         54 party:85 UK Independence Party (UKIP) DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP85   0
11949 18592 Clive Grattan         54 party:53 Labour Party DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP53   0
11950 18593 Mara Makunura         54 party:52 Conservative and Unionist Party DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP52   0
11951 18594 Shaun Patrick Joseph Murphy         54 party:90 Liberal Democrats DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP90   0
11952 18601 Susan Mary Carter         54 party:52 Conservative and Unionist Party DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP52   0
11953 18602 Alain Stephen Dekker         54 party:90 Liberal Democrats DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP90   0
11954 18603 Madi Jabbi         54 party:53 Labour Party DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP53   0
11955 18604 Justin Palmer         54 party:63 Green Party DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP63   0
11956 18605 Jenny Parsons         54 party:85 UK Independence Party (UKIP) DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP85   0
11957 18606 Peter Hayward         54 party:53 Labour Party DIW:E05008992 Empress                       2016-05-05 0 0           PP53   0
11958 18607 Marina Munro         54 party:52 Conservative and Unionist Party DIW:E05008992 Empress                       2016-05-05 0 0           PP52   0
11959 18608 Colin Nixon         54 party:85 UK Independence Party (UKIP) DIW:E05008992 Empress                       2016-05-05 0 0           PP85   0
11960 18618 Rosie Bell         54 party:85 UK Independence Party (UKIP) DIW:E05008994 Knellwood                       2016-05-05 0 0           PP85   0
11961 18619 Jeffrey Michael De Noronha         54 party:90 Liberal Democrats DIW:E05008994 Knellwood                       2016-05-05 0 0           PP90   0
11962 18620 Amy Hannah Lewry         54 party:63 Green Party DIW:E05008994 Knellwood                       2016-05-05 0 0           PP63   0
11963 18621 Paul Graham Taylor         54 party:52 Conservative and Unionist Party DIW:E05008994 Knellwood                       2016-05-05 0 0           PP52   0
11964 18622 Bill Tootill         54 party:53 Labour Party DIW:E05008994 Knellwood                       2016-05-05 0 0           PP53   0
11965 18630 David Edward Clifford         54 party:52 Conservative and Unionist Party DIW:E05008995 Manor Park                       2016-05-05 0 0           PP52   0
11966 18631 David Lee Collett         54 party:85 UK Independence Party (UKIP) DIW:E05008995 Manor Park                       2016-05-05 0 0           PP85   0
11967 18632 Dominique Jamie Alexandra Swaddling         54 party:53 Labour Party DIW:E05008995 Manor Park                       2016-05-05 0 0           PP53   0
11968 18640 David Anthony Armitage         54 party:52 Conservative and Unionist Party DIW:E05008996 North Town                       2016-05-05 0 0           PP52   0
11969 18641 Keith Dibble         54 party:53 Labour Party DIW:E05008996 North Town                       2016-05-05 0 0           PP53   0
11970 18642 Mark Letties         54 party:85 UK Independence Party (UKIP) DIW:E05008996 North Town                       2016-05-05 0 0           PP85   0
11971 18649 Kevin Betsworth         54 party:85 UK Independence Party (UKIP) DIW:E05008997 Rowhill                       2016-05-05 0 0           PP85   0
11972 18650 Julie Martha Considine         54 party:53 Labour Party DIW:E05008997 Rowhill                       2016-05-05 0 0           PP53   0
11973 18651 Peta Martine Howell         54 party:63 Green Party DIW:E05008997 Rowhill                       2016-05-05 0 0           PP63   0
11974 18652 Maurice Leonard Sheehan         54 party:52 Conservative and Unionist Party DIW:E05008997 Rowhill                       2016-05-05 0 0           PP52   0
11975 18653 Sue Gadsby         54 party:53 Labour Party DIW:E05008998 St John's                       2016-05-05 0 0           PP53   0
11976 18654 Chris Harding         54 party:85 UK Independence Party (UKIP) DIW:E05008998 St John's                       2016-05-05 0 0           PP85   0
11977 18655 Peter John Moyle         54 party:52 Conservative and Unionist Party DIW:E05008998 St John's                       2016-05-05 0 0           PP52   0
11978 18656 Philip Geoffrey Thompson         54 party:90 Liberal Democrats DIW:E05008998 St John's                       2016-05-05 0 0           PP90   0
11979 18657 Simon Amir Austridge         54 party:85 UK Independence Party (UKIP) DIW:E05008999 St Mark's                       2016-05-05 0 0           PP85   0
11980 18658 Diane Beverley Bedford         54 party:52 Conservative and Unionist Party DIW:E05008999 St Mark's                       2016-05-05 0 0           PP52   0
11981 18660 Abul Koher Chowdhury         54 party:90 Liberal Democrats DIW:E05008999 St Mark's                       2016-05-05 0 0           PP90   0
11982 18661 Gary Simpson         54 party:63 Green Party DIW:E05008999 St Mark's                       2016-05-05 0 0           PP63   0
11983 18662 Colin Southon         54 party:53 Labour Party DIW:E05008999 St Mark's                       2016-05-05 0 0   31098.0       PP53   0
11984 18663 Attika Salim Choudhary         54 party:52 Conservative and Unionist Party DIW:E05009000 Wellington                       2016-05-05 0 0           PP52   0
11985 18664 Alex Crawford         54 party:53 Labour Party DIW:E05009000 Wellington                       2016-05-05 0 0           PP53   0
11986 18665 Haydar Koher         54 party:90 Liberal Democrats DIW:E05009000 Wellington                       2016-05-05 0 0           PP90   0
11987 18666 Paula Samantha Marshall         54 party:63 Green Party DIW:E05009001 West Heath                       2016-05-05 0 0           PP63   0
11988 18667 Steve Morgan         54 party:52 Conservative and Unionist Party DIW:E05009001 West Heath                       2016-05-05 0 0           PP52   0
11989 18668 Josephine Patricia Murphy         54 party:90 Liberal Democrats DIW:E05009001 West Heath                       2016-05-05 0 0           PP90   0
11990 18669 Trevor Simpson         54 party:53 Labour Party DIW:E05009001 West Heath                       2016-05-05 0 0           PP53   0
11991 18670 Mark Staplehurst         54 party:85 UK Independence Party (UKIP) DIW:E05009001 West Heath                       2016-05-05 0 0           PP85   0
11992 46197 Donna Wallace Mrs   female   54 party:63 Green Party DIW:E05008992 Empress     https://my.greenparty.org.uk/candidates/105784       https://static-candidates.democracyclub.org.uk/media/images/images/34816.png   profile-photo kdcm87 Photo from local election campaign https://blackwater.greenparty.org.uk/candidates/candidates-rushmoor.html 2016-05-05 0 0   34816.0       PP63   0
Powered by Datasette · Query took 1.001ms