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

23.74 KB
1025 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

34.79 KB
5145 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.27 KB
11 rows
2 columns


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

House Candidate

@kaggle.unanimad_us_election_2020.house_candidate

31.15 KB
1215 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.08 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

88.14 KB
4633 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

156.51 KB
32177 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.02 KB
52 rows
2 columns


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

Senate County

@kaggle.unanimad_us_election_2020.senate_county

67.97 KB
3582 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

87.21 KB
14125 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.69 KB
35 rows
2 columns


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