Google COVID-19 data

In the google_health schema, we have data provided by the Google COVID-19 Open-Data¹. In the table below, we have a brief description of the content of each database table. For each of them, we have another table named {table_name}_meta that contains an explanation of the columns in the table.

For example, in the google_health schema, we have a table called hospitalizations_d that contains the information related to patients of COVID-19 and hospitals for the regions in the location_key. The meaning of the columns of this table are explained in the hospitalizations_d_meta table.

You can find information about the strings used in the location_key column of the tables in the locality_names_0 table.

Table name	Keys	Content	Source
covid19_series_by_age_d	location_key, date	Epidemiology and hospitalizations data stratified by age.	Google COVID-19 Open-Data1
covid19_series_by_sex_d	location_key, date	Epidemiology and hospitalizations data stratified by sex.	Google COVID-19 Open-Data1
covid19_series_d	location_key, date	COVID-19 cases, deaths, recoveries and tests.	Google COVID-19 Open-Data1
demographics	location_key	Various population statistics.	Google COVID-19 Open-Data1
economy	location_key	Various economic indicators.	Google COVID-19 Open-Data1
emergency_declarations_d	location_key, date	Government emergency declarations and mitigation policies.	Google COVID-19 Open-Data1
geography	location_key	Geographical information about the region.	Google COVID-19 Open-Data1
government_response_d	location_key, date	Government interventions and their relative stringency.	Google COVID-19 Open-Data1
health	location_key	Health indicators for the region.	Google COVID-19 Open-Data1
hospitalizations_d	location_key, date	Information related to patients of COVID-19 and hospitals.	Google COVID-19 Open-Data1
locality_names_0	location_key	Various names and codes, useful for joining with other tables.	Google COVID-19 Open-Data1
mobility_d	location_key, date	Various metrics related to the movement of people.	Google COVID-19 Open-Data1
search_trends_d	location_key, date	Trends in symptom search volumes due to COVID-19.	Google COVID-19 Open-Data1
vaccinations_access	location_key, date	Metrics quantifying access to COVID-19 vaccination sites.	Google COVID-19 Open-Data1
vaccinations_d	location_key, date	Trends in persons vaccinated and population vaccination rate regarding various Covid-19 vaccines.	Google COVID-19 Open-Data1
vaccinations_search_d	location_key, date	Trends in Google searches for COVID-19 vaccination information.	Google COVID-19 Open-Data1
weather_d	location_key, date	Dated meteorological information for each region.	Google COVID-19 Open-Data1

Google COVID-19 Open-Data¹ - The data was fetched from this repository: https://github.com/GoogleCloudPlatform/covid-19-open-data