Data Dictionary

Column Type Label Description
EVENT_UNIQUE_ID text

Offence Number

OCC_DATE text

Date of Offence

OCC_YEAR text

Year Offence Occurred

OCC_MONTH text

Month Offence Occurred

OCC_DAY text

Day of the Month Offence Occurred

OCC_DOW text

Day of the Week Offence Occurred

OCC_DOY text

Day of the Year Offence Occurred

DIVISION text

Police Division where Offence Occurred

HOMICIDE_TYPE text

Type of Homicide (Shooting, Stabbing, Other)

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

geometry text

Additional Information

Field Value
Data last updated October 11, 2022
Metadata last updated March 27, 2025
Created October 11, 2022
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': 'f7076075-31c8-4dca-a3ce-967b887e511f', '2952': '4a1defe0-7f2a-41e6-a3b8-cea21a126fee'}, 'SHP': {'4326': '86678470-506e-4c97-b124-1568744b20b5', '2952': '8837cd9e-7439-4434-ba61-3f4a6a8c4caa'}, 'GPKG': {'4326': 'ca05b596-d5cf-4e85-8585-4351478de126', '2952': '08733dfd-3c6a-47d8-b559-a8c6fa14bf0b'}, 'GEOJSON': {'4326': 'ee1aa75f-7070-4344-9f47-4f6053ac31d7'}}
Datastore cache last update1 month ago
Extract jobAirflow - files_to_datastore.py - police-annual-statistical-report-homicide
Has viewsTrue
Id559d4af8-ba23-44ed-916c-10efb6ed95ef
Is previewTrue
Package id7d72bbbe-8adc-4b36-8ad1-5359f1c7a9cc
Package name or idpolice-annual-statistical-report-homicide
Position12
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - police-annual-statistical-report-homicide
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID