Crime Statistics - Incidents and rates for selected offences

The dataset includes incident-based crime statistics at the provincial and police service level. Statistics include the number of incidents of offences and rates per 100,000 population for the following offences: Homicide, Attempted murder , Sexual assault (Levels 1, 2 and 3), Total sexual violations against children, Assault (Levels 1, 2 and 3), Total robbery, Total breaking and entering, Total theft of motor vehicle, Total impaired driving, Total drug violations, Possession (cannabis), Possession, (cocaine), Possession (other Controlled Drugs and Substances Act drugs), Cannabis (trafficking, production or distribution), Cocaine (trafficking, production or distribution), Other Controlled Drugs and Substances Act drugs (trafficking, production or distribution). This data is sourced from Statistics Canada through CANSIM.

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 \"novascotia-ca/crime-statistics-incidents-and-rates-for-selected-m862-kmjy\".\"crime_statistics_incidents_and_rates_for_selected\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.