About this Dataset

Charges

Related Tables / Normalized Version

This dataset provides demographic information related to arrests made by the Tempe Police Department. 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 Arrest Demographic Datasets - Related Tables.

Why this Dataset is Organized this Way?

The related tables such as persons, charges, and locations follow a normalized data model. This structure is often preferred by data professionals for more advanced analysis, filtering, or joining with external datasets.

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

Understanding the Arrests Data (as related tables)

The related tables represent different parts of the arrest data. Each one focuses on a different type of information, like the officers, individuals arrested, charges, and arrest details.

All of these tables connect back to the arrests table, which acts as the central record for each event. This structure is called a normalized model and is often used to manage data in a more efficient way. Visit the User Guide: Understanding the Arrest Demographic Datasets - Related Tables for more details outlining the relationships between the related tables.

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:30.465542
Tags: arizona, arrests, crime, demographics, law-enforcement, officer, pd, police, public-safety, tempe

Tables

Table 1

@usgov.city_of_tempe_charges_e26dc.table_1

10.76 MB
312,594 rows
10 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "pin" VARCHAR,
  "charge" VARCHAR,
  "class" VARCHAR,
  "statute" VARCHAR,
  "charge_count" DOUBLE,
  "severity_code" VARCHAR,
  "severity_trans" VARCHAR,
  "chargeclasstranslation" VARCHAR,
  "chargegrouping" VARCHAR
);