Data license: CC-BY-SA · Data source: Democracy Club
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 | 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | NorgroveSelina | https://www.facebook.com/selinaforbroxbourne/ | https://static-candidates.democracyclub.org.uk/media/images/images/14249.png | profile-photo | sjorford | http://www.broxbournelabour.org.uk/our_labour_candidate_2017 | 2716920064 | 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 |
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))