out_ferc714__hourly_estimated_state_demand

package: pudl

Hourly time series of estimated electricity demand for each state, scaled such that it matches the total electricity sales by state reported in EIA 861.

Most-recent data:

2024

Processing:

Data is ready for use in analyses, but for practical reasons has not been denormalized and remains in narrow format.

Source:

FERC Form 714 -- Annual Electric Balancing Authority Area and Planning Area Report

Primary key:

state_id_fips, datetime_utc

Usage Warnings

  • Contains estimated values.

  • Contains information from multiple raw inputs.

  • Large table; do not attempt to open with Excel.

  • Contains information from multiple raw inputs.

  • FERC data is notoriously difficult to extract cleanly, and often contains free-form strings, non-labeled total rows and lack of IDs. See Notable Irregularities for details.

Additional Details

This table uses hourly electricity demand and information about service territories to estimate the total hourly electricity demand for each US state. Hourly demand is drawn from the FERC 714, which reports at the balancing authority and utility level. Service territories for utilities and balancing authorities are inferred from information in the EIA 861, including the counties served by each utility and the utilities that make up each balancing authority.

This table uses the total electricity sales by state reported in the EIA 861 as a scaling factor to ensure that the magnitude of electricity sales is roughly correct, and obtains the shape of the demand curve from the hourly planning area demand reported in the FERC 714.

This table includes the state FIPS codes - see out_censusdp1tract__states for additional information about FIPS state codes.

Columns
state_id_fips

Two digit state FIPS code.

datetime_utc

Date and time converted to Coordinated Universal Time (UTC).

demand_mwh

Electricity demand (energy) within a given timeframe.

scaled_demand_mwh

Estimated electricity demand scaled by the total sales within a state.