Data reconciliation for row 206 of dairy cattle timeline (event labeled 6/28)

globaldothealth / outbreak-data

For users of G.h data: notes, timelines, sources, etc.

MIT License

0 stars 0 forks source link

Data reconciliation for row 206 of dairy cattle timeline (event labeled 6/28) #20

Closed jackie-powers closed 4 months ago

jackie-powers commented 4 months ago

It appears that USDA has backloaded some of their data and our timeline data is not matching the most recent total case count (139) and number of cases for Colorado (27) for dairy cattle. As of 7/1, there was one new case in Colorado, meaning that the Colorado count for the previous report (6/28) should be 26 and the total count should be 138. I also sorted the list by state and determined this as well. If someone could check this that would be great!

jackie-powers commented 4 months ago

When I downloaded the data, a new case (CO 017) appeared for 6/28 which was not originally on our cattle outbreaks tab.

JacqSauer commented 4 months ago

Can be discussed during our meeting this morning, but does the pivot table help with these backlog issues @jackie-powers ? is there another way that might help?