Data license: CC-BY-SA · Data source: Democracy Club
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 | twitter_username | facebook_page_url | party_ppc_page_url | facebook_personal_url | homepage_url | wikipedia_url | linkedin_url | image_url | proxy_image_url_template | image_copyright | image_uploading_user | image_uploading_user_notes | twitter_user_id | 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 | martin.lyon@ukiplocal.org | 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 | rupert.kyrle@eastleigh.gov.uk | 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 | david.pragnell@eastleigh.gov.uk | 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 |
JSON shape: default, array, newline-delimited
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))