pudl.output.sec10k¶
Denormalized output tables for the SEC 10-K assets.
These tables are created by joining the raw SEC 10-K tables with other data from the PUDL database, and enriching them with additional information. The resulting tables are more user-friendly and easier to work with than the normalized core tables.
Functions¶
|
Construct the source URL for SEC 10-K filings. |
|
Denormalized table for SEC 10-K quarterly filings. |
Company information extracted from SEC10k filings and matched to EIA utilities. |
|
|
Denormalized table for company name changes from SEC 10-K filings. |
Module Contents¶
- pudl.output.sec10k._filename_sec10k_to_source_url(filename_sec10k: pandas.Series) pandas.Series[source]¶
Construct the source URL for SEC 10-K filings.
- pudl.output.sec10k.out_sec10k__quarterly_filings(core_sec10k__quarterly_filings: pandas.DataFrame) pandas.DataFrame[source]¶
Denormalized table for SEC 10-K quarterly filings.
This table contains the basic information about the quarterly filings, including the filing date, report date, and the URL to the filing.
- pudl.output.sec10k.out_sec10k__quarterly_company_information(core_sec10k__quarterly_company_information: pandas.DataFrame, core_sec10k__quarterly_filings: pandas.DataFrame, core_sec10k__assn_sec10k_filers_and_eia_utilities: pandas.DataFrame, core_eia__entity_utilities: pandas.DataFrame) pandas.DataFrame[source]¶
Company information extracted from SEC10k filings and matched to EIA utilities.
- pudl.output.sec10k.out_sec10k__changelog_company_name(core_sec10k__changelog_company_name: pandas.DataFrame) pandas.DataFrame[source]¶
Denormalized table for company name changes from SEC 10-K filings.
The original data contains only the former name and date of the name change, leaving the current name out. This asset constructs a column with the new company name in it, by shifting the old name column by one row within each central_index_key group, and then fills in the last new company name value with the current company name.