Data Dictionary

ID
EVENT_UNIQUE_ID
Type
text
Beskrivelse

Offence Number

ID
REPORT_DATE
Type
date
Beskrivelse

Date Offence was Reported

ID
OCC_DATE
Type
date
Beskrivelse

Date of Offence

ID
REPORT_YEAR
Type
text
Beskrivelse

Year Offence was Reported

ID
REPORT_MONTH
Type
text
Beskrivelse

Month Offence was Reported

ID
REPORT_DAY
Type
text
Beskrivelse

Day of the Month Offence was Reported

ID
REPORT_DOY
Type
text
Beskrivelse

Day of the Year Offence was Reported

ID
REPORT_DOW
Type
text
Beskrivelse

Day of the Week Offence was Reported

ID
REPORT_HOUR
Type
text
Beskrivelse

Hour Offence was Reported

ID
OCC_YEAR
Type
text
Beskrivelse

Year Offence Occurred

ID
OCC_MONTH
Type
text
Beskrivelse

Month Offence Occurred

ID
OCC_DAY
Type
text
Beskrivelse

Day of the Month Offence Occurred

ID
OCC_DOY
Type
text
Beskrivelse

Day of the Year Offence Occurred

ID
OCC_DOW
Type
text
Beskrivelse

Day of the Week Offence Occurred

ID
OCC_HOUR
Type
text
Beskrivelse

Hour Offence Occurred

ID
DIVISION
Type
text
Beskrivelse

Police Division where Offence Occurred

ID
LOCATION_TYPE
Type
text
Beskrivelse

Location Type of Offence

ID
PREMISES_TYPE
Type
text
Beskrivelse

Premises Type of Offence

ID
UCR_CODE
Type
text
Beskrivelse

UCR Code for Offence

ID
UCR_EXT
Type
text
Beskrivelse

UCR Extension for Offence

ID
OFFENCE
Type
text
Beskrivelse

Title of Offence

ID
CSI_CATEGORY
Type
text
Beskrivelse

CSI Category of Occurrence

ID
HOOD_158
Type
text
Beskrivelse

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

ID
NEIGHBOURHOOD_158
Type
text
Beskrivelse

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

ID
HOOD_140
Type
text
Beskrivelse

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

ID
NEIGHBOURHOOD_140
Type
text
Beskrivelse

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

ID
LONG_WGS84
Type
float8
Beskrivelse

Longitude coordinate

ID
LAT_WGS84
Type
float8
Beskrivelse

Latitude coordinate

Yderligere information

Felt Værdi
Data last updated 4. februar 2026
Metadata last updated 23. april 2026
Oprettet 4. februar 2026
Format JSON
Licens License not specified
Datastore activeTrue
Datastore cache{'CSV': '174089c6-5a1a-42a5-8937-f9f25c72700a', 'XML': '622223ca-34a3-4206-931a-4761c5599c91', 'JSON': '086ae96c-cb4c-4f2a-b637-ffdb3df8836e'}
Datastore cache last updatefor 2 måneder siden
Extract jobAirflow: Integration Pipeline major-crime-indicators
Has viewsTrue
Id11581817-b148-4dd4-99c4-679649515ccc
Is previewTrue
Package id6909ea60-ef0e-465f-b5d0-43106b6b9130
Position3
Record count474.819
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline major-crime-indicators
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID