Cold Chain IoT Sensor Metrics
This dataset provides granular, time-stamped sensor readings from IoT devices used in pharmaceutical cold chain logistics, including temperature, humidity, shock events, and location data. It enables supply chain managers to monitor shipment integrity, ensure regulatory compliance, and optimize operational efficiency for sensitive products. The dataset is ideal for real-time alerts, historical analytics, and sustainability reporting.
Sample rows
preview · 8 of 120 rows · all 14 columns| sensor_idstring | sensor_statusstring | battery_level_percentfloat | shock_detectedboolean | product_typestring | shipment_idstring | timestampdatetime | temperature_celsiusfloat | humidity_percentfloat | shock_g_forcefloat | location_latitudefloat | location_longitudefloat | compliance_flagboolean | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SN-1024-EU | active | 87.5 | false | insulin | SHIP-1001 | 2024-06-01T08:22:11Z | 4.2 | 41.3 | blank | 48.8566 | 2.3522 | true | Normal transit reading, within range. |
| SENSOR-ADL-98 | active | 92.1 | true | cold-chain | SHIP-1002 | 2024-06-01T09:12:45Z | 5.7 | 55.1 | 2.8 | -34.9285 | 138.6007 | true | Routine compliance check, mild shock detected. |
| T-458-EU | active | 80 | false | vaccines | SHIP-1001 | 2024-06-01T23:59:59Z | 7.5 | 38.2 | blank | 50.1109 | 8.6821 | true | End-of-day scan, all values nominal. |
| SN-LOW-889 | error | 4.2 | true | frozen plasma | SHIP-1003 | 2024-06-02T03:03:19Z | -100 | 0 | 14.7 | 89.9999 | -135 | false | Temperature at regulatory boundary! Deep freeze. |
| B-9012 | active | 99 | false | antivirals | SHIP-1004 | 2024-06-02T12:45:02Z | 24.1 | 44.7 | blank | 35.6895 | 139.6917 | true | Start-of-day reading, shipment just departed. |
| Q-TEST-07 | error | 18.3 | true | pain-relief | SHIP-1002 | 2024-06-02T15:22:33Z | 36.5 | 97.5 | 8.1 | 19.4326 | -99.1332 | false | Extreme humidity/shock! Immediate investigation. |
| SN-2048-US | active | 61.7 | false | growth-hormone | SHIP-1005 | 2024-06-02T19:55:44Z | 2.1 | 30.8 | blank | 40.7128 | -74.006 | true | Normal transit reading, battery level moderate. |
| Z-GLB-112 | inactive | 1 | true | experimental | SHIP-1006 | 2024-06-03T07:15:53Z | 100 | 100 | 18.2 | -90 | 180 | false | Extreme temperature/humidity/shock! Sensor inactive. |
| SENSOR-TEST-55 | active | 85.3 | false | hormones | SHIP-1004 | 2024-06-03T08:00:01Z | 22.3 | 54.5 | blank | 51.5074 | -0.1278 | true | First scan at warehouse, all readings normal. |
| A-EXP-888 | active | 55.5 | false | antibiotics | SHIP-1007 | 2024-06-03T12:33:07Z | 3.6 | 38.9 | blank | 41.9028 | 12.4964 | true | Routine compliance check, shipment in transit. |
| SN-TRIAL-001 | maintenance | 73.4 | false | clinical-trials | SHIP-1008 | 2024-06-03T15:16:18Z | 25 | 63.2 | blank | 52.52 | 13.405 | true | Maintenance scheduled, reading valid. |
| T-TEST-99 | maintenance | 44.8 | true | oral-tablets | SHIP-1008 | 2024-06-03T20:50:11Z | 21.7 | 77.1 | 5.4 | 45.4642 | 9.19 | false | Max humidity + significant shock event. |
| SN-2345-UK | active | 96.2 | false | cold-chain | SHIP-1009 | 2024-06-04T06:03:24Z | 7.1 | 31.4 | blank | 53.4808 | -2.2426 | true | Routine compliance check, shipment on route. |
| SENSOR-PAIN-22 | error | 15 | true | pain-relief | SHIP-1007 | 2024-06-04T15:29:37Z | 37.6 | 84.4 | 13.9 | 34.0522 | -118.2437 | false | High temp and shock detected! Needs review. |
| SN-3011-CA | active | 88.2 | false | vaccines | SHIP-1010 | 2024-06-04T16:45:19Z | 5.2 | 42.6 | blank | 43.6532 | -79.3832 | true | Normal transit reading, all parameters okay. |
| X-TRIAL-76 | active | 60.6 | false | rapid-tests | SHIP-1010 | 2024-06-04T19:49:01Z | 2.9 | 36.7 | blank | 55.9533 | -3.1883 | true | Routine scan, battery sufficient. |
| SN-EX-007 | inactive | 0 | true | specialty | SHIP-1011 | 2024-06-05T00:00:01Z | 100 | 100 | 17.3 | blank | blank | false | Critical error, sensor battery depleted. |
| SN-1212-FR | active | 82.6 | false | immuno-suppressants | SHIP-1011 | 2024-06-05T08:41:14Z | 3.4 | 36.2 | blank | 48.8566 | 2.3522 | true | Morning scan, shipment stable. |
| SENSOR-MNT-41 | maintenance | 41.9 | true | clinical-trials | SHIP-1012 | 2024-06-05T12:00:00Z | 4.8 | 67.1 | 4.1 | 59.3293 | 18.0686 | false | Scheduled maintenance, minor shock detected. |
| SN-5678-NL | active | 99.9 | false | insulin | SHIP-1013 | 2024-06-05T18:19:27Z | 2.5 | 31 | blank | 52.3702 | 4.8952 | true | Shipment arrived at destination, compliance passed. |
What the 120 rows show
from the 120-row sampleError (sensor status) stands out: mean battery_
- 30%shock_
detected = true - 80.0median battery_
level_ percent - 5.7median temperature_
celsius - 46.9median humidity_
percent - 10.8median shock_
g_ force
Median 80.0, from 0.0 to 99.9.
- string 5
- float 6
- datetime 1
- boolean 2
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 5 columns | |||
sensor_id | string | Unique identifier for the IoT sensor device | SN-1024-EU |
shipment_id | string | Unique identifier for the shipment or consignment being monitored | SHIP-1001 |
sensor_status | string | Operational status of the sensor at the time of readingactive · inactive · error · maintenance · optional | active |
product_type | string | Type or category of pharmaceutical product being monitoredoptional | insulin |
notes | string | Additional notes or comments about the reading or shipmentoptional | Normal transit reading, w… |
| Numbers 6 columns | |||
temperature_celsius | float | Temperature reading in degrees Celsius-100 to 100 | 4.2 |
humidity_percent | float | Relative humidity reading as a percentage (0-100%)0 to 100 | 41.3 |
shock_g_force | float | Peak g-force measured during a shock event (if detected); null if no shock0 or more · optional | 2.8 |
location_latitude | float | Latitude coordinate of the sensor at the time of reading-90 to 90 · optional | 48.8566 |
location_longitude | float | Longitude coordinate of the sensor at the time of reading-180 to 180 · optional | 2.3522 |
battery_level_percent | float | Sensor battery level as a percentage (0-100%)0 to 100 · optional | 87.5 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the sensor reading was recorded (UTC) | 2024-06-01T08:22:11Z |
| True or false 2 columns | |||
shock_detected | boolean | Indicates if a shock event was detected at this timestamp | false |
compliance_flag | boolean | Indicates if the reading is within regulatory compliance thresholdsoptional | true |
Use it for
A logistics dashboard
The shock_
detected rate, battery_ level_ percent by sensor_ status and a breakdown of product_ type. Excel, Power BI or Tableau. Why do the 19 error rows have a mean battery_
level_ percent of 13.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sensors120SN-1024-EU87.5activeSENSOR-ADL-9892.1activeSN-LOW-8894.2error
A software demo
Believable sensors with shipment_
id, timestamp and temperature_ celsius to fill a screen in front of a buyer.
This dataset120 rows14 columns
Yours1,000 rows14 columnslocation_latitude: UK only
blueprint · cold-chain-iot-sensor-metrics
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Temperature readings must remain within defined safe thresholds for each product type.
- Any humidity excursion triggers a compliance alert entry.
- Shock events above critical G-force level must be logged with location and timestamp.
- Sensor battery status is recorded and must not fall below 20% during transit.
- Route deviation metrics are flagged and annotated for risk analysis.
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- cold-chain-iot-sensor-metrics