Cold Chain Sustainability Metrics

This dataset provides detailed, shipment-level metrics for perishable food and pharmaceutical cold chain logistics, including temperature control, carbon emissions, energy consumption, and regulatory compliance. It enables comprehensive monitoring and optimization of eco-efficiency, route planning, and adherence to industry standards, supporting sustainability and risk management in supply chains.

  • last updated 22 Jan 2026
  • by GoMask
The brief that made it

Optimize cold chain routes for reduced carbon footprint and energy use

Sample rows

preview · 8 of 80 rows · all 33 columns
shipment_idstringregulatory_compliance_statusstringquantityfloatincident_reportedbooleanorigin_countrystringshipment_datedateorigin_street_addressstringorigin_citystringorigin_statestringorigin_postal_codestringdestination_street_addressstringdestination_citystringdestination_statestringdestination_postal_codestringdestination_countrystringproduct_typestringproduct_descriptionstringquantity_unitstringvehicle_idstringroute_idstringdistance_kmfloatplanned_temperature_min_cfloatplanned_temperature_max_cfloatactual_temperature_min_cfloatactual_temperature_max_cfloattemperature_excursion_countintegertotal_excursion_duration_minutesintegerco2_emissions_kgfloatenergy_consumption_kwhfloatcompliance_standardstringdelivery_statusstringdelivery_datetimedatetimeincident_descriptionstring
SHIP20240001compliant1200.5falseUSA2024-02-111903 Market StPhiladelphiaPA1910378 Rue de LyonParisblank75012FrancefoodFrozen seafoodkgVEH-A-0011RTE-EU-0036100.2-20-12-19.4-11.70blank210.6530.2HACCPdelivered2024-02-14T16:18:00blank
SHIP20240002non-compliant15000trueCanada2024-01-2999 King StTorontoONM5V1K4350 Avenida PaulistaSão PauloSP01310-000BrazilpharmaFlu vaccine vialsunitsVEH-B-0092RTE-SA-0038300.7281.88.5143380.2800.7GDPdelivered2024-02-02T13:32:00Temperature excursion at customs
SHIP20240003compliant320.2falseNetherlands2024-03-03Maastrichterlaan 13Maastrichtblank6211ENCarrer de Valencia 185Barcelonablank08007SpainfoodFresh berrieskgVEH-EU-0018RTE-EU-0081205.51.551.25.40blank58.7110.1HACCPdelivered2024-03-04T10:21:00blank
SHIP20240004compliant6800falseUK2024-01-1852 Main StreetManchesterblankM1 1AE10 HafenstrasseHamburgblank20457GermanypharmaInsulin packsunitsVEH-EU-0021RTE-EU-0071089.4262.16.40blank63.2120.3GDPdelivered2024-01-19T17:05:00blank
SHIP20240005non-compliant150.7trueVietnam2024-02-2322 Nguyen HueHo Chi Minh Cityblank70000190 Orchard RdSingaporeblank238841SingaporefoodChilled shrimpkgVEH-SEA-0014RTE-SEA-0031204.30.540.34.211539.574.6HACCPdelivered2024-02-24T09:50:00Temperature spike during unloading
SHIP20240006non-compliant820.9trueNew Zealand2024-03-1081 Queen StAucklandblank101025 Collins StMelbourneVIC3000AustraliafoodOrganic yoghurtkgVEH-AUS-0032RTE-AUS-0012658.7262.27.123295.4220.4HACCPdelayedblankTemperature exceeded during customs check
SHIP20240007compliant440falseArgentina2024-02-06Avenida 9 de Julio 101Buenos AiresblankC1043AABRua Augusta 1120São PauloSP01304-001BrazilpharmaBlood plasmalitersVEH-SA-0007RTE-SA-0012318.9-30-18-29.5-17.10blank72.9250.3GDPdelivered2024-02-08T11:46:00blank
SHIP20240008pending78.7falseChina2024-03-1715 Fuxing RdBeijingblank100038100 Nathan RdHong Kongblank999077ChinaotherTemperature-sensitive reagentskgVEH-CN-0015RTE-CN-0082008.2102511.827.111152.766.8ISO-22000in-transitblankblank

What the 80 rows show

from the 80-row sample

Non-compliant (regulatory compliance status) stands out: 10 of its 10 rows have incident_reported = true, against 3 of 70 for the rest.

  • 16%incident_reported = true
  • 367.5median quantity
  • 3product types
  • 3quantity units
  • 3delivery statuses
  • 4compliance standards
Incident reported rate by regulatory_compliance_statusincident_reported = true
0%50%100%0%compliant0 of 64100%non-compliant10 of 1050%pending3 of 6
quantity80 rows, in bands of 2,000
0357066523111108,00016kquantity →

