COVID-19

Dashboard

Coronavirus (COVID-19) infection statistics for Italy
Last updated: a year ago

Start with Grafana Cloud and the new FREE tier. Includes 10K series Prometheus or Graphite Metrics and 50gb Loki Logs

Downloads: 384

Reviews: 2

  • Screenshot 2020-03-10 at 23.43.49 PM.png
    Screenshot 2020-03-10 at 23.43.49 PM.png
  • Screenshot 2020-03-15 at 8.27.30 AM.jpg
    Screenshot 2020-03-15 at 8.27.30 AM.jpg

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!

Dependencies: