out_sec10k__quarterly_company_information
Quarterly time series of company and filing data extracted from SEC 10-K filings.
- 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, central_index_key
Usage Warnings
PUDL does not currently update its copy of this data.
Additional Details
In addition to the information provided by the core_sec10k__quarterly_company_information table, this output table merges in the associated utility_id_eia (and utility name) if it is available, as well as the report and filing dates associated with the filing each record was extracted from, as well as providing a link to the source URL for the filing.
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.
Identifier of the company in SEC database.
A counter indicating which observation of company data within an SEC 10-K filing header the record pertains to.
The EIA Utility Identification number.
The name of the utility.
Date reported.
Date on which the filing was submitted.
Name of the reporting company.
The end date of an SEC filing company's fiscal year, in MMDD format.
Taxpayer ID of the company with the IRS.
Two letter state code where company is incorporated.
Text description of Standard Industrial Classification (SIC)
A higher level industry category defined within the Standard Industrial Classification (SIC) system.
Four-digit Standard Industrial Classification (SIC) code identifying the 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.
Document control number used in the SEC EDGAR database. The first four digits can be used to access scans of the document in the SEC's Virtual Private Reference Room.
Specific version of SEC 10-K that was filed. 10-k: the standard annual report. 10-k/a: an amended version of the annual report. 10-k405: filed to report insider trading that was not reported in a timely fashion. 10-k405/a: an amended version of the 10-k405. 10-kt: submitted in lieu of or in addition to a standard 10-K annual report when a company changes the end of its fiscal year (e.g. due to a merger) leaving the company with a longer or shorter reporting period. 10-kt/a: an amended version of the 10-kt. 10-ksb: the annual report for small businesses, also known as penny stocks. 10-ksb/a: an amended version of the 10-ksb.
SEC Act through which the form was enacted, e.g. 1934 act.
Filing number used internally by the SEC commission to track filing.
Phone number for utility contact 1.
Street address of the company's place of business.
Second line of the street address of the company's place of business.
City where the company's place of business is located.
State where the company's place of business is located.
Zip code of the company's place of business.
Zip code suffix of the company's place of business.
Non-US postal code of the company's place of business.
Street portion of the company's mailing address.
Second line of the street portion of the company's mailing address.
City of the company's mailing address.
State of the company's mailing address.
Zip code of the company's mailing address.
Zip code suffix of the company's mailing address.
Non-US postal code of the company's mailing address.
URL pointing to the original source of the data in the record.