home / democracyclub

democracyclub

Custom SQL query returning 73 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
9980 5012 Barry Hodgson     male   32 party:85 UK Independence Party (UKIP) MTW:E05001334 Penn     http://ukipwolverhampton.org/m-p-candidates/                 2016-05-05 0 0           PP85   0
9981 5583 Arun Photay     male   32 party:52 Conservative and Unionist Party MTW:E05001338 Tettenhall Wightwick   1.0 https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Photay_Arun.aspx http://www.arunphotay.com/   http://uk.linkedin.com/pub/arun-photay-ba-hons-adcb/49/680/b30/en https://static-candidates.democracyclub.org.uk/media/images/55225af1328bff5d39338a6a.png   profile-photo JPCarrington Used on main page of candidate's campaign website http://www.arunphotay.com/home.html 2016-05-05 0 0           PP52   0
9982 6947 Andrea Cantrill     Female   32 party:63 Green Party MTW:E05001333 Park     https://my.greenparty.org.uk/candidates/106305       https://static-candidates.democracyclub.org.uk/media/images/554879923c0ead4826d5918a.png   profile-photo andylolz From party PPC page: https://my.greenparty.org.uk/candidates/106305 2016-05-05 0 0   6231.0       PP63 Anything homemade! 0
9983 7124 Ian Jenkins     Male   32 party:90 Liberal Democrats MTW:E05001324 Bushbury North             https://static-candidates.democracyclub.org.uk/media/images/551b3c1413eb34c82843cb66.png   profile-photo JPCarrington On local party's PPC page here: http://www.wolverhamptoneastlibdems.org.uk/2015/03/13/parliamentary-candidates-for-general-election-2015/ 2016-05-05 0 0   3953;17832       PP90   0
9984 16704 Payal Bedi-Chadha         32 party:53 Labour Party MTW:E05001321 Bilston East   1.0                   2016-05-05 0 0           PP53   0
9985 16705 Tom Fellows         32 party:85 UK Independence Party (UKIP) MTW:E05001321 Bilston East                       2016-05-05 0 0           PP85   0
9986 16706 David Mackintosh         32 party:52 Conservative and Unionist Party MTW:E05001321 Bilston East                       2016-05-05 0 0           PP52   0
9987 17271 Paula Christine Brookfield     female   32 party:53 Labour Party MTW:E05001340 Wednesfield South   1.0 http://www.wolverhamptonlabour.com/wards/wednesfield-south/paula-brookfield                 2016-05-05 0 0           PP53   0
9988 17272 Steve Hall         32 party:52 Conservative and Unionist Party MTW:E05001340 Wednesfield South                       2016-05-05 0 0           PP52   0
9989 17825 Peter William Dobb         32 party:52 Conservative and Unionist Party MTW:E05001322 Bilston North                       2016-05-05 0 0           PP52   0
9990 17826 Ray Hollington         32 party:85 UK Independence Party (UKIP) MTW:E05001322 Bilston North                       2016-05-05 0 0           PP85   0
9991 17827 Linda Mary Leach     female   32 party:53 Labour Party MTW:E05001322 Bilston North   1.0 http://www.wolverhamptonlabour.com/wards/bilston-north/linda-leach                 2016-05-05 0 0           PP53   0
9992 17828 Sera Singh Aulakh         32 party:52 Conservative and Unionist Party MTW:E05001323 Blakenhall                       2016-05-05 0 0           PP52   0
9993 17829 Bhajan Singh Devsi         32 ynmp-party:2 Independent MTW:E05001323 Blakenhall                       2016-05-05 0 0           ynmp-party:2   0
9994 17830 John Jeffrey Rowley         32 party:53 Labour Party MTW:E05001323 Blakenhall   1.0                   2016-05-05 0 0           PP53   0
9995 17831 Gerard Fletcher         32 party:85 UK Independence Party (UKIP) MTW:E05001324 Bushbury North                       2016-05-05 0 0           PP85   0
9996 17833 Hazel Malcolm         32 party:53 Labour Party MTW:E05001324 Bushbury North   1.0                   2016-05-05 0 0           PP53   0
9997 17834 Andrew William McNeil         32 party:52 Conservative and Unionist Party MTW:E05001324 Bushbury North                       2016-05-05 0 0           PP52   0
9998 17835 Michelle Webster         32 party:63 Green Party MTW:E05001324 Bushbury North                       2016-05-05 0 0           PP63   0
9999 17844 Peter Alan Bilson         32 party:53 Labour Party MTW:E05001325 Bushbury South and Low Hill   1.0                   2016-05-05 0 0           PP53   0
10000 17845 Simon Mark Hewitt         32 party:52 Conservative and Unionist Party MTW:E05001325 Bushbury South and Low Hill                       2016-05-05 0 0           PP52   0
10001 17846 Ann Jenkins         32 party:90 Liberal Democrats MTW:E05001325 Bushbury South and Low Hill                       2016-05-05 0 0           PP90   0
10002 17847 Aaron Andrew Hall         32 party:52 Conservative and Unionist Party MTW:E05001326 East Park                       2016-05-05 0 0           PP52   0
10003 17848 Terry Hancox         32 party:63 Green Party MTW:E05001326 East Park                       2016-05-05 0 0           PP63   0
10004 17849 James Leyshon         32 party:85 UK Independence Party (UKIP) MTW:E05001326 East Park                       2016-05-05 0 0           PP85   0
10005 17850 Anwen Dawn Muston Ms   Female 1956-01-09 32 party:53 Labour Party MTW:E05001326 East Park   1.0   https://eastparklabour.wordpress.com/               2016-05-05 0 0           PP53   0
10006 17851 William of Shropshire         32 ynmp-party:2 Independent MTW:E05001326 East Park                       2016-05-05 0 0           ynmp-party:2   0
10007 17852 Adam Ansari         32 party:52 Conservative and Unionist Party MTW:E05001327 Ettingshall                       2016-05-05 0 0           PP52   0
10008 17853 Jennifer Cooper         32 party:73 Socialist Labour Party MTW:E05001327 Ettingshall                       2016-05-05 0 0           PP73   0
10009 17854 Zee Russell         32 party:53 Labour Party MTW:E05001327 Ettingshall   1.0                   2016-05-05 0 0           PP53   0
10010 17855 Ian Brookfield         32 party:53 Labour Party MTW:E05001328 Fallings Park   1.0                   2016-05-05 0 0           PP53   0
10011 17856 Tracey Dawn Jukes         32 party:85 UK Independence Party (UKIP) MTW:E05001328 Fallings Park                       2016-05-05 0 0           PP85   0
10012 17857 Peter Nixon         32 party:90 Liberal Democrats MTW:E05001328 Fallings Park                       2016-05-05 0 0           PP90   0
10013 17858 Giuliano Ivanov Pisarski         32 party:52 Conservative and Unionist Party MTW:E05001328 Fallings Park                       2016-05-05 0 0           PP52   0
10014 17859 David John Belcher         32 party:63 Green Party MTW:E05001329 Graiseley                       2016-05-05 0 0           PP63   0
10015 17860 Jas Boparai         32 party:52 Conservative and Unionist Party MTW:E05001329 Graiseley                       2016-05-05 0 0           PP52   0
10016 17861 John Charles Reynolds         32 joint-party:53-119 Labour and Co-operative Party MTW:E05001329 Graiseley   1.0                   2016-05-05 0 0           joint-party:53-119   0
10017 17862 Kieran Patrick Smith         32 party:90 Liberal Democrats MTW:E05001329 Graiseley                       2016-05-05 0 0           PP90   0
10018 17863 Alan William Bamber         32 party:90 Liberal Democrats MTW:E05001330 Heath Town                       2016-05-05 0 0           PP90   0
10019 17864 Jasbir Kaur Jaspal     Female   32 party:53 Labour Party MTW:E05001330 Heath Town   1.0 http://www.wolverhamptonlabour.com/wards/heath-town/jasbir-jaspal                 2016-05-05 0 0           PP53   0
10020 17865 Fortune Sibanda         32 party:52 Conservative and Unionist Party MTW:E05001330 Heath Town                       2016-05-05 0 0           PP52   0
10021 17866 Jarrad Williams         32 party:804 Trade Unionist and Socialist Coalition MTW:E05001330 Heath Town                       2016-05-05 0 0           PP804   0
10022 17867 Alan David Bolshaw     Male   32 party:53 Labour Party MTW:E05001331 Merry Hill   1.0 http://www.wolverhamptonlabour.com/wards/merry-hill/alan-bolshaw       https://static-candidates.democracyclub.org.uk/media/images/images/17867.png   profile-photo ClaireDarke From Labour party website 2016-05-05 0 0           PP53   0
10023 17868 Carl James Husted         32 party:52 Conservative and Unionist Party MTW:E05001331 Merry Hill                       2016-05-05 0 0           PP52   0
10024 17869 Henry Obi         32 party:63 Green Party MTW:E05001331 Merry Hill                       2016-05-05 0 0           PP63   0
10025 17870 Jessica Rose Pringle         32 party:90 Liberal Democrats MTW:E05001331 Merry Hill                       2016-05-05 0 0           PP90   0
10026 17871 Louise Margaret Miles         32 party:53 Labour Party MTW:E05001332 Oxley   1.0                   2016-05-05 0 0           PP53   0
10027 17872 Robert Edward Quarmby         32 party:90 Liberal Democrats MTW:E05001332 Oxley                       2016-05-05 0 0           PP90   0
10028 17873 Neil David Turner         32 party:52 Conservative and Unionist Party MTW:E05001332 Oxley                       2016-05-05 0 0           PP52   0
10029 17874 Claire Darke     female   32 party:53 Labour Party MTW:E05001333 Park   1.0 http://www.wolverhamptonlabour.com/wards/park/claire-darke       https://static-candidates.democracyclub.org.uk/media/images/images/17874.png   copyright-assigned ClaireDarke   2016-05-05 0 0           PP53   0
10030 17875 Kamran Khan         32 party:52 Conservative and Unionist Party MTW:E05001333 Park                       2016-05-05 0 0           PP52   0
10031 17876 Bryan Hamer Lewis         32 party:90 Liberal Democrats MTW:E05001333 Park                       2016-05-05 0 0           PP90   0
10032 17882 Simon Bennett Mr   male 1989-04-25 32 party:52 Conservative and Unionist Party MTW:E05001334 Penn           https://uk.linkedin.com/in/simonbennett89 https://static-candidates.democracyclub.org.uk/media/images/images/17882.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52 Chocolate covered Malted Milks 0
10033 17883 Jeffrey William Hemsley         32 party:90 Liberal Democrats MTW:E05001334 Penn                       2016-05-05 0 0           PP90   0
10034 17884 Martin Wintour Waite         32 party:53 Labour Party MTW:E05001334 Penn   1.0                   2016-05-05 0 0           PP53   0
10035 17886 Savita Sehdev         32 party:52 Conservative and Unionist Party MTW:E05001336 Spring Vale                       2016-05-05 0 0           PP52   0
10036 17887 Mak Singh         32 party:53 Labour Party MTW:E05001336 Spring Vale   1.0                   2016-05-05 0 0           PP53   0
10037 17888 Hazel Thomas         32 party:85 UK Independence Party (UKIP) MTW:E05001336 Spring Vale                       2016-05-05 0 0           PP85   0
10038 17889 Rachel Arnold         32 party:63 Green Party MTW:E05001335 St Peter's                       2016-05-05 0 0           PP63   0
10039 17890 Sohail Khan         32 party:52 Conservative and Unionist Party MTW:E05001335 St Peter's                       2016-05-05 0 0           PP52   0
10040 17891 Roger Charles Lawrence     Male   32 joint-party:53-119 Labour and Co-operative Party MTW:E05001335 St Peter's   1.0 http://www.wolverhamptonlabour.com/wards/st-peters/roger-lawrence                 2016-05-05 0 0           joint-party:53-119   0
10041 17892 Mark Edmund Evans         32 party:52 Conservative and Unionist Party MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP52   0
10042 17893 Peter George Hollis         32 party:90 Liberal Democrats MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP90   0
10043 17894 Doug Hope         32 party:85 UK Independence Party (UKIP) MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP85   0
10044 17895 Chester Morrison         32 party:53 Labour Party MTW:E05001337 Tettenhall Regis                       2016-05-05 0 0           PP53   0
10045 17896 Udey Singh Cllr   Male   32 party:52 Conservative and Unionist Party MTW:E05001337 Tettenhall Regis   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/17896.png   copyright-assigned Udey   2016-05-05 0 0           PP52 Cream Custard 0
10046 17897 Frances Kathleen Heap         32 party:90 Liberal Democrats MTW:E05001338 Tettenhall Wightwick                       2016-05-05 0 0           PP90   0
10047 17898 John Pitt         32 party:63 Green Party MTW:E05001338 Tettenhall Wightwick                       2016-05-05 0 0           PP63   0
10048 17899 Phil Walker         32 party:53 Labour Party MTW:E05001338 Tettenhall Wightwick                       2016-05-05 0 0           PP53   0
10049 17900 Philip Thomas Alexander Bateman         32 joint-party:53-119 Labour and Co-operative Party MTW:E05001339 Wednesfield North   1.0                   2016-05-05 0 0           joint-party:53-119   0
10050 17901 Lee Harris         32 party:63 Green Party MTW:E05001339 Wednesfield North                       2016-05-05 0 0           PP63   0
10051 17902 Andrew Scott Randle         32 party:52 Conservative and Unionist Party MTW:E05001339 Wednesfield North                       2016-05-05 0 0           PP52   0
10052 34181 Sarah Quarmby Mrs   female 1991.0 32 party:90 Liberal Democrats MTW:E05001336 Spring Vale     http://www.libdems.org.uk/sarah_quarmby       https://static-candidates.democracyclub.org.uk/media/images/images/17885.png   copyright-assigned sarahquarmby Candidate is allowing the use 2016-05-05 0 0   17885.0       PP90   0
Powered by Datasette · Query took 0.92ms