Compared all stored columns.
Real records.
Clear comparisons.
Where the data comes from, what it covers, and how it becomes useful information.
Study scope and evidence sources.
The numerical foundation is recorded imports cleared in Alberta. The study covers 26 counter-tariff-matched families plus 1 additional antidumping family. It is an exploratory selection, not every construction material or every trade measure.
Construction product families selected because they include goods covered by Canadian counter-tariffs or antidumping duties on U.S.-origin products, then matched to Alberta customs import records for 2023–2025. The bars group these selected families by construction use.
Source: trade-measure lists cross-referenced with Alberta customs import records. The 27 selected families contain affected goods; not every item in each family is necessarily subject to a duty. Construction groups overlap, so their counts must not be added.
Families may appear in more than one group; do not add these counts together. The construction use is inferred, not recorded by customs.
| Evidence | Window | Role |
|---|---|---|
| Canadian International Merchandise Trade (CIMT) import records, published by Statistics Canada | January 2023–December 2025 | Numerical input: product codes, origins, nominal Canadian-dollar (CAD) values and quantities. |
| Trade measures | Policy snapshot reviewed 6 October 2026 | Department of Finance Canada list and Canada Border Services Agency (CBSA) product descriptions; retain each measure’s dates and legal conditions. |
| Manufacturing evidence | Desk review 6 October 2026; publication/opening dates retained | Separate product-and-factory evidence; not domestic sales or available capacity. |
Technical appendix: source fields and handling
| Source field / added field | Meaning | Handling |
|---|---|---|
| YearMonth/AnnéeMois | Reporting year and month | Retain complete 2023–2025 calendar years. |
| Ten-digit Harmonized System import classification (HS10) | Official product classification used for Canadian imports | Preserve as text, including leading zeros. The six-digit Harmonized System subheading (HS6) is the international product category; the eight-digit Canadian tariff item (HS8) adds Canadian tariff detail. |
| Country/Pays | Reported country of origin | Different from distributor location. Canada-origin imports are re-imports, not domestic factory sales. |
| Province | Province of customs clearance | Select AB. Do not infer final construction destination. |
| Value/Valeur | Recorded import value in nominal Canadian dollars (CAD) | Sum values; not retail or installed price. |
| Quantity/Quantité + Unit of Measure | Reported physical amount and its unit | Keep ten-digit product classifications (HS10) and units compatible; retain recorded zero quantities. |
| State/État | U.S. state field where applicable | Do not invent a state for other origins. |
| product_id, family name and category tags | Labels added by this study | Derived research classifications; trace them back to source codes. |
How were the products selected?
The study cross-references construction-related products covered by Canadian trade measures on U.S.-origin goods with import records cleared through customs in Alberta.
- Identify relevant construction products. Review Finance Canada’s counter-tariff list and the Canada Border Services Agency (CBSA) antidumping product descriptions for goods with potential construction or infrastructure uses.
- Match customs codes to Alberta import records. Link the listed eight-digit tariff items (HS8) to the ten-digit Harmonized System statistical product codes (HS10) in Statistics Canada’s Canadian International Merchandise Trade (CIMT) records. Retain Alberta-clearance observations for January 2023–December 2025. Antidumping inclusion is checked separately against the legal product description and origin.
- Group the matching products into research families. The selected catalogue contains 27 families: 26 with counter-tariff code matches and one additional family, copper pipe fittings, included through the U.S.-origin antidumping screen.
- Keep all recorded origins for comparison. Calculate import values and U.S. shares for each selected family using its recorded imports from all countries. This makes it possible to compare U.S. sourcing with other origins.
The trade-measure review is dated 6 October 2026; the import baseline is 2023–2025. These are separate evidence windows. The charts cover the complete selected families, including items that may fall outside a measure. They do not measure duties paid or prove that every import in a family is subject to a tariff.
Quality checks and data handling.
The selected import records retain reported values. Quality checks identified zeros, blank state fields and potential inconsistencies. No selected records were removed as a result of the duplicate, negative-value or quantity checks.
Recorded import values checked.
January 2023–December 2025.
3,056 observations reported as zero.
Percentage of the 66,154 selected import records. Each bar uses a 0–100% scale.
Source: downloadable quality-check summary, 6 October 2026. Conditions can overlap; percentages must not be added. Neither bar is an overall error rate.
| Check | Result | Handling in the analysis |
|---|---|---|
| Blank U.S. state field | 31,574 records · 47.7% | Retained the blank state values and the associated import records. No state name was substituted. State is not used to calculate country-of-origin import shares. |
| Recorded quantity of zero | 3,056 records · 4.6% | Retained the source zero and the recorded import value. No estimated quantity was inserted. The count is reported in the quality summary; it is not evidence of a new row-level flag column. |
| Exact duplicates | 0 records | No duplicate deletion was needed. |
| Negative import values | 0 records | No negative-value removal or replacement was needed. |
| Monthly coverage | 36 months represented | Used the complete three-year window. This confirms coverage in the selected set; it does not establish that every family has an observation in every month. |
Technical appendix: what the quality download contains
The quality CSV contains two columns: metric and value. It stores summary counts and percentages, code coverage and the check date. It does not contain corrected import records or row-level indicators.
In the import analysis, the original state, quantity and value fields are retained. Product IDs and family labels are research classifications. The quality summary does not establish that new missing-state or zero-quantity indicator columns were added to the underlying annual extracts.
Reported quantities are grouped separately by ten-digit product classification (HS10) and unit; incompatible units are not combined into a single physical-volume total. Complementary economic tables are kept outside the import-share calculation. Unavailable values must not be interpreted as zero.
Percentages use 66,154 selected records. Checks were documented on 6 October 2026. These controls do not constitute an independent transaction-level audit.
How were the indicators calculated?
Technical appendix: transformations and output filenames
| Input | Derived output | Transformation / reason |
|---|---|---|
| Three original Canadian International Merchandise Trade (CIMT) annual files | Filtered_Alberta_Imports_HS10_2023/2024/2025.csv | Keep Alberta-clearance rows from the selected 27 families. Add/retain year and product_id; preserve source values. |
| Filtered monthly records | Import_Summary_27_Families.csv | Sum values by family and year; add the combined 2023–2025 period. |
| Filtered records by origin | Origin_Shares_27_Families.csv | Sum each origin and divide by all-origin value for that product and period. |
| Catalogue + observed codes + policy lists | HS10_Trade_Measure_Mapping_27_Families.csv | Connect six-digit product subheadings (HS6), ten-digit import codes (HS10) and eight-digit tariff items (HS8); retain listed rates, dates, sources and match limitations. |
| Public manufacturing review | Manufacturing_Audit_Current_27_Families.csv | Retain the manufacturing evidence for the selected families, including manufacturers, source links, review status and limitations. |
| Recalculated row checks | Quality_Counts_Current_27_Families.csv | Record summary counts so the quality indicators are reproducible. |
For 2023–2025, sum the dollars first; do not average annual percentages. A zero denominator is unavailable, not 0%. Round only for display.
Supporting context sources and unit handling
Statistics Canada tables 16-10-0117-01 (2023–2024), 16-10-0048-01 (unadjusted 2023–2025), 36-10-0709-01 (2022–2024) and 36-10-0478-01 (2022) provide broader context. Preserve source units, scales and status flags; thousands-of-dollars observations need a ×1,000 interpretation in dollars. These figures are not added to customs totals or used as exact-product market shares.
The Canada Border Services Agency (CBSA) administers customs. The National Pollutant Release Inventory (NPRI) is an Environment and Climate Change Canada inventory of reporting facilities. NPRI supports location research; it does not confirm which product a factory manufactures.
See the complete evidence guide, definitions and source register.
Trace each family to its customs codes.
The study links 27 research product families to 91 international six-digit product subheadings (HS6) and 367 detailed ten-digit Canadian import classifications (HS10) found in the selected Alberta records. These are different levels of detail, not separate sets of imports to add together.
These are official customs product-classification codes used to report imported goods. The international system is the Harmonized Commodity Description and Coding System, commonly called the Harmonized System (HS). It is used for international goods trade, not only for construction. The study did not create these official codes; it created readable family names and matched them to existing classifications.
Construction example from the selected data: paper-faced gypsum board (drywall).
Six-digit subheading (HS6)
World Customs Organization (WCO) defines the international base.
Eight-digit tariff item (HS8)
The Department of Finance Canada assigns digits 7–8.
Ten-digit import classification (HS10)
Statistics Canada assigns digits 9–10 for more detailed product statistics.
Each level retains the preceding digits and adds detail. The Canada Border Services Agency (CBSA) administers import classification. Codes identify product classes, not individual shipments, buyers, factories or projects.
Who defines the codes, and who uses them?
The World Customs Organization (WCO) establishes the first six digits. Canada adds two tariff digits through the Department of Finance Canada and two statistical digits through Statistics Canada.
Importers or their customs representatives use the appropriate classification when reporting goods; the Canada Border Services Agency (CBSA) administers classification and may issue rulings or corrections. Statistics Canada publishes the resulting merchandise-trade statistics.
The official codes in this study come from the published Canadian International Merchandise Trade (CIMT) import records and the Canadian tariff lists. The project matches these codes to its own product-family labels. A six-digit subheading can contain several ten-digit classifications, which is why 91 broad subheadings correspond to 367 observed detailed codes.
Official explanations: Statistics Canada: who assigns the digits · Canada Border Services Agency: how to read a classification.
View all 27 families and code coverage
| Product family | Six-digit product subheadings (HS6) | Observed ten-digit import codes (HS10) | Ten-digit import codes with counter-tariff match | Inclusion basis |
|---|---|---|---|---|
| Steel reinforcing bars | 721420 | 8 | 8 | Counter-tariff code matches |
| Steel sections and beams | 721610 721621 721622 721631 721632 721633 721640 721650 | 28 | 28 | Counter-tariff code matches |
| Sawn wood | 440711 440712 440713 440714 440719 | 21 | 21 | Counter-tariff code matches |
| Plywood | 441210 441231 441233 441234 441239 441241 441242 441249 441251 441252 441259 441291 441292 441299 | 21 | 20 | Counter-tariff code matches |
| Drywall | 680911 | 3 | 3 | Counter-tariff code matches |
| Aluminum structures and parts | 761090 | 5 | 5 | Counter-tariff code matches |
| Aluminum doors, windows and frames | 761010 | 3 | 3 | Counter-tariff code matches |
| Steel doors, windows and frames | 730830 | 7 | 7 | Counter-tariff code matches |
| PVC floor and wall coverings | 391810 | 6 | 6 | Counter-tariff code matches |
| Carpets and textile floor coverings | 570310 570321 570329 570331 570339 570390 | 15 | 15 | Counter-tariff code matches |
| Air conditioning with refrigeration | 841510 841581 841582 | 19 | 6 | Counter-tariff code matches |
| Air conditioners without a built-in refrigerating unit | 841583 | 4 | 4 | Counter-tariff code matches |
| Non-electric heating equipment and parts | 732290 | 6 | 6 | Counter-tariff code matches |
| Iron and steel pipes | 730300 730419 730439 730449 730490 730511 730512 730519 730531 730539 730619 730630 730640 730650 730661 730669 730690 | 117 | 114 | Counter-tariff code matches |
| Iron and steel pipe fittings | 730711 730719 730721 730722 730723 730729 730791 730792 730793 730799 | 21 | 18 | Counter-tariff code matches |
| Copper pipe fittings | 741210 741220 | 7 | 0 | Additional U.S. antidumping family |
| Electrical cables and conductors | 854449 854460 | 7 | 3 | Counter-tariff code matches |
| LED lighting | 940511 940541 940542 | 7 | 6 | Counter-tariff code matches |
| Steel bridge components | 730810 | 1 | 1 | Counter-tariff code matches |
| Other fabricated steel components | 730890 | 9 | 9 | Counter-tariff code matches |
| Steel wire ropes and cables | 731210 | 11 | 11 | Counter-tariff code matches |
| Steel screws and bolts | 731815 | 4 | 4 | Counter-tariff code matches |
| Railway rails | 730210 | 5 | 5 | Counter-tariff code matches |
| Railway track components | 730230 730240 730290 | 4 | 4 | Counter-tariff code matches |
| Steel tanks (over 300 L) | 730900 | 2 | 2 | Counter-tariff code matches |
| Compressors | 841430 841440 841480 | 25 | 11 | Counter-tariff code matches |
| Steel gas containers | 731100 | 1 | 1 | Counter-tariff code matches |
Code matches are a screening tool. Legal product descriptions, origin, dates and relief determine actual applicability. A 2026 policy snapshot is not a calculation of duties paid during 2023–2025.
Download the working outputs.
These comma-separated values files (CSV) contain the derived outputs for the selected 27 families and download directly from this page. They are derived research outputs, not separate official datasets. Treat customs codes as text when importing into Excel.
Product catalogue
27 families, categories, customs subheadings and scope notes.
Import values & U.S. share
Annual and combined values for the selected families.
Country-of-origin comparisons
Recorded values and shares by family, origin and period.
Product-code traceability
Observed HS10, HS8 counter-tariff matches and U.S. antidumping screens.
Manufacturing evidence audit
Selected-family extract, manufacturers, sources and review limitations.
Quality-check summary
Counts and flags used on this page.
Original annual import files — Statistics Canada
These links open the official national ZIP files. The working outputs above select Alberta and the selected product basket from the recorded observations.