Data Dictionary

ID
EVENT_UNIQUE_ID
Typ
text
Beskrivning

Offence Number

ID
OCCURRENCE_YEAR
Typ
text
Beskrivning

Year Offence Occurred

ID
OCCURRENCE_DATE
Typ
date
Beskrivning

Date Offence Occurred (time is displayed in UTC format when downloaded as a CSV)

ID
OCCURRENCE_TIME
Typ
text
Beskrivning

Time of Day Offence Occurred

ID
REPORTED_YEAR
Typ
text
Beskrivning

Year Offence was Reported

ID
REPORTED_DATE
Typ
date
Beskrivning

Date Offence was Reported (time is displayed in UTC format when downloaded as a CSV)

ID
REPORTED_TIME
Typ
text
Beskrivning

Time of Day Offence was Reported

ID
DIVISION
Typ
text
Beskrivning

Police Division where Offence Occurred

ID
LOCATION_TYPE
Typ
text
Beskrivning

Location Type of the Offence

ID
AGE_BIAS
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s age

ID
MENTAL_OR_PHYSICAL_DISABILITY
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s mental or physical disability

ID
RACE_BIAS
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s race.

ID
ETHNICITY_BIAS
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s ethnicity

ID
LANGUAGE_BIAS
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s language

ID
RELIGION_BIAS
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s religion

ID
SEXUAL_ORIENTATION_BIAS
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s sexual orientation

ID
GENDER_BIAS
Typ
text
Beskrivning

A Hate Crime committed on the basis of the Suspect’s perception of the Victim’s gender

ID
MULTIPLE_BIAS
Typ
text
Beskrivning

A Hate Crime with more than one Bias Category

ID
PRIMARY_OFFENCE
Typ
text
Beskrivning

The Offence committed in relation to the Hate Crime.

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

ID
ARREST_MADE
Typ
text
Beskrivning

An entity can be considered arrested when a charge is laid, recommended or the person(s) who committed the offence has been identified and taken into custody for the same.

Mer information

Fält Värde
Data senast uppdaterad 30 juni 2025
Metadata senast uppdaterad 3 juni 2026
Skapad 30 juni 2025
Format CSV
Licens License not specified
Datastore activeTrue
Datastore cache{'CSV': '42f10129-b3d0-42e2-9ca8-18d4587342a7', 'XML': '7a815c1e-6377-44c6-a3e9-f3c5ca6504c1', 'JSON': '15918324-ea42-4845-980c-1ae6c52688c2'}
Datastore cache last updateför 1 dag sedan
Extract jobAirflow: Integration Pipeline hate-crimes-open-data
Has viewsTrue
Idb8066585-a284-4661-8b62-d01955a1f6cd
Is previewTrue
Package id475f27d8-28d6-4858-8ffc-22b092062ff1
Position0
Record count2 041
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline hate-crimes-open-data
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID