Global Health Observatory - World Health Organization

CREATE TABLE owid_chemical (
  "year" INTEGER,
  "country" VARCHAR,
  "chemical" INTEGER
);

CREATE TABLE owid_chemical_events (
  "year" INTEGER,
  "country" VARCHAR,
  "ihr_spar_capacity_level" VARCHAR,
  "chemical_events" INTEGER
);

CREATE TABLE owid_child_maltreatment_extent_of_implementation_of_ho_106c2e84 (
  "year" INTEGER,
  "country" VARCHAR,
  "child_maltreatment_extent_of_implementation_of_home_vi_10423387" VARCHAR  -- Child Maltreatment, Extent Of Implementation Of Home Visiting Programmes,
  "child_maltreatment_extent_of_implementation_of_home_vi_3eb4bb85" VARCHAR  -- Child Maltreatment, Extent Of Implementation Of Home Visiting Programmes Low,
  "child_maltreatment_extent_of_implementation_of_home_vi_b970a390" VARCHAR  -- Child Maltreatment, Extent Of Implementation Of Home Visiting Programmes High,
  "comments" VARCHAR
);

CREATE TABLE owid_child_maltreatment_extent_of_implementation_of_ho_ff7c35af (
  "year" INTEGER,
  "country" VARCHAR,
  "child_maltreatment_extent_of_implementation_of_home_vi_10423387" VARCHAR  -- Child Maltreatment, Extent Of Implementation Of Home Visiting Programmes
);

