Global Health Observatory - World Health Organization

CREATE TABLE owid_ban_on_appearance_of_tobacco_products_in_tv_and_or_films_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_appearance_of_tobacco_products_in_tv_and_or_films" VARCHAR,
  "ban_on_appearance_of_tobacco_products_in_tv_and_or_films_low" VARCHAR,
  "ban_on_appearance_of_tobacco_products_in_tv_and_or_films_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_billboard_and_outdoor_advertising_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_billboard_and_outdoor_advertising" VARCHAR
);

CREATE TABLE owid_ban_on_billboard_and_outdoor_advertising_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_billboard_and_outdoor_advertising" VARCHAR,
  "ban_on_billboard_and_outdoor_advertising_low" VARCHAR,
  "ban_on_billboard_and_outdoor_advertising_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_corporate_social_responsibility_activities_csr_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_corporate_social_responsibility_activities_csr" VARCHAR  -- Ban On Corporate Social Responsibility Activities, Csr
);

CREATE TABLE owid_ban_on_corporate_social_responsibility_activities_csr_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_corporate_social_responsibility_activities_csr" VARCHAR  -- Ban On Corporate Social Responsibility Activities, Csr,
  "ban_on_corporate_social_responsibility_activities_csr_low" VARCHAR  -- Ban On Corporate Social Responsibility Activities, Csr Low,
  "ban_on_corporate_social_responsibility_activities_csr_high" VARCHAR  -- Ban On Corporate Social Responsibility Activities, Csr High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_deceitful_terms_on_cigarette_packaging_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_deceitful_terms_on_cigarette_packaging" VARCHAR
);

CREATE TABLE owid_ban_on_deceitful_terms_on_cigarette_packaging_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_deceitful_terms_on_cigarette_packaging" VARCHAR,
  "ban_on_deceitful_terms_on_cigarette_packaging_low" VARCHAR,
  "ban_on_deceitful_terms_on_cigarette_packaging_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_deceitful_terms_on_other_smoked_tobacco_packaging_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_deceitful_terms_on_other_smoked_tobacco_packaging" VARCHAR
);

CREATE TABLE owid_ban_on_deceitful_terms_on_other_smoked_tobacco_packaging_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_deceitful_terms_on_other_smoked_tobacco_packaging" VARCHAR,
  "ban_on_deceitful_terms_on_other_smoked_tobacco_packaging_low" VARCHAR,
  "ban_on_deceitful_terms_on_other_smoked_tobacco_packaging_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_deceitful_terms_on_smokeless_tobacco_packaging_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_deceitful_terms_on_smokeless_tobacco_packaging" VARCHAR
);

CREATE TABLE owid_ban_on_deceitful_terms_on_smokeless_tobacco_packaging_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_deceitful_terms_on_smokeless_tobacco_packaging" VARCHAR,
  "ban_on_deceitful_terms_on_smokeless_tobacco_packaging_low" VARCHAR,
  "ban_on_deceitful_terms_on_smokeless_tobacco_packaging_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_display_of_tobacco_products_at_points_of_sale_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_display_of_tobacco_products_at_points_of_sale" VARCHAR
);

CREATE TABLE owid_ban_on_display_of_tobacco_products_at_points_of_sale_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_display_of_tobacco_products_at_points_of_sale" VARCHAR,
  "ban_on_display_of_tobacco_products_at_points_of_sale_low" VARCHAR,
  "ban_on_display_of_tobacco_products_at_points_of_sale_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_entities_other_than_tobacco_companies_the__002d87c0 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_entities_other_than_tobacco_companies_the_tobac_30953af2" VARCHAR  -- Ban On Entities Other Than Tobacco Companies The Tobacco Industry Publicizing The Csr Activities Of The Tobacco Companies Industry,
  "ban_on_entities_other_than_tobacco_companies_the_tobac_c3475738" VARCHAR  -- Ban On Entities Other Than Tobacco Companies The Tobacco Industry Publicizing The Csr Activities Of The Tobacco Companies Industry Low,
  "ban_on_entities_other_than_tobacco_companies_the_tobac_aea679e3" VARCHAR  -- Ban On Entities Other Than Tobacco Companies The Tobacco Industry Publicizing The Csr Activities Of The Tobacco Companies Industry High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_entities_other_than_tobacco_companies_the__31eac3ed (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_entities_other_than_tobacco_companies_the_tobac_30953af2" VARCHAR  -- Ban On Entities Other Than Tobacco Companies The Tobacco Industry Publicizing The Csr Activities Of The Tobacco Companies Industry
);

