I wrote python script to fetch Ethnicity and Race data of all counties for year 2015-2023 from data.census.gov using API key.
I transformed the data and calculated race distribution of races in each county per year.
In Washington police shooting data, there were 4692 records where county was missing. I impute the counties with the help of “geopy” library with city and state fields in data.
I transformed the Washington police shooting data and calculated shot race distribution of races in each county per year.
Next steps will be working on how to compare them to have a better idea of counties where a particular racial group experiences a disproportionate number of shootings despite not being the majority of the population.
