Global Health Observatory - World Health Organization

CREATE TABLE owid_mean_hdl_cholesterol_crude_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_hdl_cholesterol_crude" FLOAT  -- Mean Hdl Cholesterol, Crude,
  "mean_hdl_cholesterol_crude_low" FLOAT  -- Mean Hdl Cholesterol, Crude Low,
  "mean_hdl_cholesterol_crude_high" FLOAT  -- Mean Hdl Cholesterol, Crude High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_hemoglobin_level_of_children_aged_6_59_months_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_children_aged_6_59_months" INTEGER
);

CREATE TABLE owid_mean_hemoglobin_level_of_children_aged_6_59_months_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_children_aged_6_59_months" INTEGER,
  "mean_hemoglobin_level_of_children_aged_6_59_months_low" INTEGER,
  "mean_hemoglobin_level_of_children_aged_6_59_months_high" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_hemoglobin_level_of_non_pregnant_women_aged__3352b173 (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_non_pregnant_women_aged_15_49_years" INTEGER  -- Mean Hemoglobin Level Of Non Pregnant Women, Aged 15–49 Years
);

CREATE TABLE owid_mean_hemoglobin_level_of_non_pregnant_women_aged__7fa861f8 (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_non_pregnant_women_aged_15_49_years" INTEGER  -- Mean Hemoglobin Level Of Non Pregnant Women, Aged 15–49 Years,
  "mean_hemoglobin_level_of_non_pregnant_women_aged_15_49_6f0fcac9" INTEGER  -- Mean Hemoglobin Level Of Non Pregnant Women, Aged 15–49 Years Low,
  "mean_hemoglobin_level_of_non_pregnant_women_aged_15_49_a9695e3c" INTEGER  -- Mean Hemoglobin Level Of Non Pregnant Women, Aged 15–49 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_hemoglobin_level_of_pregnant_women_aged_15_49_years_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_pregnant_women_aged_15_49_years" INTEGER  -- Mean Hemoglobin Level Of Pregnant Women, Aged 15–49 Years
);

CREATE TABLE owid_mean_hemoglobin_level_of_pregnant_women_aged_15_49_years_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_pregnant_women_aged_15_49_years" INTEGER  -- Mean Hemoglobin Level Of Pregnant Women, Aged 15–49 Years,
  "mean_hemoglobin_level_of_pregnant_women_aged_15_49_years_low" INTEGER  -- Mean Hemoglobin Level Of Pregnant Women, Aged 15–49 Years Low,
  "mean_hemoglobin_level_of_pregnant_women_aged_15_49_years_high" INTEGER  -- Mean Hemoglobin Level Of Pregnant Women, Aged 15–49 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_hemoglobin_level_of_women_of_reproductive_ag_1a09ae7d (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_women_of_reproductive_age_age_920c055a" INTEGER  -- Mean Hemoglobin Level Of Women Of Reproductive Age, Aged 15–49 Years,
  "mean_hemoglobin_level_of_women_of_reproductive_age_age_e5fa5540" INTEGER  -- Mean Hemoglobin Level Of Women Of Reproductive Age, Aged 15–49 Years Low,
  "mean_hemoglobin_level_of_women_of_reproductive_age_age_5924d6bf" INTEGER  -- Mean Hemoglobin Level Of Women Of Reproductive Age, Aged 15–49 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_hemoglobin_level_of_women_of_reproductive_ag_92b4371e (
  "year" INTEGER,
  "country" VARCHAR,
  "mean_hemoglobin_level_of_women_of_reproductive_age_age_920c055a" INTEGER  -- Mean Hemoglobin Level Of Women Of Reproductive Age, Aged 15–49 Years
);

CREATE TABLE owid_mean_non_hdl_cholesterol_age_standardized_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_non_hdl_cholesterol_age_standardized" FLOAT  -- Mean Non Hdl Cholesterol, Age Standardized
);

CREATE TABLE owid_mean_non_hdl_cholesterol_age_standardized_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_non_hdl_cholesterol_age_standardized" FLOAT  -- Mean Non Hdl Cholesterol, Age Standardized,
  "mean_non_hdl_cholesterol_age_standardized_low" FLOAT  -- Mean Non Hdl Cholesterol, Age Standardized Low,
  "mean_non_hdl_cholesterol_age_standardized_high" FLOAT  -- Mean Non Hdl Cholesterol, Age Standardized High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_non_hdl_cholesterol_crude_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_non_hdl_cholesterol_crude" FLOAT  -- Mean Non Hdl Cholesterol, Crude
);

