Global Health Observatory - World Health Organization

CREATE TABLE owid_estimated_percentage_of_residential_long_term_car_f66ada19 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_percentage_of_residential_long_term_care_fac_c1d01f24" INTEGER  -- Estimated Percentage Of Residential Long Term Care Facilities Following National Dementia Standards,
  "estimated_percentage_of_residential_long_term_care_fac_3e97380b" VARCHAR  -- Estimated Percentage Of Residential Long Term Care Facilities Following National Dementia Standards Low,
  "estimated_percentage_of_residential_long_term_care_fac_a3946f32" VARCHAR  -- Estimated Percentage Of Residential Long Term Care Facilities Following National Dementia Standards High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_population_based_prevalence_of_depression_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_population_based_prevalence_of_depression" FLOAT
);

CREATE TABLE owid_estimated_population_based_prevalence_of_depression_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_population_based_prevalence_of_depression" FLOAT,
  "estimated_population_based_prevalence_of_depression_low" FLOAT,
  "estimated_population_based_prevalence_of_depression_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_road_traffic_death_rate_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimated_road_traffic_death_rate_per_100_000_population" FLOAT  -- Estimated Road Traffic Death Rate, Per 100–000 Population
);

CREATE TABLE owid_estimated_road_traffic_death_rate_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_road_traffic_death_rate_per_100_000_population" FLOAT  -- Estimated Road Traffic Death Rate, Per 100–000 Population,
  "estimated_road_traffic_death_rate_per_100_000_population_low" VARCHAR  -- Estimated Road Traffic Death Rate, Per 100–000 Population Low,
  "estimated_road_traffic_death_rate_per_100_000_population_high" VARCHAR  -- Estimated Road Traffic Death Rate, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_cigarette_smoking_prevalence__551f526c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_cigarette_smoking_prevalence_pct_a_e7f58fc7" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct, Age Standardized Rate,
  "estimate_of_current_cigarette_smoking_prevalence_pct_a_ba9df3cb" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct, Age Standardized Rate Low,
  "estimate_of_current_cigarette_smoking_prevalence_pct_a_b8b340a2" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct, Age Standardized Rate High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_cigarette_smoking_prevalence__a2aba9c7 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_cigarette_smoking_prevalence_pct_a_e7f58fc7" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct, Age Standardized Rate,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_cigarette_smoking_prevalence_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_cigarette_smoking_prevalence_pct" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_cigarette_smoking_prevalence_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_cigarette_smoking_prevalence_pct" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct,
  "estimate_of_current_cigarette_smoking_prevalence_pct_low" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct Low,
  "estimate_of_current_cigarette_smoking_prevalence_pct_high" FLOAT  -- Estimate Of Current Cigarette Smoking Prevalence, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_smoking_prevalence_pc_22c60fa9 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_smoking_prevalence_pct_age_eb356012" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct, Age Standardized Rate,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_smoking_prevalence_pc_a1b46f66 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_smoking_prevalence_pct_age_eb356012" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct, Age Standardized Rate,
  "estimate_of_current_tobacco_smoking_prevalence_pct_age_b484ce67" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct, Age Standardized Rate Low,
  "estimate_of_current_tobacco_smoking_prevalence_pct_age_f1c4c4c2" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct, Age Standardized Rate High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_smoking_prevalence_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_smoking_prevalence_pct" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_smoking_prevalence_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_smoking_prevalence_pct" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct,
  "estimate_of_current_tobacco_smoking_prevalence_pct_low" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct Low,
  "estimate_of_current_tobacco_smoking_prevalence_pct_high" FLOAT  -- Estimate Of Current Tobacco Smoking Prevalence, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_use_prevalence_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_use_prevalence_pct" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_use_prevalence_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_use_prevalence_pct" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct,
  "estimate_of_current_tobacco_use_prevalence_pct_low" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct Low,
  "estimate_of_current_tobacco_use_prevalence_pct_high" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_use_prevalence_pct_ag_4323f137 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_use_prevalence_pct_age_sta_6dcff74e" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct, Age Standardized Rate,
  "estimate_of_current_tobacco_use_prevalence_pct_age_sta_0f0480b1" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct, Age Standardized Rate Low,
  "estimate_of_current_tobacco_use_prevalence_pct_age_sta_b0565476" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct, Age Standardized Rate High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimate_of_current_tobacco_use_prevalence_pct_ag_e7b86a6c (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimate_of_current_tobacco_use_prevalence_pct_age_sta_6dcff74e" FLOAT  -- Estimate Of Current Tobacco Use Prevalence, Pct, Age Standardized Rate,
  "comments" VARCHAR
);

CREATE TABLE owid_estimates_of_number_of_homicides_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "estimates_of_number_of_homicides" FLOAT
);

CREATE TABLE owid_estimates_of_number_of_homicides_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "estimates_of_number_of_homicides" FLOAT,
  "estimates_of_number_of_homicides_low" FLOAT,
  "estimates_of_number_of_homicides_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_estimates_of_rates_of_homicides_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimates_of_rates_of_homicides_per_100_000_population" FLOAT
);

CREATE TABLE owid_estimates_of_rates_of_homicides_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "estimates_of_rates_of_homicides_per_100_000_population" FLOAT,
  "estimates_of_rates_of_homicides_per_100_000_population_low" FLOAT,
  "estimates_of_rates_of_homicides_per_100_000_population_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_ethanol_tax_deducted_from_excise_tax_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "ethanol_tax_deducted_from_excise_tax" VARCHAR
);

CREATE TABLE owid_ethanol_tax_deducted_from_excise_tax_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ethanol_tax_deducted_from_excise_tax" VARCHAR,
  "ethanol_tax_deducted_from_excise_tax_low" VARCHAR,
  "ethanol_tax_deducted_from_excise_tax_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_evaluation_of_any_government_sponsored_telehealth_dcb6ff1b (
  "year" INTEGER,
  "country" VARCHAR,
  "evaluation_of_any_government_sponsored_telehealth_programmes" VARCHAR,
  "evaluation_of_any_government_sponsored_telehealth_prog_0c97f3bd" VARCHAR  -- Evaluation Of Any Government Sponsored Telehealth Programmes Low,
  "evaluation_of_any_government_sponsored_telehealth_prog_ce39ccb6" VARCHAR  -- Evaluation Of Any Government Sponsored Telehealth Programmes High,
  "comments" VARCHAR
);

CREATE TABLE owid_evaluation_of_any_government_sponsored_telehealth_ef4d9497 (
  "year" INTEGER,
  "country" VARCHAR,
  "evaluation_of_any_government_sponsored_telehealth_programmes" VARCHAR
);