Global Health Observatory - World Health Organization

CREATE TABLE owid_establishment_of_national_coordination_centre_ncc_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "establishment_of_national_coordination_centre_ncc" FLOAT  -- Establishment Of National Coordination Centre, Ncc
);

CREATE TABLE owid_establishment_of_national_coordination_centre_ncc_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "establishment_of_national_coordination_centre_ncc" FLOAT  -- Establishment Of National Coordination Centre, Ncc,
  "establishment_of_national_coordination_centre_ncc_low" VARCHAR  -- Establishment Of National Coordination Centre, Ncc Low,
  "establishment_of_national_coordination_centre_ncc_high" VARCHAR  -- Establishment Of National Coordination Centre, Ncc High,
  "comments" VARCHAR
);

CREATE TABLE owid_establishment_of_national_reference_laboratory_nrl_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "establishment_of_national_reference_laboratory_nrl" FLOAT  -- Establishment Of National Reference Laboratory, Nrl
);

CREATE TABLE owid_establishment_of_national_reference_laboratory_nrl_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "amr_glass_category" VARCHAR,
  "establishment_of_national_reference_laboratory_nrl" FLOAT  -- Establishment Of National Reference Laboratory, Nrl,
  "establishment_of_national_reference_laboratory_nrl_low" VARCHAR  -- Establishment Of National Reference Laboratory, Nrl Low,
  "establishment_of_national_reference_laboratory_nrl_high" VARCHAR  -- Establishment Of National Reference Laboratory, Nrl High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_antiretroviral_therapy_coverage_among_children_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_antiretroviral_therapy_coverage_among_children" INTEGER
);

CREATE TABLE owid_estimated_antiretroviral_therapy_coverage_among_children_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_antiretroviral_therapy_coverage_among_children" INTEGER,
  "estimated_antiretroviral_therapy_coverage_among_children_low" INTEGER,
  "estimated_antiretroviral_therapy_coverage_among_children_high" INTEGER,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_antiretroviral_therapy_coverage_among_p_07bbcdfb (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_antiretroviral_therapy_coverage_among_people_bede645f" INTEGER  -- Estimated Antiretroviral Therapy Coverage Among People Living With Hiv, Pct,
  "estimated_antiretroviral_therapy_coverage_among_people_d0040a6c" INTEGER  -- Estimated Antiretroviral Therapy Coverage Among People Living With Hiv, Pct Low,
  "estimated_antiretroviral_therapy_coverage_among_people_bc05b712" INTEGER  -- Estimated Antiretroviral Therapy Coverage Among People Living With Hiv, Pct High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_antiretroviral_therapy_coverage_among_p_95589436 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_antiretroviral_therapy_coverage_among_people_bede645f" INTEGER  -- Estimated Antiretroviral Therapy Coverage Among People Living With Hiv, Pct
);

CREATE TABLE owid_estimated_direct_deaths_from_major_conflicts_per__0234ca5b (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_direct_deaths_from_major_conflicts_per_100_0_8f279dcb" FLOAT  -- Estimated Direct Deaths From Major Conflicts, Per 100–000 Population
);

CREATE TABLE owid_estimated_direct_deaths_from_major_conflicts_per__e2bbe434 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_direct_deaths_from_major_conflicts_per_100_0_8f279dcb" FLOAT  -- Estimated Direct Deaths From Major Conflicts, Per 100–000 Population,
  "estimated_direct_deaths_from_major_conflicts_per_100_0_efcb1a37" FLOAT  -- Estimated Direct Deaths From Major Conflicts, Per 100–000 Population Low,
  "estimated_direct_deaths_from_major_conflicts_per_100_0_bf30c40f" FLOAT  -- Estimated Direct Deaths From Major Conflicts, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_malaria_incidence_per_1000_population_at_risk_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_malaria_incidence_per_1000_population_at_risk" FLOAT  -- Estimated Malaria Incidence, Per 1000 Population At Risk
);

