Baselight

COVID-19 In Italy

Coronavirus Disease 2019 cases in Italy

@kaggle.sudalairajkumar_covid19_in_italy

Covid19 Italy Region
@kaggle.sudalairajkumar_covid19_in_italy.covid19_italy_region

  • 245.23 KB
  • 6027 rows
  • 17 columns
sno

SNo

date

Date

country

Country

regioncode

RegionCode

regionname

RegionName

latitude

Latitude

longitude

Longitude

hospitalizedpatients

HospitalizedPatients

intensivecarepatients

IntensiveCarePatients

totalhospitalizedpatients

TotalHospitalizedPatients

homeconfinement

HomeConfinement

currentpositivecases

CurrentPositiveCases

newpositivecases

NewPositiveCases

recovered

Recovered

deaths

Deaths

totalpositivecases

TotalPositiveCases

testsperformed

TestsPerformed

Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA13Abruzzo42.3512219613.39843823
1Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA17Basilicata40.6394705215.80514834
2Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA18Calabria38.9059759816.59440194
3Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA15Campania40.8395655514.25084984
4Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA8Emilia-Romagna44.4943668111.3417208102126181818
5Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA6Friuli Venezia Giulia45.649435413.76813649
6Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA12Lazio41.8927704412.483667221122213
7Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA7Liguria44.411493158.9326992
8Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA3Lombardia45.466794099.190347404761995711661666172
9Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)ITA11Marche43.6167597313.5188753

CREATE TABLE covid19_italy_region (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "country" VARCHAR,
  "regioncode" BIGINT,
  "regionname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "hospitalizedpatients" BIGINT,
  "intensivecarepatients" BIGINT,
  "totalhospitalizedpatients" BIGINT,
  "homeconfinement" BIGINT,
  "currentpositivecases" BIGINT,
  "newpositivecases" BIGINT,
  "recovered" BIGINT,
  "deaths" BIGINT,
  "totalpositivecases" BIGINT,
  "testsperformed" DOUBLE
);

Share link

Anyone who has the link will be able to view this.