Historical Sanitation Code Complaint Records for Chicago

Chicago's Department of Streets and Sanitation provides records of all sanitation code complaints made to 311 since January 1, 2011. The dataset includes over 20 columns detailing the nature, location, and status of each service request. It is a historical archive, as its function was replaced by a new dataset in December 2018.

Use Cases

• Analyze spatial complaint clusters using Latitude, Longitude, and Community Area to identify sanitation hotspots.
• Model request completion times by comparing Creation Date and Completion Date across different Wards or Police Districts.
• Classify the primary complaint type using the 'What is the Nature of this Code Violation?' column for service prioritization.
• Track the status of requests (e.g., 'Open - Dup', 'Completed') over time to monitor departmental workflow and duplicate reporting.

Strengths

• Daily updated data provides near real-time tracking of complaints.
• Includes geographic coordinates (X Coordinate, Y Coordinate) for precise spatial analysis.
• Covers a multi-year period from January 1, 2011 onward for longitudinal study.

Limitations

• Contains duplicate entries labeled as 'Open - Dup' or 'Completed - Dup', which may require filtering for unique incidents.
• As a historical archive replaced in 2018, newer data is not added to this specific collection.
• Unknown total row count and sample size limits assessment of statistical power.

Provenance

Source

City of Chicago Department of Streets and Sanitation, via data.cityofchicago.org.

Collection Method

Collected from the city's 311 Customer Service Request (CSR) system.

Time Range

January 1, 2011 to present (though functionally historical post-December 2018).

Freshness

Data is updated daily, but this specific dataset is historical-only and was functionally replaced in December 2018.

Geography

City of Chicago, Illinois, USA.