Logistics shipments
===================

A national courier network: warehouses in 24 hub cities, carriers, shipments with promised and actual delivery dates, and the scan events along the way. Late deliveries cluster in the monsoon months and in festival weeks, when volume peaks.

Category: Operations
Licence: CC0-1.0
Synthetic data generated by DataStride. Places and calendars are real; companies are fictional.
Build: 940aea8e3b2c8169

shp_warehouses (24 rows)
  warehouse_id           INTEGER        [key] Warehouse identifier.
  city                   VARCHAR(40)    Hub city.
  state                  VARCHAR(40)    State.
  capacity_parcels_per_day INTEGER        Designed daily throughput.
  opened_on              DATE           Date the warehouse opened.

shp_carriers (12 rows)
  carrier_id             INTEGER        [key] Carrier identifier.
  carrier_name           VARCHAR(60)    Carrier name (fictional).
  mode                   VARCHAR(20)    Primary transport mode.
  on_time_target_pct     DECIMAL(5,2)   Contracted on-time percentage.

shp_shipments (4500 rows)
  shipment_id            INTEGER        [key] Shipment identifier.
  origin_id              INTEGER        -> shp_warehouses.warehouse_id Warehouse it left from.
  destination_city       VARCHAR(40)    Where it is going.
  carrier_id             INTEGER        -> shp_carriers.carrier_id Carrier handling it.
  weight_kg              DECIMAL(8,2)   Billed weight.
  dispatched_on          DATE           Dispatch date.
  promised_on            DATE           Promised delivery date.
  delivered_on           DATE           Actual delivery; null if lost or still moving.
  freight_charge         DECIMAL(10,2)  Freight charged, INR.

shp_tracking_events (5000 rows)
  event_id               INTEGER        [key] Event identifier.
  shipment_id            INTEGER        -> shp_shipments.shipment_id Shipment scanned.
  event_type             VARCHAR(30)    What happened.
  event_date             DATE           Date of the scan.
  scan_city              VARCHAR(40)    City of the scan.

Deliberate data-quality quirks (clean them before you aggregate):
  shp_shipments.destination_city: trailing space
