Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_compliance_of_ban_on_smoking_in_public_transport_2 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_smoking_in_public_transport" INTEGER,
"compliance_of_ban_on_smoking_in_public_transport_low" VARCHAR,
"compliance_of_ban_on_smoking_in_public_transport_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_smoking_in_pubs_and_bars_1 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_smoking_in_pubs_and_bars" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_smoking_in_pubs_and_bars_2 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_smoking_in_pubs_and_bars" INTEGER,
"compliance_of_ban_on_smoking_in_pubs_and_bars_low" VARCHAR,
"compliance_of_ban_on_smoking_in_pubs_and_bars_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_smoking_in_restaurants_1 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_smoking_in_restaurants" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_smoking_in_restaurants_2 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_smoking_in_restaurants" INTEGER,
"compliance_of_ban_on_smoking_in_restaurants_low" VARCHAR,
"compliance_of_ban_on_smoking_in_restaurants_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_smoking_in_universities_1 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_smoking_in_universities" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_smoking_in_universities_2 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_smoking_in_universities" INTEGER,
"compliance_of_ban_on_smoking_in_universities_low" VARCHAR,
"compliance_of_ban_on_smoking_in_universities_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_sponsored_events_1 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_sponsored_events" INTEGER,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_of_ban_on_sponsored_events_2 (
"year" INTEGER,
"country" VARCHAR,
"compliance_of_ban_on_sponsored_events" INTEGER,
"compliance_of_ban_on_sponsored_events_low" VARCHAR,
"compliance_of_ban_on_sponsored_events_high" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_advertising_at_point_of_sa_48079d33 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_advertising_at_point_of_sale_score" INTEGER -- Compliance With Ban On Advertising At Point Of Sale, Score,
"compliance_with_ban_on_advertising_at_point_of_sale_score_low" VARCHAR -- Compliance With Ban On Advertising At Point Of Sale, Score Low,
"compliance_with_ban_on_advertising_at_point_of_sale_score_high" VARCHAR -- Compliance With Ban On Advertising At Point Of Sale, Score High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_advertising_at_point_of_sa_cb9579e4 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_advertising_at_point_of_sale_score" INTEGER -- Compliance With Ban On Advertising At Point Of Sale, Score
);
CREATE TABLE owid_compliance_with_ban_on_advertising_in_local_magaz_21757350 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_advertising_in_local_magazines__10705c99" INTEGER -- Compliance With Ban On Advertising In Local Magazines And Newspapers, Score
);
CREATE TABLE owid_compliance_with_ban_on_advertising_in_local_magaz_528f3eed (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_advertising_in_local_magazines__10705c99" INTEGER -- Compliance With Ban On Advertising In Local Magazines And Newspapers, Score,
"compliance_with_ban_on_advertising_in_local_magazines__92d86d7a" VARCHAR -- Compliance With Ban On Advertising In Local Magazines And Newspapers, Score Low,
"compliance_with_ban_on_advertising_in_local_magazines__1b7dd627" VARCHAR -- Compliance With Ban On Advertising In Local Magazines And Newspapers, Score High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_advertising_on_national_te_4b115f7d (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_advertising_on_national_televis_0ae76bf9" INTEGER -- Compliance With Ban On Advertising On National Television And Radio, Score,
"compliance_with_ban_on_advertising_on_national_televis_b0884144" VARCHAR -- Compliance With Ban On Advertising On National Television And Radio, Score Low,
"compliance_with_ban_on_advertising_on_national_televis_146fa922" VARCHAR -- Compliance With Ban On Advertising On National Television And Radio, Score High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_advertising_on_national_te_6da0c320 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_advertising_on_national_televis_0ae76bf9" INTEGER -- Compliance With Ban On Advertising On National Television And Radio, Score
);
CREATE TABLE owid_compliance_with_ban_on_appearance_of_tobacco_bran_eda60728 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_appearance_of_tobacco_brands_in_27b8e05b" INTEGER -- Compliance With Ban On Appearance Of Tobacco Brands In Tv And Or Films, Score,
"compliance_with_ban_on_appearance_of_tobacco_brands_in_95c54998" VARCHAR -- Compliance With Ban On Appearance Of Tobacco Brands In Tv And Or Films, Score Low,
"compliance_with_ban_on_appearance_of_tobacco_brands_in_117ce86c" VARCHAR -- Compliance With Ban On Appearance Of Tobacco Brands In Tv And Or Films, Score High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_appearance_of_tobacco_bran_f4ec544b (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_appearance_of_tobacco_brands_in_27b8e05b" INTEGER -- Compliance With Ban On Appearance Of Tobacco Brands In Tv And Or Films, Score
);
CREATE TABLE owid_compliance_with_ban_on_appearance_of_tobacco_prod_8a40e7d5 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_appearance_of_tobacco_products__47c075a3" INTEGER -- Compliance With Ban On Appearance Of Tobacco Products In Tv And Or Films, Score,
"compliance_with_ban_on_appearance_of_tobacco_products__f59299f2" VARCHAR -- Compliance With Ban On Appearance Of Tobacco Products In Tv And Or Films, Score Low,
"compliance_with_ban_on_appearance_of_tobacco_products__ebbd2b23" VARCHAR -- Compliance With Ban On Appearance Of Tobacco Products In Tv And Or Films, Score High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_appearance_of_tobacco_prod_d6637b23 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_appearance_of_tobacco_products__47c075a3" INTEGER -- Compliance With Ban On Appearance Of Tobacco Products In Tv And Or Films, Score
);
CREATE TABLE owid_compliance_with_ban_on_billboard_and_outdoor_adve_2c4d0573 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_billboard_and_outdoor_advertising_score" INTEGER -- Compliance With Ban On Billboard And Outdoor Advertising, Score,
"compliance_with_ban_on_billboard_and_outdoor_advertisi_daef77ea" VARCHAR -- Compliance With Ban On Billboard And Outdoor Advertising, Score Low,
"compliance_with_ban_on_billboard_and_outdoor_advertisi_a5f9a796" VARCHAR -- Compliance With Ban On Billboard And Outdoor Advertising, Score High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_billboard_and_outdoor_adve_4b527abd (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_billboard_and_outdoor_advertising_score" INTEGER -- Compliance With Ban On Billboard And Outdoor Advertising, Score
);
CREATE TABLE owid_compliance_with_ban_on_free_distribution_in_mail__935836dd (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_free_distribution_in_mail_or_th_24a8eaeb" INTEGER -- Compliance With Ban On Free Distribution In Mail Or Through Other Means, Score
);
CREATE TABLE owid_compliance_with_ban_on_free_distribution_in_mail__ef250b72 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_free_distribution_in_mail_or_th_24a8eaeb" INTEGER -- Compliance With Ban On Free Distribution In Mail Or Through Other Means, Score,
"compliance_with_ban_on_free_distribution_in_mail_or_th_ae2c609d" VARCHAR -- Compliance With Ban On Free Distribution In Mail Or Through Other Means, Score Low,
"compliance_with_ban_on_free_distribution_in_mail_or_th_2f2756d6" VARCHAR -- Compliance With Ban On Free Distribution In Mail Or Through Other Means, Score High,
"comments" VARCHAR
);
CREATE TABLE owid_compliance_with_ban_on_indentifying_non_tobacco_p_646b6ee3 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_indentifying_non_tobacco_produc_0bcb2371" INTEGER -- Compliance With Ban On Indentifying Non Tobacco Products With Tobacco Brand Names, Score
);
CREATE TABLE owid_compliance_with_ban_on_indentifying_non_tobacco_p_f8bc5ab1 (
"year" INTEGER,
"country" VARCHAR,
"compliance_with_ban_on_indentifying_non_tobacco_produc_0bcb2371" INTEGER -- Compliance With Ban On Indentifying Non Tobacco Products With Tobacco Brand Names, Score,
"compliance_with_ban_on_indentifying_non_tobacco_produc_6a98bc5c" VARCHAR -- Compliance With Ban On Indentifying Non Tobacco Products With Tobacco Brand Names, Score Low,
"compliance_with_ban_on_indentifying_non_tobacco_produc_e2187e8c" VARCHAR -- Compliance With Ban On Indentifying Non Tobacco Products With Tobacco Brand Names, Score High,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.