Data Dictionary

ID
EVENT_UNIQUE_ID
Typ
text
Beskrivning

Offence Number

ID
REPORT_DATE
Typ
date
Beskrivning

Date Offence was Reported

ID
REPORT_YEAR
Typ
float8
Beskrivning

Year Offence was Reported

ID
REPORT_MONTH
Typ
text
Beskrivning

Month Offence was Reported

ID
REPORT_DOW
Typ
text
Beskrivning

Day of the Month Offence was Reported

ID
REPORT_DOY
Typ
float8
Beskrivning

Day of the Year Offence was Reported

ID
REPORT_DAY
Typ
float8
Beskrivning

Day of the Week Offence was Reported

ID
REPORT_HOUR
Typ
float8
Beskrivning

Hour Offence was Reported

ID
OCC_DATE
Typ
date
Beskrivning

Date of Offence

ID
OCC_YEAR
Typ
float8
Beskrivning

Year Offence Occurred

ID
OCC_MONTH
Typ
text
Beskrivning

Month Offence Occurred

ID
OCC_DOY
Typ
float8
Beskrivning

Day of the Month Offence Occurred

ID
OCC_DAY
Typ
float8
Beskrivning

Day of the Year Offence Occurred

ID
OCC_DOW
Typ
text
Beskrivning

Day of the Week Offence Occurred

ID
OCC_HOUR
Typ
float8
Beskrivning

Hour Offence Occurred

ID
DIVISION
Typ
text
Beskrivning

Police Division where Offence Occurred

ID
PREMISES_TYPE
Typ
text
Beskrivning

Premises Type of Offence

ID
APPREHENSION_TYPE
Typ
text
Beskrivning

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

ID
SEX
Typ
text
Beskrivning

Sex of Person Apprehended

ID
AGE_COHORT
Typ
text
Beskrivning

Age category of Person Apprehended

ID
HOOD_158
Typ
text
Beskrivning

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

ID
NEIGHBOURHOOD_158
Typ
text
Beskrivning

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

ID
HOOD_140
Typ
text
Beskrivning

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

ID
NEIGHBOURHOOD_140
Typ
text
Beskrivning

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

Mer information

Fält Värde
Data senast uppdaterad 30 juni 2025
Metadata senast uppdaterad 23 april 2026
Skapad 30 juni 2025
Format CSV
Licens 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 updateför 1 månad sedan
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
Record count134 457
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