search

open-covid-19 / data

Daily time-series epidemiology and hospitalization data for all countries, state/province data for 50+ countries and county/municipality data for CO, FR, NL, PH, UK and US. Covariates for all available regions include demographics, mobility reports, government interventions, weather and more.
https://open-covid-19.github.io/explorer
Apache License 2.0
276 stars 63 forks source link

Too few countries have country-wide recovered counts #309

Open winwiz1 opened 4 years ago

winwiz1 commented 4 years ago

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: