Data Dictionary

Column Type Label Description
EVENT_UNIQUE_ID text

Offence Number

REPORT_DATE date

Date Offence was Reported

REPORT_YEAR float8

Year Offence was Reported

REPORT_MONTH text

Month Offence was Reported

REPORT_DOW text

Day of the Month Offence was Reported

REPORT_DOY float8

Day of the Year Offence was Reported

REPORT_DAY float8

Day of the Week Offence was Reported

REPORT_HOUR float8

Hour Offence was Reported

OCC_DATE date

Date of Offence

OCC_YEAR float8

Year Offence Occurred

OCC_MONTH text

Month Offence Occurred

OCC_DOY float8

Day of the Month Offence Occurred

OCC_DAY float8

Day of the Year Offence Occurred

OCC_DOW text

Day of the Week Offence Occurred

OCC_HOUR float8

Hour Offence Occurred

DIVISION text

Police Division where Offence Occurred

PREMISES_TYPE text

Premises Type of Offence

APPREHENSION_TYPE text

The section applied when apprehending an individual pursuant to the Mental Health Act

SEX text

Sex of Person Apprehended

AGE_COHORT text

Age category of Person Apprehended

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

Additional Information

Field Value
Data last updated Hunyo 30, 2025
Metadata last updated Hunyo 30, 2025
Created Hunyo 30, 2025
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '3b19464b-42b1-4687-a9f4-647aa9f7d1ab', 'XML': 'ad9f37a4-ec63-4155-bb53-b95df5550665', 'JSON': 'a4c01552-0e8a-4304-93a4-a6de4a028a28'}
Datastore cache last update3 linggo ang nakalipas
Extract jobAirflow - files_to_datastore.py - mental-health-apprehensions
Has viewsTrue
Id51defc26-a141-4f5c-bb6b-11c4cb153c39
Is previewTrue
Package idf49d6bef-1560-47b2-b4ad-c5fd3bb8f491
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - mental-health-apprehensions
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID