Global Health Observatory - World Health Organization

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_value_a_041c3c6a (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_value_added_tax" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Value Added Tax,
  "comments" VARCHAR
);

CREATE TABLE owid_average_taxes_as_a_pct_of_cigarette_price_value_a_4301c2ec (
  "year" INTEGER,
  "country" VARCHAR,
  "average_taxes_as_a_pct_of_cigarette_price_value_added_tax" FLOAT  -- Average, Taxes As A Pct Of Cigarette Price, Value Added Tax,
  "average_taxes_as_a_pct_of_cigarette_price_value_added_tax_low" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Value Added Tax Low,
  "average_taxes_as_a_pct_of_cigarette_price_value_added_tax_high" VARCHAR  -- Average, Taxes As A Pct Of Cigarette Price, Value Added Tax High,
  "comments" VARCHAR
);

CREATE TABLE owid_awareness_activities_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_awareness_activity_types" VARCHAR,
  "awareness_activities" VARCHAR
);

CREATE TABLE owid_awareness_activities_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_awareness_activity_types" VARCHAR,
  "awareness_activities" VARCHAR,
  "awareness_activities_low" VARCHAR,
  "awareness_activities_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_banning_the_publicity_of_financial_or_other_spons_840f8c6a (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "banning_the_publicity_of_financial_or_other_sponsorshi_e024393f" VARCHAR  -- Banning The Publicity Of Financial Or Other Sponsorship Or Support By The Tobacco Industry Of Events, Activities, Individuals
);

CREATE TABLE owid_banning_the_publicity_of_financial_or_other_spons_d8d81041 (
  "year" INTEGER,
  "country" VARCHAR,
  "banning_the_publicity_of_financial_or_other_sponsorshi_e024393f" VARCHAR  -- Banning The Publicity Of Financial Or Other Sponsorship Or Support By The Tobacco Industry Of Events, Activities, Individuals,
  "banning_the_publicity_of_financial_or_other_sponsorshi_9e4c2455" VARCHAR  -- Banning The Publicity Of Financial Or Other Sponsorship Or Support By The Tobacco Industry Of Events, Activities, Individuals Low,
  "banning_the_publicity_of_financial_or_other_sponsorshi_b7769562" VARCHAR  -- Banning The Publicity Of Financial Or Other Sponsorship Or Support By The Tobacco Industry Of Events, Activities, Individuals High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_at_point_of_sale_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_advertising_at_point_of_sale" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_at_point_of_sale_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_advertising_at_point_of_sale" VARCHAR,
  "ban_on_advertising_at_point_of_sale_low" VARCHAR,
  "ban_on_advertising_at_point_of_sale_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_in_international_magazines_and_29c6a7dd (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_advertising_in_international_magazines_and_newspapers" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_in_international_magazines_and_7211de67 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_advertising_in_international_magazines_and_newspapers" VARCHAR,
  "ban_on_advertising_in_international_magazines_and_news_36defe4a" VARCHAR  -- Ban On Advertising In International Magazines And Newspapers Low,
  "ban_on_advertising_in_international_magazines_and_news_c6954c27" VARCHAR  -- Ban On Advertising In International Magazines And Newspapers High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_in_local_magazines_and_newspapers_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_advertising_in_local_magazines_and_newspapers" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_in_local_magazines_and_newspapers_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_advertising_in_local_magazines_and_newspapers" VARCHAR,
  "ban_on_advertising_in_local_magazines_and_newspapers_low" VARCHAR,
  "ban_on_advertising_in_local_magazines_and_newspapers_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_on_international_television_and_radio_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_advertising_on_international_television_and_radio" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_on_international_television_and_radio_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_advertising_on_international_television_and_radio" VARCHAR,
  "ban_on_advertising_on_international_television_and_radio_low" VARCHAR,
  "ban_on_advertising_on_international_television_and_radio_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_on_national_television_and_radio_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_advertising_on_national_television_and_radio" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_on_national_television_and_radio_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_advertising_on_national_television_and_radio" VARCHAR,
  "ban_on_advertising_on_national_television_and_radio_low" VARCHAR,
  "ban_on_advertising_on_national_television_and_radio_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_on_the_internet_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_advertising_on_the_internet" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_on_the_internet_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_advertising_on_the_internet" VARCHAR,
  "ban_on_advertising_on_the_internet_low" VARCHAR,
  "ban_on_advertising_on_the_internet_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_advertising_point_of_sale_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_advertising_point_of_sale" VARCHAR  -- Ban On Advertising, Point Of Sale
);

CREATE TABLE owid_ban_on_advertising_point_of_sale_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_advertising_point_of_sale" VARCHAR  -- Ban On Advertising, Point Of Sale,
  "ban_on_advertising_point_of_sale_low" VARCHAR  -- Ban On Advertising, Point Of Sale Low,
  "ban_on_advertising_point_of_sale_high" VARCHAR  -- Ban On Advertising, Point Of Sale High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_any_form_of_contribution_financial_or_othe_2330eb7a (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_any_form_of_contribution_financial_or_other_sup_c0b4b5c2" VARCHAR  -- Ban On Any Form Of Contribution, Financial Or Other Support, To Any Event, Activity Or Individual
);

CREATE TABLE owid_ban_on_any_form_of_contribution_financial_or_othe_83e58296 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_any_form_of_contribution_financial_or_other_sup_c0b4b5c2" VARCHAR  -- Ban On Any Form Of Contribution, Financial Or Other Support, To Any Event, Activity Or Individual,
  "ban_on_any_form_of_contribution_financial_or_other_sup_62b8a7cd" VARCHAR  -- Ban On Any Form Of Contribution, Financial Or Other Support, To Any Event, Activity Or Individual Low,
  "ban_on_any_form_of_contribution_financial_or_other_sup_89ab5ff7" VARCHAR  -- Ban On Any Form Of Contribution, Financial Or Other Support, To Any Event, Activity Or Individual High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_appearance_of_tobacco_brands_in_tv_and_or__192a15c4 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_appearance_of_tobacco_brands_in_tv_and_or_films_14427d45" VARCHAR  -- Ban On Appearance Of Tobacco Brands In Tv And Or Films, Product Placement,
  "ban_on_appearance_of_tobacco_brands_in_tv_and_or_films_f30b4ea7" VARCHAR  -- Ban On Appearance Of Tobacco Brands In Tv And Or Films, Product Placement Low,
  "ban_on_appearance_of_tobacco_brands_in_tv_and_or_films_e7e59e62" VARCHAR  -- Ban On Appearance Of Tobacco Brands In Tv And Or Films, Product Placement High,
  "comments" VARCHAR
);

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

CREATE TABLE owid_ban_on_appearance_of_tobacco_products_in_tv_and_or_films_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_appearance_of_tobacco_products_in_tv_and_or_films" VARCHAR
);