# Southeastern Freight Services — Logistics Dataset

Southeastern Freight Services (SFS) is a regional LTL/FTL freight carrier operating across the southeastern United States, with terminals and warehouses in Atlanta GA, Charlotte NC, Greenville SC, Jacksonville FL, Knoxville TN, and Nashville TN. The fleet consists of approximately 1,500 vehicles (tractors, straight trucks, and sprinters) operated by a workforce of 1,200 CDL-licensed drivers, supporting both regional Southeast lanes and longer-haul routes to Baltimore, Chicago, Dallas, and Miami.

## File Inventory

| File | Format | Records | Description |
|------|--------|---------|-------------|
| shipments.csv | CSV | 15,000 | Freight shipments with dates, driver/route assignment, weight, freight class, and status |
| vehicles.csv | CSV | 1,500 | Fleet roster: tractors, straight trucks, and sprinters with make/model/capacity |
| drivers.csv | CSV | 1,200 | Driver roster with CDL credentials, hire date, terminal, and vehicle assignment |
| warehouses.csv | CSV | 25 | Warehouse/terminal reference with city, state, region, and manager |
| routes.json | JSON | 1,500 | Lane reference with geographically accurate distances and transit times |
| maintenance.csv | CSV | 5,000 | Vehicle service records with realistic type-specific costs and odometer readings |
| delivery_exceptions.csv | CSV | 3,045 | Exception records covering all Exception/Delayed shipments with resolution tracking |
| tracking_events.log | LOG | 61,792 | Shipment scan events following pickup→delivery pipeline order |
| fuel_reports.xlsx | XLSX | 14,780 | Monthly fuel consumption by vehicle, linked to driver and terminal |

## Date Range

Operational data spans **January 2023 – December 2025** (shipments, maintenance, exceptions). Fuel reports cover the full **2025 calendar year**. Tracking events follow each shipment's ship date.

## Key Relationships

- `shipments.driver_id` → `drivers.driver_id` (Active drivers only)
- `shipments.route_id` → `routes.route_id`
- `shipments.origin_warehouse` → `warehouses.warehouse_id`
- `delivery_exceptions.shipment_id` → `shipments.shipment_id` (Exception/Delayed shipments only)
- `tracking_events.shipment_id` → `shipments.shipment_id`
- `maintenance.vehicle_id` → `vehicles.vehicle_id`
- `fuel_reports.vehicle_id` → `vehicles.vehicle_id`
- `drivers.primary_vehicle_id` → `vehicles.vehicle_id`
- `drivers.terminal` / `vehicles.assigned_terminal` → `warehouses.city`

## ID Format Conventions

| Prefix | Entity |
|--------|--------|
| SH | Shipment |
| WH | Warehouse |
| DR | Driver |
| VH | Vehicle |
| RT | Route |
| MT | Maintenance |
| EX | Exception |

## Notes

Shipment weight is capped at 44,000 lbs (standard 53-foot trailer payload limit). Route distances are fixed per origin-destination pair, reflecting actual road mileage. Driver-vehicle assignments respect CDL class (Class A drivers operate Tractors; Class B drivers operate Straight Trucks/Sprinters) and home terminal. Fuel cost is computed as gallons × price-per-gallon (correlation 0.997).
