Global Health Observatory - World Health Organization

CREATE TABLE owid_compliance_with_ban_on_promotional_discounts_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_ban_on_promotional_discounts_score" INTEGER  -- Compliance With Ban On Promotional Discounts, Score
);

CREATE TABLE owid_compliance_with_ban_on_promotional_discounts_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_ban_on_promotional_discounts_score" INTEGER  -- Compliance With Ban On Promotional Discounts, Score,
  "compliance_with_ban_on_promotional_discounts_score_low" VARCHAR  -- Compliance With Ban On Promotional Discounts, Score Low,
  "compliance_with_ban_on_promotional_discounts_score_high" VARCHAR  -- Compliance With Ban On Promotional Discounts, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_ban_on_sponsorship_contributions__50d798ce (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_ban_on_sponsorship_contributions_and_o_a6cb7e95" INTEGER  -- Compliance With Ban On Sponsorship, Contributions And Or Publicity Of Contributions, Score,
  "compliance_with_ban_on_sponsorship_contributions_and_o_d772d386" VARCHAR  -- Compliance With Ban On Sponsorship, Contributions And Or Publicity Of Contributions, Score Low,
  "compliance_with_ban_on_sponsorship_contributions_and_o_cbdf131c" VARCHAR  -- Compliance With Ban On Sponsorship, Contributions And Or Publicity Of Contributions, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_ban_on_sponsorship_contributions__6bb39958 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_ban_on_sponsorship_contributions_and_o_a6cb7e95" INTEGER  -- Compliance With Ban On Sponsorship, Contributions And Or Publicity Of Contributions, Score
);

CREATE TABLE owid_compliance_with_ban_on_use_of_brand_name_of_non_t_4ec833bf (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_ban_on_use_of_brand_name_of_non_tobacc_1bb60888" INTEGER  -- Compliance With Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product, Score,
  "compliance_with_ban_on_use_of_brand_name_of_non_tobacc_7ee38939" VARCHAR  -- Compliance With Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product, Score Low,
  "compliance_with_ban_on_use_of_brand_name_of_non_tobacc_71d7fc6e" VARCHAR  -- Compliance With Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_ban_on_use_of_brand_name_of_non_t_bdb9d0d1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_ban_on_use_of_brand_name_of_non_tobacc_1bb60888" INTEGER  -- Compliance With Ban On Use Of Brand Name Of Non Tobacco Product For Tobacco Product, Score
);

CREATE TABLE owid_compliance_with_bans_on_direct_advertising_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_bans_on_direct_advertising" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_bans_on_direct_advertising_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_bans_on_direct_advertising" INTEGER,
  "compliance_with_bans_on_direct_advertising_low" VARCHAR,
  "compliance_with_bans_on_direct_advertising_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_bans_on_promotion_and_sponsorship_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_bans_on_promotion_and_sponsorship" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_bans_on_promotion_and_sponsorship_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_bans_on_promotion_and_sponsorship" INTEGER,
  "compliance_with_bans_on_promotion_and_sponsorship_low" VARCHAR,
  "compliance_with_bans_on_promotion_and_sponsorship_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_international_health_regulations_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_international_health_regulations" INTEGER
);

CREATE TABLE owid_compliance_with_international_health_regulations_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_international_health_regulations" INTEGER,
  "compliance_with_international_health_regulations_low" VARCHAR,
  "compliance_with_international_health_regulations_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_regulations_on_smoke_free_environ_7fc77b47 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_regulations_on_smoke_free_environments_db398c54" INTEGER  -- Compliance With Regulations On Smoke Free Environments, National Legislation,
  "compliance_with_regulations_on_smoke_free_environments_4ab5d1cf" VARCHAR  -- Compliance With Regulations On Smoke Free Environments, National Legislation Low,
  "compliance_with_regulations_on_smoke_free_environments_39bba4a2" VARCHAR  -- Compliance With Regulations On Smoke Free Environments, National Legislation High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_regulations_on_smoke_free_environ_f24c52cc (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_regulations_on_smoke_free_environments_db398c54" INTEGER  -- Compliance With Regulations On Smoke Free Environments, National Legislation,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_education_facilities_e_86326c7d (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_education_facilities_except_3a2e9b5d" INTEGER  -- Compliance With Smoke Free Education Facilities Except Universities Law, Score,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_education_facilities_e_f7bdbba6 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_education_facilities_except_3a2e9b5d" INTEGER  -- Compliance With Smoke Free Education Facilities Except Universities Law, Score,
  "compliance_with_smoke_free_education_facilities_except_c8d11d53" VARCHAR  -- Compliance With Smoke Free Education Facilities Except Universities Law, Score Low,
  "compliance_with_smoke_free_education_facilities_except_f77105f3" VARCHAR  -- Compliance With Smoke Free Education Facilities Except Universities Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_government_facilities__8b33e547 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_government_facilities_law_score" INTEGER  -- Compliance With Smoke Free Government Facilities Law, Score,
  "compliance_with_smoke_free_government_facilities_law_score_low" VARCHAR  -- Compliance With Smoke Free Government Facilities Law, Score Low,
  "compliance_with_smoke_free_government_facilities_law_score_high" VARCHAR  -- Compliance With Smoke Free Government Facilities Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_government_facilities__f0a77bb2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_government_facilities_law_score" INTEGER  -- Compliance With Smoke Free Government Facilities Law, Score,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_health_care_facilities_0dc102b2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_health_care_facilities_law_score" INTEGER  -- Compliance With Smoke Free Health Care Facilities Law, Score,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_health_care_facilities_f87702b8 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_health_care_facilities_law_score" INTEGER  -- Compliance With Smoke Free Health Care Facilities Law, Score,
  "compliance_with_smoke_free_health_care_facilities_law_score_low" VARCHAR  -- Compliance With Smoke Free Health Care Facilities Law, Score Low,
  "compliance_with_smoke_free_health_care_facilities_law__76d66dc5" VARCHAR  -- Compliance With Smoke Free Health Care Facilities Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_indoor_offices_law_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_indoor_offices_law_score" INTEGER  -- Compliance With Smoke Free Indoor Offices Law, Score,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_indoor_offices_law_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_indoor_offices_law_score" INTEGER  -- Compliance With Smoke Free Indoor Offices Law, Score,
  "compliance_with_smoke_free_indoor_offices_law_score_low" VARCHAR  -- Compliance With Smoke Free Indoor Offices Law, Score Low,
  "compliance_with_smoke_free_indoor_offices_law_score_high" VARCHAR  -- Compliance With Smoke Free Indoor Offices Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_public_transport_law_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_public_transport_law_score" INTEGER  -- Compliance With Smoke Free Public Transport Law, Score,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_public_transport_law_score_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_public_transport_law_score" INTEGER  -- Compliance With Smoke Free Public Transport Law, Score,
  "compliance_with_smoke_free_public_transport_law_score_low" VARCHAR  -- Compliance With Smoke Free Public Transport Law, Score Low,
  "compliance_with_smoke_free_public_transport_law_score_high" VARCHAR  -- Compliance With Smoke Free Public Transport Law, Score High,
  "comments" VARCHAR
);

CREATE TABLE owid_compliance_with_smoke_free_pubs_and_bars_law_score_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "compliance_with_smoke_free_pubs_and_bars_law_score" INTEGER  -- Compliance With Smoke Free Pubs And Bars Law, Score,
  "comments" VARCHAR
);