Name: Child And Infant Mortality
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Child And Infant Mortality

One in every 100 children dies before completing one year of life. Around 68 percent of infant mortality is attributed to deaths of children before completing 1 month.
15,000 children die every day – Child mortality is an everyday tragedy of enormous scale that rarely makes the headlines
Child mortality rates have declined in all world regions, but the world is not on track to reach the Sustainable Development Goal for child mortality
Before the Modern Revolution child mortality was very high in all societies that we have knowledge of – a quarter of all children died in the first year of life, almost half died before reaching the end of puberty
Over the last two centuries all countries in the world have made very rapid progress against child mortality. From 1800 to 1950 global mortality has halved from around 43% to 22.5%. Since 1950 the mortality rate has declined five-fold to 4.5% in 2015. All countries in the world have benefitted from this progress
In the past it was very common for parents to see children die, because both, child mortality rates and fertility rates were very high. In Europe in the mid 18th century parents lost on average between 3 and 4 of their children
Based on this overview we are asking where the world is today – where are children dying and what are they dying from?

5.4 million children died in 2017 – Where did these children die?
Pneumonia is the most common cause of death, preterm births and neonatal disorders is second, and diarrheal diseases are third – What are children today dying from?
This is the basis for answering the question what can we do to make further progress against child mortality? We will extend this entry over the course of 2020.

@article{owidchildmortality,
author = {Max Roser, Hannah Ritchie and Bernadeta Dadonaite},
title = {Child and Infant Mortality},
journal = {Our World in Data},
year = {2013},
note = {https://ourworldindata.org/child-mortality}
}

Tables

Number Of Deaths From Diarrheal Diseases By Risk Facto 3c0f063f

@kaggle.programmerrdai_child_and_infant_mortality.number_of_deaths_from_diarrheal_diseases_by_risk_facto_3c0f063f

145.71 kB
6,840 rows
12 columns

CREATE TABLE number_of_deaths_from_diarrheal_diseases_by_risk_facto_3c0f063f (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_diarrheal_diseases_risk_child_growth_fail_81077e0b" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Child Growth Failure - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_no_access_to_hand_bf68c2ef" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: No Access To Handwashing Facility - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_suboptimal_breast_ef680568" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Suboptimal Breastfeeding - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_unsafe_water_sour_364b1834" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Unsafe Water Source - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_zinc_deficiency_s_14d16cda" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Zinc Deficiency - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_low_birth_weight__d488618d" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Low Birth Weight - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_short_gestation_s_e94c3322" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Short Gestation - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_unsafe_sanitation_dcefff8f" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Unsafe Sanitation - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_diarrheal_diseases_risk_vitamin_a_deficie_d721d620" BIGINT  -- Deaths - Cause: Diarrheal Diseases - Risk: Vitamin A Deficiency - Sex: Both - Age: Under 5 (Number)
);

Number Of New Hiv Child Infections Vs Number Of Infect Aeb2f163

@kaggle.programmerrdai_child_and_infant_mortality.number_of_new_hiv_child_infections_vs_number_of_infect_aeb2f163

44.25 kB
2,970 rows
5 columns

CREATE TABLE number_of_new_hiv_child_infections_vs_number_of_infect_aeb2f163 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "new_hiv_infections_averted_due_to_pmtct_estimate" DOUBLE  -- New HIV Infections Averted Due To PMTCT - Estimate,
  "new_hiv_infections_children_aged_0_14_children_0_14_estimate" DOUBLE  -- New HIV Infections - Children (aged 0-14) - Children (0-14) Estimate
);

Per Capita Total Expenditure On Health Vs Child Mortality

@kaggle.programmerrdai_child_and_infant_mortality.per_capita_total_expenditure_on_health_vs_child_mortality

478.84 kB
56,108 rows
7 columns

