Global Health Observatory - World Health Organization

CREATE TABLE owid_confirmed_cases_of_rr_mdr_tb_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "confirmed_cases_of_rr_mdr_tb" UINTEGER  -- Confirmed Cases Of Rr, Mdr Tb
);

CREATE TABLE owid_confirmed_cases_of_rr_mdr_tb_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "confirmed_cases_of_rr_mdr_tb" UINTEGER  -- Confirmed Cases Of Rr, Mdr Tb,
  "confirmed_cases_of_rr_mdr_tb_low" VARCHAR  -- Confirmed Cases Of Rr, Mdr Tb Low,
  "confirmed_cases_of_rr_mdr_tb_high" VARCHAR  -- Confirmed Cases Of Rr, Mdr Tb High,
  "comments" VARCHAR
);

CREATE TABLE owid_congenital_rubella_syndrome_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "congenital_rubella_syndrome_number_of_reported_cases" INTEGER  -- Congenital Rubella Syndrome, Number Of Reported Cases
);

CREATE TABLE owid_congenital_rubella_syndrome_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "congenital_rubella_syndrome_number_of_reported_cases" INTEGER  -- Congenital Rubella Syndrome, Number Of Reported Cases,
  "congenital_rubella_syndrome_number_of_reported_cases_low" VARCHAR  -- Congenital Rubella Syndrome, Number Of Reported Cases Low,
  "congenital_rubella_syndrome_number_of_reported_cases_high" VARCHAR  -- Congenital Rubella Syndrome, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_congenital_syphilis_number_of_cases_reported_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "congenital_syphilis_number_of_cases_reported" INTEGER  -- Congenital Syphilis Number Of Cases, Reported,
  "comments" VARCHAR
);

CREATE TABLE owid_congenital_syphilis_number_of_cases_reported_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "congenital_syphilis_number_of_cases_reported" INTEGER  -- Congenital Syphilis Number Of Cases, Reported,
  "congenital_syphilis_number_of_cases_reported_low" VARCHAR  -- Congenital Syphilis Number Of Cases, Reported Low,
  "congenital_syphilis_number_of_cases_reported_high" VARCHAR  -- Congenital Syphilis Number Of Cases, Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_congenital_syphilis_rate_per_100_000_live_births__57b20d35 (
  "year" INTEGER,
  "country" VARCHAR,
  "congenital_syphilis_rate_per_100_000_live_births_reported" FLOAT  -- Congenital Syphilis Rate Per 100–000 Live Births, Reported,
  "congenital_syphilis_rate_per_100_000_live_births_reported_low" VARCHAR  -- Congenital Syphilis Rate Per 100–000 Live Births, Reported Low,
  "congenital_syphilis_rate_per_100_000_live_births_reported_high" VARCHAR  -- Congenital Syphilis Rate Per 100–000 Live Births, Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_congenital_syphilis_rate_per_100_000_live_births__92547b6e (
  "year" INTEGER,
  "country" VARCHAR,
  "congenital_syphilis_rate_per_100_000_live_births_reported" FLOAT  -- Congenital Syphilis Rate Per 100–000 Live Births, Reported,
  "comments" VARCHAR
);

CREATE TABLE owid_consumer_information_about_calories_additives_etc_60fcec33 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_types" VARCHAR,
  "consumer_information_about_calories_additives_etc_on_containers" VARCHAR  -- Consumer Information About Calories, Additives, Etc On Containers,
  "consumer_information_about_calories_additives_etc_on_c_c9eee910" VARCHAR  -- Consumer Information About Calories, Additives, Etc On Containers Low,
  "consumer_information_about_calories_additives_etc_on_c_86e319d1" VARCHAR  -- Consumer Information About Calories, Additives, Etc On Containers High,
  "comments" VARCHAR
);

