Global Health Observatory - World Health Organization

CREATE TABLE owid_policy_or_strategy_makes_specific_reference_tothe_f114b444 (
  "year" INTEGER,
  "country" VARCHAR,
  "policy_or_strategy_makes_specific_reference_tothe_use__b1d06c03" VARCHAR  -- Policy Or Strategy Makes Specific Reference Tothe Use Of Social Media In The Health Domain,
  "policy_or_strategy_makes_specific_reference_tothe_use__ea7cda11" VARCHAR  -- Policy Or Strategy Makes Specific Reference Tothe Use Of Social Media In The Health Domain Low,
  "policy_or_strategy_makes_specific_reference_tothe_use__299b0c3b" VARCHAR  -- Policy Or Strategy Makes Specific Reference Tothe Use Of Social Media In The Health Domain High,
  "comments" VARCHAR
);

CREATE TABLE owid_polio_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,
  "polio_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Polio Immunization Coverage Among One Year Olds, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_polio_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,
  "residence_area_type" VARCHAR,
  "education_level" VARCHAR,
  "polio_immunization_coverage_among_one_year_olds_pct" FLOAT  -- Polio Immunization Coverage Among One Year Olds, Pct,
  "polio_immunization_coverage_among_one_year_olds_pct_low" FLOAT  -- Polio Immunization Coverage Among One Year Olds, Pct Low,
  "polio_immunization_coverage_among_one_year_olds_pct_high" FLOAT  -- Polio Immunization Coverage Among One Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_poliomyelitis_number_of_reported_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "poliomyelitis_number_of_reported_cases" UINTEGER  -- Poliomyelitis, Number Of Reported Cases
);

CREATE TABLE owid_poliomyelitis_number_of_reported_cases_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "poliomyelitis_number_of_reported_cases" UINTEGER  -- Poliomyelitis, Number Of Reported Cases,
  "poliomyelitis_number_of_reported_cases_low" VARCHAR  -- Poliomyelitis, Number Of Reported Cases Low,
  "poliomyelitis_number_of_reported_cases_high" VARCHAR  -- Poliomyelitis, Number Of Reported Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_polio_pol3_immunization_coverage_among_1_year_olds_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "polio_pol3_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Polio, Pol3, Immunization Coverage Among 1 Year Olds, Pct
);

CREATE TABLE owid_polio_pol3_immunization_coverage_among_1_year_olds_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "polio_pol3_immunization_coverage_among_1_year_olds_pct" INTEGER  -- Polio, Pol3, Immunization Coverage Among 1 Year Olds, Pct,
  "polio_pol3_immunization_coverage_among_1_year_olds_pct_low" VARCHAR  -- Polio, Pol3, Immunization Coverage Among 1 Year Olds, Pct Low,
  "polio_pol3_immunization_coverage_among_1_year_olds_pct_high" VARCHAR  -- Polio, Pol3, Immunization Coverage Among 1 Year Olds, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "population" UINTEGER
);

CREATE TABLE owid_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "population" UINTEGER,
  "population_low" VARCHAR,
  "population_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_population_aged_15_24_years_with_comprehensive_co_13de7be8 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "population_aged_15_24_years_with_comprehensive_correct_274730c7" INTEGER  -- Population Aged 15–24 Years With Comprehensive Correct Knowledge Of Hiv Aids, Pct
);

CREATE TABLE owid_population_aged_15_24_years_with_comprehensive_co_c3013aa9 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "population_aged_15_24_years_with_comprehensive_correct_274730c7" INTEGER  -- Population Aged 15–24 Years With Comprehensive Correct Knowledge Of Hiv Aids, Pct,
  "population_aged_15_24_years_with_comprehensive_correct_a9783858" VARCHAR  -- Population Aged 15–24 Years With Comprehensive Correct Knowledge Of Hiv Aids, Pct Low,
  "population_aged_15_24_years_with_comprehensive_correct_69210808" VARCHAR  -- Population Aged 15–24 Years With Comprehensive Correct Knowledge Of Hiv Aids, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_below_the_international_poverty_line_pct (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "population_below_the_international_poverty_line_pct" INTEGER  -- Population Below The International Poverty Line, Pct,
  "comments" VARCHAR
);

