Factory-to-Warehouse Route Efficiency Logs

This dataset logs detailed operational metrics for factory-to-warehouse transportation routes, including transit times, vehicle types, stop counts, fuel efficiency, and sustainability indicators. It is designed to help logistics managers and analysts optimize supply chain performance, monitor environmental impact, and improve route planning for non-retail manufacturing and distribution networks.

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

Route optimization and efficiency analysis

Sample rows

preview · 8 of 122 rows · all 28 columns
log_idstringroute_conditionsstringfuel_consumed_litersfloatdelayedbooleanwarehouse_countrystringfactory_idstringfactory_namestringfactory_street_addressstringfactory_citystringfactory_statestringfactory_postal_codestringfactory_countrystringwarehouse_idstringwarehouse_namestringwarehouse_street_addressstringwarehouse_citystringwarehouse_statestringwarehouse_postal_codestringroute_idstringlog_datedatevehicle_idstringvehicle_typestringtransit_time_minutesfloatstop_countintegerdistance_kmfloatfuel_efficiency_km_per_literfloatco2_emissions_kgfloatnotesstring
XTR-101-001normal0falseUSAFCTY-0001Eagle Manufacturing2101 North Main StDallasTX75201USAWH-2101North Dallas Distribution5420 Commerce DrDallasTX75235RT-DAL-DAL-012024-02-17TRK-1001electric-truck28.4012.6blank4.2Tested new EV protocol
VAN-500-002congested0.8falseUSAFCTY-0002Green Valley Foods4530 Valley RdSan JoseCA95112USAWH-5002San Jose Urban Hub390 Industrial PkwySan JoseCA95131RT-SJO-SJO-022024-01-23VAN-2002van16.717.912.42.3Morning rush hour
TRK-203-003normal52.1falseUSAFCTY-0003Steelworks Ohio9800 Industrial WayClevelandOH44135USAWH-3201Detroit Regional Storage2100 River RdDetroitMI48226RT-CLE-DET-012024-03-12TRK-3203truck440.22370.67.1142.5blank
HYT-401-004under construction15.7trueCanadaFCTY-0004Northern Plastics3021 Elm AveTorontoONM4B1B3CanadaWH-1150Mississauga Distribution1100 Lakeshore BlvdMississaugaONL5B2C1RT-TOR-MSA-012024-02-08HYB-4004hybrid-truck120.9398.213.832.9Detour for roadworks
TRK-504-005congested67.2trueGermanyFCTY-0005Blue Lake Chemicals1122 Lakeside BlvdHamburgHH20099GermanyWH-3033Berlin Industrial Park890 AlexanderstrasseBerlinBE10178RT-HAM-BER-012024-01-14TRK-5005truck498.63288.44.3208.5Heavy traffic near Berlin
TRK-601-006normal82.5falseUSAFCTY-0006Sunny Valley Textiles4001 Sunny StPhoenixAZ85032USAWH-6021Albuquerque Main Hub4120 Central AveAlbuquerqueNM87106RT-PHX-ABQ-012024-03-05TRK-6006truck370.52542.16.6264.8blank
EVT-701-007normal0falseUSAFCTY-0007Pinecrest Assembly7810 Pinecrest DrAtlantaGA30328USAWH-7001Atlanta Metro Logistics5600 Peachtree BlvdAtlantaGA30341RT-ATL-ATL-012024-03-15ELC-7007electric-truck21.219.6blank2.9EV performance excellent
VAN-802-008normal1.1falseSwedenFCTY-0008Baltic Electronics153 Baltic AveStockholmAB11423SwedenWH-8021Stockholm Central Storage920 DrottninggatanStockholmAB11151RT-STO-STO-012024-02-22VAN-8008van18.906.213.72.8blank

What the 122 rows show

from the 122-row sample

Weather delay (route conditions) stands out: mean fuel_consumed_liters is 199.7, against 44.2 for the rest.

  • 28%delayed = true
  • 33.4median fuel_consumed_liters
  • 5vehicle types
  • 27factory countries
  • 217.1median transit_time_minutes
  • 1.5median stop_count
