Open k-dhingra93 opened 4 years ago
@k-dhingra93 , you're right. Recoveries are being underreported here. The problem is with the New South Wales record
I can see that the states figures are incorrect when I run this query
select Provinces.Name,
sum(Recoveries) as Recoveries
from locationdays
inner join locations
on locations.id = locationdays.locationid
inner join Provinces
on Provinces.id = locations.ProvinceId
inner join Regions
on Regions.id = Provinces.RegionId
where Regions.Name='Australia'
group by Provinces.Name
State | Recoveries |
---|---|
Australian Capital Territory | 59 |
External territories | 0 |
From Diamond Princess | 0 |
Jervis Bay Territory | 0 |
N/A | |
New South Wales | 4 |
Northern Territory | 2 |
Queensland | 372 |
South Australia | 179 |
Tasmania | 48 |
Victoria | 926 |
Western Australia | 216 |
Generated with this tool
The Australian cases appear to be completely missing now. Not sure what the WA recoveries are at now?
WA cases and recoveries can be found at https://ww2.health.wa.gov.au/Articles/A_E/Coronavirus/COVID19-statistics
New south wales wasn't really reporting data until recently. This data now appears to be up to date. @k-dhingra93 this looks like it should be OK to close.
Cases in Australia have been incorrect for over a week. Aus government provides daily updates of active cases, deaths and recoveries here: https://www.health.gov.au/resources/publications/coronavirus-covid-19-at-a-glance
The data for Aus seems to be very inconsistent with official reports