Global Health Observatory - World Health Organization

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_la_462ddabd (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_law_req_348ed6e4" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Law Requires Or Establishes Fines For Violations
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_la_cb1b3e87 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_law_req_348ed6e4" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Law Requires Or Establishes Fines For Violations,
  "health_warnings_on_smokeless_tobacco_packaging_law_req_906e009a" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Law Requires Or Establishes Fines For Violations Low,
  "health_warnings_on_smokeless_tobacco_packaging_law_req_06bdbd2c" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Law Requires Or Establishes Fines For Violations High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_la_ff5407eb (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_law_app_b8f15289" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Law Applys To Products Whether Manufactured Domestically Imported And For Duty Free Sale,
  "health_warnings_on_smokeless_tobacco_packaging_law_app_7da55139" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Law Applys To Products Whether Manufactured Domestically Imported And For Duty Free Sale Low,
  "health_warnings_on_smokeless_tobacco_packaging_law_app_7edb7390" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Law Applys To Products Whether Manufactured Domestically Imported And For Duty Free Sale High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_133113bf (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_no_56684ae5" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Not Be Obscured In Any Way Including By Required Markings Such As Tax Stamps,
  "health_warnings_on_smokeless_tobacco_packaging_must_no_9dba0635" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Not Be Obscured In Any Way Including By Required Markings Such As Tax Stamps Low,
  "health_warnings_on_smokeless_tobacco_packaging_must_no_696b76d5" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Not Be Obscured In Any Way Including By Required Markings Such As Tax Stamps High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_1e445e2a (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_no_56684ae5" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Not Be Obscured In Any Way Including By Required Markings Such As Tax Stamps
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_20a26344 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_in_e29c2e0f" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Include A Photograph Or Graphic
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_24f7736f (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_rotated" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_91ddc741 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_6e259ecf" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Written In The Principal Language, S, Of The Country,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_2f454f40" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Written In The Principal Language, S, Of The Country Low,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_214ce611" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Written In The Principal Language, S, Of The Country High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_a7fa5591 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_in_e29c2e0f" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Include A Photograph Or Graphic,
  "health_warnings_on_smokeless_tobacco_packaging_must_in_6f93db51" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Include A Photograph Or Graphic Low,
  "health_warnings_on_smokeless_tobacco_packaging_must_in_d1e11784" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Include A Photograph Or Graphic High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_b583aedf (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_aed6c0c4" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Placed At The Top Of The Principal Display Areas Of The Package,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_011b0703" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Placed At The Top Of The Principal Display Areas Of The Package Low,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_e2ff6005" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Placed At The Top Of The Principal Display Areas Of The Package High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_c1ce2a22 (
  "year" INTEGER,
  "country" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_rotated" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_0a34124e" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Rotated Low,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_892a3491" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Rotated High,
  "comments" VARCHAR
);

CREATE TABLE owid_health_warnings_on_smokeless_tobacco_packaging_mu_c37ff008 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "health_warnings_on_smokeless_tobacco_packaging_must_be_6e259ecf" VARCHAR  -- Health Warnings On Smokeless Tobacco Packaging Must Be Written In The Principal Language, S, Of The Country
);

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

CREATE TABLE owid_healthy_life_expectancy_hale_at_age_60_years_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "healthy_life_expectancy_hale_at_age_60_years" FLOAT  -- Healthy Life Expectancy, Hale, At Age 60, Years
);

CREATE TABLE owid_healthy_life_expectancy_hale_at_age_60_years_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "healthy_life_expectancy_hale_at_age_60_years" FLOAT  -- Healthy Life Expectancy, Hale, At Age 60, Years,
  "healthy_life_expectancy_hale_at_age_60_years_low" FLOAT  -- Healthy Life Expectancy, Hale, At Age 60, Years Low,
  "healthy_life_expectancy_hale_at_age_60_years_high" FLOAT  -- Healthy Life Expectancy, Hale, At Age 60, Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_healthy_life_expectancy_hale_at_birth_years_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "healthy_life_expectancy_hale_at_birth_years" FLOAT  -- Healthy Life Expectancy, Hale, At Birth, Years
);

CREATE TABLE owid_healthy_life_expectancy_hale_at_birth_years_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "healthy_life_expectancy_hale_at_birth_years" FLOAT  -- Healthy Life Expectancy, Hale, At Birth, Years,
  "healthy_life_expectancy_hale_at_birth_years_low" FLOAT  -- Healthy Life Expectancy, Hale, At Birth, Years Low,
  "healthy_life_expectancy_hale_at_birth_years_high" FLOAT  -- Healthy Life Expectancy, Hale, At Birth, Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_heavy_episodic_drinking_youth_15_19_years_drinker_0d521adc (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "heavy_episodic_drinking_youth_15_19_years_drinkers_onl_3e30e982" FLOAT  -- Heavy Episodic Drinking, Youth 15, 19 Years, Drinkers Only, Past 30 Days, Pct,
  "heavy_episodic_drinking_youth_15_19_years_drinkers_onl_1a493446" VARCHAR  -- Heavy Episodic Drinking, Youth 15, 19 Years, Drinkers Only, Past 30 Days, Pct Low,
  "heavy_episodic_drinking_youth_15_19_years_drinkers_onl_373184d3" VARCHAR  -- Heavy Episodic Drinking, Youth 15, 19 Years, Drinkers Only, Past 30 Days, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_heavy_episodic_drinking_youth_15_19_years_drinker_fd078cff (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "heavy_episodic_drinking_youth_15_19_years_drinkers_onl_3e30e982" FLOAT  -- Heavy Episodic Drinking, Youth 15, 19 Years, Drinkers Only, Past 30 Days, Pct
);

CREATE TABLE owid_heavy_episodic_drinking_youth_15_19_years_past_30_58152787 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "heavy_episodic_drinking_youth_15_19_years_past_30_days_pct" FLOAT  -- Heavy Episodic Drinking, Youth 15, 19 Years, Past 30 Days, Pct
);

CREATE TABLE owid_heavy_episodic_drinking_youth_15_19_years_past_30_b43c50cc (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "heavy_episodic_drinking_youth_15_19_years_past_30_days_pct" FLOAT  -- Heavy Episodic Drinking, Youth 15, 19 Years, Past 30 Days, Pct,
  "heavy_episodic_drinking_youth_15_19_years_past_30_days_pct_low" FLOAT  -- Heavy Episodic Drinking, Youth 15, 19 Years, Past 30 Days, Pct Low,
  "heavy_episodic_drinking_youth_15_19_years_past_30_days_pct_high" FLOAT  -- Heavy Episodic Drinking, Youth 15, 19 Years, Past 30 Days, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_hepatitis_b_hepb3_immunization_coverage_among_1_y_c04ea681 (
  "year" INTEGER,
  "country" VARCHAR,
  "hepatitis_b_hepb3_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Hepatitis B, Hepb3, Immunization Coverage Among 1 Year Olds, Pct,
  "hepatitis_b_hepb3_immunization_coverage_among_1_year_o_8ef4e63d" VARCHAR  -- Hepatitis B, Hepb3, Immunization Coverage Among 1 Year Olds, Pct Low,
  "hepatitis_b_hepb3_immunization_coverage_among_1_year_o_4ac3b803" VARCHAR  -- Hepatitis B, Hepb3, Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_hepatitis_b_hepb3_immunization_coverage_among_1_y_e8dd73a4 (
  "year" INTEGER,
  "country" VARCHAR,
  "hepatitis_b_hepb3_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Hepatitis B, Hepb3, Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_hepatitis_b_surface_antigen_hbsag_carriers_per_10_a08ee14a (
  "year" INTEGER,
  "country" VARCHAR,
  "age_group" VARCHAR,
  "population_type" VARCHAR,
  "hepatitis_b_surface_antigen_hbsag_carriers_per_100_000_29d070b1" FLOAT  -- Hepatitis B Surface Antigen, Hbsag, Carriers, Per 100–000 Population,
  "hepatitis_b_surface_antigen_hbsag_carriers_per_100_000_1a89efdb" FLOAT  -- Hepatitis B Surface Antigen, Hbsag, Carriers, Per 100–000 Population Low,
  "hepatitis_b_surface_antigen_hbsag_carriers_per_100_000_f6d1cafb" FLOAT  -- Hepatitis B Surface Antigen, Hbsag, Carriers, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_hepatitis_b_surface_antigen_hbsag_prevalence_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "hepatitis_b_surface_antigen_hbsag_prevalence" FLOAT  -- Hepatitis B Surface Antigen, Hbsag, Prevalence,
  "comments" VARCHAR
);