out_ferc714__summarized_demand

package: pudl

Summarized demand statistics and FERC-714 respondent attributes by respondent-year.

Most-recent data:

2024

Processing:

Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.

Source:

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

Primary key:

respondent_id_ferc714, report_date

Usage Warnings

  • 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.

Columns
report_date

Date reported.

respondent_id_ferc714

PUDL-assigned identifying a respondent to FERC Form 714. This ID associates natively reported respondent IDs from the original CSV and XBRL data sources.

demand_annual_mwh

Annual electricity demand in a given report year.

population

County population, sourced from Census DP1 data.

area_km2

County area in km2.

population_density_km2

Average population per sq. km area of a service territory.

demand_annual_per_capita_mwh

Per-capita annual demand, averaged using Census county-level population estimates.

demand_density_mwh_km2

Annual demand per km2 of a given service territory.

eia_code

EIA utility or balancing area authority ID associated with this FERC Form 714 respondent. Note that many utilities are also balancing authorities and in many cases EIA uses the same integer ID to identify a utility in its role as a balancing authority AND as a utility, but there is no requirement that these IDs be the same, and in a number of cases they are different.

respondent_type

Whether a respondent to the FERC form 714 is a utility or a balancing authority.

respondent_name_ferc714

Name of the utility, balancing area authority, or planning authority responding to FERC Form 714.

balancing_authority_id_eia

EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.

balancing_authority_code_eia

EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.

balancing_authority_name_eia

Name of the balancing authority.

utility_id_eia

The EIA Utility Identification number.

utility_name_eia

The name of the utility.