Global Health Observatory - World Health Organization

CREATE TABLE owid_extent_of_implementation_of_mental_health_service_29f2dce8 (
  "year" INTEGER,
  "country" VARCHAR,
  "extent_of_implementation_of_mental_health_services_for_23238e11" VARCHAR  -- Extent Of Implementation Of Mental Health Services For Victims Of All Types Of Violence,
  "extent_of_implementation_of_mental_health_services_for_9fb2b7be" VARCHAR  -- Extent Of Implementation Of Mental Health Services For Victims Of All Types Of Violence Low,
  "extent_of_implementation_of_mental_health_services_for_49eebd4b" VARCHAR  -- Extent Of Implementation Of Mental Health Services For Victims Of All Types Of Violence High,
  "comments" VARCHAR
);

CREATE TABLE owid_extent_of_implementation_of_mental_health_service_35d0b102 (
  "year" INTEGER,
  "country" VARCHAR,
  "extent_of_implementation_of_mental_health_services_for_23238e11" VARCHAR  -- Extent Of Implementation Of Mental Health Services For Victims Of All Types Of Violence
);

CREATE TABLE owid_external_health_expenditure_ext_as_percentage_of__1f817126 (
  "year" INTEGER,
  "country" VARCHAR,
  "external_health_expenditure_ext_as_percentage_of_curre_825482bc" FLOAT  -- External Health Expenditure, Ext, As Percentage Of Current Health Expenditure, Che, Pct,
  "external_health_expenditure_ext_as_percentage_of_curre_03efa60e" VARCHAR  -- External Health Expenditure, Ext, As Percentage Of Current Health Expenditure, Che, Pct Low,
  "external_health_expenditure_ext_as_percentage_of_curre_a05077f6" VARCHAR  -- External Health Expenditure, Ext, As Percentage Of Current Health Expenditure, Che, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_external_health_expenditure_ext_as_percentage_of__40bf3b13 (
  "year" INTEGER,
  "country" VARCHAR,
  "external_health_expenditure_ext_as_percentage_of_curre_825482bc" FLOAT  -- External Health Expenditure, Ext, As Percentage Of Current Health Expenditure, Che, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_external_health_expenditure_ext_per_capita_in_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "external_health_expenditure_ext_per_capita_in_usd" FLOAT  -- External Health Expenditure, Ext, Per Capita In Usd,
  "comments" VARCHAR
);

CREATE TABLE owid_external_health_expenditure_ext_per_capita_in_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "external_health_expenditure_ext_per_capita_in_usd" FLOAT  -- External Health Expenditure, Ext, Per Capita In Usd,
  "external_health_expenditure_ext_per_capita_in_usd_low" VARCHAR  -- External Health Expenditure, Ext, Per Capita In Usd Low,
  "external_health_expenditure_ext_per_capita_in_usd_high" VARCHAR  -- External Health Expenditure, Ext, Per Capita In Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_external_quality_assessment_eqa_provided_for_bact_48656a53 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "external_quality_assessment_eqa_provided_for_bacterial_607514a8" INTEGER  -- External Quality Assessment, Eqa, Provided For Bacterial Identification And Antimicrobial Susceptibility Testing, Ast,
  "external_quality_assessment_eqa_provided_for_bacterial_3b6fff38" VARCHAR  -- External Quality Assessment, Eqa, Provided For Bacterial Identification And Antimicrobial Susceptibility Testing, Ast Low,
  "external_quality_assessment_eqa_provided_for_bacterial_721c562a" VARCHAR  -- External Quality Assessment, Eqa, Provided For Bacterial Identification And Antimicrobial Susceptibility Testing, Ast High,
  "comments" VARCHAR
);

CREATE TABLE owid_external_quality_assessment_eqa_provided_for_bact_65c77705 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "external_quality_assessment_eqa_provided_for_bacterial_607514a8" INTEGER  -- External Quality Assessment, Eqa, Provided For Bacterial Identification And Antimicrobial Susceptibility Testing, Ast
);

CREATE TABLE owid_external_quality_assessment_eqa_provided_to_local_9193996c (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "external_quality_assessment_eqa_provided_to_local_labo_5fad5d63" FLOAT  -- External Quality Assessment, Eqa, Provided To Local Laboratories Participating In Glass
);

CREATE TABLE owid_external_quality_assessment_eqa_provided_to_local_b3446ef3 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "external_quality_assessment_eqa_provided_to_local_labo_5fad5d63" FLOAT  -- External Quality Assessment, Eqa, Provided To Local Laboratories Participating In Glass,
  "external_quality_assessment_eqa_provided_to_local_labo_28be027e" VARCHAR  -- External Quality Assessment, Eqa, Provided To Local Laboratories Participating In Glass Low,
  "external_quality_assessment_eqa_provided_to_local_labo_f0089f1a" VARCHAR  -- External Quality Assessment, Eqa, Provided To Local Laboratories Participating In Glass High,
  "comments" VARCHAR
);