Median 367.5, from 2.8 to 15,000.

origin_country80 rows · top 10 of 29 values
  1. USA12
  2. France10
  3. UK7
  4. Canada5
  5. Ireland4
  6. New Zealand3
  7. China3
  8. Brazil3
  9. Italy3
  10. Malaysia3
33 columns by typefrom the column list below
  • string 20
  • integer 2
  • float 8
  • date 1
  • datetime 1
  • boolean 1

Columns

33 columns in four groups
blueprint · 33 columns
columntypedescriptionexample
Text 20 columns
shipment_idstringUnique identifier for each cold chain shipmentuniqueSHIP20240001
origin_street_addressstringStreet address of the shipment origin1903 Market St
origin_citystringCity of the shipment originPhiladelphia
origin_statestringState or province of the shipment originoptionalPA
origin_postal_codestringPostal code of the shipment originoptional19103
origin_countrystringCountry of the shipment originUSA
destination_street_addressstringStreet address of the shipment destination78 Rue de Lyon
destination_citystringCity of the shipment destinationParis
destination_statestringState or province of the shipment destinationoptionalSP
destination_postal_codestringPostal code of the shipment destinationoptional75012
destination_countrystringCountry of the shipment destinationFrance
product_typestringType of perishable goods being shipped (e.g., food, pharma)food · pharma · otherfood
product_descriptionstringDescription of the shipped productoptionalFrozen seafood
quantity_unitstringUnit of measurement for the quantity (e.g., kg, liters, units)3 unitskg
vehicle_idstringIdentifier for the vehicle used in the shipmentoptionalVEH-A-0011
route_idstringIdentifier for the route taken during shipmentoptionalRTE-EU-003
regulatory_compliance_statusstringIndicates whether the shipment met regulatory standardscompliant · non-compliant · pendingcompliant
compliance_standardstringName or code of the regulatory standard applied (e.g., GDP, HACCP)4 standards · optionalHACCP
incident_descriptionstringDescription of any incident reported during the shipmentoptionalTemperature excursion at …
delivery_statusstringFinal delivery status of the shipmentdelivered · in-transit · delayed · cancelled · returneddelivered
Numbers 10 columns
quantityfloatQuantity of goods shipped (in specified units)0 or more1200.5
distance_kmfloatTotal distance covered by the shipment in kilometers0 or more6100.2
planned_temperature_min_cfloatMinimum planned temperature (in Celsius) for the shipment-20
planned_temperature_max_cfloatMaximum planned temperature (in Celsius) for the shipment-12
actual_temperature_min_cfloatMinimum actual temperature (in Celsius) recorded during shipmentoptional-19.4
actual_temperature_max_cfloatMaximum actual temperature (in Celsius) recorded during shipmentoptional-11.7
temperature_excursion_countintegerNumber of temperature excursions (deviations from planned range) during shipment0 or more0
total_excursion_duration_minutesintegerTotal duration (in minutes) of all temperature excursions0 or more · optional43
co2_emissions_kgfloatEstimated CO2 emissions (in kilograms) for the shipment0 or more210.6
energy_consumption_kwhfloatTotal energy consumption (in kilowatt-hours) for temperature control during shipment0 or more · optional530.2
Dates and times 2 columns
shipment_datedateDate when the shipment was dispatched2024-02-11
delivery_datetimedatetimeDate and time when the shipment was delivered (if applicable)optional2024-02-14T16:18:00
True or false 1 column
incident_reportedbooleanIndicates if any incident (e.g., temperature breach, delay) was reported during shipmentfalse

Use it for

  • incident repor…16%13 of 80 rowsmean quantity by regu…1.3kcompli…3.4knon-co…339.3pending

    A logistics dashboard

    The incident_reported rate, quantity by regulatory_compliance_status and a breakdown of origin_country. Excel, Power BI or Tableau.

  • Why do 13 of 80 rows have incident_reported = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable shipments with shipment_date, origin_street_address and origin_city to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 33 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset80 rows33 columns
Yours1,000 rows33 columnsorigin_street_address: UK only

blueprint · cold-chain-sustainability-metrics

Behind this dataset

Same schema. As many rows as you need.

These 80 rows came out of a blueprint — 33 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 row represents a distinct shipment batch
  • Include temperature data at key checkpoints
  • Calculate estimated CO2 emissions per shipment
  • Flag deviations from temperature or emissions thresholds
  • Assign sustainability score based on overall performance
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-sustainability-metrics

What should your data show?

Preview 20 rows free
No signup. No card.