Global Health Observatory - World Health Organization

CREATE TABLE owid_oral_health_basic_restorative_dental_procedures_t_5238acf2 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_basic_restorative_dental_procedures_to_tre_da9b0a74" VARCHAR  -- Oral Health, Basic Restorative Dental Procedures To Treat Existing Dental Decay,
  "oral_health_basic_restorative_dental_procedures_to_tre_0f4b1682" VARCHAR  -- Oral Health, Basic Restorative Dental Procedures To Treat Existing Dental Decay Low,
  "oral_health_basic_restorative_dental_procedures_to_tre_e149ff6a" VARCHAR  -- Oral Health, Basic Restorative Dental Procedures To Treat Existing Dental Decay High,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_1c13359a (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_d833eb8e" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Essential Curative Oral Health Care,
  "oral_health_interventions_as_part_of_health_benefit_pa_f40be2a0" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Essential Curative Oral Health Care Low,
  "oral_health_interventions_as_part_of_health_benefit_pa_e0a3f5bb" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Essential Curative Oral Health Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_3c1a7ae2 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_6fa99d4b" INTEGER  -- Oral Health Interventions As Part Of Health Benefit Packages, Coverage Of The Largest Government Health Financing Scheme, Pct,
  "oral_health_interventions_as_part_of_health_benefit_pa_26a14b45" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Coverage Of The Largest Government Health Financing Scheme, Pct Low,
  "oral_health_interventions_as_part_of_health_benefit_pa_4ab25a19" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Coverage Of The Largest Government Health Financing Scheme, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_56dc60c6 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_d833eb8e" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Essential Curative Oral Health Care
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_6519e3a2 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_5890531e" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Advanced Curative Oral Health Care
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_6d37422a (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_5890531e" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Advanced Curative Oral Health Care,
  "oral_health_interventions_as_part_of_health_benefit_pa_b579cde6" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Advanced Curative Oral Health Care Low,
  "oral_health_interventions_as_part_of_health_benefit_pa_e727eceb" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Advanced Curative Oral Health Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_6f68efb4 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_49dda418" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Rehabilitatative Oral Health Care
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_7e3f1d1f (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_49dda418" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Rehabilitatative Oral Health Care,
  "oral_health_interventions_as_part_of_health_benefit_pa_3ad4c8dc" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Rehabilitatative Oral Health Care Low,
  "oral_health_interventions_as_part_of_health_benefit_pa_63dd51c2" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Rehabilitatative Oral Health Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_a59877ed (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_8f36b7a1" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Routine And Preventive Oral Health Care
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_b08f8408 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_8f36b7a1" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Routine And Preventive Oral Health Care,
  "oral_health_interventions_as_part_of_health_benefit_pa_de452fcb" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Routine And Preventive Oral Health Care Low,
  "oral_health_interventions_as_part_of_health_benefit_pa_7dda4894" VARCHAR  -- Oral Health Interventions As Part Of Health Benefit Packages, Routine And Preventive Oral Health Care High,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_interventions_as_part_of_health_benef_e2cbf731 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_interventions_as_part_of_health_benefit_pa_6fa99d4b" INTEGER  -- Oral Health Interventions As Part Of Health Benefit Packages, Coverage Of The Largest Government Health Financing Scheme, Pct
);

CREATE TABLE owid_oral_health_noma_recognized_as_a_national_public__d674cdc6 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_noma_recognized_as_a_national_public_health_problem" VARCHAR  -- Oral Health, Noma Recognized As A National Public Health Problem
);

CREATE TABLE owid_oral_health_noma_recognized_as_a_national_public__ecb0661f (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_noma_recognized_as_a_national_public_health_problem" VARCHAR  -- Oral Health, Noma Recognized As A National Public Health Problem,
  "oral_health_noma_recognized_as_a_national_public_healt_7219ed13" VARCHAR  -- Oral Health, Noma Recognized As A National Public Health Problem Low,
  "oral_health_noma_recognized_as_a_national_public_healt_b9798875" VARCHAR  -- Oral Health, Noma Recognized As A National Public Health Problem High,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_screening_for_early_detection_of_oral_c45b3879 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_screening_for_early_detection_of_oral_diseases" VARCHAR,
  "oral_health_screening_for_early_detection_of_oral_diseases_low" VARCHAR,
  "oral_health_screening_for_early_detection_of_oral_diseases_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_oral_health_screening_for_early_detection_of_oral_fe9d1567 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_screening_for_early_detection_of_oral_diseases" VARCHAR
);

CREATE TABLE owid_oral_health_urgent_treatment_for_providing_emerge_5f9fda05 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_urgent_treatment_for_providing_emergency_o_1c763f0a" VARCHAR  -- Oral Health, Urgent Treatment For Providing Emergency Oral Care And Pain Relief
);

CREATE TABLE owid_oral_health_urgent_treatment_for_providing_emerge_83914393 (
  "year" INTEGER,
  "country" VARCHAR,
  "oral_health_urgent_treatment_for_providing_emergency_o_1c763f0a" VARCHAR  -- Oral Health, Urgent Treatment For Providing Emergency Oral Care And Pain Relief,
  "oral_health_urgent_treatment_for_providing_emergency_o_3ba6ec29" VARCHAR  -- Oral Health, Urgent Treatment For Providing Emergency Oral Care And Pain Relief Low,
  "oral_health_urgent_treatment_for_providing_emergency_o_4ae0fc0d" VARCHAR  -- Oral Health, Urgent Treatment For Providing Emergency Oral Care And Pain Relief High,
  "comments" VARCHAR
);

CREATE TABLE owid_organochlorine_resistance_reported_for_at_least_one_site_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "organochlorine_resistance_reported_for_at_least_one_site" VARCHAR
);

