home / democracyclub

democracyclub

Custom SQL query returning 95 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
9305 433 John Spottiswoode     male   22 party:63 Green Party UTW:E05002467 Shirley       http://southampton.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/550bef1036b6dcb123cb432d.png   other tfgg Emailed by candidate Mon, Mar 9, 2015 at 3:03 PM 2016-05-05 0 0   14415.0       PP63   0
9306 2585 Chris Bluemel     male   22 party:63 Green Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP63   0
9307 4414 Darren Paffey     male   22 party:53 Labour Party UTW:E05002455 Bargate   1.0 http://www.labour.org.uk/people/detail/darren-paffey http://www.darrenpaffey.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/5481e86eb150e238702c05cc.png   profile-photo     2016-05-05 0 0   14318.0       PP53   0
9308 4987 Mark Chaloner Mr   male   22 party:53 Labour Party UTW:E05002467 Shirley   1.0 http://www.winchesterlabour.org.uk/mark_chaloner_confirmed_as_labour_s_parliamentary_candidate_for_winchester_chandlers_ford       https://static-candidates.democracyclub.org.uk/media/images/images/4987.png   profile-photo markbraggins Photo published on official announcement page: http://www.winchesterlabour.org.uk/mark_chaloner_confirmed_as_labour_s_parliamentary_candidate_for_winchester_chandlers_ford 2016-05-05 0 0           PP53   0
9309 5890 Kim Rose     Male 1957.0 22 party:85 UK Independence Party (UKIP) UTW:E05002458 Bitterne                       2016-05-05 0 0           PP85   0
9310 6391 Adrian Ford     Male   22 party:90 Liberal Democrats UTW:E05002465 Portswood     https://southampton-libdems.org.uk/en/page/portswood-ward       https://static-candidates.democracyclub.org.uk/media/images/5548b60fc0821aec2c24221d.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/adrian_ford 2016-05-05 0 0   14073.0       PP90   0
9311 6635 Sue Atkins Mrs   female 1945.0 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002470 Woolston             https://static-candidates.democracyclub.org.uk/media/images/554795d8a57e7ec942ad8e2a.png   profile-photo andylolz From party PPC page: http://tusc2015.com/sue-atkins-4-southampton-itchen/ 2016-05-05 0 0           PP804   0
9312 6636 Nick Chaffey     Male 1964-06-12 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002465 Portswood     http://tusc2015.com/nick-chaffey-for-southampton-test/ https://sotontusc.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/552e542742862f047e51cca7.png   public-domain nickchaffey Its my picture 2016-05-05 0 0   14071.0       PP804   0
9313 7128 Declan Clune Mr   Male 1970-06-27 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002468 Sholing     http://tusc2015.com/declan-clune-for-eastleigh2/       https://static-candidates.democracyclub.org.uk/media/images/images/7128.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   14426.0       PP804   0
9314 14070 Kieren Daniel Brown         22 party:63 Green Party UTW:E05002465 Portswood                       2016-05-05 0 0           PP63   0
9315 14072 Molly Vivienne Chandler         22 party:85 UK Independence Party (UKIP) UTW:E05002465 Portswood                       2016-05-05 0 0           PP85   0
9316 14074 Linda Margaret Norris     Female 1961.0 22 party:52 Conservative and Unionist Party UTW:E05002465 Portswood                       2016-05-05 0 0           PP52   0
9317 14075 John Savage Mr   Male 1958.0 22 party:53 Labour Party UTW:E05002465 Portswood   1.0                   2016-05-05 0 0           PP53   0
9318 14314 Spencer James Cromwell Bowman         22 party:52 Conservative and Unionist Party UTW:E05002455 Bargate                       2016-05-05 0 0           PP52   0
9319 14315 Joe Cox     Male   22 party:63 Green Party UTW:E05002455 Bargate                       2016-05-05 0 0   14076.0       PP63 biscuits aren't that helpful 0
9320 14316 John Anthony Easton         22 ynmp-party:2 Independent UTW:E05002455 Bargate                       2016-05-05 0 0           ynmp-party:2   0
9321 14317 Thomas Gravatt Mr   Male 1996-05-07 22 party:90 Liberal Democrats UTW:E05002455 Bargate     http://www.libdems.org.uk/thomas_gravatt       https://static-candidates.democracyclub.org.uk/media/images/images/14317.png   profile-photo j0e_m Photo suggested by candidate, Joe accidentally clicked ignore, uploading again... 2016-05-05 0 0           PP90   0
9322 14324 John Michael Hannides         22 party:52 Conservative and Unionist Party UTW:E05002456 Bassett   1.0                   2016-05-05 0 0           PP52   0
9323 14325 Steven Hulbert         22 party:90 Liberal Democrats UTW:E05002456 Bassett                       2016-05-05 0 0           PP90   0
9324 14326 James Jeremy Peploe         22 party:63 Green Party UTW:E05002456 Bassett                       2016-05-05 0 0           PP63   0
9325 14327 David Ernest Rawlinson         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002456 Bassett                       2016-05-05 0 0           PP804   0
9326 14328 Matthew Renyard         22 party:53 Labour Party UTW:E05002456 Bassett                       2016-05-05 0 0           PP53   0
9327 14329 Jean Romsey         22 party:85 UK Independence Party (UKIP) UTW:E05002456 Bassett                       2016-05-05 0 0           PP85   0
9328 14330 Stephen Wallace Barnes-Andrews         22 party:53 Labour Party UTW:E05002457 Bevois   1.0                   2016-05-05 0 0           PP53   0
9329 14331 Paul Clarke     Male   22 party:90 Liberal Democrats UTW:E05002457 Bevois     https://southampton-libdems.org.uk/en/page/swaythling-ward                 2016-05-05 0 0           PP90   0
9330 14332 Felix Davis         22 party:52 Conservative and Unionist Party UTW:E05002457 Bevois                       2016-05-05 0 0           PP52   0
9331 14333 Andrew Howe         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002457 Bevois                       2016-05-05 0 0           PP804   0
9332 14334 Richard John Lyons         22 party:85 UK Independence Party (UKIP) UTW:E05002457 Bevois                       2016-05-05 0 0           PP85   0
9333 14335 Rosie Pearce     female   22 party:63 Green Party UTW:E05002457 Bevois     https://my.greenparty.org.uk/candidates/106209 http://southampton.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/14335.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/106209 2016-05-05 0 0           PP63   0
9334 14338 Jodie Luke Copeland         22 party:63 Green Party UTW:E05002458 Bitterne                       2016-05-05 0 0           PP63   0
9335 14339 Frances Mary Murphy         22 party:53 Labour Party UTW:E05002458 Bitterne   1.0                   2016-05-05 0 0           PP53   0
9336 14340 Robert Naish     Male   22 party:90 Liberal Democrats UTW:E05002458 Bitterne     https://southampton-libdems.org.uk/en/page/peartree-ward                 2016-05-05 0 0           PP90   0
9337 14341 Edward James Osmond         22 party:52 Conservative and Unionist Party UTW:E05002458 Bitterne                       2016-05-05 0 0           PP52   0
9338 14342 Dee Strutt         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002458 Bitterne                       2016-05-05 0 0           PP804   0
9339 14351 Jenny Barnes         22 party:63 Green Party UTW:E05002459 Bitterne Park                       2016-05-05 0 0           PP63   0
9340 14352 Linda Boulton         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002459 Bitterne Park                       2016-05-05 0 0           PP804   0
9341 14353 Stephen Joseph Fenerty         22 party:53 Labour Party UTW:E05002459 Bitterne Park             https://static-candidates.democracyclub.org.uk/media/images/images/14353.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
9342 14354 James Arnold Read     Male   22 party:90 Liberal Democrats UTW:E05002459 Bitterne Park     https://southampton-libdems.org.uk/en/page/bitterne-park-ward                 2016-05-05 0 0           PP90   0
9343 14355 Ivan William White         22 party:52 Conservative and Unionist Party UTW:E05002459 Bitterne Park   1.0                   2016-05-05 0 0           PP52   0
9344 14363 Derek John Chandler         22 party:63 Green Party UTW:E05002460 Coxford                       2016-05-05 0 0           PP63   0
9345 14364 Victoria Kate Galton         22 party:90 Liberal Democrats UTW:E05002460 Coxford                       2016-05-05 0 0           PP90   0
9346 14365 Trevor Glasspool         22 party:52 Conservative and Unionist Party UTW:E05002460 Coxford                       2016-05-05 0 0           PP52   0
9347 14366 Ricky Lambert     male   22 ynmp-party:2 Independent UTW:E05002460 Coxford                       2016-05-05 0 0           ynmp-party:2   0
9348 14367 Joe Lockyer         22 party:85 UK Independence Party (UKIP) UTW:E05002460 Coxford                       2016-05-05 0 0           PP85   0
9349 14368 Sally Victoria Spicer     Female   22 party:53 Labour Party UTW:E05002460 Coxford             https://static-candidates.democracyclub.org.uk/media/images/images/14368.png   other JIMB0B http://www.southampton.gov.uk/modernGov/mgUserInfo.aspx?UID=2144 2016-05-05 0 0           PP53   0
9350 14369 Tammy Elizabeth Thomas         22 ynmp-party:2 Independent UTW:E05002460 Coxford   1.0                   2016-05-05 0 0           ynmp-party:2   0
9351 14373 Chris Grace         22 party:52 Conservative and Unionist Party UTW:E05002461 Freemantle                       2016-05-05 0 0           PP52   0
9352 14374 Amy Greenwood     Female   22 party:90 Liberal Democrats UTW:E05002461 Freemantle     http://southampton-libdems.org.uk/en/page/coxford-ward       https://static-candidates.democracyclub.org.uk/media/images/images/14374.png   profile-photo takluyver2 http://southampton-libdems.org.uk/en/page/freemantle-ward 2016-05-05 0 0           PP90   0
9353 14375 Colin Brendan Hingston         22 party:85 UK Independence Party (UKIP) UTW:E05002461 Freemantle                       2016-05-05 0 0           PP85   0
9354 14376 Jonathan Woodrow Martin         22 party:63 Green Party UTW:E05002461 Freemantle             https://static-candidates.democracyclub.org.uk/media/images/images/14376.png   profile-photo takluyver2 https://southampton.greenparty.org.uk/green-councillors-key-successes/local-elections.html 2016-05-05 0 0           PP63   0
9355 14377 Dave Shields     male   22 party:53 Labour Party UTW:E05002461 Freemantle   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/14377.png   profile-photo takluyver2   2016-05-05 0 0           PP53   0
9356 14381 Peter Andrew Baillie         22 party:52 Conservative and Unionist Party UTW:E05002462 Harefield   1.0                   2016-05-05 0 0           PP52   0
9357 14382 John Robert Charles Dennis         22 party:90 Liberal Democrats UTW:E05002462 Harefield                       2016-05-05 0 0           PP90   0
9358 14383 Bo Fletcher         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002462 Harefield                       2016-05-05 0 0           PP804   0
9359 14384 Val Laurent         22 party:52 Conservative and Unionist Party UTW:E05002462 Harefield   1.0                   2016-05-05 0 0           PP52   0
9360 14385 Carol Juliet Lloyd         22 party:90 Liberal Democrats UTW:E05002462 Harefield                       2016-05-05 0 0           PP90   0
9361 14386 Mary Christine Lloyd         22 party:53 Labour Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP53   0
9362 14387 Daniel Leonard Paul James Lucas         22 party:53 Labour Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP53   0
9363 14388 Michael Charles John Mawle         22 party:63 Green Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP63   0
9364 14389 Graham O'Reilly         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002462 Harefield                       2016-05-05 0 0           PP804   0
9365 14394 Vincent Avellino         22 party:85 UK Independence Party (UKIP) UTW:E05002464 Peartree                       2016-05-05 0 0           PP85   0
9366 14395 Eileen Margaret Bowers         22 party:90 Liberal Democrats UTW:E05002464 Peartree                       2016-05-05 0 0           PP90   0
9367 14396 Marley George Guthrie         22 party:52 Conservative and Unionist Party UTW:E05002464 Peartree                       2016-05-05 0 0           PP52   0
9368 14397 Eamon Francis Keogh         22 party:53 Labour Party UTW:E05002464 Peartree   1.0                   2016-05-05 0 0           PP53   0
9369 14398 Mike Marx         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002464 Peartree                       2016-05-05 0 0           PP804   0
9370 14399 Gemma Louise Mathieson         22 party:63 Green Party UTW:E05002464 Peartree                       2016-05-05 0 0           PP63   0
9371 14404 Richard James         22 party:63 Green Party UTW:E05002466 Redbridge                       2016-05-05 0 0           PP63   0
9372 14405 Preshan Jeevaratnam         22 party:52 Conservative and Unionist Party UTW:E05002466 Redbridge                       2016-05-05 0 0           PP52   0
9373 14406 Steve McKinnon         22 party:85 UK Independence Party (UKIP) UTW:E05002466 Redbridge                       2016-05-05 0 0           PP85   0
9374 14407 Simon Stokes     Male   22 party:90 Liberal Democrats UTW:E05002466 Redbridge                       2016-05-05 0 0           PP90   0
9375 14408 Lee Keith Whitbread         22 party:53 Labour Party UTW:E05002466 Redbridge   1.0                   2016-05-05 0 0           PP53   0
9376 14409 Denise Mary Elizabeth Wyatt         22 ynmp-party:2 Independent UTW:E05002466 Redbridge                       2016-05-05 0 0           ynmp-party:2   0
9377 14412 David John Fletcher         22 ynmp-party:2 Independent UTW:E05002467 Shirley                       2016-05-05 0 0           ynmp-party:2   0
9378 14413 Peter Galton     Male   22 party:90 Liberal Democrats UTW:E05002467 Shirley     https://southampton-libdems.org.uk/en/page/shirley-ward                 2016-05-05 0 0           PP90   0
9379 14414 Nicholas Edward Ray         22 party:85 UK Independence Party (UKIP) UTW:E05002467 Shirley                       2016-05-05 0 0           PP85   0
9380 14416 Matt Turpin         22 party:52 Conservative and Unionist Party UTW:E05002467 Shirley                       2016-05-05 0 0           PP52   0
9381 14425 James Edward Baillie         22 party:52 Conservative and Unionist Party UTW:E05002468 Sholing   1.0                   2016-05-05 0 0           PP52   0
9382 14427 Kenneth John Darke         22 party:90 Liberal Democrats UTW:E05002468 Sholing                       2016-05-05 0 0           PP90   0
9383 14428 Nicholas Murray Ford         22 party:63 Green Party UTW:E05002468 Sholing                       2016-05-05 0 0           PP63   0
9384 14429 Derek Lascelles Humber         22 party:85 UK Independence Party (UKIP) UTW:E05002468 Sholing                       2016-05-05 0 0           PP85   0
9385 14430 Dan Jeffery         22 party:53 Labour Party UTW:E05002468 Sholing                       2016-05-05 0 0           PP53   0
9386 14438 Harmeet Brar         22 party:52 Conservative and Unionist Party UTW:E05002469 Swaythling                       2016-05-05 0 0           PP52   0
9387 14439 Angela Mary Cotton         22 party:63 Green Party UTW:E05002469 Swaythling                       2016-05-05 0 0           PP63   0
9388 14440 Kev Hayes         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002469 Swaythling                       2016-05-05 0 0           PP804   0
9389 14441 Sharon Elizabeth Mintoff     Female   22 party:53 Labour Party UTW:E05002469 Swaythling   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/14441.png   other JIMB0B http://www.southampton.gov.uk/modernGov/mgUserInfo.aspx?UID=2189 2016-05-05 0 0           PP53   0
9390 14442 Jules Poulain         22 party:90 Liberal Democrats UTW:E05002469 Swaythling                       2016-05-05 0 0           PP90   0
9391 14448 Katherine Jane Barbour   MBA Female   22 party:63 Green Party UTW:E05002470 Woolston     https://southampton.greenparty.org.uk/green-councillors-key-successes/local-elections.html       https://static-candidates.democracyclub.org.uk/media/images/images/14448.png   profile-photo petersteadman Photo taken from 2016 Candidates page of Soton & Dist Green Pty website: https://southampton.greenparty.org.uk/green-councillors-key-successes/local-elections.html 2016-05-05 0 0   14456.0       PP63   0
9392 14449 Susan Jane Blatchford         22 party:53 Labour Party UTW:E05002470 Woolston   1.0                   2016-05-05 0 0   14457.0       PP53   0
9393 14450 Colin Anthony Bleach     Male   22 party:90 Liberal Democrats UTW:E05002470 Woolston                       2016-05-05 0 0           PP90   0
9394 14451 Alex Fiuza Mr   Male   22 party:52 Conservative and Unionist Party UTW:E05002470 Woolston             https://static-candidates.democracyclub.org.uk/media/images/images/14451.png   profile-photo petersteadman http://www.southamptonconservatives.co.uk/southampton-political-wards/woolston_ward/ - published at head of this ward page on Soton Conservatives website 2016-05-05 0 0           PP52   0
9395 14452 Christopher Hammond Mr   Male 1998.0 22 party:53 Labour Party UTW:E05002470 Woolston   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/14452.png   other petersteadman Councillor photo from Soton City Cncl website: http://www.southampton.gov.uk/modernGov/mgUserInfo.aspx?UID=2712 Probably copyright issues using this one instead: http://www.dailyecho.co.uk/news/10484462.Labour_wins_Woolston_by_election/ 2016-05-05 0 0           PP53   0
9396 14453 Graham Michael Henry         22 party:804 Trade Unionist and Socialist Coalition UTW:E05002470 Woolston                       2016-05-05 0 0           PP804   0
9397 14454 Keith Alfred Reed Mr   Male   22 party:90 Liberal Democrats UTW:E05002470 Woolston             https://static-candidates.democracyclub.org.uk/media/images/images/14454.png   profile-photo petersteadman https://twitter.com/portswoodfocus - taken from his twitter page 2016-05-05 0 0           PP90   0
9398 14455 Joe Spencer Mr   Male   22 party:52 Conservative and Unionist Party UTW:E05002470 Woolston             https://static-candidates.democracyclub.org.uk/media/images/images/14455.png   profile-photo petersteadman http://www.southamptonconservatives.co.uk/southampton-political-wards/woolston_ward/ - published on ward page of Soton Conservatives website 2016-05-05 0 0           PP52   0
9399 34611 Ron Meldrum Mr   male   22 party:63 Green Party UTW:E05002470 Woolston     http://southampton.greenparty.org.uk/local-news/2015/02/08/ron-meldrum-has-been-selected-as-green-party-candidate-eastleigh/ https://eastleigh.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/34611.png   other markbraggins This is a screenshot from Ron Meldrum's PDF leaflet released on 8th May via Eastleigh Greens Facebook page https://www.facebook.com/groups/eastleighgreens/ 2016-05-05 0 0   6243.0       PP63   0
Powered by Datasette · Query took 1.32ms