This repository contains the data for and documents the process used to generate the Tableau visualisation for the prevalence of COVID across North Carolina Counties from May - Oct 2020.
- Data was taken from the NCDHHS.gov website, under the "County-Daily Cases and Deaths Metrics" as an excel file.
- Excel file for demographics for NC County Populations taken from here
- Excel file for fibs codes taken from simple Google search
Using R,
- The original daily cases were summed into groups by month and county
- The population data was added to the counties using an outer join, and the rate (cases/population) for each month calculated
- Saving the dataframe as an Excel file, Tableau was used to visualise the data
- County column insufficient on its own in Tableau, extra research from here helped in adding fibs and State columns. fibs data added to excel using outer join in R.
This project was inspired by https://github.com/huishun98/SG-COVID-data