out_ferc714__georeferenced_respondents

package: pudl

Annual summary of demand and other information about FERC-714 respondents.

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

  • 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 differs from out_ferc714__summarized_demand in that it also includes a geometry column describing the respondent's service territory in each year. These service territories are based on the counties that the corresponding EIA-861 respondent reported serving in that year. There is sometimes ambiguity as to whether a FERC-714 respondent should be interpreted as an individual utility or a balancing authority. The respodent_type column indicates which type of entity has been assumed in determining the service territory from EIA-861 data.

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.

geometry

Geospatial representation of the feature.

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.

population

County population, sourced from Census DP1 data.

area_km2

County area in km2.

demand_annual_mwh

Annual electricity demand in a given report year.