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
This dataset has the following 70 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
SR_NUMBER | sr_number | text | SR11003716 SR12014362 SR11005757 SR12014602 SR10051751 view top 100 |
USER_ID | user_id | text | CCSRWEB MOBILE RMCCRAY STOWE JPRESNELL view top 100 |
SR_TYPE | sr_type | text | MTL-FRN BLD-RES RF-COLLT PTHOLE LITR-PRV view top 100 |
SR_TYPE_DESC | sr_type_desc | text | METAL FURNITURE, SPEC COLLECTN BUILDING, RESIDENTIAL TRASH, REQUEST FOR COLLECTION POTHOLE, REPAIR TALL GRASS/WEEDS, PRIVATE PROP view top 100 |
PRIORITY | priority | text | STANDARD HAZARDOUS PRIORITY EMERGENCY view top 100 |
GROUP_ID | group_id | number | 150 1907 102 142 2932 view top 100 |
GROUP_TITLE | group_title | text | SPECIAL COLLECTIONS BUILD-EBID CLLCTNSSRVCRCRDNTRS LITTER STREET CLEANING view top 100 |
GROUP_DESC | group_desc | text | PS-SPECIAL COLLECTIONS BUILD-EXISTING BUILDING INSPECTION PS-COLLECTIONS SERVICE AREA COORDINATORS PS-LITTER OFFICER POLICE-DEFAULT view top 100 |
DEPT_CODE | dept_code | text | PUB SERV BUILD HEALTH POLICE CITY_MGR view top 100 |
DEPT_NAME | dept_name | text | PUBLIC SERVICES CINC BUILDING DEPT CINC HEALTH DEPT POLICE DEPARTMENT CITY MANAGER'S OFFICE view top 100 |
DEPT_DIVISION | dept_division | text | NOD TROD DOTE-TRAFFIC ENGINEERING DOTE-ENGINEERING NONE view top 100 |
ADDRESS | address | text | 2000 RADCLIFF DR 801 PLUM ST 8472 CURZON AV 7131 READING RD 8470 CURZON AV view top 100 |
LOCATION | location | text | 2000 RADCLIFF DR - GJ1193432950 8472 CURZON AV, CINC - GJ1902143995 7131 READING RD, CINC - GJ1910840997 8470 CURZON AV, CINC - GJ1901743981 1115 BATES AV - GJ1316835181 view top 100 |
NEIGHBORHOOD | neighborhood | text | WESTWOOD EAST PRICE HILL WEST PRICE HILL AVONDALE COLLEGE HILL view top 100 |
ZIPCODE | zipcode | text | 45205 45211 45202 45214 45238 view top 100 |
NEAREST_PARCEL_NO | nearest_parcel_no | text | 016900070027 007700010001 024500010168 022000560028 011700070045 view top 100 |
METHOD_RECEIVED | method_received | text | INTERNET PHONE 311 CALL INSPECTOR RADIO view top 100 |
DATE_CREATED | date_created | calendar_date | 2016-07-07T00:00:00.000 2016-12-27T00:00:00.000 2016-07-08T00:00:00.000 2016-12-29T00:00:00.000 2016-12-26T00:00:00.000 view top 100 |
TIME_RECEIVED | time_received | text | 8:21 AM 9:10 PM 1:58 PM 8:45 AM 1:41 PM view top 100 |
DATE_CLOSED | date_closed | calendar_date | 2022-10-04T00:00:00.000 2024-04-22T00:00:00.000 2023-04-14T00:00:00.000 2022-11-28T00:00:00.000 2022-11-29T00:00:00.000 view top 100 |
SR_STATUS | sr_status | text | CLOSED ABAT-OWN CLOS-NO CLOS-EXP DUPLICAT view top 100 |
SR_STATUS_FLAG | sr_status_flag | text | CLOSED OPEN view top 100 |
DATE_STATUS_CHANGE | date_status_change | calendar_date | 2022-10-04T00:00:00.000 2024-04-22T00:00:00.000 2023-04-14T00:00:00.000 2022-11-28T00:00:00.000 2022-11-29T00:00:00.000 view top 100 |
TIME_STATUS_CHANGE | time_status_change | text | 5:45 PM 3:43 PM 6:00 PM 10:40 AM 5:46 PM view top 100 |
DATE_LAST_UPDATE | date_last_update | calendar_date | 2022-10-04T00:00:00.000 2024-04-22T00:00:00.000 2023-04-14T00:00:00.000 2022-11-28T00:00:00.000 2022-11-29T00:00:00.000 view top 100 |
TIME_LAST_UPDATE | time_last_update | text | 5:45 PM 3:43 PM 6:00 PM 10:40 AM 5:46 PM view top 100 |
PLANNED_HOURS_TOSTART_RESPONSE | planned_hours_tostart_response | number | 336 24 1 48 72 view top 100 |
PLANNED_RESPONSE_TIME | planned_response_time | text | 2016-07-10 2016-12-30 2016-07-11 2017-01-01 2016-12-29 view top 100 |
PLANNED_END_DATE | planned_end_date | calendar_date | 2017-07-07T00:00:00.000 2017-12-27T00:00:00.000 2017-07-08T00:00:00.000 2017-12-29T00:00:00.000 2017-12-26T00:00:00.000 view top 100 |
PLANNED_COMPLETION_DAYS | planned_completion_days | number | 14 1 7 365 180 view top 100 |
DATE_DISPATCHED | date_dispatched | text | 01/25/2022 4/12/2024 06/17/2022 07/13/2022 04/28/2021 view top 100 |
TIME_DISPATCHED | time_dispatched | text | 8:59 AM 8:56 AM 8:58 AM 8:54 AM 8:35 AM view top 100 |
DATE_REVISED_COMPLETION | date_revised_completion | calendar_date | 2024-04-30T00:00:00.000 2024-03-30T00:00:00.000 2023-06-26T00:00:00.000 2023-11-30T00:00:00.000 2023-10-13T00:00:00.000 view top 100 |
DATE_REVISED_COMPLETION_REASON | date_revised_completion_reason | text | INSUFFICIENT PERSONNEL EQUIPMENT NOT AVAILABLE HIGHER PRIORITY PROJECT COMMITMENT INCLIMATE WEATHER OTHER UNEXPECTED EMERGENCY view top 100 |
COLLECTION_SPECIAL_DATE | collection_special_date | calendar_date | 2024-02-29T00:00:00.000 2023-04-13T00:00:00.000 2024-05-02T00:00:00.000 2023-09-14T00:00:00.000 2024-04-18T00:00:00.000 view top 100 |
COLLECTION_DAY | collection_day | text | MONDAY THURSDAY TUESDAY WEDNESDAY FRIDAY view top 100 |
COLLECTION_ROUTE | collection_route | text | THU13 MON18 THU10 MON17 TUE23 view top 100 |
COLLECTION_DIST | collection_dist | text | 3 1 2 4 5 view top 100 |
TRANSFER_ALLOW | transfer_allow | text | Y N view top 100 |
TRANSFERED_NUM_TIMES | transfered_num_times | number | 0 1 2 3 4 view top 100 |
PROPTY_CITY_OWNED_YN | propty_city_owned_yn | text | Y view top 100 |
PROPTY_CITY_DEPT_OWNER | propty_city_dept_owner | text | POLICE DOTE RECREATION PARKS FACILITIES view top 100 |
STREET_NO | street_no | number | 2000 801 100 1115 8472 view top 100 |
STREET_DIRECTION | street_direction | text | W E S N view top 100 |
STREET_NAME | street_name | text | RADCLIFF DR VINE ST READING RD HARRISON AV GLENWAY AV view top 100 |
CITY_ID | city_id | text | CINC SPRF ANDE GREE COLE view top 100 |
STRUCTURE_ID | structure_id | text | 0 1 01 NA N/A view top 100 |
FLOOR_ID | floor_id | text | 0 1 2 3 01 view top 100 |
UNIT_ID | unit_id | text | 0 1 2 3 4 view top 100 |
MUNITWNSHP | munitwnshp | text | CINCINNATI SPRINGFIELD TOWNSHIP ANDERSON TOWNSHIP NORWOOD COLERAIN TOWNSHIP view top 100 |
REQUEST_RETURN_CALL | request_return_call | text | N Y 0 view top 100 |
NUM_BULKY_ITEMS | num_bulky_items | number | 0 1 2 3 5 view top 100 |
BULKY_ITEM_1 | bulky_item_1 | text | MATTRESS/BOX SPRING SOFA BED/COUCH CHAIR/RECLINER DRESSER COUCH view top 100 |
BULKY_ITEM_2 | bulky_item_2 | text | MATTRESS/BOX SPRING SOFA BED/COUCH CHAIR/RECLINER DRESSER TABLE/COFFEE TABLE view top 100 |
BULKY_ITEM_3 | bulky_item_3 | text | MATTRESS/BOX SPRING CHAIR/RECLINER SOFA BED/COUCH TABLE/COFFEE TABLE DRESSER view top 100 |
BULKY_ITEM_4 | bulky_item_4 | text | MATTRESS/BOX SPRING CHAIR/RECLINER TABLE/COFFEE TABLE DRESSER SOFA BED/COUCH view top 100 |
BULKY_ITEM_5 | bulky_item_5 | text | MATTRESS/BOX SPRING CHAIR/RECLINER TABLE/COFFEE TABLE DRESSER CABINET view top 100 |
NUM_TIRES | num_tires | number | 0 4 1 2 3 view top 100 |
NUM_FREONS | num_freons | number | 0 1 2 3 4 view top 100 |
NUM_SOFABEDS | num_sofabeds | number | 0 1 2 3 4 view top 100 |
NUM_POTHOLES | num_potholes | number | 0 1 2 3 4 view top 100 |
POLICE_DISTRICT | police_district | text | 3 2 4 5 1 view top 100 |
POLICE_RPT_AREA | police_rpt_area | number | 98 97 99 2 231 view top 100 |
TRASH_RECYCLE_CART_ID | trash_recycle_cart_id | text | 0 TC9846352 view top 100 |
SEGIDUSNG_XREF | segidusng_xref | text | GJ1193432950 GJ1902143995 GJ1910840997 GJ1901743981 GJ1316835181 view top 100 |
LATITUDE | latitude | number | 39.1199545244967 39.1042567891717 39.2176422878218 39.190632998228 39.2175123784373 view top 100 |
LONGITUDE | longitude | number | -84.5485058021221 -84.5190605441107 -84.4630083339613 -84.4629842092473 -84.4630576594918 view top 100 |
DATE_TIME_RECEIVED | date_time_received | text | 2016-07-07 2016-12-27 2016-07-08 2016-12-29 2016-12-26 view top 100 |
COMMUNITY_COUNCIL_NEIGHBORHOOD | community_council_neighborhood | text | WESTWOOD WEST PRICE HILL EAST PRICE HILL COLLEGE HILL NORTHSIDE view top 100 |
HAM_PAVE_POLYGON_ID | ham_pave_polygon_id | text | S-HAM39217 S-HAM38514 S-HAM33136 S-HAM21371 S-HAM07000 view top 100 |