Customer Service Requests (CSR) Survey Feedback Responses
data.cincinnati-oh.gov | Last Updated 13 May 2024Data Description: This data set contains a record of all Citizen Service Requests (CSRs) feedback survey responses. When CSRs are closed out by the City, customers who provide an email address are automatically sent a notification that their work has been completed, as well as a link to a customer service satisfaction survey. Customers are able to provide feedback on work completion, satisfaction level, and any additional information. No identifying personal customer/citizen information (name, contact information, or additional comments) is included in this data. Data Creation: Data generated when CSR feedback surveys are submitted Data Created By: DPS Refresh Frequency: 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-CSR-Satisfaction/ks8a-xggj/ 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 27 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
SR_NUMBER | sr_number | text | SR21065133 SR22072586 SR21085729 SR21020898 SR22053299 view top 100 |
USER_ID | user_id | text | CCSRWEB MOBILE CAGISMOB view top 100 |
SR_TYPE | sr_type | text | MTL-FRN PTHOLE YDWSTA-J DFLTPLC TLGR-PRV view top 100 |
SR_TYPE_DESC | sr_type_desc | text | METAL FURNITURE, SPEC COLLECTN POTHOLE, REPAIR YARD WASTE,RTC DEFAULT, POLICE (AND JUNK VEH) TALL GRASS/WEEDS, PRIVATE PROP view top 100 |
GROUP_DESC | group_desc | text | PS-SPECIAL COLLECTIONS PS-LITTER OFFICER PS-ASPHALT OFFICE OF ENVIRONMENTAL QUALITY PS-YARDWASTE view top 100 |
DEPT_NAME | dept_name | text | PUBLIC SERVICES CITY MANAGER'S OFFICE DEPT OF TRANS AND ENG POLICE DEPARTMENT CINC BUILDING DEPT view top 100 |
ADDRESS | address | text | 147 PARKER ST 952 OLIVE AV 3561 LINWOOD AV 3434 DARWIN PL 4041 W 8TH ST view top 100 |
LOCATION | location | text | 147 PARKER ST, CINC - GJ1444733397 952 OLIVE AV, CINC - GJ0982631760 3561 LINWOOD AV, CINC - GJ2306433735 3434 DARWIN PL, CINC - PRIVATE STREET 6267 GRAND VISTA AV, CINC - GJ2254740604 view top 100 |
NEIGHBORHOOD | neighborhood | text | WESTWOOD EAST PRICE HILL WEST PRICE HILL HYDE PARK CUF view top 100 |
ZIPCODE | zipcode | text | 45208 45205 45211 45202 45238 view top 100 |
LATITUDE | latitude | number | 39.12425076 39.12337084 39.10975485 39.15253816 39.15527985 view top 100 |
LONGITUDE | longitude | number | -84.57322759 -84.41960508 -84.51931246 -84.60793131 -84.403602 view top 100 |
DATE_CREATED | date_created | calendar_date | 2022-02-22T00:00:00.000 2022-02-23T00:00:00.000 2021-05-25T00:00:00.000 2022-07-07T00:00:00.000 2021-04-28T00:00:00.000 view top 100 |
TIME_RECEIVED | time_received | text | 11:58 AM 4:48 PM 11:25 AM 9:36 AM 4:54 PM view top 100 |
DATE_CLOSED | date_closed | calendar_date | 2022-04-07T00:00:00.000 2021-09-22T00:00:00.000 2021-09-21T00:00:00.000 2022-10-04T00:00:00.000 2022-07-15T00:00:00.000 view top 100 |
SR_STATUS_FLAG | sr_status_flag | text | CLOSED view top 100 |
DATE_STATUS_CHANGE | date_status_change | calendar_date | 2022-04-07T00:00:00.000 2021-09-22T00:00:00.000 2021-09-21T00:00:00.000 2022-10-04T00:00:00.000 2022-07-15T00:00:00.000 view top 100 |
TIME_STATUS_CHANGE | time_status_change | text | 5:45 PM 3:43 PM 7:29 AM 5:46 PM 1:37 PM view top 100 |
PLANNED_HOURS_TOSTART_RESPONSE | planned_hours_tostart_response | number | 336 1 24 0 48 view top 100 |
PLANNED_RESPONSE_TIME | planned_response_time | text | 2021-09-30 12:00:00 2021-03-16 06:12:00 2021-04-21 07:08:00 2021-08-06 01:19:00 2021-06-17 09:41:00 view top 100 |
PLANNED_END_DATE | planned_end_date | calendar_date | 2022-03-07T00:00:00.000 2022-03-02T00:00:00.000 2022-02-05T00:00:00.000 2021-06-29T00:00:00.000 2022-03-06T00:00:00.000 view top 100 |
PLANNED_COMPLETION_DAYS | planned_completion_days | number | 14 1 7 45 12 view top 100 |
CSR_SVY_RSLVD | csr_svy_rslvd | text | Yes No view top 100 |
CSR_SVY_OVALL_SATISFIED | csr_svy_ovall_satisfied | text | Very Satisfied Very Unsatisfied Satisfied Unsatisfied view top 100 |
CSR_SVY_IF_RSVLD_SATISFIED | csr_svy_if_rsvld_satisfied | text | Very Satisfied N/a: My Request Has Not Yet Been Resolved Satisfied Very Unsatisfied Unsatisfied view top 100 |
CSR_SVY_IF_NOT_RSVLD | csr_svy_if_not_rsvld | text | N/a No Yes view top 100 |
CSR_SVY_IF_USED_CALL_CENTER | csr_svy_if_used_call_center | text | N/a: I Submitted My Request Via Web Or Mobile App Very Satisfied Satisfied Very Unsatisfied Unsatisfied view top 100 |