Denver Crime Data
Denver Crime Data
By City and County of Denver
Criminal offenses in the City and County of Denver for the previous five years plus the current year to date
Product type
Dataset
Update frequency
Daily
Updated
Jun 7, 2023
Delivery method
Download
Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.
Dataset file name: crime.csv
Key Statistics
Total records
503,329
Missing values
0.998%
Duplicate rows
0%
Columns
Columns
19
Categorical
0
Numeric
12
Date/time
3
Correlations
Correlations
4
Correlated columns
INCIDENT_ID and OFFENSE_ID, GEO_Y and GEO_LAT, GEO_X and GEO_LON, PRECINCT_ID and DISTRICT_ID
Column name | Type | Unique values | Min value | Max value |
---|---|---|---|---|
OFFENSE_CODE | numeric | 155 | 902 | 7399 |
INCIDENT_ID | numeric | 469,937 | 20196 | 2020890000000 |
OFFENSE_CODE_EXTENSION | numeric | 6 | 0 | 5 |
OFFENSE_ID | numeric | 503,329 | 20196521300 | 2020890000000299800 |
GEO_X | numeric | 47,931 | 1 | 40674770 |
GEO_Y | numeric | 45,400 | 1 | 104670740 |
GEO_LON | numeric | 29,652 | -115.46406 | 4.999999987376214e-7 |
GEO_LAT | numeric | 36,257 | 0 | 39.904312 |
PRECINCT_ID | numeric | 36 | 111 | 759 |
DISTRICT_ID | numeric | 7 | 1 | 7 |
IS_CRIME | numeric | 2 | 0 | 1 |
IS_TRAFFIC | numeric | 2 | 0 | 1 |
OFFENSE_TYPE_ID | text | 200 | 4 | 30 |
OFFENSE_CATEGORY_ID | text | 15 | 5 | 28 |
INCIDENT_ADDRESS | text | 99,470 | 2 | 97 |
NEIGHBORHOOD_ID | text | 80 | 3 | 26 |
LAST_OCCURRENCE_DATE | date | 126,102 | 01/02/2016 01:35:00 AM | 07/21/2021 12:45:00 PM |
FIRST_OCCURRENCE_DATE | date | 335,844 | 01/02/2016 01:00:00 AM | 07/21/2021 12:52:00 PM |
REPORTED_DATE | date | 425,965 | 01/02/2016 01:00:00 AM | 07/21/2021 12:52:00 PM |