Mean fuel_consumed_liters by route_conditions118 rows
020040035.1normal83 rows28.8conges…11 rows56.4under …4 rows199.7weathe…15 rows220.6other5 rows
fuel_consumed_liters118 rows, in bands of 50
04080721967950150300fuel_consumed_liters →

Median 33.4, from 0.0 to 258.2.

warehouse_country122 rows · top 10 of 28 values
  1. USA57
  2. Germany10
  3. Canada5
  4. China5
  5. UK5
  6. Brazil4
  7. Sweden3
  8. Finland3
  9. Spain3
  10. Australia3
28 columns by typefrom the column list below
  • string 20
  • integer 1
  • float 5
  • date 1
  • boolean 1

Columns

28 columns in four groups
blueprint · 28 columns
columntypedescriptionexample
Text 20 columns
log_idstringUnique identifier for each route efficiency log entryuniqueXTR-101-001
factory_idstringUnique identifier for the factory originFCTY-0001
factory_namestringName of the factoryEagle Manufacturing
factory_street_addressstringStreet address of the factory2101 North Main St
factory_citystringCity where the factory is locatedDallas
factory_statestringState or province of the factoryTX
factory_postal_codestringPostal code of the factory75201
factory_countrystringCountry where the factory is locatedUSA
warehouse_idstringUnique identifier for the warehouse destinationWH-2101
warehouse_namestringName of the warehouseSan Jose Urban Hub
warehouse_street_addressstringStreet address of the warehouse5420 Commerce Dr
warehouse_citystringCity where the warehouse is locatedDallas
warehouse_statestringState or province of the warehouseTX
warehouse_postal_codestringPostal code of the warehouse75235
warehouse_countrystringCountry where the warehouse is locatedUSA
route_idstringUnique identifier for the factory-to-warehouse routeRT-DAL-DAL-01
vehicle_idstringUnique identifier for the vehicle usedTRK-1001
vehicle_typestringType of vehicle used for transportation (e.g., truck, van, electric-truck)truck · van · electric-truck · hybrid-truck · otherelectric-truck
route_conditionsstringDescription of route conditions (e.g., normal, congested, under construction)5 values · optionalnormal
notesstringAdditional notes or observations about the routeoptionalTested new EV protocol
Numbers 6 columns
transit_time_minutesfloatTotal transit time from factory to warehouse in minutes0 or more28.4
stop_countintegerNumber of stops made during the route0 or more0
distance_kmfloatTotal distance covered during the route in kilometers0 or more12.6
fuel_consumed_litersfloatTotal fuel consumed during the route in liters0 or more · optional0
fuel_efficiency_km_per_literfloatFuel efficiency for the route in kilometers per liter0 or more · optional12.4
co2_emissions_kgfloatEstimated CO2 emissions for the route in kilograms0 or more · optional4.2
Dates and times 1 column
log_datedateDate when the route efficiency log was recorded2024-02-17
True or false 1 column
delayedbooleanIndicates if the route experienced a significant delayoptionalfalse

Use it for

  • delayed28%34 of 122 rowsmean fuel consumed li…35.1norm…28.8cong…56.4unde…199.7weat…

    A logistics dashboard

    The delayed rate, fuel_consumed_liters by route_conditions and a breakdown of warehouse_country. Excel, Power BI or Tableau.

  • Why do the 15 weather delay rows have a mean fuel_consumed_liters of 199.7?

    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 logs with factory_id, factory_name and factory_street_address to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 28 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 dataset122 rows28 columns
Yours1,000 rows28 columnsfactory_street_address: UK only

blueprint · factory-to-warehouse-route-efficiency-logs

Behind this dataset

Same schema. As many rows as you need.

These 122 rows came out of a blueprint — 28 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 record represents a single trip from factory to warehouse.
  • Transit time is recorded in minutes, with mandatory GPS start and end timestamps.
  • Vehicle type and load weight (kg) must be specified for every trip.
  • Log must include calculated fuel consumption (L/100km) and any route deviations.
  • Any trip with a delay over 30 minutes must specify cause (traffic, breakdown, etc.).
Rows
Open the blueprint in Data Factory

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
factory-to-warehouse-route-efficiency-logs

What should your data show?

Preview 20 rows free
No signup. No card.