core_sec10k__quarterly_company_information

package: pudl

Quarterly time series of company and filing information extracted from SEC 10-K filing headers.

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:

filename_sec10k, central_index_key

Usage Warnings

  • PUDL does not currently update its copy of this data.

Additional Details

While the SEC 10-K filings are submitted by a single company, they often contain references to many other related companies. Information about these companies and the filing itself are contained in text headers at the beginning of the filing. This table contains data extracted from those headers. Each record in this table represents a single observation of a company in a single filing. The filer_count indicates which referenced company within a filing header the record corresponds to.

Because the same company may be referenced in a number of different filings submitted in the same reporting period or even on the same day, this table contains apparently duplicative records about many companies, that may be distinguished only by the filename associated with the filing they appeared in and their filer count. Note that all references to a particular company may not be perfectly consistent across all filings in which they appear. The various company names, addresses, and other information associated with the company's unique and permanent central_index_key are later used as inputs into the probabilistic record linkage process.

Columns
filename_sec10k

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.

central_index_key

Identifier of the company in SEC database.

filer_count

A counter indicating which observation of company data within an SEC 10-K filing header the record pertains to.

company_name

Name of the reporting company.

fiscal_year_end

The end date of an SEC filing company's fiscal year, in MMDD format.

taxpayer_id_irs

Taxpayer ID of the company with the IRS.

incorporation_state

Two letter state code where company is incorporated.

industry_name_sic

Text description of Standard Industrial Classification (SIC)

industry_id_sic

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.

film_number

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.

sec10k_type

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

SEC Act through which the form was enacted, e.g. 1934 act.

filing_number_sec

Filing number used internally by the SEC commission to track filing.

phone_number

Phone number for utility contact 1.

business_street_address

Street address of the company's place of business.

business_street_address_2

Second line of the street address of the company's place of business.

business_city

City where the company's place of business is located.

business_state

State where the company's place of business is located.

business_zip_code

Zip code of the company's place of business.

business_zip_code_4

Zip code suffix of the company's place of business.

business_postal_code

Non-US postal code of the company's place of business.

mail_street_address

Street portion of the company's mailing address.

mail_street_address_2

Second line of the street portion of the company's mailing address.

mail_city

City of the company's mailing address.

mail_state

State of the company's mailing address.

mail_zip_code

Zip code of the company's mailing address.

mail_zip_code_4

Zip code suffix of the company's mailing address.

mail_postal_code

Non-US postal code of the company's mailing address.