Edmonton's Citizen Dashboard

Close
Author
schafer.cal
Description
Statistics Canada's Weighted Clearance Rate for the top 20 largest Canadian Cities. The Weighted Clearance Rate (WCR) measures the percentage of police reported criminal incidents that are cleared by charge, or cleared by "other" (e.g., using the Youth Criminal Act, the accused is deceased), weighted by crime severity. Source: Statistics Canada, tables 252-0083 to 252-0090; 2011 Census. http://www5.statcan.gc.ca/subject-sujet/result-resultat?pid=2693&id=2102&lang=eng&type=ARRAY&pageNum=1&more=0 http://www12.statcan.gc.ca/census-recensement/2011/dp-pd/hlt-fst/pd-pl/Table-Tableau.cfm?LANG=Eng&T=301&S=3&O=D
Tags
eps, edmonton police service, police, police statistics, police data, eps statistics, clearance rates, weighted clearance rates, weighted clearance rates across canada, police comparison, statistics canada, solving crime
Rating
Current value: 0 out of 5
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

City_or_Region
city_or_region
1998
wcr_1998
1999
wcr_1999
2000
wcr_2000
2001
wcr_2001
2002
wcr_2002
2003
wcr_2003
2004
wcr_2004
2005
wcr_2005
2006
wcr_2006
2007
wcr_2007
2008
wcr_2008
2009
wcr_2009
2010
wcr_2010
2011
wcr_2011
2012
wcr_2012
2013
wcr_2013
2014
wcr_2014
2015
wcr_2015
2016
_2016
2017
_2017

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.