Crime Statistics - Crime Severity Index

The dataset includes crime statistics at the provincial and police service levels. It is based on police reported incidents of crime reported through the Uniform Crime Reporting Survey (UCR). Statistics include the crime severity index, violent crime severity index, and non-violent crime severity index overall for provincial and police service levels. The Youth Crime Severity Index is based on the same principles as the overall Crime Severity Index, which reflects the seriousness of offences, but uses the number of youths accused instead of an incident count. Statistics included are: youth crime severity index, youth violent crime severity index and youth non-violent crime severity index for provincial level data only. 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-crime-severity-index-w64p-5ue3\".\"crime_statistics_crime_severity_index\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.