← All dashboards

COVID-19

Coronavirus (COVID-19) infection statistics for Italy

This dashboard shows new coronavirus (COVID-19) infection statistics for Italy.

Steps:

wget https://raw.githubusercontent.com/pcm-dpc/COVID-19/master/dati-province/dpc-covid19-ita-province.csv

create database covid19; use covid19;

create table province( data date, stato varchar(64), codice_regione int, denominazione_regione varchar(64), codice_provincia varchar(64), denominazione_provincia varchar(64), sigla_provincia varchar(2), latitude float, longitude float, totale_casi int);

LOAD DATA LOCAL INFILE ‘dpc-covid19-ita-province.csv’ INTO TABLE province FIELDS TERMINATED BY ‘,’ ENCLOSED BY ’’ LINES TERMINATED BY ‘\n’ IGNORE 1 ROWS;

– Good luck!

Dashboard revisions

RevisionDecscriptionCreated

Reviews

Login or Sign up to write a review

Reviews from the community

Get this dashboard

Data source:

Dependencies:

Import the dashboard template:

or

Download JSON

Docs: Importing dashboards

Downloads: 494