core_ferceqr__quarterly_identity
Quarterly time series of individuals who filed FERC EQR for a company in a given quarter.
- Most-recent data:
2026q1
- 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 920 -- Electric Quarterly Report (EQR)
- Primary key:
This table has no primary key. The primary key ought to be ['year_quarter', 'company_id_ferc', 'filer_unique_id'], where filer_unique_id is an employee-level ID. However, a handful of companies have erroneously reported the same filer_unique_id for multiple employees, resulting in duplicate records. In other cases, there appear to be multiple filings in a given quarter for the same company and filer, resulting in additional duplicates. Thus, there is no reliable natural primary key for the identity table.
Usage Warnings
This table is experimental and/or a work in progress and may change in the future.
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
Year-quarter corresponding to record. Formatted like YYYYq{1-4}.
The Company Identifier (CID) obtained through FERC's Company Registration system.
(Seller) An identifier (e.g., “FS1”, “FS2”) used to designate a record containing Seller identification information. One record for each seller company must be included in an EQR for a given quarter. (Agent) – An identifier (i.e., “FA1”) used to designate a record containing Agent identification information. One record with the FA1 identifier must be included in an EQR for a given quarter.
Name of the reporting company.
(Seller) – The name of the contact for the company authorized to make sales as indicated in the company’s FERC tariff(s) or that is required to file the EQR under section 220 of the Federal Power Act. (Agent) – Name of the person who prepared the filing
Title of of utility contact 1.
Street address 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.
Country (USA, Canada, Mexico, or United Kingdom) for contact identified in contact_name.
Phone number for contact identified in contact_name.
Email for contact identified in contact_name.
Sellers should indicate whether they have reported their sales transactions to index price publisher(s). If they have, Sellers should indicate specifically which index publisher(s) in Field Number 73.