[OR] Add missing data points via state data reports?

[MattHilliard]

State or US: OR

Describe the problem We have a fair number of days without new data in various columns for OR. It seems like the "data reports" (below the press releases on the linked page) may allow filling in some of this data but I haven't investigated yet.

Link to data source https://www.oregon.gov/oha/erd/pages/covid-19-news.aspx "Data Reports" section

[MattHilliard]

I looked at days we had no negative tests and found of the 15 days we don't have an updated data point, 6 of them can be repaired using OR data reports:

No data report available: 7/4, 6/28, 6/26, 6/20 Data reports available: 5/14, 5/12, 4/28, 4/10, 4/4, 4/1 Data report available but no test data: 4/22 Dates preceding data report horizon of 3/26: 3/25, 3/21, 3/14, 3/12

Some of those days have other data missing as well, e.g. positive cases or hospitalization.

[terwilliger42]

Thanks a lot @MattHilliard !!

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions!

[stale[bot]]

This issue has been closed because it was stale for 15 days, and there was no further activity on it for 10 days. You can feel free to re-open it if the issue is important, and label it as "not stale."

[muamichali]

On 12/9/2020 we backfilled Oregon's entire time-series of positiveTestsViral,totalTestsViral,negativeTestsViral from a table published on their website. This renders moot the proposal to repair testing numbers from the daily reports. https://github.com/COVID19Tracking/issues/issues/997

Following Matt's process above for the days where we do not have updates to Positive, Negative and Deaths https://docs.google.com/spreadsheets/d/1WRGREjxxj-s-_61Tb2VZhoSmKlWkNtMmj9t9Is7WeRg/edit#gid=0

[muamichali]

The changes above were performed in two batches. Info below: Changes (5).txt Changes (4).txt