Global Health Observatory - World Health Organization

CREATE TABLE owid_total_population_with_household_expenditures_on_h_a8e6dfd9 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_with_household_expenditures_on_health_608f0771" FLOAT  -- Total Population With Household Expenditures On Health Greater Than 25pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, Regional, Global,
  "total_population_with_household_expenditures_on_health_622746d9" VARCHAR  -- Total Population With Household Expenditures On Health Greater Than 25pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, Regional, Global Low,
  "total_population_with_household_expenditures_on_health_832a5c48" VARCHAR  -- Total Population With Household Expenditures On Health Greater Than 25pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, Regional, Global High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_with_household_expenditures_on_h_ba4b817b (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_with_household_expenditures_on_health_cc336f9a" FLOAT  -- Total Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, Regional, Global
);

CREATE TABLE owid_total_population_with_household_expenditures_on_h_ebd56703 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_with_household_expenditures_on_health_55958b50" FLOAT  -- Total Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Millions, Global, Regional,
  "total_population_with_household_expenditures_on_health_96abce64" VARCHAR  -- Total Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Millions, Global, Regional Low,
  "total_population_with_household_expenditures_on_health_5c29f440" VARCHAR  -- Total Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Millions, Global, Regional High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_population_with_household_expenditures_on_h_f6014faa (
  "year" INTEGER,
  "country" VARCHAR,
  "total_population_with_household_expenditures_on_health_55958b50" FLOAT  -- Total Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Millions, Global, Regional
);

CREATE TABLE owid_total_productivity_losses_due_to_5_oral_diseases__d92e16f8 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_productivity_losses_due_to_5_oral_diseases_in_million_usd" FLOAT  -- Total Productivity Losses Due To 5 Oral Diseases In Million, Usd
);

CREATE TABLE owid_total_productivity_losses_due_to_5_oral_diseases__fdd072b7 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_productivity_losses_due_to_5_oral_diseases_in_million_usd" FLOAT  -- Total Productivity Losses Due To 5 Oral Diseases In Million, Usd,
  "total_productivity_losses_due_to_5_oral_diseases_in_mi_774b7a99" VARCHAR  -- Total Productivity Losses Due To 5 Oral Diseases In Million, Usd Low,
  "total_productivity_losses_due_to_5_oral_diseases_in_mi_9d70a0c1" VARCHAR  -- Total Productivity Losses Due To 5 Oral Diseases In Million, Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_rubella_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_rubella_number_of_reported_cases" UINTEGER  -- Total Rubella, Number Of Reported Cases
);

CREATE TABLE owid_total_rubella_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_rubella_number_of_reported_cases" UINTEGER  -- Total Rubella, Number Of Reported Cases,
  "total_rubella_number_of_reported_cases_low" VARCHAR  -- Total Rubella, Number Of Reported Cases Low,
  "total_rubella_number_of_reported_cases_high" VARCHAR  -- Total Rubella, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_taxes_on_beverages_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "total_taxes_on_beverages_pct" FLOAT  -- Total Taxes On Beverages, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_total_taxes_on_beverages_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "total_taxes_on_beverages_pct" FLOAT  -- Total Taxes On Beverages, Pct,
  "total_taxes_on_beverages_pct_low" VARCHAR  -- Total Taxes On Beverages, Pct Low,
  "total_taxes_on_beverages_pct_high" VARCHAR  -- Total Taxes On Beverages, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_tetanus_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_tetanus_number_of_reported_cases" UINTEGER  -- Total Tetanus, Number Of Reported Cases
);

CREATE TABLE owid_total_tetanus_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_tetanus_number_of_reported_cases" UINTEGER  -- Total Tetanus, Number Of Reported Cases,
  "total_tetanus_number_of_reported_cases_low" VARCHAR  -- Total Tetanus, Number Of Reported Cases Low,
  "total_tetanus_number_of_reported_cases_high" VARCHAR  -- Total Tetanus, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_traditional_and_complementary_medicine_profession_0aa49054 (
  "year" INTEGER,
  "country" VARCHAR,
  "traditional_and_complementary_medicine_professionals_number" UINTEGER  -- Traditional And Complementary Medicine Professionals, Number,
  "comments" VARCHAR
);

CREATE TABLE owid_traditional_and_complementary_medicine_profession_0ddca9ac (
  "year" INTEGER,
  "country" VARCHAR,
  "traditional_and_complementary_medicine_professionals_number" UINTEGER  -- Traditional And Complementary Medicine Professionals, Number,
  "traditional_and_complementary_medicine_professionals_number_low" VARCHAR  -- Traditional And Complementary Medicine Professionals, Number Low,
  "traditional_and_complementary_medicine_professionals_n_59ca64d4" VARCHAR  -- Traditional And Complementary Medicine Professionals, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_training_in_screening_and_brief_interventions_for_135c7748 (
  "year" INTEGER,
  "country" VARCHAR,
  "training_in_screening_and_brief_interventions_for_alco_77330fc6" VARCHAR  -- Training In Screening And Brief Interventions For Alcohol Problems
);

CREATE TABLE owid_training_in_screening_and_brief_interventions_for_59382b3c (
  "year" INTEGER,
  "country" VARCHAR,
  "training_in_screening_and_brief_interventions_for_alco_77330fc6" VARCHAR  -- Training In Screening And Brief Interventions For Alcohol Problems,
  "training_in_screening_and_brief_interventions_for_alco_484d002f" VARCHAR  -- Training In Screening And Brief Interventions For Alcohol Problems Low,
  "training_in_screening_and_brief_interventions_for_alco_dfc4e531" VARCHAR  -- Training In Screening And Brief Interventions For Alcohol Problems High,
  "comments" VARCHAR
);

CREATE TABLE owid_training_requirements_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sunbed_facility_staff_training_requirements" VARCHAR,
  "comments" VARCHAR,
  "training_requirements" VARCHAR
);

CREATE TABLE owid_training_requirements_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sunbed_facility_staff_training_requirements" VARCHAR,
  "training_requirements" VARCHAR,
  "training_requirements_low" VARCHAR,
  "training_requirements_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_travel_distance_to_obtain_assistive_products_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "travel_distance_to_obtain_assistive_products" VARCHAR,
  "travel_distance_to_obtain_assistive_products_pct" FLOAT  -- Travel Distance To Obtain Assistive Products, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_travel_distance_to_obtain_assistive_products_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "travel_distance_to_obtain_assistive_products" VARCHAR,
  "travel_distance_to_obtain_assistive_products_pct" FLOAT  -- Travel Distance To Obtain Assistive Products, Pct,
  "travel_distance_to_obtain_assistive_products_pct_low" VARCHAR  -- Travel Distance To Obtain Assistive Products, Pct Low,
  "travel_distance_to_obtain_assistive_products_pct_high" VARCHAR  -- Travel Distance To Obtain Assistive Products, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_admissions_inpatient_alcohol_dependence_1839795f (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_admissions_inpatient_alcohol_dependence_per_100_000" FLOAT  -- Treatment Admissions, Inpatient, Alcohol Dependence, Per 100–000,
  "treatment_admissions_inpatient_alcohol_dependence_per__cc498692" VARCHAR  -- Treatment Admissions, Inpatient, Alcohol Dependence, Per 100–000 Low,
  "treatment_admissions_inpatient_alcohol_dependence_per__86c51ec5" VARCHAR  -- Treatment Admissions, Inpatient, Alcohol Dependence, Per 100–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_admissions_inpatient_alcohol_dependence_a0dde2fa (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_admissions_inpatient_alcohol_dependence_per_100_000" FLOAT  -- Treatment Admissions, Inpatient, Alcohol Dependence, Per 100–000
);

CREATE TABLE owid_treatment_admissions_inpatient_alcoholic_psychosi_038a9506 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_admissions_inpatient_alcoholic_psychosis_per_100_000" INTEGER  -- Treatment Admissions, Inpatient, Alcoholic Psychosis, Per 100–000
);

CREATE TABLE owid_treatment_admissions_inpatient_alcoholic_psychosi_62cbc75e (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_admissions_inpatient_alcoholic_psychosis_per_100_000" INTEGER  -- Treatment Admissions, Inpatient, Alcoholic Psychosis, Per 100–000,
  "treatment_admissions_inpatient_alcoholic_psychosis_per_b9ccd0c3" VARCHAR  -- Treatment Admissions, Inpatient, Alcoholic Psychosis, Per 100–000 Low,
  "treatment_admissions_inpatient_alcoholic_psychosis_per_3ab296ab" VARCHAR  -- Treatment Admissions, Inpatient, Alcoholic Psychosis, Per 100–000 High,
  "comments" VARCHAR
);

CREATE TABLE owid_treatment_history_unknown (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment_history_unknown" UINTEGER
);