search

COVID19Tracking / issues

Repo for issues and administration
45 stars 6 forks source link

[OK] Patch 01/19/21-01/21/21 EOR metrics #1148

Closed hmhoffman closed 3 years ago

hmhoffman commented 3 years ago

State: OK

Dates affected: 01/19/21-01/21/21

Describe the issue: Oklahoma frequently published their executive order reports (EORs) after the time of our daily update, so the metrics we source from them(Total PCR tests (specimens), Positive PCR tests (specimens), Negative PCR tests (specimens), Negative PCR tests (people), Pending, Currently hospitalized, and Currently in ICU) were on a one day lag in our timeseries. Additionally, Oklahoma did not publish EORs on weekends or federal holidays. On January 18, 2021, they did not publish an EOR due to the holiday, and so on January 19, 2021, we should not have had an updated data source for the EOR metrics, and should have carried over the previous days values. However, on January 19, 2021, they released their EOR anomalously early, and we updated our data for January 19, 2021. The EOR for January 20, 2021 was published unusually early as well, and we caught those numbers in our data for January 20, 2021, instead of our numbers for January 21, 2021. As a result, we were unable to update their EOR metrics for January 21, 2020, as the EOR was not published early enough for us to catch it. We are patching their timeseries to ensure that the EOR metrics are consistently on a one-day lag.

hmhoffman commented 3 years ago

Rows edited: 2 OK 2021-01-20 negative: 2642075 (was 2653602) pending: 3664 (was 3976) hospitalizedCurrently: 1776 (was 1722) inIcuCurrently: 474 (was 449) totalTestsViral: 2989880 (was 3002865) positiveTestsViral: 339128 (was 341025) negativeTestsViral: 2642075 (was 2653602) OK 2021-01-19 negative: 2601000 (was 2642075) pending: 4695 (was 3664) hospitalizedCurrently: 1866 (was 1776) inIcuCurrently: 499 (was 474) totalTestsViral: 2943409 (was 2989880) positiveTestsViral: 2943409 (was 339128) negativeTestsViral: 2943409 (was 2642075)