Global Health Observatory - World Health Organization

CREATE TABLE owid_population_pushed_further_below_a_relative_povert_0c2eace5 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_type" VARCHAR,
  "household_composition_by_age" VARCHAR,
  "population_pushed_further_below_a_relative_poverty_lin_1cf848c2" FLOAT  -- Population Pushed Further Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban
);

CREATE TABLE owid_population_pushed_further_below_a_relative_povert_67534f60 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_composition_by_age" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_type" VARCHAR,
  "population_pushed_further_below_a_relative_poverty_lin_1cf848c2" FLOAT  -- Population Pushed Further Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban,
  "population_pushed_further_below_a_relative_poverty_lin_5c35bca7" VARCHAR  -- Population Pushed Further Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban Low,
  "population_pushed_further_below_a_relative_poverty_lin_0e01e5a3" VARCHAR  -- Population Pushed Further Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_pushed_further_below_the_dollar1_90_a__0c9ff08e (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_type" VARCHAR,
  "household_composition_by_age" VARCHAR,
  "population_pushed_further_below_the_dollar1_90_a_day_p_cf4875c2" FLOAT  -- Population Pushed Further Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban
);

CREATE TABLE owid_population_pushed_further_below_the_dollar1_90_a__f7826880 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_composition_by_age" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_type" VARCHAR,
  "population_pushed_further_below_the_dollar1_90_a_day_p_cf4875c2" FLOAT  -- Population Pushed Further Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban,
  "population_pushed_further_below_the_dollar1_90_a_day_p_f55e9f46" VARCHAR  -- Population Pushed Further Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban Low,
  "population_pushed_further_below_the_dollar1_90_a_day_p_53ea54ae" VARCHAR  -- Population Pushed Further Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_pushed_further_below_the_dollar2_15_a__c98a87cc (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_composition_by_age" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_type" VARCHAR,
  "population_pushed_further_below_the_dollar2_15_a_day_p_2142433c" FLOAT  -- Population Pushed Further Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban,
  "population_pushed_further_below_the_dollar2_15_a_day_p_96c4b725" VARCHAR  -- Population Pushed Further Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban Low,
  "population_pushed_further_below_the_dollar2_15_a_day_p_2371ce9d" VARCHAR  -- Population Pushed Further Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_pushed_further_below_the_dollar3_20_a__3e222583 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_further_below_the_dollar3_20_a_day_p_4c5e971a" FLOAT  -- Population Pushed Further Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban
);

CREATE TABLE owid_population_pushed_further_below_the_dollar3_20_a__c2411e52 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_further_below_the_dollar3_20_a_day_p_4c5e971a" FLOAT  -- Population Pushed Further Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban,
  "population_pushed_further_below_the_dollar3_20_a_day_p_6aaa4f13" VARCHAR  -- Population Pushed Further Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban Low,
  "population_pushed_further_below_the_dollar3_20_a_day_p_bfaf4328" VARCHAR  -- Population Pushed Further Below The Dollar3–20 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_pushed_further_below_the_dollar3_65_a__a1ae81ea (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_further_below_the_dollar3_65_a_day_p_4790e5a7" FLOAT  -- Population Pushed Further Below The Dollar3–65 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban,
  "population_pushed_further_below_the_dollar3_65_a_day_p_97ad518b" VARCHAR  -- Population Pushed Further Below The Dollar3–65 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban Low,
  "population_pushed_further_below_the_dollar3_65_a_day_p_10b97e15" VARCHAR  -- Population Pushed Further Below The Dollar3–65 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_using_at_least_basic_drinking_water_se_5346e9dc (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_at_least_basic_drinking_water_services_pct" FLOAT  -- Population Using At Least Basic Drinking Water Services, Pct,
  "population_using_at_least_basic_drinking_water_services_pct_low" VARCHAR  -- Population Using At Least Basic Drinking Water Services, Pct Low,
  "population_using_at_least_basic_drinking_water_service_8b21793b" VARCHAR  -- Population Using At Least Basic Drinking Water Services, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_using_at_least_basic_drinking_water_se_b29c5de4 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_at_least_basic_drinking_water_services_pct" FLOAT  -- Population Using At Least Basic Drinking Water Services, Pct
);

CREATE TABLE owid_population_using_at_least_basic_sanitation_services_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_at_least_basic_sanitation_services_pct" FLOAT  -- Population Using At Least Basic Sanitation Services, Pct
);

