Global Health Observatory - World Health Organization

CREATE TABLE owid_presence_of_roaming_backyard_pigs_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "presence_of_roaming_backyard_pigs" VARCHAR
);

CREATE TABLE owid_presence_of_roaming_backyard_pigs_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "presence_of_roaming_backyard_pigs" VARCHAR,
  "presence_of_roaming_backyard_pigs_low" VARCHAR,
  "presence_of_roaming_backyard_pigs_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_pre_service_elearning_programmes_have_been_evaluated_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "pre_service_elearning_programmes_have_been_evaluated" VARCHAR
);

CREATE TABLE owid_pre_service_elearning_programmes_have_been_evaluated_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "pre_service_elearning_programmes_have_been_evaluated" VARCHAR,
  "pre_service_elearning_programmes_have_been_evaluated_low" VARCHAR,
  "pre_service_elearning_programmes_have_been_evaluated_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_preterm_birth_number_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "preterm_birth_number" UINTEGER  -- Preterm Birth, Number
);

CREATE TABLE owid_preterm_birth_number_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "preterm_birth_number" UINTEGER  -- Preterm Birth, Number,
  "preterm_birth_number_low" UINTEGER  -- Preterm Birth, Number Low,
  "preterm_birth_number_high" UINTEGER  -- Preterm Birth, Number High,
  "comments" VARCHAR
);

CREATE TABLE owid_preterm_birth_rate_per_100_live_births_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "preterm_birth_rate_per_100_live_births" FLOAT  -- Preterm Birth Rate, Per 100 Live Births
);

CREATE TABLE owid_preterm_birth_rate_per_100_live_births_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "preterm_birth_rate_per_100_live_births" FLOAT  -- Preterm Birth Rate, Per 100 Live Births,
  "preterm_birth_rate_per_100_live_births_low" FLOAT  -- Preterm Birth Rate, Per 100 Live Births Low,
  "preterm_birth_rate_per_100_live_births_high" FLOAT  -- Preterm Birth Rate, Per 100 Live Births High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_active_syphilis_in_individuals_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_active_syphilis_in_individuals_pct" FLOAT  -- Prevalence Of Active Syphilis In Individuals, Pct
);

CREATE TABLE owid_prevalence_of_active_syphilis_in_individuals_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_active_syphilis_in_individuals_pct" FLOAT  -- Prevalence Of Active Syphilis In Individuals, Pct,
  "prevalence_of_active_syphilis_in_individuals_pct_low" FLOAT  -- Prevalence Of Active Syphilis In Individuals, Pct Low,
  "prevalence_of_active_syphilis_in_individuals_pct_high" FLOAT  -- Prevalence Of Active Syphilis In Individuals, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_anaemia_in_children_aged_6_59_months_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "prevalence_of_anaemia_in_children_aged_6_59_months_pct" FLOAT  -- Prevalence Of Anaemia In Children Aged 6–59 Months, Pct
);

CREATE TABLE owid_prevalence_of_anaemia_in_children_aged_6_59_months_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "prevalence_of_anaemia_in_children_aged_6_59_months_pct" FLOAT  -- Prevalence Of Anaemia In Children Aged 6–59 Months, Pct,
  "prevalence_of_anaemia_in_children_aged_6_59_months_pct_low" FLOAT  -- Prevalence Of Anaemia In Children Aged 6–59 Months, Pct Low,
  "prevalence_of_anaemia_in_children_aged_6_59_months_pct_high" FLOAT  -- Prevalence Of Anaemia In Children Aged 6–59 Months, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_anaemia_in_non_pregnant_women_aged__9b087f96 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "prevalence_of_anaemia_in_non_pregnant_women_aged_15_49_pct" FLOAT  -- Prevalence Of Anaemia In Non Pregnant Women, Aged 15–49, Pct,
  "prevalence_of_anaemia_in_non_pregnant_women_aged_15_49_pct_low" FLOAT  -- Prevalence Of Anaemia In Non Pregnant Women, Aged 15–49, Pct Low,
  "prevalence_of_anaemia_in_non_pregnant_women_aged_15_49_pct_high" FLOAT  -- Prevalence Of Anaemia In Non Pregnant Women, Aged 15–49, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_anaemia_in_non_pregnant_women_aged__a361f54f (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "prevalence_of_anaemia_in_non_pregnant_women_aged_15_49_pct" FLOAT  -- Prevalence Of Anaemia In Non Pregnant Women, Aged 15–49, Pct
);

CREATE TABLE owid_prevalence_of_anaemia_in_pregnant_women_aged_15_49_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "prevalence_of_anaemia_in_pregnant_women_aged_15_49_pct" FLOAT  -- Prevalence Of Anaemia In Pregnant Women, Aged 15–49, Pct
);

