core_ferceqr__quarterly_index_pub
Quarterly time series of electricity market price indices that individual EQR filers reported transactions to.
- 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:
year_quarter, company_id_ferc, filer_unique_id
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.
The name of the company that is 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. This name must match the name provided as seller_company_name in the core_ferceqr__quarterly_identity table. There are a handful of cases in which this requirement is violated, so any joins between tables should rely on company_id_ferc, not the company names.
Name of index price publisher, which can be one of the following: AM - Argus Media, EIG - Energy Intelligence Group, Inc., IP - Intelligence Press, P - Platts, B - Bloomberg, PDX - Powerdex, SNL - SNL Energy
Description of the types of transactions reported to the index publisher identified in this record.