Global Health Observatory - World Health Organization

CREATE TABLE owid_population_with_household_expenditures_on_health__e0959ffe (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_type" VARCHAR,
  "household_composition_by_age" VARCHAR,
  "population_with_household_expenditures_on_health_great_b2b555c7" FLOAT  -- Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, National, Rural, Urban
);

CREATE TABLE owid_population_with_primary_reliance_on_clean_fuels_a_8d428dd3 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_primary_reliance_on_clean_fuels_and_te_9a18f3c1" FLOAT  -- Population With Primary Reliance On Clean Fuels And Technologies For Cooking, In Millions,
  "population_with_primary_reliance_on_clean_fuels_and_te_b04b75d5" FLOAT  -- Population With Primary Reliance On Clean Fuels And Technologies For Cooking, In Millions Low,
  "population_with_primary_reliance_on_clean_fuels_and_te_83ecef00" FLOAT  -- Population With Primary Reliance On Clean Fuels And Technologies For Cooking, In Millions High,
  "comments" VARCHAR,
  "population_without_primary_reliance_on_clean_fuels_and_ca07ea56" FLOAT  -- Population Without Primary Reliance On Clean Fuels And Technologies For Cooking, In Millions
);

CREATE TABLE owid_population_with_primary_reliance_on_clean_fuels_a_b0966653 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_primary_reliance_on_clean_fuels_and_te_9a18f3c1" FLOAT  -- Population With Primary Reliance On Clean Fuels And Technologies For Cooking, In Millions,
  "population_without_primary_reliance_on_clean_fuels_and_ca07ea56" FLOAT  -- Population Without Primary Reliance On Clean Fuels And Technologies For Cooking, In Millions
);

CREATE TABLE owid_population_with_primary_reliance_on_fuels_and_tec_837932b4 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "cooking_fuel" VARCHAR,
  "population_with_primary_reliance_on_fuels_and_technolo_284af2ac" FLOAT  -- Population With Primary Reliance On Fuels And Technologies For Cooking, By Fuel Type, In Millions,
  "population_with_primary_reliance_on_fuels_and_technolo_12a72796" FLOAT  -- Population With Primary Reliance On Fuels And Technologies For Cooking, By Fuel Type, In Millions Low,
  "population_with_primary_reliance_on_fuels_and_technolo_7602a211" FLOAT  -- Population With Primary Reliance On Fuels And Technologies For Cooking, By Fuel Type, In Millions High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_with_primary_reliance_on_fuels_and_tec_b2c3626c (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "cooking_fuel" VARCHAR,
  "population_with_primary_reliance_on_fuels_and_technolo_284af2ac" FLOAT  -- Population With Primary Reliance On Fuels And Technologies For Cooking, By Fuel Type, In Millions
);

CREATE TABLE owid_population_with_primary_reliance_on_polluting_fue_71946a3b (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_primary_reliance_on_polluting_fuels_an_d54cdb36" FLOAT  -- Population With Primary Reliance On Polluting Fuels And Technologies For Cooking, In Millions,
  "population_with_primary_reliance_on_polluting_fuels_an_23f74be8" FLOAT  -- Population With Primary Reliance On Polluting Fuels And Technologies For Cooking, In Millions Low,
  "population_with_primary_reliance_on_polluting_fuels_an_41224a6e" FLOAT  -- Population With Primary Reliance On Polluting Fuels And Technologies For Cooking, In Millions High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_with_primary_reliance_on_polluting_fue_e9033f77 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_primary_reliance_on_polluting_fuels_an_d54cdb36" FLOAT  -- Population With Primary Reliance On Polluting Fuels And Technologies For Cooking, In Millions
);

CREATE TABLE owid_postgraduate_training_programme_in_prevention_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "postgraduate_training_programme_in_prevention" VARCHAR
);

CREATE TABLE owid_postgraduate_training_programme_in_prevention_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "postgraduate_training_programme_in_prevention" VARCHAR,
  "postgraduate_training_programme_in_prevention_low" VARCHAR,
  "postgraduate_training_programme_in_prevention_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_postgraduate_training_programme_in_treatment_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "postgraduate_training_programme_in_treatment" VARCHAR
);

