calgary-ca/community-crime-and-disorder-statistics-20122019-848s-4m4z
Icon for Socrata external plugin
 
Readme
Updated 5 months ago
Indexed 2 hours ago

Community Crime and Disorder Statistics (2012-2019)

*Please visit new link for crime statistics data - <a href="https://data.calgary.ca/Health-and-Safety/Community-Crime-Statistics/78gh-n26t">Community Crime Statistics</a>

and this new link for disorder statistics data <a href="https://data.calgary.ca/Health-and-Safety/Community-Disorder-Statistics/h3h6-kgme">Community Disorder Statistics.</a>

Data is provided monthly by the Calgary Police Service. This includes both crime and disorder statistics.

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.

Disorder events consist of Social and Physical disorder. Only public-generated calls are included.

Social disorder includes: Drunk, Disturbance, Indecent Act, Juvenile Complaint, Landlord/tenant, Mental health concern, Neighbor dispute, Party complaint, Prowler, Suspicious person, Threats, Drugs, Noise complaint, Possible gunshots, Unwanted guest/patron, Prostitution, Speeder, Suspicious Auto.

Physical disorder includes: Fire, Property damage and Abandoned auto.

**Resident counts are pulled from census data which is collected Apr/May of each year and apply to community crime stats from June of current year to May of the following year.

ex) 2018 Census data applies to June 2018-May 2019 Community Crime stats

**

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-and-disorder-statistics-20122019-848s-4m4z\".\"community_crime_and_disorder_statistics_20122019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • community_crime_and_disorder_statistics_20122019
     
Upstream Metadata