Global Health Observatory - World Health Organization

CREATE TABLE owid_total_environment_attributable_deaths_000_in_chil_ad82337e (
  "year" INTEGER,
  "country" VARCHAR,
  "total_environment_attributable_deaths_000_in_children__ae55d47b" FLOAT  -- Total Environment Attributable Deaths, 000, In Children Under 5 Years,
  "total_environment_attributable_deaths_000_in_children__49aa7a73" VARCHAR  -- Total Environment Attributable Deaths, 000, In Children Under 5 Years Low,
  "total_environment_attributable_deaths_000_in_children__df953cbe" VARCHAR  -- Total Environment Attributable Deaths, 000, In Children Under 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_environment_attributable_deaths_000_in_chil_c24724bd (
  "year" INTEGER,
  "country" VARCHAR,
  "total_environment_attributable_deaths_000_in_children__ae55d47b" FLOAT  -- Total Environment Attributable Deaths, 000, In Children Under 5 Years
);

CREATE TABLE owid_total_environment_attributable_deaths_per_100000__2186c55e (
  "year" INTEGER,
  "country" VARCHAR,
  "total_environment_attributable_deaths_per_100000_child_45bfa361" INTEGER  -- Total Environment Attributable Deaths Per 100000 Children Under 5 Years
);

CREATE TABLE owid_total_environment_attributable_deaths_per_100000__abaf37af (
  "year" INTEGER,
  "country" VARCHAR,
  "total_environment_attributable_deaths_per_100000_child_45bfa361" INTEGER  -- Total Environment Attributable Deaths Per 100000 Children Under 5 Years,
  "total_environment_attributable_deaths_per_100000_child_b9c9cf6e" VARCHAR  -- Total Environment Attributable Deaths Per 100000 Children Under 5 Years Low,
  "total_environment_attributable_deaths_per_100000_child_fc5317b9" VARCHAR  -- Total Environment Attributable Deaths Per 100000 Children Under 5 Years High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_expenditure_on_dementia_basic_research_loca_521fa73a (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_basic_research_local_cur_d3453a72" FLOAT  -- Total Expenditure On Dementia Basic Research, Local Currency, Self Report
);

CREATE TABLE owid_total_expenditure_on_dementia_basic_research_loca_c3fedc02 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_basic_research_local_cur_d3453a72" FLOAT  -- Total Expenditure On Dementia Basic Research, Local Currency, Self Report,
  "total_expenditure_on_dementia_basic_research_local_cur_652f548b" VARCHAR  -- Total Expenditure On Dementia Basic Research, Local Currency, Self Report Low,
  "total_expenditure_on_dementia_basic_research_local_cur_596d75fe" VARCHAR  -- Total Expenditure On Dementia Basic Research, Local Currency, Self Report High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_expenditure_on_dementia_clinical_translatio_5959e940 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_clinical_translational_r_7c565010" FLOAT  -- Total Expenditure On Dementia Clinical Translational Research, Local Currency, Self Report
);

CREATE TABLE owid_total_expenditure_on_dementia_clinical_translatio_701f1f9b (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_clinical_translational_r_7c565010" FLOAT  -- Total Expenditure On Dementia Clinical Translational Research, Local Currency, Self Report,
  "total_expenditure_on_dementia_clinical_translational_r_19e28d51" VARCHAR  -- Total Expenditure On Dementia Clinical Translational Research, Local Currency, Self Report Low,
  "total_expenditure_on_dementia_clinical_translational_r_65d332e0" VARCHAR  -- Total Expenditure On Dementia Clinical Translational Research, Local Currency, Self Report High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_expenditure_on_dementia_implementation_rese_536adea8 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_implementation_research__5123f167" FLOAT  -- Total Expenditure On Dementia Implementation Research, Local Currency, Self Report
);

CREATE TABLE owid_total_expenditure_on_dementia_implementation_rese_b58aed71 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_implementation_research__5123f167" FLOAT  -- Total Expenditure On Dementia Implementation Research, Local Currency, Self Report,
  "total_expenditure_on_dementia_implementation_research__72d68ba0" VARCHAR  -- Total Expenditure On Dementia Implementation Research, Local Currency, Self Report Low,
  "total_expenditure_on_dementia_implementation_research__7b147a44" VARCHAR  -- Total Expenditure On Dementia Implementation Research, Local Currency, Self Report High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_expenditure_on_dementia_research_local_curr_0ebbf3d7 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_research_local_currency__3913bd8c" FLOAT  -- Total Expenditure On Dementia Research, Local Currency, Self Report
);

