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.
Sample rows
preview · 8 of 122 rows · all 28 columns| log_idstring | route_conditionsstring | fuel_consumed_litersfloat | delayedboolean | warehouse_countrystring | factory_idstring | factory_namestring | factory_street_addressstring | factory_citystring | factory_statestring | factory_postal_codestring | factory_countrystring | warehouse_idstring | warehouse_namestring | warehouse_street_addressstring | warehouse_citystring | warehouse_statestring | warehouse_postal_codestring | route_idstring | log_datedate | vehicle_idstring | vehicle_typestring | transit_time_minutesfloat | stop_countinteger | distance_kmfloat | fuel_efficiency_km_per_literfloat | co2_emissions_kgfloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| XTR-101-001 | normal | 0 | false | USA | FCTY-0001 | Eagle Manufacturing | 2101 North Main St | Dallas | TX | 75201 | USA | WH-2101 | North Dallas Distribution | 5420 Commerce Dr | Dallas | TX | 75235 | RT-DAL-DAL-01 | 2024-02-17 | TRK-1001 | electric-truck | 28.4 | 0 | 12.6 | blank | 4.2 | Tested new EV protocol |
| VAN-500-002 | congested | 0.8 | false | USA | FCTY-0002 | Green Valley Foods | 4530 Valley Rd | San Jose | CA | 95112 | USA | WH-5002 | San Jose Urban Hub | 390 Industrial Pkwy | San Jose | CA | 95131 | RT-SJO-SJO-02 | 2024-01-23 | VAN-2002 | van | 16.7 | 1 | 7.9 | 12.4 | 2.3 | Morning rush hour |
| TRK-203-003 | normal | 52.1 | false | USA | FCTY-0003 | Steelworks Ohio | 9800 Industrial Way | Cleveland | OH | 44135 | USA | WH-3201 | Detroit Regional Storage | 2100 River Rd | Detroit | MI | 48226 | RT-CLE-DET-01 | 2024-03-12 | TRK-3203 | truck | 440.2 | 2 | 370.6 | 7.1 | 142.5 | blank |
| HYT-401-004 | under construction | 15.7 | true | Canada | FCTY-0004 | Northern Plastics | 3021 Elm Ave | Toronto | ON | M4B1B3 | Canada | WH-1150 | Mississauga Distribution | 1100 Lakeshore Blvd | Mississauga | ON | L5B2C1 | RT-TOR-MSA-01 | 2024-02-08 | HYB-4004 | hybrid-truck | 120.9 | 3 | 98.2 | 13.8 | 32.9 | Detour for roadworks |
| TRK-504-005 | congested | 67.2 | true | Germany | FCTY-0005 | Blue Lake Chemicals | 1122 Lakeside Blvd | Hamburg | HH | 20099 | Germany | WH-3033 | Berlin Industrial Park | 890 Alexanderstrasse | Berlin | BE | 10178 | RT-HAM-BER-01 | 2024-01-14 | TRK-5005 | truck | 498.6 | 3 | 288.4 | 4.3 | 208.5 | Heavy traffic near Berlin |
| TRK-601-006 | normal | 82.5 | false | USA | FCTY-0006 | Sunny Valley Textiles | 4001 Sunny St | Phoenix | AZ | 85032 | USA | WH-6021 | Albuquerque Main Hub | 4120 Central Ave | Albuquerque | NM | 87106 | RT-PHX-ABQ-01 | 2024-03-05 | TRK-6006 | truck | 370.5 | 2 | 542.1 | 6.6 | 264.8 | blank |
| EVT-701-007 | normal | 0 | false | USA | FCTY-0007 | Pinecrest Assembly | 7810 Pinecrest Dr | Atlanta | GA | 30328 | USA | WH-7001 | Atlanta Metro Logistics | 5600 Peachtree Blvd | Atlanta | GA | 30341 | RT-ATL-ATL-01 | 2024-03-15 | ELC-7007 | electric-truck | 21.2 | 1 | 9.6 | blank | 2.9 | EV performance excellent |
| VAN-802-008 | normal | 1.1 | false | Sweden | FCTY-0008 | Baltic Electronics | 153 Baltic Ave | Stockholm | AB | 11423 | Sweden | WH-8021 | Stockholm Central Storage | 920 Drottninggatan | Stockholm | AB | 11151 | RT-STO-STO-01 | 2024-02-22 | VAN-8008 | van | 18.9 | 0 | 6.2 | 13.7 | 2.8 | blank |
| TRK-903-009 | weather delay | 183.9 | true | USA | FCTY-0009 | Rio Grande Paperworks | 1200 Rio Grande Blvd | Monterrey | NL | 64000 | Mexico | WH-9011 | San Antonio TX Logistics | 1010 Commerce St | San Antonio | TX | 78205 | RT-MTY-SAT-01 | 2024-03-02 | TRK-9009 | truck | 812.7 | 4 | 1115.2 | 6.1 | 401.7 | Border crossing delays, heavy rain |
| HYT-010-010 | normal | 27.2 | false | USA | FCTY-0010 | Central Machine Works | 4010 Central St | Chicago | IL | 60616 | USA | WH-0110 | St Louis Midwest Hub | 2100 Olive St | St Louis | MO | 63103 | RT-CHI-STL-01 | 2024-01-29 | HYB-0010 | hybrid-truck | 390.1 | 2 | 457.8 | 16.8 | 41.5 | Testing new hybrid model |
| TRK-111-011 | normal | 32.8 | false | USA | FCTY-0011 | Western Steel Corp | 299 Main St | Seattle | WA | 98134 | USA | WH-1112 | Portland Storage | 1000 NE Columbia Blvd | Portland | OR | 97217 | RT-SEA-PDX-01 | 2024-02-11 | TRK-1111 | truck | 195.2 | 1 | 278.9 | 8.5 | 98.7 | blank |
| VAN-120-012 | normal | 1.2 | false | USA | FCTY-0012 | Eastbrook Dairy | 800 Eastbrook Rd | Buffalo | NY | 14206 | USA | WH-1203 | Rochester Urban Store | 2100 Main St | Rochester | NY | 14615 | RT-BUF-ROC-01 | 2024-03-01 | VAN-1202 | van | 49.5 | 1 | 22.7 | 14.5 | 3.1 | blank |
| TRK-131-013 | normal | 97.8 | false | USA | FCTY-0013 | Pacific Rubber | 301 Pacific Ave | Los Angeles | CA | 90021 | USA | WH-1313 | Phoenix Distribution | 7300 S 51st Ave | Phoenix | AZ | 85043 | RT-LAX-PHX-01 | 2024-02-19 | TRK-1313 | truck | 325.6 | 2 | 595.2 | 6.1 | 328.9 | blank |
| HYT-142-014 | weather delay | 156.2 | true | Denmark | FCTY-0014 | Northern Timber | 4302 Forest Ln | Stockholm | AB | 11521 | Sweden | WH-1422 | Copenhagen Central | 800 Norrebrogade | Copenhagen | DK | 2200 | RT-STO-CPH-01 | 2024-03-22 | HYB-1424 | hybrid-truck | 812.3 | 5 | 1030.2 | 6.6 | 505.8 | Winter storm on Öresund Bridge |
| EVT-150-015 | normal | 0 | false | USA | FCTY-0001 | Eagle Manufacturing | 2101 North Main St | Dallas | TX | 75201 | USA | WH-1501 | Austin Micro Storage | 5101 N Interstate 35 | Austin | TX | 78723 | RT-DAL-AUS-01 | 2024-01-06 | ELC-1501 | electric-truck | 46.2 | 1 | 22.1 | blank | 6.1 | blank |
| OTH-161-016 | other | blank | true | USA | FCTY-0015 | Lakeside Foundry | 6200 Lakeside Dr | Minneapolis | MN | 55401 | USA | WH-1611 | Chicago Midwest Storage | 1234 W Randolph St | Chicago | IL | 60607 | RT-MIN-CHI-01 | 2024-03-21 | OTH-1616 | other | 0 | 0 | 0 | blank | 0 | Route canceled due to vehicle breakdown |
| TRK-172-017 | normal | 152.2 | false | USA | FCTY-0016 | Valley Auto Parts | 800 Valley Pkwy | Denver | CO | 80216 | USA | WH-1723 | Salt Lake City Hub | 4000 W 2100 S | Salt Lake City | UT | 84120 | RT-DEN-SLC-01 | 2024-02-27 | TRK-1727 | truck | 496.7 | 3 | 821.4 | 5.4 | 498.7 | blank |
| EVT-188-018 | normal | 0 | false | Canada | FCTY-0017 | Northern Plastics | 3021 Elm Ave | Toronto | ON | M4B1B3 | Canada | WH-1885 | Toronto Urban Storage | 180 King St | Toronto | ON | M5V1E9 | RT-TOR-TOR-02 | 2024-01-11 | ELC-1881 | electric-truck | 32.4 | 1 | 15.7 | blank | 3.9 | blank |
| VAN-195-019 | normal | 1.3 | false | USA | FCTY-0018 | Green Valley Foods | 4530 Valley Rd | San Jose | CA | 95112 | USA | WH-1951 | Oakland Distribution | 2107 Broadway | Oakland | CA | 94612 | RT-SJO-OAK-01 | 2024-02-24 | VAN-1951 | van | 41.7 | 1 | 24.5 | 18.9 | 4.6 | blank |
| TRK-202-020 | under construction | 112.7 | true | Germany | FCTY-0019 | Blue Lake Chemicals | 1122 Lakeside Blvd | Hamburg | HH | 20099 | Germany | WH-2021 | Munich Central Park | 820 Rosenheimerstrasse | Munich | BY | 80331 | RT-HAM-MUC-01 | 2024-01-09 | TRK-2021 | truck | 364.5 | 2 | 613.2 | 5.4 | 305.2 | Construction on A9 Autobahn |
What the 122 rows show
from the 122-row sampleWeather delay (route conditions) stands out: mean fuel_
- 28%delayed = true
- 33.4median fuel_
consumed_ liters - 5vehicle types
- 27factory countries
- 217.1median transit_
time_ minutes - 1.5median stop_
count
Median 33.4, from 0.0 to 258.2.
- string 20
- integer 1
- float 5
- date 1
- boolean 1
Columns
28 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
log_id | string | Unique identifier for each route efficiency log entryunique | XTR-101-001 |
factory_id | string | Unique identifier for the factory origin | FCTY-0001 |
factory_name | string | Name of the factory | Eagle Manufacturing |
factory_street_address | string | Street address of the factory | 2101 North Main St |
factory_city | string | City where the factory is located | Dallas |
factory_state | string | State or province of the factory | TX |
factory_postal_code | string | Postal code of the factory | 75201 |
factory_country | string | Country where the factory is located | USA |
warehouse_id | string | Unique identifier for the warehouse destination | WH-2101 |
warehouse_name | string | Name of the warehouse | San Jose Urban Hub |
warehouse_street_address | string | Street address of the warehouse | 5420 Commerce Dr |
warehouse_city | string | City where the warehouse is located | Dallas |
warehouse_state | string | State or province of the warehouse | TX |
warehouse_postal_code | string | Postal code of the warehouse | 75235 |
warehouse_country | string | Country where the warehouse is located | USA |
route_id | string | Unique identifier for the factory-to-warehouse route | RT-DAL-DAL-01 |
vehicle_id | string | Unique identifier for the vehicle used | TRK-1001 |
vehicle_type | string | Type of vehicle used for transportation (e.g., truck, van, electric-truck)truck · van · electric-truck · hybrid-truck · other | electric-truck |
route_conditions | string | Description of route conditions (e.g., normal, congested, under construction)5 values · optional | normal |
notes | string | Additional notes or observations about the routeoptional | Tested new EV protocol |
| Numbers 6 columns | |||
transit_time_minutes | float | Total transit time from factory to warehouse in minutes0 or more | 28.4 |
stop_count | integer | Number of stops made during the route0 or more | 0 |
distance_km | float | Total distance covered during the route in kilometers0 or more | 12.6 |
fuel_consumed_liters | float | Total fuel consumed during the route in liters0 or more · optional | 0 |
fuel_efficiency_km_per_liter | float | Fuel efficiency for the route in kilometers per liter0 or more · optional | 12.4 |
co2_emissions_kg | float | Estimated CO2 emissions for the route in kilograms0 or more · optional | 4.2 |
| Dates and times 1 column | |||
log_date | date | Date when the route efficiency log was recorded | 2024-02-17 |
| True or false 1 column | |||
delayed | boolean | Indicates if the route experienced a significant delayoptional | false |
Use it for
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.
- Logs122XTR-101-0010normalHYT-401-00415.7under co…TRK-504-00567.2congested
A software demo
Believable logs with factory_
id, factory_ name and factory_ street_ address to fill a screen in front of a buyer.
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.
- 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.).
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