home / democracyclub

democracyclub

Custom SQL query returning 46 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
15488 1346 Kevin White     male 1972-12-16 99 party:63 Green Party DIW:E05007876 Lodge Park     https://my.greenparty.org.uk/candidates/106146 http://www.redditchgreens.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/54bd390bead6762e54811af6.png         2016-05-05 0 0           PP63   0
15489 4011 Jonathan Oakton     male   99 party:85 UK Independence Party (UKIP) DIW:E05007872 Church Hill                       2016-05-05 0 0           PP85   0
15490 4255 John Fisher     male   99 party:53 Labour Party DIW:E05007877 Matchborough     https://vote.labour.org.uk/gary-john-fisher       https://static-candidates.democracyclub.org.uk/media/images/5481e796b150e238702c0548.png   profile-photo     2016-05-05 0 0   18262.0       PP53   0
15491 18189 Ann Gee         99 party:90 Liberal Democrats DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0           PP90   0
15492 18190 Len Harris         99 party:85 UK Independence Party (UKIP) DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0           PP85   0
15493 18191 Pattie Hill     Female   99 party:53 Labour Party DIW:E05007870 Batchley & Brockhill       http://worcestershire.moderngov.co.uk/mgUserInfo.aspx?UID=72     https://static-candidates.democracyclub.org.uk/media/images/images/18191.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
15494 18192 Scott Royston Torrington         99 party:52 Conservative and Unionist Party DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0           PP52   0
15495 18202 Salman Akbar         99 party:52 Conservative and Unionist Party DIW:E05007871 Central                       2016-05-05 0 0           PP52   0
15496 18203 Trevor Stephen Blake         99 party:85 UK Independence Party (UKIP) DIW:E05007871 Central                       2016-05-05 0 0           PP85   0
15497 18204 Tom Bowes         99 party:63 Green Party DIW:E05007871 Central                       2016-05-05 0 0           PP63   0
15498 18205 Greg Chance         99 party:53 Labour Party DIW:E05007871 Central                       2016-05-05 0 0           PP53   0
15499 18206 Diane Elizabeth Thomas         99 party:90 Liberal Democrats DIW:E05007871 Central                       2016-05-05 0 0           PP90   0
15500 18217 David Howard Gee         99 party:90 Liberal Democrats DIW:E05007872 Church Hill                       2016-05-05 0 0   24235.0       PP90   0
15501 18218 Bill Hartnett         99 party:53 Labour Party DIW:E05007872 Church Hill                       2016-05-05 0 0           PP53   0
15502 18219 Robert Daniel Wardell         99 party:63 Green Party DIW:E05007872 Church Hill                       2016-05-05 0 0   24238.0       PP63   0
15503 18220 Pamela Mary Williams         99 party:52 Conservative and Unionist Party DIW:E05007872 Church Hill                       2016-05-05 0 0           PP52   0
15504 18221 Agnes Beatrix Winczek         99 ynmp-party:2 Independent DIW:E05007872 Church Hill                       2016-05-05 0 0           ynmp-party:2   0
15505 18231 Joe Baker         99 party:53 Labour Party DIW:E05007874 Greenlands                       2016-05-05 0 0   24231.0       PP53   0
15506 18232 Chris Harrison         99 party:85 UK Independence Party (UKIP) DIW:E05007874 Greenlands                       2016-05-05 0 0           PP85   0
15507 18233 Tony Pitt         99 party:90 Liberal Democrats DIW:E05007874 Greenlands                       2016-05-05 0 0           PP90   0
15508 18234 Mal Ullah         99 party:52 Conservative and Unionist Party DIW:E05007874 Greenlands                       2016-05-05 0 0           PP52   0
15509 18235 Rylma Elaine White         99 party:63 Green Party DIW:E05007874 Greenlands                       2016-05-05 0 0   24239.0       PP63   0
15510 18236 Roger Michael Bennett         99 party:52 Conservative and Unionist Party DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP52   0
15511 18237 Margaret Hindle         99 party:90 Liberal Democrats DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP90   0
15512 18238 Nayab Patel     female   99 party:53 Labour Party DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP53   0
15513 18239 Scott Duncan Preston         99 party:85 UK Independence Party (UKIP) DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP85   0
15514 18240 Alistair Derek Waugh         99 party:63 Green Party DIW:E05007875 Headless Cross and Oakenshaw                       2016-05-05 0 0           PP63   0
15515 18257 Les Rogers         99 party:85 UK Independence Party (UKIP) DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP85   0
15516 18258 Mark Henry Shurmer         99 party:53 Labour Party DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP53   0
15517 18259 Craig Warhurst         99 party:52 Conservative and Unionist Party DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP52   0
15518 18260 Ian David Webster         99 party:90 Liberal Democrats DIW:E05007876 Lodge Park                       2016-05-05 0 0           PP90   0
15519 18261 Louise Deveney         99 party:63 Green Party DIW:E05007877 Matchborough                       2016-05-05 0 0           PP63   0
15520 18263 Simon Brookes Oliver         99 party:90 Liberal Democrats DIW:E05007877 Matchborough                       2016-05-05 0 0           PP90   0
15521 18264 Jim Swansborough         99 party:85 UK Independence Party (UKIP) DIW:E05007877 Matchborough                       2016-05-05 0 0           PP85   0
15522 18265 Alexandra Beverley Kay Williams         99 party:52 Conservative and Unionist Party DIW:E05007877 Matchborough                       2016-05-05 0 0           PP52   0
15523 18266 Matt Dormer         99 party:52 Conservative and Unionist Party DIW:E05007878 West                       2016-05-05 0 0           PP52   0
15524 18267 Mike Lewington         99 party:53 Labour Party DIW:E05007878 West                       2016-05-05 0 0           PP53   0
15525 18268 Russell Patrick Taylor         99 party:90 Liberal Democrats DIW:E05007878 West                       2016-05-05 0 0           PP90   0
15526 18269 Simon Edward Venables         99 party:63 Green Party DIW:E05007878 West                       2016-05-05 0 0           PP63   0
15527 18270 Julie Ann Walford         99 party:85 UK Independence Party (UKIP) DIW:E05007878 West                       2016-05-05 0 0           PP85   0
15528 18271 Emma Louise Bradley         99 party:63 Green Party DIW:E05007879 Winyates                       2016-05-05 0 0           PP63   0
15529 18272 Kathy Haslam         99 party:85 UK Independence Party (UKIP) DIW:E05007879 Winyates                       2016-05-05 0 0           PP85   0
15530 18273 John Hyams         99 party:52 Conservative and Unionist Party DIW:E05007879 Winyates                       2016-05-05 0 0           PP52   0
15531 18274 Yvonne Smith         99 party:53 Labour Party DIW:E05007879 Winyates                       2016-05-05 0 0           PP53   0
15532 18275 Hans Windheuser         99 party:90 Liberal Democrats DIW:E05007879 Winyates                       2016-05-05 0 0   24240.0       PP90   0
15533 19423 Steve Pound         99 party:63 Green Party DIW:E05007870 Batchley & Brockhill                       2016-05-05 0 0   32798.0       PP63   0
Powered by Datasette · Query took 0.686ms