Global Health Observatory - World Health Organization

CREATE TABLE owid_health_warning_labels_on_pregnancy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_pregnancy" VARCHAR,
  "health_warning_labels_on_pregnancy_low" VARCHAR,
  "health_warning_labels_on_pregnancy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_under_age_drinking_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_under_age_drinking" VARCHAR
);

CREATE TABLE owid_health_warning_labels_on_under_age_drinking_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warning_labels_on_under_age_drinking" VARCHAR,
  "health_warning_labels_on_under_age_drinking_low" VARCHAR,
  "health_warning_labels_on_under_age_drinking_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_appear_on_each_cigarette_package__c46e5eef (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_appear_on_each_cigarette_package_and_a_3153b9a2" VARCHAR  -- Health Warnings Appear On Each Cigarette Package And Any Outside Packaging And Labelling Used In The Retail Sale
);

CREATE TABLE owid_health_warnings_appear_on_each_cigarette_package__de253e0d (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_appear_on_each_cigarette_package_and_a_3153b9a2" VARCHAR  -- Health Warnings Appear On Each Cigarette Package And Any Outside Packaging And Labelling Used In The Retail Sale,
  "health_warnings_appear_on_each_cigarette_package_and_a_206f9b39" VARCHAR  -- Health Warnings Appear On Each Cigarette Package And Any Outside Packaging And Labelling Used In The Retail Sale Low,
  "health_warnings_appear_on_each_cigarette_package_and_a_9901ddc3" VARCHAR  -- Health Warnings Appear On Each Cigarette Package And Any Outside Packaging And Labelling Used In The Retail Sale High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_appear_on_each_other_smoked_tobac_22c86998 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_appear_on_each_other_smoked_tobacco_pa_ddcf1e6d" VARCHAR  -- Health Warnings Appear On Each Other Smoked Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale
);

