Merchandise trade panel, top-20 economies (UN Comtrade)
Downloads are disabled for this dataset: its license prohibits commercial use. The documentation, schema and sample rows stay available here.
Annual total merchandise trade from the UN Comtrade public preview API (keyless): imports (CIF) and exports (FOB) in USD for 20 major trading economies versus the World, 2015-2024, with total trade, merchandise trade balance, balance share, YoY growth, per-year rank and surplus/deficit flag. The cross-country comparable merchandise layer for tariff, supply-chain and macro models. Raw data: UN Statistics Division, UN Comtrade Database.
- Rows
- 198
- Columns
- 14
- Source cadence
- Yearly
- Last refreshed
- Oct 3, 2026
- Theme
- trade
| Column | Type | Description |
|---|---|---|
| year | integer | Reference year (2015-2024). |
| country | string | Reporter economy name via the hub normalization layer. |
| country_code | string | ISO 3166-1 alpha-3 reporter code. |
| reporter_m49 | integer | UN M49 numeric reporter code used in the Comtrade query. |
| imports_usd | float | Total merchandise imports versus the World, US dollars, CIF valuation (Comtrade primaryValue, flow M). (unit: USD) |
| exports_usd | float | Total merchandise exports versus the World, US dollars, FOB valuation (Comtrade primaryValue, flow X). (unit: USD) |
| total_trade_usd | float | Imports plus exports, US dollars. (unit: USD) |
| trade_balance_usd | float | Merchandise trade balance = exports minus imports; positive = surplus. US dollars. (unit: USD) |
| balance_pct_of_total | float | Trade balance as a percent of total trade; the imbalance intensity read. (unit: %) |
| imports_yoy_pct | float | Year-on-year percent change of imports; null for each reporter's first year. (unit: %) |
| exports_yoy_pct | float | Year-on-year percent change of exports; null for each reporter's first year. (unit: %) |
| total_trade_rank | integer | Per-year rank on total merchandise trade (1 = largest trader). |
| surplus_flag | boolean | True when the reporter ran a trade surplus that year. |
| row_hash | string | Deterministic 12-hex row identity hash over source, country, year, imports and exports. |
First 10 sample rows — a preview, not the complete dataset.
| year | country | country_code | reporter_m49 | imports_usd | exports_usd | total_trade_usd | trade_balance_usd | balance_pct_of_total | imports_yoy_pct | exports_yoy_pct | total_trade_rank | surplus_flag | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2,015 | China | CHN | 156 | 1,679,564,324,560 | 2,273,468,224,113 | 3,953,032,548,673 | 593,903,899,553 | 15.024 | — | — | 1 | true | c85162687e70 |
| 2,015 | United States | USA | 842 | 2,313,424,569,327 | 1,501,845,863,839 | 3,815,270,433,166 | -811,578,705,488 | -21.272 | — | — | 2 | false | 18bb4c5e43e0 |
| 2,015 | Germany | DEU | 276 | 1,057,535,853,584.251 | 1,328,500,248,528.884 | 2,386,036,102,113.135 | 270,964,394,944.633 | 11.356 | — | — | 3 | true | ef557140f370 |
| 2,015 | Japan | JPN | 392 | 625,568,420,678 | 624,873,508,116 | 1,250,441,928,794 | -694,912,562 | -0.056 | — | — | 4 | false | 95d3a95a3998 |
| 2,015 | United Kingdom | GBR | 826 | 630,251,057,548 | 466,295,682,754 | 1,096,546,740,302 | -163,955,374,794 | -14.952 | — | — | 5 | false | 1a7201cdafef |
| 2,015 | Hong Kong | HKG | 344 | 559,305,500,094.066 | 510,552,778,635.197 | 1,069,858,278,729.263 | -48,752,721,458.869 | -4.557 | — | — | 6 | false | 17a1e03ec270 |
| 2,015 | South Korea | KOR | 410 | 436,486,934,609 | 526,753,006,361 | 963,239,940,970 | 90,266,071,752 | 9.371 | — | — | 7 | true | 949c26b64da5 |
| 2,015 | Netherlands | NLD | 528 | 412,644,303,638.533 | 464,697,216,473.282 | 877,341,520,111.815 | 52,052,912,834.749 | 5.933 | — | — | 8 | true | 11ed297071b7 |
| 2,015 | Italy | ITA | 380 | 410,933,397,835.203 | 456,988,625,514.476 | 867,922,023,349.679 | 46,055,227,679.273 | 5.306 | — | — | 9 | true | 44e7f06b85af |
| 2,015 | Canada | CAN | 124 | 419,374,729,376.088 | 408,697,323,603.511 | 828,072,052,979.599 | -10,677,405,772.577 | -1.289 | — | — | 10 | false | ae7cde788c8c |
- Current
20261003T041833Z-a54d060c0676 · sha256 a54d060c0676…
198 rows · first snapshot
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/un_comtrade_trade_intel/merchandise_trade_panel" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/un_comtrade_trade_intel/merchandise_trade_panel").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/un_comtrade_trade_intel/merchandise_trade_panel
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 20261003T041833Z-a54d060c0676 and its content hash, so readers get exactly the data you used.
UN Comtrade merchandise-trade intelligence. (2026). Merchandise trade panel, top-20 economies (UN Comtrade) [Data set, snapshot 20261003T041833Z-a54d060c0676, sha256 a54d060c0676]. Datazimuts. Retrieved 2026-10-04, from https://datazimuts.com/en/datasets/un_comtrade_trade_intel/merchandise_trade_panel?snapshot=20261003T041833Z-a54d060c0676
@misc{dz_un_comtrade_trade_intel_merchandise_trad_a54d060c,
title = {{Merchandise trade panel, top-20 economies (UN Comtrade)}},
author = {{UN Comtrade merchandise-trade intelligence}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/un_comtrade_trade_intel/merchandise_trade_panel?snapshot=20261003T041833Z-a54d060c0676}},
note = {Snapshot 20261003T041833Z-a54d060c0676, sha256 a54d060c0676f57e9dea1a043f174af57172b10c778fb80016eb9e67df567cec; accessed 2026-10-04}
}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.
<iframe src="https://datazimuts.com/embed/chart?dataset=un_comtrade_trade_intel%2Fmerchandise_trade_panel&lang=en&theme=auto&snapshot=20261003T041833Z-a54d060c0676&x=year&y=year&agg=avg" title="Merchandise trade panel, top-20 economies (UN Comtrade)" 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.