calgary-ca/community-crime-statistics-78gh-n26t
Icon for Socrata external plugin
 
Readme
Updated 12 days ago
Indexed 3 hours ago

Community Crime Statistics

Data is provided monthly by the Calgary Police Service. This data is considered cumulative as late-reported incidents are often received well after an offence has occurred. Therefore, crime counts are subject to change as they are updated.

Crime count is based on the most serious violation (MSV) per incident. Violence: These figures include all violent crime offences as defined by the Centre for Canadian Justice Statistics Universal Crime Reporting (UCR) rules. Domestic violence is excluded. Break and Enter: Residential B&E includes both House and ‘Other’ structure break and enters due to the predominantly residential nature of this type of break in (e.g. detached garages, sheds). B&Es incidents include attempts.

Resident counts are pulled from the latest census data, and therefore undergo a change when new census data is collected and made available (typically in the summer).

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 \"calgary-ca/community-crime-statistics-78gh-n26t\".\"community_crime_statistics\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • community_crime_statistics
     
Upstream Metadata