home / democracyclub

candidates

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

54 rows where election = 64

✎ 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, party_ppc_page_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
12607 12607 10983 Fiona Drinan         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004572 Hart Plain                       2016-05-05 0 0           PP90   0
12608 12608 10984 Howard Frank Sherlock         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004572 Hart Plain                       2016-05-05 0 0           PP53   0
12609 12609 10985 Elaine Louanne Shimbart         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004572 Hart Plain                       2016-05-05 0 0           PP52   0
12610 12610 13132 Michael Edmund Bolt         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004566 Barncroft                       2016-05-05 0 0           PP90   0
12611 12611 13133 Brenda Margaret Kerrin         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004566 Barncroft                       2016-05-05 0 0           PP85   0
12612 12612 13134 Phil Pearson         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004566 Barncroft                       2016-05-05 0 0           PP53   0
12613 12613 13135 Yvonne Margaret Weeks         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004566 Barncroft                       2016-05-05 0 0           PP52   0
12614 12614 13141 Malc Carpenter         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004567 Battins                       2016-05-05 0 0           PP85   0
12615 12615 13142 Ralph Martin Cousins         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004567 Battins                       2016-05-05 0 0           PP53   0
12616 12616 13143 Johanna Frances Lowe         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004567 Battins                       2016-05-05 0 0           PP90   0
12617 12617 13144 Ian Andrew Payne         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004567 Battins                       2016-05-05 0 0           PP52   0
12618 12618 13145 Philippa Mary Irene Gray     female   local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004568 Bedhampton     http://www.havant-libdems.org/candidates/       https://static-candidates.democracyclub.org.uk/media/images/images/13145.png   profile-photo mattl From http://www.havant-libdems.org/candidates/ 2016-05-05 0 0           PP90   0
12619 12619 13146 Freya Savidge-Conway Mrs   Female 1981.0 local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004568 Bedhampton                       2016-05-05 0 0           PP53   0
12620 12620 13147 Kenneth Patrick Smith         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004568 Bedhampton                       2016-05-05 0 0           PP52   0
12621 12621 13148 Catherine Billam         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004569 Bondfields                       2016-05-05 0 0           PP90   0
12622 12622 13149 Terry Hart         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004569 Bondfields                       2016-05-05 0 0           PP53   0
12623 12623 13150 Curtis Royston Stanfield         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004569 Bondfields                       2016-05-05 0 0           PP52   0
12624 12624 13151 Geoff Whiffen         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004569 Bondfields                       2016-05-05 0 0           PP85   0
12625 12625 13157 Andrew Boxall         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004570 Cowplain                       2016-05-05 0 0           PP85   0
12626 12626 13158 John Dennis Jacobs         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004570 Cowplain                       2016-05-05 0 0           PP90   0
12627 12627 13159 David John Keast         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004570 Cowplain                       2016-05-05 0 0           PP52   0
12628 12628 13160 Ken Monks         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004570 Cowplain                       2016-05-05 0 0           PP53   0
12629 12629 13166 Steve Bilbe         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004571 Emsworth                       2016-05-05 0 0           PP53   0
12630 12630 13167 Lulu Bowerman         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004571 Emsworth                       2016-05-05 0 0           PP52   0
12631 12631 13168 Brian Kerrin         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004571 Emsworth                       2016-05-05 0 0           PP85   0
12632 12632 13169 Chris Maple         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004571 Emsworth                       2016-05-05 0 0           PP90   0
12633 12633 13170 Mark Edwin Coates Lt Cdr MA (Hons), MLitt, PGCE (Cantab), PGCIE Male   local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004573 Hayling East                       2016-05-05 0 0           PP53   0
12634 12634 13171 Lesley Marsden         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004573 Hayling East                       2016-05-05 0 0           PP85   0
12635 12635 13172 Leah Turner         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004573 Hayling East                       2016-05-05 0 0           PP52   0
12636 12636 13173 Natalie Willcocks         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004573 Hayling East                       2016-05-05 0 0           PP90   0
12637 12637 13179 Sheree Dawn Earnshaw         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004574 Hayling West                       2016-05-05 0 0           PP53   0
12638 12638 13180 Paul Gray     male   local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004574 Hayling West     http://www.libdems.org.uk/paul_gray https://paul-gray.com/     https://static-candidates.democracyclub.org.uk/media/images/images/13180.png   profile-photo brycx http://www.havant-libdems.org/2017/05/10/paul-gray-for-havant/ 2016-05-05 0 0   31703.0       PP90   0
12639 12639 13181 Stephen Humphrey         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004574 Hayling West                       2016-05-05 0 0           PP85   0
12640 12640 13182 John-Laurence Henry Moore         local.havant.2016-05-05 64 party:3960 British National Party DIW:E05004574 Hayling West                       2016-05-05 0 0           PP3960   0
12641 12641 13183 Joanne Thomas         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004574 Hayling West                       2016-05-05 0 0           PP52   0
12642 12642 13184 Hilary Rosamund Bolt         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004575 Purbrook                       2016-05-05 0 0           PP90   0
12643 12643 13185 Anthony Gundry         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004575 Purbrook                       2016-05-05 0 0           PP85   0
12644 12644 13186 Caren Howard         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004575 Purbrook                       2016-05-05 0 0           PP52   0
12645 12645 13187 Anne Thomson         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004575 Purbrook                       2016-05-05 0 0           PP53   0
12646 12646 13188 Ann Bazley         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004577 Stakes                       2016-05-05 0 0           PP90   0
12647 12647 13190 Dianne Lloyd         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004577 Stakes                       2016-05-05 0 0           PP52   0
12648 12648 13191 Carole Newnham         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004577 Stakes                       2016-05-05 0 0           PP85   0
12649 12649 13192 Jane Marianne Briggs         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004576 St Faith's                       2016-05-05 0 0           PP90   0
12650 12650 13193 Richard Coates         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004576 St Faith's                       2016-05-05 0 0           PP85   0
12651 12651 13194 David William Guest         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004576 St Faith's                       2016-05-05 0 0           PP52   0
12652 12652 13195 Phil Munday         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004576 St Faith's                       2016-05-05 0 0           PP53   0
12653 12653 13202 Ann Brown         local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004578 Warren Park                       2016-05-05 0 0           PP90   0
12654 12654 13203 Richard Brown         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004578 Warren Park                       2016-05-05 0 0           PP53   0
12655 12655 13204 John Davis         local.havant.2016-05-05 64 party:85 UK Independence Party (UKIP) DIW:E05004578 Warren Park                       2016-05-05 0 0           PP85   0
12656 12656 13205 Hakan Ustabas         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004578 Warren Park                       2016-05-05 0 0           PP52   0
12657 12657 13206 Paul Fencott         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004579 Waterloo                       2016-05-05 0 0           PP53   0
12658 12658 13207 Scott Anderson Richardson     Male 1971-04-23 local.havant.2016-05-05 64 party:90 Liberal Democrats DIW:E05004579 Waterloo             https://static-candidates.democracyclub.org.uk/media/images/images/13207.png   public-domain scott230471@yahoo.co.uk   2016-05-05 0 0           PP90   0
12659 12659 13208 Peter Philip Wade         local.havant.2016-05-05 64 party:52 Conservative and Unionist Party DIW:E05004579 Waterloo                       2016-05-05 0 0           PP52   0
12660 12660 31685 Anthony Dixon Berry         local.havant.2016-05-05 64 party:53 Labour Party DIW:E05004577 Stakes                       2016-05-05 0 0   13189.0       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 7.427ms · Data license: CC-BY-SA · Data source: Democracy Club