Last 18 months to Sep 2026. Containers to 1 Sep, ships to 11 Aug. Rest of page: all years.
One row per paired voyage on this lane: the ship left Rotterdam, arrived Algeciras, 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.
Rotterdam → Algeciras is measured twice here, from two independent records. Carrier container tracking records 8 routings on this lane (62 carrier/service combinations, 11 operators); sailing direct, a container typically takes 15.08 days gate to gate over 415 recorded voyages — the same figures the route finder shows for this pair. AIS ship movements give 1,226 port-to-port voyages by 372 vessels, median 14.4 days (mean 23.2 d, middle half 10.5–22.9 d).
The two medians are not comparable directly: 1 carriers record containers on this lane against 27 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 4.21 d at Rotterdam (21,355 records) and 4.32 d at Algeciras (1,150 records).
Of the 688 journeys whose routing is recorded, 671 moved without transshipment and 17 were transshipped — Tanger MED (8, median 20.7 d); Salalah (6, median 83.3 d); Bremerhaven (3, median 18.3 d) .
The ships do not sail this lane in a straight line. The most called intermediate port is Antwerp, on 32% of voyages (392 of 1,226), and the median voyage makes 3 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 13.6 d in 2024 to 15.6 d in 2022, a spread of 2.0 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 6.5 d (CMA CGM, n=73) and the slowest of the ranked set is FE3 at 20.6 d (HMM, n=18) — a difference of 14.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 | 1,226 | 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 | 372 | Individual hulls, however many times each sailed. | vessel-calls.csv · COUNT(DISTINCT imo) |
| Ship median transit | 14.4 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 | 696 | Containers whose whole door-to-door journey the carrier published. | container-records.csv · COUNT(*) |
| Median door to door | 5.5 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 | 4.8–7.4 d | The 25th to 75th percentile of those journeys. | container-records.csv · QUANTILE(transit_days, .25) … (.75) |
| Carriers recording this lane | 1 | 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 (696 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.