Data Dictionary

ID
REPORT_YEAR
Type
int4
Description

Year crime was reported

ID
DIVISION
Type
text
Description

Geographic division where crime took place

ID
CATEGORY
Type
text
Description

Crime category

ID
SUBTYPE
Type
text
Description

Crime category subtype

ID
COUNT_
Type
text
Description

Total number of crimes

ID
COUNT_CLEARED
Type
text
Description

Total number of crimes identified as cleared

Additional Information

Field Value
Data last updated June 30, 2025
Metadata last updated July 29, 2026
Created June 30, 2025
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '40cdf222-1f15-44b0-bf13-d825a9ae7df6', 'XML': 'e02be690-a153-4e37-ae32-b6a423bdc076', 'JSON': 'd8a1d0a2-1a4f-4f3f-807c-e36cafc3f78c'}
Datastore cache last update1 month ago
Extract jobAirflow - files_to_datastore.py - police-annual-statistical-report-reported-crimes
Has viewsTrue
Id5d04d510-88cb-4b48-8311-94b3e155e100
Is previewTrue
Package idb57e23b8-fd0d-4655-8cb5-0930b98ff59c
Position0
Record count47,099
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - police-annual-statistical-report-reported-crimes
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID