Global Health Observatory - World Health Organization

CREATE TABLE owid_tobacco_tax_revenues_import_duties_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_import_duties" FLOAT  -- Tobacco Tax Revenues, Import Duties,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_import_duties_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_import_duties" FLOAT  -- Tobacco Tax Revenues, Import Duties,
  "tobacco_tax_revenues_import_duties_low" VARCHAR  -- Tobacco Tax Revenues, Import Duties Low,
  "tobacco_tax_revenues_import_duties_high" VARCHAR  -- Tobacco Tax Revenues, Import Duties High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_import_duties_and_all_other_taxes (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_import_duties_and_all_other_taxes" FLOAT  -- Tobacco Tax Revenues, Import Duties And All Other Taxes,
  "tobacco_tax_revenues_import_duties_and_all_other_taxes_low" VARCHAR  -- Tobacco Tax Revenues, Import Duties And All Other Taxes Low,
  "tobacco_tax_revenues_import_duties_and_all_other_taxes_high" VARCHAR  -- Tobacco Tax Revenues, Import Duties And All Other Taxes High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_other_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_other" FLOAT  -- Tobacco Tax Revenues, Other,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_other_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_other" FLOAT  -- Tobacco Tax Revenues, Other,
  "tobacco_tax_revenues_other_low" VARCHAR  -- Tobacco Tax Revenues, Other Low,
  "tobacco_tax_revenues_other_high" VARCHAR  -- Tobacco Tax Revenues, Other High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_tobacco_product_types_included_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "tobacco_tax_revenues_tobacco_product_types_included" VARCHAR  -- Tobacco Tax Revenues, Tobacco Product Types Included
);

CREATE TABLE owid_tobacco_tax_revenues_tobacco_product_types_included_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_tobacco_product_types_included" VARCHAR  -- Tobacco Tax Revenues, Tobacco Product Types Included,
  "tobacco_tax_revenues_tobacco_product_types_included_low" VARCHAR  -- Tobacco Tax Revenues, Tobacco Product Types Included Low,
  "tobacco_tax_revenues_tobacco_product_types_included_high" VARCHAR  -- Tobacco Tax Revenues, Tobacco Product Types Included High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_total_excise_specific_and_ad_50a8ce35 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_total_excise_specific_and_ad_valorem" FLOAT  -- Tobacco Tax Revenues, Total Excise, Specific And Ad Valorem,
  "tobacco_tax_revenues_total_excise_specific_and_ad_valorem_low" VARCHAR  -- Tobacco Tax Revenues, Total Excise, Specific And Ad Valorem Low,
  "tobacco_tax_revenues_total_excise_specific_and_ad_valorem_high" VARCHAR  -- Tobacco Tax Revenues, Total Excise, Specific And Ad Valorem High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_total_excise_specific_and_ad_e1ea4a6f (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_total_excise_specific_and_ad_valorem" FLOAT  -- Tobacco Tax Revenues, Total Excise, Specific And Ad Valorem,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_total_revenues_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_total_revenues" BIGINT  -- Tobacco Tax Revenues, Total Revenues,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_total_revenues_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_total_revenues" BIGINT  -- Tobacco Tax Revenues, Total Revenues,
  "tobacco_tax_revenues_total_revenues_low" VARCHAR  -- Tobacco Tax Revenues, Total Revenues Low,
  "tobacco_tax_revenues_total_revenues_high" VARCHAR  -- Tobacco Tax Revenues, Total Revenues High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_valued_added_tax_vat_and_oth_1613633a (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_valued_added_tax_vat_and_other_sales_taxes" FLOAT  -- Tobacco Tax Revenues, Valued Added Tax, Vat, And Other Sales Taxes,
  "tobacco_tax_revenues_valued_added_tax_vat_and_other_sa_3761791f" VARCHAR  -- Tobacco Tax Revenues, Valued Added Tax, Vat, And Other Sales Taxes Low,
  "tobacco_tax_revenues_valued_added_tax_vat_and_other_sa_d379f5f0" VARCHAR  -- Tobacco Tax Revenues, Valued Added Tax, Vat, And Other Sales Taxes High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_revenues_valued_added_tax_vat_and_oth_b000d495 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_revenues_valued_added_tax_vat_and_other_sales_taxes" FLOAT  -- Tobacco Tax Revenues, Valued Added Tax, Vat, And Other Sales Taxes,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_a_minimum_price_policy_is_i_11e6ee3b (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_a_minimum_price_policy_is_implemented" VARCHAR  -- Tobacco Tax Structure, A Minimum Price Policy Is Implemented,
  "tobacco_tax_structure_a_minimum_price_policy_is_implemented_low" VARCHAR  -- Tobacco Tax Structure, A Minimum Price Policy Is Implemented Low,
  "tobacco_tax_structure_a_minimum_price_policy_is_implem_e2eef9e1" VARCHAR  -- Tobacco Tax Structure, A Minimum Price Policy Is Implemented High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_a_minimum_price_policy_is_i_d2969a20 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_a_minimum_price_policy_is_implemented" VARCHAR  -- Tobacco Tax Structure, A Minimum Price Policy Is Implemented
);

CREATE TABLE owid_tobacco_tax_structure_excise_tax_proportion_of_price_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "tobacco_tax_structure_excise_tax_proportion_of_price" FLOAT  -- Tobacco Tax Structure, Excise Tax Proportion Of Price,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_excise_tax_proportion_of_price_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "tobacco_tax_structure_excise_tax_proportion_of_price" FLOAT  -- Tobacco Tax Structure, Excise Tax Proportion Of Price,
  "tobacco_tax_structure_excise_tax_proportion_of_price_low" VARCHAR  -- Tobacco Tax Structure, Excise Tax Proportion Of Price Low,
  "tobacco_tax_structure_excise_tax_proportion_of_price_high" VARCHAR  -- Tobacco Tax Structure, Excise Tax Proportion Of Price High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_greater_reliance_on_specifi_4c5f51f3 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_greater_reliance_on_specific_tax_9ce2478b" VARCHAR  -- Tobacco Tax Structure, Greater Reliance On Specific Tax In Mixed Excise Regime,
  "tobacco_tax_structure_greater_reliance_on_specific_tax_74099a5e" VARCHAR  -- Tobacco Tax Structure, Greater Reliance On Specific Tax In Mixed Excise Regime Low,
  "tobacco_tax_structure_greater_reliance_on_specific_tax_394ebcba" VARCHAR  -- Tobacco Tax Structure, Greater Reliance On Specific Tax In Mixed Excise Regime High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_greater_reliance_on_specifi_bf8316ef (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_greater_reliance_on_specific_tax_9ce2478b" VARCHAR  -- Tobacco Tax Structure, Greater Reliance On Specific Tax In Mixed Excise Regime
);

CREATE TABLE owid_tobacco_tax_structure_minimum_specific_tax_applie_507751b9 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_minimum_specific_tax_applied_in__14f29842" VARCHAR  -- Tobacco Tax Structure, Minimum Specific Tax Applied In Ad Valorem Or Mixed Excise Regime
);

