Dataset: US Energy Generation 2001-2022

About this Dataset

US Energy Generation 2001-2022

This CSV (organised_Gen.csv) is adapted from https://www.eia.gov/electricity/, where the main information related to energy usage in the United States is located. This dataset has the following columns:

YEAR
MONTH
STATE
TYPE OF PRODUCER
ENERGY SOURCE
GENERATION (Megawatt-hours)

Also, there is an additional states.csv with the State abbreviations and used in the guiding notebook:

https://www.kaggle.com/code/kevinmorgado/us-monthly-generation-eda

Source: U.S. Energy Information Administration (Sep 2021).

Tables

Organised Gen

@kaggle.kevinmorgado_us_energy_generation_2001_2022.organised_gen

3.72 MB
496774 rows
7 columns


CREATE TABLE organised_gen (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "month" BIGINT,
  "state" VARCHAR,
  "type_of_producer" VARCHAR,
  "energy_source" VARCHAR,
  "generation_megawatthours" DOUBLE
);

States

@kaggle.kevinmorgado_us_energy_generation_2001_2022.states

3.62 KB
51 rows
3 columns


CREATE TABLE states (
  "state" VARCHAR,
  "abbrev" VARCHAR,
  "code" VARCHAR
);