CREATE TABLE owid_health_warnings_appear_on_each_other_smoked_tobac_5ec58c95 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_appear_on_each_other_smoked_tobacco_pa_ddcf1e6d" VARCHAR  -- Health Warnings Appear On Each Other Smoked Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale,
  "health_warnings_appear_on_each_other_smoked_tobacco_pa_a8801643" VARCHAR  -- Health Warnings Appear On Each Other Smoked Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale Low,
  "health_warnings_appear_on_each_other_smoked_tobacco_pa_4a26c8f4" VARCHAR  -- Health Warnings Appear On Each Other Smoked Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_appear_on_each_smokeless_tobacco__0197f9fd (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_appear_on_each_smokeless_tobacco_packa_f956d4e5" VARCHAR  -- Health Warnings Appear On Each Smokeless Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale,
  "health_warnings_appear_on_each_smokeless_tobacco_packa_c74831a3" VARCHAR  -- Health Warnings Appear On Each Smokeless Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale Low,
  "health_warnings_appear_on_each_smokeless_tobacco_packa_68c40000" VARCHAR  -- Health Warnings Appear On Each Smokeless Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_appear_on_each_smokeless_tobacco__15b73c48 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_appear_on_each_smokeless_tobacco_packa_f956d4e5" VARCHAR  -- Health Warnings Appear On Each Smokeless Tobacco Package And Any Outside Packaging And Labelling Used In The Retail Sale
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_describe_t_6d44d4c9 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_describe_the_ha_0ddc8627" VARCHAR  -- Health Warnings On Cigarette Packaging Describe The Harmful Effects Of Tobacco Use On Health
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_describe_t_d5c9faff (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_describe_the_ha_0ddc8627" VARCHAR  -- Health Warnings On Cigarette Packaging Describe The Harmful Effects Of Tobacco Use On Health,
  "health_warnings_on_cigarette_packaging_describe_the_ha_9e7f2de1" VARCHAR  -- Health Warnings On Cigarette Packaging Describe The Harmful Effects Of Tobacco Use On Health Low,
  "health_warnings_on_cigarette_packaging_describe_the_ha_3d62e57f" VARCHAR  -- Health Warnings On Cigarette Packaging Describe The Harmful Effects Of Tobacco Use On Health High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_do_not_rem_b399dbf3 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_do_not_remove_o_2bfeed72" VARCHAR  -- Health Warnings On Cigarette Packaging Do Not Remove Or Diminish The Liability Of The Tobacco Industry,
  "health_warnings_on_cigarette_packaging_do_not_remove_o_cec3604c" VARCHAR  -- Health Warnings On Cigarette Packaging Do Not Remove Or Diminish The Liability Of The Tobacco Industry Low,
  "health_warnings_on_cigarette_packaging_do_not_remove_o_6ad0cf48" VARCHAR  -- Health Warnings On Cigarette Packaging Do Not Remove Or Diminish The Liability Of The Tobacco Industry High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_do_not_rem_da35acde (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_do_not_remove_o_2bfeed72" VARCHAR  -- Health Warnings On Cigarette Packaging Do Not Remove Or Diminish The Liability Of The Tobacco Industry
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_law_applys_b41a8e00 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_law_applys_to_p_b4de1e94" VARCHAR  -- Health Warnings On Cigarette Packaging Law Applys To Products Whether Manufactured Domestically Imported And For Duty Free Sale
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_law_applys_b9e7fbd5 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_law_applys_to_p_b4de1e94" VARCHAR  -- Health Warnings On Cigarette Packaging Law Applys To Products Whether Manufactured Domestically Imported And For Duty Free Sale,
  "health_warnings_on_cigarette_packaging_law_applys_to_p_9da3d374" VARCHAR  -- Health Warnings On Cigarette Packaging Law Applys To Products Whether Manufactured Domestically Imported And For Duty Free Sale Low,
  "health_warnings_on_cigarette_packaging_law_applys_to_p_c313924f" VARCHAR  -- Health Warnings On Cigarette Packaging Law Applys To Products Whether Manufactured Domestically Imported And For Duty Free Sale High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_law_requir_1af00a57 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_law_requires_or_e7e29803" VARCHAR  -- Health Warnings On Cigarette Packaging Law Requires Or Establishes Fines For Violations,
  "health_warnings_on_cigarette_packaging_law_requires_or_afba56b8" VARCHAR  -- Health Warnings On Cigarette Packaging Law Requires Or Establishes Fines For Violations Low,
  "health_warnings_on_cigarette_packaging_law_requires_or_1dedfce6" VARCHAR  -- Health Warnings On Cigarette Packaging Law Requires Or Establishes Fines For Violations High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_law_requir_532b4e49 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_law_requires_or_e7e29803" VARCHAR  -- Health Warnings On Cigarette Packaging Law Requires Or Establishes Fines For Violations
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_be_pl_714a139f (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_placed__770f7e05" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Placed At The Top Of The Principal Display Areas Of The Package,
  "health_warnings_on_cigarette_packaging_must_be_placed__cb022dc0" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Placed At The Top Of The Principal Display Areas Of The Package Low,
  "health_warnings_on_cigarette_packaging_must_be_placed__f3ec8b78" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Placed At The Top Of The Principal Display Areas Of The Package High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_be_pl_df5765ab (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_placed__770f7e05" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Placed At The Top Of The Principal Display Areas Of The Package
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_be_rotated_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_rotated" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_be_rotated_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_rotated" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_rotated_low" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_rotated_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_be_wr_207182f3 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_written_c1a6e0d7" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Written In The Principal Language, S, Of The Country
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_be_wr_93dc6036 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_be_written_c1a6e0d7" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Written In The Principal Language, S, Of The Country,
  "health_warnings_on_cigarette_packaging_must_be_written_0a2f2d00" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Written In The Principal Language, S, Of The Country Low,
  "health_warnings_on_cigarette_packaging_must_be_written_51c35185" VARCHAR  -- Health Warnings On Cigarette Packaging Must Be Written In The Principal Language, S, Of The Country High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_inclu_196deb6c (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_include_a__5abfe6af" VARCHAR  -- Health Warnings On Cigarette Packaging Must Include A Photograph Or Graphic
);

CREATE TABLE owid_health_warnings_on_cigarette_packaging_must_inclu_51e056c5 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_cigarette_packaging_must_include_a__5abfe6af" VARCHAR  -- Health Warnings On Cigarette Packaging Must Include A Photograph Or Graphic,
  "health_warnings_on_cigarette_packaging_must_include_a__5c0da706" VARCHAR  -- Health Warnings On Cigarette Packaging Must Include A Photograph Or Graphic Low,
  "health_warnings_on_cigarette_packaging_must_include_a__4b22e4be" VARCHAR  -- Health Warnings On Cigarette Packaging Must Include A Photograph Or Graphic High,
  "comments" VARCHAR
);