Pre-processing notebooks

[hdrake]

Ideally there would be a handful of jupyter notebooks that produce a csv spreadsheet where each row is an entry for a specific region on a specific date and columns that correspond to:

Spatial data

• [x] Country (for aggregating purposes)

Epidemiological data

• [x] Positive/Confirmed Cases
• [ ] Tests
• [ ] Hospitalizations
• [x] Recovered Cases
• [x] Deaths

Environmental data

• [x] Near-surface air temperature
• [ ] Ground temperature
• [x] Specific humidity
• [ ] Relative humidity
• [ ] Absolute humidity
• [x] Incident solar flux
• [x] Incident solar UV flux
• [ ] Surface wind speed (?)
• [x] Sea level pressure (?)

Demographics

• [ ] Population
• [ ] Population density
• [ ] Gross Domestic Product (or proxy)

Policy response

• [ ] Proxy for mobility
• [ ] Enacted policies (perhaps as Boolean 0 or 1 entries, see the Global Policy Lab's repo)

[hdrake]

Started a template for aggregating epidemiological and environmental data: https://github.com/COVID-Weather/covid-environmental-factors/blob/dd3fe7befbe8a2502662bb78a5db4f35e8001d00/notebooks/T_preprocess_state-level_UStest.ipynb

[hdrake]

Made a ton of progress on environmental data in https://github.com/COVID-Weather/covid-environmental-factors/pull/18