Real-Time Cold Chain Sensor Logs
This dataset provides granular, real-time IoT sensor logs for refrigerated supply chain shipments, including environmental readings, shipment details, location, and compliance status. It enables logistics managers to monitor temperature and humidity integrity, respond to alerts, and ensure regulatory compliance for food and pharmaceutical products. The comprehensive schema supports operational optimization, risk mitigation, and detailed reporting.
Sample rows
preview · 8 of 120 rows · all 20 columns| log_idstring | alert_typestring | humidity_percentfloat | alert_flagboolean | sensor_idstring | timestampdatetime | shipment_idstring | product_typestring | temperature_celsiusfloat | location_latitudefloat | location_longitudefloat | location_citystring | location_statestring | location_countrystring | alert_thresholdfloat | battery_level_percentfloat | shipment_start_datedate | shipment_expected_delivery_datedate | carrier_namestring | compliance_statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ABC123-001 | none | 54.2 | false | SENS-00001 | 2024-05-01T08:15:26Z | SHIP-0001 | food | 5.6 | 34.0522 | -118.2437 | Los Angeles | CA | USA | blank | 98.3 | 2024-04-28 | 2024-05-03 | FedEx | compliant |
| XYZ789-002 | none | 41.5 | false | SENS-00002 | 2024-05-01T09:30:12Z | SHIP-0002 | pharmaceutical | 3.2 | 40.7128 | -74.006 | New York | NY | USA | blank | 87.5 | 2024-04-30 | 2024-05-05 | UPS | compliant |
| LMN456-003 | none | blank | false | SENS-00003 | 2024-05-01T10:20:45Z | SHIP-0003 | other | 29.8 | 51.5074 | -0.1278 | London | England | UK | blank | 73.2 | 2024-04-29 | 2024-05-06 | RoyalMail | compliant |
| DEF321-004 | none | 60.7 | false | SENS-00004 | 2024-05-01T11:45:15Z | SHIP-0004 | food | 8.1 | 48.8566 | 2.3522 | Paris | Île-de-France | France | blank | 90.1 | 2024-04-27 | 2024-05-02 | LaPoste | compliant |
| JKL654-005 | temperature_high | 65.3 | true | SENS-00001 | 2024-05-01T13:05:54Z | SHIP-0001 | food | 13.7 | 34.0522 | -118.2437 | Los Angeles | CA | USA | 10 | 96.4 | 2024-04-28 | 2024-05-03 | FedEx | non-compliant |
| QRS987-006 | temperature_high | 13.9 | true | SENS-00005 | 2024-05-01T14:15:36Z | SHIP-0005 | pharmaceutical | 42.1 | 55.7558 | 37.6173 | Moscow | Moscow | Russia | 40 | 39.8 | 2024-04-30 | 2024-05-07 | RussianPost | non-compliant |
| TUV321-007 | none | 14.7 | false | SENS-00006 | 2024-05-01T15:00:00Z | SHIP-0006 | other | 0 | 35.6895 | 139.6917 | Tokyo | Tokyo | Japan | blank | 80.4 | 2024-04-29 | 2024-05-05 | JapanPost | compliant |
| MNO987-008 | none | 52.1 | false | SENS-00007 | 2024-05-01T16:45:23Z | SHIP-0007 | food | 2.9 | 45.4215 | -75.6998 | Ottawa | ON | Canada | blank | 88.7 | 2024-04-26 | 2024-05-03 | Purolator | compliant |
| PQR234-009 | none | 48.8 | false | SENS-00008 | 2024-05-01T17:15:44Z | SHIP-0008 | pharmaceutical | 9.6 | -34.6037 | -58.3816 | Buenos Aires | BA | Argentina | blank | 82 | 2024-05-01 | 2024-05-08 | AndesCargo | compliant |
| STU765-010 | humidity_high | 99.9 | true | SENS-00009 | 2024-05-01T18:22:08Z | SHIP-0009 | other | 37.2 | -54.8019 | -68.303 | Ushuaia | TI | Argentina | 90 | 15.1 | 2024-04-28 | 2024-05-06 | AndesCargo | non-compliant |
| VWX543-011 | none | 44.2 | false | SENS-00003 | 2024-05-01T19:55:30Z | SHIP-0003 | other | 32 | 51.5074 | -0.1278 | London | England | UK | blank | 70.9 | 2024-04-29 | 2024-05-06 | RoyalMail | compliant |
| GHI789-012 | none | 55.7 | false | SENS-00010 | 2024-05-02T05:20:16Z | SHIP-0010 | food | 6.3 | 41.8781 | -87.6298 | Chicago | IL | USA | blank | 95.2 | 2024-04-30 | 2024-05-05 | UPS | compliant |
| OPQ234-013 | none | 36.8 | false | SENS-00011 | 2024-05-02T06:10:38Z | SHIP-0011 | pharmaceutical | -2.3 | 39.9042 | 116.4074 | Beijing | Beijing | China | blank | 84.6 | 2024-04-29 | 2024-05-06 | SFExpress | compliant |
| EFG678-014 | none | 61.9 | false | SENS-00012 | 2024-05-02T07:45:22Z | SHIP-0012 | food | 9.4 | 43.6532 | -79.3832 | Toronto | ON | Canada | blank | 93.8 | 2024-04-28 | 2024-05-03 | Purolator | compliant |
| HIJ345-015 | humidity_high | 74.5 | true | SENS-00004 | 2024-05-02T09:32:10Z | SHIP-0004 | food | 18.5 | 48.8566 | 2.3522 | Paris | Île-de-France | France | 70 | 87.9 | 2024-04-27 | 2024-05-02 | LaPoste | non-compliant |
| RST567-016 | temperature_high | 47.2 | true | SENS-00013 | 2024-05-02T11:10:08Z | SHIP-0013 | pharmaceutical | 45.7 | -33.8688 | 151.2093 | Sydney | NSW | Australia | 40 | 18.3 | 2024-04-30 | 2024-05-07 | Toll | non-compliant |
| UVW678-017 | none | 38.6 | false | SENS-00006 | 2024-05-02T12:55:40Z | SHIP-0006 | other | 16.9 | 35.6895 | 139.6917 | Tokyo | Tokyo | Japan | blank | 79.6 | 2024-04-29 | 2024-05-05 | JapanPost | compliant |
| XZY890-018 | none | 47 | false | SENS-00014 | 2024-05-02T13:30:21Z | SHIP-0014 | food | 2.1 | 59.3293 | 18.0686 | Stockholm | Stockholm | Sweden | blank | 89.3 | 2024-04-28 | 2024-05-04 | PostNord | compliant |
| YUI234-019 | temperature_high | 99 | true | SENS-00015 | 2024-05-02T15:25:13Z | SHIP-0015 | pharmaceutical | 49.2 | -34.6037 | -58.3816 | Buenos Aires | BA | Argentina | 40 | 7.5 | 2024-04-30 | 2024-05-08 | AndesCargo | non-compliant |
| POI567-020 | temperature_high | 100 | true | SENS-00016 | 2024-05-02T16:45:39Z | SHIP-0016 | other | 50 | -90 | 0 | McMurdo Station | Antarctica | Antarctica | 45 | 0 | 2024-05-01 | 2024-05-10 | PolarExpress | non-compliant |
What the 120 rows show
from the 120-row sampleTemperature_
- 34%alert_
flag = true - 49.2median humidity_
percent - 2compliance statuses
- 3product types
- 18carrier names
- 19location countries
Temperature_
Median 49.2, from 0.0 to 100.0.
- string 10
- float 6
- date 2
- datetime 1
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
log_id | string | Unique identifier for each sensor log entryunique | ABC123-001 |
sensor_id | string | Unique identifier for the IoT sensor device | SENS-00001 |
shipment_id | string | Unique identifier for the shipment associated with the sensor reading | SHIP-0001 |
product_type | string | Type of product being shipped (e.g., food, pharmaceutical)food · pharmaceutical · other | food |
location_city | string | City where the sensor reading was takenoptional | Los Angeles |
location_state | string | State or region where the sensor reading was takenoptional | CA |
location_country | string | Country where the sensor reading was takenoptional | USA |
alert_type | string | Type of alert triggered (e.g., temperature_high, temperature_low, humidity_high, humidity_low)5 values · optional | none |
carrier_name | string | Name of the logistics carrier responsible for the shipmentoptional | FedEx |
compliance_status | string | Status indicating if the shipment is in compliance with temperature/humidity regulationscompliant · non-compliant · pending · optional | compliant |
| Numbers 6 columns | |||
temperature_celsius | float | Measured temperature in degrees Celsius-50 to 50 | 5.6 |
humidity_percent | float | Measured relative humidity as a percentage0 to 100 · optional | 54.2 |
location_latitude | float | Latitude coordinate of the sensor at the time of reading-90 to 90 · optional | 34.0522 |
location_longitude | float | Longitude coordinate of the sensor at the time of reading-180 to 180 · optional | -118.2437 |
alert_threshold | float | Threshold value that triggered the alert, if anyoptional | 10 |
battery_level_percent | float | Sensor battery level as a percentage at the time of reading0 to 100 · optional | 98.3 |
| Dates and times 3 columns | |||
timestamp | datetime | Date and time when the sensor reading was recorded (UTC) | 2024-05-01T08:15:26Z |
shipment_start_date | date | Date the shipment beganoptional | 2024-04-28 |
shipment_expected_delivery_date | date | Expected delivery date for the shipmentoptional | 2024-05-03 |
| True or false 1 column | |||
alert_flag | boolean | Indicates if the reading triggered a temperature or humidity alert | false |
Use it for
A logistics dashboard
The alert_
flag rate, humidity_ percent by alert_ type and a breakdown of sensor_ id. Excel, Power BI or Tableau. Why do 41 of 120 rows have alert_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs120ABC123-00154.2noneJKL654-00565.3temperat…QRS987-00613.9temperat…
A software demo
Believable logs with timestamp, sensor_
id and shipment_ id to fill a screen in front of a buyer.
blueprint · real-time-cold-chain-sensor-logs
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 20 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.
- Each row represents a sensor snapshot from a shipment at a timestamp.
- Temperatures must remain within predefined safe ranges depending on cargo type.
- Automatic alerts triggered if temperature deviates for more than 10 minutes.
- Sensor readings include geolocation and status (normal, warning, critical).
- Shipments flagged for inspection if three or more warnings occur in transit.
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
- real-time-cold-chain-sensor-logs