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 2025 जुन 30
Metadata last updated 2025 अगस्ट 7
Created 2025 जुन 30
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 update2 हप्ता पहिले
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