Data Description: This dataset contains the record of all Citizen Service Request (CSR) calls received at the call center at the Department of Public Services (DPS). For full CSR data visit: https://data.cincinnati-oh.gov/Innovative-Government/Customer-Service-Requests-CSRs-/gcej-gmiw 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 by incoming calls received at the DPS call center Data Created By: DPS 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
This dataset has the following 26 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
AGENTDISPID | agentdispid | number | 110 255 166 252 254 view top 100 |
CALLSTARTDT | callstartdt | calendar_date | 2015-05-19T00:00:00.000 2015-05-18T00:00:00.000 2020-06-01T00:00:00.000 2015-06-01T00:00:00.000 2015-03-16T00:00:00.000 view top 100 |
CALLACTIONID | callactionid | number | 8 5 18 6 17 view top 100 |
CALLACTIONREASONID | callactionreasonid | number | 6 44 4 36 18 view top 100 |
CALLID | callid | number | 105 351 331 876 494 view top 100 |
CALLTYPEID | calltypeid | number | 1 2 view top 100 |
CONNCLEARDT | conncleardt | calendar_date | 2019-11-15T13:26:14.000 2019-01-02T18:25:10.000 2019-01-02T18:25:11.000 2018-06-12T17:04:28.000 2015-07-01T08:41:08.000 view top 100 |
DNIS | dnis | text | 5135916000 5133523000 5916000 5913000 5135916010 view top 100 |
QUEUEENDDT | queueenddt | calendar_date | 2015-06-01T11:44:12.000 2019-11-15T13:25:57.000 2019-01-02T18:25:10.000 2019-11-15T13:27:02.000 2017-07-06T14:27:57.000 view top 100 |
SEQNUM | seqnum | number | 25686443 15274005 36751511 15270344 28947664 view top 100 |
SERVICE_ID | service_id | number | 106 107 view top 100 |
STATION | station | text | 6008 6004 6001 6007 6060 view top 100 |
WORKGROUP_ID | workgroup_id | number | 19 0 22 13 view top 100 |
WRAPENDDT | wrapenddt | calendar_date | 2015-07-31T10:05:02.000 2018-02-28T13:12:14.000 2017-02-02T14:15:58.000 2022-07-27T18:30:18.000 2016-12-19T14:42:17.000 view top 100 |
QUEUESTARTDT | queuestartdt | calendar_date | 2018-11-19T17:10:50.000 2019-01-02T17:47:04.000 2019-11-15T13:26:02.000 2015-06-23T09:58:48.000 2015-03-12T12:10:49.000 view top 100 |
PREVIEWENDDT | previewenddt | calendar_date | 2018-04-05T13:05:05.000 2017-10-24T19:34:29.000 2018-03-12T16:49:58.000 2017-10-09T16:11:34.000 2018-02-06T17:49:05.000 view top 100 |
PREVIEWSTARTDT | previewstartdt | calendar_date | 2017-12-04T21:18:28.000 2018-02-06T17:49:03.000 2017-11-28T12:30:00.000 2017-12-04T16:25:03.000 2018-01-12T16:26:36.000 view top 100 |
ANSWERDT | answerdt | calendar_date | 2017-12-29T17:19:22.000 2018-02-26T14:34:55.000 2017-11-28T20:25:16.000 2017-12-19T19:41:19.000 2018-01-31T16:25:40.000 view top 100 |
ANSWER_SPEED_SECS | answer_speed_secs | number | 8 9 7 10 11 view top 100 |
TALK_TIME_SECS | talk_time_secs | number | 0 77 73 72 74 view top 100 |
WRAP_TIME_SECS | wrap_time_secs | number | 0 3 4 2 5 view top 100 |
SERVICE_LEVEL | service_level | text | N Y view top 100 |
ABANDONED | abandoned | text | N Y view top 100 |
CALL_TYPE | call_type | text | Regular Call Virtual Call view top 100 |
UNIQUE_ID | unique_id | text | 289476634319 256863134673 289477294486 289477054444 256864274845 view top 100 |
ANSWERED | answered | text | Answered Not Answered view top 100 |