CREATE TABLE owid_prevalence_of_anaemia_in_pregnant_women_aged_15_49_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "prevalence_of_anaemia_in_pregnant_women_aged_15_49_pct" FLOAT  -- Prevalence Of Anaemia In Pregnant Women, Aged 15–49, Pct,
  "prevalence_of_anaemia_in_pregnant_women_aged_15_49_pct_low" FLOAT  -- Prevalence Of Anaemia In Pregnant Women, Aged 15–49, Pct Low,
  "prevalence_of_anaemia_in_pregnant_women_aged_15_49_pct_high" FLOAT  -- Prevalence Of Anaemia In Pregnant Women, Aged 15–49, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_anaemia_in_women_of_reproductive_ag_6b8ee1b2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "pregnancy_status" VARCHAR,
  "prevalence_of_anaemia_in_women_of_reproductive_age_age_3e253988" FLOAT  -- Prevalence Of Anaemia In Women Of Reproductive Age, Aged 15–49, Pct,
  "prevalence_of_anaemia_in_women_of_reproductive_age_age_b1792b7c" FLOAT  -- Prevalence Of Anaemia In Women Of Reproductive Age, Aged 15–49, Pct Low,
  "prevalence_of_anaemia_in_women_of_reproductive_age_age_6f878822" FLOAT  -- Prevalence Of Anaemia In Women Of Reproductive Age, Aged 15–49, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_anaemia_in_women_of_reproductive_ag_c0d517b8 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severity" VARCHAR,
  "prevalence_of_anaemia_in_women_of_reproductive_age_age_3e253988" FLOAT  -- Prevalence Of Anaemia In Women Of Reproductive Age, Aged 15–49, Pct
);

CREATE TABLE owid_prevalence_of_cervical_cancer_screening_among_wom_20d8ca2a (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "time_period" VARCHAR,
  "prevalence_of_cervical_cancer_screening_among_women_ag_f0d5ff6f" INTEGER  -- Prevalence Of Cervical Cancer Screening Among Women Aged 30–49 Years, Pct,
  "prevalence_of_cervical_cancer_screening_among_women_ag_db79abe8" INTEGER  -- Prevalence Of Cervical Cancer Screening Among Women Aged 30–49 Years, Pct Low,
  "prevalence_of_cervical_cancer_screening_among_women_ag_92d26073" INTEGER  -- Prevalence Of Cervical Cancer Screening Among Women Aged 30–49 Years, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_cervical_cancer_screening_among_wom_d20f7fc2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "time_period" VARCHAR,
  "prevalence_of_cervical_cancer_screening_among_women_ag_f0d5ff6f" INTEGER  -- Prevalence Of Cervical Cancer Screening Among Women Aged 30–49 Years, Pct
);

CREATE TABLE owid_prevalence_of_chlamydia_in_individuals_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_chlamydia_in_individuals_pct" FLOAT  -- Prevalence Of Chlamydia In Individuals, Pct
);

CREATE TABLE owid_prevalence_of_chlamydia_in_individuals_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalence_of_chlamydia_in_individuals_pct" FLOAT  -- Prevalence Of Chlamydia In Individuals, Pct,
  "prevalence_of_chlamydia_in_individuals_pct_low" FLOAT  -- Prevalence Of Chlamydia In Individuals, Pct Low,
  "prevalence_of_chlamydia_in_individuals_pct_high" FLOAT  -- Prevalence Of Chlamydia In Individuals, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_condom_use_by_adults_during_higher__da213e98 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_condom_use_by_adults_during_higher_risk__ce45c93e" INTEGER  -- Prevalence Of Condom Use By Adults During Higher Risk Sex, 15–49, Pct,
  "prevalence_of_condom_use_by_adults_during_higher_risk__b1fb93bc" VARCHAR  -- Prevalence Of Condom Use By Adults During Higher Risk Sex, 15–49, Pct Low,
  "prevalence_of_condom_use_by_adults_during_higher_risk__0dfcc058" VARCHAR  -- Prevalence Of Condom Use By Adults During Higher Risk Sex, 15–49, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalence_of_condom_use_by_adults_during_higher__fca240c9 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_condom_use_by_adults_during_higher_risk__ce45c93e" INTEGER  -- Prevalence Of Condom Use By Adults During Higher Risk Sex, 15–49, Pct
);

CREATE TABLE owid_prevalence_of_controlled_hypertension_among_adult_0621af22 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "prevalence_of_controlled_hypertension_among_adults_age_e72a29b2" FLOAT  -- Prevalence Of Controlled Hypertension Among Adults Aged 30–79 Years With Hypertension, Age Standardized,
  "prevalence_of_controlled_hypertension_among_adults_age_1d75f039" FLOAT  -- Prevalence Of Controlled Hypertension Among Adults Aged 30–79 Years With Hypertension, Age Standardized Low,
  "prevalence_of_controlled_hypertension_among_adults_age_01108b5c" FLOAT  -- Prevalence Of Controlled Hypertension Among Adults Aged 30–79 Years With Hypertension, Age Standardized High,
  "comments" VARCHAR
);