CREATE TABLE owid_estimated_malaria_incidence_per_1000_population_at_risk_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_malaria_incidence_per_1000_population_at_risk" FLOAT  -- Estimated Malaria Incidence, Per 1000 Population At Risk,
  "estimated_malaria_incidence_per_1000_population_at_risk_low" FLOAT  -- Estimated Malaria Incidence, Per 1000 Population At Risk Low,
  "estimated_malaria_incidence_per_1000_population_at_risk_high" FLOAT  -- Estimated Malaria Incidence, Per 1000 Population At Risk High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_malaria_mortality_rate_per_100_000_population_1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_malaria_mortality_rate_per_100_000_population" FLOAT  -- Estimated Malaria Mortality Rate, Per 100–000 Population
);

CREATE TABLE owid_estimated_malaria_mortality_rate_per_100_000_population_2 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_malaria_mortality_rate_per_100_000_population" FLOAT  -- Estimated Malaria Mortality Rate, Per 100–000 Population,
  "estimated_malaria_mortality_rate_per_100_000_population_low" FLOAT  -- Estimated Malaria Mortality Rate, Per 100–000 Population Low,
  "estimated_malaria_mortality_rate_per_100_000_population_high" FLOAT  -- Estimated Malaria Mortality Rate, Per 100–000 Population High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_mdr_tb_cases_among_notified_pulmonary_tb_cases (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_mdr_tb_cases_among_notified_pulmonary_tb_cases" UINTEGER
);

CREATE TABLE owid_estimated_number_of_children_needing_antiretrovir_8a160b0f (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_children_needing_antiretroviral_th_772f0760" UINTEGER  -- Estimated Number Of Children Needing Antiretroviral Therapy Based On Who Methods,
  "estimated_number_of_children_needing_antiretroviral_th_316f5f73" UINTEGER  -- Estimated Number Of Children Needing Antiretroviral Therapy Based On Who Methods Low,
  "estimated_number_of_children_needing_antiretroviral_th_8038eab1" UINTEGER  -- Estimated Number Of Children Needing Antiretroviral Therapy Based On Who Methods High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_children_needing_antiretrovir_a5975f33 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_children_needing_antiretroviral_th_772f0760" UINTEGER  -- Estimated Number Of Children Needing Antiretroviral Therapy Based On Who Methods
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_fin_a424505e (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_financia_f62ea32e" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Financial Benefits Social Protection
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_fin_bfede617 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_financia_f62ea32e" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Financial Benefits Social Protection,
  "estimated_number_of_dementia_carers_receiving_financia_de32ee83" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Financial Benefits Social Protection Low,
  "estimated_number_of_dementia_carers_receiving_financia_a804f6f2" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Financial Benefits Social Protection High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_psy_30143ad1 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_psycho_s_cec8cd3f" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Psycho Social Supports
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_psy_a5ae408a (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_psycho_s_cec8cd3f" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Psycho Social Supports,
  "estimated_number_of_dementia_carers_receiving_psycho_s_00349f78" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Psycho Social Supports Low,
  "estimated_number_of_dementia_carers_receiving_psycho_s_c4b68c0c" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Psycho Social Supports High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_res_a3bb6181 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_respite_care" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_respite_care_low" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_respite_care_high" VARCHAR,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_res_f3198999 (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_respite_care" VARCHAR
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_tra_77d1a93d (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_training_62cc4f54" UINTEGER  -- Estimated Number Of Dementia Carers Receiving Training And Education,
  "estimated_number_of_dementia_carers_receiving_training_1d80c080" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Training And Education Low,
  "estimated_number_of_dementia_carers_receiving_training_cdf952f1" VARCHAR  -- Estimated Number Of Dementia Carers Receiving Training And Education High,
  "comments" VARCHAR
);

CREATE TABLE owid_estimated_number_of_dementia_carers_receiving_tra_c175539d (
  "year" INTEGER,
  "country" VARCHAR,
  "estimated_number_of_dementia_carers_receiving_training_62cc4f54" UINTEGER  -- Estimated Number Of Dementia Carers Receiving Training And Education
);