Covid@Lombardy
Covariates and Covid Infos - EU NUTS Level
@kaggle.federicocapello_covidlombardy
Covariates and Covid Infos - EU NUTS Level
@kaggle.federicocapello_covidlombardy
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
);
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
);
Anyone who has the link will be able to view this.