COVID-19 In Italy

Coronavirus Disease 2019 cases in Italy

@kaggle.sudalairajkumar_covid19_in_italy

Table List

2 tables(625.56 KB)

Covid19 Italy Province

@kaggle.sudalairajkumar_covid19_in_italy.covid19_italy_province

380.33 KB
40201 rows
11 columns

sno SNo	date Date	country Country	regioncode RegionCode	regionname RegionName	provincecode ProvinceCode	provincename ProvinceName	provinceabbreviation ProvinceAbbreviation	latitude Latitude	longitude Longitude
	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	13	Abruzzo	66	L'Aquila	AQ	42.35122196	13.39843823
1	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	13	Abruzzo	67	Teramo	TE	42.6589177	13.70439971
2	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	13	Abruzzo	68	Pescara	PE	42.46458398	14.21364822
3	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	13	Abruzzo	69	Chieti	CH	42.35103167	14.16754574
4	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	13	Abruzzo	979	In fase di definizione/aggiornamento	nan
5	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	17	Basilicata	76	Potenza	PZ	40.63947052	15.80514834
6	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	17	Basilicata	77	Matera	MT	40.66751177	16.59792442
7	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	17	Basilicata	980	In fase di definizione/aggiornamento	nan
8	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	18	Calabria	78	Cosenza	CS	39.29308681	16.25609692
9	Mon Feb 24 2020 18:00:00 GMT+0000 (Coordinated Universal Time)	ITA	18	Calabria	79	Catanzaro	CZ	38.90597598	16.59440194


CREATE TABLE covid19_italy_province (
  "sno" BIGINT,
  "date" TIMESTAMP,
  "country" VARCHAR,
  "regioncode" BIGINT,
  "regionname" VARCHAR,
  "provincecode" BIGINT,
  "provincename" VARCHAR,
  "provinceabbreviation" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "totalpositivecases" BIGINT
);