Tyler Data & Insights

Author: Office of Performance & Data Analytics
Description: Data Description: This dataset captures confirmed shooting events in the City of Cincinnati. Shootings events are captured in the Computer Aided Dispatch System (CAD), and are ultimately stored in the City's Records Management System (RMS). No personal or identifying (or otherwise sensitive) victim or suspect information is included in this data set. Data Creation: This data is created through the City’s computer-aided dispatch (CAD) system. Data Created By: The source of this data is the Cincinnati Police Department. Refresh Frequency: This data is updated daily. CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/xw7t-5phj Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset. Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.). Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad Disclaimer: In compliance with privacy laws, all Public Safety datasets are anonymized and appropriately redacted prior to publication on the City of Cincinnati’s Open Data Portal. This means that for all public safety datasets: (1) the last two digits of all addresses have been replaced with “XX,” and in cases where there is a single digit street address, the entire address number is replaced with "X"; and (2) Latitude and Longitude have been randomly skewed to represent values within the same block area (but not the exact location) of the incident.
Category: safety
Tags: shootings, cpd, rms, cad, police incidents, police data initiative, shootings data, pdi
Rating: Current value: 0 out of 5
Data Provided By: City of Cincinnati
License: Public Domain

PDI (Police Data Initiative) CPD ShootingsData Description: This dataset captures confirmed shooting events in the City of Cincinnati. Shootings events are captured in the Computer Aided Dispatch System (CAD), and are ultimately stored in the City's Records Management System (RMS). No personal or identifying (or otherwise sensitive) victim or suspect information is included in this data set. Data Creation: This data is created through the City’s computer-aided dispatch (CAD) system. Data Created By: The source of this data is the Cincinnati Police Department. Refresh Frequency: This data is updated daily. CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/xw7t-5phj Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset. Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.). Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad Disclaimer: In compliance with privacy laws, all Public Safety datasets are anonymized and appropriately redacted prior to publication on the City of Cincinnati’s Open Data Portal. This means that for all public safety datasets: (1) the last two digits of all addresses have been replaced with “XX,” and in cases where there is a single digit street address, the entire address number is replaced with "X"; and (2) Latitude and Longitude have been randomly skewed to represent values within the same block area (but not the exact location) of the incident.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="PDI (Police Data Initiative) CPD Shootings" height="_height_px" src="https://data.cincinnati-oh.gov/w/7a3r-kxji/default?cur=9lXAXDYjnyI&from=rKHW6BWf97c" frameborder="0"scrolling="no"><a href="https://data.cincinnati-oh.gov/safety/PDI-Police-Data-Initiative-CPD-Shootings/7a3r-kxji" title="PDI (Police Data Initiative) CPD Shootings" target="_blank">PDI (Police Data Initiative) CPD Shootings</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

DISTRICT: district
INCLOCATION_X: inclocation_x
LATITUDE_X: latitude_x
LONGITUDE_X: longitude_x
CPD_NEIGHBORHOOD: cpd_neighborhood
SNA_NEIGHBORHOOD: sna_neighborhood
OID: oid
RMS_NO: rms_no
VICCOUNT: viccount
CITYSTATEZIP: citystatezip
RACE: race
SEX: sex
AGE: age
TYPE: type
DATEOCCURRED: dateoccurred
MONTHOCCURED: monthoccured
TIMEOCCURED: timeoccured
HROCCURED: hroccured
DAYOCCURRED: dayoccurred
RMSDUP: rmsdup
DATETIME: datetime
DSTFULL: dstfull
ZIP: zip
COMMUNITY_COUNCIL_NEIGHBORHOOD: community_council_neighborhood

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

Tyler Data & Insights

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.cincinnati-oh.gov.

Notice