Dataset: Italian COVID-19 Regional Dataset

About this Dataset

Italian COVID-19 Regional Dataset

This dataset is a product of the Italian COVID-19 dataset and the transformation is described in the notebook Italian COVID-19 dataset review, sections named Regions.

This dataset was created as a basis for a data visualization project.

Tables

Italian Covid 19 Regions Data From2020 To2025

@kaggle.alessandrabilardi_italian_covid_19_region_dataset.italian_covid_19_regions_data_from2020_to2025

2.95 MB
37403 rows
29 columns


CREATE TABLE italian_covid_19_regions_data_from2020_to2025 (
  "date" TIMESTAMP,
  "state" VARCHAR,
  "region_code" BIGINT,
  "region_name" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "hospitalized_with_symptoms" BIGINT,
  "intensive_care" BIGINT,
  "total_hospitalized" BIGINT,
  "home_isolation" BIGINT,
  "total_positives" BIGINT,
  "new_positives" BIGINT,
  "intensive_care_admissions" DOUBLE,
  "discharged_recovered" BIGINT,
  "deceased" BIGINT,
  "total_cases" BIGINT,
  "daily_discharged_recovered" BIGINT,
  "daily_deceased" BIGINT,
  "daily_total_cases" BIGINT,
  "hospitalized_with_symptoms_normalized_per_region_name" DOUBLE,
  "intensive_care_normalized_per_region_name" DOUBLE,
  "total_hospitalized_normalized_per_region_name" DOUBLE,
  "home_isolation_normalized_per_region_name" DOUBLE,
  "total_positives_normalized_per_region_name" DOUBLE,
  "new_positives_normalized_per_region_name" DOUBLE,
  "intensive_care_admissions_normalized_per_region_name" DOUBLE,
  "daily_discharged_recovered_normalized_per_region_name" DOUBLE,
  "daily_deceased_normalized_per_region_name" DOUBLE,
  "daily_total_cases_normalized_per_region_name" DOUBLE
);