home / democracyclub

democracyclub

Custom SQL query returning 61 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
12479 739 Roy Leonard Sandison     male   62 party:63 Green Party DIW:E05008981 New Bilton                       2016-05-05 0 0   18545.0       PP63   0
12480 5529 Pete McLaren     male   62 party:804 Trade Unionist and Socialist Coalition DIW:E05010760 Wolston and the Lawfords       http://www.rugbytusc.com/     https://static-candidates.democracyclub.org.uk/media/images/5547b16ff0745ae61e5c2791.png   profile-photo andylolz From party PPC page: http://tusc2015.com/pete-mclaren-for-rugby/ 2016-05-05 0 0           PP804   0
12481 5530 Terence White     male 1992-09-17 62 party:90 Liberal Democrats DIW:E05008979 Hillmorton             https://static-candidates.democracyclub.org.uk/media/images/551a0a4bb989d5e837ae99e2.png   profile-photo terry I own this photo 2016-05-05 0 0   18527.0       PP90   0
12482 14111 Peter James Butlin         62 party:52 Conservative and Unionist Party DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP52   0
12483 14112 Lee Martin Chase         62 party:90 Liberal Democrats DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP90   0
12484 14113 Steve Edkins         62 party:804 Trade Unionist and Socialist Coalition DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP804   0
12485 14114 Hamish Livingstone         62 party:53 Labour Party DIW:E05010758 Admirals and Cawston                       2016-05-05 0 0           PP53   0
12486 14115 Graham Bliss     male   62 party:63 Green Party DIW:E05008974 Benn     https://my.greenparty.org.uk/candidates/106159       https://static-candidates.democracyclub.org.uk/media/images/images/14115.png   profile-photo J https://my.greenparty.org.uk/candidates/106159 2016-05-05 0 0           PP63   0
12487 14116 Charlie Hull         62 party:52 Conservative and Unionist Party DIW:E05008974 Benn                       2016-05-05 0 0           PP52   0
12488 14117 Maggie O'Rourke     female   62 party:53 Labour Party DIW:E05008974 Benn     http://www.rugbylabour.co.uk/maggie_o_rourke                 2016-05-05 0 0           PP53   0
12489 14118 Alex Speirs         62 party:85 UK Independence Party (UKIP) DIW:E05008974 Benn                       2016-05-05 0 0           PP85   0
12490 14119 Hugh Trimble         62 party:90 Liberal Democrats DIW:E05008974 Benn                       2016-05-05 0 0   33257.0       PP90   0
12491 14135 Julie Beverly A'Barrow         62 party:52 Conservative and Unionist Party DIW:E05008975 Bilton                       2016-05-05 0 0           PP52   0
12492 14136 Elizabeth Bull         62 party:85 UK Independence Party (UKIP) DIW:E05008975 Bilton                       2016-05-05 0 0           PP85   0
12493 14137 Lesley Mary George         62 party:90 Liberal Democrats DIW:E05008975 Bilton                       2016-05-05 0 0           PP90   0
12494 14138 Pawel Lukas Ignatowicz         62 party:53 Labour Party DIW:E05008975 Bilton                       2016-05-05 0 0           PP53   0
12495 14139 Steven Michael Wright         62 party:63 Green Party DIW:E05008975 Bilton                       2016-05-05 0 0           PP63   0
12496 14158 Leigh Simone Hunt         62 party:52 Conservative and Unionist Party DIW:E05008976 Clifton, Newton and Churchover ward                       2016-05-05 0 0           PP52   0
12497 14159 Catherine Lisa Rose         62 party:53 Labour Party DIW:E05008976 Clifton, Newton and Churchover ward                       2016-05-05 0 0           PP53   0
12498 14160 Keith Ward         62 party:90 Liberal Democrats DIW:E05008976 Clifton, Newton and Churchover ward                       2016-05-05 0 0           PP90   0
12499 14180 Gwendoline Hotten         62 party:90 Liberal Democrats DIW:E05008977 Coton and Boughton                       2016-05-05 0 0           PP90   0
12500 14181 David Mclean         62 party:85 UK Independence Party (UKIP) DIW:E05008977 Coton and Boughton                       2016-05-05 0 0           PP85   0
12501 14182 Carolyn Ann Robbins         62 party:52 Conservative and Unionist Party DIW:E05008977 Coton and Boughton                       2016-05-05 0 0           PP52   0
12502 14183 Alan Charles Webb     male   62 party:53 Labour Party DIW:E05008977 Coton and Boughton     http://www.rugbylabour.co.uk/alan_webb                 2016-05-05 0 0           PP53   0
12503 18476 Bob Hughes     male   62 party:53 Labour Party DIW:E05010759 Dunsmore     http://www.rugbylabour.co.uk/bob_hughes       https://static-candidates.democracyclub.org.uk/media/images/images/18476.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
12504 18477 Ian James Picker         62 party:52 Conservative and Unionist Party DIW:E05010759 Dunsmore                       2016-05-05 0 0           PP52   0
12505 18478 Howard David Roberts         62 ynmp-party:2 Independent DIW:E05010759 Dunsmore                       2016-05-05 0 0           ynmp-party:2   0
12506 18496 Robert Johnson         62 party:804 Trade Unionist and Socialist Coalition DIW:E05008986 Eastlands                       2016-05-05 0 0           PP804   0
12507 18497 Frank McGowan         62 party:85 UK Independence Party (UKIP) DIW:E05008986 Eastlands                       2016-05-05 0 0           PP85   0
12508 18498 Tony Meeson         62 party:52 Conservative and Unionist Party DIW:E05008986 Eastlands                       2016-05-05 0 0           PP52   0
12509 18499 Peter Stephen Reynolds         62 party:63 Green Party DIW:E05008986 Eastlands                       2016-05-05 0 0           PP63   0
12510 18500 Sue Roodhouse         62 party:90 Liberal Democrats DIW:E05008986 Eastlands                       2016-05-05 0 0           PP90   0
12511 18501 Steve Weston         62 party:53 Labour Party DIW:E05008986 Eastlands                       2016-05-05 0 0           PP53   0
12512 18524 David Dick Cranham         62 party:52 Conservative and Unionist Party DIW:E05008979 Hillmorton                       2016-05-05 0 0           PP52   0
12513 18525 Jim Ellis     male   62 party:53 Labour Party DIW:E05008979 Hillmorton     http://www.rugbylabour.co.uk/jim_ellis https://d3n8a8pro7vhmx.cloudfront.net/labourclp140/pages/298/attachments/original/1523396688/hillmorton_final_.pdf?1523396688     https://static-candidates.democracyclub.org.uk/media/images/images/18525.png   profile-photo sjorford http://www.rugbylabour.co.uk/jim_ellis 2016-05-05 0 0           PP53   0
12514 18526 Paul Machin         62 party:63 Green Party DIW:E05008979 Hillmorton                       2016-05-05 0 0           PP63   0
12515 18528 Patricia Wyatt         62 party:85 UK Independence Party (UKIP) DIW:E05008979 Hillmorton                       2016-05-05 0 0           PP85   0
12516 18542 Ally MacGregor         62 party:804 Trade Unionist and Socialist Coalition DIW:E05008981 New Bilton                       2016-05-05 0 0           PP804   0
12517 18543 Kevin Paul McLoughlin         62 party:52 Conservative and Unionist Party DIW:E05008981 New Bilton                       2016-05-05 0 0           PP52   0
12518 18544 Ish Mistry     male   62 party:53 Labour Party DIW:E05008981 New Bilton     http://www.rugbylabour.co.uk/ish_mistry                 2016-05-05 0 0           PP53   0
12519 18546 Hossain Tafazzal         62 party:90 Liberal Democrats DIW:E05008981 New Bilton                       2016-05-05 0 0           PP90   0
12520 18547 Kieren Richard George Brown     male   62 party:53 Labour Party DIW:E05008982 Newbold and Brownsover             https://static-candidates.democracyclub.org.uk/media/images/images/18547.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
12521 18548 Lorna Dunleavy         62 party:63 Green Party DIW:E05008982 Newbold and Brownsover                       2016-05-05 0 0           PP63   0
12522 18549 Sara Elizabeth Last         62 party:52 Conservative and Unionist Party DIW:E05008982 Newbold and Brownsover                       2016-05-05 0 0           PP52   0
12523 18550 Jerome Vincent Perrier         62 party:90 Liberal Democrats DIW:E05008982 Newbold and Brownsover                       2016-05-05 0 0           PP90   0
12524 18551 Kenneth Armstrong         62 party:85 UK Independence Party (UKIP) DIW:E05008983 Paddox                       2016-05-05 0 0           PP85   0
12525 18552 Tim Douglas         62 party:90 Liberal Democrats DIW:E05008983 Paddox                       2016-05-05 0 0           PP90   0
12526 18553 Greg Lyttle         62 party:52 Conservative and Unionist Party DIW:E05008983 Paddox                       2016-05-05 0 0           PP52   0
12527 18554 Julie-Ann Machin         62 party:63 Green Party DIW:E05008983 Paddox                       2016-05-05 0 0           PP63   0
12528 18555 Janine O'Brien         62 party:53 Labour Party DIW:E05008983 Paddox                       2016-05-05 0 0           PP53   0
12529 18562 Rob Bevin         62 party:53 Labour Party DIW:E05008984 Revel and Binley Woods                       2016-05-05 0 0           PP53   0
12530 18563 John Edward Birch         62 party:85 UK Independence Party (UKIP) DIW:E05008984 Revel and Binley Woods                       2016-05-05 0 0           PP85   0
12531 18564 Tony Gillias         62 party:52 Conservative and Unionist Party DIW:E05008984 Revel and Binley Woods                       2016-05-05 0 0           PP52   0
12532 18565 Howard Avis     male   62 party:53 Labour Party DIW:E05008985 Rokeby and Overslade           https://www.linkedin.com/in/howard-avis-73b0b126/           2016-05-05 0 0           PP53   0
12533 18566 Kate Crowley         62 party:63 Green Party DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP63   0
12534 18567 Carie-Anne Dumbleton         62 party:90 Liberal Democrats DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP90   0
12535 18568 Ravi Bipin Mistry         62 party:52 Conservative and Unionist Party DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP52   0
12536 18569 Julie Dawn Weekes         62 party:804 Trade Unionist and Socialist Coalition DIW:E05008985 Rokeby and Overslade                       2016-05-05 0 0           PP804   0
12537 18579 Sally Drayton Bragg         62 party:52 Conservative and Unionist Party DIW:E05010760 Wolston and the Lawfords                       2016-05-05 0 0           PP52   0
12538 18580 Doreen Cox         62 party:53 Labour Party DIW:E05010760 Wolston and the Lawfords                       2016-05-05 0 0           PP53   0
12539 18581 Elanor Roderick         62 party:63 Green Party DIW:E05010760 Wolston and the Lawfords                       2016-05-05 0 0           PP63   0
Powered by Datasette · Query took 0.757ms