Global Health Observatory - World Health Organization

CREATE TABLE owid_five_year_change_in_government_resources_for_prev_547c6014 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_year_change_in_government_resources_for_preventio_a834a530" VARCHAR  -- Five Year Change In Government Resources For Prevention For Substance Use,
  "five_year_change_in_government_resources_for_preventio_91fd52b0" VARCHAR  -- Five Year Change In Government Resources For Prevention For Substance Use Low,
  "five_year_change_in_government_resources_for_preventio_dba5791d" VARCHAR  -- Five Year Change In Government Resources For Prevention For Substance Use High,
  "comments" VARCHAR
);

CREATE TABLE owid_five_year_change_in_government_resources_for_prev_9264334d (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_year_change_in_government_resources_for_preventio_a834a530" VARCHAR  -- Five Year Change In Government Resources For Prevention For Substance Use
);

CREATE TABLE owid_five_year_change_in_government_resources_for_trea_5e46b674 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_year_change_in_government_resources_for_treatment_42a822b2" VARCHAR  -- Five Year Change In Government Resources For Treatment Of Substance Use Disorders
);

CREATE TABLE owid_five_year_change_in_government_resources_for_trea_cb4a2bd8 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_year_change_in_government_resources_for_treatment_42a822b2" VARCHAR  -- Five Year Change In Government Resources For Treatment Of Substance Use Disorders,
  "five_year_change_in_government_resources_for_treatment_cb85230c" VARCHAR  -- Five Year Change In Government Resources For Treatment Of Substance Use Disorders Low,
  "five_year_change_in_government_resources_for_treatment_817b597a" VARCHAR  -- Five Year Change In Government Resources For Treatment Of Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_five_years_change_in_international_cooperation_fo_613991cf (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_years_change_in_international_cooperation_for_tre_fca38825" VARCHAR  -- Five Years Change In International Cooperation For Treatment Of Substance Use Disorders,
  "five_years_change_in_international_cooperation_for_tre_bc2411fa" VARCHAR  -- Five Years Change In International Cooperation For Treatment Of Substance Use Disorders Low,
  "five_years_change_in_international_cooperation_for_tre_217d5845" VARCHAR  -- Five Years Change In International Cooperation For Treatment Of Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_five_years_change_in_international_cooperation_fo_7f8c48cc (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_years_change_in_international_cooperation_for_pre_e79280eb" VARCHAR  -- Five Years Change In International Cooperation For Prevention For Substance Use,
  "five_years_change_in_international_cooperation_for_pre_47d72a2d" VARCHAR  -- Five Years Change In International Cooperation For Prevention For Substance Use Low,
  "five_years_change_in_international_cooperation_for_pre_92192390" VARCHAR  -- Five Years Change In International Cooperation For Prevention For Substance Use High,
  "comments" VARCHAR
);

CREATE TABLE owid_five_years_change_in_international_cooperation_fo_9101b692 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_years_change_in_international_cooperation_for_pre_e79280eb" VARCHAR  -- Five Years Change In International Cooperation For Prevention For Substance Use
);

CREATE TABLE owid_five_years_change_in_international_cooperation_fo_d38acf88 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "five_years_change_in_international_cooperation_for_tre_fca38825" VARCHAR  -- Five Years Change In International Cooperation For Treatment Of Substance Use Disorders
);

CREATE TABLE owid_font_style_font_size_and_colour_of_health_warning_23f7b8c2 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "font_style_font_size_and_colour_of_health_warnings_are_40385b2f" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Smokeless Tobacco Packaging
);

CREATE TABLE owid_font_style_font_size_and_colour_of_health_warning_2734efb1 (
  "year" INTEGER,
  "country" VARCHAR,
  "font_style_font_size_and_colour_of_health_warnings_are_40385b2f" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Smokeless Tobacco Packaging,
  "font_style_font_size_and_colour_of_health_warnings_are_419dfcea" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Smokeless Tobacco Packaging Low,
  "font_style_font_size_and_colour_of_health_warnings_are_1d669cd8" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Smokeless Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_font_style_font_size_and_colour_of_health_warning_327cccf4 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "font_style_font_size_and_colour_of_health_warnings_are_76677917" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Other Smoked Tobacco Packaging
);

CREATE TABLE owid_font_style_font_size_and_colour_of_health_warning_97334315 (
  "year" INTEGER,
  "country" VARCHAR,
  "font_style_font_size_and_colour_of_health_warnings_are_1b9938d7" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Cigarette Packaging,
  "font_style_font_size_and_colour_of_health_warnings_are_a0b53525" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Cigarette Packaging Low,
  "font_style_font_size_and_colour_of_health_warnings_are_b2c683ef" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Cigarette Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_font_style_font_size_and_colour_of_health_warning_a531d16f (
  "year" INTEGER,
  "country" VARCHAR,
  "font_style_font_size_and_colour_of_health_warnings_are_76677917" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Other Smoked Tobacco Packaging,
  "font_style_font_size_and_colour_of_health_warnings_are_bf28ee39" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Other Smoked Tobacco Packaging Low,
  "font_style_font_size_and_colour_of_health_warnings_are_a1822aa0" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Other Smoked Tobacco Packaging High,
  "comments" VARCHAR
);

CREATE TABLE owid_font_style_font_size_and_colour_of_health_warning_b8b7f985 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "font_style_font_size_and_colour_of_health_warnings_are_1b9938d7" VARCHAR  -- Font Style, Font Size And Colour Of Health Warnings Are Mandated For Cigarette Packaging
);

CREATE TABLE owid_food_safety (
  "year" INTEGER,
  "country" VARCHAR,
  "food_safety" INTEGER
);

CREATE TABLE owid_food_safety_spar (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "food_safety_spar" INTEGER  -- Food Safety, Spar
);

CREATE TABLE owid_formative_research_was_conducted_prior_to_the_campaign_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "formative_research_was_conducted_prior_to_the_campaign" VARCHAR
);

CREATE TABLE owid_formative_research_was_conducted_prior_to_the_campaign_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "formative_research_was_conducted_prior_to_the_campaign" VARCHAR,
  "formative_research_was_conducted_prior_to_the_campaign_low" VARCHAR,
  "formative_research_was_conducted_prior_to_the_campaign_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_framework_of_national_alcohol_policy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_policy_frameworks" VARCHAR,
  "framework_of_national_alcohol_policy" VARCHAR
);

CREATE TABLE owid_framework_of_national_alcohol_policy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_policy_frameworks" VARCHAR,
  "framework_of_national_alcohol_policy" VARCHAR,
  "framework_of_national_alcohol_policy_low" VARCHAR,
  "framework_of_national_alcohol_policy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_full_immunization_coverage_among_one_year_olds_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_decile" VARCHAR,
  "full_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Full Immunization Coverage Among One Year Olds, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_full_immunization_coverage_among_one_year_olds_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "full_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Full Immunization Coverage Among One Year Olds, Pct,
  "full_immunization_coverage_among_one_year_olds_pct_low" FLOAT  -- Full Immunization Coverage Among One Year Olds, Pct Low,
  "full_immunization_coverage_among_one_year_olds_pct_high" FLOAT  -- Full Immunization Coverage Among One Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_functioning_national_amr_surveillance_plan_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "functioning_national_amr_surveillance_plan" INTEGER
);

CREATE TABLE owid_functioning_national_amr_surveillance_plan_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "functioning_national_amr_surveillance_plan" INTEGER,
  "functioning_national_amr_surveillance_plan_low" VARCHAR,
  "functioning_national_amr_surveillance_plan_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_funding_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "goe_question" VARCHAR,
  "funding" VARCHAR
);