Logistics Delivery ETA Prediction
This dataset provides comprehensive delivery records for logistics operations, including historical and real-time data on delivery routes, timing, vehicle and package details, and contextual factors such as traffic and weather. It enables accurate ETA prediction, performance analysis, and operational optimization for logistics providers and customers.
Sample rows
preview · 8 of 200 rows · all 30 columns| delivery_idstring | traffic_conditionstring | distance_kmfloat | origin_countrystring | order_idstring | customer_idstring | pickup_datetimedatetime | scheduled_delivery_datetimedatetime | actual_delivery_datetimedatetime | predicted_eta_datetimedatetime | origin_street_addressstring | origin_citystring | origin_statestring | origin_postal_codestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | vehicle_typestring | carrier_idstring | driver_idstring | package_weight_kgfloat | package_volume_m3float | weather_conditionstring | delivery_statusstring | delivery_prioritystring | created_atdatetime | updated_atdatetime | delay_reasonstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DLV-000001 | normal | 6.7 | United States | ORD-0000001 | CUST-001 | 2024-06-03T08:13:00Z | 2024-06-03T14:15:00Z | 2024-06-03T14:24:00Z | 2024-06-03T14:18:00Z | 112 Main St | New York | NY | 10001 | 275 Park Ave | Brooklyn | NY | 11205 | United States | van | CAR-0012 | DRV-0012 | 4.9 | 0.08 | clear | delivered | express | 2024-06-03T07:44:00Z | 2024-06-03T14:24:00Z | blank |
| DLV-000002 | normal | 12.3 | Canada | ORD-0000002 | CUST-002 | 2024-06-02T11:09:00Z | 2024-06-02T17:23:00Z | blank | 2024-06-02T17:17:00Z | 57 Granville Rd | Richmond | BC | V7C1E2 | 340 Robson St | Vancouver | BC | V6B2B6 | Canada | car | CAR-0123 | DRV-0123 | 8.2 | 0.16 | rain | in_transit | standard | 2024-06-02T10:57:00Z | 2024-06-02T16:59:00Z | blank |
| DLV-000003 | heavy | 9.1 | United Kingdom | ORD-0000003 | CUST-003 | 2024-05-26T09:54:00Z | 2024-05-26T17:20:00Z | 2024-05-26T18:05:00Z | 2024-05-26T17:40:00Z | 14 Oxford St | London | ENG | W1D1BS | 209 Baker St | London | ENG | NW13AU | United Kingdom | bike | CAR-0022 | DRV-0022 | 1.6 | 0.03 | rain | delivered | same_day | 2024-05-26T09:23:00Z | 2024-05-26T18:05:00Z | Severe traffic congestion due to roadworks in city center. |
| DLV-000004 | heavy | 21.5 | United States | ORD-0000004 | CUST-004 | 2024-06-04T07:35:00Z | 2024-06-04T13:20:00Z | blank | 2024-06-04T13:08:00Z | 101 Sunset Blvd | Los Angeles | CA | 90028 | 233 N Victory Blvd | Burbank | CA | 91502 | United States | truck | CAR-0088 | DRV-0088 | 35.7 | 0.74 | clear | pending | standard | 2024-06-04T07:04:00Z | 2024-06-04T09:18:00Z | blank |
| DLV-000005 | normal | 9.6 | Australia | ORD-0000005 | CUST-005 | 2024-05-29T10:26:00Z | 2024-05-29T20:31:00Z | blank | 2024-05-29T20:45:00Z | 82 George St | Sydney | NSW | 2000 | 17 Pacific Hwy | Chatswood | NSW | 2067 | Australia | car | CAR-0056 | DRV-0056 | 3.1 | 0.09 | clear | in_transit | express | 2024-05-29T09:59:00Z | 2024-05-29T11:21:00Z | blank |
| DLV-000006 | normal | 23.2 | Canada | ORD-0000006 | CUST-006 | 2024-06-01T06:09:00Z | 2024-06-01T10:23:00Z | 2024-06-01T10:46:00Z | 2024-06-01T10:30:00Z | 97 Bay St | Toronto | ON | M5J2R8 | 15 Finch Ave W | North York | ON | M2N7J6 | Canada | van | CAR-0039 | DRV-0039 | 17.2 | 0.23 | fog | delivered | standard | 2024-06-01T05:37:00Z | 2024-06-01T10:46:00Z | blank |
| DLV-000007 | normal | 4.2 | France | ORD-0000007 | CUST-007 | 2024-05-30T13:15:00Z | 2024-05-30T16:35:00Z | 2024-05-30T17:10:00Z | 2024-05-30T16:50:00Z | 39 Rue de Rivoli | Paris | IDF | 75004 | 20 Rue de Lyon | Paris | IDF | 75012 | France | bike | CAR-0046 | DRV-0046 | 0.7 | 0.01 | rain | delivered | same_day | 2024-05-30T12:54:00Z | 2024-05-30T17:10:00Z | blank |
| DLV-000008 | normal | 8.4 | Germany | ORD-0000008 | CUST-008 | 2024-05-31T08:03:00Z | 2024-05-31T15:47:00Z | blank | 2024-05-31T15:15:00Z | 28 Friedrichstr | Berlin | BE | 10117 | 65 Kantstr | Berlin | BE | 10625 | Germany | car | CAR-0017 | DRV-0017 | 2.8 | 0.07 | clear | pending | express | 2024-05-31T07:35:00Z | 2024-05-31T09:10:00Z | blank |
| DLV-000009 | heavy | 54.2 | United States | ORD-0000009 | CUST-009 | 2024-06-01T12:18:00Z | 2024-06-01T17:21:00Z | 2024-06-01T17:29:00Z | 2024-06-01T17:25:00Z | 85 Market St | San Francisco | CA | 94103 | 402 Castro St | Mountain View | CA | 94041 | United States | truck | CAR-0103 | DRV-0103 | 41.1 | 1.39 | clear | delivered | standard | 2024-06-01T11:55:00Z | 2024-06-01T17:29:00Z | blank |
| DLV-000010 | normal | 5.7 | New Zealand | ORD-0000010 | CUST-010 | 2024-05-28T07:23:00Z | 2024-05-28T13:34:00Z | 2024-05-28T14:05:00Z | 2024-05-28T13:50:00Z | 21 Queen St | Auckland | AUK | 1010 | 14 Parnell Rd | Auckland | AUK | 1052 | New Zealand | van | CAR-0145 | DRV-0145 | 5.3 | 0.12 | rain | delivered | express | 2024-05-28T07:00:00Z | 2024-05-28T14:05:00Z | Heavy rainfall caused minor delays on local roads. |
| DLV-000011 | unknown | 372.4 | Norway | ORD-0000011 | CUST-011 | 2024-05-27T09:25:00Z | 2024-05-27T18:15:00Z | blank | 2024-05-27T18:10:00Z | 1 Arctic Base Rd | Longyearbyen | SVAL | 9170 | 200 Polar Research Ave | Ny-Ålesund | SVAL | 9171 | Norway | other | CAR-0175 | blank | 0.17 | blank | snow | pending | standard | 2024-05-27T09:11:00Z | 2024-05-27T10:03:00Z | blank |
| DLV-000012 | normal | 6.2 | Italy | ORD-0000012 | CUST-012 | 2024-05-30T07:10:00Z | 2024-05-30T13:32:00Z | 2024-05-30T13:55:00Z | 2024-05-30T13:40:00Z | 29 Via Appia | Rome | RM | 00179 | 10 Piazza del Popolo | Rome | RM | 00187 | Italy | van | CAR-0026 | DRV-0026 | 3.8 | 0.05 | clear | delivered | same_day | 2024-05-30T06:41:00Z | 2024-05-30T13:55:00Z | blank |
| DLV-000013 | closed | 188.9 | Brazil | ORD-0000013 | CUST-013 | 2024-05-28T10:12:00Z | 2024-05-28T18:14:00Z | blank | 2024-05-28T18:17:00Z | 6 Amazonia Rd | Manaus | AM | 69005-010 | 29 Jungle Ave | Itacoatiara | AM | 69100-000 | Brazil | other | CAR-0114 | blank | 7.7 | 0.16 | storm | delayed | standard | 2024-05-28T10:05:00Z | 2024-05-28T18:17:00Z | Flooded routes and severe tropical storm delayed delivery. |
| DLV-000014 | normal | 2.7 | Australia | ORD-0000014 | CUST-014 | 2024-05-27T08:00:00Z | 2024-05-27T13:33:00Z | 2024-05-27T13:51:00Z | 2024-05-27T13:37:00Z | 89 Collins St | Melbourne | VIC | 3000 | 24 Swanston St | Melbourne | VIC | 3000 | Australia | bike | CAR-0170 | DRV-0170 | 0.9 | 0.01 | clear | delivered | same_day | 2024-05-27T07:31:00Z | 2024-05-27T13:51:00Z | blank |
| DLV-000015 | normal | 7.4 | Canada | ORD-0000015 | CUST-015 | 2024-06-02T09:45:00Z | 2024-06-02T17:20:00Z | blank | 2024-06-02T17:11:00Z | 22 Granville Ave | Montreal | QC | H3B2Y5 | 44 Sherbrooke St | Montreal | QC | H2X1C3 | Canada | car | CAR-0097 | DRV-0097 | 2.6 | 0.06 | rain | in_transit | express | 2024-06-02T09:31:00Z | 2024-06-02T11:23:00Z | blank |
| DLV-000016 | normal | 3.2 | Canada | ORD-0000016 | CUST-016 | 2024-05-29T12:41:00Z | 2024-05-29T14:55:00Z | blank | 2024-05-29T15:02:00Z | 7 Yonge St | Toronto | ON | M5E1M2 | 45 Bloor St | Toronto | ON | M4W1A9 | Canada | bike | CAR-0134 | DRV-0134 | 0.5 | 0.007 | clear | pending | same_day | 2024-05-29T12:25:00Z | 2024-05-29T13:08:00Z | blank |
| DLV-000017 | heavy | 7.8 | United Kingdom | ORD-0000017 | CUST-017 | 2024-05-31T11:02:00Z | 2024-05-31T16:42:00Z | 2024-05-31T17:24:00Z | 2024-05-31T16:55:00Z | 18 King St | Manchester | ENG | M2 6AG | 88 Oxford Rd | Manchester | ENG | M1 7ED | United Kingdom | van | CAR-0165 | DRV-0165 | 2.1 | 0.02 | rain | delivered | express | 2024-05-31T10:40:00Z | 2024-05-31T17:24:00Z | Unexpected traffic accident caused delivery delay. |
| DLV-000018 | normal | 3.9 | United States | ORD-0000018 | CUST-018 | 2024-06-02T10:30:00Z | 2024-06-02T13:58:00Z | 2024-06-02T13:56:00Z | 2024-06-02T13:54:00Z | 44 Broadway | New York | NY | 10004 | 234 5th Ave | New York | NY | 10001 | United States | bike | CAR-0028 | DRV-0028 | 1.2 | 0.03 | clear | delivered | same_day | 2024-06-02T10:14:00Z | 2024-06-02T13:56:00Z | blank |
| DLV-000019 | normal | 7.2 | Germany | ORD-0000019 | CUST-019 | 2024-05-28T09:21:00Z | 2024-05-28T14:41:00Z | blank | 2024-05-28T14:32:00Z | 5 Leopoldstr | Munich | BY | 80802 | 67 Sendlinger Tor | Munich | BY | 80336 | Germany | bike | CAR-0091 | DRV-0091 | 1.9 | 0.02 | clear | pending | same_day | 2024-05-28T09:09:00Z | 2024-05-28T11:31:00Z | blank |
| DLV-000020 | heavy | 7.8 | Hong Kong | ORD-0000020 | CUST-020 | 2024-06-03T07:12:00Z | 2024-06-03T15:55:00Z | blank | 2024-06-03T15:57:00Z | 3 Queen's Rd | Hong Kong | HK | 00001 | 21 Nathan Rd | Kowloon | HK | 00002 | Hong Kong | car | CAR-0201 | DRV-0201 | 2.4 | 0.04 | rain | in_transit | express | 2024-06-03T06:55:00Z | 2024-06-03T12:40:00Z | blank |
What the 200 rows show
from the 200-row sampleUnknown (traffic condition) stands out: mean distance_
- 11.6median distance_
km - 3delivery priorities
- 5vehicle types
- 5delivery statuses
- 6weather conditions
- 30destination countries
Median 11.6, from 2.1 to 1,284.
- string 21
- float 3
- datetime 6
Columns
30 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 21 columns | |||
delivery_id | string | Unique identifier for each delivery recordunique | DLV-000001 |
order_id | string | Unique identifier for the associated order | ORD-0000001 |
customer_id | string | Unique identifier for the customer receiving the delivery | CUST-001 |
origin_street_address | string | Street address of the pickup location | 112 Main St |
origin_city | string | City of the pickup location | New York |
origin_state | string | State of the pickup location | NY |
origin_postal_code | string | Postal code of the pickup location | 10001 |
origin_country | string | Country of the pickup location | United States |
destination_street_address | string | Street address of the delivery destination | 275 Park Ave |
destination_city | string | City of the delivery destination | Brooklyn |
destination_state | string | State of the delivery destination | NY |
destination_postal_code | string | Postal code of the delivery destination | 11205 |
destination_country | string | Country of the delivery destination | United States |
vehicle_type | string | Type of vehicle used for delivery (e.g., truck, van, bike)truck · van · bike · car · other | van |
carrier_id | string | Unique identifier for the logistics carrier or delivery service | CAR-0012 |
driver_id | string | Unique identifier for the driver assigned to the deliveryoptional | DRV-0012 |
traffic_condition | string | Traffic status during delivery (e.g., normal, heavy, accident, closed)normal · heavy · accident · closed · unknown · optional | normal |
weather_condition | string | Weather status during delivery (e.g., clear, rain, snow, storm)6 values · optional | clear |
delivery_status | string | Current status of the delivery (e.g., pending, in_transit, delivered, delayed, cancelled)pending · in_transit · delivered · delayed · cancelled | delivered |
delay_reason | string | Reason for delivery delay, if applicableoptional | Severe traffic congestion… |
delivery_priority | string | Priority level of the delivery (e.g., standard, express, same_day)standard · express · same_day | express |
| Numbers 3 columns | |||
distance_km | float | Total distance in kilometers between origin and destination0 or more | 6.7 |
package_weight_kg | float | Weight of the package in kilograms0 or more | 4.9 |
package_volume_m3 | float | Volume of the package in cubic meters0 or more · optional | 0.08 |
| Dates and times 6 columns | |||
pickup_datetime | datetime | Date and time when the package was picked up for delivery | 2024-06-03T08:13:00Z |
scheduled_delivery_datetime | datetime | Scheduled date and time for delivery as per logistics plan | 2024-06-03T14:15:00Z |
actual_delivery_datetime | datetime | Actual date and time when the delivery was completedoptional | 2024-06-03T14:24:00Z |
predicted_eta_datetime | datetime | Predicted estimated time of arrival for the delivery | 2024-06-03T14:18:00Z |
created_at | datetime | Timestamp when the delivery record was created | 2024-06-03T07:44:00Z |
updated_at | datetime | Timestamp when the delivery record was last updated | 2024-06-03T14:24:00Z |
Use it for
A logistics dashboard
Distance_
km by traffic_ condition and a breakdown of origin_ country. Excel, Power BI or Tableau. Why do the 17 unknown rows have a mean distance_
km of 443.5? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Deliveries200DLV-0000016.7normalDLV-00000212.3normalDLV-0000039.1heavy
A software demo
Believable deliveries with order_
id, customer_ id and pickup_ datetime to fill a screen in front of a buyer.
blueprint · logistics-delivery-eta-prediction
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 30 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.
- Include route and traffic features
- Segment by delivery type
- Track actual vs predicted ETA
- Flag missed ETAs
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
- logistics-delivery-eta-prediction