Global Health Observatory - World Health Organization
@owid.gho
@owid.gho
CREATE TABLE owid_nurses_working_in_mental_health_sector_per_100_00_b40964c9 (
"year" INTEGER,
"country" VARCHAR,
"nurses_working_in_mental_health_sector_per_100_000_population" FLOAT -- Nurses Working In Mental Health Sector, Per 100–000 Population,
"nurses_working_in_mental_health_sector_per_100_000_pop_24274f7b" VARCHAR -- Nurses Working In Mental Health Sector, Per 100–000 Population Low,
"nurses_working_in_mental_health_sector_per_100_000_pop_409a48a6" VARCHAR -- Nurses Working In Mental Health Sector, Per 100–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_nursing_and_midwifery_personnel_number_1 (
"year" INTEGER,
"country" VARCHAR,
"nursing_and_midwifery_personnel_number" UINTEGER -- Nursing And Midwifery Personnel, Number
);
CREATE TABLE owid_nursing_and_midwifery_personnel_number_2 (
"year" INTEGER,
"country" VARCHAR,
"nursing_and_midwifery_personnel_number" UINTEGER -- Nursing And Midwifery Personnel, Number,
"nursing_and_midwifery_personnel_number_low" VARCHAR -- Nursing And Midwifery Personnel, Number Low,
"nursing_and_midwifery_personnel_number_high" VARCHAR -- Nursing And Midwifery Personnel, Number High,
"comments" VARCHAR
);
CREATE TABLE owid_nursing_and_midwifery_personnel_per_10_000_population_1 (
"year" INTEGER,
"country" VARCHAR,
"nursing_and_midwifery_personnel_per_10_000_population" FLOAT -- Nursing And Midwifery Personnel, Per 10–000 Population
);
CREATE TABLE owid_nursing_and_midwifery_personnel_per_10_000_population_2 (
"year" INTEGER,
"country" VARCHAR,
"nursing_and_midwifery_personnel_per_10_000_population" FLOAT -- Nursing And Midwifery Personnel, Per 10–000 Population,
"nursing_and_midwifery_personnel_per_10_000_population_low" VARCHAR -- Nursing And Midwifery Personnel, Per 10–000 Population Low,
"nursing_and_midwifery_personnel_per_10_000_population_high" VARCHAR -- Nursing And Midwifery Personnel, Per 10–000 Population High,
"comments" VARCHAR
);
CREATE TABLE owid_nursing_personnel_number_1 (
"year" INTEGER,
"country" VARCHAR,
"nursing_personnel_number" UINTEGER -- Nursing Personnel, Number,
"comments" VARCHAR
);
CREATE TABLE owid_nursing_personnel_number_2 (
"year" INTEGER,
"country" VARCHAR,
"nursing_personnel_number" UINTEGER -- Nursing Personnel, Number,
"nursing_personnel_number_low" VARCHAR -- Nursing Personnel, Number Low,
"nursing_personnel_number_high" VARCHAR -- Nursing Personnel, Number High,
"comments" VARCHAR
);
CREATE TABLE owid_nursing_personnel_pct_1 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"nursing_personnel_pct" FLOAT -- Nursing Personnel, Pct
);
CREATE TABLE owid_nursing_personnel_pct_2 (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"nursing_personnel_pct" FLOAT -- Nursing Personnel, Pct,
"nursing_personnel_pct_low" VARCHAR -- Nursing Personnel, Pct Low,
"nursing_personnel_pct_high" VARCHAR -- Nursing Personnel, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_nutrition_governance_score (
"year" INTEGER,
"country" VARCHAR,
"sex" VARCHAR,
"nutrition_governance_score" FLOAT,
"comments" VARCHAR
);
CREATE TABLE owid_obesity_prevalence_in_non_pregnant_women_aged_15__392161a0 (
"year" INTEGER,
"country" VARCHAR,
"age_group" VARCHAR,
"wealth_decile" VARCHAR,
"wealth_quintile" VARCHAR,
"residence_area_type" VARCHAR,
"dhs_mics_subnational_regions_health_equity_monitor" VARCHAR -- Dhs Mics Subnational Regions, Health Equity Monitor,
"education_level" VARCHAR,
"obesity_prevalence_in_non_pregnant_women_aged_15_49_ye_353e79b2" FLOAT -- Obesity Prevalence In Non Pregnant Women Aged 15–49 Years, Bmi, Gt, 30, Pct,
"obesity_prevalence_in_non_pregnant_women_aged_15_49_ye_2e2efc58" FLOAT -- Obesity Prevalence In Non Pregnant Women Aged 15–49 Years, Bmi, Gt, 30, Pct Low,
"obesity_prevalence_in_non_pregnant_women_aged_15_49_ye_342407a3" FLOAT -- Obesity Prevalence In Non Pregnant Women Aged 15–49 Years, Bmi, Gt, 30, Pct High,
"comments" VARCHAR
);
CREATE TABLE owid_obesity_prevalence_in_non_pregnant_women_aged_15__aa40520a (
"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,
"obesity_prevalence_in_non_pregnant_women_aged_15_49_ye_353e79b2" FLOAT -- Obesity Prevalence In Non Pregnant Women Aged 15–49 Years, Bmi, Gt, 30, Pct,
"comments" VARCHAR
);
CREATE TABLE owid_occupational_airborne_particulates_attributable_d_62d46081 (
"year" INTEGER,
"country" VARCHAR,
"occupational_airborne_particulates_attributable_dalys__3089825c" FLOAT -- Occupational Airborne Particulates Attributable Dalys Per 100000 Capita
);
CREATE TABLE owid_occupational_airborne_particulates_attributable_d_9c33ea8d (
"year" INTEGER,
"country" VARCHAR,
"occupational_airborne_particulates_attributable_dalys_000" FLOAT -- Occupational Airborne Particulates Attributable Dalys, 000
);
CREATE TABLE owid_occupational_airborne_particulates_attributable_d_db7e210c (
"year" INTEGER,
"country" VARCHAR,
"occupational_airborne_particulates_attributable_deaths_66767124" FLOAT -- Occupational Airborne Particulates Attributable Deaths Per 100000 Capita
);
CREATE TABLE owid_occupational_airborne_particulates_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_airborne_particulates_attributable_deaths" FLOAT
);
CREATE TABLE owid_occupational_carcinogens_attributable_dalys_000_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_carcinogens_attributable_dalys_000" FLOAT -- Occupational Carcinogens Attributable Dalys, 000
);
CREATE TABLE owid_occupational_carcinogens_attributable_dalys_per_1_e9e0f854 (
"year" INTEGER,
"country" VARCHAR,
"occupational_carcinogens_attributable_dalys_per_100000_capita" FLOAT
);
CREATE TABLE owid_occupational_carcinogens_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_carcinogens_attributable_deaths" FLOAT
);
CREATE TABLE owid_occupational_carcinogens_attributable_deaths_per__a708288b (
"year" INTEGER,
"country" VARCHAR,
"occupational_carcinogens_attributable_deaths_per_100000_capita" FLOAT
);
CREATE TABLE owid_occupational_ergonomic_stressors_attributable_dal_2230c4d0 (
"year" INTEGER,
"country" VARCHAR,
"occupational_ergonomic_stressors_attributable_dalys_pe_30e5d587" FLOAT -- Occupational Ergonomic Stressors Attributable Dalys Per 100000 Capita
);
CREATE TABLE owid_occupational_ergonomic_stressors_attributable_dalys_000_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_ergonomic_stressors_attributable_dalys_000" FLOAT -- Occupational Ergonomic Stressors Attributable Dalys, 000
);
CREATE TABLE owid_occupational_ergonomic_stressors_attributable_dea_6a78f1ce (
"year" INTEGER,
"country" VARCHAR,
"occupational_ergonomic_stressors_attributable_deaths_p_81143f87" FLOAT -- Occupational Ergonomic Stressors Attributable Deaths Per 100000 Capita
);
CREATE TABLE owid_occupational_ergonomic_stressors_attributable_deaths_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_ergonomic_stressors_attributable_deaths" FLOAT
);
CREATE TABLE owid_occupational_injuries_attributable_dalys_000_1 (
"year" INTEGER,
"country" VARCHAR,
"occupational_injuries_attributable_dalys_000" FLOAT -- Occupational Injuries Attributable Dalys, 000
);
Anyone who has the link will be able to view this.