core_sec10k__assn_exhibit_21_subsidiaries_and_eia_utilities
Return to SearchAssociation table providing connections between subsidiaries listed in Exhibit 21 and EIA utilities.
- Most-recent data:
2023
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- Source:
U.S. Securities and Exchange Commission (SEC) Form 10-K
- Primary key:
subsidiary_company_id_sec10k
Usage Warnings
PUDL does not currently update its copy of this data.
Additional Details
An Exhibit 21 subsidiary is considered matched to an EIA utility if their names are identical. Only subsidiaries that don't file SEC 10-K themselves are included in this table. SEC 10-K filers have much more information available and are matched to EIA utilities using probabilistic record linkage in core_sec10k__assn_sec10k_filers_and_eia_utilities.
Columns
PUDL-assigned ID for subsidiaries found in SEC 10-K Exhibit 21. The ID is created by concatenating the CIK of the company whose filing the subsidiary was found in, the subsidiary company's name, and location of incorporation. It is not guaranteed to be stable across different releases of PUDL and so should never be hard-coded in analyses.
The EIA Utility Identification number.