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.4 MB
121,273 rows
2 columns

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

Comed Hourly

@kaggle.robikscube_hourly_energy_consumption.comed_hourly

785.42 kB
66,497 rows
2 columns

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

Dayton Hourly

@kaggle.robikscube_hourly_energy_consumption.dayton_hourly

1.32 MB
121,275 rows
2 columns

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

Deok Hourly

@kaggle.robikscube_hourly_energy_consumption.deok_hourly

633.28 kB
57,739 rows
2 columns

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

Dom Hourly

@kaggle.robikscube_hourly_energy_consumption.dom_hourly

1.34 MB
116,189 rows
2 columns

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

Duq Hourly

@kaggle.robikscube_hourly_energy_consumption.duq_hourly

1.28 MB
119,068 rows
2 columns

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

Ekpc Hourly

@kaggle.robikscube_hourly_energy_consumption.ekpc_hourly

495.79 kB
45,334 rows
2 columns

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

Fe Hourly

@kaggle.robikscube_hourly_energy_consumption.fe_hourly

711.07 kB
62,874 rows
2 columns

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

Ni Hourly

@kaggle.robikscube_hourly_energy_consumption.ni_hourly

687.9 kB
58,450 rows
2 columns

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

Pjme Hourly

@kaggle.robikscube_hourly_energy_consumption.pjme_hourly

1.75 MB
145,366 rows
2 columns

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

Pjm Hourly Est

@kaggle.robikscube_hourly_energy_consumption.pjm_hourly_est

3.88 MB
178,262 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

445.83 kB
32,896 rows
2 columns

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

Pjmw Hourly

@kaggle.robikscube_hourly_energy_consumption.pjmw_hourly

1.59 MB
143,206 rows
2 columns

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