CREATE TABLE owid_population_in_areas_that_warrant_treatment_with_a_6f2294ff (
  "country" VARCHAR,
  "year" INTEGER,
  "population_in_areas_that_warrant_treatment_with_antibi_52261476" UINTEGER  -- Population In Areas That Warrant Treatment With Antibiotics, Facial Cleanliness And Environmental Improvement For Elimination Of Trachoma As A Public Health Problem,
  "population_in_areas_that_warrant_treatment_with_antibi_4b5211cf" VARCHAR  -- Population In Areas That Warrant Treatment With Antibiotics, Facial Cleanliness And Environmental Improvement For Elimination Of Trachoma As A Public Health Problem Low,
  "population_in_areas_that_warrant_treatment_with_antibi_c73789b1" VARCHAR  -- Population In Areas That Warrant Treatment With Antibiotics, Facial Cleanliness And Environmental Improvement For Elimination Of Trachoma As A Public Health Problem High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_in_areas_that_warrant_treatment_with_a_d7ead325 (
  "country" VARCHAR,
  "year" INTEGER,
  "population_in_areas_that_warrant_treatment_with_antibi_52261476" UINTEGER  -- Population In Areas That Warrant Treatment With Antibiotics, Facial Cleanliness And Environmental Improvement For Elimination Of Trachoma As A Public Health Problem
);

CREATE TABLE owid_population_practising_open_defecation_pct_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_practising_open_defecation_pct" FLOAT  -- Population Practising Open Defecation, Pct
);

CREATE TABLE owid_population_practising_open_defecation_pct_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_practising_open_defecation_pct" FLOAT  -- Population Practising Open Defecation, Pct,
  "population_practising_open_defecation_pct_low" VARCHAR  -- Population Practising Open Defecation, Pct Low,
  "population_practising_open_defecation_pct_high" VARCHAR  -- Population Practising Open Defecation, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_pushed_below_a_relative_poverty_line_b_ccac9a1b (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_below_a_relative_poverty_line_by_hou_1bcb7357" FLOAT  -- Population Pushed 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_below_a_relative_poverty_line_b_fc5de772 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_below_a_relative_poverty_line_by_hou_1bcb7357" FLOAT  -- Population Pushed Below A Relative Poverty Line By Household Health Expenditures, 60pct Of Median Daily Per Capita Consumption Or Income, Pct, National, Rural, Urban,
  "population_pushed_below_a_relative_poverty_line_by_hou_e370d6f7" VARCHAR  -- Population Pushed 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_below_a_relative_poverty_line_by_hou_473720ed" VARCHAR  -- Population Pushed 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_below_the_dollar1_90_a_day_pove_87d87941 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_below_the_dollar1_90_a_day_poverty_l_7b7304b1" FLOAT  -- Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban,
  "population_pushed_below_the_dollar1_90_a_day_poverty_l_8b5c411c" VARCHAR  -- Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban Low,
  "population_pushed_below_the_dollar1_90_a_day_poverty_l_48aa0e0b" VARCHAR  -- Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

CREATE TABLE owid_population_pushed_below_the_dollar1_90_a_day_pove_dfe3a094 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_below_the_dollar1_90_a_day_poverty_l_7b7304b1" FLOAT  -- Population Pushed Below The Dollar1–90 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban
);

CREATE TABLE owid_population_pushed_below_the_dollar2_15_a_day_pove_2ede88d9 (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_below_the_dollar2_15_a_day_poverty_l_d3860012" FLOAT  -- Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban
);

CREATE TABLE owid_population_pushed_below_the_dollar2_15_a_day_pove_d1c4263c (
  "year" INTEGER,
  "country" VARCHAR,
  "residence_area_type" VARCHAR,
  "population_pushed_below_the_dollar2_15_a_day_poverty_l_d3860012" FLOAT  -- Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban,
  "population_pushed_below_the_dollar2_15_a_day_poverty_l_93d9c9f8" VARCHAR  -- Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban Low,
  "population_pushed_below_the_dollar2_15_a_day_poverty_l_f02768a0" VARCHAR  -- Population Pushed Below The Dollar2–15 A Day Poverty Line By Household Health Expenditures, Pct, National, Rural, Urban High,
  "comments" VARCHAR
);

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

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

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