Japan Tankan business-conditions DI (quarterly)
Commercial use OKFresh
Query in workbenchThe full snapshot isn't published yet — check back after the next refresh.Download sample CSVDownload sample JSONSample rows only (up to 20) — not the complete dataset.
Quarterly Japan Tankan business-conditions panel, 1967Q3 onward: the Bank of Japan's Short-term Economic Survey diffusion index ("favorable" minus "unfavorable", percentage points) for large, medium-sized and small enterprises, manufacturing and nonmanufacturing, actual result plus the forecast made for that quarter. Carries per-group forecast errors (the famous Tankan conservatism bias), quarter-over-quarter and year-over-year DI changes, the large-minus-small manufacturing gap and the manufacturing-minus-nonmanufacturing gap, and a four-state business-cycle regime on the headline large-manufacturing DI. One row per survey quarter; the grid ends on a forecast-only lead quarter (the forecast for the not-yet-published quarter), and nonmanufacturing columns are structurally null before 1983Q2 (upstream coverage expansion). Who joins this: macro desks read large_mfg_regime and the forecast error as the Japan cycle call; FX/rate models join (quarter) to JPY and JGB series for the BoJ policy read; equity teams use the size and sector gaps for rotation signals.
- Rows
- 237
- Columns
- 38
- Source cadence
- Quarterly
- Last refreshed
- Oct 1, 2026
- Theme
- economy
| Column | Type | Description |
|---|---|---|
| quarter | string | Survey quarter as YYYYQ (panel join key). (unit: string) |
| date | date | First day of the survey quarter (Q1 -> Jan 1, Q2 -> Apr 1, Q3 -> Jul 1, Q4 -> Oct 1). (unit: date) |
| country | string | Country name (shared normalization layer). (unit: string) |
| country_code | string | ISO 3166-1 alpha-3 country code (JPN). (unit: string) |
| di_large_mfg | float | Tankan business-conditions DI for large enterprises, manufacturing — actual result (BOJ series TK99F1000601GCQ01000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_large_mfg_fc | float | Tankan business-conditions DI for large enterprises, manufacturing — forecast result (BOJ series TK99F1000601GCQ11000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_large_nonmfg | float | Tankan business-conditions DI for large enterprises, nonmanufacturing — actual result (BOJ series TK99F2000601GCQ01000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_large_nonmfg_fc | float | Tankan business-conditions DI for large enterprises, nonmanufacturing — forecast result (BOJ series TK99F2000601GCQ11000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_medium_mfg | float | Tankan business-conditions DI for medium enterprises, manufacturing — actual result (BOJ series TK99F1000601GCQ02000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_medium_mfg_fc | float | Tankan business-conditions DI for medium enterprises, manufacturing — forecast result (BOJ series TK99F1000601GCQ12000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_medium_nonmfg | float | Tankan business-conditions DI for medium enterprises, nonmanufacturing — actual result (BOJ series TK99F2000601GCQ02000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_medium_nonmfg_fc | float | Tankan business-conditions DI for medium enterprises, nonmanufacturing — forecast result (BOJ series TK99F2000601GCQ12000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_small_mfg | float | Tankan business-conditions DI for small enterprises, manufacturing — actual result (BOJ series TK99F1000601GCQ03000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_small_mfg_fc | float | Tankan business-conditions DI for small enterprises, manufacturing — forecast result (BOJ series TK99F1000601GCQ13000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_small_nonmfg | float | Tankan business-conditions DI for small enterprises, nonmanufacturing — actual result (BOJ series TK99F2000601GCQ03000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_small_nonmfg_fc | float | Tankan business-conditions DI for small enterprises, nonmanufacturing — forecast result (BOJ series TK99F2000601GCQ13000): "favorable" minus "unfavorable" share, percentage points. (unit: percentage points) |
| di_large_mfg_fc_error | float | Forecast error for large manufacturing: actual DI minus the forecast made for that quarter (null when either is missing). Tankan forecasts skew conservative, so the error is the surprise signal. (unit: percentage points) |
| di_large_nonmfg_fc_error | float | Forecast error for large nonmanufacturing: actual DI minus the forecast made for that quarter (null when either is missing). Tankan forecasts skew conservative, so the error is the surprise signal. (unit: percentage points) |
| di_medium_mfg_fc_error | float | Forecast error for medium manufacturing: actual DI minus the forecast made for that quarter (null when either is missing). Tankan forecasts skew conservative, so the error is the surprise signal. (unit: percentage points) |
| di_medium_nonmfg_fc_error | float | Forecast error for medium nonmanufacturing: actual DI minus the forecast made for that quarter (null when either is missing). Tankan forecasts skew conservative, so the error is the surprise signal. (unit: percentage points) |
| di_small_mfg_fc_error | float | Forecast error for small manufacturing: actual DI minus the forecast made for that quarter (null when either is missing). Tankan forecasts skew conservative, so the error is the surprise signal. (unit: percentage points) |
| di_small_nonmfg_fc_error | float | Forecast error for small nonmanufacturing: actual DI minus the forecast made for that quarter (null when either is missing). Tankan forecasts skew conservative, so the error is the surprise signal. (unit: percentage points) |
| di_large_mfg_qoq_chg | float | Quarter-over-quarter change in the large manufacturing DI (null for the first covered quarter). (unit: percentage points) |
| di_large_nonmfg_qoq_chg | float | Quarter-over-quarter change in the large nonmanufacturing DI (null for the first covered quarter). (unit: percentage points) |
| di_medium_mfg_qoq_chg | float | Quarter-over-quarter change in the medium manufacturing DI (null for the first covered quarter). (unit: percentage points) |
| di_medium_nonmfg_qoq_chg | float | Quarter-over-quarter change in the medium nonmanufacturing DI (null for the first covered quarter). (unit: percentage points) |
| di_small_mfg_qoq_chg | float | Quarter-over-quarter change in the small manufacturing DI (null for the first covered quarter). (unit: percentage points) |
| di_small_nonmfg_qoq_chg | float | Quarter-over-quarter change in the small nonmanufacturing DI (null for the first covered quarter). (unit: percentage points) |
| di_large_mfg_yoy_chg | float | Year-over-year change in the large manufacturing DI (null for the first four covered quarters). (unit: percentage points) |
| di_large_nonmfg_yoy_chg | float | Year-over-year change in the large nonmanufacturing DI (null for the first four covered quarters). (unit: percentage points) |
| di_medium_mfg_yoy_chg | float | Year-over-year change in the medium manufacturing DI (null for the first four covered quarters). (unit: percentage points) |
| di_medium_nonmfg_yoy_chg | float | Year-over-year change in the medium nonmanufacturing DI (null for the first four covered quarters). (unit: percentage points) |
| di_small_mfg_yoy_chg | float | Year-over-year change in the small manufacturing DI (null for the first four covered quarters). (unit: percentage points) |
| di_small_nonmfg_yoy_chg | float | Year-over-year change in the small nonmanufacturing DI (null for the first four covered quarters). (unit: percentage points) |
| large_small_mfg_gap | float | Large-minus-small manufacturing DI: the firm-size divergence in Japanese manufacturing sentiment (null before 1967Q3). (unit: percentage points) |
| mfg_nonmfg_gap_large | float | Manufacturing-minus-nonmanufacturing DI for large enterprises: the sector divergence (null before 1983Q2). (unit: percentage points) |
| large_mfg_regime | string | Four-state business-cycle read on the headline large-manufacturing DI: expansion (DI > 0 and rising), slowdown (DI > 0 and falling), contraction (DI <= 0 and falling), recovery (DI <= 0 and rising). Null when the quarter-over-quarter change is unavailable. (unit: string) |
| row_hash | string | Deterministic 16-hex sha256 of quarter + the 12 DI levels (idempotency key). (unit: string) |
First 10 sample rows — a preview, not the complete dataset.
| quarter | date | country | country_code | di_large_mfg | di_large_mfg_fc | di_large_nonmfg | di_large_nonmfg_fc | di_medium_mfg | di_medium_mfg_fc | di_medium_nonmfg | di_medium_nonmfg_fc | di_small_mfg | di_small_mfg_fc | di_small_nonmfg | di_small_nonmfg_fc | di_large_mfg_fc_error | di_large_nonmfg_fc_error | di_medium_mfg_fc_error | di_medium_nonmfg_fc_error | di_small_mfg_fc_error | di_small_nonmfg_fc_error | di_large_mfg_qoq_chg | di_large_nonmfg_qoq_chg | di_medium_mfg_qoq_chg | di_medium_nonmfg_qoq_chg | di_small_mfg_qoq_chg | di_small_nonmfg_qoq_chg | di_large_mfg_yoy_chg | di_large_nonmfg_yoy_chg | di_medium_mfg_yoy_chg | di_medium_nonmfg_yoy_chg | di_small_mfg_yoy_chg | di_small_nonmfg_yoy_chg | large_small_mfg_gap | mfg_nonmfg_gap_large | large_mfg_regime | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1967Q3 | 1967-07-01 | Japan | JPN | — | — | — | — | — | — | — | — | 43 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | a6369ccf76599353 |
| 1967Q4 | 1967-10-01 | Japan | JPN | — | — | — | — | — | — | — | — | 44 | 51 | — | — | — | — | — | — | -7 | — | — | — | — | — | 1 | — | — | — | — | — | — | — | — | — | — | 69594a9588f3996b |
| 1968Q1 | 1968-01-01 | Japan | JPN | — | — | — | — | — | — | — | — | 38 | 41 | — | — | — | — | — | — | -3 | — | — | — | — | — | -6 | — | — | — | — | — | — | — | — | — | — | 3109d745ccb10046 |
| 1968Q2 | 1968-04-01 | Japan | JPN | — | — | — | — | — | — | — | — | 35 | 31 | — | — | — | — | — | — | 4 | — | — | — | — | — | -3 | — | — | — | — | — | — | — | — | — | — | 77366c51f5f525fd |
| 1968Q3 | 1968-07-01 | Japan | JPN | — | — | — | — | — | — | — | — | 33 | 27 | — | — | — | — | — | — | 6 | — | — | — | — | — | -2 | — | — | — | — | — | -10 | — | — | — | — | 53b387087a63fffd |
| 1968Q4 | 1968-10-01 | Japan | JPN | — | — | — | — | — | — | — | — | 38 | 42 | — | — | — | — | — | — | -4 | — | — | — | — | — | 5 | — | — | — | — | — | -6 | — | — | — | — | 1774c95cf9165c31 |
| 1969Q1 | 1969-01-01 | Japan | JPN | — | — | — | — | — | — | — | — | 34 | 38 | — | — | — | — | — | — | -4 | — | — | — | — | — | -4 | — | — | — | — | — | -4 | — | — | — | — | 284d7033c280eb21 |
| 1969Q2 | 1969-04-01 | Japan | JPN | — | — | — | — | — | — | — | — | 39 | 40 | — | — | — | — | — | — | -1 | — | — | — | — | — | 5 | — | — | — | — | — | 4 | — | — | — | — | 5d6f2f88edba2637 |
| 1969Q3 | 1969-07-01 | Japan | JPN | — | — | — | — | — | — | — | — | 38 | 40 | — | — | — | — | — | — | -2 | — | — | — | — | — | -1 | — | — | — | — | — | 5 | — | — | — | — | 47e3d542447f6f21 |
| 1969Q4 | 1969-10-01 | Japan | JPN | — | — | — | — | — | — | — | — | 40 | 45 | — | — | — | — | — | — | -5 | — | — | — | — | — | 2 | — | — | — | — | — | 2 | — | — | — | — | 37992b62e2543262 |
Profiled Oct 1, 2026 from snapshot 20261001T043746Z-0ad58d9d0fdb
Measured- Completeness
- 84.4%
- Rows
- 237
- Columns
- 38
- Columns with gaps
- 33
19672026
| Column | Missing | Distinct | Range | Distribution |
|---|---|---|---|---|
| quartervarchar | 0% | 258 | — |
|
| datedate | 0% | 259 | Jul 1, 1967 → Jul 1, 2026 | — |
| countryvarchar | 0% | 1 | — |
|
| country_codevarchar | 0% | 1 | — |
|
| di_large_mfgdouble | 11.8% | 87 | -58 → 53median 5 | 5 outside 1st–99th percentile |
| di_large_mfg_fcdouble | 11.8% | 81 | -55 → 47median 3 | 4 outside 1st–99th percentile |
| di_large_nonmfgdouble | 27% | 74 | -41 → 57median 9 | 3 outside 1st–99th percentile |
| di_large_nonmfg_fcdouble | 27% | 70 | -36 → 51median 9 | 3 outside 1st–99th percentile |
| di_medium_mfgdouble | 11.8% | 87 | -57 → 42median -1 | 5 outside 1st–99th percentile |
| di_medium_mfg_fcdouble | 11.8% | 69 | -61 → 34median -5 | 6 outside 1st–99th percentile |
| di_medium_nonmfgdouble | 27% | 74 | -47 → 43median -1 | 4 outside 1st–99th percentile |
| di_medium_nonmfg_fcdouble | 27% | 64 | -45 → 36median -2 | 4 outside 1st–99th percentile |
| di_small_mfgdouble | 0.42% | 87 | -60 → 46median -5.5 | 4 outside 1st–99th percentile |
| di_small_mfg_fcdouble | 0.42% | 94 | -63 → 51median -7 | 6 outside 1st–99th percentile |
| di_small_nonmfgdouble | 27% | 66 | -44 → 34median -8 | 4 outside 1st–99th percentile |
| di_small_nonmfg_fcdouble | 27% | 67 | -52 → 25median -9 | 3 outside 1st–99th percentile |
| di_large_mfg_fc_errordouble | 12.2% | 44 | -23 → 28median 1 | 6 outside 1st–99th percentile |
| di_large_nonmfg_fc_errordouble | 27.4% | 33 | -17 → 15median 1 | 3 outside 1st–99th percentile |
| di_medium_mfg_fc_errordouble | 12.2% | 36 | -16 → 31median 2 | 5 outside 1st–99th percentile |
| di_medium_nonmfg_fc_errordouble | 27.4% | 35 | -16 → 19median 3 | 2 outside 1st–99th percentile |
| di_small_mfg_fc_errordouble | 0.84% | 35 | -16 → 27median 2 | 6 outside 1st–99th percentile |
| di_small_nonmfg_fc_errordouble | 27.4% | 25 | -8 → 15median 4 | 2 outside 1st–99th percentile |
| di_large_mfg_qoq_chgdouble | 12.2% | 42 | -34 → 20median 0 | 6 outside 1st–99th percentile |
| di_large_nonmfg_qoq_chgdouble | 27.4% | 25 | -25 → 14median 1 | 3 outside 1st–99th percentile |
| di_medium_mfg_qoq_chgdouble | 12.2% | 46 | -33 → 19median 0 | 5 outside 1st–99th percentile |
| di_medium_nonmfg_qoq_chgdouble | 27.4% | 33 | -27 → 17median 1 | 4 outside 1st–99th percentile |
| di_small_mfg_qoq_chgdouble | 0.84% | 41 | -30 → 20median 0 | 6 outside 1st–99th percentile |
| di_small_nonmfg_qoq_chgdouble | 27.4% | 23 | -25 → 10median 1 | 3 outside 1st–99th percentile |
| di_large_mfg_yoy_chgdouble | 13.5% | 88 | -69 → 52median 1 | 5 outside 1st–99th percentile |
| di_large_nonmfg_yoy_chgdouble | 28.7% | 53 | -55 → 34median 3 | 3 outside 1st–99th percentile |
| di_medium_mfg_yoy_chgdouble | 13.5% | 77 | -67 → 49median 1 | 6 outside 1st–99th percentile |
| di_medium_nonmfg_yoy_chgdouble | 28.7% | 58 | -45 → 38median 3 | 3 outside 1st–99th percentile |
| di_small_mfg_yoy_chgdouble | 2.1% | 79 | -76 → 48median 0.5 | 6 outside 1st–99th percentile |
| di_small_nonmfg_yoy_chgdouble | 28.7% | 50 | -36 → 27median 3 | 4 outside 1st–99th percentile |
| large_small_mfg_gapdouble | 11.8% | 35 | -8 → 27median 12 | 5 outside 1st–99th percentile |
| mfg_nonmfg_gap_largedouble | 27% | 48 | -32 → 25median -6 | 3 outside 1st–99th percentile |
| large_mfg_regimevarchar | 12.2% | 4 | — |
|
| row_hashvarchar | 0% | 222 | — |
|
- Current
20261001T043746Z-0ad58d9d0fdb · sha256 0ad58d9d0fdb…
237 rows · first snapshot
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
cURL
curl "https://datazimuts.com/v1/datasets/boj_tankan_intel/jp_tankan_business_conditions_quarterly" | jq '{title, rows, columns_count, license}'Python
import requests
ds = requests.get("https://datazimuts.com/v1/datasets/boj_tankan_intel/jp_tankan_business_conditions_quarterly").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/boj_tankan_intel/jp_tankan_business_conditions_quarterly
Tip: fetch /llms.txt for the full machine-readable catalog.
Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.
Cite this snapshot
Pinned to snapshot 20261001T043746Z-0ad58d9d0fdb and its content hash, so readers get exactly the data you used.
APA
Japan Tankan Business-Conditions Intelligence (BoJ, keyless). (2026). Japan Tankan business-conditions DI (quarterly) [Data set, snapshot 20261001T043746Z-0ad58d9d0fdb, sha256 0ad58d9d0fdb]. Datazimuts. Retrieved 2026-10-01, from https://datazimuts.com/en/datasets/boj_tankan_intel/jp_tankan_business_conditions_quarterly?snapshot=20261001T043746Z-0ad58d9d0fdb
BibTeX
@misc{dz_boj_tankan_intel_jp_tankan_business_cond_0ad58d9d,
title = {{Japan Tankan business-conditions DI (quarterly)}},
author = {{Japan Tankan Business-Conditions Intelligence (BoJ, keyless)}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/boj_tankan_intel/jp_tankan_business_conditions_quarterly?snapshot=20261001T043746Z-0ad58d9d0fdb}},
note = {Snapshot 20261001T043746Z-0ad58d9d0fdb, sha256 0ad58d9d0fdb9ebb3161042004d859574ede40bdf17f10b9782bc29714781c21; accessed 2026-10-01}
}Embed a table or a chart
Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.
HTML
<iframe src="https://datazimuts.com/embed/chart?dataset=boj_tankan_intel%2Fjp_tankan_business_conditions_quarterly&lang=en&theme=auto&snapshot=20261001T043746Z-0ad58d9d0fdb&x=date&y=di_large_mfg&agg=avg" title="Japan Tankan business-conditions DI (quarterly)" width="100%" height="380" style="border:0" loading="lazy"></iframe>
Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.