cincinnati-oh-gov/fleet-monthly-costs-xvtz-r8an
Icon for Socrata external plugin
 
Readme
Updated 9 hours ago
Indexed 6 hours ago

Fleet Monthly Costs

Data Description: This dataset shows the monthly usage and cost of fuel, parts, labor, and other services on assets in the City’s fleet of vehicles.

Data Creation: This dataset is updated for each vehicle each month

Data Created By: Fleet Services Division of the Department of Public Services

Refresh Frequency: Daily

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
EQ_EQUIP_NOeq_equip_noeq_equip_noText
COST_YEARcost_yearcost_yearNumber
COST_MONTHcost_monthcost_monthNumber
METER_1_USAGEmeter_1_usagemeter_1_usageNumber
METER_1_EOMmeter_1_eommeter_1_eomNumber
FUEL_QTYfuel_qtyfuel_qtyNumber
FUEL_COSTfuel_costfuel_costNumber
CNG_QTYcng_qtycng_qtyNumber
CNG_COSTcng_costcng_costNumber
OIL_QTYoil_qtyoil_qtyNumber
OIL_COSToil_costoil_costNumber
MISC_COSTmisc_costmisc_costNumber
REPAIR_LABOR_HRSrepair_labor_hrsrepair_labor_hrsNumber
REPAIR_LABOR_COSTrepair_labor_costrepair_labor_costNumber
REPAIR_PARTS_COSTrepair_parts_costrepair_parts_costNumber
REPAIR_TASKSrepair_tasksrepair_tasksNumber
PM_LABOR_HRSpm_labor_hrspm_labor_hrsNumber
PM_LABOR_COSTpm_labor_costpm_labor_costNumber
PM_PARTS_COSTpm_parts_costpm_parts_costNumber
PM_SERVICESpm_servicespm_servicesNumber
DEPREC_COSTdeprec_costdeprec_costNumber
DOWNTIME_HRS_SHOPdowntime_hrs_shopdowntime_hrs_shopNumber
FIXED_MONTHLY_COSTfixed_monthly_costfixed_monthly_costNumber
USER_REPR_LABOR_HRSuser_repr_labor_hrsuser_repr_labor_hrsNumber
USER_REPR_LABOR_COSTuser_repr_labor_costuser_repr_labor_costNumber
USER_REPR_PARTS_COSTuser_repr_parts_costuser_repr_parts_costNumber
USER_REPR_TASKSuser_repr_tasksuser_repr_tasksNumber
USER_CAUS_DOWNT_SHOPuser_caus_downt_shopuser_caus_downt_shopNumber
REPAIR_CML_LABOR_COSTrepair_cml_labor_costrepair_cml_labor_costNumber
REPAIR_CML_PARTS_COSTrepair_cml_parts_costrepair_cml_parts_costNumber
USER_REPR_CML_LABOR_COSTuser_repr_cml_labor_costuser_repr_cml_labor_costNumber
USER_REPR_CML_PARTS_COSTuser_repr_cml_parts_costuser_repr_cml_parts_costNumber
FISCAL_YEARfiscal_yearfiscal_yearNumber
 
Preview
  • fleet_monthly_costs