Name: Hourly Energy Consumption
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Hourly Energy Consumption

PJM Hourly Energy Consumption Data

PJM Interconnection LLC (PJM) is a regional transmission organization (RTO) in the United States. It is part of the Eastern Interconnection grid operating an electric transmission system serving all or parts of Delaware, Illinois, Indiana, Kentucky, Maryland, Michigan, New Jersey, North Carolina, Ohio, Pennsylvania, Tennessee, Virginia, West Virginia, and the District of Columbia.

The hourly power consumption data comes from PJM's website and are in megawatts (MW).

The regions have changed over the years so data may only appear for certain dates per region.

Ideas of what you could do with this dataset:

Split the last year into a test set- can you build a model to predict energy consumption?
Find trends in energy consumption around hours of the day, holidays, or long term trends?
Understand how daily trends change depending of the time of year. Summer trends are very different than winter trends.

Tables

Aep Hourly

@kaggle.robikscube_hourly_energy_consumption.aep_hourly

1.34 MB
121273 rows
2 columns


CREATE TABLE aep_hourly (
  "datetime" TIMESTAMP,
  "aep_mw" DOUBLE
);

Comed Hourly

@kaggle.robikscube_hourly_energy_consumption.comed_hourly

767.01 KB
66497 rows
2 columns


CREATE TABLE comed_hourly (
  "datetime" TIMESTAMP,
  "comed_mw" DOUBLE
);

Dayton Hourly

@kaggle.robikscube_hourly_energy_consumption.dayton_hourly

1.26 MB
121275 rows
2 columns


CREATE TABLE dayton_hourly (
  "datetime" TIMESTAMP,
  "dayton_mw" DOUBLE
);

Deok Hourly

@kaggle.robikscube_hourly_energy_consumption.deok_hourly

618.44 KB
57739 rows
2 columns


CREATE TABLE deok_hourly (
  "datetime" TIMESTAMP,
  "deok_mw" DOUBLE
);

Dom Hourly

@kaggle.robikscube_hourly_energy_consumption.dom_hourly

1.28 MB
116189 rows
2 columns


CREATE TABLE dom_hourly (
  "datetime" TIMESTAMP,
  "dom_mw" DOUBLE
);

Duq Hourly

@kaggle.robikscube_hourly_energy_consumption.duq_hourly

1.22 MB
119068 rows
2 columns


CREATE TABLE duq_hourly (
  "datetime" TIMESTAMP,
  "duq_mw" DOUBLE
);

Ekpc Hourly

@kaggle.robikscube_hourly_energy_consumption.ekpc_hourly

484.17 KB
45334 rows
2 columns


CREATE TABLE ekpc_hourly (
  "datetime" TIMESTAMP,
  "ekpc_mw" DOUBLE
);

Fe Hourly

@kaggle.robikscube_hourly_energy_consumption.fe_hourly

694.4 KB
62874 rows
2 columns


CREATE TABLE fe_hourly (
  "datetime" TIMESTAMP,
  "fe_mw" DOUBLE
);

Ni Hourly

@kaggle.robikscube_hourly_energy_consumption.ni_hourly

671.78 KB
58450 rows
2 columns


CREATE TABLE ni_hourly (
  "datetime" TIMESTAMP,
  "ni_mw" DOUBLE
);

Pjme Hourly

@kaggle.robikscube_hourly_energy_consumption.pjme_hourly

1.67 MB
145366 rows
2 columns


CREATE TABLE pjme_hourly (
  "datetime" TIMESTAMP,
  "pjme_mw" DOUBLE
);

Pjm Hourly Est

@kaggle.robikscube_hourly_energy_consumption.pjm_hourly_est

3.7 MB
178262 rows
13 columns


CREATE TABLE pjm_hourly_est (
  "datetime" TIMESTAMP,
  "aep" DOUBLE,
  "comed" DOUBLE,
  "dayton" DOUBLE,
  "deok" DOUBLE,
  "dom" DOUBLE,
  "duq" DOUBLE,
  "ekpc" DOUBLE,
  "fe" DOUBLE,
  "ni" DOUBLE,
  "pjme" DOUBLE,
  "pjmw" DOUBLE,
  "pjm_load" DOUBLE
);

Pjm Load Hourly

@kaggle.robikscube_hourly_energy_consumption.pjm_load_hourly

435.38 KB
32896 rows
2 columns


CREATE TABLE pjm_load_hourly (
  "datetime" TIMESTAMP,
  "pjm_load_mw" DOUBLE
);

Pjmw Hourly

@kaggle.robikscube_hourly_energy_consumption.pjmw_hourly

1.51 MB
143206 rows
2 columns


CREATE TABLE pjmw_hourly (
  "datetime" TIMESTAMP,
  "pjmw_mw" DOUBLE
);