Global Health Observatory - World Health Organization

CREATE TABLE owid_sector_for_the_treatment_of_alcohol_induced_psych_07c1a645 (
  "year" INTEGER,
  "country" VARCHAR,
  "sector_for_the_treatment_of_alcohol_induced_psychoses__a2042e5f" VARCHAR  -- Sector For The Treatment Of Alcohol Induced Psychoses And Other Alcohol Induced Psychiatric Conditions,
  "sector_for_the_treatment_of_alcohol_induced_psychoses__9a59790c" VARCHAR  -- Sector For The Treatment Of Alcohol Induced Psychoses And Other Alcohol Induced Psychiatric Conditions Low,
  "sector_for_the_treatment_of_alcohol_induced_psychoses__c83f976f" VARCHAR  -- Sector For The Treatment Of Alcohol Induced Psychoses And Other Alcohol Induced Psychiatric Conditions High,
  "comments" VARCHAR
);

CREATE TABLE owid_sector_for_the_treatment_of_alcohol_induced_psych_125056c2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sector_for_the_treatment_of_alcohol_induced_psychoses__a2042e5f" VARCHAR  -- Sector For The Treatment Of Alcohol Induced Psychoses And Other Alcohol Induced Psychiatric Conditions
);

CREATE TABLE owid_sectors_represented_in_national_alcohol_policy_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_policy_sectors" VARCHAR,
  "sectors_represented_in_national_alcohol_policy" VARCHAR
);

CREATE TABLE owid_sectors_represented_in_national_alcohol_policy_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "substance_abuse_policy_sectors" VARCHAR,
  "sectors_represented_in_national_alcohol_policy" VARCHAR,
  "sectors_represented_in_national_alcohol_policy_low" VARCHAR,
  "sectors_represented_in_national_alcohol_policy_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_see_cci_1 (
  "year" INTEGER,
  "country" 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,
  "see_cci" FLOAT,
  "comments" VARCHAR
);

CREATE TABLE owid_see_cci_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "wealth_quintile" VARCHAR,
  "education_level" VARCHAR,
  "see_cci" FLOAT,
  "see_cci_low" VARCHAR,
  "see_cci_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_self_help_groups_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_groups" VARCHAR,
  "self_help_groups" VARCHAR
);

CREATE TABLE owid_self_help_groups_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_groups" VARCHAR,
  "self_help_groups" VARCHAR,
  "self_help_groups_low" VARCHAR,
  "self_help_groups_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_self_help_groups_for_substance_use_disorders_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_groups" VARCHAR,
  "self_help_groups_for_substance_use_disorders" VARCHAR
);

CREATE TABLE owid_self_help_groups_for_substance_use_disorders_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_groups" VARCHAR,
  "self_help_groups_for_substance_use_disorders" VARCHAR,
  "self_help_groups_for_substance_use_disorders_low" VARCHAR,
  "self_help_groups_for_substance_use_disorders_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_server_training_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "server_training" VARCHAR
);

CREATE TABLE owid_server_training_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "server_training" VARCHAR,
  "server_training_low" VARCHAR,
  "server_training_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_server_training_on_a_regular_basis_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "server_training_on_a_regular_basis" VARCHAR
);

CREATE TABLE owid_server_training_on_a_regular_basis_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "server_training_on_a_regular_basis" VARCHAR,
  "server_training_on_a_regular_basis_low" VARCHAR,
  "server_training_on_a_regular_basis_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_service_delivery_data_collection_for_substance_use_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "service_delivery_data_collection_for_substance_use" VARCHAR
);

CREATE TABLE owid_service_delivery_data_collection_for_substance_use_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "service_delivery_data_collection_for_substance_use" VARCHAR,
  "service_delivery_data_collection_for_substance_use_low" VARCHAR,
  "service_delivery_data_collection_for_substance_use_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_service_delivery_data_collection_system_for_subst_51eb849f (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "service_delivery_data_collection_system_for_substance__a00bf96d" VARCHAR  -- Service Delivery Data Collection System For Substance Use Disorders
);

CREATE TABLE owid_service_delivery_data_collection_system_for_subst_f22c7c44 (
  "year" INTEGER,
  "country" VARCHAR,
  "rsud_substance_types" VARCHAR,
  "service_delivery_data_collection_system_for_substance__a00bf96d" VARCHAR  -- Service Delivery Data Collection System For Substance Use Disorders,
  "service_delivery_data_collection_system_for_substance__c7429d30" VARCHAR  -- Service Delivery Data Collection System For Substance Use Disorders Low,
  "service_delivery_data_collection_system_for_substance__45eb457c" VARCHAR  -- Service Delivery Data Collection System For Substance Use Disorders High,
  "comments" VARCHAR
);

CREATE TABLE owid_severe_wasted_numbers_among_children_under_5_year_bb39d5a6 (
  "year" INTEGER,
  "country" VARCHAR,
  "severe_wasted_numbers_among_children_under_5_years_of__d15bf18e" FLOAT  -- Severe Wasted Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_severe_wasted_numbers_among_children_under_5_year_e55697a5 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severe_wasted_numbers_among_children_under_5_years_of__d15bf18e" FLOAT  -- Severe Wasted Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates,
  "severe_wasted_numbers_among_children_under_5_years_of__c6458183" FLOAT  -- Severe Wasted Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates Low,
  "severe_wasted_numbers_among_children_under_5_years_of__9ff16189" FLOAT  -- Severe Wasted Numbers Among Children Under 5 Years Of Age, Millions, Model Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_severe_wasting_prevalence_among_children_under_5__5250ddb4 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_wealth" VARCHAR,
  "wealth_tercile" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "severe_wasting_prevalence_among_children_under_5_years_8dd21cf4" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Lt, 3 Sd, Survey Based Estimates,
  "severe_wasting_prevalence_among_children_under_5_years_19a76329" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Lt, 3 Sd, Survey Based Estimates Low,
  "severe_wasting_prevalence_among_children_under_5_years_5c1ef50a" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Lt, 3 Sd, Survey Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_severe_wasting_prevalence_among_children_under_5__69c5a8f2 (
  "year" INTEGER,
  "country" VARCHAR,
  "severe_wasting_prevalence_among_children_under_5_years_5146ab09" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_severe_wasting_prevalence_among_children_under_5__8fb02f9e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "severe_wasting_prevalence_among_children_under_5_years_5146ab09" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates,
  "severe_wasting_prevalence_among_children_under_5_years_9b7832a6" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates Low,
  "severe_wasting_prevalence_among_children_under_5_years_4ce3ca84" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct, Model Based Estimates High,
  "comments" VARCHAR
);

CREATE TABLE owid_severe_wasting_prevalence_among_children_under_5__e8d445d2 (
  "year" INTEGER,
  "country" VARCHAR,
  "severe_wasting_prevalence_among_children_under_5_years_8dd21cf4" FLOAT  -- Severe Wasting Prevalence Among Children Under 5 Years Of Age, Pct Weight For Height, Lt, 3 Sd, Survey Based Estimates,
  "comments" VARCHAR
);

CREATE TABLE owid_severe_wasting_prevalence_in_children_aged_lt_5_y_0163257a (
  "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,
  "severe_wasting_prevalence_in_children_aged_lt_5_years_pct" FLOAT  -- Severe Wasting Prevalence In Children Aged, Lt, 5 Years, Pct,
  "comments" VARCHAR
);