Motor Vehicle Collisions with KSI Data
Dataset description:
This dataset includes all traffic collisions events where a person was either Killed or Seriously Injured (KSI) since 2006
Source: Motor Vehicle Collisions involving Killed or Seriously Injured Persons
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| ACCNUM | text | Accident Number |
|
| DATE | date | Date Collision Occurred |
|
| TIME | text | Time Collision Occurred |
|
| STREET1 | text | Street Collision Occurred |
|
| STREET2 | text | Street Collision Occurred |
|
| OFFSET | text | Distance and direction of the Collision |
|
| ROAD_CLASS | text | Road Classification |
|
| DISTRICT | text | City District |
|
| ACCLOC | text | Collision Location |
|
| TRAFFCTL | text | Traffic Control Type |
|
| VISIBILITY | text | Environment Condition |
|
| LIGHT | text | Light Condition |
|
| RDSFCOND | text | Road Surface Condition |
|
| ACCLASS | text | Classification of Accident |
|
| IMPACTYPE | text | Initial Impact Type |
|
| INVTYPE | text | Involvement Type |
|
| INVAGE | text | Age of Involved Party |
|
| INJURY | text | Severity of Injury |
|
| FATAL_NO | text | Sequential Number |
|
| INITDIR | text | Initial Direction of Travel |
|
| VEHTYPE | text | Type of Vehicle |
|
| MANOEUVER | text | Vehicle Manouever |
|
| DRIVACT | text | Apparent Driver Action |
|
| DRIVCOND | text | Driver Condition |
|
| PEDTYPE | text | Pedestrian Crash Type - detail |
|
| PEDACT | text | Pedestrian Action |
|
| PEDCOND | text | Condition of Pedestrian |
|
| CYCLISTYPE | text | Cyclist Crash Type - detail |
|
| CYCACT | text | Cyclist Action |
|
| CYCCOND | text | Cyclist Condition |
|
| PEDESTRIAN | text | Pedestrian Involved In Collision |
|
| CYCLIST | text | Cyclists Involved in Collision |
|
| AUTOMOBILE | text | Driver Involved in Collision |
|
| MOTORCYCLE | text | Motorcyclist Involved in Collision |
|
| TRUCK | text | Truck Driver Involved in Collision |
|
| TRSN_CITY_VEH | text | Transit or City Vehicle Involved in Collision |
|
| EMERG_VEH | text | Emergency Vehicle Involved in Collision |
|
| PASSENGER | text | Passenger Involved in Collision |
|
| SPEEDING | text | Speeding Related Collision |
|
| AG_DRIV | text | Aggressive and Distracted Driving Collision |
|
| REDLIGHT | text | Red Light Related Collision |
|
| ALCOHOL | text | Alcohol Related Collision |
|
| DISABILITY | text | Medical or Physical Disability Related Collision |
|
| HOOD_158 | text | Unique ID for City of Toronto Neighbourhood (new) |
|
| NEIGHBOURHOOD_158 | text | City of Toronto Neighbourhood name (new) |
|
| HOOD_140 | text | Unique ID for City of Toronto Neighbourhood (old) |
|
| NEIGHBOURHOOD_140 | text | City of Toronto Neighbourhood name (old) |
|
| DIVISION | text | Toronto Police Service Division |
|
| geometry | text |
Additional Information
| Field | Value |
|---|---|
| Data last updated | January 27, 2023 |
| Metadata last updated | March 27, 2025 |
| Created | January 27, 2023 |
| Format | GeoJSON |
| License | License not specified |
| Datastore active | True |
| Datastore cache | {'CSV': {'4326': 'fdb2834f-3a92-41dd-b098-fbd84acb9cfe', '2952': '7ab6c611-e56d-44ad-b457-288169d59f89'}, 'SHP': {'4326': 'c5ad6fba-46b2-40e8-a8d6-b6e4df7328c8', '2952': 'fddc5066-fe94-4c1f-a39e-8bcecd947312'}, 'GPKG': {'4326': '1de0f8b3-c29b-473b-bd4a-d6af4c9d3376', '2952': 'eb56a12f-fe43-4856-bbfb-eb6e2ec29530'}, 'GEOJSON': {'4326': '355d4464-eb3c-4780-af79-43dd533ae906'}} |
| Datastore cache last update | 7 months ago |
| Extract job | Airflow - files_to_datastore.py - motor-vehicle-collisions-involving-killed-or-seriously-injured-persons |
| Has views | True |
| Id | c9b88f1f-863e-42f1-ada0-2c09b1e2eaa4 |
| Is preview | True |
| Package id | 0b6d3a00-7de1-440b-b47c-7252fd13929f |
| Package name or id | motor-vehicle-collisions-involving-killed-or-seriously-injured-persons |
| Position | 0 |
| State | active |
| Url type | datastore |
| Extract Job | Airflow - files_to_datastore.py - motor-vehicle-collisions-involving-killed-or-seriously-injured-persons |
| Is Datastore Cache File? | |
| Datastore Cache |
|
| Datastore Cache Last Updated | |
| Datastore resource's ID |