CREATE TABLE owid_consumer_information_on_alcohol_and_health_at_poi_c8e06a05 (
  "year" INTEGER,
  "country" VARCHAR,
  "consumer_information_on_alcohol_and_health_at_points_of_sale" VARCHAR,
  "consumer_information_on_alcohol_and_health_at_points_o_e6f7cff0" VARCHAR  -- Consumer Information On Alcohol And Health At Points Of Sale Low,
  "consumer_information_on_alcohol_and_health_at_points_o_fdaf7be2" VARCHAR  -- Consumer Information On Alcohol And Health At Points Of Sale High,
  "comments" VARCHAR
);

CREATE TABLE owid_consumer_information_on_alcohol_and_health_at_poi_ff938bf3 (
  "year" INTEGER,
  "country" VARCHAR,
  "consumer_information_on_alcohol_and_health_at_points_of_sale" VARCHAR
);

CREATE TABLE owid_continued_breastfeeding_12_23_months_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "household_wealth" VARCHAR,
  "continued_breastfeeding_12_23_months" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_continued_breastfeeding_12_23_months_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "continued_breastfeeding_12_23_months" FLOAT,
  "continued_breastfeeding_12_23_months_low" FLOAT,
  "continued_breastfeeding_12_23_months_high" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_continuing_professional_development_in_prevention_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "continuing_professional_development_in_prevention" VARCHAR
);

CREATE TABLE owid_continuing_professional_development_in_prevention_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "continuing_professional_development_in_prevention" VARCHAR,
  "continuing_professional_development_in_prevention_low" VARCHAR,
  "continuing_professional_development_in_prevention_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_continuing_professional_development_in_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "continuing_professional_development_in_treatment" VARCHAR
);

CREATE TABLE owid_continuing_professional_development_in_treatment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "continuing_professional_development_in_treatment" VARCHAR,
  "continuing_professional_development_in_treatment_low" VARCHAR,
  "continuing_professional_development_in_treatment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_contraceptive_prevalence_use_of_modern_and_tradit_a012c542 (
  "year" INTEGER,
  "country" 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,
  "contraceptive_prevalence_use_of_modern_and_traditional_f1db8fd6" FLOAT  -- Contraceptive Prevalence, Use Of Modern And Traditional Methods, Pct,
  "contraceptive_prevalence_use_of_modern_and_traditional_0a1970f0" FLOAT  -- Contraceptive Prevalence, Use Of Modern And Traditional Methods, Pct Low,
  "contraceptive_prevalence_use_of_modern_and_traditional_9ad7c991" FLOAT  -- Contraceptive Prevalence, Use Of Modern And Traditional Methods, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_contraceptive_prevalence_use_of_modern_and_tradit_d44885f4 (
  "year" INTEGER,
  "country" 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,
  "contraceptive_prevalence_use_of_modern_and_traditional_f1db8fd6" FLOAT  -- Contraceptive Prevalence, Use Of Modern And Traditional Methods, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_contraceptive_prevalence_use_of_modern_methods_pct_1 (
  "year" INTEGER,
  "country" 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,
  "contraceptive_prevalence_use_of_modern_methods_pct" FLOAT  -- Contraceptive Prevalence, Use Of Modern Methods, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_contraceptive_prevalence_use_of_modern_methods_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "contraceptive_prevalence_use_of_modern_methods_pct" FLOAT  -- Contraceptive Prevalence, Use Of Modern Methods, Pct,
  "contraceptive_prevalence_use_of_modern_methods_pct_low" FLOAT  -- Contraceptive Prevalence, Use Of Modern Methods, Pct Low,
  "contraceptive_prevalence_use_of_modern_methods_pct_high" FLOAT  -- Contraceptive Prevalence, Use Of Modern Methods, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_coordination (
  "year" INTEGER,
  "country" VARCHAR,
  "coordination" INTEGER
);

CREATE TABLE owid_cost_effectiveness_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "cost_effectiveness" VARCHAR
);

CREATE TABLE owid_cost_effectiveness_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "cost_effectiveness" VARCHAR,
  "cost_effectiveness_low" VARCHAR,
  "cost_effectiveness_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_counselling_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "counselling" VARCHAR
);