home / democracyclub

democracyclub

Custom SQL query returning 13 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
8203 19601 Kate Bramson         4 party:52 Conservative and Unionist Party LBW:E05000538 College ward                       2016-05-05 0 0           PP52   0
8204 19602 Brigid Gardner Ms   Female   4 party:90 Liberal Democrats LBW:E05000538 College ward     http://www.southwark-libdems.org.uk/dulwich_village_candidates       https://static-candidates.democracyclub.org.uk/media/images/images/36112.png   profile-photo JackyC123 The photo is on the candidate's website 2016-05-05 0 0   36112.0       PP90   0
8205 19603 Denis Pougin         4 party:2137 All People's Party LBW:E05000538 College ward                       2016-05-05 0 0           PP2137   0
8206 19604 Toby Prescott         4 party:85 UK Independence Party (UKIP) LBW:E05000538 College ward                       2016-05-05 0 0           PP85   0
8207 19605 Dale Leslie Rapley     male   4 party:63 Green Party LBW:E05000538 College ward             https://static-candidates.democracyclub.org.uk/media/images/images/19605.png   profile-photo bookshelf   2016-05-05 0 0           PP63   0
8208 19611 Siobhan Gite Aarons         4 party:52 Conservative and Unionist Party LBW:E05000544 Newington ward                       2016-05-05 0 0           PP52   0
8209 19612 Terry Adewale         4 party:2137 All People's Party LBW:E05000544 Newington ward                       2016-05-05 0 0           PP2137   0
8210 19613 Michelle Deborah Baharier         4 ynmp-party:2 Independent LBW:E05000544 Newington ward                       2016-05-05 0 0           ynmp-party:2   0
8211 19614 James Coldwell     male   4 party:53 Labour Party LBW:E05000544 Newington ward     http://www.southwarklabour.co.uk/2018wards/newington.aspx       https://static-candidates.democracyclub.org.uk/media/images/images/19614.png   profile-photo roy2 Photo is from Southwark Labour party website - http://www.southwarklabour.co.uk/2018wards/newington.aspx 2016-05-05 0 0           PP53   0
8212 19615 Nick Hooper         4 party:63 Green Party LBW:E05000544 Newington ward                       2016-05-05 0 0           PP63   0
8213 19616 Martin Shapland         4 party:90 Liberal Democrats LBW:E05000544 Newington ward                       2016-05-05 0 0           PP90   0
8214 19617 Gawain Howard Wilkinson Towler         4 party:85 UK Independence Party (UKIP) LBW:E05000544 Newington ward                       2016-05-05 0 0           PP85   0
8215 48117 Catherine Rose         4 party:53 Labour Party LBW:E05000538 College ward                       2016-05-05 0 0   19606.0       PP53   0
Powered by Datasette · Query took 0.435ms