Global Health Observatory - World Health Organization

CREATE TABLE owid_severe_wasting_prevalence_in_children_aged_lt_5_y_59f009fd (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "severe_wasting_prevalence_in_children_aged_lt_5_years_pct" FLOAT  -- Severe Wasting Prevalence In Children Aged, Lt, 5 Years, Pct,
  "severe_wasting_prevalence_in_children_aged_lt_5_years_pct_low" FLOAT  -- Severe Wasting Prevalence In Children Aged, Lt, 5 Years, Pct Low,
  "severe_wasting_prevalence_in_children_aged_lt_5_years_pct_high" FLOAT  -- Severe Wasting Prevalence In Children Aged, Lt, 5 Years, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_skilled_health_professionals_density_per_10_000_p_2d310430 (
  "year" INTEGER,
  "country" VARCHAR,
  "skilled_health_professionals_density_per_10_000_population" FLOAT  -- Skilled Health Professionals Density, Per 10–000 Population,
  "skilled_health_professionals_density_per_10_000_population_low" VARCHAR  -- Skilled Health Professionals Density, Per 10–000 Population Low,
  "skilled_health_professionals_density_per_10_000_population_high" VARCHAR  -- Skilled Health Professionals Density, Per 10–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_skilled_health_professionals_density_per_10_000_p_56224dd7 (
  "year" INTEGER,
  "country" VARCHAR,
  "skilled_health_professionals_density_per_10_000_population" FLOAT  -- Skilled Health Professionals Density, Per 10–000 Population
);

CREATE TABLE owid_smear_positive_tuberculosis_case_detection_rate_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "smear_positive_tuberculosis_case_detection_rate_pct" FLOAT  -- Smear Positive Tuberculosis Case Detection Rate, Pct
);

CREATE TABLE owid_smear_positive_tuberculosis_case_detection_rate_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smear_positive_tuberculosis_case_detection_rate_pct" FLOAT  -- Smear Positive Tuberculosis Case Detection Rate, Pct,
  "smear_positive_tuberculosis_case_detection_rate_pct_low" FLOAT  -- Smear Positive Tuberculosis Case Detection Rate, Pct Low,
  "smear_positive_tuberculosis_case_detection_rate_pct_high" FLOAT  -- Smear Positive Tuberculosis Case Detection Rate, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_smear_positive_tuberculosis_treatment_success_rate_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "smear_positive_tuberculosis_treatment_success_rate_pct" INTEGER  -- Smear Positive Tuberculosis Treatment Success Rate, Pct
);

CREATE TABLE owid_smear_positive_tuberculosis_treatment_success_rate_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smear_positive_tuberculosis_treatment_success_rate_pct" INTEGER  -- Smear Positive Tuberculosis Treatment Success Rate, Pct,
  "smear_positive_tuberculosis_treatment_success_rate_pct_low" VARCHAR  -- Smear Positive Tuberculosis Treatment Success Rate, Pct Low,
  "smear_positive_tuberculosis_treatment_success_rate_pct_high" VARCHAR  -- Smear Positive Tuberculosis Treatment Success Rate, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_education_facilities_except_universiti_23539882 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_education_facilities_except_universities_na_6f7e0cf8" VARCHAR  -- Smoke Free Education Facilities Except Universities, National Legislation
);

CREATE TABLE owid_smoke_free_education_facilities_except_universiti_6acea9b0 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_education_facilities_except_universities_na_6f7e0cf8" VARCHAR  -- Smoke Free Education Facilities Except Universities, National Legislation,
  "smoke_free_education_facilities_except_universities_na_315b0d6a" VARCHAR  -- Smoke Free Education Facilities Except Universities, National Legislation Low,
  "smoke_free_education_facilities_except_universities_na_060bcd53" VARCHAR  -- Smoke Free Education Facilities Except Universities, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_government_facilities_national_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_government_facilities_national_legislation" VARCHAR  -- Smoke Free Government Facilities, National Legislation
);

CREATE TABLE owid_smoke_free_government_facilities_national_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_government_facilities_national_legislation" VARCHAR  -- Smoke Free Government Facilities, National Legislation,
  "smoke_free_government_facilities_national_legislation_low" VARCHAR  -- Smoke Free Government Facilities, National Legislation Low,
  "smoke_free_government_facilities_national_legislation_high" VARCHAR  -- Smoke Free Government Facilities, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_health_care_facilities_national_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_health_care_facilities_national_legislation" VARCHAR  -- Smoke Free Health Care Facilities, National Legislation
);

