Dataset: Covid@Lombardy

About this Dataset

Covid@Lombardy

A heterogeneous set of twenty-two variables related to six macro areas of interest have been collected from Eurostat’s data repositories: they are related to economy, healthcare, population, primary sector, mo-bility and education. Data regarding Coronavirus has been collected from the European Joint Research Center (JRC) repository.

Tables

Dataset

@kaggle.federicocapello_covidlombardy.dataset

45.65 KB
144 rows
30 columns


CREATE TABLE dataset (
  "nuts" VARCHAR,
  "air_passengers" DOUBLE,
  "available_hospital_beds_nuts2" DOUBLE,
  "causes_of_death_crude_death_rate_3year_average_by_nuts2" DOUBLE,
  "compensation_of_employees_by_nuts2" DOUBLE,
  "deaths" DOUBLE,
  "early_leavers_from_education_and_training_by_sex_perce_d7187b5c" DOUBLE,
  "employment_thousand_hours_worked_nuts2" DOUBLE,
  "farm_labour_force" DOUBLE,
  "health_personnel_by_nuts2" DOUBLE,
  "hospital_discharges_resp_diseases_j00_to_j99_nuts2" DOUBLE,
  "life_expectancy" DOUBLE,
  "longterm_care_beds_per_hundred_thousand_nuts2" DOUBLE,
  "nama_10r_2gdp" DOUBLE,
  "participation_in_education_and_training" DOUBLE,
  "pop_density" DOUBLE,
  "population_nuts2" DOUBLE,
  "pupils_and_students_enrolled_by_sex_age_and_nuts2" DOUBLE,
  "real_growth_rate_of_regional_gross_value_added_gva_at__8122493b" DOUBLE,
  "stock_of_vehicles_by_category_and_nuts2" DOUBLE,
  "students_enrolled_in_tertiary_education_by_education_l_58e4f67e" DOUBLE,
  "unemployment_rate_nuts2" DOUBLE,
  "utilised_agricultural_area" DOUBLE,
  "young_people_neither_in_employment_nor_in_education_an_9d65aaae" DOUBLE,
  "binary_first_wave" VARCHAR,
  "binary_second_wave" VARCHAR,
  "multi_first_wave" VARCHAR,
  "multi_second_wave" VARCHAR,
  "cases_density_first_wave" DOUBLE,
  "cases_density_second_wave" DOUBLE
);

Policies

@kaggle.federicocapello_covidlombardy.policies

44.92 KB
48312 rows
22 columns


CREATE TABLE policies (
  "nuts2" VARCHAR,
  "date" TIMESTAMP,
  "anti_disinformation_measures" DOUBLE,
  "closure_and_regulation_of_schools" BIGINT,
  "curfew" DOUBLE,
  "declaration_of_emergency" DOUBLE,
  "external_border_restrictions" BIGINT,
  "health_monitoring" DOUBLE,
  "health_resources" BIGINT,
  "health_testing" DOUBLE,
  "hygiene" DOUBLE,
  "internal_border_restrictions" DOUBLE,
  "lockdown" DOUBLE,
  "new_task_force_bureau_or_administrative_configuration" DOUBLE,
  "other_policy_not_listed_above" DOUBLE,
  "public_awareness_measures" DOUBLE,
  "quarantine" DOUBLE,
  "restriction_and_regulation_of_businesses" BIGINT,
  "restriction_and_regulation_of_government_services" DOUBLE,
  "restrictions_of_mass_gatherings" BIGINT,
  "social_distancing" DOUBLE,
  "covid_19_vaccines" DOUBLE
);