BigQuery Public Datasets Program
Daily time-series data related to COVID-19 globally
This repository contains the largest COVID-19 epidemiological database available in addition to a powerful set of expansive covariates. It includes open sourced data with a permissive license (enabling commercial use) relating to vaccinations, epidemiology, hospitalizations, demographics, economy, geography, health, mobility, government response, weather, and more. Moreover, the data merges daily time-series from hundreds of data sources at a fine spatial resolution, containing over 20,000 locations and using a consistent set of region keys.
This dataset is available in both the US and EU regions of BigQuery at the following links:
All data in this dataset is retrieved automatically. When possible, data is retrieved directly from the relevant authorities, like a country's ministry of health.
This dataset has significant public interest in light of the COVID-19 crisis. All bytes processed in queries against this dataset will be zeroed out, making this part of the query free. Data joined with the dataset will be billed at the normal rate to prevent abuse. After September 15, queries over these datasets will revert to the normal billing rate.
This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery
Dataset Migration
If you are migrating from any of the other COVID-19 Public Datasets, such as the New York Times "US Coronavirus Database"
The structure of this list is as follows:
Previous dataset column name : COVID-19 Open Data column name
Sample Queries
Try the sample queries below in the BigQuery UI.
How many confirmed COVID-19 cases did each country have at the end of June?
This query determines the cumulative number of COVID-19 cases for each county, as well as a normalization of cumulative cases by country population, as of the end of June. Run this query.
How did confirmed COVID-19 cases compare to COVID-19 tests in the US during the month of June, by state?
This query determines the percent of reported COVID-19 tests in each US state that returned positive by dividing the total number of reported tests that returned positive by the total number of COVID-19 tests conducted in the month of June. Run this query.
Community Discussion
Join the community discussion by visiting the BigQuery public datasets: COVID-19 related datasets
Contact us
To nominate a dataset for inclusion please file a ticket in our Public Issue TrackerThe data files are published under the CC BY license
Google Cloud Console has failed to load JavaScript sources from www.gstatic.com.
Possible reasons are: