Global Health Observatory - World Health Organization

CREATE TABLE owid_prevalence_of_previous_diagnosis_of_hypertension__d8b9d223 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_previous_diagnosis_of_hypertension_among_0eb53236" FLOAT  -- Prevalence Of Previous Diagnosis Of Hypertension Among Adults Aged 30–79 With Hypertension, Crude
);

CREATE TABLE owid_prevalence_of_previous_diagnosis_of_hypertension__da547be5 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_previous_diagnosis_of_hypertension_among_0eb53236" FLOAT  -- Prevalence Of Previous Diagnosis Of Hypertension Among Adults Aged 30–79 With Hypertension, Crude,
  "prevalence_of_previous_diagnosis_of_hypertension_among_9d1cef07" FLOAT  -- Prevalence Of Previous Diagnosis Of Hypertension Among Adults Aged 30–79 With Hypertension, Crude Low,
  "prevalence_of_previous_diagnosis_of_hypertension_among_6bf13a40" FLOAT  -- Prevalence Of Previous Diagnosis Of Hypertension Among Adults Aged 30–79 With Hypertension, Crude High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_severe_periodontal_disease_in_peopl_a46d55a2 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevalence_of_severe_periodontal_disease_in_people_15p_3dbefebf" FLOAT  -- Prevalence Of Severe Periodontal Disease In People 15plus Year, Pct
);

CREATE TABLE owid_prevalence_of_severe_periodontal_disease_in_peopl_c8c7edf5 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevalence_of_severe_periodontal_disease_in_people_15p_3dbefebf" FLOAT  -- Prevalence Of Severe Periodontal Disease In People 15plus Year, Pct,
  "prevalence_of_severe_periodontal_disease_in_people_15p_9a030264" VARCHAR  -- Prevalence Of Severe Periodontal Disease In People 15plus Year, Pct Low,
  "prevalence_of_severe_periodontal_disease_in_people_15p_79993e33" VARCHAR  -- Prevalence Of Severe Periodontal Disease In People 15plus Year, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_thinness_among_children_and_adolesc_1b32daee (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_thinness_among_children_and_adolescents__0220d51a" FLOAT  -- Prevalence Of Thinness Among Children And Adolescents, Bmi, Lt, 2 Standard Deviations Below The Median, Crude Estimate, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_thinness_among_children_and_adolesc_d1cd5187 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_thinness_among_children_and_adolescents__0220d51a" FLOAT  -- Prevalence Of Thinness Among Children And Adolescents, Bmi, Lt, 2 Standard Deviations Below The Median, Crude Estimate, Pct,
  "prevalence_of_thinness_among_children_and_adolescents__b84d41f5" FLOAT  -- Prevalence Of Thinness Among Children And Adolescents, Bmi, Lt, 2 Standard Deviations Below The Median, Crude Estimate, Pct Low,
  "prevalence_of_thinness_among_children_and_adolescents__beabd772" FLOAT  -- Prevalence Of Thinness Among Children And Adolescents, Bmi, Lt, 2 Standard Deviations Below The Median, Crude Estimate, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_treatment_taking_medicine_for_hyper_9310a1ba (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_0cfae76c" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Crude
);

CREATE TABLE owid_prevalence_of_treatment_taking_medicine_for_hyper_c7f4ede0 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_0cfae76c" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Crude,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_0d5b1620" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Crude Low,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_94df1d5b" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Crude High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_treatment_taking_medicine_for_hyper_da6d2a99 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_60d4c1d8" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Age Standardized
);

CREATE TABLE owid_prevalence_of_treatment_taking_medicine_for_hyper_dffa60ae (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_60d4c1d8" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Age Standardized,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_380e9d03" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Age Standardized Low,
  "prevalence_of_treatment_taking_medicine_for_hypertensi_62c86569" FLOAT  -- Prevalence Of Treatment, Taking Medicine, For Hypertension Among Adults Aged 30–79 With Hypertension, Age Standardized High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_trichomoniasis_in_individuals_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_trichomoniasis_in_individuals_pct" FLOAT  -- Prevalence Of Trichomoniasis In Individuals, Pct
);

