Survivorship-bias-free, Point-in-Time Japanese annual securities filings (Parquet & DuckDB) with exact filing timestamps (submit_datetime) and year-over-year risk disclosure drift scores (risk_change_score).
Amendment filings (doc_type_code = 130) never overwrite earlier filing history. Filtering by submit_datetime <= as_of returns only the figures actually known to the market on that date.
Retains delisted issuers from official EDINET submissions and precomputes year-over-year cosine distance on the “Business Risks” section using intfloat/multilingual-e5-large.
Measured across 148 Japanese listed companies comparing 2025 and 2026 annual securities reports (有価証券報告書):
0.001543 (bottom 25% at 0.000253 or lower, indicating largely unchanged risk text)0.023372 (roughly 15× the median)0.023372) and Daito Trust Construction (0.018248).pit_metrics Table)| Column | Type | Description |
|---|---|---|
doc_id | String | EDINET document ID (e.g., S100YDF3) |
edinet_code | String | EDINET issuer code (e.g., E01441) |
sec_code | String | 5-digit securities code (e.g., 59730) |
filer_name | String | Issuer legal name |
doc_type_code | String | Filing type (120: Annual Report, 130: Amendment) |
is_amendment | Boolean | Amendment filing flag |
period_end | Date | Fiscal period end (YYYY-MM-DD) |
submit_datetime | Datetime | Submission timestamp (Point-in-Time cutoff key) |
metric_name | String | Normalized metric (net_sales, operating_income, ordinary_income, net_income, net_assets, total_assets, operating_cf) |
metric_value | Float64 | Financial value in JPY |
risk_change_score | Float64 | Year-over-year cosine distance of Business Risks text |
Download sample/edinet_pit_sample.parquet or sample/edinet_pit_sample.duckdb from GitHub or Hugging Face and query Point-in-Time snapshots locally:
SELECT sec_code, filer_name, period_end, metric_name, metric_value, risk_change_score
FROM read_parquet('sample/edinet_pit_sample.parquet')
WHERE submit_datetime <= TIMESTAMP '2026-06-26 00:00:00'
QUALIFY ROW_NUMBER() OVER (
PARTITION BY edinet_code, period_end, metric_name
ORDER BY submit_datetime DESC
) = 1;
全上場企業(上場廃止含む)・過去 5〜10 年分のフルデータセット(初期買い切り ¥20,000 想定 / 月次更新サブスク ¥3,500 想定)の先行リリース案内および追加指標リクエストを受け付けています。必要な期間や銘柄範囲・希望フォーマットをお知らせください。