Global Health Observatory - World Health Organization

CREATE TABLE owid_varenicline_legally_sold_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "varenicline_legally_sold" VARCHAR  -- Varenicline, Legally Sold
);

CREATE TABLE owid_varenicline_legally_sold_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "varenicline_legally_sold" VARCHAR  -- Varenicline, Legally Sold,
  "varenicline_legally_sold_low" VARCHAR  -- Varenicline, Legally Sold Low,
  "varenicline_legally_sold_high" VARCHAR  -- Varenicline, Legally Sold High,
  "comments" VARCHAR
);

CREATE TABLE owid_varenicline_place_available_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "varenicline_place_available" VARCHAR  -- Varenicline, Place Available
);

CREATE TABLE owid_varenicline_place_available_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "varenicline_place_available" VARCHAR  -- Varenicline, Place Available,
  "varenicline_place_available_low" VARCHAR  -- Varenicline, Place Available Low,
  "varenicline_place_available_high" VARCHAR  -- Varenicline, Place Available High,
  "comments" VARCHAR
);

CREATE TABLE owid_vehicle_standards_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "vehicle_standards" VARCHAR,
  "comments" VARCHAR,
  "vehicle_standards_value" VARCHAR
);

CREATE TABLE owid_vehicle_standards_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "vehicle_standards" VARCHAR,
  "vehicle_standards_value" VARCHAR,
  "vehicle_standards_value_low" VARCHAR,
  "vehicle_standards_value_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_voluntary_treatment_for_people_with_alcohol_use_d_072a3af1 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "voluntary_treatment_for_people_with_alcohol_use_disord_581e4b5c" VARCHAR  -- Voluntary Treatment For People With Alcohol Use Disorders In The Criminal Justice System,
  "voluntary_treatment_for_people_with_alcohol_use_disord_44fda452" VARCHAR  -- Voluntary Treatment For People With Alcohol Use Disorders In The Criminal Justice System Low,
  "voluntary_treatment_for_people_with_alcohol_use_disord_222d4c97" VARCHAR  -- Voluntary Treatment For People With Alcohol Use Disorders In The Criminal Justice System High,
  "comments" VARCHAR
);

CREATE TABLE owid_voluntary_treatment_for_people_with_alcohol_use_d_44a71159 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "voluntary_treatment_for_people_with_alcohol_use_disord_581e4b5c" VARCHAR  -- Voluntary Treatment For People With Alcohol Use Disorders In The Criminal Justice System
);

CREATE TABLE owid_voluntary_treatment_for_people_with_drug_use_diso_773317bd (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "voluntary_treatment_for_people_with_drug_use_disorders_68d7bfa5" VARCHAR  -- Voluntary Treatment For People With Drug Use Disorders In The Criminal Justice System,
  "voluntary_treatment_for_people_with_drug_use_disorders_9be03a10" VARCHAR  -- Voluntary Treatment For People With Drug Use Disorders In The Criminal Justice System Low,
  "voluntary_treatment_for_people_with_drug_use_disorders_88f76681" VARCHAR  -- Voluntary Treatment For People With Drug Use Disorders In The Criminal Justice System High,
  "comments" VARCHAR
);

CREATE TABLE owid_voluntary_treatment_for_people_with_drug_use_diso_ed3046c2 (
  "year" INTEGER,
  "country" VARCHAR,
  "treatment" VARCHAR,
  "voluntary_treatment_for_people_with_drug_use_disorders_68d7bfa5" VARCHAR  -- Voluntary Treatment For People With Drug Use Disorders In The Criminal Justice System
);

CREATE TABLE owid_warn_about_the_dangers_of_tobacco_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "warn_about_the_dangers_of_tobacco" INTEGER
);

CREATE TABLE owid_warn_about_the_dangers_of_tobacco_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "warn_about_the_dangers_of_tobacco" INTEGER,
  "warn_about_the_dangers_of_tobacco_low" VARCHAR,
  "warn_about_the_dangers_of_tobacco_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_wash_deaths_number_sdg_3_9_2_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "wash_deaths_number_sdg_3_9_2" FLOAT  -- Wash Deaths, Number, Sdg 3–9 2
);

