out_sec10k__quarterly_filings

package: pudl
Log in or sign up to preview / export as CSV Download full table as Parquet

Quarterly time series of metadata describing 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

Usage Warnings

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

Additional Details

Each SEC 10-K filing is submitted by a single company, but may contain information about numerous other companies. This table indicates the company submitting the filing, as well as some information about the overall filing. Each filing is guaranteed to have a unique filename, but ~1% of all filings are one company submitting the same form multiple times on the same day, so the filename is the only available natural primary key. This output table adds a link to the source URL for the filing, which is constructed from the filename.

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.

company_name

Name of the reporting company.

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.

filing_date

Date on which the filing was submitted.

exhibit_21_version

Version of exhibit 21 submitted (if applicable).

report_date

Date reported.

source_url

URL pointing to the original source of the data in the record.