Wednesday, April 3, 2019

Trade Data - SK exports

Question:
I am looking for the annual total volume (quantity) of exports (all products so all HS codes) originating from Saskatchewan broken down by destination (country). I am hoping to include as many years as possible, for this project the more data that is available the better, i.e., as far back as possible.

Answer:
We've received the following from subject matter:

"If they need data broken down by HS codes, the most efficient way to proceed is by custom tabulation. I could run a table for exports of all HS codes by Country of Destination, with Saskatchewan selected as the Province of Origin. Such data is available all the way back to 1988 and is available on a cost-recovery basis at $416.35 per bundle of 5 years of data. If they’re interested, I’d need to know which level of HS detail they need. If they need very detailed data (i.e. at the HS8 level), it might not fit in a single Excel table.

If they need data but have no funds, the only “alternative” I can think of is table 12-10-0119-01 (https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210011901), which has data at the provincial level, but only for principal trading partners (top 25 or so) and under the North American Product Classification System (NAPCS) instead of the Harmonized System. The NAPCS uses broader product categories than the HS and can be more efficient when comparing different categories of products. The data in there is also on a monthly frequency so they would need to aggregate some data themselves."