Global Health Observatory - World Health Organization

CREATE TABLE owid_lack_of_infrastructure_for_ehr_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_infrastructure_for_ehr" VARCHAR  -- Lack Of Infrastructure, For Ehr
);

CREATE TABLE owid_lack_of_infrastructure_for_ehr_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_infrastructure_for_ehr" VARCHAR  -- Lack Of Infrastructure, For Ehr,
  "lack_of_infrastructure_for_ehr_low" VARCHAR  -- Lack Of Infrastructure, For Ehr Low,
  "lack_of_infrastructure_for_ehr_high" VARCHAR  -- Lack Of Infrastructure, For Ehr High,
  "comments" VARCHAR
);

CREATE TABLE owid_lack_of_integration_between_various_health_services_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_integration_between_various_health_services" VARCHAR
);

CREATE TABLE owid_lack_of_integration_between_various_health_services_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_integration_between_various_health_services" VARCHAR,
  "lack_of_integration_between_various_health_services_low" VARCHAR,
  "lack_of_integration_between_various_health_services_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_lack_of_legislation_or_regulations_covering_use_of_ehr_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_legislation_or_regulations_covering_use_of_ehr" VARCHAR
);

CREATE TABLE owid_lack_of_legislation_or_regulations_covering_use_of_ehr_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_legislation_or_regulations_covering_use_of_ehr" VARCHAR,
  "lack_of_legislation_or_regulations_covering_use_of_ehr_low" VARCHAR,
  "lack_of_legislation_or_regulations_covering_use_of_ehr_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_lack_of_national_or_international_standards_for_i_0e8c0b14 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_national_or_international_standards_for_intero_1debf564" VARCHAR  -- Lack Of National Or International Standards For Interoperability Of Ehr
);

CREATE TABLE owid_lack_of_national_or_international_standards_for_i_1aa80db6 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_national_or_international_standards_for_intero_1debf564" VARCHAR  -- Lack Of National Or International Standards For Interoperability Of Ehr,
  "lack_of_national_or_international_standards_for_intero_88f2db79" VARCHAR  -- Lack Of National Or International Standards For Interoperability Of Ehr Low,
  "lack_of_national_or_international_standards_for_intero_3fa0fad0" VARCHAR  -- Lack Of National Or International Standards For Interoperability Of Ehr High,
  "comments" VARCHAR
);

CREATE TABLE owid_lack_of_suitable_courses_available_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_suitable_courses_available" VARCHAR
);

CREATE TABLE owid_lack_of_suitable_courses_available_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "lack_of_suitable_courses_available" VARCHAR,
  "lack_of_suitable_courses_available_low" VARCHAR,
  "lack_of_suitable_courses_available_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_law_mandates_that_health_warnings_appear_on_cigar_082535e5 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_mandates_that_health_warnings_appear_on_cigarette_packages" VARCHAR,
  "law_mandates_that_health_warnings_appear_on_cigarette__00f674de" VARCHAR  -- Law Mandates That Health Warnings Appear On Cigarette Packages Low,
  "law_mandates_that_health_warnings_appear_on_cigarette__71d178d1" VARCHAR  -- Law Mandates That Health Warnings Appear On Cigarette Packages High,
  "comments" VARCHAR
);

CREATE TABLE owid_law_mandates_that_health_warnings_appear_on_cigar_f0efde2c (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "law_mandates_that_health_warnings_appear_on_cigarette_packages" VARCHAR
);

CREATE TABLE owid_law_mandates_that_health_warnings_appear_on_other_24497037 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_mandates_that_health_warnings_appear_on_other_smok_ffdbe572" VARCHAR  -- Law Mandates That Health Warnings Appear On Other Smoked Tobacco Packages,
  "law_mandates_that_health_warnings_appear_on_other_smok_99daf6cb" VARCHAR  -- Law Mandates That Health Warnings Appear On Other Smoked Tobacco Packages Low,
  "law_mandates_that_health_warnings_appear_on_other_smok_ed42ad72" VARCHAR  -- Law Mandates That Health Warnings Appear On Other Smoked Tobacco Packages High,
  "comments" VARCHAR
);

CREATE TABLE owid_law_mandates_that_health_warnings_appear_on_other_6b7ef702 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "law_mandates_that_health_warnings_appear_on_other_smok_ffdbe572" VARCHAR  -- Law Mandates That Health Warnings Appear On Other Smoked Tobacco Packages
);

