home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

95 rows where election = 22

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id post_label mapit_url elected party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes election_date election_current party_lists_in_use party_list_position old_person_ids gss_code parlparse_id theyworkforyou_url party_ec_id favourite_biscuits cancelled_poll
9305 9305 433 John Spottiswoode     male   local.southampton.2016-05-05 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 9306 2585 Chris Bluemel     male   local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP63   0
9307 9307 4414 Darren Paffey     male   local.southampton.2016-05-05 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 9308 4987 Mark Chaloner Mr   male   local.southampton.2016-05-05 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 9309 5890 Kim Rose     Male 1957.0 local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002458 Bitterne                       2016-05-05 0 0           PP85   0
9310 9310 6391 Adrian Ford     Male   local.southampton.2016-05-05 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 9311 6635 Sue Atkins Mrs   female 1945.0 local.southampton.2016-05-05 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 9312 6636 Nick Chaffey     Male 1964-06-12 local.southampton.2016-05-05 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 9313 7128 Declan Clune Mr   Male 1970-06-27 local.southampton.2016-05-05 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 9314 14070 Kieren Daniel Brown         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002465 Portswood                       2016-05-05 0 0           PP63   0
9315 9315 14072 Molly Vivienne Chandler         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002465 Portswood                       2016-05-05 0 0           PP85   0
9316 9316 14074 Linda Margaret Norris     Female 1961.0 local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002465 Portswood                       2016-05-05 0 0           PP52   0
9317 9317 14075 John Savage Mr   Male 1958.0 local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002465 Portswood   1.0                   2016-05-05 0 0           PP53   0
9318 9318 14314 Spencer James Cromwell Bowman         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002455 Bargate                       2016-05-05 0 0           PP52   0
9319 9319 14315 Joe Cox     Male   local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002455 Bargate                       2016-05-05 0 0   14076.0       PP63 biscuits aren't that helpful 0
9320 9320 14316 John Anthony Easton         local.southampton.2016-05-05 22 ynmp-party:2 Independent UTW:E05002455 Bargate                       2016-05-05 0 0           ynmp-party:2   0
9321 9321 14317 Thomas Gravatt Mr   Male 1996-05-07 local.southampton.2016-05-05 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 9322 14324 John Michael Hannides         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002456 Bassett   1.0                   2016-05-05 0 0           PP52   0
9323 9323 14325 Steven Hulbert         local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002456 Bassett                       2016-05-05 0 0           PP90   0
9324 9324 14326 James Jeremy Peploe         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002456 Bassett                       2016-05-05 0 0           PP63   0
9325 9325 14327 David Ernest Rawlinson         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002456 Bassett                       2016-05-05 0 0           PP804   0
9326 9326 14328 Matthew Renyard         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002456 Bassett                       2016-05-05 0 0           PP53   0
9327 9327 14329 Jean Romsey         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002456 Bassett                       2016-05-05 0 0           PP85   0
9328 9328 14330 Stephen Wallace Barnes-Andrews         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002457 Bevois   1.0                   2016-05-05 0 0           PP53   0
9329 9329 14331 Paul Clarke     Male   local.southampton.2016-05-05 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 9330 14332 Felix Davis         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002457 Bevois                       2016-05-05 0 0           PP52   0
9331 9331 14333 Andrew Howe         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002457 Bevois                       2016-05-05 0 0           PP804   0
9332 9332 14334 Richard John Lyons         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002457 Bevois                       2016-05-05 0 0           PP85   0
9333 9333 14335 Rosie Pearce     female   local.southampton.2016-05-05 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 9334 14338 Jodie Luke Copeland         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002458 Bitterne                       2016-05-05 0 0           PP63   0
9335 9335 14339 Frances Mary Murphy         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002458 Bitterne   1.0                   2016-05-05 0 0           PP53   0
9336 9336 14340 Robert Naish     Male   local.southampton.2016-05-05 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 9337 14341 Edward James Osmond         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002458 Bitterne                       2016-05-05 0 0           PP52   0
9338 9338 14342 Dee Strutt         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002458 Bitterne                       2016-05-05 0 0           PP804   0
9339 9339 14351 Jenny Barnes         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002459 Bitterne Park                       2016-05-05 0 0           PP63   0
9340 9340 14352 Linda Boulton         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002459 Bitterne Park                       2016-05-05 0 0           PP804   0
9341 9341 14353 Stephen Joseph Fenerty         local.southampton.2016-05-05 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 9342 14354 James Arnold Read     Male   local.southampton.2016-05-05 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 9343 14355 Ivan William White         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002459 Bitterne Park   1.0                   2016-05-05 0 0           PP52   0
9344 9344 14363 Derek John Chandler         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002460 Coxford                       2016-05-05 0 0           PP63   0
9345 9345 14364 Victoria Kate Galton         local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002460 Coxford                       2016-05-05 0 0           PP90   0
9346 9346 14365 Trevor Glasspool         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002460 Coxford                       2016-05-05 0 0           PP52   0
9347 9347 14366 Ricky Lambert     male   local.southampton.2016-05-05 22 ynmp-party:2 Independent UTW:E05002460 Coxford                       2016-05-05 0 0           ynmp-party:2   0
9348 9348 14367 Joe Lockyer         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002460 Coxford                       2016-05-05 0 0           PP85   0
9349 9349 14368 Sally Victoria Spicer     Female   local.southampton.2016-05-05 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 9350 14369 Tammy Elizabeth Thomas         local.southampton.2016-05-05 22 ynmp-party:2 Independent UTW:E05002460 Coxford   1.0                   2016-05-05 0 0           ynmp-party:2   0
9351 9351 14373 Chris Grace         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002461 Freemantle                       2016-05-05 0 0           PP52   0
9352 9352 14374 Amy Greenwood     Female   local.southampton.2016-05-05 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 9353 14375 Colin Brendan Hingston         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002461 Freemantle                       2016-05-05 0 0           PP85   0
9354 9354 14376 Jonathan Woodrow Martin         local.southampton.2016-05-05 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 9355 14377 Dave Shields     male   local.southampton.2016-05-05 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 9356 14381 Peter Andrew Baillie         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002462 Harefield   1.0                   2016-05-05 0 0           PP52   0
9357 9357 14382 John Robert Charles Dennis         local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002462 Harefield                       2016-05-05 0 0           PP90   0
9358 9358 14383 Bo Fletcher         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002462 Harefield                       2016-05-05 0 0           PP804   0
9359 9359 14384 Val Laurent         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002462 Harefield   1.0                   2016-05-05 0 0           PP52   0
9360 9360 14385 Carol Juliet Lloyd         local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002462 Harefield                       2016-05-05 0 0           PP90   0
9361 9361 14386 Mary Christine Lloyd         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP53   0
9362 9362 14387 Daniel Leonard Paul James Lucas         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP53   0
9363 9363 14388 Michael Charles John Mawle         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002462 Harefield                       2016-05-05 0 0           PP63   0
9364 9364 14389 Graham O'Reilly         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002462 Harefield                       2016-05-05 0 0           PP804   0
9365 9365 14394 Vincent Avellino         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002464 Peartree                       2016-05-05 0 0           PP85   0
9366 9366 14395 Eileen Margaret Bowers         local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002464 Peartree                       2016-05-05 0 0           PP90   0
9367 9367 14396 Marley George Guthrie         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002464 Peartree                       2016-05-05 0 0           PP52   0
9368 9368 14397 Eamon Francis Keogh         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002464 Peartree   1.0                   2016-05-05 0 0           PP53   0
9369 9369 14398 Mike Marx         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002464 Peartree                       2016-05-05 0 0           PP804   0
9370 9370 14399 Gemma Louise Mathieson         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002464 Peartree                       2016-05-05 0 0           PP63   0
9371 9371 14404 Richard James         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002466 Redbridge                       2016-05-05 0 0           PP63   0
9372 9372 14405 Preshan Jeevaratnam         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002466 Redbridge                       2016-05-05 0 0           PP52   0
9373 9373 14406 Steve McKinnon         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002466 Redbridge                       2016-05-05 0 0           PP85   0
9374 9374 14407 Simon Stokes     Male   local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002466 Redbridge                       2016-05-05 0 0           PP90   0
9375 9375 14408 Lee Keith Whitbread         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002466 Redbridge   1.0                   2016-05-05 0 0           PP53   0
9376 9376 14409 Denise Mary Elizabeth Wyatt         local.southampton.2016-05-05 22 ynmp-party:2 Independent UTW:E05002466 Redbridge                       2016-05-05 0 0           ynmp-party:2   0
9377 9377 14412 David John Fletcher         local.southampton.2016-05-05 22 ynmp-party:2 Independent UTW:E05002467 Shirley                       2016-05-05 0 0           ynmp-party:2   0
9378 9378 14413 Peter Galton     Male   local.southampton.2016-05-05 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 9379 14414 Nicholas Edward Ray         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002467 Shirley                       2016-05-05 0 0           PP85   0
9380 9380 14416 Matt Turpin         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002467 Shirley                       2016-05-05 0 0           PP52   0
9381 9381 14425 James Edward Baillie         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002468 Sholing   1.0                   2016-05-05 0 0           PP52   0
9382 9382 14427 Kenneth John Darke         local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002468 Sholing                       2016-05-05 0 0           PP90   0
9383 9383 14428 Nicholas Murray Ford         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002468 Sholing                       2016-05-05 0 0           PP63   0
9384 9384 14429 Derek Lascelles Humber         local.southampton.2016-05-05 22 party:85 UK Independence Party (UKIP) UTW:E05002468 Sholing                       2016-05-05 0 0           PP85   0
9385 9385 14430 Dan Jeffery         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002468 Sholing                       2016-05-05 0 0           PP53   0
9386 9386 14438 Harmeet Brar         local.southampton.2016-05-05 22 party:52 Conservative and Unionist Party UTW:E05002469 Swaythling                       2016-05-05 0 0           PP52   0
9387 9387 14439 Angela Mary Cotton         local.southampton.2016-05-05 22 party:63 Green Party UTW:E05002469 Swaythling                       2016-05-05 0 0           PP63   0
9388 9388 14440 Kev Hayes         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002469 Swaythling                       2016-05-05 0 0           PP804   0
9389 9389 14441 Sharon Elizabeth Mintoff     Female   local.southampton.2016-05-05 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 9390 14442 Jules Poulain         local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002469 Swaythling                       2016-05-05 0 0           PP90   0
9391 9391 14448 Katherine Jane Barbour   MBA Female   local.southampton.2016-05-05 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 9392 14449 Susan Jane Blatchford         local.southampton.2016-05-05 22 party:53 Labour Party UTW:E05002470 Woolston   1.0                   2016-05-05 0 0   14457.0       PP53   0
9393 9393 14450 Colin Anthony Bleach     Male   local.southampton.2016-05-05 22 party:90 Liberal Democrats UTW:E05002470 Woolston                       2016-05-05 0 0           PP90   0
9394 9394 14451 Alex Fiuza Mr   Male   local.southampton.2016-05-05 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 9395 14452 Christopher Hammond Mr   Male 1998.0 local.southampton.2016-05-05 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 9396 14453 Graham Michael Henry         local.southampton.2016-05-05 22 party:804 Trade Unionist and Socialist Coalition UTW:E05002470 Woolston                       2016-05-05 0 0           PP804   0
9397 9397 14454 Keith Alfred Reed Mr   Male   local.southampton.2016-05-05 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 9398 14455 Joe Spencer Mr   Male   local.southampton.2016-05-05 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 9399 34611 Ron Meldrum Mr   male   local.southampton.2016-05-05 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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "candidates" (
"id" INTEGER,
  "name" TEXT,
  "honorific_prefix" REAL,
  "honorific_suffix" REAL,
  "gender" TEXT,
  "birth_date" REAL,
  "election" INTEGER,
  "party_id" TEXT,
  "party_name" TEXT,
  "post_id" TEXT,
  "post_label" TEXT,
  "mapit_url" INTEGER,
  "elected" REAL,
  "email" TEXT,
  "twitter_username" REAL,
  "facebook_page_url" REAL,
  "party_ppc_page_url" REAL,
  "facebook_personal_url" REAL,
  "homepage_url" REAL,
  "wikipedia_url" REAL,
  "linkedin_url" REAL,
  "image_url" REAL,
  "proxy_image_url_template" INTEGER,
  "image_copyright" REAL,
  "image_uploading_user" REAL,
  "image_uploading_user_notes" REAL,
  "twitter_user_id" INTEGER,
  "election_date" TEXT,
  "election_current" INTEGER,
  "party_lists_in_use" INTEGER,
  "party_list_position" INTEGER,
  "old_person_ids" REAL,
  "gss_code" INTEGER,
  "parlparse_id" REAL,
  "theyworkforyou_url" REAL,
  "party_ec_id" TEXT,
  "favourite_biscuits" REAL,
  "cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))
Powered by Datasette · Query took 9.528ms · Data license: CC-BY-SA · Data source: Democracy Club