U.S. supply chain tables

Hardcoded ClickHouse results from US ocean AMS bills of lading (Kirchner bols, arrivals 2014–2025). Each page has the question, the SQL, the table, and a short answer you can cite.

How many US ocean import bill rows come from China, Vietnam, India, and Mexico each year?
12 rows
How many unique US ocean bills of lading come from China, Vietnam, India, and Mexico each year?
12 rows
Which of Vietnam’s largest US shippers also shipped from China in 2016–17?
50 rows
How did China and Vietnam unique bills and cargo weight on US ocean imports change from 2014 to 2025?
12 rows
How many unique US ocean bills over 1,000 kg come from China, Vietnam, India, and Mexico each year?
12 rows
Which Vietnam product categories grew most in US ocean imports between 2017–18 and 2024–25?
8 rows
How did monthly China and Vietnam US ocean bills move in 2024 and 2025?
24 rows
What share of Vietnam’s top US shippers already shipped from China in 2016–17?
1 row
What share of US ocean import bills come from China and Vietnam each year?
12 rows