Global Health Observatory - World Health Organization

CREATE TABLE owid_most_sold_brand_of_cigarettes_price_in_pppdollar_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_price_in_pppdollar" FLOAT  -- Most Sold Brand Of Cigarettes, Price In Pppdollar
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_price_in_pppdollar_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_price_in_pppdollar" FLOAT  -- Most Sold Brand Of Cigarettes, Price In Pppdollar,
  "most_sold_brand_of_cigarettes_price_in_pppdollar_low" VARCHAR  -- Most Sold Brand Of Cigarettes, Price In Pppdollar Low,
  "most_sold_brand_of_cigarettes_price_in_pppdollar_high" VARCHAR  -- Most Sold Brand Of Cigarettes, Price In Pppdollar High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_price_in_usd_at_off_7e267465 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_price_in_usd_at_official_2d8d633b" FLOAT  -- Most Sold Brand Of Cigarettes, Price In Usd At Official Exchange Rates,
  "most_sold_brand_of_cigarettes_price_in_usd_at_official_40aa689a" VARCHAR  -- Most Sold Brand Of Cigarettes, Price In Usd At Official Exchange Rates Low,
  "most_sold_brand_of_cigarettes_price_in_usd_at_official_021eb3c7" VARCHAR  -- Most Sold Brand Of Cigarettes, Price In Usd At Official Exchange Rates High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_price_in_usd_at_off_e7253135 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_price_in_usd_at_official_2d8d633b" FLOAT  -- Most Sold Brand Of Cigarettes, Price In Usd At Official Exchange Rates
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_08da5aa1 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price_total_tax" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Total Tax,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__92272ce9" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Total Tax Low,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__394d7bbe" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Total Tax High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_0f9c2db7 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__c54c31d8" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Ad Valorem Excise
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_1b27e1c5 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__32ce7fa6" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Import Duties,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__0c3583e0" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Import Duties Low,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__9593efac" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Import Duties High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_50bf6c1a (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__a4562173" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Specific Excise,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__6b92be7a" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Specific Excise Low,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__388ae5d0" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Specific Excise High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_684cd4b1 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__c54c31d8" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Ad Valorem Excise,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__f2d6bbb7" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Ad Valorem Excise Low,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__de756a15" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Ad Valorem Excise High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_8b710025 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__32ce7fa6" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Import Duties
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_8df1a02a (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price_total_tax" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Total Tax
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_92160ed6 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__a4562173" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Specific Excise
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_9b08e223 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__1aa21156" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Other Taxes
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_defaf486 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__1aa21156" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Other Taxes,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__a03ee6a4" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Other Taxes Low,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__c5831096" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Other Taxes High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_e8ffbc09 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__ef1382c9" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Value Added Tax,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__47adbcac" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Value Added Tax Low,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__6904c5f3" VARCHAR  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Value Added Tax High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_cigarettes_taxes_as_a_pct_of_p_f17268fe (
  "year" INTEGER,
  "country" VARCHAR,
  "most_sold_brand_of_cigarettes_taxes_as_a_pct_of_price__ef1382c9" FLOAT  -- Most Sold Brand Of Cigarettes, Taxes As A Pct Of Price, Value Added Tax
);

CREATE TABLE owid_most_sold_brand_of_other_tobacco_type_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "comments" VARCHAR,
  "most_sold_brand_of_other_tobacco_type" VARCHAR
);

CREATE TABLE owid_most_sold_brand_of_other_tobacco_type_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "tobacco_and_nicotine_product" VARCHAR,
  "most_sold_brand_of_other_tobacco_type" VARCHAR,
  "most_sold_brand_of_other_tobacco_type_low" VARCHAR,
  "most_sold_brand_of_other_tobacco_type_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_most_sold_type_of_spirit_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "comments" VARCHAR,
  "most_sold_type_of_spirit" VARCHAR
);

CREATE TABLE owid_most_sold_type_of_spirit_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "most_sold_type_of_spirit" VARCHAR,
  "most_sold_type_of_spirit_low" VARCHAR,
  "most_sold_type_of_spirit_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_most_widely_used_screening_method_in_national_cer_634012e1 (
  "year" INTEGER,
  "country" VARCHAR,
  "most_widely_used_screening_method_in_national_cervical_dc668a46" VARCHAR  -- Most Widely Used Screening Method In National Cervical Cancer Screening Program,
  "most_widely_used_screening_method_in_national_cervical_0057e479" VARCHAR  -- Most Widely Used Screening Method In National Cervical Cancer Screening Program Low,
  "most_widely_used_screening_method_in_national_cervical_9b82f3c1" VARCHAR  -- Most Widely Used Screening Method In National Cervical Cancer Screening Program High,
  "comments" VARCHAR
);

CREATE TABLE owid_most_widely_used_screening_method_in_national_cer_927c91b2 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "most_widely_used_screening_method_in_national_cervical_dc668a46" VARCHAR  -- Most Widely Used Screening Method In National Cervical Cancer Screening Program
);

CREATE TABLE owid_mumps_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "mumps_number_of_reported_cases" UINTEGER  -- Mumps, Number Of Reported Cases
);

CREATE TABLE owid_mumps_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "mumps_number_of_reported_cases" UINTEGER  -- Mumps, Number Of Reported Cases,
  "mumps_number_of_reported_cases_low" VARCHAR  -- Mumps, Number Of Reported Cases Low,
  "mumps_number_of_reported_cases_high" VARCHAR  -- Mumps, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_name_of_latest_adult_prevalence_survey_nonsmoked_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "name_of_latest_adult_prevalence_survey_nonsmoked" VARCHAR  -- Name Of Latest Adult Prevalence Survey, Nonsmoked
);