home / democracyclub

democracyclub

Custom SQL query returning 67 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
12540 1337 Alan Bullion     male 1956-07-10 63 party:90 Liberal Democrats DIW:E05005134 Culverden     http://www.libdems.org.uk/alan_bullion     https://www.linkedin.com/pub/alan-bullion/4/835/141 https://static-candidates.democracyclub.org.uk/media/images/5481e94fb150e238702c0655.png   profile-photo     2016-05-05 0 0   10642.0       PP90   0
12541 2154 Lorna Blackmore     female   63 party:53 Labour Party DIW:E05005140 Pantiles and St Mark's                       2016-05-05 0 0           PP53   0
12542 4553 Colin Nicholson     male   63 party:85 UK Independence Party (UKIP) DIW:E05005143 Rusthall             https://static-candidates.democracyclub.org.uk/media/images/55390a0d539d9492693b0971.png   profile-photo JPCarrington Profile picture used on party's official PPC site here: http://www.myukip.com/parliamentary-candidates-t-z.html 2016-05-05 0 0           PP85   0
12543 4946 Kevin Kerrigan     male   63 party:53 Labour Party DIW:E05005131 Brenchley and Horsmonden     http://www.labour.org.uk/people/detail/kevin-kerrigan http://www.tunbridgewellslabour.org.uk/kevin-kerrigan-for-mp/     https://static-candidates.democracyclub.org.uk/media/images/54898a0f446a57290ed83c55.png   profile-photo     2016-05-05 0 0   10632.0       PP53   0
12544 6817 Jane March     Female   63 party:52 Conservative and Unionist Party DIW:E05005131 Brenchley and Horsmonden     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/March_Jane.aspx                 2016-05-05 0 0           PP52   0
12545 10627 Simon Hilton         63 party:85 UK Independence Party (UKIP) DIW:E05005130 Benenden and Cranbrook                       2016-05-05 0 0           PP85   0
12546 10628 Sean Holden     male   63 party:52 Conservative and Unionist Party DIW:E05005130 Benenden and Cranbrook   1.0 http://www.kentconservatives2017.uk/candidates/sean_holden/       https://static-candidates.democracyclub.org.uk/media/images/images/10628.png   other gregorywilliams https://democracy.kent.gov.uk/mgUserInfo.aspx?UID=28852 2016-05-05 0 0           PP52   0
12547 10629 Isobel Clare Kerrigan         63 party:53 Labour Party DIW:E05005130 Benenden and Cranbrook                       2016-05-05 0 0           PP53   0
12548 10630 Matthew Richard John Warne         63 party:90 Liberal Democrats DIW:E05005130 Benenden and Cranbrook                       2016-05-05 0 0           PP90   0
12549 10631 Thomas Chetta         63 party:85 UK Independence Party (UKIP) DIW:E05005131 Brenchley and Horsmonden                       2016-05-05 0 0           PP85   0
12550 10633 Barbara Gladys Cobbold         63 party:52 Conservative and Unionist Party DIW:E05005132 Broadwater   1.0                   2016-05-05 0 0           PP52   0
12551 10634 James Ketteringham         63 party:53 Labour Party DIW:E05005132 Broadwater                       2016-05-05 0 0           PP53   0
12552 10635 Marguerita Morton         63 party:90 Liberal Democrats DIW:E05005132 Broadwater                       2016-05-05 0 0           PP90   0
12553 10636 Mark Robert Nicholson         63 party:85 UK Independence Party (UKIP) DIW:E05005132 Broadwater                       2016-05-05 0 0           PP85   0
12554 10637 Ken Gillard         63 party:85 UK Independence Party (UKIP) DIW:E05005133 Capel ward                       2016-05-05 0 0           PP85   0
12555 10638 Carol Ann Mackonochie         63 party:52 Conservative and Unionist Party DIW:E05005133 Capel ward                       2016-05-05 0 0           PP52   0
12556 10639 Raymond Peter Moon         63 party:53 Labour Party DIW:E05005133 Capel ward                       2016-05-05 0 0           PP53   0
12557 10640 Hugh David Patterson         63 party:90 Liberal Democrats DIW:E05005133 Capel ward                       2016-05-05 0 0           PP90   0
12558 10641 Ronen Basu         63 party:52 Conservative and Unionist Party DIW:E05005134 Culverden   1.0                   2016-05-05 0 0           PP52   0
12559 10643 Richard Leslie         63 party:63 Green Party DIW:E05005134 Culverden                       2016-05-05 0 0           PP63   0
12560 10644 Stephen Geza Lukacs         63 party:85 UK Independence Party (UKIP) DIW:E05005134 Culverden                       2016-05-05 0 0           PP85   0
12561 10645 Carol Wilson         63 party:53 Labour Party DIW:E05005134 Culverden                       2016-05-05 0 0           PP53   0
12562 10646 Russ Bishop         63 party:85 UK Independence Party (UKIP) DIW:E05005136 Goudhurst and Lamberhurst                       2016-05-05 0 0           PP85   0
12563 10647 Simon James Fowler         63 party:53 Labour Party DIW:E05005136 Goudhurst and Lamberhurst                       2016-05-05 0 0           PP53   0
12564 10648 Barry Noakes         63 party:52 Conservative and Unionist Party DIW:E05005136 Goudhurst and Lamberhurst   1.0                   2016-05-05 0 0           PP52   0
12565 10649 Nancy Warne         63 party:90 Liberal Democrats DIW:E05005136 Goudhurst and Lamberhurst                       2016-05-05 0 0           PP90   0
12566 10650 John Austen         63 party:85 UK Independence Party (UKIP) DIW:E05005137 Hawkhurst and Sandhurst                       2016-05-05 0 0           PP85   0
12567 10651 David Burgess         63 party:53 Labour Party DIW:E05005137 Hawkhurst and Sandhurst                       2016-05-05 0 0           PP53   0
12568 10652 Thomas Camille Deacon         63 party:90 Liberal Democrats DIW:E05005137 Hawkhurst and Sandhurst                       2016-05-05 0 0           PP90   0
12569 10653 Beverley Sara Palmer         63 party:52 Conservative and Unionist Party DIW:E05005137 Hawkhurst and Sandhurst                       2016-05-05 0 0           PP52   0
12570 10663 Leonard Horwood         63 party:52 Conservative and Unionist Party DIW:E05005140 Pantiles and St Mark's   1.0                   2016-05-05 0 0           PP52   0
12571 10664 John Anthony Hurst     male   63 party:63 Green Party DIW:E05005140 Pantiles and St Mark's                       2016-05-05 0 0   27466.0       PP63   0
12572 10665 Dominic James Alexander Mathon         63 party:90 Liberal Democrats DIW:E05005140 Pantiles and St Mark's                       2016-05-05 0 0           PP90   0
12573 10666 Christopher Robert Stevenson         63 party:85 UK Independence Party (UKIP) DIW:E05005140 Pantiles and St Mark's                       2016-05-05 0 0           PP85   0
12574 10669 Peter Eric Bulman         63 party:52 Conservative and Unionist Party DIW:E05005141 Park   1.0                   2016-05-05 0 0           PP52   0
12575 10670 Gillian Douglass         63 party:90 Liberal Democrats DIW:E05005141 Park                       2016-05-05 0 0           PP90   0
12576 10671 Hazel Joyce Kelly         63 party:85 UK Independence Party (UKIP) DIW:E05005141 Park                       2016-05-05 0 0           PP85   0
12577 10672 Nick Maltby         63 party:53 Labour Party DIW:E05005141 Park                       2016-05-05 0 0           PP53   0
12578 10673 James Robert Cole         63 party:90 Liberal Democrats DIW:E05005142 Pembury                       2016-05-05 0 0           PP90   0
12579 10674 Margaret Morgan         63 party:53 Labour Party DIW:E05005142 Pembury                       2016-05-05 0 0           PP53   0
12580 10675 David Patrick Reilly         63 party:52 Conservative and Unionist Party DIW:E05005142 Pembury                       2016-05-05 0 0           PP52   0
12581 10676 David Weatherley         63 party:85 UK Independence Party (UKIP) DIW:E05005142 Pembury                       2016-05-05 0 0           PP85   0
12582 10682 Alex Britcher         63 party:53 Labour Party DIW:E05005143 Rusthall                       2016-05-05 0 0           PP53   0
12583 10683 David Charles Holton         63 party:63 Green Party DIW:E05005143 Rusthall                       2016-05-05 0 0           PP63   0
12584 10684 Isla Megan McLachlan         63 party:90 Liberal Democrats DIW:E05005143 Rusthall                       2016-05-05 0 0           PP90   0
12585 10685 Joy Ann Podbury         63 party:52 Conservative and Unionist Party DIW:E05005143 Rusthall   1.0                   2016-05-05 0 0           PP52   0
12586 10690 Martin Roland Betts         63 party:53 Labour Party DIW:E05005146 Sherwood                       2016-05-05 0 0           PP53   0
12587 10691 Mark Bicknell         63 party:90 Liberal Democrats DIW:E05005146 Sherwood                       2016-05-05 0 0           PP90   0
12588 10692 Chris Hoare     male 1958.0 63 party:85 UK Independence Party (UKIP) DIW:E05005146 Sherwood             https://static-candidates.democracyclub.org.uk/media/images/images/10692.png   other gregorywilliams https://democracy.kent.gov.uk/mgUserInfo.aspx?UID=27645 2016-05-05 0 0   29182.0       PP85   0
12589 10693 Frank Williams         63 party:52 Conservative and Unionist Party DIW:E05005146 Sherwood   1.0                   2016-05-05 0 0           PP52   0
12590 10694 Christopher Roger Camp         63 party:52 Conservative and Unionist Party DIW:E05005147 Southborough and High Brooms                       2016-05-05 0 0           PP52   0
12591 10695 Dianne Hill         63 party:53 Labour Party DIW:E05005147 Southborough and High Brooms   1.0                   2016-05-05 0 0           PP53   0
12592 10696 Matt Lyons         63 party:63 Green Party DIW:E05005147 Southborough and High Brooms                       2016-05-05 0 0           PP63   0
12593 10697 Keith Murray-Jenkins         63 party:85 UK Independence Party (UKIP) DIW:E05005147 Southborough and High Brooms                       2016-05-05 0 0           PP85   0
12594 10698 Jo Wright         63 party:90 Liberal Democrats DIW:E05005147 Southborough and High Brooms                       2016-05-05 0 0           PP90   0
12595 10704 William O'Shea         63 party:85 UK Independence Party (UKIP) DIW:E05005149 Speldhurst and Bidborough                       2016-05-05 0 0   29168.0       PP85   0
12596 10705 Julian Stanyer         63 party:52 Conservative and Unionist Party DIW:E05005149 Speldhurst and Bidborough   1.0                   2016-05-05 0 0           PP52   0
12597 10706 Ann Christine Tyler         63 party:53 Labour Party DIW:E05005149 Speldhurst and Bidborough                       2016-05-05 0 0           PP53   0
12598 10713 Harry Roy Allen         63 party:52 Conservative and Unionist Party DIW:E05005144 St James'                       2016-05-05 0 0           PP52   0
12599 10714 Ben Chapelard         63 party:90 Liberal Democrats DIW:E05005144 St James'   1.0                   2016-05-05 0 0           PP90   0
12600 10715 Linda Marie Jagger         63 party:53 Labour Party DIW:E05005144 St James'                       2016-05-05 0 0           PP53   0
12601 10716 Naz Mian         63 party:85 UK Independence Party (UKIP) DIW:E05005144 St James'                       2016-05-05 0 0           PP85   0
12602 10717 Phyllis Valerie Leslie         63 party:63 Green Party DIW:E05005145 St John's                       2016-05-05 0 0           PP63   0
12603 10718 Peter Andrew Lidstone         63 party:90 Liberal Democrats DIW:E05005145 St John's   1.0                   2016-05-05 0 0           PP90   0
12604 10719 Christine Jennifer Marshall         63 party:85 UK Independence Party (UKIP) DIW:E05005145 St John's                       2016-05-05 0 0           PP85   0
12605 10720 Timothy John Rich         63 party:53 Labour Party DIW:E05005145 St John's                       2016-05-05 0 0           PP53   0
12606 10721 David Allister Scott         63 party:52 Conservative and Unionist Party DIW:E05005145 St John's                       2016-05-05 0 0           PP52   0
Powered by Datasette · Query took 0.846ms