home / democracyclub

democracyclub

Custom SQL query returning 51 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
10169 4259 Gavin Callaghan     male   36 party:53 Labour Party DIW:E05004030 Pitsea North West   1.0 http://www.labour.org.uk/people/detail/gavin-callaghan http://www.gavincallaghan.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/4259.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9653.0       PP53   0
10170 9605 Susan Patricia McCaffery         36 party:85 UK Independence Party (UKIP) DIW:E05004021 Billericay East                       2016-05-05 0 0           PP85   0
10171 9606 Patricia Reid         36 party:53 Labour Party DIW:E05004021 Billericay East                       2016-05-05 0 0           PP53   0
10172 9607 Stuart Bryan Sullivan         36 party:52 Conservative and Unionist Party DIW:E05004021 Billericay East   1.0                   2016-05-05 0 0           PP52   0
10173 9608 Jack Anthony Ferguson         36 party:53 Labour Party DIW:E05004022 Billericay West                       2016-05-05 0 0           PP53   0
10174 9609 Cliff Hammans         36 party:85 UK Independence Party (UKIP) DIW:E05004022 Billericay West                       2016-05-05 0 0           PP85   0
10175 9610 Philip Charles Turner         36 party:52 Conservative and Unionist Party DIW:E05004022 Billericay West   1.0                   2016-05-05 0 0           PP52   0
10176 9611 David Thomas Kirkman     male   36 party:53 Labour Party DIW:E05004023 Burstead                       2016-05-05 0 0           PP53   0
10177 9612 Richard Andrew Moore         36 party:52 Conservative and Unionist Party DIW:E05004023 Burstead   1.0                   2016-05-05 0 0           PP52   0
10178 9613 Kevin John Piper         36 party:85 UK Independence Party (UKIP) DIW:E05004023 Burstead                       2016-05-05 0 0           PP85   0
10179 9614 Stuart Johns Allen         36 party:52 Conservative and Unionist Party DIW:E05004024 Crouch   1.0                   2016-05-05 0 0           PP52   0
10180 9615 Sally Jane Muylders         36 party:53 Labour Party DIW:E05004024 Crouch                       2016-05-05 0 0           PP53   0
10181 9616 Richard Frederick Petchey         36 party:85 UK Independence Party (UKIP) DIW:E05004024 Crouch                       2016-05-05 0 0           PP85   0
10182 9617 Adele Jane Brown         36 party:53 Labour Party DIW:E05004025 Fryerns   1.0                   2016-05-05 0 0           PP53   0
10183 9618 Tony Mark Low         36 party:52 Conservative and Unionist Party DIW:E05004025 Fryerns                       2016-05-05 0 0           PP52   0
10184 9619 Rhyan Lee Waine Mr   Male 1997-08-01 36 party:85 UK Independence Party (UKIP) DIW:E05004025 Fryerns     http://www.basildonboroughukip.org/2016/04/15/may-2016-election-special-ukip-candidate-for-fryerns-rhyan-waine/       https://static-candidates.democracyclub.org.uk/media/images/images/9619.png   profile-photo RhyanW http://www.basildonboroughukip.org/2016/04/15/may-2016-election-special-ukip-candidate-for-fryerns-rhyan-waine/ 2016-05-05 0 0           PP85   0
10185 9632 Lewis David Blaney     male   36 party:53 Labour Party DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP53   0
10186 9633 Hazel Patricia Green         36 party:85 UK Independence Party (UKIP) DIW:E05004026 Laindon Park   1.0                   2016-05-05 0 0           PP85   0
10187 9634 Gary David Maylin     male   36 party:52 Conservative and Unionist Party DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP52   0
10188 9635 Philip William Rackley         36 party:63 Green Party DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP63   0
10189 9636 Alan Henry Richards         36 party:90 Liberal Democrats DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP90   0
10190 9637 John Drummond         36 party:63 Green Party DIW:E05004027 Langdon Hills                       2016-05-05 0 0           PP63   0
10191 9638 Philip Edward Gibbs Dr   male 1960.0 36 party:85 UK Independence Party (UKIP) DIW:E05004027 Langdon Hills       http://philipgibbslangdonhills.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/9638.png   profile-photo philip3   2016-05-05 0 0           PP85   0
10192 9639 Liz Grant         36 party:90 Liberal Democrats DIW:E05004027 Langdon Hills                       2016-05-05 0 0   26576.0       PP90   0
10193 9640 Alex James Harrison         36 party:53 Labour Party DIW:E05004027 Langdon Hills                       2016-05-05 0 0           PP53   0
10194 9641 Stephen Hillier         36 party:52 Conservative and Unionist Party DIW:E05004027 Langdon Hills   1.0                   2016-05-05 0 0           PP52   0
10195 9642 Andrew Forrest Gordon Mr   male 1992.0 36 party:53 Labour Party DIW:E05004028 Lee Chapel North   1.0   https://andrew-gordon.net/   https://www.linkedin.com/in/andrew-gordon-24580855/ https://static-candidates.democracyclub.org.uk/media/images/images/9642.png   profile-photo agordon92   2016-05-05 0 0           PP53 chocolate malted milk 0
10196 9643 Arthur John James         36 party:85 UK Independence Party (UKIP) DIW:E05004028 Lee Chapel North                       2016-05-05 0 0           PP85   0
10197 9644 Stephen Graham Yates         36 party:52 Conservative and Unionist Party DIW:E05004028 Lee Chapel North                       2016-05-05 0 0           PP52   0
10198 9645 Clarence Machipisa Zwengunde         36 ynmp-party:2 Independent DIW:E05004028 Lee Chapel North                       2016-05-05 0 0           ynmp-party:2   0
10199 9647 Derrick William John Fellowes         36 party:85 UK Independence Party (UKIP) DIW:E05004029 Nethermayne   1.0                   2016-05-05 0 0           PP85   0
10200 9648 Dean Robert Hall         36 party:63 Green Party DIW:E05004029 Nethermayne                       2016-05-05 0 0           PP63   0
10201 9649 Graham Peter Herbing         36 party:53 Labour Party DIW:E05004029 Nethermayne                       2016-05-05 0 0           PP53   0
10202 9650 Pauline Patricia Kettle         36 ynmp-party:2 Independent DIW:E05004029 Nethermayne                       2016-05-05 0 0           ynmp-party:2   0
10203 9651 Ben Williams         36 party:90 Liberal Democrats DIW:E05004029 Nethermayne                       2016-05-05 0 0           PP90   0
10204 9652 Jacqueline Ann Blake         36 party:52 Conservative and Unionist Party DIW:E05004030 Pitsea North West                       2016-05-05 0 0           PP52   0
10205 9654 Michelle Yvonne Regan         36 party:85 UK Independence Party (UKIP) DIW:E05004030 Pitsea North West                       2016-05-05 0 0           PP85   0
10206 9655 Kayode Adeniran     male   36 party:53 Labour Party DIW:E05004031 Pitsea South East             https://static-candidates.democracyclub.org.uk/media/images/images/9655.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=720002710829932544 2016-05-05 0 0   48955.0       PP53   0
10207 9656 Jose Carrion         36 party:85 UK Independence Party (UKIP) DIW:E05004031 Pitsea South East   1.0                   2016-05-05 0 0           PP85   0
10208 9657 Ian David Dwyer     male   36 party:52 Conservative and Unionist Party DIW:E05004031 Pitsea South East                       2016-05-05 0 0           PP52   0
10209 9668 Leslie Ronald Allport         36 party:85 UK Independence Party (UKIP) DIW:E05004032 St Martin's                       2016-05-05 0 0           PP85   0
10210 9669 David Edmund Burton-Sampson     male   36 party:53 Labour Party DIW:E05004032 St Martin's   1.0                   2016-05-05 0 0           PP53   0
10211 9670 Jeff Henry         36 party:52 Conservative and Unionist Party DIW:E05004032 St Martin's                       2016-05-05 0 0           PP52   0
10212 9674 Kayte Block Cllr   female 1988.0 36 party:53 Labour Party DIW:E05004033 Vange   1.0   http://kayte4bb.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/9674.png   profile-photo yanbad13257   2016-05-05 0 0           PP53   0
10213 9675 Terry Latchford         36 party:85 UK Independence Party (UKIP) DIW:E05004033 Vange                       2016-05-05 0 0           PP85   0
10214 9676 Tamara Danielle Rainford         36 party:52 Conservative and Unionist Party DIW:E05004033 Vange                       2016-05-05 0 0           PP52   0
10215 9677 Eunice Christine Brockman         36 party:4005 Wickford Independents DIW:E05004035 Wickford North                       2016-05-05 0 0           PP4005   0
10216 9678 Dolores Maria Baila McGurran         36 party:53 Labour Party DIW:E05004035 Wickford North                       2016-05-05 0 0           PP53   0
10217 9679 Carole Morris         36 party:52 Conservative and Unionist Party DIW:E05004035 Wickford North   1.0                   2016-05-05 0 0           PP52   0
10218 9680 David Radley     male   36 party:90 Liberal Democrats DIW:E05004035 Wickford North                       2016-05-05 0 0           PP90   0
10219 36676 Christopher Allen         36 party:52 Conservative and Unionist Party DIW:E05004029 Nethermayne     http://basildonconservatives.com/candidates/fryerns/                 2016-05-05 0 0   9646.0       PP52   0
Powered by Datasette · Query took 0.757ms