out_sec10k__parents_and_subsidiaries
A denormalized table containing information about parent companies that file SEC Form 10-K and their subsidiaries, which may or may not file Form 10-K.
- Most-recent data:
2023
- Processing:
Data has been expanded into a wide/denormalized format, with IDs and codes accompanied by human-readable names and descriptions.
- Source:
U.S. Securities and Exchange Commission (SEC) Form 10-K
- Primary key:
filename_sec10k, subsidiary_company_id_sec10k
Usage Warnings
This data has been extracted probabilistically using a machine learning model and contains some incompletions and errors. It should not be treated as ground truth data.
PUDL does not currently update its copy of this data.
Additional Details
Company ownership fractions are extracted from SEC 10-K Exhibit 21. Information about the companies is extracted primarily from the headers of the SEC 10-K filing. Subsidiaries that file Form 10-K will have much more information available than those that only appear as subsidiaries in Exhibit 21.
SEC 10-K filers and EIA utilities are matched using probabilistic record linkage. Exhibit 21 subsidiaries that don't file a Form 10-K are matched to EIA utilities using the company name.
Columns
Unique portion of the filename associated with the SEC 10-K filing in the EDGAR database. The full source URL can be reconstructed by prepending https://www.sec.gov/Archives/edgar/data/ and adding the .txt file type extension.
Name of subsidiary company.
Location of subsidiary company. This is the full US state name or country name and occasionally a two digit code that was not mapped to a full name during cleaning.
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.
Proportion of generator ownership attributable to this utility.
Central index key (CIK) of the parent company.
Name of the parent company.
Date on which the filing was submitted.
Date reported.
Phone number of the parent company.
City where the parent company's place of business is located.
State where the parent company's place of business is located.
Street address of the parent company's place of business.
Second line of the street address of the parent company's place of business.
Zip code of the parent company's place of business.
Zip code suffix of the company's place of business.
City of the parent company's mailing address.
State of the parent company's mailing address.
Street portion of the parent company's mailing address.
Second line of the street portion of the parent company's mailing address.
Zip code of the parent company's mailing address.
Zip code suffix of the parent company's mailing address.
Two letter state code where parent company is incorporated.
The EIA utility ID of the parent company.
The EIA reported utility name of the parent company.
Text description of the parent company's Standard Industrial Classification (SIC)
Four-digit Standard Industrial Classification (SIC) code identifying the parent company's primary industry. SIC codes have been replaced by NAICS codes in many applications, but are still used by the SEC. See e.g. https://www.osha.gov/data/sic-manual for code definitions.
Taxpayer ID of the parent company with the IRS.
Central index key (CIK) of the subsidiary company.
Phone number of the subsidiary company.
City where the subsidiary company's place of business is located.
State where the subsidiary company's place of business is located.
Street address of the subsidiary company's place of business.
Second line of the street address of the subsidiary company's place of business.
Zip code of the subsidiary company's place of business.
Zip code suffix of the subsidiary company's place of business.
City of the subsidiary company's mailing address.
State of the parent company's mailing address.
Street portion of the subsidiary company's mailing address.
Second line of the street portion of the subsidiary company's mailing address.
Zip code of the subsidiary company's mailing address.
Zip code suffix of the subsidiary company's mailing address.
Two letter state code where subisidary company is incorporated.
The EIA utility ID of the subsidiary company.
The EIA reported utility name of the subsidiary company.
Text description of the subsidiary company's Standard Industrial Classification (SIC)
Four-digit Standard Industrial Classification (SIC) code identifying the subsidiary company's primary industry. SIC codes have been replaced by NAICS codes in many applications, but are still used by the SEC. See e.g. https://www.osha.gov/data/sic-manual for code definitions.
Taxpayer ID of the subsidiary company with the IRS.