Dataset quality · U.S. Census Bureau — Foreign Trade Division
U.S. Trade Flows
The U.S. Census Bureau Foreign Trade program tracks the value of goods imported into and exported from the United States, broken down by country, port of entry, and commodity (HS/NAICS). Monthly data is published via the FT900 release. This dataset focuses on annual import values from the three largest trading partners — China, Mexico, Canada — covering the full arc of the 2018–2025 tariff cycle.
Frequency
Monthly (annual aggregates used here)
Coverage
2017 – 2024
Columns
5
Column group 1 / 4
Monthly series since 1990 — annual view used here
The Census Bureau FT900 monthly release is one of the most closely watched economic indicators in the U.S. Annual aggregates used in this story are fully consistent across years. No gaps in country-level data for the major trading partners.
yearGoodColumn group 2 / 4
Country-level data — complete for major partners
Country attribution follows the country of origin (for imports) or final destination (for exports). Data for China, Mexico, and Canada — the top 3 partners — is complete and unambiguous.
countryGoodColumn group 3 / 4
Import/export values — reliable, revision-minimal
Import values are reported by Customs and Border Protection at time of entry. The dataset is subject to minor revisions in the 12 months following publication as late-reported entries are reconciled.
imports_usd_bnGoodexports_usd_bnGoodColumn group 4 / 4
Tariff rates — indicative, not transaction-level
The effective tariff rate is a weighted average from USITC DataWeb. It excludes anti-dumping and countervailing duties, which can be substantial (especially for China). Use as a directional signal, not a precise applied rate.
tariff_rate_pctFairStories built on this dataset
2017 – 2025 · United States
The Tariff War in Numbers
How U.S. tariffs reshaped trade with China, Mexico, and Canada — from the 2018 steel shock to the 2025 escalation.
2017 – 2026 · United States
The Whack-a-Mole Deficit
Tariffs cut the China deficit by 33%. The total U.S. trade deficit hit a record $1.19 trillion. Vietnam, Mexico, and India filled the gap.
Source
U.S. Trade Flows
U.S. Census Bureau — Foreign Trade Division · Monthly (annual aggregates used here)
2017 – 2024
Timestamp
yearintegerGoodReference year
Geography
countrystringGoodTrade flows
imports_usd_bnnumber ($B)Goodexports_usd_bnnumber ($B)Goodpolicy
tariff_rate_pctnumber (%)Fair