COVID-19

Coronavirus (COVID-19) infection statistics for Italy

COVID-19 screenshot 1
COVID-19 screenshot 2

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!

Revisions
RevisionDescriptionCreated

Get this dashboard

Import the dashboard template

or

Download JSON

Datasource
Dependencies