Canada goods trade balances by partner, quarterly
Quarterly Canadian goods trade balances (table 36-10-0023-01, balance of international payments, current account) from Statistics Canada: receipts minus payments, seasonally adjusted, in millions of Canadian dollars, for Canada's 27 principal trading partners plus the EU aggregate, the United Kingdom, 'Total of all countries' and 'Other countries not elsewhere classified'. Coverage 1997-Q1 to the present. Negative values are genuine deficits (kept verbatim — e.g. Total of all countries 2026-Q1 = -6,397 before a 2026-Q2 surplus of 12,204). Caveats: partner series overlap (see the companion flows dataset), so partner balances are not additive; the latest quarter is occasionally revised. Statistics Canada Open Licence (commercial reuse allowed); source: Statistics Canada.
- Source
- Statistics Canada
- Rows
- 3,658
- Columns
- 4
- Source cadence
- Quarterly
- Last refreshed
- Sep 26, 2026
- Theme
- trade
| Column | Type | Description |
|---|---|---|
| quarter | string | Reference quarter, as an ISO date (first month of the quarter: January, April, July or October). |
| country_code | string | ISO 3166-1 alpha-3 code for Canada (CAN) — the join key for the 'Enrich with public data' feature. |
| partner_name | string | Trading partner as published by Statistics Canada: one of 27 principal trading partners, the 'European Union excluding the United Kingdom' aggregate, the United Kingdom (reported separately since 2021-01), 'Total of all countries' (headline aggregate) or 'Other countries not elsewhere classified' (residual). The EU aggregate contains the separately published member states (Belgium, France, Germany, Italy, Netherlands, Spain), so partner values are not additive. |
| balance_millions_cad | float | Goods trade balance (receipts minus payments), seasonally adjusted, in millions of Canadian dollars. May be negative — negative values are genuine deficits (e.g. Total of all countries 2026-Q1 = -6,397) kept verbatim; genuine upstream gaps are missing, never zero-filled. (unit: millions of Canadian dollars (SA)) |
- Current
20260926T052447Z-8800a8328280 · sha256 8800a8328280…
3,658 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/statcan_trade/statcan_goods_trade_balances_by_partner_quarterly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/statcan_trade/statcan_goods_trade_balances_by_partner_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/statcan_trade/statcan_goods_trade_balances_by_partner_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 20260926T052447Z-8800a8328280 and its content hash, so readers get exactly the data you used.
Statistics Canada. (2026). Canada goods trade balances by partner, quarterly [Data set, snapshot 20260926T052447Z-8800a8328280, sha256 8800a8328280]. Datazimuts. Retrieved 2026-09-26, from https://datazimuts.com/en/datasets/statcan_trade/statcan_goods_trade_balances_by_partner_quarterly?snapshot=20260926T052447Z-8800a8328280
@misc{dz_statcan_trade_statcan_goods_trade_balanc_8800a832,
title = {{Canada goods trade balances by partner, quarterly}},
author = {{Statistics Canada}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/statcan_trade/statcan_goods_trade_balances_by_partner_quarterly?snapshot=20260926T052447Z-8800a8328280}},
note = {Snapshot 20260926T052447Z-8800a8328280, sha256 8800a83282805564cfa658597251e0eadedba0bea7f329959b694d53d70836c9; 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.
<iframe src="https://datazimuts.com/embed/chart?dataset=statcan_trade%2Fstatcan_goods_trade_balances_by_partner_quarterly&lang=en&theme=auto&snapshot=20260926T052447Z-8800a8328280&x=quarter&y=balance_millions_cad&agg=avg" title="Canada goods trade balances by partner, 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.