CREATE TABLE owid_wash_deaths_number_sdg_3_9_2_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "wash_deaths_number_sdg_3_9_2" FLOAT  -- Wash Deaths, Number, Sdg 3–9 2,
  "wash_deaths_number_sdg_3_9_2_low" VARCHAR  -- Wash Deaths, Number, Sdg 3–9 2 Low,
  "wash_deaths_number_sdg_3_9_2_high" VARCHAR  -- Wash Deaths, Number, Sdg 3–9 2 High,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_among_children_under_5_years_of_age_weigh_8253a573 (
  "year" INTEGER,
  "country" VARCHAR,
  "wasting_among_children_under_5_years_of_age_weight_for_2f2bbe6a" FLOAT  -- Wasting Among Children Under 5 Years Of Age, Weight For Height, Lt, 2 Sd, Prevalence, Pct, Survey Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_among_children_under_5_years_of_age_weigh_85b4fe76 (
  "year" INTEGER,
  "country" VARCHAR,
  "wasting_among_children_under_5_years_of_age_weight_for_0637e2eb" FLOAT  -- Wasting Among Children Under 5 Years Of Age, Weight For Height, Lt, 2 Sd, Number, In Thousands, Survey Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_among_children_under_5_years_of_age_weigh_86db8b2f (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_tercile" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "wasting_among_children_under_5_years_of_age_weight_for_2f2bbe6a" FLOAT  -- Wasting Among Children Under 5 Years Of Age, Weight For Height, Lt, 2 Sd, Prevalence, Pct, Survey Based Estimates,
  "wasting_among_children_under_5_years_of_age_weight_for_dac4e964" FLOAT  -- Wasting Among Children Under 5 Years Of Age, Weight For Height, Lt, 2 Sd, Prevalence, Pct, Survey Based Estimates Low,
  "wasting_among_children_under_5_years_of_age_weight_for_c978ed0e" FLOAT  -- Wasting Among Children Under 5 Years Of Age, Weight For Height, Lt, 2 Sd, Prevalence, Pct, Survey Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_numbers_among_children_under_5_years_of_a_63d6651d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "wasting_numbers_among_children_under_5_years_of_age_mi_962e2c31" FLOAT  -- Wasting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "wasting_numbers_among_children_under_5_years_of_age_mi_e02fcbaa" FLOAT  -- Wasting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates Low,
  "wasting_numbers_among_children_under_5_years_of_age_mi_b1ed8021" FLOAT  -- Wasting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_numbers_among_children_under_5_years_of_a_cdb0cd35 (
  "year" INTEGER,
  "country" VARCHAR,
  "wasting_numbers_among_children_under_5_years_of_age_mi_962e2c31" FLOAT  -- Wasting Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_prevalence_among_children_under_5_years_o_92f26d16 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "wasting_prevalence_among_children_under_5_years_of_age_ec98a6d0" FLOAT  -- Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates,
  "wasting_prevalence_among_children_under_5_years_of_age_79a47b80" FLOAT  -- Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates Low,
  "wasting_prevalence_among_children_under_5_years_of_age_e71e6d5e" FLOAT  -- Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_prevalence_among_children_under_5_years_o_e8975815 (
  "year" INTEGER,
  "country" VARCHAR,
  "wasting_prevalence_among_children_under_5_years_of_age_ec98a6d0" FLOAT  -- Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_prevalence_in_children_aged_lt_5_years_pc_6a8a193e (
  "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,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "wasting_prevalence_in_children_aged_lt_5_years_pct_hea_6cf1771e" FLOAT  -- Wasting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
  "wasting_prevalence_in_children_aged_lt_5_years_pct_hea_8d7196a6" FLOAT  -- Wasting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor Low,
  "wasting_prevalence_in_children_aged_lt_5_years_pct_hea_d4343176" FLOAT  -- Wasting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor High,
  "comments" VARCHAR
);

CREATE TABLE owid_wasting_prevalence_in_children_aged_lt_5_years_pc_783fc4cd (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_decile" VARCHAR,
  "wasting_prevalence_in_children_aged_lt_5_years_pct_hea_6cf1771e" FLOAT  -- Wasting Prevalence In Children Aged, Lt, 5 Years, Pct, Health Inequality Monitor,
  "comments" VARCHAR
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_000_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_000" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys, 000
);

CREATE TABLE owid_water_sanitation_and_hygiene_attributable_dalys_000_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "water_sanitation_and_hygiene_attributable_dalys_000" FLOAT  -- Water, Sanitation And Hygiene Attributable Dalys, 000,
  "water_sanitation_and_hygiene_attributable_dalys_000_low" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys, 000 Low,
  "water_sanitation_and_hygiene_attributable_dalys_000_high" VARCHAR  -- Water, Sanitation And Hygiene Attributable Dalys, 000 High,
  "comments" VARCHAR
);