CREATE TABLE owid_smoke_free_health_care_facilities_national_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_health_care_facilities_national_legislation" VARCHAR  -- Smoke Free Health Care Facilities, National Legislation,
  "smoke_free_health_care_facilities_national_legislation_low" VARCHAR  -- Smoke Free Health Care Facilities, National Legislation Low,
  "smoke_free_health_care_facilities_national_legislation_high" VARCHAR  -- Smoke Free Health Care Facilities, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_indoor_offices_national_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_indoor_offices_national_legislation" VARCHAR  -- Smoke Free Indoor Offices, National Legislation
);

CREATE TABLE owid_smoke_free_indoor_offices_national_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_indoor_offices_national_legislation" VARCHAR  -- Smoke Free Indoor Offices, National Legislation,
  "smoke_free_indoor_offices_national_legislation_low" VARCHAR  -- Smoke Free Indoor Offices, National Legislation Low,
  "smoke_free_indoor_offices_national_legislation_high" VARCHAR  -- Smoke Free Indoor Offices, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_other_indoor_public_places_national_le_d30ec7b5 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_other_indoor_public_places_national_legislation" VARCHAR  -- Smoke Free Other Indoor Public Places, National Legislation,
  "smoke_free_other_indoor_public_places_national_legislation_low" VARCHAR  -- Smoke Free Other Indoor Public Places, National Legislation Low,
  "smoke_free_other_indoor_public_places_national_legislation_high" VARCHAR  -- Smoke Free Other Indoor Public Places, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_other_indoor_public_places_national_le_d526497a (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_other_indoor_public_places_national_legislation" VARCHAR  -- Smoke Free Other Indoor Public Places, National Legislation
);

CREATE TABLE owid_smoke_free_public_transport_national_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_public_transport_national_legislation" VARCHAR  -- Smoke Free Public Transport, National Legislation
);

CREATE TABLE owid_smoke_free_public_transport_national_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_public_transport_national_legislation" VARCHAR  -- Smoke Free Public Transport, National Legislation,
  "smoke_free_public_transport_national_legislation_low" VARCHAR  -- Smoke Free Public Transport, National Legislation Low,
  "smoke_free_public_transport_national_legislation_high" VARCHAR  -- Smoke Free Public Transport, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_pubs_bars_and_cafes_national_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_pubs_bars_and_cafes_national_legislation" VARCHAR  -- Smoke Free Pubs, Bars And Cafes, National Legislation
);

CREATE TABLE owid_smoke_free_pubs_bars_and_cafes_national_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_pubs_bars_and_cafes_national_legislation" VARCHAR  -- Smoke Free Pubs, Bars And Cafes, National Legislation,
  "smoke_free_pubs_bars_and_cafes_national_legislation_low" VARCHAR  -- Smoke Free Pubs, Bars And Cafes, National Legislation Low,
  "smoke_free_pubs_bars_and_cafes_national_legislation_high" VARCHAR  -- Smoke Free Pubs, Bars And Cafes, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_restaurants_national_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_restaurants_national_legislation" VARCHAR  -- Smoke Free Restaurants, National Legislation
);

CREATE TABLE owid_smoke_free_restaurants_national_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_restaurants_national_legislation" VARCHAR  -- Smoke Free Restaurants, National Legislation,
  "smoke_free_restaurants_national_legislation_low" VARCHAR  -- Smoke Free Restaurants, National Legislation Low,
  "smoke_free_restaurants_national_legislation_high" VARCHAR  -- Smoke Free Restaurants, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_smoke_free_universities_national_legislation_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "smoke_free_universities_national_legislation" VARCHAR  -- Smoke Free Universities, National Legislation
);

CREATE TABLE owid_smoke_free_universities_national_legislation_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "smoke_free_universities_national_legislation" VARCHAR  -- Smoke Free Universities, National Legislation,
  "smoke_free_universities_national_legislation_low" VARCHAR  -- Smoke Free Universities, National Legislation Low,
  "smoke_free_universities_national_legislation_high" VARCHAR  -- Smoke Free Universities, National Legislation High,
  "comments" VARCHAR
);