home / democracyclub

democracyclub

Custom SQL query returning 54 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
12607 10983 Fiona Drinan         64 party:90 Liberal Democrats DIW:E05004572 Hart Plain                       2016-05-05 0 0           PP90   0
12608 10984 Howard Frank Sherlock         64 party:53 Labour Party DIW:E05004572 Hart Plain                       2016-05-05 0 0           PP53   0
12609 10985 Elaine Louanne Shimbart         64 party:52 Conservative and Unionist Party DIW:E05004572 Hart Plain                       2016-05-05 0 0           PP52   0
12610 13132 Michael Edmund Bolt         64 party:90 Liberal Democrats DIW:E05004566 Barncroft                       2016-05-05 0 0           PP90   0
12611 13133 Brenda Margaret Kerrin         64 party:85 UK Independence Party (UKIP) DIW:E05004566 Barncroft                       2016-05-05 0 0           PP85   0
12612 13134 Phil Pearson         64 party:53 Labour Party DIW:E05004566 Barncroft                       2016-05-05 0 0           PP53   0
12613 13135 Yvonne Margaret Weeks         64 party:52 Conservative and Unionist Party DIW:E05004566 Barncroft                       2016-05-05 0 0           PP52   0
12614 13141 Malc Carpenter         64 party:85 UK Independence Party (UKIP) DIW:E05004567 Battins                       2016-05-05 0 0           PP85   0
12615 13142 Ralph Martin Cousins         64 party:53 Labour Party DIW:E05004567 Battins                       2016-05-05 0 0           PP53   0
12616 13143 Johanna Frances Lowe         64 party:90 Liberal Democrats DIW:E05004567 Battins                       2016-05-05 0 0           PP90   0
12617 13144 Ian Andrew Payne         64 party:52 Conservative and Unionist Party DIW:E05004567 Battins                       2016-05-05 0 0           PP52   0
12618 13145 Philippa Mary Irene Gray     female   64 party:90 Liberal Democrats DIW:E05004568 Bedhampton     http://www.havant-libdems.org/candidates/       https://static-candidates.democracyclub.org.uk/media/images/images/13145.png   profile-photo mattl From http://www.havant-libdems.org/candidates/ 2016-05-05 0 0           PP90   0
12619 13146 Freya Savidge-Conway Mrs   Female 1981.0 64 party:53 Labour Party DIW:E05004568 Bedhampton                       2016-05-05 0 0           PP53   0
12620 13147 Kenneth Patrick Smith         64 party:52 Conservative and Unionist Party DIW:E05004568 Bedhampton                       2016-05-05 0 0           PP52   0
12621 13148 Catherine Billam         64 party:90 Liberal Democrats DIW:E05004569 Bondfields                       2016-05-05 0 0           PP90   0
12622 13149 Terry Hart         64 party:53 Labour Party DIW:E05004569 Bondfields                       2016-05-05 0 0           PP53   0
12623 13150 Curtis Royston Stanfield         64 party:52 Conservative and Unionist Party DIW:E05004569 Bondfields                       2016-05-05 0 0           PP52   0
12624 13151 Geoff Whiffen         64 party:85 UK Independence Party (UKIP) DIW:E05004569 Bondfields                       2016-05-05 0 0           PP85   0
12625 13157 Andrew Boxall         64 party:85 UK Independence Party (UKIP) DIW:E05004570 Cowplain                       2016-05-05 0 0           PP85   0
12626 13158 John Dennis Jacobs         64 party:90 Liberal Democrats DIW:E05004570 Cowplain                       2016-05-05 0 0           PP90   0
12627 13159 David John Keast         64 party:52 Conservative and Unionist Party DIW:E05004570 Cowplain                       2016-05-05 0 0           PP52   0
12628 13160 Ken Monks         64 party:53 Labour Party DIW:E05004570 Cowplain                       2016-05-05 0 0           PP53   0
12629 13166 Steve Bilbe         64 party:53 Labour Party DIW:E05004571 Emsworth                       2016-05-05 0 0           PP53   0
12630 13167 Lulu Bowerman         64 party:52 Conservative and Unionist Party DIW:E05004571 Emsworth                       2016-05-05 0 0           PP52   0
12631 13168 Brian Kerrin         64 party:85 UK Independence Party (UKIP) DIW:E05004571 Emsworth                       2016-05-05 0 0           PP85   0
12632 13169 Chris Maple         64 party:90 Liberal Democrats DIW:E05004571 Emsworth                       2016-05-05 0 0           PP90   0
12633 13170 Mark Edwin Coates Lt Cdr MA (Hons), MLitt, PGCE (Cantab), PGCIE Male   64 party:53 Labour Party DIW:E05004573 Hayling East                       2016-05-05 0 0           PP53   0
12634 13171 Lesley Marsden         64 party:85 UK Independence Party (UKIP) DIW:E05004573 Hayling East                       2016-05-05 0 0           PP85   0
12635 13172 Leah Turner         64 party:52 Conservative and Unionist Party DIW:E05004573 Hayling East                       2016-05-05 0 0           PP52   0
12636 13173 Natalie Willcocks         64 party:90 Liberal Democrats DIW:E05004573 Hayling East                       2016-05-05 0 0           PP90   0
12637 13179 Sheree Dawn Earnshaw         64 party:53 Labour Party DIW:E05004574 Hayling West                       2016-05-05 0 0           PP53   0
12638 13180 Paul Gray     male   64 party:90 Liberal Democrats DIW:E05004574 Hayling West     http://www.libdems.org.uk/paul_gray https://paul-gray.com/     https://static-candidates.democracyclub.org.uk/media/images/images/13180.png   profile-photo brycx http://www.havant-libdems.org/2017/05/10/paul-gray-for-havant/ 2016-05-05 0 0   31703.0       PP90   0
12639 13181 Stephen Humphrey         64 party:85 UK Independence Party (UKIP) DIW:E05004574 Hayling West                       2016-05-05 0 0           PP85   0
12640 13182 John-Laurence Henry Moore         64 party:3960 British National Party DIW:E05004574 Hayling West                       2016-05-05 0 0           PP3960   0
12641 13183 Joanne Thomas         64 party:52 Conservative and Unionist Party DIW:E05004574 Hayling West                       2016-05-05 0 0           PP52   0
12642 13184 Hilary Rosamund Bolt         64 party:90 Liberal Democrats DIW:E05004575 Purbrook                       2016-05-05 0 0           PP90   0
12643 13185 Anthony Gundry         64 party:85 UK Independence Party (UKIP) DIW:E05004575 Purbrook                       2016-05-05 0 0           PP85   0
12644 13186 Caren Howard         64 party:52 Conservative and Unionist Party DIW:E05004575 Purbrook                       2016-05-05 0 0           PP52   0
12645 13187 Anne Thomson         64 party:53 Labour Party DIW:E05004575 Purbrook                       2016-05-05 0 0           PP53   0
12646 13188 Ann Bazley         64 party:90 Liberal Democrats DIW:E05004577 Stakes                       2016-05-05 0 0           PP90   0
12647 13190 Dianne Lloyd         64 party:52 Conservative and Unionist Party DIW:E05004577 Stakes                       2016-05-05 0 0           PP52   0
12648 13191 Carole Newnham         64 party:85 UK Independence Party (UKIP) DIW:E05004577 Stakes                       2016-05-05 0 0           PP85   0
12649 13192 Jane Marianne Briggs         64 party:90 Liberal Democrats DIW:E05004576 St Faith's                       2016-05-05 0 0           PP90   0
12650 13193 Richard Coates         64 party:85 UK Independence Party (UKIP) DIW:E05004576 St Faith's                       2016-05-05 0 0           PP85   0
12651 13194 David William Guest         64 party:52 Conservative and Unionist Party DIW:E05004576 St Faith's                       2016-05-05 0 0           PP52   0
12652 13195 Phil Munday         64 party:53 Labour Party DIW:E05004576 St Faith's                       2016-05-05 0 0           PP53   0
12653 13202 Ann Brown         64 party:90 Liberal Democrats DIW:E05004578 Warren Park                       2016-05-05 0 0           PP90   0
12654 13203 Richard Brown         64 party:53 Labour Party DIW:E05004578 Warren Park                       2016-05-05 0 0           PP53   0
12655 13204 John Davis         64 party:85 UK Independence Party (UKIP) DIW:E05004578 Warren Park                       2016-05-05 0 0           PP85   0
12656 13205 Hakan Ustabas         64 party:52 Conservative and Unionist Party DIW:E05004578 Warren Park                       2016-05-05 0 0           PP52   0
12657 13206 Paul Fencott         64 party:53 Labour Party DIW:E05004579 Waterloo                       2016-05-05 0 0           PP53   0
12658 13207 Scott Anderson Richardson     Male 1971-04-23 64 party:90 Liberal Democrats DIW:E05004579 Waterloo             https://static-candidates.democracyclub.org.uk/media/images/images/13207.png   public-domain scott230471@yahoo.co.uk   2016-05-05 0 0           PP90   0
12659 13208 Peter Philip Wade         64 party:52 Conservative and Unionist Party DIW:E05004579 Waterloo                       2016-05-05 0 0           PP52   0
12660 31685 Anthony Dixon Berry         64 party:53 Labour Party DIW:E05004577 Stakes                       2016-05-05 0 0   13189.0       PP53   0
Powered by Datasette · Query took 0.769ms