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: [e-mail] 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主表/非规范化版本（仅保留最近90天数据） 本数据集提供坦佩警察局逮捕行动相关的人口统计信息。每条记录对应一次逮捕所关联的单项指控，同时包含被逮捕者（arrestee）与执行逮捕的警官的相关信息。人口统计字段涵盖双方的种族、族裔、逮捕时的年龄区间及性别。 数据源自该局的记录管理系统（Records Management System，RMS），可用于分析逮捕模式、执法活动及随时间变化的人口统计趋势。该信息是推动执法透明度、为社区内执法工作提供背景支撑的持续工作的组成部分。如需了解逮捕数量与人口统计细分的详细解读指南，请参阅用户指南：《逮捕人口统计数据集解读》。 本数据集采用此组织形式的缘由？ 主逮捕开放数据表将单次逮捕事件的核心信息、关联人员及指控细节整合于同一张表中。该格式非常适合快速浏览与简易分析，可满足从普通数据探索者到资深分析师的各类用户需求。 逮捕开放数据解读（主表/非规范化版本） 本数据集的每一行对应一项单独指控，因此若单次逮捕涉及多项指控，则该逮捕事件会在表中多次出现。若需统计唯一逮捕事件的数量，用户需对作为逮捕事件标识符的rin字段执行去重计数。同理：统计唯一被逮捕者数量时，需对作为人员标识符的pin字段执行去重计数；统计唯一执行逮捕的警官数量时，需对arrest_officer字段执行去重计数。此结构既支持用户探索指控层级的细节，也可根据需要按逮捕事件、被逮捕者或警官对人口统计数据进行汇总分析。如需了解更多详情，请参阅用户指南：《逮捕人口统计数据集解读》。 数据字典及附加信息 联系邮箱：[e-mail] 联系电话：无 链接：无 数据源：Versaterm RMS 数据源类型：SQL Server 预处理方式：自动化流程 发布频率：每日 发布方式：自动