CREATE TABLE owid_tobacco_tax_structure_minimum_specific_tax_applie_e832583c (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_minimum_specific_tax_applied_in__14f29842" VARCHAR  -- Tobacco Tax Structure, Minimum Specific Tax Applied In Ad Valorem Or Mixed Excise Regime,
  "tobacco_tax_structure_minimum_specific_tax_applied_in__da030529" VARCHAR  -- Tobacco Tax Structure, Minimum Specific Tax Applied In Ad Valorem Or Mixed Excise Regime Low,
  "tobacco_tax_structure_minimum_specific_tax_applied_in__49912b0c" VARCHAR  -- Tobacco Tax Structure, Minimum Specific Tax Applied In Ad Valorem Or Mixed Excise Regime High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_price_dispersion_share_of_c_2a741996 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_price_dispersion_share_of_cheape_079bf7f0" FLOAT  -- Tobacco Tax Structure, Price Dispersion, Share Of Cheapest Brand Price In Premium Brand Price, Pct, The Higher The Pct The Smaller The Gap,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_price_dispersion_share_of_c_43b5f838 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_price_dispersion_share_of_cheape_079bf7f0" FLOAT  -- Tobacco Tax Structure, Price Dispersion, Share Of Cheapest Brand Price In Premium Brand Price, Pct, The Higher The Pct The Smaller The Gap,
  "tobacco_tax_structure_price_dispersion_share_of_cheape_e25acaa5" VARCHAR  -- Tobacco Tax Structure, Price Dispersion, Share Of Cheapest Brand Price In Premium Brand Price, Pct, The Higher The Pct The Smaller The Gap Low,
  "tobacco_tax_structure_price_dispersion_share_of_cheape_62b04de6" VARCHAR  -- Tobacco Tax Structure, Price Dispersion, Share Of Cheapest Brand Price In Premium Brand Price, Pct, The Higher The Pct The Smaller The Gap High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_price_gap_decreased_over_th_219867e3 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_price_gap_decreased_over_the_las_5c7e9555" VARCHAR  -- Tobacco Tax Structure, Price Gap Decreased Over The Last Two Years, Cheapest Brand Of Cigarettes Versus The Premium Brand,
  "tobacco_tax_structure_price_gap_decreased_over_the_las_15c32c64" VARCHAR  -- Tobacco Tax Structure, Price Gap Decreased Over The Last Two Years, Cheapest Brand Of Cigarettes Versus The Premium Brand Low,
  "tobacco_tax_structure_price_gap_decreased_over_the_las_76fc369a" VARCHAR  -- Tobacco Tax Structure, Price Gap Decreased Over The Last Two Years, Cheapest Brand Of Cigarettes Versus The Premium Brand High,
  "comments" VARCHAR
);

CREATE TABLE owid_tobacco_tax_structure_price_gap_decreased_over_th_c30445be (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_tax_structure_price_gap_decreased_over_the_las_5c7e9555" VARCHAR  -- Tobacco Tax Structure, Price Gap Decreased Over The Last Two Years, Cheapest Brand Of Cigarettes Versus The Premium Brand
);