CREATE TABLE owid_external_quality_assessment_eqa_provided_to_the_n_4a411261 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "external_quality_assessment_eqa_provided_to_the_nation_238e991a" FLOAT  -- External Quality Assessment, Eqa, Provided To The National Reference Laboratory, Nrl,
  "external_quality_assessment_eqa_provided_to_the_nation_38b3a5c3" VARCHAR  -- External Quality Assessment, Eqa, Provided To The National Reference Laboratory, Nrl Low,
  "external_quality_assessment_eqa_provided_to_the_nation_820bcdc1" VARCHAR  -- External Quality Assessment, Eqa, Provided To The National Reference Laboratory, Nrl High,
  "comments" VARCHAR
);

CREATE TABLE owid_external_quality_assessment_eqa_provided_to_the_n_97c23174 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "external_quality_assessment_eqa_provided_to_the_nation_238e991a" FLOAT  -- External Quality Assessment, Eqa, Provided To The National Reference Laboratory, Nrl
);

CREATE TABLE owid_financial_support_provided_for_mitigation_existin_d502985f (
  "year" INTEGER,
  "country" VARCHAR,
  "financial_support_provided_for_mitigation_existing_dwellings" VARCHAR  -- Financial Support Provided For Mitigation, Existing Dwellings,
  "financial_support_provided_for_mitigation_existing_dwe_2f5416cd" VARCHAR  -- Financial Support Provided For Mitigation, Existing Dwellings Low,
  "financial_support_provided_for_mitigation_existing_dwe_4b5e6ea8" VARCHAR  -- Financial Support Provided For Mitigation, Existing Dwellings High,
  "comments" VARCHAR
);

CREATE TABLE owid_financing_method_for_substance_use_disorder_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "financing_method_for_substance_use_disorder_treatment" VARCHAR
);

CREATE TABLE owid_financing_method_for_substance_use_disorder_treatment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_type_disorders" VARCHAR,
  "financing_method_for_substance_use_disorder_treatment" VARCHAR,
  "financing_method_for_substance_use_disorder_treatment_low" VARCHAR,
  "financing_method_for_substance_use_disorder_treatment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_financing_methods_for_treatment_for_alcohol_use_d_4909edd6 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "financing_methods_for_treatment_for_alcohol_use_disorders" VARCHAR
);

CREATE TABLE owid_financing_methods_for_treatment_for_alcohol_use_d_7a0007fa (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "financing_methods_for_treatment_for_alcohol_use_disorders" VARCHAR,
  "financing_methods_for_treatment_for_alcohol_use_disorders_low" VARCHAR,
  "financing_methods_for_treatment_for_alcohol_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_financing_methods_for_treatment_for_drug_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "financing_methods_for_treatment_for_drug_use_disorders" VARCHAR
);

CREATE TABLE owid_financing_methods_for_treatment_for_drug_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_programmes" VARCHAR,
  "financing_methods_for_treatment_for_drug_use_disorders" VARCHAR,
  "financing_methods_for_treatment_for_drug_use_disorders_low" VARCHAR,
  "financing_methods_for_treatment_for_drug_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_fines_for_violations_of_smoke_free_laws_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "fines_for_violations_of_smoke_free_laws" VARCHAR
);

CREATE TABLE owid_fines_for_violations_of_smoke_free_laws_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "fines_for_violations_of_smoke_free_laws" VARCHAR,
  "fines_for_violations_of_smoke_free_laws_low" VARCHAR,
  "fines_for_violations_of_smoke_free_laws_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_fines_on_the_establishment_for_violations_of_smok_3dd9267e (
  "year" INTEGER,
  "country" VARCHAR,
  "fines_on_the_establishment_for_violations_of_smoke_free_laws" VARCHAR,
  "fines_on_the_establishment_for_violations_of_smoke_fre_c68d6d82" VARCHAR  -- Fines On The Establishment For Violations Of Smoke Free Laws Low,
  "fines_on_the_establishment_for_violations_of_smoke_fre_4ce6c820" VARCHAR  -- Fines On The Establishment For Violations Of Smoke Free Laws High,
  "comments" VARCHAR
);

CREATE TABLE owid_fines_on_the_establishment_for_violations_of_smok_6144d979 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "fines_on_the_establishment_for_violations_of_smoke_free_laws" VARCHAR
);

CREATE TABLE owid_fines_on_the_patrons_of_establishments_for_violat_45095f68 (
  "year" INTEGER,
  "country" VARCHAR,
  "fines_on_the_patrons_of_establishments_for_violations__83135ba4" VARCHAR  -- Fines On The Patrons Of Establishments For Violations Of Smoke Free Laws,
  "fines_on_the_patrons_of_establishments_for_violations__12e728de" VARCHAR  -- Fines On The Patrons Of Establishments For Violations Of Smoke Free Laws Low,
  "fines_on_the_patrons_of_establishments_for_violations__a0ec5064" VARCHAR  -- Fines On The Patrons Of Establishments For Violations Of Smoke Free Laws High,
  "comments" VARCHAR
);

CREATE TABLE owid_fines_on_the_patrons_of_establishments_for_violat_7bc2be99 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "fines_on_the_patrons_of_establishments_for_violations__83135ba4" VARCHAR  -- Fines On The Patrons Of Establishments For Violations Of Smoke Free Laws
);