Dataset: Traffic Collisions Toronto

About this Dataset

Traffic Collisions Toronto

Summary
This dataset includes all Motor Vehicle Collision (MVC) occurrences by their occurrence date and related offences. The MVC categories include property damage (PD) collisions, Fail to Remain (FTR) collisions, injury collisions and fatalities. This data is provided at the occurrence level, therefore multiple offences and/or victims can be associated with each record. This data does not include occurrences that have been deemed unfounded. The definition of unfounded according to Statistics Canada is: “It has been determined through police investigation that the offence reported did not occur, nor was it attempted” (Statistics Canada, 2020).

In this dataset a collision is defined as the contact resulting from the motion of a motor vehicle or streetcar or its load, which produces property damage, injury or death. The term collision indicates that the initial point of contact involved at least one motor vehicle or streetcar.

Definitions:

Fatal Collisions occur when an individual’s injuries from a MVC result in a fatality within 30 days. Please note this category excludes:

(i) Occurrences on private property

(ii) Occurrences related to sudden death prior to collision (suicide or medical episode)

(iii) Occurrences where the individual has died more than 30 days after the collision

Personal Injury Collisions occur when an individual involved in a MVC suffers personal injuries.

Fail to Remain Collisions occur when an individual involved in a MVC fails to stop and provide their information at the scene of a collision.

Property Damage Collisions occur when an individual’s property has been damaged in a MVC or the value of damages is less than $2,000 for all involved parties.

[1] Statistics Canada. 2020. Uniform Crime Reporting Manual. Surveys and Statistical Programs. Canadian Centre for Justice Statistics.

Tables

Traffic Collisions Toronto Data

@kaggle.andriyahapov_traffic_collisions_toronto.traffic_collisions_toronto_data

13.06 MB
499538 rows
19 columns


CREATE TABLE traffic_collisions_toronto_data (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "eventuniqueid" VARCHAR,
  "occurrencedate" TIMESTAMP,
  "month" VARCHAR,
  "day_of_week" VARCHAR,
  "year" BIGINT,
  "hour" BIGINT,
  "division" VARCHAR,
  "atom" VARCHAR,
  "neighbourhood" VARCHAR,
  "fatalities" BIGINT,
  "injury_collisions" VARCHAR,
  "ftr_collisions" VARCHAR,
  "pd_collisions" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "objectid2" BIGINT
);