CREATE TABLE owid_organochlorine_resistance_reported_for_at_least_one_site_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "organochlorine_resistance_reported_for_at_least_one_site" VARCHAR,
  "organochlorine_resistance_reported_for_at_least_one_site_low" VARCHAR,
  "organochlorine_resistance_reported_for_at_least_one_site_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_organophosphate_resistance_reported_for_at_least__2088481d (
  "year" INTEGER,
  "country" VARCHAR,
  "organophosphate_resistance_reported_for_at_least_one_site" VARCHAR
);

CREATE TABLE owid_organophosphate_resistance_reported_for_at_least__ea72eb9a (
  "year" INTEGER,
  "country" VARCHAR,
  "organophosphate_resistance_reported_for_at_least_one_site" VARCHAR,
  "organophosphate_resistance_reported_for_at_least_one_site_low" VARCHAR,
  "organophosphate_resistance_reported_for_at_least_one_site_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_108116dd (
  "year" INTEGER,
  "country" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_disp_b4760c0f" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Display Qualitative Information On Emission Yields,
  "other_smoked_tobacco_packaging_and_labelling_must_disp_eb9de0b9" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Display Qualitative Information On Emission Yields Low,
  "other_smoked_tobacco_packaging_and_labelling_must_disp_81f7fac5" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Display Qualitative Information On Emission Yields High,
  "comments" VARCHAR
);

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_17f8e4c7 (
  "year" INTEGER,
  "country" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_not__a4b60e93" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors,
  "other_smoked_tobacco_packaging_and_labelling_must_not__ee67b2c0" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors Low,
  "other_smoked_tobacco_packaging_and_labelling_must_not__652aba97" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Figurative Or Other Signs Including Colors Or Numbers As Substitutes For Prohibited Misleading Terms And Descriptors High,
  "comments" VARCHAR
);

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_353fe45a (
  "year" INTEGER,
  "country" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_not__d5f02a1a" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Descriptors Depicting Flavours,
  "other_smoked_tobacco_packaging_and_labelling_must_not__8fbf1503" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Descriptors Depicting Flavours Low,
  "other_smoked_tobacco_packaging_and_labelling_must_not__1510aa5f" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Use Descriptors Depicting Flavours High,
  "comments" VARCHAR
);

CREATE TABLE owid_other_smoked_tobacco_packaging_and_labelling_must_7c0920f6 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "other_smoked_tobacco_packaging_and_labelling_must_not__e5b516ee" VARCHAR  -- Other Smoked Tobacco Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark
);