CREATE TABLE owid_children_aged_36_59_months_who_are_developmentall_0d7a14ed (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "children_aged_36_59_months_who_are_developmentally_on__d5fae9e4" FLOAT  -- Children Aged 36–59 Months Who Are Developmentally On Track In At Least Three Of The Following Domains, Literacy Numeracy, Physical Development, Social Emotional Development And Learning, Pct,
  "children_aged_36_59_months_who_are_developmentally_on__c720e683" VARCHAR  -- Children Aged 36–59 Months Who Are Developmentally On Track In At Least Three Of The Following Domains, Literacy Numeracy, Physical Development, Social Emotional Development And Learning, Pct Low,
  "children_aged_36_59_months_who_are_developmentally_on__a268a9b2" VARCHAR  -- Children Aged 36–59 Months Who Are Developmentally On Track In At Least Three Of The Following Domains, Literacy Numeracy, Physical Development, Social Emotional Development And Learning, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_36_59_months_who_are_developmentall_fb956e40 (
  "year" INTEGER,
  "country" VARCHAR,
  "children_aged_36_59_months_who_are_developmentally_on__d5fae9e4" FLOAT  -- Children Aged 36–59 Months Who Are Developmentally On Track In At Least Three Of The Following Domains, Literacy Numeracy, Physical Development, Social Emotional Development And Learning, Pct
);

CREATE TABLE owid_children_aged_6_59_months_who_received_vitamin_a__2b239177 (
  "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,
  "children_aged_6_59_months_who_received_vitamin_a_suppl_0cfc09d1" FLOAT  -- Children Aged 6–59 Months Who Received Vitamin A Supplementation, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_6_59_months_who_received_vitamin_a__86390f11 (
  "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,
  "children_aged_6_59_months_who_received_vitamin_a_suppl_0cfc09d1" FLOAT  -- Children Aged 6–59 Months Who Received Vitamin A Supplementation, Pct,
  "children_aged_6_59_months_who_received_vitamin_a_suppl_32a7584b" FLOAT  -- Children Aged 6–59 Months Who Received Vitamin A Supplementation, Pct Low,
  "children_aged_6_59_months_who_received_vitamin_a_suppl_915e1f4d" FLOAT  -- Children Aged 6–59 Months Who Received Vitamin A Supplementation, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_sleeping_under_insectici_a7a88a76 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "children_aged_lt_5_years_sleeping_under_insecticide_tr_ba5b612e" FLOAT  -- Children Aged, Lt, 5 Years Sleeping Under Insecticide Treated Nets, Pct,
  "children_aged_lt_5_years_sleeping_under_insecticide_tr_fb883f88" FLOAT  -- Children Aged, Lt, 5 Years Sleeping Under Insecticide Treated Nets, Pct Low,
  "children_aged_lt_5_years_sleeping_under_insecticide_tr_6fcb8fc9" FLOAT  -- Children Aged, Lt, 5 Years Sleeping Under Insecticide Treated Nets, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_sleeping_under_insectici_cba126a4 (
  "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,
  "children_aged_lt_5_years_sleeping_under_insecticide_tr_ba5b612e" FLOAT  -- Children Aged, Lt, 5 Years Sleeping Under Insecticide Treated Nets, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_wasted_for_age_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "children_aged_lt_5_years_wasted_for_age_pct" FLOAT  -- Children Aged, Lt 5 Years Wasted For Age, Pct
);

CREATE TABLE owid_children_aged_lt_5_years_wasted_for_age_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "children_aged_lt_5_years_wasted_for_age_pct" FLOAT  -- Children Aged, Lt 5 Years Wasted For Age, Pct,
  "children_aged_lt_5_years_wasted_for_age_pct_low" VARCHAR  -- Children Aged, Lt 5 Years Wasted For Age, Pct Low,
  "children_aged_lt_5_years_wasted_for_age_pct_high" VARCHAR  -- Children Aged, Lt 5 Years Wasted For Age, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_diarrhoea_receiving_7c03b5d2 (
  "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,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_b38c9b9b" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Therapy And Continued Feeding, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_diarrhoea_receiving_7dfefd62 (
  "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,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_b0acb9ad" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Salts, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_diarrhoea_receiving_c2f10ae4 (
  "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,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_b0acb9ad" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Salts, Pct,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_0744ea98" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Salts, Pct Low,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_f8c0550a" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Salts, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_diarrhoea_receiving_c985d5f1 (
  "year" INTEGER,
  "country" VARCHAR,
  "children_aged_lt_5_years_with_diarrhoea_receiving_ors_pct" FLOAT  -- Children Aged, Lt 5 Years With Diarrhoea Receiving Ors, Pct,
  "children_aged_lt_5_years_with_diarrhoea_receiving_ors_pct_low" VARCHAR  -- Children Aged, Lt 5 Years With Diarrhoea Receiving Ors, Pct Low,
  "children_aged_lt_5_years_with_diarrhoea_receiving_ors_pct_high" VARCHAR  -- Children Aged, Lt 5 Years With Diarrhoea Receiving Ors, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_diarrhoea_receiving_cf5e051a (
  "year" INTEGER,
  "country" VARCHAR,
  "children_aged_lt_5_years_with_diarrhoea_receiving_ors_pct" FLOAT  -- Children Aged, Lt 5 Years With Diarrhoea Receiving Ors, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_diarrhoea_receiving_d60c614a (
  "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,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_b38c9b9b" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Therapy And Continued Feeding, Pct,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_947c2c95" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Therapy And Continued Feeding, Pct Low,
  "children_aged_lt_5_years_with_diarrhoea_receiving_oral_a63c3112" FLOAT  -- Children Aged, Lt, 5 Years With Diarrhoea Receiving Oral Rehydration Therapy And Continued Feeding, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_pneumonia_symptoms__23daf730 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "wealth_decile" VARCHAR,
  "wealth_quintile" VARCHAR,
  "residence_area_type" VARCHAR,
  "dhs_mics_subnational_regions_health_equity_monitor" VARCHAR  -- Dhs Mics Subnational Regions, Health Equity Monitor,
  "education_level" VARCHAR,
  "children_aged_lt_5_years_with_pneumonia_symptoms_taken_902a4dc8" FLOAT  -- Children Aged, Lt, 5 Years With Pneumonia Symptoms Taken To A Health Facility, Pct,
  "children_aged_lt_5_years_with_pneumonia_symptoms_taken_984c4a05" FLOAT  -- Children Aged, Lt, 5 Years With Pneumonia Symptoms Taken To A Health Facility, Pct Low,
  "children_aged_lt_5_years_with_pneumonia_symptoms_taken_020e6b0a" FLOAT  -- Children Aged, Lt, 5 Years With Pneumonia Symptoms Taken To A Health Facility, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_children_aged_lt_5_years_with_pneumonia_symptoms__8ee40234 (
  "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,
  "children_aged_lt_5_years_with_pneumonia_symptoms_taken_902a4dc8" FLOAT  -- Children Aged, Lt, 5 Years With Pneumonia Symptoms Taken To A Health Facility, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_cholera_case_fatality_rate_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "cholera_case_fatality_rate" FLOAT
);

CREATE TABLE owid_cholera_case_fatality_rate_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "cholera_case_fatality_rate" FLOAT,
  "cholera_case_fatality_rate_low" VARCHAR,
  "cholera_case_fatality_rate_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_display_qu_31488ec6 (
  "year" INTEGER,
  "country" VARCHAR,
  "comments" VARCHAR,
  "cigarette_packaging_and_labelling_must_display_qualita_848e1d6a" VARCHAR  -- Cigarette Packaging And Labelling Must Display Qualitative Information On Emission Yields
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_display_qu_b4c04cc2 (
  "year" INTEGER,
  "country" VARCHAR,
  "cigarette_packaging_and_labelling_must_display_qualita_848e1d6a" VARCHAR  -- Cigarette Packaging And Labelling Must Display Qualitative Information On Emission Yields,
  "cigarette_packaging_and_labelling_must_display_qualita_17697cb6" VARCHAR  -- Cigarette Packaging And Labelling Must Display Qualitative Information On Emission Yields Low,
  "cigarette_packaging_and_labelling_must_display_qualita_861c48e1" VARCHAR  -- Cigarette Packaging And Labelling Must Display Qualitative Information On Emission Yields High,
  "comments" VARCHAR
);

CREATE TABLE owid_cigarette_packaging_and_labelling_must_not_displa_3c8ba406 (
  "year" INTEGER,
  "country" VARCHAR,
  "cigarette_packaging_and_labelling_must_not_display_qua_84ff0343" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark,
  "cigarette_packaging_and_labelling_must_not_display_qua_78dceff2" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark Low,
  "cigarette_packaging_and_labelling_must_not_display_qua_a08bee10" VARCHAR  -- Cigarette Packaging And Labelling Must Not Display Quantitative Information On Emission Yields, Such As Tar Nicotine And Carbon Monoxide, Including When Used As Part Of A Brand Name Or Trademark High,
  "comments" VARCHAR
);