EPS Impaired Driving Incidents

Impaired Driving measures the number of EPS-reported incidents of impaired driving. The number here uses the number of victims when the incident involves victims. Impaired driving is a leading cause of criminal death in Canada, as well as a significant factor for traffic collision, injuries, and fatalities.

A driver will face a criminal charge of impaired driving when they exceed a Blood Alcohol Concentration (BAC) of 0.08, or when there is other evidence that a driver is impaired. The number of incidents here also includes impairment by narcotics or prescription medication, or when cooperation with testing for alcohol or drugs is refused.

The following UCR2 codes are used for this crime statistic:

9210 Impaired operation - causing death

9215 Impaired operation (drugs) - causing death

9220 Impaired operation - causing bodily harm

9225 Impaired operation (drugs) - causing bodily harm

9230 Impaired operation of motor vehicle, vessel or aircraft

9235 Impaired operation (drugs) vehicle, vessel, aircraft

9240 Impaired operation - failure to provide breath sample

9245 Failure to comply or refusal (drugs)

9250 Impaired operation - failure to provide blood sample

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"dashboard-edmonton-ca/eps-impaired-driving-incidents-6wgz-mm4u\".\"eps_impaired_driving_incidents\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.