Police Criminal Offenses 2020-present (Public)
Published by Police
About this dataset
Criminal offenses from Mesa Police Department incident reports, including reports from calls for service, officer initiated activity, and reports made in person. Each row is one offense. Most offenses use National Incident Based Reporting System (NIBRS) codes; offense_group identifies Group A, Group B (arrest only), and Mesa local codes outside NIBRS. One incident can include several offenses, so the same crime_id can appear on multiple rows. To count incidents, use a distinct count of crime_id. Each row has a unique offense_uid. Locations are withheld for sensitive incidents. When an incident includes homicide, kidnapping, a sex offense, incest, human trafficking for commercial sex, or certain Mesa local offense codes designated by the Police Department, address, location_wkt, latitude, and longitude are blank on every row of that incident, and sensitive_incident is true. Locations are approximate. address and location_wkt are rounded to the hundred block, and latitude and longitude are derived from that rounded address. Where verified is 0, the address could not be matched and the location defaults to Center and Main. Coverage is based on report date, beginning in 2020. Some offenses occurred well before they were reported, so occurred_date can be earlier than 2020. Mesa Police began reporting under NIBRS on January 1, 2021; offenses reported in 2020 predate that transition and are not directly comparable with later years. Traffic offenses are excluded. victim_count is the number of victims connected to each offense. It counts people only for crimes against persons (crime_against is Person). All other offenses, including crimes against property or society and Group B and Mesa local offenses, always show 1, which does not represent people harmed. A person who is the victim of more than one offense is counted on each of those rows, so summing across rows counts victimizations rather than individual people. This dataset does not fully reconcile with Police Dispatch Events (https://citydata.mesaaz.gov/d/izhu-764k). Not every call for service produces a report, and not every report begins with a call. The dataset is replaced daily from Mesa Police records, so offenses can change as reports are reviewed, corrected, or reclassified. Offenses have not been adjudicated in a court of law.
Live preview
The first rows, fetched from Socrata network when you open this page.
Loading the first rows from the source…