Monthly Canadian merchandise trade-partner intelligence from Statistics Canada table 12-10-0011-01 (balance-of-payments basis, seasonally adjusted, 1997-01 onward): a partner x month panel of imports, exports and trade balances for Canada's 27 principal trading partners (ISO alpha-3) plus the All-countries total and a derived rest-of-world bucket (the EU aggregate is excluded to avoid double-counting its member states). Partner shares of total trade, MoM/YoY momentum, per-month surplus/deficit balance_rank, persistent 12-month surplus/deficit flags, a documented 0-100 trade_exposure_score ranked as exposure_rank with a1..a4 tiers, monthly partner-concentration HHI, and the USA's export/import shares as month-level context. Units: CAD millions, percent, scores. Caveats: principal-partner roster is fixed (residual bucket mixes large unlisted and small partners); StatCan revises recent months; first 12 months carry null YoY columns. Primary key: (month, partner_name). Cadence: monthly; as_of is the latest published month, so identical input produces an identical content hash. Statistics Canada Open Licence (commercial reuse allowed); source: Statistics Canada.

Source: Statistics Canada — merchandise trade by principal trading partner
Rows: 10,295
Columns: 34
Source cadence: Monthly
Last refreshed: Sep 26, 2026
Theme: economy

Column	Type	Description
month	date	Reference month: first day of the month, ISO date. (unit: date)
partner_name	string	Principal trading partner as published by StatCan ('All countries' = total; 'Rest of world' = derived residual).
country_code	string	ISO alpha-3 ('WLD' for the All-countries total; empty for the derived Rest-of-world bucket). (unit: ISO-3166-1 alpha-3)
is_total	integer	1 for the All-countries total row.
is_derived	integer	1 for the derived Rest-of-world bucket (All countries minus the 27 listed partners).
exports_cad_m	float	Exports, balance-of-payments basis, seasonally adjusted. (unit: CAD millions)
imports_cad_m	float	Imports, balance-of-payments basis, seasonally adjusted. (unit: CAD millions)
trade_balance_cad_m	float	Trade balance = exports - imports (published series; identity-gated). (unit: CAD millions)
twoway_cad_m	float	Two-way trade = exports + imports. (unit: CAD millions)
export_share_pct	float	Partner's share of total exports that month. (unit: percent)
import_share_pct	float	Partner's share of total imports that month. (unit: percent)
twoway_share_pct	float	Partner's share of total two-way trade that month. (unit: percent)
exports_mom_pct	float	Month-over-month change in exports. (unit: percent)
imports_mom_pct	float	Month-over-month change in imports. (unit: percent)
twoway_mom_pct	float	Month-over-month change in two-way trade. (unit: percent)
balance_mom_m	float	Month-over-month change in the trade balance. (unit: CAD millions)
exports_yoy_pct	float	Year-over-year change in exports; null for the first 12 months. (unit: percent)
imports_yoy_pct	float	Year-over-year change in imports; null for the first 12 months. (unit: percent)
twoway_yoy_pct	float	Year-over-year change in two-way trade; null for the first 12 months. (unit: percent)
balance_yoy_m	float	Year-over-year change in the trade balance; null for the first 12 months. (unit: CAD millions)
balance_rank	integer	Per-month rank of the trade balance, descending (1 = largest surplus); null for total and derived rows.
surplus_flag	integer	1 when the monthly trade balance is positive.
persistent_surplus_12m	integer	1 when the balance was positive in all trailing 12 months.
persistent_deficit_12m	integer	1 when the balance was negative in all trailing 12 months.
trade_exposure_score	float	Documented 0-100 score: 100(0.60minmax(log1p(twoway_cad_m)) + 0.40*minmax(winsorized twoway_yoy_pct +/-100)), min-max global over partner-months; null for total and derived rows. (unit: 0-100)
exposure_rank	integer	Per-month rank of trade_exposure_score, descending; null for total and derived rows.
exposure_tier	string	Score quartile tier: a1 (top) .. a4; null for total and derived rows.
export_hhi_month	float	Monthly export partner-concentration HHI over 27 partners + rest of world. (unit: 0-10000)
import_hhi_month	float	Monthly import partner-concentration HHI. (unit: 0-10000)
twoway_hhi_month	float	Monthly two-way trade partner-concentration HHI. (unit: 0-10000)
us_export_share_pct	float	Month-level context: the USA's share of total exports. (unit: percent)
us_import_share_pct	float	Month-level context: the USA's share of total imports. (unit: percent)
source_table	string	StatCan table id ('12-10-0011-01').
row_hash	string	Deterministic 16-hex hash of the row's content fields (stable sort; idempotent snapshots).

