Last 18 months to Aug 2026. Containers to 28 Aug, ships to 17 Jul. Rest of page: all years.
One row per paired voyage on this lane: the ship left Shanghai, arrived Le Havre, 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 → Le Havre is measured twice here, from two independent records. Carrier container tracking records 11 routings on this lane (32 carrier/service combinations, 7 operators); sailing direct, a container typically takes 47.33 days gate to gate over 247 recorded voyages — the same figures the route finder shows for this pair. AIS ship movements give 796 port-to-port voyages by 219 vessels, median 47.0 days (mean 48.8 d, middle half 41.4–55.6 d).
The two medians are not comparable directly: 2 carriers record containers on this lane against 13 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 4.26 d at Le Havre (2,932 records).
Of the 698 journeys whose routing is recorded, 508 moved without transshipment and 190 were transshipped — Algeciras (75, median 46.5 d); Singapore (72, median 42.0 d); Tanger MED (24, median 45.6 d); Le Havre (6, median 53.0 d) .
The ships do not sail this lane in a straight line. The most called intermediate port is Yantian, on 78% of voyages (617 of 796), and the median voyage makes 5 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 43.8 d in 2026 to 53.2 d in 2024, a spread of 9.4 d across 5 years.
It is not uniform across carriers either. Over the whole period the quickest well-evidenced service is OCEAN - NEU4 | CMA - FAL1 +3 at 38.4 d (CMA CGM, n=134) and the slowest of the ranked set is THEA - FE2 | ASC - CEX +4 at 54.5 d (Hapag-Lloyd, n=37) — a difference of 16.1 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 | 796 | 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 | 219 | Individual hulls, however many times each sailed. | vessel-calls.csv · COUNT(DISTINCT imo) |
| Ship median transit | 47.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 | 721 | Containers whose whole door-to-door journey the carrier published. | container-records.csv · COUNT(*) |
| Median door to door | 45.0 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 | 43.0–48.0 d | The 25th to 75th percentile of those journeys. | container-records.csv · QUANTILE(transit_days, .25) … (.75) |
| Carriers recording this lane | 2 | 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 (721 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.