Data

What's in the file

One row per month, geography, product category and partner view: Canada and the ten provinces, all merchandise and 12 NAPCS product categories, and all trading partners or all partners except the United States, from January 1997 to the latest month. How each value is calculated is set out in the methodology.

Columns

date

Reference month (YYYY-MM).

geo_code

CA for Canada or the two-letter province code.

geography

Full name of Canada or the province.

product_code

NAPCS section code (C11 to C23), or TOTAL for all merchandise.

product

Product category name.

partner

All countries, or Excluding US (HHI recomputed after dropping the United States).

hhi

Raw monthly HHI, from 0 to 1. Blank when no exports were recorded that month; the dashboard's chart leaves these months as gaps.

hhi_12m_avg

Average of the latest 12 monthly HHI values. Blank for the first 11 months of the series and whenever a month in the window is blank.

equivalent_partners

1 / hhi: the number of equal-sized partners that would give the same concentration.

concentration_level

Low (below 0.15), Moderate (0.15 to 0.25) or High (above 0.25), based on hhi.

Updates and revisions

Refreshed with each monthly Statistics Canada release. Each refresh replaces the file, including any revisions Statistics Canada makes to earlier months. Values are given to four decimal places; the dashboard's charts and tables round to two.

Licence

The file is licensed under CC BY 4.0: you may reuse and adapt it with credit to TL Economic Intelligence. The source data are from Statistics Canada Table 12-10-0175-01, used under the Statistics Canada Open Licence.