out_ferc714__respondents_with_fips
Annual respondents with the county FIPS IDs for their service territories.
- 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:
This table has no primary key. Note that the state and county FIPS columns can be null. Otherwise the natural primary key would be: ['respondent_id_ferc714', 'report_date', 'county_id_fips']. The state FIPS code is not part of the primary key because the first two digits of the county FIPS code indicate the state.
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.
Columns
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.
Whether a respondent to the FERC form 714 is a utility or a balancing authority.
PUDL-assigned identifying a respondent to FERC Form 714. This ID associates natively reported respondent IDs from the original CSV and XBRL data sources.
Name of the utility, balancing area authority, or planning authority responding to FERC Form 714.
Date reported.
EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity.
EIA short code identifying a balancing authority. May include Canadian and Mexican BAs.
Name of the balancing authority.
The EIA Utility Identification number.
The name of the utility.
Two letter US state abbreviation.
County name.
Two digit state FIPS code.
County ID from the Federal Information Processing Standard Publication 6-4.