Baselight

US Energy Generation 2001-2022

Monthly Generation by State, type of producer and type of source

@kaggle.kevinmorgado_us_energy_generation_2001_2022

Organised Gen
@kaggle.kevinmorgado_us_energy_generation_2001_2022.organised_gen

  • 3.72 MB
  • 496774 rows
  • 7 columns
unnamed_0

Unnamed: 0

year

YEAR

month

MONTH

state

STATE

type_of_producer

TYPE OF PRODUCER

energy_source

ENERGY SOURCE

generation_megawatthours

GENERATION (Megawatthours)

20011AKTotal Electric Power IndustryCoal46903
120011AKTotal Electric Power IndustryPetroleum71085
220011AKTotal Electric Power IndustryNatural Gas367521
320011AKTotal Electric Power IndustryHydroelectric Conventional104549
420011AKTotal Electric Power IndustryWind87
520011AKTotal Electric Power IndustryTotal590145
620011AKElectric Generators, Electric UtilitiesCoal18410
720011AKElectric Generators, Electric UtilitiesPetroleum64883
820011AKElectric Generators, Electric UtilitiesNatural Gas305277
920011AKElectric Generators, Electric UtilitiesHydroelectric Conventional104549

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

Share link

Anyone who has the link will be able to view this.