City Fleet Maintenance Work Orders with Cost and Downtime Data

Fleet Services Division of Cincinnati's Public Services Department provides records of all vehicle maintenance and repair work orders from January 2008 onward. The dataset includes details on work types, costs, labor hours, and timestamps for service milestones. Data is refreshed daily by the Office of Performance and Data Analytics.

Use Cases

• Predict TOTAL_COST from features like LABOR_HOURS, PARTS_COST, and EQ_EQUIP_NO using regression models.
• Analyze DOWNTIME_HRS_SHOP and DELAY_HOURS by DEPT_EQUIP_DEPT_NAME to identify departments with highest vehicle availability loss.
• Forecast maintenance needs by modeling the relationship between METER_1_LIFE_TOTAL, JOB_TYPE, and DATETIME_OUT_SERVICE.
• Cluster work orders by REAS_FOR_REPAIR_DESC and PRI_PRIORITY_CODE to discover common failure patterns across the fleet.
• Assess WARRANTY claim effectiveness by comparing costs and repair frequencies for specific asset types (EQ_PARENT_EQUIP_NO).

Strengths

• Daily update frequency ensures current operational data.
• Contains over 15 distinct cost and time-based columns like LABOR_COST and DATETIME_IN_SERVICE.
• Temporal coverage spans from January 2008 to the present, enabling long-term trend analysis.
• Includes a data dictionary for column definitions, improving interpretability.

Limitations

• Total row count and dataset size are unknown, making scalability assessment difficult.
• Potential for class imbalance if certain JOB_TYPE or REAS_FOR_REPAIR_DESC categories are infrequent.
• Geographic coverage is limited to the City of Cincinnati's fleet operations.

Provenance

Source

Fleet Services Division, Public Services Department, City of Cincinnati.

Collection Method

Recorded for all maintenance and repairs of the city's vehicle fleet, with processing for address verification and geocoding.

Time Range

January 2008 to present.

Freshness

Daily

Geography

City of Cincinnati, Ohio, USA.