Data Update #3

Based on Chad's feedback from Update 2, I agree that the previous 19 rows of data I had for my data slice is a weird number, so I narrowed my set to 12 rows of data for my bar chart. I found this to be more concise and it made the bar chart easier to read. I highlighted Hamilton, Ontario and made the representing bar a different colour to stand out among the other cities in the data. 

 

Chart:

Unanswered Question: 

Looking at my chart, 7/12 of the cities are from Ontario. My unanswered question is, why do Ontario cities have the highest rate of police-reported hate crime in 2019, compared to the other provinces? 

How would I get the data?

Since this dataset is based on police-reported incidents, a possibility is that Ontario may just be better at reporting hate crime incidents, compared to other provinces. To find out this data, I will do further research, hopefully getting more data from Ontario's open data portal about crime. I will also try to find out if Ontario has strong resources that help victims/make victims feel more comfortable with coming forward and reporting incidents as such, which could be a reason to the higher numbers in that province.

Data Update #2

Lead:

Hamilton, Ontario had the highest rate of police-reported hate crime in Canada during 2019, according to Statistics Canada.

Excel Workbook Link and Explanation:

 
https://docs.google.com/spreadsheets/d/1pmTnl5EUYB6h-RIubeuhRDDseq6buwHPV-CZb60AC0o/edit?usp=sharing 

The raw data is just as I downloaded from the Statistics Canada website. It contains the rates of police-reported hate crimes in the Census Metropolitan Areas, during the years of 2014 to 2019. My small data slice shows the top 20 cities with the highest rates of hate crime, showing that Hamilton has the highest among the rest of the cities. When I compared each year, I noticed that Hamilton very frequently has always had the highest rate since 2014.

Original Dataset Link:

https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510019101&cubeTimeFrame.startYear=2014&cubeTimeFrame.endYear=2019&referencePeriods=20140101%2C20190101

Based on the feedback from Update 1, I agree with Chad that the previous dataset I chose is difficult to extract data from since it's simply a list of locations. I chose another dataset, which I feel I'm likely to have more to work with for my Final Data Report.

Study Link and Brief Summary:

https://www.toronto.com/news-story/10282846-hamilton-hate-crime-numbers-may-not-tell-the-whole-story/

In this news story, Mac Christie writes about how Hamilton's hate crime rates could actually be much higher than what is mentioned because most cases are under-reported. This news story is relevant to my data because it covers the issue of Hamilton having the highest rate of police-reported hate crimes in Canada and gives me some idea to why the rates are high in that city. Christie mentions that in 2019, the Hamilton Police service said that out of 92 hate/bias events reported, only eight were labelled a hate/bias crime. I found that quite shocking and later on he also mentions that out of the 92 events reported, a true number is likely over 250. This article also mentions that in general, Hamilton hasn't taken hate crimes or racism seriously in the past, which I feel like that could be a big factor as to why the rates are so high now.