Name: US Election 2020
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

US Election 2020

Please, If you enjoyed this dataset, don't forget to upvote it.

US Election 2020

Context

For this year, was the 59th quadrennial presidential election held on Tuesday, November 3, 2020. To win the election, the candidate needs 270 out of 538 electoral votes. A good sign, that show if a candidate is doing well, is if they win states that aren't expcted to go their way.

Content

This dataset contains county-level data from 2020 US Election.

Acknowledgements

US election 2020: A really simple guide

Tables

Governors County

@kaggle.unanimad_us_election_2020.governors_county

24.31 kB
1,025 rows
5 columns

CREATE TABLE governors_county (
  "state" VARCHAR,
  "county" VARCHAR,
  "current_votes" BIGINT,
  "total_votes" BIGINT,
  "percent" BIGINT
);

Governors County Candidate

@kaggle.unanimad_us_election_2020.governors_county_candidate

35.62 kB
5,145 rows
6 columns

CREATE TABLE governors_county_candidate (
  "state" VARCHAR,
  "county" VARCHAR,
  "candidate" VARCHAR,
  "party" VARCHAR,
  "votes" BIGINT,
  "won" BOOLEAN
);

Governors State

@kaggle.unanimad_us_election_2020.governors_state

2.33 kB
11 rows
2 columns

CREATE TABLE governors_state (
  "state" VARCHAR,
  "votes" BIGINT
);

House Candidate

@kaggle.unanimad_us_election_2020.house_candidate

31.9 kB
1,215 rows
5 columns

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

House State

@kaggle.unanimad_us_election_2020.house_state

12.37 kB
436 rows
4 columns

CREATE TABLE house_state (
  "district" VARCHAR,
  "current_votes" BIGINT,
  "total_votes" BIGINT,
  "percent" BIGINT
);

President County

@kaggle.unanimad_us_election_2020.president_county

90.26 kB
4,633 rows
5 columns

CREATE TABLE president_county (
  "state" VARCHAR,
  "county" VARCHAR,
  "current_votes" BIGINT,
  "total_votes" BIGINT,
  "percent" BIGINT
);

President County Candidate

@kaggle.unanimad_us_election_2020.president_county_candidate

160.27 kB
32,177 rows
6 columns

CREATE TABLE president_county_candidate (
  "state" VARCHAR,
  "county" VARCHAR,
  "candidate" VARCHAR,
  "party" VARCHAR,
  "total_votes" BIGINT,
  "won" BOOLEAN
);

President State

@kaggle.unanimad_us_election_2020.president_state

3.09 kB
52 rows
2 columns

CREATE TABLE president_state (
  "state" VARCHAR,
  "total_votes" BIGINT
);

Senate County

@kaggle.unanimad_us_election_2020.senate_county

69.6 kB
3,582 rows
5 columns

CREATE TABLE senate_county (
  "state" VARCHAR,
  "county" VARCHAR,
  "current_votes" BIGINT,
  "total_votes" BIGINT,
  "percent" BIGINT
);

Senate County Candidate

@kaggle.unanimad_us_election_2020.senate_county_candidate

89.3 kB
14,125 rows
5 columns

CREATE TABLE senate_county_candidate (
  "state" VARCHAR,
  "county" VARCHAR,
  "candidate" VARCHAR,
  "party" VARCHAR,
  "total_votes" BIGINT
);

Senate State

@kaggle.unanimad_us_election_2020.senate_state

2.76 kB
35 rows
2 columns

CREATE TABLE senate_state (
  "state" VARCHAR,
  "total_votes" BIGINT
);