Comparing the infection, testing, and vaccination rates between the incarcerated population and general population per county in California.
We created our general population dataset from three California Department of Public Health (CDPH) sources: (1) COVID-19 Cases and Tests Data, (2) COVID-19 Hospitalizations Data, and (3) COVID-19 Vaccinations Data.
Here is the code documentation for how data from each source was pulled, cleaned, and merged together into the final dataframe (general_population.csv). Additionally, we included concerns on missing data and methodology from each dataset. Here is the documentation of each source, including which columns were chosen, their definitions, and additional clarifying information.
Please contact info@covidincustody.org for any questions or concerns.
There are no prerequisites or installation required. Data from all sources will be pulled directly from the webpage, and an output csv (general_population.csv) will be stored in the same directory as utils.py and run.py. Once both code files are downloaded, please run the following:
python3 run.py