home / democracyclub

candidates

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

29 rows where election = 11

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: party_id, party_name, post_id, post_label, 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
8788 8788 11410 Kathy Condon         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009002 Broxbourne and Hoddesdon South                       2016-05-05 0 0           PP53   0
8789 8789 11411 Evelyn Faulkner         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009002 Broxbourne and Hoddesdon South                       2016-05-05 0 0   27137.0       PP85   0
8790 8790 11412 David William Holliday         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009002 Broxbourne and Hoddesdon South   1.0                   2016-05-05 0 0           PP52   0
8791 8791 11413 Robert Ronald Hyde         local.broxbourne.2016-05-05 11 party:63 Green Party DIW:E05009002 Broxbourne and Hoddesdon South                       2016-05-05 0 0           PP63   0
8792 8792 13890 Tony Renwick         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009003 Cheshunt North                       2016-05-05 0 0           PP53   0
8793 8793 13891 Linda Joy Russell         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009003 Cheshunt North   1.0                   2016-05-05 0 0           PP52   0
8794 8794 14084 Cliff Hunt         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009009 Rosedale and Bury Green                       2016-05-05 0 0           PP85   0
8795 8795 14237 Dee Hart     female   local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009005 Flamstead End   1.0                   2016-05-05 0 0           PP52   0
8796 8796 14238 Errol George Lawrence         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009005 Flamstead End                       2016-05-05 0 0           PP53   0
8797 8797 14239 Shirley Pratt         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009005 Flamstead End                       2016-05-05 0 0   26793.0       PP85   0
8798 8798 14240 Keith Martin Brown         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009007 Hoddesdon North   1.0                   2016-05-05 0 0           PP52   0
8799 8799 14241 Tony Faulkner         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009007 Hoddesdon North                       2016-05-05 0 0   27127.0       PP85   0
8800 8800 14242 Ed Hopwood         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009007 Hoddesdon North                       2016-05-05 0 0           PP53   0
8801 8801 14243 Ken Ayling         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009008 Hoddesdon Town and Rye Park   1.0                   2016-05-05 0 0           PP52   0
8802 8802 14244 Mark Hall         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009008 Hoddesdon Town and Rye Park                       2016-05-05 0 0           PP53   0
8803 8803 14245 Sidney Pratt         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009008 Hoddesdon Town and Rye Park                       2016-05-05 0 0           PP85   0
8804 8804 14249 Selina Norgrove     female   local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009009 Rosedale and Bury Green             https://static-candidates.democracyclub.org.uk/media/images/images/14249.png   profile-photo sjorford http://www.broxbournelabour.org.uk/our_labour_candidate_2017 2016-05-05 0 0           PP53   0
8805 8805 14250 Darren Richard Pitcher         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009009 Rosedale and Bury Green   1.0                   2016-05-05 0 0           PP52   0
8806 8806 14251 Malcolm David Aitken         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009010 Waltham Cross   1.0                   2016-05-05 0 0           PP53   0
8807 8807 14252 Patsy Spears         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009010 Waltham Cross                       2016-05-05 0 0           PP52   0
8808 8808 14253 Dawn Bloor         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009011 Wormley and Turnford                       2016-05-05 0 0           PP85   0
8809 8809 14254 Lewis Christopher Cocking         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009011 Wormley and Turnford   1.0                   2016-05-05 0 0           PP52   0
8810 8810 14255 Kehinde Osifuwa         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009011 Wormley and Turnford                       2016-05-05 0 0           PP53   0
8811 8811 14304 Steve Coster         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009006 Goffs Oak                       2016-05-05 0 0   27129.0       PP85   0
8812 8812 14305 Gillian Mary Lawrence         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009006 Goffs Oak                       2016-05-05 0 0           PP53   0
8813 8813 14306 Jeremy Pearce         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009006 Goffs Oak   1.0                   2016-05-05 0 0           PP52   0
8814 8814 16620 Mavis Clark         local.broxbourne.2016-05-05 11 party:85 UK Independence Party (UKIP) DIW:E05009004 Cheshunt South and Theobalds                       2016-05-05 0 0           PP85   0
8815 8815 16621 Carol Ann Crump         local.broxbourne.2016-05-05 11 party:52 Conservative and Unionist Party DIW:E05009004 Cheshunt South and Theobalds   1.0                   2016-05-05 0 0           PP52   0
8816 8816 16622 Ian Martin Charles Dust         local.broxbourne.2016-05-05 11 party:53 Labour Party DIW:E05009004 Cheshunt South and Theobalds                       2016-05-05 0 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.841ms · Data license: CC-BY-SA · Data source: Democracy Club