SOCRATA
Violence Reduction - Victims of Homicides and Non-Fatal Shootings | City of Chicago | Data Portal
Dataset Profile
63.6K
Total records
—
Type
ID: https://data.cityofchicago.org/Public-Safety/Violence-Reduction-Victims-of-Homicides-and-Non-Fa/gumc-mgzr
Freshness & Tracking
Discovered3/8/2026, 4:53:13 PM
Last checked3/8/2026, 11:39:23 PM
Last changed3/8/2026, 4:53:13 PM
Reads2
Search hits3
View raw source ↗File Details
Filenamedownload_2026-03-16.csv
Size24486.1 KB
Typetext/csv; charset=utf-8
Rows analyzed63.3K
Columns38
📊
download_2026-03-16.csv
23.9 MB · text/csv; charset=utf-8 · Uploaded 3/16/2026
72.2% Fair
23.9 MB
Size
63.3K
Rows
38
Columns
3
Analyses
Activity Timeline
Upload/RefreshAnalysisFailedSnapshot
⚡analysis
Scheduled analysis
8/23/2026
72.2% quality
⚡analysis
Scheduled analysis
8/17/2026
68% quality
⚡analysis
Analysis run
3/16/2026
100% quality
📤upload
File uploaded
3/16/2026
download_2026-03-16.csv
Achievements
3/8🔍Located
📤Uploaded
⬇️Downloaded
🗄️Query Layer
🔬Analyzed
📸Snapshot
🛡️Privacy
⭐High Quality
30d agotoday
⏰
Scheduledconduit_analysis
8/23/2026⏰
Scheduledconduit_analysis
8/17/2026⚡
Manualconduit_analysis
3/16/2026Resources
Direct links to downloads, APIs, and related pages.
Profiled Fields (38)
Field-level metadata from analytics imports.
| Field | Technical | Semantic | Business |
|---|---|---|---|
| AGE | string | category | AGE |
| AREA | number | numeric | AREA |
| BEAT | mixed | category | BEAT |
| BLOCK | string | text | BLOCK |
| CASE_NUMBER | string | text | CASE NUMBER |
| COMMUNITY_AREA | string | category | COMMUNITY AREA |
| DATE | string | datetime | DATE |
| DAY_OF_WEEK | number | numeric | DAY OF WEEK |
| DISTRICT | number | numeric | DISTRICT |
| GUNSHOT_INJURY_I | string | category | GUNSHOT INJURY I |
| HOMICIDE_VICTIM_FIRST_NAME | string | person_name | HOMICIDE VICTIM FIRST NAME |
| HOMICIDE_VICTIM_LAST_NAME | string | person_name | HOMICIDE VICTIM LAST NAME |
| HOMICIDE_VICTIM_MI | mixed | category | HOMICIDE VICTIM MI |
| HOUR | number | numeric | HOUR |
| INCIDENT_FBI_CD | string | category | INCIDENT FBI CD |
| INCIDENT_FBI_DESCR | string | text | INCIDENT FBI DESCR |
| INCIDENT_IUCR_CD | string | category | INCIDENT IUCR CD |
| INCIDENT_IUCR_SECONDARY | string | category | INCIDENT IUCR SECONDARY |
| INCIDENT_PRIMARY | string | category | INCIDENT PRIMARY |
| LATITUDE | number | geolocation | LATITUDE |
| LOCATION | string | text | LOCATION |
| LOCATION_DESCRIPTION | string | text | LOCATION DESCRIPTION |
| LONGITUDE | number | geolocation | LONGITUDE |
| MONTH | number | numeric | MONTH |
| RACE | string | category | RACE |
| SEX | string | category | SEX |
| STATE_HOUSE_DISTRICT | number | address | STATE HOUSE DISTRICT |
| STATE_SENATE_DISTRICT | number | address | STATE SENATE DISTRICT |
| STREET_OUTREACH_ORGANIZATION | string | address | STREET OUTREACH ORGANIZATION |
| UNIQUE_ID | string | identifier | UNIQUE ID |
| UPDATED | string | datetime | UPDATED |
| VICTIMIZATION_FBI_CD | mixed | category | VICTIMIZATION FBI CD |
| VICTIMIZATION_FBI_DESCR | string | text | VICTIMIZATION FBI DESCR |
| VICTIMIZATION_IUCR_CD | string | category | VICTIMIZATION IUCR CD |
| VICTIMIZATION_IUCR_SECONDARY | string | category | VICTIMIZATION IUCR SECONDARY |
| VICTIMIZATION_PRIMARY | string | category | VICTIMIZATION PRIMARY |
| WARD | number | numeric | WARD |
| ZIP_CODE | string | address | ZIP CODE |