FiveThirtyEight Primary Candidates 2018 Dataset

Explore Data from FiveThirtyEight

@kaggle.fivethirtyeight_fivethirtyeight_primary_candidates_2018_dataset

Table List

1 table(44.67 KB)

Dem Candidates

@kaggle.fivethirtyeight_fivethirtyeight_primary_candidates_2018_dataset.dem_candidates

44.67 KB
811 rows
32 columns

candidate Candidate	state State	district District	office_type Office Type	race_type Race Type	race_primary_election_date Race Primary Election Date	primary_status Primary Status	primary_runoff_status Primary Runoff Status	general_status General Status	partisan_lean Partisan Lean	primary Primary %	won_primary Won Primary	race Race	veteran Veteran?	lgbtq LGBTQ?	elected_official Elected Official?	self_funder Self-Funder?	stem STEM?	obama_alum Obama Alum?	party_support Party Support?	emily_endorsed Emily Endorsed?	guns_sense_candidate Guns Sense Candidate?	biden_endorsed Biden Endorsed?	warren_endorsed Warren Endorsed?	sanders_endorsed Sanders Endorsed?	our_revolution_endorsed Our Revolution Endorsed?	justice_dems_endorsed Justice Dems Endorsed?	pccc_endorsed PCCC Endorsed?	indivisible_endorsed Indivisible Endorsed?	wfp_endorsed WFP Endorsed?	votevets_endorsed VoteVets Endorsed?	no_labels_support No Labels Support?
Anthony White (Alabama)	AL	Governor of Alabama	Governor	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lost	nan	nan	-28.879999	3.4200001	No	Nonwhite	Yes	No	No	No	No	No	nan	nan	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Christopher Countryman	AL	Governor of Alabama	Governor	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lost	nan	nan	-28.879999	1.74	No	White	No	Yes	No	No	No	No	nan	nan	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Doug "New Blue" Smith	AL	Governor of Alabama	Governor	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lost	nan	nan	-28.879999	3.27	No	White	Yes	No	No	No	No	No	nan	nan	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
James C. Fields	AL	Governor of Alabama	Governor	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lost	nan	nan	-28.879999	8	No	Nonwhite	Yes	No	Yes	No	No	No	nan	nan	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Sue Bell Cobb	AL	Governor of Alabama	Governor	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lost	nan	nan	-28.879999	28.98	No	White	No	No	Yes	No	No	No	nan	nan	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Walt Maddox	AL	Governor of Alabama	Governor	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Advanced	nan	On the Ballot	-28.879999	54.599998	Yes	White	No	No	Yes	No	No	No	nan	nan	Yes	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Lizzetta Hill McConnell	AL	U.S. House Alabama District 1	Representative	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lost	nan	nan	-30.68	19.23	No	Nonwhite	No	No	No	No	Yes	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Robert Kennedy Jr.	AL	U.S. House Alabama District 1	Representative	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Advanced	nan	On the Ballot	-30.68	80.769997	Yes	Nonwhite	Yes	No	No	No	No	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Audri Scott Williams	AL	U.S. House Alabama District 2	Representative	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Lost	nan	nan	-33.080002	39.560001	No	Nonwhite	Yes	No	No	No	No	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Tabitha Isner	AL	U.S. House Alabama District 2	Representative	Regular	Tue Jun 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Advanced	nan	On the Ballot	-33.080002	60.439999	Yes	White	No	No	No	No	No	No	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan


CREATE TABLE dem_candidates (
  "candidate" VARCHAR,
  "state" VARCHAR,
  "district" VARCHAR,
  "office_type" VARCHAR,
  "race_type" VARCHAR,
  "race_primary_election_date" TIMESTAMP,
  "primary_status" VARCHAR,
  "primary_runoff_status" VARCHAR,
  "general_status" VARCHAR,
  "partisan_lean" DOUBLE,
  "primary" DOUBLE,
  "won_primary" VARCHAR,
  "race" VARCHAR,
  "veteran" VARCHAR,
  "lgbtq" VARCHAR,
  "elected_official" VARCHAR,
  "self_funder" VARCHAR,
  "stem" VARCHAR,
  "obama_alum" VARCHAR,
  "party_support" VARCHAR,
  "emily_endorsed" VARCHAR,
  "guns_sense_candidate" VARCHAR,
  "biden_endorsed" VARCHAR,
  "warren_endorsed" VARCHAR,
  "sanders_endorsed" VARCHAR,
  "our_revolution_endorsed" VARCHAR,
  "justice_dems_endorsed" VARCHAR,
  "pccc_endorsed" VARCHAR,
  "indivisible_endorsed" VARCHAR,
  "wfp_endorsed" VARCHAR,
  "votevets_endorsed" VARCHAR,
  "no_labels_support" VARCHAR
);