Last 18 months to Aug 2026. Rest of page: all years.
One row per paired voyage on this lane: the ship left Shanghai, arrived Vancouver, and the record says when, with which terminals at each end. The filter bar above scopes this table like every other pane; the filters in the header row narrow it further.
Shanghai → Vancouver is measured twice here, from two independent records. Carrier container tracking records 4 routings on this lane (53 carrier/service combinations, 9 operators); sailing direct, a container typically takes 21.85 days gate to gate over 448 recorded voyages — the same figures the route finder shows for this pair. AIS ship movements give 1,376 port-to-port voyages by 427 vessels, median 24.0 days (mean 26.8 d, middle half 19.3–30.2 d).
The two medians are not comparable directly: 3 carriers record containers on this lane against 21 operators seen by AIS, so the two sets cover different ships. Where they can be compared — one carrier at a time — the difference is port time, measured at 3.53 d at Shanghai (12,464 records) and 3.0 d at Vancouver (1,584 records).
Of the 705 journeys whose routing is recorded, 658 moved without transshipment and 47 were transshipped — Busan (40, median 30.1 d); Shanghai (7, median 22.7 d) .
The ships do not sail this lane in a straight line. The most called intermediate port is Busan, on 57% of voyages (779 of 1,376), and the median voyage makes 2 intermediate calls (the most recorded is 7). A container the carrier records as direct still rides a ship that stops along the way — direct means no transshipment, not nonstop.
Voyage time is not stable. By year the median ran from 21.0 d in 2026 to 33.7 d in 2022, a spread of 12.7 d across 5 years.
It is not uniform across carriers either. Over the whole period the quickest well-evidenced service is ZIM - ZPX at 15.2 d (Zim Integrated Shipping Services, n=10) and the slowest of the ranked set is PN3 at 25.0 d (Ocean Network Express, n=13) — a difference of 9.8 d on the same lane.
Nothing here is scheduled, modelled or estimated. Every figure is a count of observed movements, and every figure carries that count.
Each row names a figure on this page, what it means, and the exact expression that regenerates it from the exported file. Column names are the CSV’s own. vessel-calls.csv is one row per paired voyage; container-records.csv is one row per container journey. Both export the whole lane, unfiltered — apply the same date or operator filter you have on screen to reproduce a filtered figure.
| Figure | Value | What it means | Reproduce it |
|---|---|---|---|
| Paired voyages | 1,376 | One ship leaving Shanghai and reaching Rotterdam. The unit behind every AIS figure on the page. | vessel-calls.csv · COUNT(*) |
| Distinct vessels on this lane | 427 | Individual hulls, however many times each sailed. | vessel-calls.csv · COUNT(DISTINCT imo) |
| Ship median transit | 24.0 d | Middle voyage, port to port. Hull in water — it excludes nothing and includes any intermediate calls. | vessel-calls.csv · MEDIAN(transit_days) |
| A shipping line’s sailings | 152 for Maersk AE5 | Voyages that carrier ran on that one service string. | vessel-calls.csv · COUNT(*) WHERE operator=… AND service=… |
| A shipping line’s median | 31.9 d for Maersk AE5 | Middle voyage of that operator + service pair. | vessel-calls.csv · MEDIAN(transit_days) WHERE operator=… AND service=… |
| Vessels deployed, per period | Operations pane | Distinct hulls that sailed in the period. | vessel-calls.csv · COUNT(DISTINCT imo) GROUP BY year(departure_utc) |
| Capacity deployed, per period | Operations pane | Slot capacity offered: the TEU of every sailing, summed. Not cargo moved. | vessel-calls.csv · SUM(teu) GROUP BY year(departure_utc) |
| Ports called en route | map dots | Share of voyages that called there. A voyage counts once per port however often it called. | vessel-calls.csv · COUNT(*) WHERE ports_en_route LIKE '%port name%' / COUNT(*) |
| Tracked journeys on this lane | 714 | Containers whose whole door-to-door journey the carrier published. | container-records.csv · COUNT(*) |
| Median door to door | 24.3 d | Middle container journey, including port time at both ends and at any hub. Not comparable with the ship median above. | container-records.csv · MEDIAN(transit_days) |
| Middle half | 22.0–27.6 d | The 25th to 75th percentile of those journeys. | container-records.csv · QUANTILE(transit_days, .25) … (.75) |
| Carriers recording this lane | 3 | Carriers publishing container events here — fewer than the operators AIS sees. | container-records.csv · COUNT(DISTINCT carrier) |
| Direct vs via | Containers pane | Direct means never transshipped. Via names the hub where the box changed vessel. | container-records.csv · GROUP BY transship_ports (empty = direct) |
Two grains, stated plainly. The routing cards in the Containers pane follow the route finder: every figure there is a median over the voyage records that route-report (the Export data workbook) rebuilds row by row. container-records.csv is a different cut — the all-time booking log at one row per door-to-door journey (714 rows here), with no recency window. Use the workbook to reproduce the cards; use the CSV for the raw journey log.
Both record sets download as CSV at their own grain. Container records are the routing/carrier rows behind the Containers pane; vessel calls are one row per paired voyage with its particulars and the ports it called. Row allowances are per account and per calendar month.