Data Dictionary

Column Type Label Description
EVENT_UNIQUE_ID text

Offence Number

REPORT_DATE date

Date Offence was Reported

OCC_DATE date

Date of Offence

REPORT_YEAR text

Year Offence was Reported

REPORT_MONTH text

Month Offence was Reported

REPORT_DAY text

Day of the Month Offence was Reported

REPORT_DOY text

Day of the Year Offence was Reported

REPORT_DOW text

Day of the Week Offence was Reported

REPORT_HOUR text

Hour Offence was Reported

OCC_YEAR text

Year Offence Occurred

OCC_MONTH text

Month Offence Occurred

OCC_DAY text

Day of the Month Offence Occurred

OCC_DOY text

Day of the Year Offence Occurred

OCC_DOW text

Day of the Week Offence Occurred

OCC_HOUR text

Hour Offence Occurred

DIVISION text

Police Division where Offence Occurred

LOCATION_TYPE text

Location Type of Offence

PREMISES_TYPE text

Premises Type of Offence

UCR_CODE text

UCR Code for Offence

UCR_EXT text

UCR Extension for Offence

OFFENCE text

Title of Offence

MCI_CATEGORY text

MCI Category of Occurrence

HOOD_158 text

Identifier of Neighbourhood using City of Toronto's new 158 neighbourhood structure

NEIGHBOURHOOD_158 text

Name of Neighbourhood using City of Toronto's new 158 neighbourhood structure

HOOD_140 text

Identifier of Neighbourhood using City of Toronto's old 140 neighbourhood structure

NEIGHBOURHOOD_140 text

Name of Neighbourhood using City of Toronto's old 140 neighbourhood structure

LONG_WGS84 float8

Longitude coordinate

LAT_WGS84 float8

Latitude coordinate

Additional Information

Field Value
Data last updated 2022 मे 5
Metadata last updated 2025 जनवरी 27
Created 2022 मे 5
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '863bbdfb-a932-48b7-8a59-bf6585ef0563', 'XML': 'bca645b7-2b2f-4724-8610-50e181141c4c', 'JSON': 'd6a031c2-9bd9-4a63-923b-ba9eb0effc22'}
Datastore cache last update4 महिना पहिले
Extract jobAirflow - files_to_datastore.py - major-crime-indicators
Has viewsTrue
Idaf452875-cfdd-4596-a08a-7b93b65ea4f0
Is previewTrue
Package idmajor-crime-indicators
Package name or idmajor-crime-indicators
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - major-crime-indicators
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID