Assignment 2 – Zhong
By Zhiyan Zhong
February 27, 2017
Most hate crimes in New York State from 2010 to 2015 were against Jewish people, according to the dataset of hate crimes by county and bias type published by the New York State government.
Of the 3,671 hate crimes from 2010 to 2015 in New York State, 1442, about one quarter, were motivated by bias against Jews. Black people were also main victims of those hate crimes, with 670 against them during the six years. Hate crimes against the LGBT group also took a large percentage of the total incidents, with 548 targeting male-homosexuals.
In New York State, Kings is the county that had the largest number of hate crimes. About one fifth of the hate crimes happened there. New York had 522 hate crimes during those six years.
I found these dramatic numbers and trends mainly using Excel. I created a Pivot Table first and set county names as row labels. I also summed up the number of each type of crimes in the table. Then I arranged data in descending order and found out the most common types of hate crimes. To find out what counties had most hate crimes, I created another Pivot Table with county names as row labels and the total of crimes in each county as values. Besides this, I also did some calculations, filtering and sorting to ensure what I found above was correct.