Global Health Observatory - World Health Organization

CREATE TABLE owid_ban_on_promotional_discounts_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_promotional_discounts" VARCHAR
);

CREATE TABLE owid_ban_on_promotional_discounts_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_promotional_discounts" VARCHAR,
  "ban_on_promotional_discounts_low" VARCHAR,
  "ban_on_promotional_discounts_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_sponsorship_contributions_and_or_publicity_0f4cc102 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_sponsorship_contributions_and_or_publicity_of_c_67ac5ce3" VARCHAR  -- Ban On Sponsorship, Contributions And Or Publicity Of Contributions,
  "ban_on_sponsorship_contributions_and_or_publicity_of_c_b0dee90c" VARCHAR  -- Ban On Sponsorship, Contributions And Or Publicity Of Contributions Low,
  "ban_on_sponsorship_contributions_and_or_publicity_of_c_79be593e" VARCHAR  -- Ban On Sponsorship, Contributions And Or Publicity Of Contributions High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_sponsorship_contributions_and_or_publicity_d848e9ba (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_sponsorship_contributions_and_or_publicity_of_c_67ac5ce3" VARCHAR  -- Ban On Sponsorship, Contributions And Or Publicity Of Contributions
);

CREATE TABLE owid_ban_on_tobacco_companies_funding_or_making_contri_8d0be36a (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_tobacco_companies_funding_or_making_contributio_fb05d20e" VARCHAR  -- Ban On Tobacco Companies Funding Or Making Contributions, Including In Kind Contributions, To Smoking Prevention Media Campaigns, Including Those Directed At Youth,
  "ban_on_tobacco_companies_funding_or_making_contributio_85cdb16b" VARCHAR  -- Ban On Tobacco Companies Funding Or Making Contributions, Including In Kind Contributions, To Smoking Prevention Media Campaigns, Including Those Directed At Youth Low,
  "ban_on_tobacco_companies_funding_or_making_contributio_93cd570e" VARCHAR  -- Ban On Tobacco Companies Funding Or Making Contributions, Including In Kind Contributions, To Smoking Prevention Media Campaigns, Including Those Directed At Youth High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_tobacco_companies_funding_or_making_contri_df5d6af4 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_tobacco_companies_funding_or_making_contributio_fb05d20e" VARCHAR  -- Ban On Tobacco Companies Funding Or Making Contributions, Including In Kind Contributions, To Smoking Prevention Media Campaigns, Including Those Directed At Youth
);

CREATE TABLE owid_ban_on_tobacco_companies_the_tobacco_industry_pub_71a7d122 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_tobacco_companies_the_tobacco_industry_publiciz_49cb8643" VARCHAR  -- Ban On Tobacco Companies The Tobacco Industry Publicizing Their Csr Activities,
  "ban_on_tobacco_companies_the_tobacco_industry_publiciz_946d3565" VARCHAR  -- Ban On Tobacco Companies The Tobacco Industry Publicizing Their Csr Activities Low,
  "ban_on_tobacco_companies_the_tobacco_industry_publiciz_1de03a6e" VARCHAR  -- Ban On Tobacco Companies The Tobacco Industry Publicizing Their Csr Activities High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_tobacco_companies_the_tobacco_industry_pub_934049a6 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_tobacco_companies_the_tobacco_industry_publiciz_49cb8643" VARCHAR  -- Ban On Tobacco Companies The Tobacco Industry Publicizing Their Csr Activities
);

CREATE TABLE owid_ban_on_tobacco_companies_tobacco_industry_publici_0671fa78 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_tobacco_companies_tobacco_industry_publicizing__eed24e13" VARCHAR  -- Ban On Tobacco Companies Tobacco Industry Publicizing Their Corporate Social Responsibility Activities,
  "ban_on_tobacco_companies_tobacco_industry_publicizing__9eb17457" VARCHAR  -- Ban On Tobacco Companies Tobacco Industry Publicizing Their Corporate Social Responsibility Activities Low,
  "ban_on_tobacco_companies_tobacco_industry_publicizing__b990fb09" VARCHAR  -- Ban On Tobacco Companies Tobacco Industry Publicizing Their Corporate Social Responsibility Activities High,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_tobacco_companies_tobacco_industry_publici_3deb70b0 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_tobacco_companies_tobacco_industry_publicizing__eed24e13" VARCHAR  -- Ban On Tobacco Companies Tobacco Industry Publicizing Their Corporate Social Responsibility Activities
);

CREATE TABLE owid_ban_on_tobacco_vending_machines_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_tobacco_vending_machines" VARCHAR
);

