About this Dataset

Police Transparency - Arrests - Last 90 Days (Dataset)

Main Table / Denormalized Version (last 90 days only)

This dataset provides demographic information related to arrests made by the Tempe Police Department. Each record represents an individual charge associated with an arrest and includes details about both the person arrested (arrestee) and the arresting officer. Demographic fields include race and ethnicity, age range at the time of arrest, and gender for each party.

The data is sourced from the Police Department’s Records Management System (RMS) and supports analysis of patterns related to arrests, enforcement activity, and demographic trends over time. This information is a component of ongoing efforts to promote transparency and provide context for law enforcement within the community.

For detailed guidance on interpreting arrest counts and demographic breakdowns, please refer to the User Guide: Understanding the Arrests Demographic Datasets.

Why this Dataset is Organized this Way?

The main arrests open data table includes key information from each arrest event, along with associated person and charge details in one place. This format is ideal for quick viewing and simple analysis.

Providing this format supports a wide range of users, from casual data explorers to experienced analysts.

Understanding the Arrests Open Data (main table / denormalized version)

Each row in this dataset represents a single charge, which means a single arrest event may appear multiple times if multiple charges were filed. To determine the number of unique arrests, users should perform a distinct count of the rin field, which serves as the arrest incident identifier.

Likewise:

To count unique arrestees, use a distinct count of the pin field (person identifier).
To count unique arresting officers, use a distinct count of the arrest_officer field.

This structure enables users to explore charge-level detail while maintaining the ability to summarize demographic data by arrest event, arrestee, or officer as needed. Visit the User Guide: Understanding the Arrests Demographic Datasets for more details.

Data Dictionary

Additional Information

Contact Email: PD_DataRequest@tempe.gov

Contact Phone: N/A

Link: N/A

Data Source: Versaterm RMS

Data Source Type: SQL Server

Preparation Method: Automated process

Publish Frequency: Daily

Publish Method: Automatic
Organization: City of Tempe
Last updated: 2025-10-18T20:43:02.600859
Tags: arizona, arrests, crime, pd, police, public-safety, tempe

Tables

Table 1

@usgov.city_of_tempe_police_transparency_arrests_last_90_days_dataset.table_1

297.05 kB
3,180 rows
40 columns

CREATE TABLE table_1 (
  "x" BIGINT,
  "y" BIGINT,
  "rin" BIGINT,
  "primary_key" VARCHAR,
  "arrest_type" VARCHAR,
  "arrest_translation" VARCHAR,
  "arrest_dt" TIMESTAMP,
  "arrest_time" BIGINT,
  "arrest_hour_of_day" BIGINT,
  "location" VARCHAR,
  "municipality" VARCHAR,
  "jurisdiction" VARCHAR,
  "district" VARCHAR,
  "zone" VARCHAR,
  "grid" DOUBLE,
  "arrest_officer" VARCHAR,
  "x_coordinate" BIGINT,
  "y_coordinate" BIGINT,
  "zipcode" DOUBLE,
  "area_name" VARCHAR,
  "ofc_age_range" VARCHAR,
  "arrestee_age_range" VARCHAR,
  "ofc_gendertranslation" VARCHAR,
  "ofc_raceandethnicity" VARCHAR,
  "charge_rin" BIGINT,
  "pin" VARCHAR,
  "charge" VARCHAR,
  "class" VARCHAR,
  "statute" VARCHAR,
  "charge_count" BIGINT,
  "severity_code" VARCHAR,
  "severity_trans" VARCHAR,
  "chargeclasstranslation" VARCHAR,
  "chargegrouping" VARCHAR,
  "arrestee_sex" VARCHAR,
  "arrestee_race" VARCHAR,
  "arrestee_ethnicity" VARCHAR,
  "arrestee_gendertranslation" VARCHAR,
  "arrestee_raceandethnicity" VARCHAR,
  "esri_oid" BIGINT
);