CREATE TABLE per_capita_total_expenditure_on_health_vs_child_mortality (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "mortality_rate_under_5_per_1_000_live_births" DOUBLE  -- Mortality Rate, Under-5 (per 1,000 Live Births),
  "current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE  -- Current Health Expenditure Per Capita, PPP (current International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Pneumonia And Lower Respiratory Diseases Deaths

@kaggle.programmerrdai_child_and_infant_mortality.pneumonia_and_lower_respiratory_diseases_deaths

117.59 kB
6,840 rows
8 columns

CREATE TABLE pneumonia_and_lower_respiratory_diseases_deaths (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_lower_respiratory_infections_sex_both_age_under_3846a113" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: Under 5 (Number),
  "deaths_lower_respiratory_infections_sex_both_age_50_69_60f44770" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 50-69 Years (Number),
  "deaths_lower_respiratory_infections_sex_both_age_15_49_9327ec61" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 15-49 Years (Number),
  "deaths_lower_respiratory_infections_sex_both_age_5_14__15742278" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 5-14 Years (Number),
  "deaths_lower_respiratory_infections_sex_both_age_70_ye_924401ba" BIGINT  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 70+ Years (Number)
);

Pneumonia Careseeking

@kaggle.programmerrdai_child_and_infant_mortality.pneumonia_careseeking

8.06 kB
421 rows
4 columns

CREATE TABLE pneumonia_careseeking (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_children_under_5_with_symptoms_of_pneumo_15fa99a3" DOUBLE  -- Percentage Of Children Under 5 With Symptoms Of Pneumonia Taken For Care To A Health Provider
);

Pneumonia Death Rates In Children Under 5

@kaggle.programmerrdai_child_and_infant_mortality.pneumonia_death_rates_in_children_under_5

74.31 kB
6,840 rows
4 columns

CREATE TABLE pneumonia_death_rates_in_children_under_5 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_lower_respiratory_infections_sex_both_age_under_5_rate" DOUBLE  -- Deaths - Lower Respiratory Infections - Sex: Both - Age: Under 5 (Rate)
);

Pneumonia Risk Factors

@kaggle.programmerrdai_child_and_infant_mortality.pneumonia_risk_factors

162.34 kB
6,840 rows
12 columns

CREATE TABLE pneumonia_risk_factors (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "deaths_cause_lower_respiratory_infections_risk_child_s_0229f330" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Child Stunting - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_child_w_8bcb31fa" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Child Wasting - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_low_bir_92ca2c2e" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Low Birth Weight - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_no_acce_4cca3d6f" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: No Access To Handwashing Facility - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_secondh_5806f820" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Secondhand Smoke - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_child_u_d7eef78b" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Child Underweight - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_househo_22ca5aec" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Household Air Pollution From Solid Fuels - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_non_exc_6d6a73c0" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Non-exclusive Breastfeeding - Sex: Both - Age: Under 5 (Number),
  "deaths_cause_lower_respiratory_infections_risk_short_g_7a7064b7" BIGINT  -- Deaths - Cause: Lower Respiratory Infections - Risk: Short Gestation - Sex: Both - Age: Under 5 (Number)
);

Poverty And Child Mortality

@kaggle.programmerrdai_child_and_infant_mortality.poverty_and_child_mortality

507.84 kB
56,536 rows
7 columns

CREATE TABLE poverty_and_child_mortality (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "mortality_rate_under_5_per_1_000_live_births" DOUBLE  -- Mortality Rate, Under-5 (per 1,000 Live Births),
  "n__1_90_per_day_share_of_population_below_poverty_line" DOUBLE  -- $1.90 Per Day - Share Of Population Below Poverty Line,
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Youth Mortality Rate

@kaggle.programmerrdai_child_and_infant_mortality.youth_mortality_rate

34.46 kB
9,979 rows
4 columns

CREATE TABLE youth_mortality_rate (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "youth_mortality_rate_un_igme_2021" DOUBLE  -- Youth Mortality Rate (UN IGME (2021))
);