CREATE TABLE owid_ban_on_tobacco_vending_machines_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_tobacco_vending_machines" VARCHAR,
  "ban_on_tobacco_vending_machines_low" VARCHAR,
  "ban_on_tobacco_vending_machines_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_ban_on_use_of_brand_name_of_non_tobacco_product_f_28013fec (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "ban_on_use_of_brand_name_of_non_tobacco_product_for_to_97e74d2c" VARCHAR  -- Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product
);

CREATE TABLE owid_ban_on_use_of_brand_name_of_non_tobacco_product_f_9917e4c0 (
  "year" INTEGER,
  "country" VARCHAR,
  "ban_on_use_of_brand_name_of_non_tobacco_product_for_to_97e74d2c" VARCHAR  -- Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product,
  "ban_on_use_of_brand_name_of_non_tobacco_product_for_to_ebd4be28" VARCHAR  -- Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product Low,
  "ban_on_use_of_brand_name_of_non_tobacco_product_for_to_fca5730d" VARCHAR  -- Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product High,
  "comments" VARCHAR
);

CREATE TABLE owid_barriers_to_accessing_assistive_products_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "barriers_to_accessing_assistive_products" VARCHAR,
  "barriers_to_accessing_assistive_products_pct" FLOAT  -- Barriers To Accessing Assistive Products, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_barriers_to_accessing_assistive_products_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "assistive_technology_product" VARCHAR,
  "barriers_to_accessing_assistive_products" VARCHAR,
  "barriers_to_accessing_assistive_products_pct" FLOAT  -- Barriers To Accessing Assistive Products, Pct,
  "barriers_to_accessing_assistive_products_pct_low" VARCHAR  -- Barriers To Accessing Assistive Products, Pct Low,
  "barriers_to_accessing_assistive_products_pct_high" VARCHAR  -- Barriers To Accessing Assistive Products, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_base_for_ad_valorem_excise_tax_on_beverage_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "comments" VARCHAR,
  "base_for_ad_valorem_excise_tax_on_beverage" VARCHAR
);

CREATE TABLE owid_base_for_ad_valorem_excise_tax_on_beverage_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "beverage_type" VARCHAR,
  "beverage" VARCHAR,
  "base_for_ad_valorem_excise_tax_on_beverage" VARCHAR,
  "base_for_ad_valorem_excise_tax_on_beverage_low" VARCHAR,
  "base_for_ad_valorem_excise_tax_on_beverage_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_basis_for_nha_estimate_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "basis_for_nha_estimate" INTEGER
);

CREATE TABLE owid_basis_for_nha_estimate_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "basis_for_nha_estimate" INTEGER,
  "basis_for_nha_estimate_low" VARCHAR,
  "basis_for_nha_estimate_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_bcg_immunization_coverage_among_1_year_olds_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "bcg_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Bcg Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_bcg_immunization_coverage_among_1_year_olds_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "bcg_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Bcg Immunization Coverage Among 1 Year Olds, Pct,
  "bcg_immunization_coverage_among_1_year_olds_pct_low" VARCHAR  -- Bcg Immunization Coverage Among 1 Year Olds, Pct Low,
  "bcg_immunization_coverage_among_1_year_olds_pct_high" VARCHAR  -- Bcg Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_bcg_immunization_coverage_among_one_year_olds_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_decile" VARCHAR,
  "bcg_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Bcg Immunization Coverage Among One Year Olds, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_bcg_immunization_coverage_among_one_year_olds_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "bcg_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Bcg Immunization Coverage Among One Year Olds, Pct,
  "bcg_immunization_coverage_among_one_year_olds_pct_low" FLOAT  -- Bcg Immunization Coverage Among One Year Olds, Pct Low,
  "bcg_immunization_coverage_among_one_year_olds_pct_high" FLOAT  -- Bcg Immunization Coverage Among One Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_beds_for_mental_health_in_general_hospitals_per_1_325ca65c (
  "year" INTEGER,
  "country" VARCHAR,
  "beds_for_mental_health_in_general_hospitals_per_100_00_ef1b86ef" FLOAT  -- Beds For Mental Health In General Hospitals, Per 100–000 Population,
  "beds_for_mental_health_in_general_hospitals_per_100_00_7cc45faf" VARCHAR  -- Beds For Mental Health In General Hospitals, Per 100–000 Population Low,
  "beds_for_mental_health_in_general_hospitals_per_100_00_58b30b25" VARCHAR  -- Beds For Mental Health In General Hospitals, Per 100–000 Population High,
  "comments" VARCHAR
);