311 Service Requests - Sanitation Code Complaints - Historical
data.cityofchicago.org | Last Updated 26 Jul 2024As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only. All open sanitation code complaints made to 311 and all requests completed since January 1, 2011. The Department of Streets and Sanitation investigates and remedies reported violations of Chicago’s sanitation code. Residents may request service for violations such as overflowing dumpsters and garbage in the alley. 311 sometimes receives duplicate sanitation code complaints. Requests that have been labeled as duplicates are in the same geographic area as a previous request and have been entered into 311’s Customer Service Request (CSR) system at around the same time. Duplicate complaints are labeled as such in the status field, as either "Open - Dup" or "Completed - Dup." Data Owner: Streets and Sanitation (http://www.cityofchicago.org/content/city/en/depts/streets.html). Time Period: January 1, 2011 to present. Frequency: Data is updated daily. Related Applications: 311 Service Request Status Inquiry (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=createsrquery2) and Report Sanitation Code Complaint (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=locform&invSRType=SCB&invSRDesc=Sanitation%20Code%20Violation&locreq=Y&stnumreqd=Y).
This dataset has the following 16 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Creation Date | creation_date | calendar_date | 2012-09-03T00:00:00.000 2012-09-04T00:00:00.000 2012-05-07T00:00:00.000 2015-03-10T00:00:00.000 2017-05-16T00:00:00.000 view top 100 |
Status | status | text | Completed Completed - Dup Open Open - Dup view top 100 |
Completion Date | completion_date | calendar_date | 2016-08-02T00:00:00.000 2011-07-05T00:00:00.000 2016-08-01T00:00:00.000 2018-08-09T00:00:00.000 2018-08-07T00:00:00.000 view top 100 |
Service Request Number | service_request_number | text | 15-01276992 14-01204282 15-01266562 15-01297541 15-01279931 view top 100 |
Type of Service Request | type_of_service_request | text | Sanitation Code Violation view top 100 |
What is the Nature of this Code Violation? | what_is_the_nature_of_this_code_violation_ | text | Other Garbage in yard Garbage in alley Dumpster not being emptied Overflowing carts view top 100 |
Street Address | street_address | text | 4048 N MOZART ST 21 E 120TH ST 4028 N MOZART ST 2483 N CLARK ST 4032 N MOZART ST view top 100 |
ZIP Code | zip_code | number | 60620 60619 60628 60617 60647 view top 100 |
X Coordinate | x_coordinate | number | 1156658.41810826 1178531.47539484 1156662.51810826 1172472.42716724 1172505.52716724 view top 100 |
Y Coordinate | y_coordinate | number | 1926773.34840253 1825403.84369693 1926640.04840253 1916945.41872509 1917305.09920376 view top 100 |
Ward | ward | number | 6 21 32 7 17 view top 100 |
Police District | police_district | number | 8 19 25 6 4 view top 100 |
Community Area | community_area | number | 25 24 71 22 7 view top 100 |
Latitude | latitude | number | 41.9548460781068 41.676207546639596 41.95448021145578 41.92754221311281 41.92853277067207 view top 100 |
Longitude | longitude | number | -87.69949148880588 -87.62216714318855 -87.69948004089855 -87.6416483549574 -87.64223206013277 view top 100 |
Location | location | location | view top 100 |