Excel dataset
=============

Database schema: workbook
Platform: sqlite
Tables: 2    Total rows: 160

ABOUT THE BUSINESS
------------------
Tri-Valley Regional Transit Authority (TVRTA) operates a network of bus routes across four service zones covering suburban and urban corridors. The authority monitors daily operational data to evaluate route efficiency, driver performance, and fuel consumption. Management uses this data to make scheduling decisions, allocate resources, and report on-time performance to the regional transportation board. The dataset covers a full operational quarter and supports analysis of ridership trends, fuel efficiency, and service reliability by route, vehicle, and zone.

WHAT EACH TABLE HOLDS
---------------------
Operations  (80 rows)
    One row per transaction — this is where the volume is, and where most analysis starts.

Routes  (80 rows)
    One row per transaction — this is where the volume is, and where most analysis starts.

HOW THE TABLES RELATE
---------------------
Day-to-day activity is recorded in Operations and Routes.


DATA DICTIONARY
---------------

  Operations
    LogID                    pk               e.g. 1
        Unique identifier for each Operations row.
    ServiceDate              date             e.g. 2025-01-10
        Date the route service was operated (weekdays only)
    Zone                     category         e.g. South
        Geographic service zone the route operates within
    RouteCode                category         e.g. R204
        Alphanumeric route identifier assigned by TVRTA
    VehicleID                category         e.g. BUS-04
        Fleet vehicle identifier assigned to the route for that day
    VehicleType              category         e.g. Articulated
        Class of transit vehicle deployed on the route
    DriverID                 category         e.g. D005
        Anonymised identifier for the driver operating the route that day
    ScheduledTrips           int              e.g. 9
        Number of trips scheduled for the route on that service day
    CompletedTrips           int              e.g. 5
        Number of trips actually completed (may be less than scheduled due to incidents)
    OnTimeTrips              int              e.g. 5
        Number of completed trips that arrived within 5 minutes of schedule
    TotalRiders              int              e.g. 595
        Total passenger boardings recorded across all completed trips for the route
    PeakRiders               int              e.g. 227
        Highest single-trip passenger count recorded during the service day
    RouteDistanceMiles       decimal          e.g. 11.4
        One-way route distance in miles used to compute per-mile fuel efficiency
    FuelUsedGallons          decimal          e.g. 40.65
        Total fuel consumed in gallons by the vehicle across all trips that day
    AvgSpeedMPH              decimal          e.g. 20.9
        Average vehicle speed in miles per hour across all completed trips
    IncidentReported         category         e.g. Yes
        Whether any mechanical or safety incident was logged for the vehicle on that day

  Routes
    RouteCode                category         e.g. R508
        Primary key matching RouteCode in the Operations sheet
    RouteName                text             e.g. Bulk bundle
        Descriptive name of the route (e.g. Northgate Express, Riverside Local)
    PrimaryZone              category         e.g. East
        Zone the route primarily serves
    ServiceType              category         e.g. Connector
        Classification of service speed and stop frequency
    BaseFareUSD              decimal          e.g. 3.11
        Standard adult single-ride fare for the route in US dollars

PROVENANCE
----------
Every value in this dataset is synthetic. No real person, company, or record is represented.
Generated by the Agoge dataset generator 1.0.0 with seed 17. The same brief and seed reproduce this data exactly.