Too few countries have country-wide recovered counts

[winwiz1]

Hi Team,

The output of this statement in BigQuery

SELECT COUNT(DISTINCT country_name)
from bigquery-public-data.covid19_open_data.covid19_open_data
UNION ALL
SELECT COUNT(DISTINCT country_name) 
FROM bigquery-public-data.covid19_open_data.covid19_open_data
WHERE aggregation_level = 0 AND cumulative_recovered IS NOT NULL
UNION ALL
SELECT COUNT(DISTINCT country_name) 
FROM bigquery-public-data.covid19_open_data.covid19_open_data
WHERE aggregation_level = 1 AND cumulative_recovered IS NOT NULL

shows there are 248 countries with 22 countries having recovery data on state/province level and 9 countries having country-wide recovery counts. Understandably not all countries make the data available but still the 9 countries are too few.

For Australia the relevant information is available from:

• First link
• Second link