CREATE TABLE owid_prevalence_of_trichomoniasis_in_individuals_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_trichomoniasis_in_individuals_pct" FLOAT  -- Prevalence Of Trichomoniasis In Individuals, Pct,
  "prevalence_of_trichomoniasis_in_individuals_pct_low" FLOAT  -- Prevalence Of Trichomoniasis In Individuals, Pct Low,
  "prevalence_of_trichomoniasis_in_individuals_pct_high" FLOAT  -- Prevalence Of Trichomoniasis In Individuals, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_underweight_among_adults_bmi_lt_18__6743f947 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_age_638c8498" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Age Standardized Estimate, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_underweight_among_adults_bmi_lt_18__733e7c4e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_cru_3bfe0f54" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Crude Estimate, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_underweight_among_adults_bmi_lt_18__ae1db33b (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_cru_3bfe0f54" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Crude Estimate, Pct,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_cru_7addff11" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Crude Estimate, Pct Low,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_cru_2f8fc82f" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Crude Estimate, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_underweight_among_adults_bmi_lt_18__d7a4b997 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_age_638c8498" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Age Standardized Estimate, Pct,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_age_9afc784d" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Age Standardized Estimate, Pct Low,
  "prevalence_of_underweight_among_adults_bmi_lt_18_5_age_f2233641" FLOAT  -- Prevalence Of Underweight Among Adults, Bmi, Lt, 18–5, Age Standardized Estimate, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_untreated_caries_of_deciduous_teeth_a51718b0 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevalence_of_untreated_caries_of_deciduous_teeth_in_c_ad5fb369" FLOAT  -- Prevalence Of Untreated Caries Of Deciduous Teeth In Children 1–9 Years, Pct,
  "prevalence_of_untreated_caries_of_deciduous_teeth_in_c_61c21285" VARCHAR  -- Prevalence Of Untreated Caries Of Deciduous Teeth In Children 1–9 Years, Pct Low,
  "prevalence_of_untreated_caries_of_deciduous_teeth_in_c_eec26218" VARCHAR  -- Prevalence Of Untreated Caries Of Deciduous Teeth In Children 1–9 Years, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_untreated_caries_of_deciduous_teeth_a927c3d9 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevalence_of_untreated_caries_of_deciduous_teeth_in_c_ad5fb369" FLOAT  -- Prevalence Of Untreated Caries Of Deciduous Teeth In Children 1–9 Years, Pct
);

CREATE TABLE owid_prevalence_of_untreated_caries_of_permanent_teeth_8ec1efc3 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevalence_of_untreated_caries_of_permanent_teeth_in_p_6199df27" FLOAT  -- Prevalence Of Untreated Caries Of Permanent Teeth In People 5plus Years, Pct
);

CREATE TABLE owid_prevalence_of_untreated_caries_of_permanent_teeth_cd3eca48 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevalence_of_untreated_caries_of_permanent_teeth_in_p_6199df27" FLOAT  -- Prevalence Of Untreated Caries Of Permanent Teeth In People 5plus Years, Pct,
  "prevalence_of_untreated_caries_of_permanent_teeth_in_p_a68fe199" VARCHAR  -- Prevalence Of Untreated Caries Of Permanent Teeth In People 5plus Years, Pct Low,
  "prevalence_of_untreated_caries_of_permanent_teeth_in_p_4792b564" VARCHAR  -- Prevalence Of Untreated Caries Of Permanent Teeth In People 5plus Years, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_use_of_assistive_products_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "prevalence_of_use_of_assistive_products_pct" FLOAT  -- Prevalence Of Use Of Assistive Products, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_use_of_assistive_products_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "prevalence_of_use_of_assistive_products_pct" FLOAT  -- Prevalence Of Use Of Assistive Products, Pct,
  "prevalence_of_use_of_assistive_products_pct_low" VARCHAR  -- Prevalence Of Use Of Assistive Products, Pct Low,
  "prevalence_of_use_of_assistive_products_pct_high" VARCHAR  -- Prevalence Of Use Of Assistive Products, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalent_cases_of_active_syphilis_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalent_cases_of_active_syphilis_in_thousands" INTEGER  -- Prevalent Cases Of Active Syphilis, In Thousands
);

CREATE TABLE owid_prevalent_cases_of_active_syphilis_in_thousands_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalent_cases_of_active_syphilis_in_thousands" FLOAT  -- Prevalent Cases Of Active Syphilis, In Thousands,
  "prevalent_cases_of_active_syphilis_in_thousands_low" FLOAT  -- Prevalent Cases Of Active Syphilis, In Thousands Low,
  "prevalent_cases_of_active_syphilis_in_thousands_high" FLOAT  -- Prevalent Cases Of Active Syphilis, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalent_cases_of_chlamydia_in_individuals_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalent_cases_of_chlamydia_in_individuals_in_thousands" UINTEGER  -- Prevalent Cases Of Chlamydia In Individuals, In Thousands
);