COVID-19

This is a Python command-line application developed using the Cement framework as the missing CSV export feature for the OC Health Care Agency's COVID-19 dashboard.

I use it to help maintain this COVID-19 spreadsheet:

OC COVID-19 Data v2

I've also added a dashboard with key trends I follow here:

https://klenwell.github.io/covid-19/

Installation

Using pyenv, install Python version 3.8.x. (3.8.1 is the version I used):

pyenv install 3.8.1
Clone repository:

git clone git@github.com:klenwell/covid-19.git
Set Python version:

cd covid-19 pyenv local 3.8.1
Install dependencies:

pip install -r requirements.txt

Usage

Export Current Data

To export the latest Orange County COVID-19 data from the OC Health Care Agency:

python app.py oc daily-v2

When successful, it will generate a CSV files for case and immunity data and output something like this:

OC Daily COVID-19 Data Export v2
================================
## Data
CSV Path: /home/klenwell/projects/covid-19/data/oc/oc-hca.csv
Runtime: 10.480208396911621 s

Start Date: 2020-01-22
End Date: 2022-05-06
Rows: 836

## Immunity
CSV Path: /home/klenwell/projects/covid-19/data/oc/oc-immunity.csv
Runtime: 1.9219765663146973 s

Infectious: 9570.0
Recovered:  720266.0666666667
Vaccinated: 1117160.3205555559

Start Date: 2020-01-22
End Date: 2022-05-06
Rows: 836

Testing

I haven't given much attention to tests. At this time, there are a few tests focused mainly on making quick fixes for breaking changes in page source formatting.

To run the full test suite:

nosetests

Development

The app comes packaged with flake8 for style guide enforcement. Before commiting any code, please run flake8 and correct any reported issues:

# Bad: needs to be fixed
$ cd covid-19
$ flake8
./app.py:7:1: E302 expected 2 blank lines, found 1

# Good: no output
$ flake8

Please feel free to submit pull requests and file bugs on the issue tracker. This is a hobby project of mine so I cannot guarantee a prompt response.