Data license: CC-BY-SA · Data source: Democracy Club
This data as JSON, CSV (advanced)
Suggested facets: birth_date, party_id, party_name, post_id, post_label, 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10141 | 10141 | 592 | Carl Morris | male | 1956-06-06 | local.thurrock.2016-05-05 34 | party:53 | Labour Party | UTW:E05002240 | Orsett | morrislabour@gmail.com | CarlMorris1 | 147517191 | 2016-05-05 | 0 | 0 | 13879.0 | PP53 | 0 | ||||||||||||||||||||
| 10142 | 10142 | 13877 | Peter Anthony Curtis | local.thurrock.2016-05-05 34 | party:85 | UK Independence Party (UKIP) | UTW:E05002240 | Orsett | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 10143 | 10143 | 13878 | Sue Little | local.thurrock.2016-05-05 34 | party:52 | Conservative and Unionist Party | UTW:E05002240 | Orsett | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 10144 | 10144 | 14185 | Lee Dove | local.thurrock.2016-05-05 34 | party:52 | Conservative and Unionist Party | UTW:E05002231 | Chadwell St Mary | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 10145 | 10145 | 14186 | Gerard William Rice | local.thurrock.2016-05-05 34 | party:53 | Labour Party | UTW:E05002231 | Chadwell St Mary | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 10146 | 10146 | 14187 | Matthew Torri | local.thurrock.2016-05-05 34 | party:85 | UK Independence Party (UKIP) | UTW:E05002231 | Chadwell St Mary | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 10147 | 10147 | 15121 | Garry Paul John Hague | local.thurrock.2016-05-05 34 | party:52 | Conservative and Unionist Party | UTW:E05002232 | Chafford and North Stifford | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 10148 | 10148 | 15122 | Umar Kankiya | local.thurrock.2016-05-05 34 | party:53 | Labour Party | UTW:E05002232 | Chafford and North Stifford | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 10149 | 10149 | 15123 | James Albert Mower | local.thurrock.2016-05-05 34 | party:85 | UK Independence Party (UKIP) | UTW:E05002232 | Chafford and North Stifford | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 10150 | 10150 | 16314 | Georgette Patricia Polley | local.thurrock.2016-05-05 34 | party:52 | Conservative and Unionist Party | UTW:E05002229 | Aveley and Uplands | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 10151 | 10151 | 16315 | Judith Margaret Pothecary | local.thurrock.2016-05-05 34 | party:53 | Labour Party | UTW:E05002229 | Aveley and Uplands | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 10152 | 10152 | 16316 | Luke David Spillman | local.thurrock.2016-05-05 34 | party:85 | UK Independence Party (UKIP) | UTW:E05002229 | Aveley and Uplands | 2016-05-05 | 0 | 0 | PP85 | 0 | ||||||||||||||||||||||||||
| 10153 | 10153 | 16378 | Barry William Johnson | local.thurrock.2016-05-05 34 | party:52 | Conservative and Unionist Party | UTW:E05002239 | Ockendon | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 10154 | 10154 | 16379 | Desmond Martins | male | 1955.0 | local.thurrock.2016-05-05 34 | party:53 | Labour Party | UTW:E05002239 | Ockendon | https://en-gb.facebook.com/desmondadolphuslanre.martins | 2016-05-05 | 0 | 0 | PP53 | 0 | |||||||||||||||||||||||
| 10155 | 10155 | 16380 | David Luke Potter | local.thurrock.2016-05-05 34 | party:85 | UK Independence Party (UKIP) | UTW:E05002239 | Ockendon | 2016-05-05 | 0 | 0 | PP85 | 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))