CREATE TABLE owid_law_mandates_that_health_warnings_appear_on_smoke_42119bf4 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "law_mandates_that_health_warnings_appear_on_smokeless__4800e733" VARCHAR  -- Law Mandates That Health Warnings Appear On Smokeless Tobacco Packages
);

CREATE TABLE owid_law_mandates_that_health_warnings_appear_on_smoke_95fcbc75 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_mandates_that_health_warnings_appear_on_smokeless__4800e733" VARCHAR  -- Law Mandates That Health Warnings Appear On Smokeless Tobacco Packages,
  "law_mandates_that_health_warnings_appear_on_smokeless__ff010919" VARCHAR  -- Law Mandates That Health Warnings Appear On Smokeless Tobacco Packages Low,
  "law_mandates_that_health_warnings_appear_on_smokeless__6676a5c8" VARCHAR  -- Law Mandates That Health Warnings Appear On Smokeless Tobacco Packages High,
  "comments" VARCHAR
);

CREATE TABLE owid_law_requires_fines_for_violations_of_advertising_bans_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "law_requires_fines_for_violations_of_advertising_bans" VARCHAR
);

CREATE TABLE owid_law_requires_fines_for_violations_of_advertising_bans_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_requires_fines_for_violations_of_advertising_bans" VARCHAR,
  "law_requires_fines_for_violations_of_advertising_bans_low" VARCHAR,
  "law_requires_fines_for_violations_of_advertising_bans_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_law_requires_fines_for_violations_of_direct_adver_337cb3e9 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_requires_fines_for_violations_of_direct_advertisin_b3206f09" VARCHAR  -- Law Requires Fines For Violations Of Direct Advertising Bans, 2015,
  "law_requires_fines_for_violations_of_direct_advertisin_ccf6caee" VARCHAR  -- Law Requires Fines For Violations Of Direct Advertising Bans, 2015 Low,
  "law_requires_fines_for_violations_of_direct_advertisin_bea0244a" VARCHAR  -- Law Requires Fines For Violations Of Direct Advertising Bans, 2015 High,
  "comments" VARCHAR
);

CREATE TABLE owid_law_requires_fines_for_violations_of_direct_adver_981d3d53 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "law_requires_fines_for_violations_of_direct_advertisin_b3206f09" VARCHAR  -- Law Requires Fines For Violations Of Direct Advertising Bans, 2015
);

CREATE TABLE owid_law_requires_fines_for_violations_of_indirect_adv_434e4e60 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_requires_fines_for_violations_of_indirect_advertis_49ac1f72" VARCHAR  -- Law Requires Fines For Violations Of Indirect Advertising Bans 2015,
  "law_requires_fines_for_violations_of_indirect_advertis_f1b96e86" VARCHAR  -- Law Requires Fines For Violations Of Indirect Advertising Bans 2015 Low,
  "law_requires_fines_for_violations_of_indirect_advertis_020185a1" VARCHAR  -- Law Requires Fines For Violations Of Indirect Advertising Bans 2015 High,
  "comments" VARCHAR
);

CREATE TABLE owid_law_requires_fines_for_violations_of_indirect_adv_d1dbaf37 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "law_requires_fines_for_violations_of_indirect_advertis_49ac1f72" VARCHAR  -- Law Requires Fines For Violations Of Indirect Advertising Bans 2015
);

CREATE TABLE owid_law_requires_fines_for_violations_of_promotion_an_3c80eec7 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "law_requires_fines_for_violations_of_promotion_and_spo_57ad3bce" VARCHAR  -- Law Requires Fines For Violations Of Promotion And Sponsorship Bans
);

CREATE TABLE owid_law_requires_fines_for_violations_of_promotion_an_95e96d48 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_requires_fines_for_violations_of_promotion_and_spo_57ad3bce" VARCHAR  -- Law Requires Fines For Violations Of Promotion And Sponsorship Bans,
  "law_requires_fines_for_violations_of_promotion_and_spo_0d014ac2" VARCHAR  -- Law Requires Fines For Violations Of Promotion And Sponsorship Bans Low,
  "law_requires_fines_for_violations_of_promotion_and_spo_9ac13ce4" VARCHAR  -- Law Requires Fines For Violations Of Promotion And Sponsorship Bans High,
  "comments" VARCHAR
);

CREATE TABLE owid_law_requires_helmet_to_be_fastened_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "law_requires_helmet_to_be_fastened" VARCHAR
);