Chicago Crime

This dataset provides detailed reports of crimes Chicago from 2001 to 2024 included,. This data come from the official site of the government of United States of America.

This dataset have 7.4M rows and 22 Fields which are:

ID - Unique Identifier for the record

Case Number - The Chicago Police Department RD Number (Records Division Number), which is unique to the incident.

Date - Date when the incident occurred. this is sometimes a best estimate.

Block - The partially redacted address where the incident occurred, placing it on the same block as the actual address.

IUCR - The Illinois Unifrom Crime Reporting code. This is directly linked to the Primary Type and Description.

Primary Type - The primary description of the IUCR code.

Description - The secondary description of the IUCR code, a subcategory of the primary description.

Location Description - Description of the location where the incident occurred.

Arrest - Indicates whether an arrest was made.

Domestic - Indicates whether the incident was domestic-related as defined by the Illinois Domestic Violence Act.

Beat - Indicates the beat where the incident occurred. A beat is the smallest police geographic area – each beat has a dedicated police beat car. Three to five beats make up a police sector, and three sectors make up a police district. The Chicago Police Department has 22 police districts. See the beats at https://data.cityofchicago.org/d/aerh-rz74

District - Indicates the police district where the incident occurred.

Ward - The ward (City Council district) where the incident occurred.

Community Area - Indicates the community area where the incident occurred. Chicago has 77 community areas.

FBI Code - Indicates the crime classification as outlined in the FBI's National Incident-Based Reporting System (NIBRS).

X Coordinate - The x coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block.

Y Coordinate - The y coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block.

Year - Year the incident occurred

Updated On - Date and time the record was last updated.

Latitude - The latitude of the location where the incident occurred. This location is shifted from the actual location for partial redaction but falls on the same block.

Longitude - The longitude of the location where the incident occurred. This location is shifted from the actual location for partial redaction but falls on the same block.

Location - The location where the incident occurred in a format that allows for creation of maps. This location is shifted from the actual location for partial redaction but falls on the same block.

本数据集涵盖2001年至2024年（含首尾两年）的芝加哥犯罪详细报案记录，数据来源于美利坚合众国政府官方站点。
本数据集共包含740万条记录与22个字段，各字段说明如下：
ID：记录唯一标识符（Unique Identifier）
案件编号（Case Number）：芝加哥警察局RD编号（记录部门编号），为每起事件的唯一标识
案发日期（Date）：事件发生的时间，部分情况下为估算值
街区（Block）：事件发生地的部分隐去地址，与实际案发地址处于同一街区
伊利诺伊州统一犯罪报告代码（IUCR, Illinois Uniform Crime Reporting Code）：与犯罪主要类型及详细描述直接关联
犯罪主要类型（Primary Type）：IUCR代码对应的一级描述
犯罪详细描述（Description）：IUCR代码对应的二级描述，属于主要类型的子类别
案发地点描述（Location Description）：事件发生地点的详细说明
是否逮捕（Arrest）：标识是否已对事件相关人员实施逮捕
涉家庭暴力（Domestic）：标识事件是否属于《伊利诺伊州反家庭暴力法》定义的家庭暴力相关案件
巡逻辖区（Beat）：标识事件发生的巡逻辖区。巡逻辖区是最小的警务地理单元，每个辖区配有专属的巡逻警车。3至5个巡逻辖区组成一个警务分区，3个警务分区组成一个警务辖区。芝加哥警察局共设有22个警务辖区，可访问https://data.cityofchicago.org/d/aerh-rz74查看辖区详情
警务辖区（District）：标识事件发生所属的警务辖区
市议会选区（Ward）：事件发生所在的市议会选区（即沃德选区）
社区区域（Community Area）：标识事件发生所在的社区区域，芝加哥全市共设有77个社区区域
FBI代码（FBI Code）：依据美国联邦调查局（FBI）的国家事件报告系统（National Incident-Based Reporting System, NIBRS）制定的犯罪分类代码
X坐标（X Coordinate）：事件发生地点采用伊利诺伊州东部州平面NAD 1983坐标系的X轴坐标，该坐标已针对部分隐址需求进行偏移，但仍处于同一街区内
Y坐标（Y Coordinate）：事件发生地点采用伊利诺伊州东部州平面NAD 1983坐标系的Y轴坐标，该坐标已针对部分隐址需求进行偏移，但仍处于同一街区内
案发年份（Year）：事件发生的年份
最后更新时间（Updated On）：该记录最后一次更新的日期与时间
纬度（Latitude）：事件发生地点的纬度坐标，该坐标已针对部分隐址需求进行偏移，但仍处于同一街区内
经度（Longitude）：事件发生地点的经度坐标，该坐标已针对部分隐址需求进行偏移，但仍处于同一街区内
地理位置（Location）：以可用于绘制地图的格式呈现的事件发生地点，该地点信息已针对部分隐址需求进行偏移，但仍处于同一街区内

原始信息汇总

数据集详情总结

概述

• 数据集名称: Keyrus: Chicago Crime
• 来源: Snowflake Marketplace

网站信息

• 网站标题: Keyrus: Chicago Crime | Snowflake Marketplace
• 网站图标: 提供多种尺寸的favicon图标（16x16, 32x32, 48x48, 96x96, 144x144）

样式信息

• 样式表: 包含多个CSS类定义，涉及编辑器样式、颜色、布局等。

搜集汇总

背景与挑战

背景概述

该数据集记录了2001年至2024年芝加哥的犯罪事件，包含740万行数据和22个字段，涵盖犯罪类型、时间、地点、逮捕情况等多维度信息。数据来源于美国政府官方网站，具有时间跨度长、数据量大、字段详细的特点，且地理位置信息经过部分脱敏处理以保护隐私。