Logistics
22 columns
100 rows
8 formats

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.

opened 13 times
last updated 29 Jan 2026
by GoMask

The brief that made it

Real-time monitoring and alerting for temperature-sensitive pharmaceutical shipments

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 sample

Compliant (compliance status) stands out: mean temperature_celsius is 4.7, against 7.0 for the rest.

49%alert_flag = true
6.0median temperature_celsius
20location countries
29location cities
54.5median humidity_percent
35median min_humidity_percent

Mean temperature_celsius by compliance_status100 rows

temperature_celsius100 rows, in bands of 2

Median 6.0, from -0.80 to 12.4.

location_state72 rows with a value · 28 left blank

CA8
NY4
ON4
IL4
Tokyo4
CDMX2
DL2
NSW2
WC2
MI2

22 columns by typefrom the column list below

string 12
float 8
datetime 1
boolean 1

Columns

22 columns in four groups

blueprint · 22 columns
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

Use 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.
Logs100
LOG-0001-2024A5.3compliant
LOG-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.

This dataset100 rows22 columns

Yours10,000 rows22 columnslocation_latitude: UK only

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.

Rules it was built with

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.

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: cold-chain-pharmaceutical-temp-logs

What should your data show?

No signup. No card.

Sample rows

What the 100 rows show

Columns

Use it for

A logistics dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Logistics

What should your data show?