candidates

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

0 rows where party_ec_id = "PP70" and theyworkforyou_url = "https://www.gate.io/es/sign"

Search:

descending

This data as JSON

Link	rowid	id	name	honorific_prefix	honorific_suffix	gender	birth_date	election	party_id	party_name	post_id	post_label	mapit_url	elected	email	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

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))