Cincinnati Police Traffic Crash Reports with Geospatial and Road Condition Data

Traffic Crash Reports are records from the Cincinnati Police Department's response to fatal, injury, and non-injury crashes. The dataset is updated daily and includes columns for crash severity, location, road conditions, weather, and demographics. Data is processed for accuracy and granularity, including address verification and geocoding, before publication on the city's open data portal.

Use Cases

• Predict crash severity (CRASHSEVERITY) using road conditions (ROADCONDITIONSPRIMARY), weather (WEATHER), and light conditions (LIGHTCONDITIONSPRIMARY).
• Analyze temporal patterns of accidents by DAYOFWEEK, CRASHDATE, and time of day derived from available columns.
• Map crash hotspots and correlate with neighborhood demographics using LONGITUDE_X, LATITUDE_X, and SNA_NEIGHBORHOOD.
• Profile crash involvement by demographic factors such as AGE, GENDER, and TYPEOFPERSON (e.g., driver, pedestrian).

Strengths

• Updated daily, providing near-real-time data on traffic incidents.
• Includes over 25 columns covering crash circumstances, environmental conditions, location, and basic demographics.
• Data undergoes standard processing including address verification, geocoding, and addition of administrative areas like police districts and neighborhoods.

Limitations

• Row count is unknown, which may limit suitability assessment for large-scale modeling.
• Location data (LONGITUDE_X, LATITUDE_X, ADDRESS_X) is anonymized; coordinates are randomly skewed and address digits are redacted, reducing precise geospatial accuracy.
• Metadata for license and exact author is not provided in the input.

Provenance

Source

City of Cincinnati Police Department.

Collection Method

Records created in response to traffic crashes, processed by the Office of Performance and Data Analytics.

Freshness

Updated daily. Last metadata update was 2026-04-03 17:36:28.

Geography

City of Cincinnati, Ohio, USA.