This is the Italian Coronavirus data repository from the Dipartimento della Protezione Civile . This dataset was created in response to the Coronavirus public health emergency in Italy and includes COVID-19 cases reported by region. More information on the data repository is available here . For additional information on Italy’s situation tracking and reporting, see the department’s Coronavirus site and interactive dashboard . 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 . This dataset is hosted in both the EU and US regions of BigQuery. See the links below for the appropriate dataset copy: US region EU region 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.

Context

This is the Italian Coronavirus data repository from the Dipartimento della Protezione Civile . This dataset was created in response to the Coronavirus public health emergency in Italy and includes COVID-19 cases reported by region

Sample Queries

Dati Italia COVID-19: Which provinces in Italy have the most confirmed cases? Find which Italian provinces have the highest number of confirmed COVID-19 cases as of yesterday. SELECT covid19.province_name AS province, covid19.region_name AS region, confirmed_cases FROM bigquery-public-data.covid19_italy.data_by_province covid19 WHERE EXTRACT(date from DATE) = DATE_SUB(CURRENT_DATE(),INTERVAL 1 day) ORDER BY confirmed_cases desc

Sample Query 2

What percentage of tests performed have resulted in confirmed cases by region? This query determines what percent of tests performed are made up by confirmed cases. SELECT covid19.region_name AS region, total_confirmed_cases, tests_performed, ROUND(total_confirmed_cases/tests_performed*100,2) AS percent_tests_confirmed_cases FROM bigquery-public-data.covid19_italy.data_by_region covid19 WHERE EXTRACT(date from DATE) = DATE_SUB(CURRENT_DATE(),INTERVAL 1 day) ORDER BY percent_tests_confirmed_cases desc