Skip to content

NA gateway import pressure: monthly port momentum

Commercial use OKFresh
Query in workbench

Follow this dataset

Get a notice in your feed when a new snapshot is published. Optionally, we also POST it to your webhook.

Must be a public https address. We never follow redirects.

The full snapshot isn't published yet — check back after the next refresh.Download sample CSVDownload sample JSONSample rows only (up to 20) — not the complete dataset.

Monthly North America gateway import pressure: loaded import TEU for the Port of Los Angeles (USA) and the Port of Vancouver (CAN), 2019-01 -> each port's latest published month, with deterministic derived features — MoM %/YoY %/3-month-annualized import change, trailing-5-year same-month seasonal baseline and deviation from it, a documented 0-100 import_pressure_score = 100*(0.45*mm(YoY) + 0.35*mm(vs_seasonal) + 0.20*mm(3m_ann)) with min-maxed clipped inputs, fixed-cut pressure_tier (surge/elevated/moderate/soft/slack), and a frontload_flag for June-August months running >10% above seasonal baseline. Keyless official port statistics (POLA container-statistics pages; Vancouver Fraser Port Authority container statistics report). One row per year_month x gateway; join keys: date, gateway_code, country_code. Who joins this: an online shop joins monthly gateway import-pressure scores to inventory and order data on year_month to anticipate retail inventory availability and freight-cost pressure 4-8 weeks ahead; a sales team joins it to territory pipeline on year_month.

Rows
184
Columns
18
Source cadence
Monthly
Last refreshed
Sep 30, 2026
Theme
trade

Use your own AI key

Once today's free allowance is used up, AI features can run on your own provider account.

Kept in this browser tab only (cleared when you close it) and sent with each AI request. Our servers use it for that request and never store or log it.