home / democracyclub

candidates

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

63 rows where election = 98

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, party_id, party_name, post_id, post_label, email, image_url, image_uploading_user, image_uploading_user_notes, 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
15425 15425 1147 Hugh McGuinness     male   local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP85   0
15426 15426 3005 Martin Lyon     male 1966-02-16 local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004497 Bishopstoke East     http://ukipwinchester.com/martin-lyon/       https://static-candidates.democracyclub.org.uk/media/images/images/3005.png   other sjorford http://www.dailyecho.co.uk/news/12886165.ELECTION_2015__Meet_the_candidates___Winchester/?ref=twt 2016-05-05 0 0   34671.0       PP85   0
15427 15427 16518 Christine McKeone         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004497 Bishopstoke East                       2016-05-05 0 0           PP53   0
15428 15428 16519 Trevor Mignot         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004497 Bishopstoke East                       2016-05-05 0 0           PP90   0
15429 15429 16520 Ania Waterman         local.eastleigh.2016-05-05 98 party:63 Green Party DIW:E05004497 Bishopstoke East                       2016-05-05 0 0           PP63   0
15430 15430 16521 Tom Yates         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004497 Bishopstoke East                       2016-05-05 0 0   38693.0       PP52   0
15431 15431 16525 John Peter Edwards         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP85   0
15432 15432 16526 David Hubble         local.eastleigh.2016-05-05 98 party:63 Green Party DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP63   0
15433 15433 16527 Sue Toher         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP53   0
15434 15434 16528 Anne Margaret Winstanley         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP90   0
15435 15435 16529 Chris Yates         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP52   0
15436 15436 16535 Ian Almeric Bennett         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004499 Botley ward                       2016-05-05 0 0           PP52   0
15437 15437 16536 Chris Greenwood         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004499 Botley ward                       2016-05-05 0 0           PP85   0
15438 15438 16537 Rupert Gregory Miles Kyrle Cllr   male   local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004499 Botley ward                       2016-05-05 0 0           PP90   0
15439 15439 16538 Kevin Paul Williamson         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004499 Botley ward                       2016-05-05 0 0           PP53   0
15440 15440 16539 Stephanie Louise Arnold         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0           PP52   0
15441 15441 16540 Derek Daniels         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0           PP85   0
15442 15442 16541 Steve Holes         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0   38638.0       PP90   0
15443 15443 16542 Shere Sattar         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0           PP53   0
15444 15444 16551 Haulwen Veronica Broadhurst         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0           PP90   0
15445 15445 16552 Pete House         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0   35199.0       PP85   0
15446 15446 16553 Sarah Mann         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0           PP53   0
15447 15447 16554 John Hamilton Reynolds         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0           PP52   0
15448 15448 16559 Peter Clayton         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004502 Chandler's Ford West ward                       2016-05-05 0 0           PP53   0
15449 15449 16560 Keith Frederick Hatch         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004502 Chandler's Ford West ward                       2016-05-05 0 0           PP52   0
15450 15450 16561 David Arthur Pragnell     male   local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004502 Chandler's Ford West ward             https://static-candidates.democracyclub.org.uk/media/images/images/16561.png   other mattl From Eastleigh Borough Council website: https://meetings.eastleigh.gov.uk/mgUserInfo.aspx?UID=50000082 2016-05-05 0 0           PP90   0
15451 15451 16562 Andy Whitehouse         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004502 Chandler's Ford West ward                       2016-05-05 0 0           PP85   0
15452 15452 16568 Mark Leonard Balaam         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP90   0
15453 15453 16569 Andy Moore         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP85   0
15454 15454 16570 Simon Payne         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP52   0
15455 15455 16571 Steve Phillips         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP53   0
15456 15456 16577 Mike Holliday         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP52   0
15457 15457 16578 Alexander David Hughes         local.eastleigh.2016-05-05 98 party:63 Green Party DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP63   0
15458 15458 16579 Keith Iain McFarlane         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP85   0
15459 15459 16580 Christopher Andrew Thomas         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP90   0
15460 15460 16582 Kathy O'Neill         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0   29090;38655       PP53   0
15461 15461 16589 Nick Arnold         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP52   0
15462 15462 16590 Pete Luffman         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP53   0
15463 15463 16591 Darshan Singh Mann         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP90   0
15464 15464 16592 Jan Weller         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP85   0
15465 15465 16597 Steven Dennis Broomfield         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP52   0
15466 15466 16598 Rob Rushton         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP90   0
15467 15467 16599 Mary Shephard         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP53   0
15468 15468 16600 Sheelagh de Carteret Cohen         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP52   0
15469 15469 16601 Malcolm Robert Cross         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP90   0
15470 15470 16602 Hilary Daniels         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP85   0
15471 15471 16603 Chris Rogers         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP53   0
15472 15472 16604 Terry Crow         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP53   0
15473 15473 16605 Liam Fleming         local.eastleigh.2016-05-05 98 party:63 Green Party DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP63   0
15474 15474 16606 Cynthia Margaret Garton Cllr   female   local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP90   0
15475 15475 16607 Graham Robert Piper         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP52   0
15476 15476 16608 Paul Michael Webber         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP85   0
15477 15477 16609 Daniel Edward Hatfield         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP52   0
15478 15478 16610 Jean Leech         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP85   0
15479 15479 16611 Beverley Anne Rose         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP90   0
15480 15480 16612 Michael Tibble         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP53   0
15481 15481 16623 Kevin Butt         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004512 Hiltingbury West ward                       2016-05-05 0 0           PP53   0
15482 15482 16624 James Ian Duguid         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004512 Hiltingbury West ward                       2016-05-05 0 0           PP90   0
15483 15483 16625 Michael Joseph Hughes         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004512 Hiltingbury West ward                       2016-05-05 0 0           PP52   0
15484 15484 16626 David John Aylwin Airey         local.eastleigh.2016-05-05 98 party:90 Liberal Democrats DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0           PP90   0
15485 15485 16627 Chris Martin         local.eastleigh.2016-05-05 98 party:85 UK Independence Party (UKIP) DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0           PP85   0
15486 15486 16628 Jamie Mills         local.eastleigh.2016-05-05 98 party:52 Conservative and Unionist Party DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0           PP52   0
15487 15487 16629 Siobhan O'Rourke         local.eastleigh.2016-05-05 98 party:53 Labour Party DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0   29116;38675       PP53   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 6.671ms · Data license: CC-BY-SA · Data source: Democracy Club