CREATE TABLE owid_population_using_at_least_basic_sanitation_services_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_at_least_basic_sanitation_services_pct" FLOAT  -- Population Using At Least Basic Sanitation Services, Pct,
  "population_using_at_least_basic_sanitation_services_pct_low" VARCHAR  -- Population Using At Least Basic Sanitation Services, Pct Low,
  "population_using_at_least_basic_sanitation_services_pct_high" VARCHAR  -- Population Using At Least Basic Sanitation Services, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_using_safely_managed_drinking_water_se_4027b52a (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_safely_managed_drinking_water_services_pct" FLOAT  -- Population Using Safely Managed Drinking Water Services, Pct,
  "population_using_safely_managed_drinking_water_services_pct_low" VARCHAR  -- Population Using Safely Managed Drinking Water Services, Pct Low,
  "population_using_safely_managed_drinking_water_service_05db5890" VARCHAR  -- Population Using Safely Managed Drinking Water Services, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_using_safely_managed_drinking_water_se_b8af7d6a (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_safely_managed_drinking_water_services_pct" FLOAT  -- Population Using Safely Managed Drinking Water Services, Pct
);

CREATE TABLE owid_population_using_safely_managed_sanitation_services_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_safely_managed_sanitation_services_pct" FLOAT  -- Population Using Safely Managed Sanitation Services, Pct
);

CREATE TABLE owid_population_using_safely_managed_sanitation_services_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_safely_managed_sanitation_services_pct" FLOAT  -- Population Using Safely Managed Sanitation Services, Pct,
  "population_using_safely_managed_sanitation_services_pct_low" VARCHAR  -- Population Using Safely Managed Sanitation Services, Pct Low,
  "population_using_safely_managed_sanitation_services_pct_high" VARCHAR  -- Population Using Safely Managed Sanitation Services, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_using_solid_fuels_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_solid_fuels_pct" FLOAT  -- Population Using Solid Fuels, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_population_using_solid_fuels_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_using_solid_fuels_pct" FLOAT  -- Population Using Solid Fuels, Pct,
  "population_using_solid_fuels_pct_low" VARCHAR  -- Population Using Solid Fuels, Pct Low,
  "population_using_solid_fuels_pct_high" VARCHAR  -- Population Using Solid Fuels, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_with_access_to_an_insecticide_treated__03810c17 (
  "year" INTEGER,
  "country" VARCHAR,
  "population_with_access_to_an_insecticide_treated_bed_n_d1e24e82" FLOAT  -- Population With Access To An Insecticide Treated Bed Net, Itn, For Malaria Protection, Pct, Modelled,
  "population_with_access_to_an_insecticide_treated_bed_n_b972b2dc" VARCHAR  -- Population With Access To An Insecticide Treated Bed Net, Itn, For Malaria Protection, Pct, Modelled Low,
  "population_with_access_to_an_insecticide_treated_bed_n_92c370e2" VARCHAR  -- Population With Access To An Insecticide Treated Bed Net, Itn, For Malaria Protection, Pct, Modelled High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_with_access_to_an_insecticide_treated__72ad61b9 (
  "year" INTEGER,
  "country" VARCHAR,
  "population_with_access_to_an_insecticide_treated_bed_n_d1e24e82" FLOAT  -- Population With Access To An Insecticide Treated Bed Net, Itn, For Malaria Protection, Pct, Modelled
);

CREATE TABLE owid_population_with_basic_handwashing_facilities_at_home_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_basic_handwashing_facilities_at_home_pct" FLOAT  -- Population With Basic Handwashing Facilities At Home, Pct
);

CREATE TABLE owid_population_with_basic_handwashing_facilities_at_home_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_basic_handwashing_facilities_at_home_pct" FLOAT  -- Population With Basic Handwashing Facilities At Home, Pct,
  "population_with_basic_handwashing_facilities_at_home_pct_low" VARCHAR  -- Population With Basic Handwashing Facilities At Home, Pct Low,
  "population_with_basic_handwashing_facilities_at_home_pct_high" VARCHAR  -- Population With Basic Handwashing Facilities At Home, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_with_household_expenditures_on_health__15f6225a (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_household_expenditures_on_health_great_086e0190" FLOAT  -- Population With Household Expenditures On Health Greater Than 25pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, National, Rural, Urban,
  "population_with_household_expenditures_on_health_great_066367f8" VARCHAR  -- Population With Household Expenditures On Health Greater Than 25pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, National, Rural, Urban Low,
  "population_with_household_expenditures_on_health_great_19dff0ae" VARCHAR  -- Population With Household Expenditures On Health Greater Than 25pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_with_household_expenditures_on_health__c3a07f68 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "household_composition_by_age" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_type" 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,
  "population_with_household_expenditures_on_health_great_1c8482e7" VARCHAR  -- Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, National, Rural, Urban Low,
  "population_with_household_expenditures_on_health_great_c5f86f30" VARCHAR  -- Population With Household Expenditures On Health Greater Than 10pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_with_household_expenditures_on_health__caca9db4 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_with_household_expenditures_on_health_great_086e0190" FLOAT  -- Population With Household Expenditures On Health Greater Than 25pct Of Total Household Expenditure Or Income, Sdg Indicator 3–8 2, Pct, National, Rural, Urban
);