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

circle-exclamation

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 documentationarrow-up-right.

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

Last updated