dathere / covid19-time-series-utilities

several utilities to help wrangle COVID-19 data into a time-series format
Creative Commons Attribution Share Alike 4.0 International
34 stars 8 forks source link

Compute the COVID-19 values from running total to day-by-day basis #16

Closed jqnatividad closed 4 years ago

jqnatividad commented 4 years ago

Right now, the observations are a running total, which doesn't lend itself to time-series analyses.

Derive the day-by-day value (e.g. 10 people recovered that day for a specific jurisdiction) by subtracting the running total of the previous interval from the current interval.

This will allow us to answer questions like "how many people recovered in the last 2 weeks in this area" and start computing confirmed, deaths, and recovered indices; compute rate of recovery, etc; and do benchmarking across jurisdictions for arbitrary time intervals (e.g. last month, last 3 days, etc.)

I also think this will make the continuous aggregates more useful.

cc @avthars @coolasspuppy @mfreed