First 10 sample rows — a preview, not the complete dataset.

month	partner_name	country_code	is_total	exports_cad_m	imports_cad_m	trade_balance_cad_m	twoway_cad_m	export_share_pct	import_share_pct	twoway_share_pct	exports_mom_pct	imports_mom_pct	twoway_mom_pct	balance_mom_m	exports_yoy_pct	imports_yoy_pct	twoway_yoy_pct	balance_yoy_m	balance_rank	surplus_flag	persistent_surplus_12m	persistent_deficit_12m	trade_exposure_score	exposure_rank	exposure_tier	export_hhi_month	import_hhi_month	twoway_hhi_month	us_export_share_pct	us_import_share_pct	source_table	row_hash
1997-01-01	All countries	WLD	1	24,976.7	21,879.3	3,097.4	46,856	100	100	100	—	—	—	—	—	—	—	—	—	1	—	—	—	—	—	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	70da8bcf28782ecf
1997-01-01	Algeria	DZA	0	32.3	86.4	-54.1	118.7	0.129	0.395	0.253	—	—	—	—	—	—	—	—	20	0	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	7de65503687bc097
1997-01-01	Australia	AUS	0	82.2	78.5	3.7	160.7	0.329	0.359	0.343	—	—	—	—	—	—	—	—	12	1	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	d984262fd827165e
1997-01-01	Belgium	BEL	0	125.3	72.2	53.2	197.5	0.502	0.33	0.422	—	—	—	—	—	—	—	—	6	1	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	76140972575b5e2f
1997-01-01	Brazil	BRA	0	117.3	76.9	40.4	194.2	0.47	0.351	0.414	—	—	—	—	—	—	—	—	7	1	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	e53d3053f382bc7f
1997-01-01	China	CHN	0	283.5	174.3	109.1	457.8	1.135	0.797	0.977	—	—	—	—	—	—	—	—	4	1	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	623aa7bbaa5f48ec
1997-01-01	France	FRA	0	151.3	277	-125.7	428.3	0.606	1.266	0.914	—	—	—	—	—	—	—	—	23	0	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	9411d4cea1265888
1997-01-01	Germany	DEU	0	257.3	377.6	-120.2	634.9	1.03	1.726	1.355	—	—	—	—	—	—	—	—	21	0	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	432b111887a8f815
1997-01-01	Hong Kong	HKG	0	231.9	356.9	-125	588.8	0.928	1.631	1.257	—	—	—	—	—	—	—	—	22	0	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	ffee6479125a4bcb
1997-01-01	India	IND	0	28.5	41.6	-13	70.1	0.114	0.19	0.15	—	—	—	—	—	—	—	—	16	0	—	—	—	—	a4	6,398.326	5,723.323	6,076.111	79.71	75.296	12-10-0011-01	45ad8158becc8324

Sep 26, 2026Current
20260926T120800Z-498212c9ab9f · sha256 498212c9ab9f…
10,295 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/ca_trade_partner_signals/ca_trade_partner_monthly" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/ca_trade_partner_signals/ca_trade_partner_monthly").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/ca_trade_partner_signals/ca_trade_partner_monthly

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 20260926T120800Z-498212c9ab9f and its content hash, so readers get exactly the data you used.

APA

Statistics Canada — merchandise trade by principal trading partner. (2026). Canadian merchandise trade-partner intelligence (monthly) [Data set, snapshot 20260926T120800Z-498212c9ab9f, sha256 498212c9ab9f]. Datazimuts. Retrieved 2026-09-26, from https://datazimuts.com/en/datasets/ca_trade_partner_signals/ca_trade_partner_monthly?snapshot=20260926T120800Z-498212c9ab9f

BibTeX

@misc{dz_ca_trade_partner_signals_ca_trade_partne_498212c9,
  title        = {{Canadian merchandise trade-partner intelligence (monthly)}},
  author       = {{Statistics Canada — merchandise trade by principal trading partner}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/ca_trade_partner_signals/ca_trade_partner_monthly?snapshot=20260926T120800Z-498212c9ab9f}},
  note         = {Snapshot 20260926T120800Z-498212c9ab9f, sha256 498212c9ab9f65c6af461a009c4a1ecb83a86b9718d8006e2bdebdb8937381d2; accessed 2026-09-26}
}

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.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=ca_trade_partner_signals%2Fca_trade_partner_monthly&lang=en&theme=auto&snapshot=20260926T120800Z-498212c9ab9f&x=month&y=is_total&agg=avg" title="Canadian merchandise trade-partner intelligence (monthly)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

Sign in to comment

Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.

Canadian merchandise trade-partner intelligence (monthly)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key