Four reefer trucks carried cold-chain pharma for our ERP customer yesterday. The temperature loggers in all four say nothing went above 8 °C. One customer is certain their cargo spoiled. They are right.
Find the shipment that breached, when the cargo air first crossed 8.0 °C, and how hot it got.
| File | What it is |
|---|---|
| shipments.csv | the four shipments: route, cargo, logger, limit |
| telemetry.csv | 2,400 rows, one per minute per shipment: logger reading and ambient temperature along the route |
| stops.csv | every stop where the doors opened, with door-open and door-close times |
| loggers.csv | fleet logger register: model, firmware, unit, mounting, calibration certificate |
| CAL-TL25-B07.csv | batch calibration certificate for the loggers |
| DATASHEET.md | the logger datasheet |
Ambient temperatures are from the Open-Meteo ERA5 archive (CC BY 4.0) for the route cities, 14 Oct 2025. Everything else is synthetic.
BASE=https://1005systems.github.io/hiring-portal/cold-chain for f in shipments.csv telemetry.csv stops.csv loggers.csv CAL-TL25-B07.csv DATASHEET.md; do curl -sO $BASE/$f; done
The customer's QA team wants one number for all four shipments together: total minutes the cargo air was at or above 8.0 °C.
COLD <shipment_id> <HH:MM IST> <peak °C>.