Cincinnati Police Reported Shootings with Geospatial and Demographic Details

Confirmed shooting events in the City of Cincinnati are recorded daily via the police Computer Aided Dispatch (CAD) system. The Cincinnati Police Department creates the data, which is processed for address verification, geocoding, and addition of administrative areas like neighborhoods and police districts. Data is updated daily and published on the city's open data portal.

Use Cases

• Analyzing temporal patterns of shootings using DateOccurred, TimeOccurred, and YearOccurred.
• Mapping incident locations and density using LATITUDE_X, LONGITUDE_X, and StreetBlock (noting coordinates are randomly skewed within the block).
• Profiling demographic patterns of incidents using Age, Sex, and Race columns.
• Aggregating incidents by administrative area using SNA_NEIGHBORHOOD, COMMUNITY_COUNCIL_NEIGHBORHOOD, and District.

Strengths

• Data is updated daily, providing high recency for analysis.
• Includes multiple geospatial and administrative reference columns like LATITUDE_X, LONGITUDE_X, SNA_NEIGHBORHOOD, and District.
• Processing includes address verification, geocoding, and addition of census and neighborhood areas.

Limitations

• Latitude and longitude coordinates are randomly skewed within the same block area, not exact incident locations.
• Row count and total dataset size are unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

Cincinnati Police Department.

Collection Method

Created through the City's computer-aided dispatch (CAD) system and stored in the Records Management System (RMS).

Freshness

Updated daily. Last updated 2026-04-03 15:05:21.

Geography

City of Cincinnati, Ohio, USA.