CREATE TABLE owid_total_expenditure_on_dementia_research_local_curr_0fe7a920 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dementia_research_local_currency__3913bd8c" FLOAT  -- Total Expenditure On Dementia Research, Local Currency, Self Report,
  "total_expenditure_on_dementia_research_local_currency__88f3a42f" VARCHAR  -- Total Expenditure On Dementia Research, Local Currency, Self Report Low,
  "total_expenditure_on_dementia_research_local_currency__6e949804" VARCHAR  -- Total Expenditure On Dementia Research, Local Currency, Self Report High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_expenditure_on_dental_healthcare_in_million_usd_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dental_healthcare_in_million_usd" FLOAT  -- Total Expenditure On Dental Healthcare In Million, Usd
);

CREATE TABLE owid_total_expenditure_on_dental_healthcare_in_million_usd_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_expenditure_on_dental_healthcare_in_million_usd" FLOAT  -- Total Expenditure On Dental Healthcare In Million, Usd,
  "total_expenditure_on_dental_healthcare_in_million_usd_low" VARCHAR  -- Total Expenditure On Dental Healthcare In Million, Usd Low,
  "total_expenditure_on_dental_healthcare_in_million_usd_high" VARCHAR  -- Total Expenditure On Dental Healthcare In Million, Usd High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_fertility_rate_births_per_woman_1 (
  "year" INTEGER,
  "country" 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,
  "total_fertility_rate_births_per_woman" FLOAT  -- Total Fertility Rate, Births Per Woman,
  "comments" VARCHAR
);

CREATE TABLE owid_total_fertility_rate_births_per_woman_2 (
  "year" INTEGER,
  "country" 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,
  "total_fertility_rate_births_per_woman" FLOAT  -- Total Fertility Rate, Births Per Woman,
  "total_fertility_rate_births_per_woman_low" FLOAT  -- Total Fertility Rate, Births Per Woman Low,
  "total_fertility_rate_births_per_woman_high" FLOAT  -- Total Fertility Rate, Births Per Woman High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_ncd_deaths_in_thousands_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "causes" VARCHAR,
  "total_ncd_deaths_in_thousands" FLOAT  -- Total Ncd Deaths, In Thousands
);

CREATE TABLE owid_total_ncd_deaths_in_thousands_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "sex" VARCHAR,
  "causes" VARCHAR,
  "total_ncd_deaths_in_thousands" UINTEGER  -- Total Ncd Deaths, In Thousands,
  "total_ncd_deaths_in_thousands_low" UINTEGER  -- Total Ncd Deaths, In Thousands Low,
  "total_ncd_deaths_in_thousands_high" UINTEGER  -- Total Ncd Deaths, In Thousands High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_net_official_development_assistance_to_medi_78337448 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_net_official_development_assistance_to_medical_r_4f13ec5c" FLOAT  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Usd, By Recipient Country
);

CREATE TABLE owid_total_net_official_development_assistance_to_medi_b4a60f1c (
  "year" INTEGER,
  "country" VARCHAR,
  "total_net_official_development_assistance_to_medical_r_4f13ec5c" FLOAT  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Usd, By Recipient Country,
  "total_net_official_development_assistance_to_medical_r_e2b4bb9c" VARCHAR  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Usd, By Recipient Country Low,
  "total_net_official_development_assistance_to_medical_r_8247d11b" VARCHAR  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Usd, By Recipient Country High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_net_official_development_assistance_to_medi_d56e51e6 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_net_official_development_assistance_to_medical_r_b4fdf668" FLOAT  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Constant 2014 Usd, By Recipient,
  "total_net_official_development_assistance_to_medical_r_9378d213" VARCHAR  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Constant 2014 Usd, By Recipient Low,
  "total_net_official_development_assistance_to_medical_r_47c5d3b7" VARCHAR  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Constant 2014 Usd, By Recipient High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_net_official_development_assistance_to_medi_f325faff (
  "year" INTEGER,
  "country" VARCHAR,
  "total_net_official_development_assistance_to_medical_r_b4fdf668" FLOAT  -- Total Net Official Development Assistance To Medical Research And Basic Health Sectors Per Capita, Constant 2014 Usd, By Recipient
);

CREATE TABLE owid_total_number_of_malaria_cases_presumed_plus_confi_20a8bc5d (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_malaria_cases_presumed_plus_confirmed_cases" UINTEGER  -- Total Number Of, Malaria Cases, Presumed Plus Confirmed Cases,
  "total_number_of_malaria_cases_presumed_plus_confirmed_cases_low" VARCHAR  -- Total Number Of, Malaria Cases, Presumed Plus Confirmed Cases Low,
  "total_number_of_malaria_cases_presumed_plus_confirmed__e7f95100" VARCHAR  -- Total Number Of, Malaria Cases, Presumed Plus Confirmed Cases High,
  "comments" VARCHAR
);

CREATE TABLE owid_total_number_of_malaria_cases_presumed_plus_confi_d803600d (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_malaria_cases_presumed_plus_confirmed_cases" UINTEGER  -- Total Number Of, Malaria Cases, Presumed Plus Confirmed Cases
);

CREATE TABLE owid_total_number_of_notified_tb_cases_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "total_number_of_notified_tb_cases" UINTEGER
);