Global Health Observatory - World Health Organization

CREATE TABLE owid_national_surveys_on_heavy_espisodic_drinking_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "national_surveys_on_heavy_espisodic_drinking" VARCHAR
);

CREATE TABLE owid_national_surveys_on_heavy_espisodic_drinking_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_surveys_on_heavy_espisodic_drinking" VARCHAR,
  "national_surveys_on_heavy_espisodic_drinking_low" VARCHAR,
  "national_surveys_on_heavy_espisodic_drinking_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_national_surveys_on_youth_alcohol_consumption_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_surveys_on_youth_alcohol_consumption" VARCHAR
);

CREATE TABLE owid_national_surveys_on_youth_alcohol_consumption_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_surveys_on_youth_alcohol_consumption" VARCHAR,
  "national_surveys_on_youth_alcohol_consumption_low" VARCHAR,
  "national_surveys_on_youth_alcohol_consumption_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_national_system_of_data_collection_based_on_healt_6ec3f9af (
  "year" INTEGER,
  "country" VARCHAR,
  "national_system_of_data_collection_based_on_health_ser_6f543a03" VARCHAR  -- National System Of Data Collection Based On Health Service Delivery
);

CREATE TABLE owid_national_system_of_data_collection_based_on_healt_b808eb44 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_system_of_data_collection_based_on_health_ser_6f543a03" VARCHAR  -- National System Of Data Collection Based On Health Service Delivery,
  "national_system_of_data_collection_based_on_health_ser_573641fb" VARCHAR  -- National System Of Data Collection Based On Health Service Delivery Low,
  "national_system_of_data_collection_based_on_health_ser_966ff1ea" VARCHAR  -- National System Of Data Collection Based On Health Service Delivery High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_system_of_epidemiological_data_collectio_04941a46 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_system_of_epidemiological_data_collection_for_e14020bd" VARCHAR  -- National System Of Epidemiological Data Collection For Alcohol Use,
  "national_system_of_epidemiological_data_collection_for_d1eaa913" VARCHAR  -- National System Of Epidemiological Data Collection For Alcohol Use Low,
  "national_system_of_epidemiological_data_collection_for_e7c4420b" VARCHAR  -- National System Of Epidemiological Data Collection For Alcohol Use High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_system_of_epidemiological_data_collectio_c257565a (
  "year" INTEGER,
  "country" VARCHAR,
  "national_system_of_epidemiological_data_collection_for_e14020bd" VARCHAR  -- National System Of Epidemiological Data Collection For Alcohol Use
);

CREATE TABLE owid_national_systems_for_monitoring_alcohol_consumpti_a38f06c5 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_system_type" VARCHAR,
  "national_systems_for_monitoring_alcohol_consumption_and_harms" VARCHAR
);

CREATE TABLE owid_national_systems_for_monitoring_alcohol_consumpti_d4d8e1f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_system_type" VARCHAR,
  "national_systems_for_monitoring_alcohol_consumption_and_harms" VARCHAR,
  "national_systems_for_monitoring_alcohol_consumption_an_a28c1d50" VARCHAR  -- National Systems For Monitoring Alcohol Consumption And Harms Low,
  "national_systems_for_monitoring_alcohol_consumption_an_638ac95d" VARCHAR  -- National Systems For Monitoring Alcohol Consumption And Harms High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_tobacco_control_budget_currency_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_tobacco_control_budget_currency_reported" VARCHAR  -- National Tobacco Control Budget, Currency Reported
);

CREATE TABLE owid_national_tobacco_control_budget_currency_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_tobacco_control_budget_currency_reported" VARCHAR  -- National Tobacco Control Budget, Currency Reported,
  "national_tobacco_control_budget_currency_reported_low" VARCHAR  -- National Tobacco Control Budget, Currency Reported Low,
  "national_tobacco_control_budget_currency_reported_high" VARCHAR  -- National Tobacco Control Budget, Currency Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_national_treatment_policy_for_alcohol_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_treatment_policy_for_alcohol_use_disorders" VARCHAR
);

CREATE TABLE owid_national_treatment_policy_for_alcohol_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "national_treatment_policy_for_alcohol_use_disorders" VARCHAR,
  "national_treatment_policy_for_alcohol_use_disorders_low" VARCHAR,
  "national_treatment_policy_for_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_national_universal_health_coverage_strategy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "national_universal_health_coverage_strategy" VARCHAR
);