CREATE TABLE owid_postgraduate_training_programme_in_treatment_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "human_resources_health_workforce" VARCHAR  -- Human Resources, Health Workforce,
  "postgraduate_training_programme_in_treatment" VARCHAR,
  "postgraduate_training_programme_in_treatment_low" VARCHAR,
  "postgraduate_training_programme_in_treatment_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_bor_06f3a1dd (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "education_level" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_born_out_79a24df0" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Five Years Preceding The Survey, Pct,
  "postnatal_care_visit_within_two_days_of_birth_born_out_52981f9c" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Five Years Preceding The Survey, Pct Low,
  "postnatal_care_visit_within_two_days_of_birth_born_out_fa770b5a" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Five Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_bor_5ad798ba (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_born_out_7d3b6964" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Three Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_bor_b6315478 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "education_level" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_born_out_7d3b6964" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Three Years Preceding The Survey, Pct,
  "postnatal_care_visit_within_two_days_of_birth_born_out_e436033c" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Three Years Preceding The Survey, Pct Low,
  "postnatal_care_visit_within_two_days_of_birth_born_out_5f5087d4" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Three Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_bor_fea74179 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_born_out_79a24df0" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, Born Outside A Health Facility, In The Five Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_in__43f49c54 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_in_the_t_e003466a" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, In The Three Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_in__ac3b4733 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "education_level" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_in_the_f_f5b3231a" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, In The Five Years Preceding The Survey, Pct,
  "postnatal_care_visit_within_two_days_of_birth_in_the_f_daa63008" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, In The Five Years Preceding The Survey, Pct Low,
  "postnatal_care_visit_within_two_days_of_birth_in_the_f_5b84fba4" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, In The Five Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_in__d024dfe0 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "wealth_quintile" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_in_the_t_e003466a" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, In The Three Years Preceding The Survey, Pct,
  "postnatal_care_visit_within_two_days_of_birth_in_the_t_8a888df9" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, In The Three Years Preceding The Survey, Pct Low,
  "postnatal_care_visit_within_two_days_of_birth_in_the_t_769da3cd" VARCHAR  -- Postnatal Care Visit Within Two Days Of Birth, In The Three Years Preceding The Survey, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_postnatal_care_visit_within_two_days_of_birth_in__fd1ce8a8 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "mothers_education_level" VARCHAR,
  "residence_area_type" VARCHAR,
  "wealth_quintile" VARCHAR,
  "postnatal_care_visit_within_two_days_of_birth_in_the_f_f5b3231a" FLOAT  -- Postnatal Care Visit Within Two Days Of Birth, In The Five Years Preceding The Survey, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_poverty_headcount_ratio_at_dollar1_25_a_day_ppp_p_06b3208f (
  "year" INTEGER,
  "country" VARCHAR,
  "poverty_headcount_ratio_at_dollar1_25_a_day_ppp_pct_of_e779d8cc" FLOAT  -- Poverty Headcount Ratio At Dollar1–25 A Day, Ppp, Pct Of Population,
  "poverty_headcount_ratio_at_dollar1_25_a_day_ppp_pct_of_7553974e" VARCHAR  -- Poverty Headcount Ratio At Dollar1–25 A Day, Ppp, Pct Of Population Low,
  "poverty_headcount_ratio_at_dollar1_25_a_day_ppp_pct_of_9625d98d" VARCHAR  -- Poverty Headcount Ratio At Dollar1–25 A Day, Ppp, Pct Of Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_poverty_headcount_ratio_at_dollar1_25_a_day_ppp_p_4130b300 (
  "year" INTEGER,
  "country" VARCHAR,
  "poverty_headcount_ratio_at_dollar1_25_a_day_ppp_pct_of_e779d8cc" FLOAT  -- Poverty Headcount Ratio At Dollar1–25 A Day, Ppp, Pct Of Population
);

CREATE TABLE owid_power_density_w_m2_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "radio_band" VARCHAR,
  "comments" VARCHAR,
  "power_density_w_m2" VARCHAR  -- Power Density, W M2
);

CREATE TABLE owid_power_density_w_m2_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "radio_band" VARCHAR,
  "power_density_w_m2" VARCHAR  -- Power Density, W M2,
  "power_density_w_m2_low" VARCHAR  -- Power Density, W M2 Low,
  "power_density_w_m2_high" VARCHAR  -- Power Density, W M2 High,
  "comments" VARCHAR
);

CREATE TABLE owid_power_frequency_hz_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "power_frequency_hz" VARCHAR  -- Power Frequency, Hz
);

CREATE TABLE owid_power_frequency_hz_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "exposed" VARCHAR,
  "frequency" VARCHAR,
  "power_frequency_hz" VARCHAR  -- Power Frequency, Hz,
  "power_frequency_hz_low" VARCHAR  -- Power Frequency, Hz Low,
  "power_frequency_hz_high" VARCHAR  -- Power Frequency, Hz High,
  "comments" VARCHAR
);