Dark Mode
Public Safety Vehicle Incidents, Cincinnati
Data Science and Analytics
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This data product details all reported motor vehicle accidents within Cincinnati, Ohio, spanning from 2010 to the present day. The data includes records of fatal crashes, those resulting in injury, and non-injury incidents classified solely as property damage. Sourced from Cincinnati Public Safety records, the information is provided in an anonymised form to ensure compliance with privacy regulations. This dataset is valuable for investigating traffic patterns, understanding collision hotspots, and analysing safety trends across the city.
Columns
The product features 27 distinct columns, including detailed geographical, temporal, and situational attributes related to each collision:
- ADDRESS_X: The partially redacted street address where the crash was reported.
- LATITUDE_X / LONGITUDE_X: Geographic coordinates of the collision location.
- CRASHDATE / DATECRASHREPORTED: The date the crash occurred and the date it was officially reported.
- CRASHSEVERITY: An indicator showing the impact level, with Property Damage Only (PDO) being the most frequent classification, followed by injury reports.
- CRASHLOCATION: The type of location, such as whether it was at an intersection or not.
- MANNEROFCRASH: The mechanism of the crash, with angle and rear-end collisions being the most common types.
- WEATHER: The prevailing weather condition at the time, with clear conditions reported most often.
- LIGHTCONDITIONSPRIMARY: The lighting environment, primarily daylight or dark, lighted roadway.
- ROADCONDITIONSPRIMARY: Road surface conditions, which are most frequently dry or wet.
- ROADCONTOUR / ROADSURFACE: Details on the road's topography (e.g., straight level) and surface material (e.g., blacktop, asphalt).
- DAYOFWEEK: The day of the week the incident happened, with Friday showing the highest occurrence rate.
- AGE / GENDER / TYPEOFPERSON: Demographic information regarding individuals involved in the crash, where drivers are the overwhelming majority, and the 18-25 age group is the most common.
- COMMUNITY_COUNCIL_NEIGHBORHOOD / CPD_NEIGHBORHOOD / SNA_NEIGHBORHOOD: Various identifiers for the neighborhood location, with Westwood frequently noted.
- UNITTYPE: The type of vehicle involved, such as mid-size cars or passenger cars.
Distribution
The data is provided in a CSV file format titled
cincinnati_traffic_crash_data__cpd.csv, which is approximately 107.95 MB in size. It contains nearly 259,000 records, spanning 27 columns. Most fields are fully populated, though minor data gaps exist in certain location and demographic columns, such as gender and neighborhood identification. The data is structured for ease of analysis.Usage
This product is highly useful for answering questions related to traffic safety and urban planning, such as:
- Identifying specific areas or communities that are sources of high crash frequency.
- Analysing the relationship between adverse weather and climate conditions and the frequency of vehicular incidents.
- Performing detailed exploratory data analysis on traffic dynamics and demographics of individuals involved in collisions.
Coverage
The geographic scope covers all reported incidents within Cincinnati, Ohio. The temporal range begins in February 2010 and currently extends through January 2021. Updates to this dataset are expected to occur on a monthly basis, ensuring a current view of traffic safety issues. The dataset includes demographic details like age and gender for involved individuals.
License
CC0: Public Domain
Who Can Use It
- City Planners and Public Safety Officials: To allocate resources, plan infrastructure improvements, and target high-risk zones for safety interventions.
- Researchers and Academics: For statistical modelling, trend analysis, and studies on accident causality, particularly concerning weather and road conditions.
- Insurance Analysts: To assess regional risk profiles and inform policy development.
- Data Scientists: For training models on incident prediction and anomaly detection in traffic data.
Dataset Name Suggestions
- Cincinnati Traffic Collision Reports (2010–Present)
- Ohio Car Crash Data for Cincinnati
- Public Safety Vehicle Incidents, Cincinnati
Attributes
Original Data Source: Public Safety Vehicle Incidents, Cincinnati
QUALITYLoading...