Edmonton's Citizen Dashboard

Close
Author
Andrew
Description
There are more collisions in the winter months due to weather and road conditions. However, the number of injury and fatal collisions stays constant through the year; a greater percentage of collisions in the summer months result in injury and fatality.Friday is the most common day of the week for collisions.
Category
Transportation
Rating
Current value: 0 out of 5
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ID
id
MONTH
month
YEAR
collision_report_year
DateTime
report_period
POPULATION
population
NUMBER_INJURIES
number_injuries
INJURIES_PER_1000
injuries_per_1000
TARGET_INJURY_RATE
target_injury_rate

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.