This git repository contains the code for covid analysis of USA counties. We have an etl script which loads data every day and an exposed api that provides details at zipcode and day level
- Python version used is 3.7
- Pipenv is used for python package management
- Python Packages required our specified in Pipfile
bash docker_start.sh etl.py
or
python etl.py
bash docker_start.sh "etl.py history"
or python etl.py history
bash docker_start.sh covid_api.py
or python covid_api.py
We find an exact match to county mapping and zip belongs to only one county. Observe that esitmated cases is
less than cases in counties because it is divided by number of zipcodes in the county to estimte zipcode level data
We find no match to county mapping and cannot find the populatin and therefore rate is null. Zip belongs to only one county. Observe that esitmated cases is
less than cases in counties because it is divided by number of zipcodes in the county to estimte zipcode level data
When we find no mapping for counties or no mapping because respective dates are missing, then estimated cases and rate values are null
When we find a zip lies in multiple counties, we multiply and sum over the tot_ration to get estimated counts