Customer Service Requests (CSRs)

data.cincinnati-oh.gov | Last Updated 13 May 2024

Data Description: This dataset contains all Customer/Citizen Service Request (CSR) records for all City of Cincinnati departments. Data set includes close time, service request type, service request group, current service request status, and time resolved/closed. A Citizen Service Requests (CSR) gives Cincinnati residents the opportunity to submit service request for concerns like furniture pick-up, tall grass and pothole repairs. Using the Fix It Cincy! Mobile App, the customer service request online portal and the hotline (513-591-6000), citizen service requests are routed directly to City departments to be completed. Data Creation: Data is generated when a CSR is submitted through mobile app, online portal, or through the hotline Data Created By: DPS Refresh Frequency: Daily CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/Customer-Service-Citizen-Service-Request-CSR-/ve9a-xare 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: csr, customer service, citizen service requests, customer service requests, open data

This dataset has the following 70 columns:

Column NameAPI Column NameData TypeSample Values
SR_NUMBERsr_numbertext
USER_IDuser_idtext
SR_TYPEsr_typetext
SR_TYPE_DESCsr_type_desctext
PRIORITYprioritytext
GROUP_IDgroup_idnumber
GROUP_TITLEgroup_titletext
GROUP_DESCgroup_desctext
DEPT_CODEdept_codetext
DEPT_NAMEdept_nametext
DEPT_DIVISIONdept_divisiontext
ADDRESSaddresstext
LOCATIONlocationtext
NEIGHBORHOODneighborhoodtext
ZIPCODEzipcodetext
NEAREST_PARCEL_NOnearest_parcel_notext
METHOD_RECEIVEDmethod_receivedtext
DATE_CREATEDdate_createdcalendar_date
TIME_RECEIVEDtime_receivedtext
DATE_CLOSEDdate_closedcalendar_date
SR_STATUSsr_statustext
SR_STATUS_FLAGsr_status_flagtext
DATE_STATUS_CHANGEdate_status_changecalendar_date
TIME_STATUS_CHANGEtime_status_changetext
DATE_LAST_UPDATEdate_last_updatecalendar_date
TIME_LAST_UPDATEtime_last_updatetext
PLANNED_HOURS_TOSTART_RESPONSEplanned_hours_tostart_responsenumber
PLANNED_RESPONSE_TIMEplanned_response_timetext
PLANNED_END_DATEplanned_end_datecalendar_date
PLANNED_COMPLETION_DAYSplanned_completion_daysnumber
DATE_DISPATCHEDdate_dispatchedtext
TIME_DISPATCHEDtime_dispatchedtext
DATE_REVISED_COMPLETIONdate_revised_completioncalendar_date
DATE_REVISED_COMPLETION_REASONdate_revised_completion_reasontext
COLLECTION_SPECIAL_DATEcollection_special_datecalendar_date
COLLECTION_DAYcollection_daytext
COLLECTION_ROUTEcollection_routetext
COLLECTION_DISTcollection_disttext
TRANSFER_ALLOWtransfer_allowtext
TRANSFERED_NUM_TIMEStransfered_num_timesnumber
PROPTY_CITY_OWNED_YNpropty_city_owned_yntext
PROPTY_CITY_DEPT_OWNERpropty_city_dept_ownertext
STREET_NOstreet_nonumber
STREET_DIRECTIONstreet_directiontext
STREET_NAMEstreet_nametext
CITY_IDcity_idtext
STRUCTURE_IDstructure_idtext
FLOOR_IDfloor_idtext
UNIT_IDunit_idtext
MUNITWNSHPmunitwnshptext
REQUEST_RETURN_CALLrequest_return_calltext
NUM_BULKY_ITEMSnum_bulky_itemsnumber
BULKY_ITEM_1bulky_item_1text
BULKY_ITEM_2bulky_item_2text
BULKY_ITEM_3bulky_item_3text
BULKY_ITEM_4bulky_item_4text
BULKY_ITEM_5bulky_item_5text
NUM_TIRESnum_tiresnumber
NUM_FREONSnum_freonsnumber
NUM_SOFABEDSnum_sofabedsnumber
NUM_POTHOLESnum_potholesnumber
POLICE_DISTRICTpolice_districttext
POLICE_RPT_AREApolice_rpt_areanumber
TRASH_RECYCLE_CART_IDtrash_recycle_cart_idtext
SEGIDUSNG_XREFsegidusng_xreftext
LATITUDElatitudenumber
LONGITUDElongitudenumber
DATE_TIME_RECEIVEDdate_time_receivedtext
COMMUNITY_COUNCIL_NEIGHBORHOODcommunity_council_neighborhoodtext
HAM_PAVE_POLYGON_IDham_pave_polygon_idtext