- I want to do the comparison of %age of races being shoot vs %age of races presents in each county of US.
- I want to identify counties where a particular racial group experiences a disproportionate number of shootings despite not being the majority of the population
- For this analysis, I need the population by race and year. I have found out a site https://data.census.gov/, that provides data on different topics like
-
Business and Economy
-
Education
-
Employment
-
Families and Living Arrangements
-
Government
-
Health
-
Housing
-
Income and Poverty
-
Populations and People
-
Race and EthnicityWith respect to different geographies:
-
Nation
-
State
-
County
-
County Subdivision
-
Place
-
ZIP Code Tabulation Area
-
Metropolitan/Micropolitan Statistical Area
-
Census Tract
-
Block Group
-
All Geographies
-
-
- Census.gov has also provided an API to access the data programmatically, here I am provided the link to the documentation:
API Documentation: https://www.census.gov/data/developers/guidance/api-user-guide.html - Currently, I am exploring the API documentation and one more direction does income, and poverty has any effect on county where non-majority races are shot more often.
- I found 1 record disturbing, that a young black woman who was identified as mentally ill, unarmed and was not trying to flee was alsosh shot in Illinois. The agency that shot the woman has just 1 record of shooting only.
| id | date | threat_type | flee_status | armed_with | city | county | state | latitude | longitude | location_precision | name | age | gender | race | race_source | was_mental_illness_related | body_camera | agency_ids |
| 10693 | 6/7/2024 | not | unarmed | Springfield | Sangamon | IL | 39.76468314 | -89.63039384 | block | Sonya Massey | 36 | female | B | photo | TRUE | TRUE | 23443 |