CREATE TABLE owid_national_universal_health_coverage_strategy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "national_universal_health_coverage_strategy" VARCHAR,
  "national_universal_health_coverage_strategy_low" VARCHAR,
  "national_universal_health_coverage_strategy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ndx_number_of_people_dying_between_ages_x_and_xplusn (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "ndx_number_of_people_dying_between_ages_x_and_xplusn" FLOAT  -- Ndx, Number Of People Dying Between Ages X And Xplusn,
  "ndx_number_of_people_dying_between_ages_x_and_xplusn_low" VARCHAR  -- Ndx, Number Of People Dying Between Ages X And Xplusn Low,
  "ndx_number_of_people_dying_between_ages_x_and_xplusn_high" VARCHAR  -- Ndx, Number Of People Dying Between Ages X And Xplusn High,
  "comments" VARCHAR
);

CREATE TABLE owid_neonatal_mortality_rate_0_to_27_days_per_1000_liv_81338f4d (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "neonatal_mortality_rate_0_to_27_days_per_1000_live_bir_fd2a4c6b" FLOAT  -- Neonatal Mortality Rate, 0 To 27 Days, Per 1000 Live Births, Sdg 3–2 2
);

CREATE TABLE owid_neonatal_mortality_rate_0_to_27_days_per_1000_liv_e6d67163 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "neonatal_mortality_rate_0_to_27_days_per_1000_live_bir_fd2a4c6b" FLOAT  -- Neonatal Mortality Rate, 0 To 27 Days, Per 1000 Live Births, Sdg 3–2 2,
  "neonatal_mortality_rate_0_to_27_days_per_1000_live_bir_921ee840" FLOAT  -- Neonatal Mortality Rate, 0 To 27 Days, Per 1000 Live Births, Sdg 3–2 2 Low,
  "neonatal_mortality_rate_0_to_27_days_per_1000_live_bir_f86e77e2" FLOAT  -- Neonatal Mortality Rate, 0 To 27 Days, Per 1000 Live Births, Sdg 3–2 2 High,
  "comments" VARCHAR
);

CREATE TABLE owid_neonatal_mortality_rate_deaths_per_1000_live_births_1 (
  "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,
  "neonatal_mortality_rate_deaths_per_1000_live_births" FLOAT  -- Neonatal Mortality Rate, Deaths Per 1000 Live Births,
  "comments" VARCHAR
);

CREATE TABLE owid_neonatal_mortality_rate_deaths_per_1000_live_births_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "neonatal_mortality_rate_deaths_per_1000_live_births" FLOAT  -- Neonatal Mortality Rate, Deaths Per 1000 Live Births,
  "neonatal_mortality_rate_deaths_per_1000_live_births_low" FLOAT  -- Neonatal Mortality Rate, Deaths Per 1000 Live Births Low,
  "neonatal_mortality_rate_deaths_per_1000_live_births_high" FLOAT  -- Neonatal Mortality Rate, Deaths Per 1000 Live Births High,
  "comments" VARCHAR
);

CREATE TABLE owid_neonatal_tetanus_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "neonatal_tetanus_number_of_reported_cases" INTEGER  -- Neonatal Tetanus, Number Of Reported Cases,
  "neonatal_tetanus_number_of_reported_cases_per_million" FLOAT  -- Neonatal Tetanus, Number Of Reported Cases Per Million
);

CREATE TABLE owid_neonatal_tetanus_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "neonatal_tetanus_number_of_reported_cases" INTEGER  -- Neonatal Tetanus, Number Of Reported Cases,
  "neonatal_tetanus_number_of_reported_cases_low" VARCHAR  -- Neonatal Tetanus, Number Of Reported Cases Low,
  "neonatal_tetanus_number_of_reported_cases_high" VARCHAR  -- Neonatal Tetanus, Number Of Reported Cases High,
  "comments" VARCHAR,
  "neonatal_tetanus_number_of_reported_cases_per_million" FLOAT  -- Neonatal Tetanus, Number Of Reported Cases Per Million
);

CREATE TABLE owid_neonates_protected_at_birth_against_neonatal_teta_1ac9db1a (
  "year" INTEGER,
  "country" VARCHAR,
  "neonates_protected_at_birth_against_neonatal_tetanus_pab_pct" INTEGER  -- Neonates Protected At Birth Against Neonatal Tetanus, Pab, Pct
);

CREATE TABLE owid_neonates_protected_at_birth_against_neonatal_teta_72e04320 (
  "year" INTEGER,
  "country" VARCHAR,
  "neonates_protected_at_birth_against_neonatal_tetanus_pab_pct" INTEGER  -- Neonates Protected At Birth Against Neonatal Tetanus, Pab, Pct,
  "neonates_protected_at_birth_against_neonatal_tetanus_p_1f1e4cab" VARCHAR  -- Neonates Protected At Birth Against Neonatal Tetanus, Pab, Pct Low,
  "neonates_protected_at_birth_against_neonatal_tetanus_p_162e8d8a" VARCHAR  -- Neonates Protected At Birth Against Neonatal Tetanus, Pab, Pct High,
  "comments" VARCHAR
);