search

MelbourneDeveloper / COVID-19-DB

COVID-19 database generated from Johns Hopkins CSSE data
Other
8 stars 0 forks source link

Sum of NewCases Doesn't Add Up #7

Closed MelbourneDeveloper closed 4 years ago

MelbourneDeveloper commented 4 years ago

Run Note: replace location with Australia Victoria LocationId

select sum(newcases) from locationdays where locationid = '85381984-ECAC-448F-B392-6A5BE4509D53'

The value doesn't add up to the last confirmed value for Victoria