Cold Chain Pharmaceutical Temp Logs
This dataset provides granular, real-time logs of temperature and humidity conditions for pharmaceutical shipments in the cold chain, including compliance status, alerting, and geolocation data. It enables supply chain stakeholders to monitor medication integrity, ensure regulatory compliance, and optimize logistics for temperature-sensitive products. The rich contextual fields support spoilage prevention, route analysis, and auditability for high-value pharmaceutical deliveries.
Sample rows
preview · 8 of 100 rows · all 22 columns| log_idstring | compliance_statusstring | temperature_celsiusfloat | alert_flagboolean | location_statestring | shipment_idstring | container_idstring | sensor_idstring | timestampdatetime | humidity_percentfloat | location_latitudefloat | location_longitudefloat | location_citystring | location_countrystring | route_idstring | medication_namestring | batch_numberstring | min_temp_celsiusfloat | max_temp_celsiusfloat | min_humidity_percentfloat | max_humidity_percentfloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOG-0001-2024A | compliant | 5.3 | false | NY | SHIP-101 | CONT-501 | SENS-9001 | 2024-06-01T08:12:33Z | 54.7 | 40.7128 | -74.006 | New York | USA | R-NE-001 | Insulin Glargine | BG-INS-20240601-001 | 2 | 8 | 30 | 60 | blank |
| LOG-0002-2024A | non-compliant | 8.6 | true | NY | SHIP-101 | CONT-502 | SENS-9002 | 2024-06-01T08:17:48Z | 61.5 | 40.713 | -74.0058 | New York | USA | R-NE-001 | Insulin Glargine | BG-INS-20240601-001 | 2 | 8 | 30 | 60 | Temperature exceeded max allowed; alert sent to driver |
| LOG-0003-2024A | compliant | 3.7 | false | CA | SHIP-102 | CONT-503 | SENS-9003 | 2024-06-01T09:02:15Z | 42.3 | 34.0522 | -118.2437 | Los Angeles | USA | R-WC-004 | Adalimumab | BG-ADA-20240531-002 | 2 | 8 | 35 | 55 | blank |
| LOG-0004-2024A | non-compliant | 7.9 | true | CA | SHIP-102 | CONT-504 | SENS-9004 | 2024-06-01T09:23:15Z | 56.2 | 34.0524 | -118.2435 | Los Angeles | USA | R-WC-004 | Adalimumab | BG-ADA-20240531-002 | 2 | 8 | 35 | 55 | Humidity exceeded allowed threshold; corrective action initiated |
| LOG-0005-2024A | compliant | 6.1 | false | blank | SHIP-103 | CONT-505 | SENS-9005 | 2024-06-01T10:12:05Z | 49.8 | 51.5074 | -0.1278 | London | UK | R-EU-002 | Etanercept | BG-ETA-20240601-003 | 2 | 8 | 35 | 60 | blank |
| LOG-0006-2024A | non-compliant | -0.8 | true | ON | SHIP-104 | CONT-506 | SENS-9006 | 2024-06-01T11:03:11Z | 37.2 | 43.6532 | -79.3832 | Toronto | Canada | R-CAN-003 | Filgrastim | BG-FIL-20240601-004 | 2 | 8 | 33 | 60 | Temperature below minimum threshold; report sent |
| LOG-0007-2024A | compliant | 2.8 | false | ON | SHIP-104 | CONT-507 | SENS-9007 | 2024-06-01T11:14:18Z | 39.1 | 43.6534 | -79.383 | Toronto | Canada | R-CAN-003 | Filgrastim | BG-FIL-20240601-004 | 2 | 8 | 33 | 60 | blank |
| LOG-0008-2024A | compliant | 4.6 | false | blank | SHIP-105 | CONT-508 | SENS-9008 | 2024-06-01T12:02:26Z | 47 | 48.8566 | 2.3522 | Paris | France | R-EU-005 | Infliximab | BG-INF-20240601-005 | 2 | 8 | 32 | 56 | blank |
| LOG-0009-2024A | non-compliant | 9.3 | true | blank | SHIP-105 | CONT-509 | SENS-9009 | 2024-06-01T12:17:22Z | 53.4 | 48.8567 | 2.3524 | Paris | France | R-EU-005 | Infliximab | BG-INF-20240601-005 | 2 | 8 | 32 | 56 | Temperature above max threshold; alert triggered |
| LOG-0010-2024A | compliant | 2.2 | false | blank | SHIP-106 | CONT-510 | SENS-9010 | 2024-06-01T13:10:11Z | 38.7 | 52.52 | 13.405 | Berlin | Germany | R-EU-003 | Palivizumab | BG-PAL-20240601-006 | 2 | 8 | 30 | 55 | blank |
| LOG-0011-2024A | non-compliant | 12.4 | true | blank | SHIP-106 | CONT-511 | SENS-9011 | 2024-06-01T13:25:03Z | 40.2 | 52.5202 | 13.4052 | Berlin | Germany | R-EU-003 | Palivizumab | BG-PAL-20240601-006 | 2 | 8 | 30 | 55 | Temperature above compliance; shipment paused |
| LOG-0012-2024A | compliant | 7.1 | false | IL | SHIP-107 | CONT-512 | SENS-9012 | 2024-06-01T14:03:28Z | 50.3 | 41.8781 | -87.6298 | Chicago | USA | R-MW-001 | Somatropin | BG-SOM-20240601-007 | 2 | 8 | 40 | 58 | blank |
| LOG-0013-2024A | non-compliant | 8.4 | true | IL | SHIP-107 | CONT-513 | SENS-9013 | 2024-06-01T14:11:46Z | 60.4 | 41.8782 | -87.6297 | Chicago | USA | R-MW-001 | Somatropin | BG-SOM-20240601-007 | 2 | 8 | 40 | 58 | Humidity above max threshold; shipment investigated |
| LOG-0014-2024A | compliant | 2.7 | false | CDMX | SHIP-108 | CONT-514 | SENS-9014 | 2024-06-01T15:01:22Z | 41.7 | 19.4326 | -99.1332 | Mexico City | Mexico | R-MEX-001 | Pegfilgrastim | BG-PEG-20240601-008 | 2 | 8 | 30 | 60 | blank |
| LOG-0015-2024A | non-compliant | 9.1 | true | CDMX | SHIP-108 | CONT-515 | SENS-9015 | 2024-06-01T15:13:33Z | 62.1 | 19.4328 | -99.133 | Mexico City | Mexico | R-MEX-001 | Pegfilgrastim | BG-PEG-20240601-008 | 2 | 8 | 30 | 60 | Temperature and humidity both exceeded limits |
| LOG-0016-2024A | compliant | 4.9 | false | blank | SHIP-109 | CONT-516 | SENS-9016 | 2024-06-01T16:04:17Z | 52.4 | 35.6895 | 139.6917 | Tokyo | Japan | R-JP-001 | Bevacizumab | BG-BEV-20240601-009 | 2 | 8 | 35 | 60 | blank |
| LOG-0017-2024A | non-compliant | 7.6 | true | blank | SHIP-109 | CONT-517 | SENS-9017 | 2024-06-01T16:18:44Z | 61.2 | 35.6897 | 139.6919 | Tokyo | Japan | R-JP-001 | Bevacizumab | BG-BEV-20240601-009 | 2 | 8 | 35 | 60 | Humidity exceeded allowed maximum |
| LOG-0018-2024A | compliant | 3.4 | false | blank | SHIP-110 | CONT-518 | SENS-9018 | 2024-06-01T17:00:07Z | 40.6 | 55.7558 | 37.6173 | Moscow | Russia | R-RUS-001 | Abatacept | BG-ABA-20240601-010 | 2 | 8 | 32 | 57 | blank |
| LOG-0019-2024A | non-compliant | 8.7 | true | blank | SHIP-110 | CONT-519 | SENS-9019 | 2024-06-01T17:16:53Z | 35.2 | 55.7559 | 37.6175 | Moscow | Russia | R-RUS-001 | Abatacept | BG-ABA-20240601-010 | 2 | 8 | 32 | 57 | Temperature above compliance; alert sent to local team |
| LOG-0020-2024A | compliant | 5.2 | false | CA | SHIP-111 | CONT-520 | SENS-9020 | 2024-06-01T18:05:21Z | 45.3 | 37.7749 | -122.4194 | San Francisco | USA | R-WC-002 | Rituximab | BG-RIT-20240601-011 | 2 | 8 | 36 | 62 | blank |
What the 100 rows show
from the 100-row sampleCompliant (compliance status) stands out: mean temperature_
- 49%alert_
flag = true - 6.0median temperature_
celsius - 20location countries
- 29location cities
- 54.5median humidity_
percent - 35median min_
humidity_ percent
Median 6.0, from -0.80 to 12.4.
- string 12
- float 8
- datetime 1
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
log_id | string | Unique identifier for each temperature and humidity log entry.unique | LOG-0001-2024A |
shipment_id | string | Unique identifier for the shipment associated with this log. | SHIP-101 |
container_id | string | Identifier for the physical container or package being monitored. | CONT-501 |
sensor_id | string | Unique identifier for the sensor device recording the data. | SENS-9001 |
location_city | string | City where the log was recorded, if available.optional | New York |
location_state | string | State or province where the log was recorded, if available.optional | NY |
location_country | string | Country where the log was recorded, if available.optional | USA |
route_id | string | Identifier for the planned shipment route.optional | R-NE-001 |
medication_name | string | Name of the primary medication or product being shipped. | Insulin Glargine |
batch_number | string | Batch or lot number of the medication. | BG-INS-20240601-001 |
compliance_status | string | Indicates if the temperature/humidity at the time of logging was within compliance thresholds.compliant · non-compliant | compliant |
notes | string | Optional notes or comments regarding this log entry (e.g., reason for non-compliance, corrective action).optional | Humidity above allowed |
| Numbers 8 columns | |||
temperature_celsius | float | Measured temperature in degrees Celsius at the time of logging.-100 to 100 | 5.3 |
humidity_percent | float | Measured relative humidity percentage at the time of logging.0 to 100 | 54.7 |
location_latitude | float | Latitude coordinate of the shipment at the time of logging.-90 to 90 · optional | 40.7128 |
location_longitude | float | Longitude coordinate of the shipment at the time of logging.-180 to 180 · optional | -74.006 |
min_temp_celsius | float | Minimum allowable temperature for the medication (compliance threshold).-100 to 100 | 2 |
max_temp_celsius | float | Maximum allowable temperature for the medication (compliance threshold).-100 to 100 | 8 |
min_humidity_percent | float | Minimum allowable humidity percentage for the medication (compliance threshold).0 to 100 · optional | 30 |
max_humidity_percent | float | Maximum allowable humidity percentage for the medication (compliance threshold).0 to 100 · optional | 60 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the temperature and humidity were recorded (UTC). | 2024-06-01T08:12:33Z |
| True or false 1 column | |||
alert_flag | boolean | Indicates whether an alert was triggered due to non-compliance at this log entry. | false |
15 SQL practice questions for the Cold Chain Pharmaceutical Temp Logs
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
Non-compliant readings with alerts
Return log_id, shipment_id, temperature_celsius and medication_name for every reading where compliance_status is 'non-compliant' and alert_flag is 1. Order the results by temperature_celsius from highest to lowest, then by log_id ascending.
Tables: cold_chain_pharmaceutical_temp_logs · your result: 4 columns, 49 rowsCountries in the network
Return each distinct location_country found in the logs, in a column named location_country, sorted alphabetically.
Tables: cold_chain_pharmaceutical_temp_logs · your result: 1 columns, 20 rowsReadings per compliance status
Return compliance_status and the number of readings for each status as reading_count. Order the results by compliance_status.
Tables: cold_chain_pharmaceutical_temp_logs · your result: 2 columns, 2 rows
- 04Average temperature by countryBeginner
- 05Alerts by country tablePower BI
- 06Temperature bandsIntermediate
- 07Cities hotter than the overall averageIntermediate
- 08Monthly non-compliance rateIntermediate
- 09Medications with repeated excursionsIntermediate
- 10Humidity breach rate measurePower BI
- 11Rank medications by average temperatureAdvanced
- 12Temperature change between readingsAdvanced
- 13Running alert totalAdvanced
- 14Share of alerts by countryAdvanced
- 15Temperature anomalies per medicationPower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
A logistics dashboard
The alert_
flag rate, temperature_ celsius by compliance_ status and a breakdown of location_ state. Excel, Power BI or Tableau. Why do the 51 compliant rows have a mean temperature_
celsius of 4.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs100LOG-0001-2024A5.3compliantLOG-0002-2024A8.6non-comp…LOG-0004-2024A7.9non-comp…
A software demo
Believable logs with shipment_
id, container_ id and sensor_ id to fill a screen in front of a buyer.
blueprint · cold-chain-pharmaceutical-temp-logs
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 22 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 shipment includes unique ID, origin, and destination.
- Temperature and humidity readings logged every hour during transit.
- Shipments flagged if temperature exceeds safe threshold for over 2 readings.
- Last-mile delivery routes reflect both urban and rural scenarios.
- Compliance status assigned based on threshold breaches.
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-pharmaceutical-temp-logs