Values in some graphs are negative

Question

Values in some graphs are negative

Closed this issue 5 years ago · 1 comments

ProfessorStoke commented 5 years ago

Examples:

Negative graph for Alaska on April 14th 2020 shows a value of -213
Deaths graph for Colorado on May 14th 2020 shows a value of -213
Negative graph for Connecticut on June 23 2020 shows a value of -1,608
Negative graph for DC on May 24th 2020 shows a value of -11,447

Answer 1 · 2020-07-09T04:53:27.000Z

These look to be data reporting errors by each state, as per https://covidtracking.com/data. Some examples:

Connecticut: "On June 24, CT removed 2770 previously reported tests due to correction of a data error. Negatives decreased as a result."
DC: "Total tests reported by DC dropped by about 11,000 from 5/24 to 5/25."

In any case, this does make the graphs harder to interpret, so we should add some defensive checks. I added a way to turn these negative values to 0 so they won't detract from the spark chart: 9f8a0b7.