Data / U.S. Trade Flows

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.

Source

U.S. Census Bureau — Foreign Trade Division

Frequency

Monthly (annual aggregates used here)

Coverage

2017 – 2024

Columns

5

Stories

Dataset quality · 4 good · 1 fair · 0 poor

Explore the dataset

Schema walkthrough, column quality analysis, null rates and consistency scores.

Quality →

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.

Story →

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.

Story →

Schema

temporal

year

integer

Reference year

geography

country

string

Trading partner country (China, Mexico, Canada)

trade

imports_usd_bn

number ($B)

Total goods imports from partner country, in billions of USD (annual)

exports_usd_bn

number ($B)

Total goods exports to partner country, in billions of USD (annual)

policy

tariff_rate_pct

number (%)

Effective average tariff rate on imports from that country — annual weighted average across all HS codes

Source

U.S. Census Bureau — Foreign Trade Division ↗