Child And Infant Mortality
Child and Infant Mortality Dataset
@kaggle.programmerrdai_child_and_infant_mortality
Child and Infant Mortality Dataset
@kaggle.programmerrdai_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}
}
CREATE TABLE causes_of_death_in_children (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_under_5_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: Under 5 (Number),
"deaths_hiv_aids_sex_both_age_under_5_number" BIGINT -- Deaths - HIV/AIDS - Sex: Both - Age: Under 5 (Number),
"deaths_meningitis_sex_both_age_under_5_number" BIGINT -- Deaths - Meningitis - Sex: Both - Age: Under 5 (Number),
"deaths_nutritional_deficiencies_sex_both_age_under_5_number" BIGINT -- Deaths - Nutritional Deficiencies - Sex: Both - Age: Under 5 (Number),
"deaths_other_neonatal_disorders_sex_both_age_under_5_number" BIGINT -- Deaths - Other Neonatal Disorders - Sex: Both - Age: Under 5 (Number),
"deaths_whooping_cough_sex_both_age_under_5_number" BIGINT -- Deaths - Whooping Cough - Sex: Both - Age: Under 5 (Number),
"deaths_lower_respiratory_infections_sex_both_age_under_3846a113" BIGINT -- Deaths - Lower Respiratory Infections - Sex: Both - Age: Under 5 (Number),
"deaths_congenital_birth_defects_sex_both_age_under_5_number" BIGINT -- Deaths - Congenital Birth Defects - Sex: Both - Age: Under 5 (Number),
"deaths_measles_sex_both_age_under_5_number" BIGINT -- Deaths - Measles - Sex: Both - Age: Under 5 (Number),
"deaths_neonatal_sepsis_and_other_neonatal_infections_s_ee817b06" BIGINT -- Deaths - Neonatal Sepsis And Other Neonatal Infections - Sex: Both - Age: Under 5 (Number),
"deaths_neonatal_encephalopathy_due_to_birth_asphyxia_a_880ee883" BIGINT -- Deaths - Neonatal Encephalopathy Due To Birth Asphyxia And Trauma - Sex: Both - Age: Under 5 (Number),
"deaths_drowning_sex_both_age_under_5_number" BIGINT -- Deaths - Drowning - Sex: Both - Age: Under 5 (Number),
"deaths_tuberculosis_sex_both_age_under_5_number" BIGINT -- Deaths - Tuberculosis - Sex: Both - Age: Under 5 (Number),
"deaths_neonatal_preterm_birth_sex_both_age_under_5_number" BIGINT -- Deaths - Neonatal Preterm Birth - Sex: Both - Age: Under 5 (Number),
"deaths_diarrheal_diseases_sex_both_age_under_5_number" BIGINT -- Deaths - Diarrheal Diseases - Sex: Both - Age: Under 5 (Number),
"deaths_neoplasms_sex_both_age_under_5_number" BIGINT -- Deaths - Neoplasms - Sex: Both - Age: Under 5 (Number),
"deaths_syphilis_sex_both_age_under_5_number" BIGINT -- Deaths - Syphilis - Sex: Both - Age: Under 5 (Number)
);CREATE TABLE child_deaths_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_all_causes_sex_both_age_7_27_days_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 7-27 Days (Number),
"deaths_all_causes_sex_both_age_1_4_years_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 1-4 Years (Number),
"deaths_all_causes_sex_both_age_0_6_days_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 0-6 Days (Number),
"deaths_all_causes_sex_both_age_28_364_days_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 28-364 Days (Number)
);CREATE TABLE child_deaths_from_malaria_number (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_under_5_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: Under 5 (Number)
);CREATE TABLE child_deaths_igme_data (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"number_of_under_five_deaths" BIGINT
);CREATE TABLE child_mortality_1990_vs_latest_slope (
"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),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE child_mortality_around_the_world (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"estimates_1950_2020_annually_interpolated_demographic__e2463e91" DOUBLE -- Estimates, 1950 - 2020: Annually Interpolated Demographic Indicators - Under-five Mortality (deaths Under Age 5 Per 1,000 Live Births)
);CREATE TABLE child_mortality_by_income_level_of_country (
"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)
);CREATE TABLE child_mortality_by_sex (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"mortality_rate_under_5_female_per_1_000_live_births" DOUBLE -- Mortality Rate, Under-5, Female (per 1,000 Live Births),
"mortality_rate_under_5_male_per_1_000_live_births" DOUBLE -- Mortality Rate, Under-5, Male (per 1,000 Live Births),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE child_mortality_igme (
"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)
);CREATE TABLE child_mortality_vs_teenage_pregnancy (
"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),
"teenage_mothers_of_women_ages_15_19_who_have_had_child_af2cb532" DOUBLE -- Teenage Mothers (% Of Women Ages 15-19 Who Have Had Children Or Are Currently Pregnant),
"continent" VARCHAR
);CREATE TABLE children_living_with_hiv (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"children_0_14_living_with_hiv" BIGINT -- Children (0-14) Living With HIV
);CREATE TABLE children_sleeping_under_treated_bednet (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"use_of_insecticide_treated_bed_nets_of_under_5_population" DOUBLE -- Use Of Insecticide-treated Bed Nets (% Of Under-5 Population)
);CREATE TABLE children_woman_death_vs_survival (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"children_that_died_before_5_years_of_age_per_woman_bas_eb19b0fc" DOUBLE -- Children That Died Before 5 Years Of Age Per Woman (based On Gapminder (2017)),
"children_that_survived_past_5_years_of_age_per_woman_b_38e7160b" DOUBLE -- Children That Survived Past 5 Years Of Age Per Woman (based On Gapminder (2017))
);CREATE TABLE correlation_between_child_mortality_and_mean_years_of__9eae196f (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"estimates_1950_2020_annually_interpolated_demographic__e2463e91" DOUBLE -- Estimates, 1950 - 2020: Annually Interpolated Demographic Indicators - Under-five Mortality (deaths Under Age 5 Per 1,000 Live Births),
"mean_years_of_schooling_women_in_reproductive_age_15_t_7cacd8ef" DOUBLE -- Mean Years Of Schooling, Women (in Reproductive Age 15 To 49) (Our World In Data (2017)),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE death_rates_from_pneumonia_and_other_lower_respiratory_af54c28a (
"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),
"gdp_per_capita_ppp_current_international" DOUBLE -- GDP Per Capita, PPP (current International $),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE deaths_from_diarrheal_diseases_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_under_5_number" BIGINT -- Deaths - Diarrheal Diseases - Sex: Both - Age: Under 5 (Number),
"deaths_diarrheal_diseases_sex_both_age_70_years_number" BIGINT -- Deaths - Diarrheal Diseases - Sex: Both - Age: 70+ Years (Number),
"deaths_diarrheal_diseases_sex_both_age_50_69_years_number" BIGINT -- Deaths - Diarrheal Diseases - Sex: Both - Age: 50-69 Years (Number),
"deaths_diarrheal_diseases_sex_both_age_15_49_years_number" BIGINT -- Deaths - Diarrheal Diseases - Sex: Both - Age: 15-49 Years (Number),
"deaths_diarrheal_diseases_sex_both_age_5_14_years_number" BIGINT -- Deaths - Diarrheal Diseases - Sex: Both - Age: 5-14 Years (Number)
);CREATE TABLE deaths_from_preterm_birth_complications (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_neonatal_preterm_birth_sex_both_age_under_5_rate" DOUBLE -- Deaths - Neonatal Preterm Birth - Sex: Both - Age: Under 5 (Rate)
);CREATE TABLE diarrheal_death_rates_children_vs_gdp_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_under_5_rate" DOUBLE -- Deaths - Diarrheal Diseases - Sex: Both - Age: Under 5 (Rate),
"gdp_per_capita_ppp_constant_2017_international" DOUBLE -- GDP Per Capita, PPP (constant 2017 International $),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE exclusive_breastfeeding (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"exclusive_breastfeeding_percent" DOUBLE
);CREATE TABLE global_child_mortality_timeseries (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_surviving_first_5_years_of_life_based_on_gapmind_979632ca" DOUBLE -- Share Surviving First 5 Years Of Life (based On Gapminder And World Bank (2019)),
"share_dying_in_first_5_years_based_on_gapminder_and_wo_7b6c49ec" DOUBLE -- Share Dying In First 5 Years (based On Gapminder And World Bank (2019))
);CREATE TABLE infant_death_rates_by_cause_by_sex (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"causes_of_death_for_infant_boys_1_year_ihme" DOUBLE -- Causes Of Death For Infant Boys (\u003c1 Year) (IHME),
"causes_of_death_for_infant_girls_1_year_ihme" DOUBLE -- Causes Of Death For Infant Girls (\u003c1 Year) (IHME)
);CREATE TABLE malaria_deaths_by_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_under_5_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: Under 5 (Number),
"deaths_malaria_sex_both_age_70_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 70+ Years (Number),
"deaths_malaria_sex_both_age_5_14_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 5-14 Years (Number),
"deaths_malaria_sex_both_age_15_49_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 15-49 Years (Number),
"deaths_malaria_sex_both_age_50_69_years_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 50-69 Years (Number)
);CREATE TABLE neonatal_deaths_by_cause (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_0_27_days_number" BIGINT -- Deaths - Diarrheal Diseases - Sex: Both - Age: 0-27 Days (Number),
"deaths_congenital_birth_defects_sex_both_age_0_27_days_number" BIGINT -- Deaths - Congenital Birth Defects - Sex: Both - Age: 0-27 Days (Number),
"deaths_hemolytic_disease_and_other_neonatal_jaundice_s_31394922" BIGINT -- Deaths - Hemolytic Disease And Other Neonatal Jaundice - Sex: Both - Age: 0-27 Days (Number),
"deaths_malaria_sex_both_age_0_27_days_number" BIGINT -- Deaths - Malaria - Sex: Both - Age: 0-27 Days (Number),
"deaths_lower_respiratory_infections_sex_both_age_0_27__8cc8341e" BIGINT -- Deaths - Lower Respiratory Infections - Sex: Both - Age: 0-27 Days (Number),
"deaths_meningitis_sex_both_age_0_27_days_number" BIGINT -- Deaths - Meningitis - Sex: Both - Age: 0-27 Days (Number),
"deaths_neonatal_encephalopathy_due_to_birth_asphyxia_a_84daa01f" BIGINT -- Deaths - Neonatal Encephalopathy Due To Birth Asphyxia And Trauma - Sex: Both - Age: 0-27 Days (Number),
"deaths_neonatal_preterm_birth_sex_both_age_0_27_days_number" BIGINT -- Deaths - Neonatal Preterm Birth - Sex: Both - Age: 0-27 Days (Number),
"deaths_tetanus_sex_both_age_0_27_days_number" BIGINT -- Deaths - Tetanus - Sex: Both - Age: 0-27 Days (Number),
"deaths_other_unspecified_infectious_diseases_sex_both__5862b103" BIGINT -- Deaths - Other Unspecified Infectious Diseases - Sex: Both - Age: 0-27 Days (Number),
"deaths_other_neonatal_disorders_sex_both_age_0_27_days_number" BIGINT -- Deaths - Other Neonatal Disorders - Sex: Both - Age: 0-27 Days (Number),
"deaths_neonatal_sepsis_and_other_neonatal_infections_s_14da482e" BIGINT -- Deaths - Neonatal Sepsis And Other Neonatal Infections - Sex: Both - Age: 0-27 Days (Number),
"deaths_sexually_transmitted_infections_excluding_hiv_s_39ce6308" BIGINT -- Deaths - Sexually Transmitted Infections Excluding HIV - Sex: Both - Age: 0-27 Days (Number)
);CREATE TABLE number_of_children_newly_infected_with_hiv (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"children_ages_0_14_newly_infected_with_hiv" BIGINT -- Children (ages 0-14) Newly Infected With HIV
);CREATE TABLE number_of_children_orphaned_from_aids (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"aids_orphans_0_17_estimate" DOUBLE -- AIDS Orphans - 0-17 Estimate
);Anyone who has the link will be able to view this.