home / democracyclub

democracyclub

Custom SQL query returning 68 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
15002 2524 John Shaw     male   92 party:90 Liberal Democrats DIW:E05004434 Brookvale and Kings Furlong       https://johnshaw.4mp.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/2524.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9690.0       PP90   0
15003 4260 Paul Harvey     male   92 party:53 Labour Party DIW:E05004445 Norden   1.0   http://drpaulharvey4basingstoke.nationbuilder.com/     https://static-candidates.democracyclub.org.uk/media/images/images/4260.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9710.0       PP53   0
15004 5892 Malik Azam     Male   92 party:85 UK Independence Party (UKIP) DIW:E05004450 Popley West                       2016-05-05 0 0           PP85   0
15005 9681 Alan Geoffrey Ball         92 ynmp-party:2 Independent DIW:E05004437 Bramley and Sherfield                       2016-05-05 0 0           ynmp-party:2   0
15006 9682 Stephen David Rothman     male   92 party:53 Labour Party DIW:E05004437 Bramley and Sherfield                       2016-05-05 0 0           PP53   0
15007 9683 Venetia Ann Rowland         92 party:52 Conservative and Unionist Party DIW:E05004437 Bramley and Sherfield   1.0                   2016-05-05 0 0           PP52   0
15008 9684 Robert Charles Cooper         92 party:90 Liberal Democrats DIW:E05004433 Brighton Hill South                       2016-05-05 0 0           PP90   0
15009 9685 Philip Andrew Heath         92 party:85 UK Independence Party (UKIP) DIW:E05004433 Brighton Hill South                       2016-05-05 0 0           PP85   0
15010 9686 Andrew David McCormick     male   92 party:53 Labour Party DIW:E05004433 Brighton Hill South   1.0                   2016-05-05 0 0           PP53   0
15011 9687 Jack Terence Cousens         92 party:53 Labour Party DIW:E05004434 Brookvale and Kings Furlong   1.0                   2016-05-05 0 0           PP53   0
15012 9688 Edward Michael Norman         92 party:52 Conservative and Unionist Party DIW:E05004434 Brookvale and Kings Furlong                       2016-05-05 0 0           PP52   0
15013 9689 John Picard         92 party:85 UK Independence Party (UKIP) DIW:E05004434 Brookvale and Kings Furlong                       2016-05-05 0 0           PP85   0
15014 9691 John Barnes         92 party:90 Liberal Democrats DIW:E05004435 Buckskin                       2016-05-05 0 0           PP90   0
15015 9692 Tony Jones         92 party:53 Labour Party DIW:E05004435 Buckskin   1.0                   2016-05-05 0 0           PP53   0
15016 9693 Brian Robert Simmonds         92 party:52 Conservative and Unionist Party DIW:E05004435 Buckskin                       2016-05-05 0 0           PP52   0
15017 9694 David John White     male   92 party:85 UK Independence Party (UKIP) DIW:E05004435 Buckskin                       2016-05-05 0 0           PP85   0
15018 9695 Madeline Hussey         92 party:90 Liberal Democrats DIW:E05004438 Chineham                       2016-05-05 0 0           PP90   0
15019 9696 Peter John King         92 party:85 UK Independence Party (UKIP) DIW:E05004438 Chineham                       2016-05-05 0 0           PP85   0
15020 9697 Laura Jane Morris         92 ynmp-party:2 Independent DIW:E05004438 Chineham                       2016-05-05 0 0           ynmp-party:2   0
15021 9698 Elaine Frances Still         92 party:52 Conservative and Unionist Party DIW:E05004438 Chineham   1.0                   2016-05-05 0 0           PP52   0
15022 9699 Spencer John Cleary         92 party:85 UK Independence Party (UKIP) DIW:E05004442 Hatch Warren and Beggarwood                       2016-05-05 0 0           PP85   0
15023 9700 James Andrew McKenzie         92 party:53 Labour Party DIW:E05004442 Hatch Warren and Beggarwood                       2016-05-05 0 0           PP53   0
15024 9701 Dan Putty         92 party:52 Conservative and Unionist Party DIW:E05004442 Hatch Warren and Beggarwood   1.0                   2016-05-05 0 0           PP52   0
15025 9702 Richard Andrew Whitechurch         92 party:90 Liberal Democrats DIW:E05004442 Hatch Warren and Beggarwood                       2016-05-05 0 0           PP90   0
15026 9703 Anne Court         92 party:52 Conservative and Unionist Party DIW:E05004443 Kempshott   1.0                   2016-05-05 0 0           PP52   0
15027 9704 Mark Hygate         92 party:85 UK Independence Party (UKIP) DIW:E05004443 Kempshott                       2016-05-05 0 0           PP85   0
15028 9705 Walter Bell McCormick         92 party:53 Labour Party DIW:E05004443 Kempshott                       2016-05-05 0 0           PP53   0
15029 9706 Ken Rhatigan         92 party:52 Conservative and Unionist Party DIW:E05004444 Kingsclere   1.0                   2016-05-05 0 0           PP52   0
15030 9707 John Bernal Rodway         92 party:53 Labour Party DIW:E05004444 Kingsclere                       2016-05-05 0 0           PP53   0
15031 9708 Roger Thorpe Ward         92 party:90 Liberal Democrats DIW:E05004444 Kingsclere                       2016-05-05 0 0           PP90   0
15032 9709 Mayola Evelien Blagdon         92 party:804 Trade Unionist and Socialist Coalition DIW:E05004445 Norden                       2016-05-05 0 0           PP804   0
15033 9711 Jim Holder         92 party:52 Conservative and Unionist Party DIW:E05004445 Norden                       2016-05-05 0 0           PP52   0
15034 9712 Doris Jones         92 party:90 Liberal Democrats DIW:E05004445 Norden                       2016-05-05 0 0           PP90   0
15035 9713 Duncan Philip Stone         92 party:85 UK Independence Party (UKIP) DIW:E05004445 Norden                       2016-05-05 0 0           PP85   0
15036 9723 Martin John Baker         92 party:90 Liberal Democrats DIW:E05004446 Oakley and North Waltham                       2016-05-05 0 0           PP90   0
15037 9724 Julie Katherine Pierce         92 party:53 Labour Party DIW:E05004446 Oakley and North Waltham                       2016-05-05 0 0           PP53   0
15038 9725 Diane Marilyn Taylor         92 party:52 Conservative and Unionist Party DIW:E05004446 Oakley and North Waltham   1.0                   2016-05-05 0 0           PP52   0
15039 9726 Roger David Gardiner     male   92 party:52 Conservative and Unionist Party DIW:E05004448 Pamber and Silchester   1.0                   2016-05-05 0 0           PP52   0
15040 9727 Lydia Massey         92 party:53 Labour Party DIW:E05004448 Pamber and Silchester                       2016-05-05 0 0           PP53   0
15041 9732 Kizzie Fenner     female   92 party:52 Conservative and Unionist Party DIW:E05004449 Popley East             https://static-candidates.democracyclub.org.uk/media/images/images/9732.png   other roy2 Photo is from official parish council site - http://www.oldbasing.gov.uk/council/the-team/ 2016-05-05 0 0           PP52   0
15042 9733 Alan Harvey Stone     male 1964.0 92 party:85 UK Independence Party (UKIP) DIW:E05004449 Popley East           https://www.linkedin.com/in/alan-stone-41386b63 https://static-candidates.democracyclub.org.uk/media/images/5525efab413cb4432adffa5c.png   profile-photo JPCarrington Profile picture as featured on official party PPC pages here: http://www.myukip.com/parliamentary-candidates-a-b.html 2016-05-05 0 0   5586.0       PP85   0
15043 9734 Janet Elizabeth Westbrook         92 party:53 Labour Party DIW:E05004449 Popley East   1.0                   2016-05-05 0 0           PP53   0
15044 9735 Jane Kathleen Frankum         92 party:53 Labour Party DIW:E05004450 Popley West   1.0                   2016-05-05 0 0           PP53   0
15045 9736 Jackie Saunders         92 party:52 Conservative and Unionist Party DIW:E05004450 Popley West                       2016-05-05 0 0           PP52   0
15046 9737 John Bentham         92 party:85 UK Independence Party (UKIP) DIW:E05004451 Rooksdown ward                       2016-05-05 0 0           PP85   0
15047 9738 Simon Edward Bound         92 party:52 Conservative and Unionist Party DIW:E05004451 Rooksdown ward   1.0                   2016-05-05 0 0           PP52   0
15048 9739 Obi Nwasike         92 party:90 Liberal Democrats DIW:E05004451 Rooksdown ward                       2016-05-05 0 0           PP90   0
15049 9740 Tom Prince         92 party:53 Labour Party DIW:E05004451 Rooksdown ward                       2016-05-05 0 0           PP53   0
15050 9741 Michael David Barham     male   92 party:53 Labour Party DIW:E05004452 Sherborne St John ward                       2016-05-05 0 0           PP53   0
15051 9742 Tristan Wyatt Robinson         92 party:52 Conservative and Unionist Party DIW:E05004452 Sherborne St John ward   1.0                   2016-05-05 0 0           PP52   0
15052 9743 Colin David Regan     male   92 party:53 Labour Party DIW:E05004453 South Ham   1.0                   2016-05-05 0 0           PP53   0
15053 9744 Rebecca Anne Sanders         92 party:52 Conservative and Unionist Party DIW:E05004453 South Ham                       2016-05-05 0 0           PP52   0
15054 9745 Alan Stretton Simpson         92 party:85 UK Independence Party (UKIP) DIW:E05004453 South Ham                       2016-05-05 0 0   24144.0       PP85   0
15055 9746 Claire Louise Ballard         92 party:53 Labour Party DIW:E05004455 Tadley South                       2016-05-05 0 0           PP53   0
15056 9747 David Alan Leeks     male   92 party:52 Conservative and Unionist Party DIW:E05004455 Tadley South   1.0                   2016-05-05 0 0           PP52   0
15057 9748 Jo Slimin         92 party:90 Liberal Democrats DIW:E05004455 Tadley South                       2016-05-05 0 0           PP90   0
15058 9749 Chloe Jane Ashfield         92 party:53 Labour Party DIW:E05004457 Whitchurch   1.0                   2016-05-05 0 0           PP53   0
15059 9750 Dave George         92 party:52 Conservative and Unionist Party DIW:E05004457 Whitchurch                       2016-05-05 0 0           PP52   0
15060 9751 Steve Neilson         92 party:90 Liberal Democrats DIW:E05004457 Whitchurch                       2016-05-05 0 0           PP90   0
15061 9752 Mike Bound         92 party:90 Liberal Democrats DIW:E05004431 Baughurst and Tadley North   1.0                   2016-05-05 0 0           PP90   0
15062 9753 Nalin Mahinda Jayawardena         92 party:52 Conservative and Unionist Party DIW:E05004431 Baughurst and Tadley North                       2016-05-05 0 0           PP52   0
15063 9754 George Whitley Porter         92 party:53 Labour Party DIW:E05004431 Baughurst and Tadley North                       2016-05-05 0 0           PP53   0
15064 9755 Sven Howard Godesen         92 party:52 Conservative and Unionist Party DIW:E05004430 Basing                       2016-05-05 0 0           PP52   0
15065 9756 Andrew Douglas Mountford         92 party:53 Labour Party DIW:E05004430 Basing                       2016-05-05 0 0           PP53   0
15066 9757 Alan John Read         92 party:90 Liberal Democrats DIW:E05004430 Basing                       2016-05-05 0 0           PP90   0
15067 9758 Stan Tennison         92 party:85 UK Independence Party (UKIP) DIW:E05004430 Basing                       2016-05-05 0 0           PP85   0
15068 17258 Ian Alexander Smith         92 party:52 Conservative and Unionist Party DIW:E05004433 Brighton Hill South                       2016-05-05 0 0           PP52   0
15069 17259 Richard Simon Winter     male   92 party:63 Green Party DIW:E05004433 Brighton Hill South     https://my.greenparty.org.uk/candidates/105799       https://static-candidates.democracyclub.org.uk/media/images/images/17259.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/105799 2016-05-05 0 0           PP63   0
Powered by Datasette · Query took 0.853ms