Occupational Health and Safety: City of Edmonton Injuries

Data from https://www.alberta.ca/employer-records-using-database.aspx.

This data is sourced from the Government of Alberta website; commercial use may require their permission. Please see https://www.alberta.ca/disclaimer.aspx.

Note that data for 2014 to 2018 is also available from https://open.alberta.ca/dataset/employer-records/resource/ba3b3ae4-ffb7-4b41-9fce-49de2a58ccb2; license at https://open.alberta.ca/licence.

The source website also notes that there’s good comparability of the 5-year snapshot of employer injury claims and rate statistics released by Alberta Labour and Immigration with those released directly by WCB. However, small methodological and coverage differences exist due to differing business reporting requirements. For these reasons, statistics released by the ministry and by the WCB are not expected to be identical. Consideration of when the data were last updated should also be noted by the users of this report.

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 \"edmonton-ca/occupational-health-and-safety-city-of-edmonton-kag4-4vma\".\"occupational_health_and_safety_city_of_edmonton\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.