US Election 2020

Race to Presidential Election 2020 by County

@kaggle.unanimad_us_election_2020

House Candidate

@kaggle.unanimad_us_election_2020.house_candidate

district District	candidate Candidate	party Party	total_votes Total Votes	won Won
Delaware at large	Lisa Blunt Rochester	DEM	281382	true
Delaware at large	Lee Murphy	REP	196392
Delaware at large	Catherine Purcell	IND	6682
Delaware at large	David Rogers	LIB	3814
Florida’s 1st district	Matt Gaetz	REP	283352	true
Florida’s 1st district	Phil Ehr	DEM	149172
Florida’s 1st district	Albert Oram	NPA	6038
Florida’s 2nd district	Neal Dunn	REP	305337	true
Florida’s 2nd district	Write-ins	WRI	6662
Florida’s 3rd district	Kat Cammack	REP	223075	true


CREATE TABLE house_candidate (
  "district" VARCHAR,
  "candidate" VARCHAR,
  "party" VARCHAR,
  "total_votes" BIGINT,
  "won" BOOLEAN
);