TDnet on Snowflake T+1

You can retrieve the timely disclosure information released on the day, starting the next day.

Overview

This dataset provides all semi-urgent timely disclosures by listed companies that could influence investment decisions—such as earnings reports, revisions to earnings and dividend forecasts, and announcements related to share buybacks. Covered documents include PDF, XBRL, HTML, and similar formats.

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 T+1	DB_PROD_JL_SNOWFLAKE_SHARE_TDT1	SHARED_TD	VIEW_TDNET_T1
Disclosure Code List	DB_PROD_JL_SNOWFLAKE_SHARE_TDT1	SHARED_TD	VIEW_INDEX_DISCLOSURE_CODE

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

Data Items Overview

TDnet on Snowflake T+1

Variable	Description	Type	Notes
DISCLOSED_DATE	Disclosure date	Date	YYYY-MM-DD
DISCLOSED_TIME	Disclosure time	Time	HH:MM:SS
STATUS_FLAG	Status	String	Use 'new' for newly posted items; use 'revision' for updates
ISSUE_CODE	Security code (5 digits)	String
COMPANY_NAME_JP	Company name (Japanese)	String
COMPANY_NAME_EN	Company name (English)	String
TITLE	Disclosure title	String
DISCLOSURE_ITEMS	Disclosure item number	String	Unique identifier for disclosure items (product category [1 digit] + entity category [1 digit] + item [3 digits])
FILE_NAME	Disclosure PDF file name	String
FILE_URL	Disclosure file download URL	String	Updated at 15 and 45 minutes past each hour. Valid for 35 minutes

(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