Global Health Observatory - World Health Organization

CREATE TABLE owid_compliance_of_ban_on_advertising_on_local_magazin_85815d20 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_advertising_on_local_magazines_an_48681f8d" INTEGER  -- Compliance Of Ban On Advertising On Local Magazines And Newspapers,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_advertising_on_local_magazin_d848a9fc (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_advertising_on_local_magazines_an_48681f8d" INTEGER  -- Compliance Of Ban On Advertising On Local Magazines And Newspapers,
  "compliance_of_ban_on_advertising_on_local_magazines_an_045c9256" VARCHAR  -- Compliance Of Ban On Advertising On Local Magazines And Newspapers Low,
  "compliance_of_ban_on_advertising_on_local_magazines_an_ef0efc6d" VARCHAR  -- Compliance Of Ban On Advertising On Local Magazines And Newspapers High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_advertising_on_national_tv_a_44cfd10a (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_advertising_on_national_tv_and_radio" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_advertising_on_national_tv_a_468448d5 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_advertising_on_national_tv_and_radio" INTEGER,
  "compliance_of_ban_on_advertising_on_national_tv_and_radio_low" VARCHAR,
  "compliance_of_ban_on_advertising_on_national_tv_and_radio_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_appearance_of_tobacco_brands_054f7484 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_appearance_of_tobacco_brands_in_t_f01ccacb" INTEGER  -- Compliance Of Ban On Appearance Of Tobacco Brands In Tv And Or Films, Product Placement,
  "compliance_of_ban_on_appearance_of_tobacco_brands_in_t_bdf7cae6" VARCHAR  -- Compliance Of Ban On Appearance Of Tobacco Brands In Tv And Or Films, Product Placement Low,
  "compliance_of_ban_on_appearance_of_tobacco_brands_in_t_73d074cc" VARCHAR  -- Compliance Of Ban On Appearance Of Tobacco Brands In Tv And Or Films, Product Placement High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_appearance_of_tobacco_brands_7cbe2d8b (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_appearance_of_tobacco_brands_in_t_f01ccacb" INTEGER  -- Compliance Of Ban On Appearance Of Tobacco Brands In Tv And Or Films, Product Placement,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_appearance_of_tobacco_produc_215bad25 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_appearance_of_tobacco_products_in_35b2629e" INTEGER  -- Compliance Of Ban On Appearance Of Tobacco Products In Tv And Or Films,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_appearance_of_tobacco_produc_505053a8 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_appearance_of_tobacco_products_in_35b2629e" INTEGER  -- Compliance Of Ban On Appearance Of Tobacco Products In Tv And Or Films,
  "compliance_of_ban_on_appearance_of_tobacco_products_in_88799b62" VARCHAR  -- Compliance Of Ban On Appearance Of Tobacco Products In Tv And Or Films Low,
  "compliance_of_ban_on_appearance_of_tobacco_products_in_a916d257" VARCHAR  -- Compliance Of Ban On Appearance Of Tobacco Products In Tv And Or Films High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_brand_name_of_non_tobacco_pr_84817742 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_brand_name_of_non_tobacco_product_963990f6" INTEGER  -- Compliance Of Ban On Brand Name Of Non Tobacco Products Used For Tobacco Product,
  "compliance_of_ban_on_brand_name_of_non_tobacco_product_ee09a6a0" VARCHAR  -- Compliance Of Ban On Brand Name Of Non Tobacco Products Used For Tobacco Product Low,
  "compliance_of_ban_on_brand_name_of_non_tobacco_product_c6e676b6" VARCHAR  -- Compliance Of Ban On Brand Name Of Non Tobacco Products Used For Tobacco Product High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_brand_name_of_non_tobacco_pr_ebb18b9d (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_brand_name_of_non_tobacco_product_963990f6" INTEGER  -- Compliance Of Ban On Brand Name Of Non Tobacco Products Used For Tobacco Product,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_free_distribution_of_tobacco_8a1b595d (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_free_distribution_of_tobacco_prod_aa901e92" INTEGER  -- Compliance Of Ban On Free Distribution Of Tobacco Products In The Mail Or Through Other Means,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_free_distribution_of_tobacco_cb2135a6 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_free_distribution_of_tobacco_prod_aa901e92" INTEGER  -- Compliance Of Ban On Free Distribution Of Tobacco Products In The Mail Or Through Other Means,
  "compliance_of_ban_on_free_distribution_of_tobacco_prod_fc963a09" VARCHAR  -- Compliance Of Ban On Free Distribution Of Tobacco Products In The Mail Or Through Other Means Low,
  "compliance_of_ban_on_free_distribution_of_tobacco_prod_5338073e" VARCHAR  -- Compliance Of Ban On Free Distribution Of Tobacco Products In The Mail Or Through Other Means High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_non_tobacco_goods_and_servic_f0f32a8c (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_non_tobacco_goods_and_services_id_f62a3a34" INTEGER  -- Compliance Of Ban On Non Tobacco Goods And Services Identified With Tobacco Brand Names,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_non_tobacco_goods_and_servic_f1d323c1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_non_tobacco_goods_and_services_id_f62a3a34" INTEGER  -- Compliance Of Ban On Non Tobacco Goods And Services Identified With Tobacco Brand Names,
  "compliance_of_ban_on_non_tobacco_goods_and_services_id_f9ef0752" VARCHAR  -- Compliance Of Ban On Non Tobacco Goods And Services Identified With Tobacco Brand Names Low,
  "compliance_of_ban_on_non_tobacco_goods_and_services_id_1eea4552" VARCHAR  -- Compliance Of Ban On Non Tobacco Goods And Services Identified With Tobacco Brand Names High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_promotional_discounts_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_promotional_discounts" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_promotional_discounts_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_promotional_discounts" INTEGER,
  "compliance_of_ban_on_promotional_discounts_low" VARCHAR,
  "compliance_of_ban_on_promotional_discounts_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_educational_facil_79c0b170 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_educational_facilities_4344e0bc" INTEGER  -- Compliance Of Ban On Smoking In Educational Facilities Except Universities,
  "compliance_of_ban_on_smoking_in_educational_facilities_72ac723a" VARCHAR  -- Compliance Of Ban On Smoking In Educational Facilities Except Universities Low,
  "compliance_of_ban_on_smoking_in_educational_facilities_35e8e164" VARCHAR  -- Compliance Of Ban On Smoking In Educational Facilities Except Universities High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_educational_facil_c7f11d35 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_educational_facilities_4344e0bc" INTEGER  -- Compliance Of Ban On Smoking In Educational Facilities Except Universities,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_government_facilities_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_government_facilities" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_government_facilities_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_government_facilities" INTEGER,
  "compliance_of_ban_on_smoking_in_government_facilities_low" VARCHAR,
  "compliance_of_ban_on_smoking_in_government_facilities_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_health_care_facilities_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_health_care_facilities" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_health_care_facilities_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_health_care_facilities" INTEGER,
  "compliance_of_ban_on_smoking_in_health_care_facilities_low" VARCHAR,
  "compliance_of_ban_on_smoking_in_health_care_facilities_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_indoor_offices_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_indoor_offices" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_indoor_offices_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_indoor_offices" INTEGER,
  "compliance_of_ban_on_smoking_in_indoor_offices_low" VARCHAR,
  "compliance_of_ban_on_smoking_in_indoor_offices_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_of_ban_on_smoking_in_public_transport_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_of_ban_on_smoking_in_public_transport" INTEGER,
  "comments" VARCHAR
);