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.
Sample rows
preview · 8 of 80 rows · all 33 columns| shipment_idstring | regulatory_compliance_statusstring | quantityfloat | incident_reportedboolean | origin_countrystring | shipment_datedate | origin_street_addressstring | origin_citystring | origin_statestring | origin_postal_codestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | product_typestring | product_descriptionstring | quantity_unitstring | vehicle_idstring | route_idstring | distance_kmfloat | planned_temperature_min_cfloat | planned_temperature_max_cfloat | actual_temperature_min_cfloat | actual_temperature_max_cfloat | temperature_excursion_countinteger | total_excursion_duration_minutesinteger | co2_emissions_kgfloat | energy_consumption_kwhfloat | compliance_standardstring | delivery_statusstring | delivery_datetimedatetime | incident_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHIP20240001 | compliant | 1200.5 | false | USA | 2024-02-11 | 1903 Market St | Philadelphia | PA | 19103 | 78 Rue de Lyon | Paris | blank | 75012 | France | food | Frozen seafood | kg | VEH-A-0011 | RTE-EU-003 | 6100.2 | -20 | -12 | -19.4 | -11.7 | 0 | blank | 210.6 | 530.2 | HACCP | delivered | 2024-02-14T16:18:00 | blank |
| SHIP20240002 | non-compliant | 15000 | true | Canada | 2024-01-29 | 99 King St | Toronto | ON | M5V1K4 | 350 Avenida Paulista | São Paulo | SP | 01310-000 | Brazil | pharma | Flu vaccine vials | units | VEH-B-0092 | RTE-SA-003 | 8300.7 | 2 | 8 | 1.8 | 8.5 | 1 | 43 | 380.2 | 800.7 | GDP | delivered | 2024-02-02T13:32:00 | Temperature excursion at customs |
| SHIP20240003 | compliant | 320.2 | false | Netherlands | 2024-03-03 | Maastrichterlaan 13 | Maastricht | blank | 6211EN | Carrer de Valencia 185 | Barcelona | blank | 08007 | Spain | food | Fresh berries | kg | VEH-EU-0018 | RTE-EU-008 | 1205.5 | 1.5 | 5 | 1.2 | 5.4 | 0 | blank | 58.7 | 110.1 | HACCP | delivered | 2024-03-04T10:21:00 | blank |
| SHIP20240004 | compliant | 6800 | false | UK | 2024-01-18 | 52 Main Street | Manchester | blank | M1 1AE | 10 Hafenstrasse | Hamburg | blank | 20457 | Germany | pharma | Insulin packs | units | VEH-EU-0021 | RTE-EU-007 | 1089.4 | 2 | 6 | 2.1 | 6.4 | 0 | blank | 63.2 | 120.3 | GDP | delivered | 2024-01-19T17:05:00 | blank |
| SHIP20240005 | non-compliant | 150.7 | true | Vietnam | 2024-02-23 | 22 Nguyen Hue | Ho Chi Minh City | blank | 70000 | 190 Orchard Rd | Singapore | blank | 238841 | Singapore | food | Chilled shrimp | kg | VEH-SEA-0014 | RTE-SEA-003 | 1204.3 | 0.5 | 4 | 0.3 | 4.2 | 1 | 15 | 39.5 | 74.6 | HACCP | delivered | 2024-02-24T09:50:00 | Temperature spike during unloading |
| SHIP20240006 | non-compliant | 820.9 | true | New Zealand | 2024-03-10 | 81 Queen St | Auckland | blank | 1010 | 25 Collins St | Melbourne | VIC | 3000 | Australia | food | Organic yoghurt | kg | VEH-AUS-0032 | RTE-AUS-001 | 2658.7 | 2 | 6 | 2.2 | 7.1 | 2 | 32 | 95.4 | 220.4 | HACCP | delayed | blank | Temperature exceeded during customs check |
| SHIP20240007 | compliant | 440 | false | Argentina | 2024-02-06 | Avenida 9 de Julio 101 | Buenos Aires | blank | C1043AAB | Rua Augusta 1120 | São Paulo | SP | 01304-001 | Brazil | pharma | Blood plasma | liters | VEH-SA-0007 | RTE-SA-001 | 2318.9 | -30 | -18 | -29.5 | -17.1 | 0 | blank | 72.9 | 250.3 | GDP | delivered | 2024-02-08T11:46:00 | blank |
| SHIP20240008 | pending | 78.7 | false | China | 2024-03-17 | 15 Fuxing Rd | Beijing | blank | 100038 | 100 Nathan Rd | Hong Kong | blank | 999077 | China | other | Temperature-sensitive reagents | kg | VEH-CN-0015 | RTE-CN-008 | 2008.2 | 10 | 25 | 11.8 | 27.1 | 1 | 11 | 52.7 | 66.8 | ISO-22000 | in-transit | blank | blank |
| SHIP20240009 | compliant | 230 | false | Poland | 2024-01-27 | Plac Bankowy 2 | Warsaw | blank | 00-950 | Ulica Florianska 5 | Kraków | blank | 31-019 | Poland | food | Chilled cheese | kg | VEH-PL-0003 | RTE-PL-002 | 295.5 | 2 | 6 | 2 | 6.1 | 0 | blank | 15.8 | 35.3 | HACCP | delivered | 2024-01-28T15:12:00 | blank |
| SHIP20240010 | compliant | 8900 | false | USA | 2024-03-21 | 50 Broadway | New York | NY | 10004 | 225 Queen St | Ottawa | ON | K1P5E4 | Canada | pharma | COVID-19 test kits | units | VEH-NA-0089 | RTE-NA-003 | 720.4 | 2 | 8 | 1.7 | 8.3 | 0 | blank | 45.8 | 98.2 | GDP | delivered | 2024-03-22T09:01:00 | blank |
| SHIP20240011 | compliant | 22.3 | false | Belgium | 2024-01-15 | Chaussee d'Ixelles 104 | Brussels | blank | 1050 | Avenue Louise 250 | Brussels | blank | 1050 | Belgium | other | Enzyme kits | kg | VEH-EU-0033 | RTE-EU-002 | 6.1 | 15 | 25 | 14.9 | 24.8 | 0 | blank | 0.8 | 3.2 | ISO-22000 | delivered | 2024-01-15T09:39:00 | blank |
| SHIP20240012 | compliant | 900 | false | Indonesia | 2024-03-07 | Jalan Sudirman 60 | Jakarta | blank | 10220 | Jalan Tun Razak 2 | Kuala Lumpur | blank | 50400 | Malaysia | food | Frozen chicken | kg | VEH-SEA-0028 | RTE-SEA-002 | 1432.8 | -18 | -10 | -17.6 | -9.8 | 0 | blank | 48.7 | 102.5 | HACCP | delivered | 2024-03-08T14:43:00 | blank |
| SHIP20240013 | compliant | 5600 | false | Brazil | 2024-02-19 | Rua da Consolação 222 | São Paulo | SP | 01302-000 | Av. Rio Branco 123 | Rio de Janeiro | RJ | 20040-003 | Brazil | pharma | IV saline bags | units | VEH-SA-0031 | RTE-SA-009 | 429.4 | 2 | 8 | 2.2 | 7.8 | 0 | blank | 12.6 | 29.1 | GDP | delivered | 2024-02-20T19:25:00 | blank |
| SHIP20240014 | compliant | 98.6 | false | Thailand | 2024-03-13 | Soi Sukhumvit 24 | Bangkok | blank | 10110 | Jalan Pudu 88 | Kuala Lumpur | blank | 55100 | Malaysia | food | Fresh mangoes | kg | VEH-SEA-0016 | RTE-SEA-004 | 1185.1 | 5 | 12 | 5.2 | 12.1 | 0 | blank | 28.3 | 54 | HACCP | delivered | 2024-03-14T07:14:00 | blank |
| SHIP20240015 | compliant | 40 | false | USA | 2024-02-12 | 28 Embarcadero | San Francisco | CA | 94111 | 1600 Amphitheatre Pkwy | Mountain View | CA | 94043 | USA | other | Clinical trial samples | kg | VEH-CA-0039 | RTE-CA-004 | 64.3 | -80 | -70 | -79.2 | -69.5 | 0 | blank | 3.1 | 14.8 | ISO-22000 | delivered | 2024-02-12T15:25:00 | blank |
| SHIP20240016 | pending | 120.5 | false | Italy | 2024-01-20 | Via Roma 12 | Milan | MI | 20121 | Calle de Alcalá 45 | Madrid | blank | 28014 | Spain | food | Chilled wine | liters | VEH-EU-0042 | RTE-EU-010 | 1512.8 | 10 | 15 | 10.2 | 15.6 | 1 | 8 | 43.5 | 62.5 | HACCP | in-transit | blank | blank |
| SHIP20240017 | compliant | 2900 | false | Ireland | 2024-03-12 | 21 Main St | Dublin | blank | D02F840 | 500 Oxford St | London | blank | W1C 2HW | UK | pharma | Monoclonal antibody vials | units | VEH-EU-0059 | RTE-EU-011 | 464.7 | 2 | 8 | 1.9 | 8.2 | 0 | blank | 8.6 | 24.1 | GDP | delivered | 2024-03-12T18:14:00 | blank |
| SHIP20240018 | non-compliant | 420 | true | USA | 2024-02-03 | 3012 Peachtree Rd | Atlanta | GA | 30305 | 1000 Wilshire Blvd | Los Angeles | CA | 90017 | USA | food | Chilled orange juice | liters | VEH-NA-0120 | RTE-NA-008 | 3477.6 | 2 | 6 | 2.1 | 7.3 | 1 | 13 | 142.9 | 310.7 | HACCP | delivered | 2024-02-05T09:58:00 | Temperature breach at unloading dock |
| SHIP20240019 | compliant | 3200 | false | Canada | 2024-01-26 | Rue Saint-Denis 33 | Montreal | QC | H2X3K1 | 5th Ave 200 | New York | NY | 10010 | USA | pharma | Rabies vaccine | units | VEH-NA-0046 | RTE-NA-002 | 610.9 | 2 | 8 | 2.3 | 8.1 | 0 | blank | 37.9 | 84.5 | GDP | delivered | 2024-01-27T13:23:00 | blank |
| SHIP20240020 | compliant | 205.5 | false | UAE | 2024-03-24 | UAH Road 6 | Abu Dhabi | blank | 00000 | Sheikh Zayed Rd 42 | Dubai | blank | 00000 | UAE | food | Chilled hummus | kg | VEH-UAE-0015 | RTE-UAE-001 | 140.3 | 4 | 10 | 4.3 | 10.6 | 0 | blank | 3.9 | 10.1 | HACCP | delivered | 2024-03-24T17:44:00 | blank |
What the 80 rows show
from the 80-row sampleNon-compliant (regulatory compliance status) stands out: 10 of its 10 rows have incident_
- 16%incident_
reported = true - 367.5median quantity
- 3product types
- 3quantity units
- 3delivery statuses
- 4compliance standards
Median 367.5, from 2.8 to 15,000.
- string 20
- integer 2
- float 8
- date 1
- datetime 1
- boolean 1
Columns
33 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
shipment_id | string | Unique identifier for each cold chain shipmentunique | SHIP20240001 |
origin_street_address | string | Street address of the shipment origin | 1903 Market St |
origin_city | string | City of the shipment origin | Philadelphia |
origin_state | string | State or province of the shipment originoptional | PA |
origin_postal_code | string | Postal code of the shipment originoptional | 19103 |
origin_country | string | Country of the shipment origin | USA |
destination_street_address | string | Street address of the shipment destination | 78 Rue de Lyon |
destination_city | string | City of the shipment destination | Paris |
destination_state | string | State or province of the shipment destinationoptional | SP |
destination_postal_code | string | Postal code of the shipment destinationoptional | 75012 |
destination_country | string | Country of the shipment destination | France |
product_type | string | Type of perishable goods being shipped (e.g., food, pharma)food · pharma · other | food |
product_description | string | Description of the shipped productoptional | Frozen seafood |
quantity_unit | string | Unit of measurement for the quantity (e.g., kg, liters, units)3 units | kg |
vehicle_id | string | Identifier for the vehicle used in the shipmentoptional | VEH-A-0011 |
route_id | string | Identifier for the route taken during shipmentoptional | RTE-EU-003 |
regulatory_compliance_status | string | Indicates whether the shipment met regulatory standardscompliant · non-compliant · pending | compliant |
compliance_standard | string | Name or code of the regulatory standard applied (e.g., GDP, HACCP)4 standards · optional | HACCP |
incident_description | string | Description of any incident reported during the shipmentoptional | Temperature excursion at … |
delivery_status | string | Final delivery status of the shipmentdelivered · in-transit · delayed · cancelled · returned | delivered |
| Numbers 10 columns | |||
quantity | float | Quantity of goods shipped (in specified units)0 or more | 1200.5 |
distance_km | float | Total distance covered by the shipment in kilometers0 or more | 6100.2 |
planned_temperature_min_c | float | Minimum planned temperature (in Celsius) for the shipment | -20 |
planned_temperature_max_c | float | Maximum planned temperature (in Celsius) for the shipment | -12 |
actual_temperature_min_c | float | Minimum actual temperature (in Celsius) recorded during shipmentoptional | -19.4 |
actual_temperature_max_c | float | Maximum actual temperature (in Celsius) recorded during shipmentoptional | -11.7 |
temperature_excursion_count | integer | Number of temperature excursions (deviations from planned range) during shipment0 or more | 0 |
total_excursion_duration_minutes | integer | Total duration (in minutes) of all temperature excursions0 or more · optional | 43 |
co2_emissions_kg | float | Estimated CO2 emissions (in kilograms) for the shipment0 or more | 210.6 |
energy_consumption_kwh | float | Total energy consumption (in kilowatt-hours) for temperature control during shipment0 or more · optional | 530.2 |
| Dates and times 2 columns | |||
shipment_date | date | Date when the shipment was dispatched | 2024-02-11 |
delivery_datetime | datetime | Date and time when the shipment was delivered (if applicable)optional | 2024-02-14T16:18:00 |
| True or false 1 column | |||
incident_reported | boolean | Indicates if any incident (e.g., temperature breach, delay) was reported during shipment | false |
Use it for
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.
- Shipments80SHIP202400011200.5compliantSHIP2024000215000non-comp…SHIP20240005150.7non-comp…
A software demo
Believable shipments with shipment_
date, origin_ street_ address and origin_ city to fill a screen in front of a buyer.
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.
- 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
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