Fleet Procurement

data.cincinnati-oh.gov | Last Updated 27 May 2020

Data Description: This data set contains procurement data related to the city’s fleet of vehicles Data Creation: Data is generated for procurement requests and purchases 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

Tags: fleet, vehicles, assets, equipment, dps, spending

This dataset has the following 20 columns:

Column NameAPI Column NameData TypeSample Values
REQUEST_IDrequest_idnumber
REQUEST_STATUSrequest_statustext
FUNDING_SOURCEfunding_sourcetext
REQUEST_TYPErequest_typetext
DEPARTMENT_NAMEdepartment_nametext
FISCAL_YEARfiscal_yearnumber
REPLACEMENT_BODY_STYLEreplacement_body_styletext
EQUIPMENT_CLASSequipment_classtext
EQUIP_ID_TO_REPLACEequip_id_to_replacetext
REPLACEMENT_MAKEreplacement_maketext
REPLACEMENT_MODELreplacement_modeltext
DATE_FLEET_DOC_ENTEREDdate_fleet_doc_enteredcalendar_date
FLEET_DOCUMENT_TYPEfleet_document_typetext
PURCHASING_BID_DATEpurchasing_bid_datecalendar_date
EST_UNIT_COSTest_unit_costnumber
DATE_BID_CLOSEDdate_bid_closedcalendar_date
DATE_PO_AWARDEDdate_po_awardedcalendar_date
ACTUAL_UNIT_COSTactual_unit_costnumber
PROCUREMENT_PLANprocurement_plantext
geomgeomlocation