core_ferc1__yearly_identification_certification
Return to SearchAnnual time series of respondent identification and corporate officer certification information.
- Most-recent data:
2024
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
FERC Form 1 -- Annual Report of Major Electric Utilities (Part I and II)
- Primary key:
utility_id_ferc1, report_year, report_filing_type
Usage Warnings
Contains columns which may appear categorical, but are actually free text.
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 contains information identifying a utility's contact information, addresses and individuals responsible for accounting and certification. Note that the entity_id_gleif field does not conform to the expected format and largely includes the names of respondents.
Columns
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year.
Four-digit year in which the data was reported.
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped.
Name of the responding utility, as it is reported in FERC Form 1. For human readability only.
Former name of the responding utility, when it changed within the last year.
Date of last name change of the company.
The Company Identifier (CID) obtained through FERC's Company Registration system.
Legal Entity Identification Number issued by Global Legal Entity Identifier Foundation (GLEIF). The Legal Entity Identifier (LEI) is a 20-character, alpha-numeric code based on the ISO 17442 standard developed by the International Organization for Standardization (ISO).
Name of contact person for the respondent.
Title of contact person for the respondent.
Email for contact identified in contact_name.
Street address for contact identified in contact_name.
Phone number for contact identified in contact_name.
City for contact identified in contact_name.
State for contact identified in contact_name.
Zip code for contact identified in contact_name.
Street address of principal office at end of period.
City of principal office at end of period.
State of principal office at end of period.
Zipcode of principal office at end of period.
Name of person signing the corporate officer's certification.
Title of person signing the corporate officer's certification.
Date that corporate officer's certification was signed.
Signature of corporate officer to certify the report.
Name of software company used for creating the instance file submitted. If the filer created the submission, is null
Type of report submitted: O (original) or R (revision).
Date on which the filing was submitted.