CREATE TABLE owid_ban_on_entities_other_than_tobacco_companies_toba_4b97ce44 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_entities_other_than_tobacco_companies_tobacco_i_e00e4d1f" VARCHAR  -- Ban On Entities Other Than Tobacco Companies Tobacco Industry Publicizing The Corporate Social Responsibility Activities Of The Tobacco Companies
);

CREATE TABLE owid_ban_on_entities_other_than_tobacco_companies_toba_8161cd19 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_entities_other_than_tobacco_companies_tobacco_i_e00e4d1f" VARCHAR  -- Ban On Entities Other Than Tobacco Companies Tobacco Industry Publicizing The Corporate Social Responsibility Activities Of The Tobacco Companies,
  "ban_on_entities_other_than_tobacco_companies_tobacco_i_44980d62" VARCHAR  -- Ban On Entities Other Than Tobacco Companies Tobacco Industry Publicizing The Corporate Social Responsibility Activities Of The Tobacco Companies Low,
  "ban_on_entities_other_than_tobacco_companies_tobacco_i_2ae1da68" VARCHAR  -- Ban On Entities Other Than Tobacco Companies Tobacco Industry Publicizing The Corporate Social Responsibility Activities Of The Tobacco Companies High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_free_distribution_in_mail_or_through_other_means_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_free_distribution_in_mail_or_through_other_means" VARCHAR
);

CREATE TABLE owid_ban_on_free_distribution_in_mail_or_through_other_means_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_free_distribution_in_mail_or_through_other_means" VARCHAR,
  "ban_on_free_distribution_in_mail_or_through_other_means_low" VARCHAR,
  "ban_on_free_distribution_in_mail_or_through_other_means_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_identifying_non_tobacco_products_with_toba_62cb9bf3 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_identifying_non_tobacco_products_with_tobacco_b_36906c96" VARCHAR  -- Ban On Identifying Non Tobacco Products With Tobacco Brand Names
);

CREATE TABLE owid_ban_on_identifying_non_tobacco_products_with_toba_d0f61d07 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_identifying_non_tobacco_products_with_tobacco_b_36906c96" VARCHAR  -- Ban On Identifying Non Tobacco Products With Tobacco Brand Names,
  "ban_on_identifying_non_tobacco_products_with_tobacco_b_809f81ec" VARCHAR  -- Ban On Identifying Non Tobacco Products With Tobacco Brand Names Low,
  "ban_on_identifying_non_tobacco_products_with_tobacco_b_0b4d9831" VARCHAR  -- Ban On Identifying Non Tobacco Products With Tobacco Brand Names High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_internet_sales_of_tobacco_products_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_internet_sales_of_tobacco_products" VARCHAR
);

CREATE TABLE owid_ban_on_internet_sales_of_tobacco_products_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_internet_sales_of_tobacco_products" VARCHAR,
  "ban_on_internet_sales_of_tobacco_products_low" VARCHAR,
  "ban_on_internet_sales_of_tobacco_products_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_product_display_at_point_of_sale_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_product_display_at_point_of_sale" VARCHAR
);

CREATE TABLE owid_ban_on_product_display_at_point_of_sale_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_product_display_at_point_of_sale" VARCHAR,
  "ban_on_product_display_at_point_of_sale_low" VARCHAR,
  "ban_on_product_display_at_point_of_sale_high" VARCHAR,
  "comments" VARCHAR
);