The constant changing of data features lead to this project eating up too much time to keep updated daily.
The code and data will remain for anyone interested in the full daily dump of numbers in RI up to 9/26/2021.
The goal of this project is to collect the daily data from RIDOH on COVID-19 cases within Rhode Island. The raw data will be saved then cleaned to get daily changes and uploaded to google sheets to automate a Tableau graph. Lastly the change from the previous day & daily totals will be tweeted out automatically by a twitter bot @RI_COVID19.
Created a dashboard to provide information about the status of COVID-19 within Rhode Island. All of the data comes from the google sheet provided & updated by the Rhode Island Department of Health and Federal Agencies CMS and CDC. The goal of this dashboard is to provide a fast loading, mobile friendly option to people wanting a daily digest of COVID-19 information. It contains charts, tables and trackers for schools, nursing homes, vaccinations, deaths, testing and hospitalizations. The website can be found at ivizri.com/covid/.
You must have Python 3 installed. You can download it here.
To automate the sending of tweets you will need to apply for a Twitter Developer account.
This will be the account name sending the tweets, and edit the config with your twitter authentication info.
Lastly to automate the uploading to google sheets you will need to create a google service account.
Then edit the config with the saved location of your service file.
Code is run from the command line by simply typing python main.py
.
The code will wait till 12:05 5 mins after RIDOH reports the numbers, then checks every 15 minutes to see if the google spreadsheet has been updated. Once an update is found the program will again pause for 2 minutes incase the file was currently being updated.
Caution race demographics contains missing info (unknown, pending, refused).
Daily Totals:
- positive cases
- negative cases
- number hospitalized
- related fatalities
- number in intensive care
Demographics:
- gender
- age bin
- race
City/Town Totals:
- city/town
- positive cases
Zip Code Totals:
- zip code
- positive cases
Nursing Home Totals:
- facility name
- high/low range cases
- high/low range fatalities
- facility type
Current dashboards created using the cleaned datasets.
- daily update comparison
- timelines tracking key information
- map of case rate by city/town
- ri nursing home cases/deaths
Current plots created using the cleaned datasets.
- 7-day moving avg: hospitals
- 7-day moving avg: testing
- 14-day trend: hospitals
- 14-day trend: testing
- cities cases rate by 10k
- Spatial Boundaries: RIGIS
- Daily Numbers: RIDOH
- City/Town Breakdown: RIDOH
- City/Town Population: Census 2017 ACS 5-Year Estimates
- Zip Population: Census 2010 Decennial Population
- Nursing Homes: CMS.gov
- Vaccination: CDC.gov