Global Health Observatory - World Health Organization

CREATE TABLE owid_ngos_for_alcohol_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_ngos" VARCHAR,
  "ngos_for_alcohol_use_disorders" VARCHAR,
  "ngos_for_alcohol_use_disorders_low" VARCHAR,
  "ngos_for_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ngos_for_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_ngos" VARCHAR,
  "ngos_for_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_ngos_for_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_ngos" VARCHAR,
  "ngos_for_drug_use_disorders" VARCHAR,
  "ngos_for_drug_use_disorders_low" VARCHAR,
  "ngos_for_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_nicotine_replacement_therapy_cost_covered_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_cost_covered" VARCHAR  -- Nicotine Replacement Therapy, Cost Covered
);

CREATE TABLE owid_nicotine_replacement_therapy_cost_covered_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_cost_covered" VARCHAR  -- Nicotine Replacement Therapy, Cost Covered,
  "nicotine_replacement_therapy_cost_covered_low" VARCHAR  -- Nicotine Replacement Therapy, Cost Covered Low,
  "nicotine_replacement_therapy_cost_covered_high" VARCHAR  -- Nicotine Replacement Therapy, Cost Covered High,
  "comments" VARCHAR
);

CREATE TABLE owid_nicotine_replacement_therapy_legally_sold_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_legally_sold" VARCHAR  -- Nicotine Replacement Therapy, Legally Sold
);

CREATE TABLE owid_nicotine_replacement_therapy_legally_sold_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_legally_sold" VARCHAR  -- Nicotine Replacement Therapy, Legally Sold,
  "nicotine_replacement_therapy_legally_sold_low" VARCHAR  -- Nicotine Replacement Therapy, Legally Sold Low,
  "nicotine_replacement_therapy_legally_sold_high" VARCHAR  -- Nicotine Replacement Therapy, Legally Sold High,
  "comments" VARCHAR
);

CREATE TABLE owid_nicotine_replacement_therapy_on_the_essential_med_0e07e480 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_on_the_essential_medicines_list" VARCHAR  -- Nicotine Replacement Therapy, On The Essential Medicines List
);

CREATE TABLE owid_nicotine_replacement_therapy_on_the_essential_med_ce63bc58 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_on_the_essential_medicines_list" VARCHAR  -- Nicotine Replacement Therapy, On The Essential Medicines List,
  "nicotine_replacement_therapy_on_the_essential_medicine_9cab5337" VARCHAR  -- Nicotine Replacement Therapy, On The Essential Medicines List Low,
  "nicotine_replacement_therapy_on_the_essential_medicine_c29433fd" VARCHAR  -- Nicotine Replacement Therapy, On The Essential Medicines List High,
  "comments" VARCHAR
);

CREATE TABLE owid_nicotine_replacement_therapy_place_available_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_place_available" VARCHAR  -- Nicotine Replacement Therapy, Place Available
);

CREATE TABLE owid_nicotine_replacement_therapy_place_available_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "nicotine_replacement_therapy_place_available" VARCHAR  -- Nicotine Replacement Therapy, Place Available,
  "nicotine_replacement_therapy_place_available_low" VARCHAR  -- Nicotine Replacement Therapy, Place Available Low,
  "nicotine_replacement_therapy_place_available_high" VARCHAR  -- Nicotine Replacement Therapy, Place Available High,
  "comments" VARCHAR
);

