Global Health Observatory - World Health Organization

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__61e0575f (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_ef952f32" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Other Smoked Tobacco Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_66a9bfe3" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Other Smoked Tobacco Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_a86dbe11" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Other Smoked Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__6a49741b (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_958537ac" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Cigarette Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__6d52564f (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_be49c1c0" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Other Smoked Tobacco Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_2cf4bcbc" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Other Smoked Tobacco Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_2553e9f7" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Other Smoked Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__6da708d9 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_958537ac" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Cigarette Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_72dbad63" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Cigarette Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_4e4ea493" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front Of Cigarette Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__8ea58b55 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_f9854f75" FLOAT  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Cigarette Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_b02a1496" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Cigarette Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_92792bb6" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Cigarette Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__95d0ca03 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_4fd4f05a" FLOAT  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Other Smoked Tobacco Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__cf351eda (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_74e81811" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Cigarette Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__cffc698a (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_517f3343" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Smokeless Tobacco Packaging,
  "percentage_of_principal_display_area_mandated_to_be_co_249faab8" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Smokeless Tobacco Packaging Low,
  "percentage_of_principal_display_area_mandated_to_be_co_27aef2d9" VARCHAR  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Smokeless Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__d8b0dd30 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_f9854f75" FLOAT  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Front And Back Of Cigarette Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_principal_display_area_mandated_to__f06c8ab1 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_principal_display_area_mandated_to_be_co_517f3343" INTEGER  -- Percentage Of Principal Display Area Mandated To Be Covered By Health Warnings, Back Of Smokeless Tobacco Packaging,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_sites_for_which_carbamate_resistanc_2f7190c6 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_carbamate_resistance_was_reported" FLOAT,
  "percentage_of_sites_for_which_carbamate_resistance_was_12d2e8e1" VARCHAR  -- Percentage Of Sites For Which Carbamate Resistance Was Reported Low,
  "percentage_of_sites_for_which_carbamate_resistance_was_51921ff2" VARCHAR  -- Percentage Of Sites For Which Carbamate Resistance Was Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_sites_for_which_carbamate_resistanc_3197af9f (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_carbamate_resistance_was_reported" FLOAT
);

CREATE TABLE owid_percentage_of_sites_for_which_organochlorine_resi_296ba885 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_organochlorine_resistanc_fb7f7e1e" FLOAT  -- Percentage Of Sites For Which Organochlorine Resistance Was Reported
);

CREATE TABLE owid_percentage_of_sites_for_which_organochlorine_resi_690a2c57 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_organochlorine_resistanc_fb7f7e1e" FLOAT  -- Percentage Of Sites For Which Organochlorine Resistance Was Reported,
  "percentage_of_sites_for_which_organochlorine_resistanc_1464925f" VARCHAR  -- Percentage Of Sites For Which Organochlorine Resistance Was Reported Low,
  "percentage_of_sites_for_which_organochlorine_resistanc_42ab00e4" VARCHAR  -- Percentage Of Sites For Which Organochlorine Resistance Was Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_sites_for_which_organophosphate_res_ae4e7b46 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_organophosphate_resistan_e12583d2" FLOAT  -- Percentage Of Sites For Which Organophosphate Resistance Was Reported
);

CREATE TABLE owid_percentage_of_sites_for_which_organophosphate_res_feb20d80 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_organophosphate_resistan_e12583d2" FLOAT  -- Percentage Of Sites For Which Organophosphate Resistance Was Reported,
  "percentage_of_sites_for_which_organophosphate_resistan_0744f178" VARCHAR  -- Percentage Of Sites For Which Organophosphate Resistance Was Reported Low,
  "percentage_of_sites_for_which_organophosphate_resistan_4f011efa" VARCHAR  -- Percentage Of Sites For Which Organophosphate Resistance Was Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_sites_for_which_pyrethroid_resistan_3da6ad7d (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_pyrethroid_resistance_wa_d703cf2e" FLOAT  -- Percentage Of Sites For Which Pyrethroid Resistance Was Reported
);

CREATE TABLE owid_percentage_of_sites_for_which_pyrethroid_resistan_bb25f2fa (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sites_for_which_pyrethroid_resistance_wa_d703cf2e" FLOAT  -- Percentage Of Sites For Which Pyrethroid Resistance Was Reported,
  "percentage_of_sites_for_which_pyrethroid_resistance_wa_5047604f" VARCHAR  -- Percentage Of Sites For Which Pyrethroid Resistance Was Reported Low,
  "percentage_of_sites_for_which_pyrethroid_resistance_wa_251fd482" VARCHAR  -- Percentage Of Sites For Which Pyrethroid Resistance Was Reported High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_sub_national_regions_covered_by_dem_0d8c8840 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sub_national_regions_covered_by_dementia_plan" FLOAT,
  "percentage_of_sub_national_regions_covered_by_dementia_plan_low" VARCHAR,
  "percentage_of_sub_national_regions_covered_by_dementia_bb00b452" VARCHAR  -- Percentage Of Sub National Regions Covered By Dementia Plan High,
  "comments" VARCHAR
);

CREATE TABLE owid_percentage_of_sub_national_regions_covered_by_dem_876d2d21 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_sub_national_regions_covered_by_dementia_plan" FLOAT
);

CREATE TABLE owid_percentage_of_the_adults_15plus_years_with_blood__16c0da7c (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_the_adults_15plus_years_with_blood_lead__d64cee57" FLOAT  -- Percentage Of The Adults, 15plus Years, With Blood Lead Levels Above 10ug Dl
);

CREATE TABLE owid_percentage_of_the_adults_15plus_years_with_blood__d4d73562 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_the_adults_15plus_years_with_blood_lead__b65f3747" FLOAT  -- Percentage Of The Adults, 15plus Years, With Blood Lead Levels Above 5ug Dl
);

CREATE TABLE owid_percentage_of_the_children_under_15_years_with_bl_121b1d16 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_the_children_under_15_years_with_blood_l_f8800929" FLOAT  -- Percentage Of The Children Under 15 Years With Blood Lead Levels Above 10ug Dl
);

CREATE TABLE owid_percentage_of_the_children_under_15_years_with_bl_55995459 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_the_children_under_15_years_with_blood_l_48461002" FLOAT  -- Percentage Of The Children Under 15 Years With Blood Lead Levels Above 5ug Dl
);

CREATE TABLE owid_percentage_of_women_15plus_years_exposed_to_secon_de24d795 (
  "year" INTEGER,
  "country" VARCHAR,
  "percentage_of_women_15plus_years_exposed_to_second_hand_smoke" FLOAT  -- Percentage Of Women, 15plus Years, Exposed To Second Hand Smoke
);