Police Transparency - Arrests - All Data (main table / denormalized)
收藏资源简介：
Main Table / Denormalized Version 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
主表/非规范化版本 本数据集包含坦佩警察局（Tempe Police Department）执法逮捕行动相关的人口统计信息。每条记录对应一次逮捕关联的单项指控，涵盖被捕者（arrestee）与办案警员的相关详情。人口统计字段包含双方的种族、族裔、逮捕时的年龄区间以及性别信息。本数据集的数据源自警察局档案管理系统（Records Management System, RMS），可用于分析逮捕模式、执法活动及长期人口统计趋势。此类信息是推动执法透明度、为社区内执法工作提供背景支撑的持续性工作的组成部分。如需解读逮捕数量与人口统计细分项的详细指引，请参阅用户指南《逮捕人口统计数据集解读》。 为何采用此种数据集组织形式？ 本逮捕公开主表将单次逮捕事件的核心信息、关联人员与指控详情整合至单条记录中，该格式适配快速浏览与简易分析需求，可服务于从普通数据探索者到资深分析师的全层级用户。 逮捕公开数据（主表/非规范化版本）解读说明 本数据集的每一行对应一项单项指控，这意味着若单次逮捕涉及多项指控，则该逮捕事件会在数据集中多次出现。若需统计唯一逮捕事件的数量，用户需对代表逮捕事件标识符的rin字段进行去重计数；同理，统计唯一被捕者数量需对pin字段（人员标识符）进行去重计数；统计唯一办案警员数量则需对arrest_officer字段进行去重计数。此种数据结构允许用户在查看指控级细节的同时，按需按逮捕事件、被捕者或办案警员对人口统计数据进行汇总分析。如需了解更多详情，请参阅用户指南《逮捕人口统计数据集解读》。 数据字典 附加信息 联系邮箱：PD-DataRequest@tempe.gov 联系电话：无 相关链接：无 数据来源：Versaterm RMS 数据源类型：SQL Server 数据制备方式：自动化流程 发布频率：每日 发布方式：自动发布