CREATE TABLE owid_nlis_children_aged_6_59_months_receiving_vitamin__40271b72 (
  "year" INTEGER,
  "country" VARCHAR,
  "nlis_children_aged_6_59_months_receiving_vitamin_a_sup_c4d22557" INTEGER  -- Nlis, Children Aged 6–59 Months Receiving Vitamin A Supplements, Dose 1, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_nlis_children_aged_6_59_months_receiving_vitamin__ae430981 (
  "year" INTEGER,
  "country" VARCHAR,
  "nlis_children_aged_6_59_months_receiving_vitamin_a_sup_a6b73aaa" INTEGER  -- Nlis, Children Aged 6–59 Months Receiving Vitamin A Supplements, Dose 2, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_nlis_population_using_improved_drinking_water_sources_pct (
  "year" INTEGER,
  "country" VARCHAR,
  "nlis_population_using_improved_drinking_water_sources_pct" FLOAT  -- Nlis, Population Using Improved Drinking Water Sources, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_nlis_population_using_improved_sanitation_facility_pct (
  "year" INTEGER,
  "country" VARCHAR,
  "nlis_population_using_improved_sanitation_facility_pct" FLOAT  -- Nlis, Population Using Improved Sanitation Facility, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_nlx_person_years_lived_between_ages_x_and_xplusn_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "nlx_person_years_lived_between_ages_x_and_xplusn" FLOAT  -- Nlx, Person Years Lived Between Ages X And Xplusn
);

CREATE TABLE owid_nlx_person_years_lived_between_ages_x_and_xplusn_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "nlx_person_years_lived_between_ages_x_and_xplusn" FLOAT  -- Nlx, Person Years Lived Between Ages X And Xplusn,
  "nlx_person_years_lived_between_ages_x_and_xplusn_low" VARCHAR  -- Nlx, Person Years Lived Between Ages X And Xplusn Low,
  "nlx_person_years_lived_between_ages_x_and_xplusn_high" VARCHAR  -- Nlx, Person Years Lived Between Ages X And Xplusn High,
  "comments" VARCHAR
);

CREATE TABLE owid_nmx_age_specific_death_rate_between_ages_x_and_xplusn_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "nmx_age_specific_death_rate_between_ages_x_and_xplusn" FLOAT  -- Nmx, Age Specific Death Rate Between Ages X And Xplusn
);

CREATE TABLE owid_nmx_age_specific_death_rate_between_ages_x_and_xplusn_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "nmx_age_specific_death_rate_between_ages_x_and_xplusn" FLOAT  -- Nmx, Age Specific Death Rate Between Ages X And Xplusn,
  "nmx_age_specific_death_rate_between_ages_x_and_xplusn_low" VARCHAR  -- Nmx, Age Specific Death Rate Between Ages X And Xplusn Low,
  "nmx_age_specific_death_rate_between_ages_x_and_xplusn_high" VARCHAR  -- Nmx, Age Specific Death Rate Between Ages X And Xplusn High,
  "comments" VARCHAR
);

CREATE TABLE owid_nomination_of_national_focal_point_nfp_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "nomination_of_national_focal_point_nfp" INTEGER  -- Nomination Of National Focal Point, Nfp
);

CREATE TABLE owid_nomination_of_national_focal_point_nfp_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "nomination_of_national_focal_point_nfp" INTEGER  -- Nomination Of National Focal Point, Nfp,
  "nomination_of_national_focal_point_nfp_low" VARCHAR  -- Nomination Of National Focal Point, Nfp Low,
  "nomination_of_national_focal_point_nfp_high" VARCHAR  -- Nomination Of National Focal Point, Nfp High,
  "comments" VARCHAR
);

CREATE TABLE owid_non_partner_sexual_violence_prevalence_pct (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "non_partner_sexual_violence_prevalence_pct" FLOAT  -- Non Partner Sexual Violence Prevalence, Pct,
  "non_partner_sexual_violence_prevalence_pct_low" FLOAT  -- Non Partner Sexual Violence Prevalence, Pct Low,
  "non_partner_sexual_violence_prevalence_pct_high" FLOAT  -- Non Partner Sexual Violence Prevalence, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_not_possible_to_gain_a_health_sciences_degree_ent_040581b2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "not_possible_to_gain_a_health_sciences_degree_entirely_5b10dd9b" VARCHAR  -- Not Possible To Gain A Health Sciences Degree Entirely Through Elearning,
  "not_possible_to_gain_a_health_sciences_degree_entirely_cb0d677e" VARCHAR  -- Not Possible To Gain A Health Sciences Degree Entirely Through Elearning Low,
  "not_possible_to_gain_a_health_sciences_degree_entirely_bd21ce9c" VARCHAR  -- Not Possible To Gain A Health Sciences Degree Entirely Through Elearning High,
  "comments" VARCHAR
);

CREATE TABLE owid_not_possible_to_gain_a_health_sciences_degree_ent_94ddbe0c (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "not_possible_to_gain_a_health_sciences_degree_entirely_5b10dd9b" VARCHAR  -- Not Possible To Gain A Health Sciences Degree Entirely Through Elearning
);

CREATE TABLE owid_nqx_probability_of_dying_between_ages_x_and_xplusn_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "nqx_probability_of_dying_between_ages_x_and_xplusn" FLOAT  -- Nqx, Probability Of Dying Between Ages X And Xplusn
);