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!
Data source config
Collector config:
Upload an updated version of an exported dashboard.json file from Grafana
Revision | Description | Created | |
---|---|---|---|
Download |