Name: US Energy Generation 2001-2022
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.9 MB
496,774 rows
7 columns

CREATE TABLE organised_gen (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "year" BIGINT,
  "month" BIGINT,
  "state" VARCHAR,
  "type_of_producer" VARCHAR,
  "energy_source" VARCHAR,
  "generation_megawatthours" DOUBLE  -- GENERATION (Megawatthours)
);

States

@kaggle.kevinmorgado_us_energy_generation_2001_2022.states

3.7 kB
51 rows
3 columns

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