core_ferc__entity_companies
Return to SearchEntity table containing static information about the companies that submit required filings to FERC.
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
FERC -- Mix of multiple FERC Forms
- Primary key:
company_id_ferc
Usage Warnings
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
The Company Identifier (CID) obtained through FERC's Company Registration system.
The name of the FERC-reporting organization or company.
The specific program or initiative associated with the FERC organization, which can provide context for the company's activities.
The website URL of the company, which can provide additional information about the organization.
Physical street address.
Second line of the address.
Name of the city.
Two letter US state abbreviation.
Five digit US Zip Code.
Four digit US Zip Code suffix.