CREATE TABLE owid_mean_non_hdl_cholesterol_crude_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_non_hdl_cholesterol_crude" FLOAT  -- Mean Non Hdl Cholesterol, Crude,
  "mean_non_hdl_cholesterol_crude_low" FLOAT  -- Mean Non Hdl Cholesterol, Crude Low,
  "mean_non_hdl_cholesterol_crude_high" FLOAT  -- Mean Non Hdl Cholesterol, Crude High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_systolic_blood_pressure_age_standardized_estimate (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mean_systolic_blood_pressure_age_standardized_estimate" FLOAT  -- Mean Systolic Blood Pressure, Age Standardized Estimate,
  "mean_systolic_blood_pressure_age_standardized_estimate_low" FLOAT  -- Mean Systolic Blood Pressure, Age Standardized Estimate Low,
  "mean_systolic_blood_pressure_age_standardized_estimate_high" FLOAT  -- Mean Systolic Blood Pressure, Age Standardized Estimate High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_systolic_blood_pressure_crude_estimate_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mean_systolic_blood_pressure_crude_estimate" FLOAT  -- Mean Systolic Blood Pressure, Crude Estimate,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_systolic_blood_pressure_crude_estimate_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mean_systolic_blood_pressure_crude_estimate" FLOAT  -- Mean Systolic Blood Pressure, Crude Estimate,
  "mean_systolic_blood_pressure_crude_estimate_low" FLOAT  -- Mean Systolic Blood Pressure, Crude Estimate Low,
  "mean_systolic_blood_pressure_crude_estimate_high" FLOAT  -- Mean Systolic Blood Pressure, Crude Estimate High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_total_cholesterol_age_standardized_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_total_cholesterol_age_standardized" FLOAT  -- Mean Total Cholesterol, Age Standardized
);

CREATE TABLE owid_mean_total_cholesterol_age_standardized_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_total_cholesterol_age_standardized" FLOAT  -- Mean Total Cholesterol, Age Standardized,
  "mean_total_cholesterol_age_standardized_low" FLOAT  -- Mean Total Cholesterol, Age Standardized Low,
  "mean_total_cholesterol_age_standardized_high" FLOAT  -- Mean Total Cholesterol, Age Standardized High,
  "comments" VARCHAR
);

CREATE TABLE owid_mean_total_cholesterol_crude_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_total_cholesterol_crude" FLOAT  -- Mean Total Cholesterol, Crude
);

CREATE TABLE owid_mean_total_cholesterol_crude_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mean_total_cholesterol_crude" FLOAT  -- Mean Total Cholesterol, Crude,
  "mean_total_cholesterol_crude_low" FLOAT  -- Mean Total Cholesterol, Crude Low,
  "mean_total_cholesterol_crude_high" FLOAT  -- Mean Total Cholesterol, Crude High,
  "comments" VARCHAR
);

CREATE TABLE owid_measles_containing_vaccine_first_dose_mcv1_immuni_803b2a28 (
  "year" INTEGER,
  "country" VARCHAR,
  "measles_containing_vaccine_first_dose_mcv1_immunizatio_65d7c7d0" INTEGER  -- Measles Containing Vaccine First Dose, Mcv1, Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_measles_containing_vaccine_first_dose_mcv1_immuni_b41d02ae (
  "year" INTEGER,
  "country" VARCHAR,
  "measles_containing_vaccine_first_dose_mcv1_immunizatio_65d7c7d0" INTEGER  -- Measles Containing Vaccine First Dose, Mcv1, Immunization Coverage Among 1 Year Olds, Pct,
  "measles_containing_vaccine_first_dose_mcv1_immunizatio_7f59af1a" VARCHAR  -- Measles Containing Vaccine First Dose, Mcv1, Immunization Coverage Among 1 Year Olds, Pct Low,
  "measles_containing_vaccine_first_dose_mcv1_immunizatio_359c1a10" VARCHAR  -- Measles Containing Vaccine First Dose, Mcv1, Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_measles_containing_vaccine_second_dose_mcv2_immun_a4af0e95 (
  "year" INTEGER,
  "country" VARCHAR,
  "measles_containing_vaccine_second_dose_mcv2_immunizati_d86214cd" INTEGER  -- Measles Containing Vaccine Second Dose, Mcv2, Immunization Coverage By The Nationally Recommended Age, Pct
);

CREATE TABLE owid_measles_containing_vaccine_second_dose_mcv2_immun_de48c651 (
  "year" INTEGER,
  "country" VARCHAR,
  "measles_containing_vaccine_second_dose_mcv2_immunizati_d86214cd" INTEGER  -- Measles Containing Vaccine Second Dose, Mcv2, Immunization Coverage By The Nationally Recommended Age, Pct,
  "measles_containing_vaccine_second_dose_mcv2_immunizati_9c1610ff" VARCHAR  -- Measles Containing Vaccine Second Dose, Mcv2, Immunization Coverage By The Nationally Recommended Age, Pct Low,
  "measles_containing_vaccine_second_dose_mcv2_immunizati_d60823b4" VARCHAR  -- Measles Containing Vaccine Second Dose, Mcv2, Immunization Coverage By The Nationally Recommended Age, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_measles_immunization_coverage_among_one_year_olds_pct_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,
  "measles_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Measles Immunization Coverage Among One Year Olds, Pct,
  "comments" VARCHAR
);