TDnet on Snowflake

You can retrieve the Near Real Timely Disclosure Information dataset.

Overview

This dataset provides all disclosure information from listed companies that could influence investment decisions—including earnings releases, revisions to earnings and dividend forecasts, and announcements related to share buybacks. Each record represents a single disclosure and includes details on the company, the type of disclosure, and a URL where the disclosure documents can be downloaded.

Important Notes

• This dataset is distributed only on Snowflake.

Data Retrieval Method

The data is published on Snowflake by sharing Secure Views. The Secure View names for each dataset are as follows:

Dataset Name	Snowflake Share	Schema	Secure View
TDnet on Snowflake	JQ_TDNET_SHARE	SHARED	JQ_TDNET_VIEW
Disclosure Code List	JQ_TDNET_SHARE	SHARED	JQ_TDNET_DISCLOSURE_ITEMS_CODE_VIEW

For specific data retrieval methods on Snowflake, please refer to the official Snowflake documentation.

Data Items Overview

TDnet on Snowflake

Variable	Description	Type	Notes
DISCLOSED_DATE	Disclosure date	Date	YYYY-MM-DD
DISCLOSED_TIME	Disclosure time	Time	HH:MM:SS
CODE	Issue code (5 digits)	String
COMPANY_NAME	Company name	String
TITLE	Disclosure title	String
DISCLOSURE_ITEMS	Disclosure item numbers	List(String)	Please refer to the Disclosure Code List for the list of public item numbers.
DOWNLOAD_URL	URL of the disclosed PDF file	String	Valid for 30 minutes after URL issuance
URL_EXPIRES_AT	Expiration time for downloading the PDF file	Timestamp_LTZ	(e.g.) 2025-08-27 13:29:04.286

(Disclosure Code List)

Variable	Description	Type	Notes
ASSET_CLASS	Product Type	String	1: Equities, 2: REITs, 3: ETFs/ETNs
MAJOR_CATEGORY	Major Category	String
SUB_CATEGORY	Subcategory	String
DISCLOSURE_ITEMS	Disclosure Item ID	Number	A unique identifier used to manage disclosure items (Product Category [1 digit] + Entity Category [1 digit] + Disclosure Item [3 digits]) The 2nd digit (Entity Category): 1: Main entity, 2: Subsidiary, 3: Parent company, 4: Investment corporation, 5: Asset management company, etc., 6: ETF, 7: ETN
DISCLOSURE_ITEMS_NAME	Disclosure Item Name	String
DOCUMENT_TYPE	Document Category	String
DOCUMENT_TYPE_NAME	Document Category Name	String