Update US case counts source

Question

Update US case counts source

Opened this issue 2 years ago · 3 comments

Our current US case count source was no longer updated as of 10/20/2022.

There is a new CDC data source, but this reports cases by week instead of by day.

Answer 1 · 2023-01-05T17:58:29.000Z

I did not notice the US case counts was no longer updated because the automated pipeline only notifies when the upload has updated the file on S3. It does not send notifications when the file is identical to the S3 file. This should be changed so that we get alerted if the case counts do not get updated.

Answer 2 · 2023-01-06T00:25:48.000Z

Alternative sources:

NYTimes has a public repo for US case counts, but the daily counts are cumulative
John Hopkins has a public repo for case counts, with US case counts split by county and wide date columns with daily counts that are cumulative

Answer 3 · 2023-01-06T04:19:38.000Z

I'd recommend the NYT's case data. Their us-states.csv seems to be basically exactly what we need other than just taking a diff for cases between consecutive days.