Global Health Observatory - World Health Organization

CREATE TABLE owid_prevalent_cases_of_chlamydia_in_individuals_in_thousands_2 (
  "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,
  "prevalent_cases_of_chlamydia_in_individuals_in_thousands_low" UINTEGER  -- Prevalent Cases Of Chlamydia In Individuals, In Thousands Low,
  "prevalent_cases_of_chlamydia_in_individuals_in_thousands_high" UINTEGER  -- Prevalent Cases Of Chlamydia In Individuals, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalent_cases_of_gonorrhoea_in_individuals_in_t_8319e357 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalent_cases_of_gonorrhoea_in_individuals_in_thousands" INTEGER  -- Prevalent Cases Of Gonorrhoea In Individuals, In Thousands,
  "prevalent_cases_of_gonorrhoea_in_individuals_in_thousands_low" INTEGER  -- Prevalent Cases Of Gonorrhoea In Individuals, In Thousands Low,
  "prevalent_cases_of_gonorrhoea_in_individuals_in_thousands_high" INTEGER  -- Prevalent Cases Of Gonorrhoea In Individuals, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevalent_cases_of_gonorrhoea_in_individuals_in_t_ec1b4d63 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalent_cases_of_gonorrhoea_in_individuals_in_thousands" INTEGER  -- Prevalent Cases Of Gonorrhoea In Individuals, In Thousands
);

CREATE TABLE owid_prevalent_cases_of_trichomoniasis_in_individuals__c790e131 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalent_cases_of_trichomoniasis_in_individuals_in_thousands" UINTEGER  -- Prevalent Cases Of Trichomoniasis In Individuals, In Thousands
);

CREATE TABLE owid_prevalent_cases_of_trichomoniasis_in_individuals__f3a989a4 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "prevalent_cases_of_trichomoniasis_in_individuals_in_thousands" UINTEGER  -- Prevalent Cases Of Trichomoniasis In Individuals, In Thousands,
  "prevalent_cases_of_trichomoniasis_in_individuals_in_th_5dd29fb4" UINTEGER  -- Prevalent Cases Of Trichomoniasis In Individuals, In Thousands Low,
  "prevalent_cases_of_trichomoniasis_in_individuals_in_th_42fe3f02" UINTEGER  -- Prevalent Cases Of Trichomoniasis In Individuals, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevention_activities_for_substance_use_disorders_839ce5c3 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_activities_for_substance_use_disorders_main_focus" VARCHAR  -- Prevention Activities For Substance Use Disorders, Main Focus
);

CREATE TABLE owid_prevention_activities_for_substance_use_disorders_9b191d03 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_activities_for_substance_use_disorders_main_focus" VARCHAR  -- Prevention Activities For Substance Use Disorders, Main Focus,
  "prevention_activities_for_substance_use_disorders_main_ad395757" VARCHAR  -- Prevention Activities For Substance Use Disorders, Main Focus Low,
  "prevention_activities_for_substance_use_disorders_main_ae83c3d4" VARCHAR  -- Prevention Activities For Substance Use Disorders, Main Focus High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevention_counselling_at_workplaces_for_those_wi_88a7b9bd (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_counselling_at_workplaces_for_those_with_al_e5ea1c86" VARCHAR  -- Prevention Counselling At Workplaces For Those With Alcohol Problems
);

CREATE TABLE owid_prevention_counselling_at_workplaces_for_those_wi_d89eac40 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_counselling_at_workplaces_for_those_with_al_e5ea1c86" VARCHAR  -- Prevention Counselling At Workplaces For Those With Alcohol Problems,
  "prevention_counselling_at_workplaces_for_those_with_al_fb0189f7" VARCHAR  -- Prevention Counselling At Workplaces For Those With Alcohol Problems Low,
  "prevention_counselling_at_workplaces_for_those_with_al_7a1382cb" VARCHAR  -- Prevention Counselling At Workplaces For Those With Alcohol Problems High,
  "comments" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_alcohol_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_programmes" VARCHAR,
  "prevention_programmes_for_alcohol" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_alcohol_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_programmes" VARCHAR,
  "prevention_programmes_for_alcohol" VARCHAR,
  "prevention_programmes_for_alcohol_low" VARCHAR,
  "prevention_programmes_for_alcohol_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_drugs_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_programmes" VARCHAR,
  "prevention_programmes_for_drugs" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_drugs_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "prevention_programmes" VARCHAR,
  "prevention_programmes_for_drugs" VARCHAR,
  "prevention_programmes_for_drugs_low" VARCHAR,
  "prevention_programmes_for_drugs_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_specific_populations_fo_40cb0a9b (
  "year" INTEGER,
  "country" VARCHAR,
  "specific_populations" VARCHAR,
  "prevention_programmes_for_specific_populations_for_alcohol" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_specific_populations_fo_7d6c988c (
  "year" INTEGER,
  "country" VARCHAR,
  "specific_populations" VARCHAR,
  "prevention_programmes_for_specific_populations_for_alcohol" VARCHAR,
  "prevention_programmes_for_specific_populations_for_alcohol_low" VARCHAR,
  "prevention_programmes_for_specific_populations_for_alcohol_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_specific_populations_for_drugs_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "specific_populations" VARCHAR,
  "prevention_programmes_for_specific_populations_for_drugs" VARCHAR
);

CREATE TABLE owid_prevention_programmes_for_specific_populations_for_drugs_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "specific_populations" VARCHAR,
  "prevention_programmes_for_specific_populations_for_drugs" VARCHAR,
  "prevention_programmes_for_specific_populations_for_drugs_low" VARCHAR,
  "prevention_programmes_for_specific_populations_for_drugs_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_previously_treated_cases_excluding_relapse (
  "year" INTEGER,
  "country" VARCHAR,
  "previously_treated_cases_excluding_relapse" UINTEGER  -- Previously Treated Cases, Excluding Relapse
);

CREATE TABLE owid_previously_treated_cases_tested_for_rr_mdr_tb_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "previously_treated_cases_tested_for_rr_mdr_tb_pct" FLOAT  -- Previously Treated Cases Tested For Rr, Mdr Tb, Pct
);

CREATE TABLE owid_previously_treated_cases_tested_for_rr_mdr_tb_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "previously_treated_cases_tested_for_rr_mdr_tb_pct" FLOAT  -- Previously Treated Cases Tested For Rr, Mdr Tb, Pct,
  "previously_treated_cases_tested_for_rr_mdr_tb_pct_low" VARCHAR  -- Previously Treated Cases Tested For Rr, Mdr Tb, Pct Low,
  "previously_treated_cases_tested_for_rr_mdr_tb_pct_high" VARCHAR  -- Previously Treated Cases Tested For Rr, Mdr Tb, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_price_measures_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "price_measure_types" VARCHAR,
  "price_measures" VARCHAR
);

CREATE TABLE owid_price_measures_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "price_measure_types" VARCHAR,
  "beverage_types" VARCHAR,
  "price_measures" VARCHAR,
  "price_measures_low" VARCHAR,
  "price_measures_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_prices_for_alcoholic_beverages_average_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "comments" VARCHAR,
  "prices_for_alcoholic_beverages_average_usd" FLOAT  -- Prices For Alcoholic Beverages, Average, Usd
);

CREATE TABLE owid_prices_for_alcoholic_beverages_average_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "prices_for_alcoholic_beverages_average_usd" FLOAT  -- Prices For Alcoholic Beverages, Average, Usd,
  "prices_for_alcoholic_beverages_average_usd_low" VARCHAR  -- Prices For Alcoholic Beverages, Average, Usd Low,
  "prices_for_alcoholic_beverages_average_usd_high" VARCHAR  -- Prices For Alcoholic Beverages, Average, Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_primary_data_availability_for_uhc_service_coverag_e410ea15 (
  "year" INTEGER,
  "country" VARCHAR,
  "primary_data_availability_for_uhc_service_coverage_ind_bd31a3f6" FLOAT  -- Primary Data Availability For Uhc Service Coverage Index, Sdg 3–8 1, Pct
);