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
CREATE TABLE causes_of_death_in_children (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_under_5_number" BIGINT,
"deaths_hiv_aids_sex_both_age_under_5_number" BIGINT,
"deaths_meningitis_sex_both_age_under_5_number" BIGINT,
"deaths_nutritional_deficiencies_sex_both_age_under_5_number" BIGINT,
"deaths_other_neonatal_disorders_sex_both_age_under_5_number" BIGINT,
"deaths_whooping_cough_sex_both_age_under_5_number" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_under_3846a113" BIGINT,
"deaths_congenital_birth_defects_sex_both_age_under_5_number" BIGINT,
"deaths_measles_sex_both_age_under_5_number" BIGINT,
"deaths_neonatal_sepsis_and_other_neonatal_infections_s_ee817b06" BIGINT,
"deaths_neonatal_encephalopathy_due_to_birth_asphyxia_a_880ee883" BIGINT,
"deaths_drowning_sex_both_age_under_5_number" BIGINT,
"deaths_tuberculosis_sex_both_age_under_5_number" BIGINT,
"deaths_neonatal_preterm_birth_sex_both_age_under_5_number" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_under_5_number" BIGINT,
"deaths_neoplasms_sex_both_age_under_5_number" BIGINT,
"deaths_syphilis_sex_both_age_under_5_number" BIGINT
);
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_1_4_years_number" BIGINT,
"deaths_all_causes_sex_both_age_0_6_days_number" BIGINT,
"deaths_all_causes_sex_both_age_28_364_days_number" BIGINT
);
CREATE TABLE child_deaths_from_malaria_number (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_malaria_sex_both_age_under_5_number" BIGINT
);
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,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE child_mortality_around_the_world (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"estimates_1950_2020_annually_interpolated_demographic__e2463e91" DOUBLE
);
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
);
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_male_per_1_000_live_births" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE child_mortality_igme (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"mortality_rate_under_5_per_1_000_live_births" DOUBLE
);
CREATE TABLE child_mortality_vs_teenage_pregnancy (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"mortality_rate_under_5_per_1_000_live_births" DOUBLE,
"teenage_mothers_of_women_ages_15_19_who_have_had_child_af2cb532" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE children_living_with_hiv (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"children_0_14_living_with_hiv" BIGINT
);
CREATE TABLE children_sleeping_under_treated_bednet (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"use_of_insecticide_treated_bed_nets_of_under_5_population" DOUBLE
);
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_survived_past_5_years_of_age_per_woman_b_38e7160b" DOUBLE
);
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,
"mean_years_of_schooling_women_in_reproductive_age_15_t_7cacd8ef" DOUBLE,
"population_historical_estimates" DOUBLE,
"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,
"gdp_per_capita_ppp_current_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"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_70_years_number" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_50_69_years_number" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_15_49_years_number" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_5_14_years_number" BIGINT
);
CREATE TABLE deaths_from_preterm_birth_complications (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_neonatal_preterm_birth_sex_both_age_under_5_rate" DOUBLE
);
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,
"gdp_per_capita_ppp_constant_2017_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"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_dying_in_first_5_years_based_on_gapminder_and_wo_7b6c49ec" DOUBLE
);
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_girls_1_year_ihme" DOUBLE
);
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_70_years_number" BIGINT,
"deaths_malaria_sex_both_age_5_14_years_number" BIGINT,
"deaths_malaria_sex_both_age_15_49_years_number" BIGINT,
"deaths_malaria_sex_both_age_50_69_years_number" BIGINT
);
CREATE TABLE neonatal_deaths_by_cause (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_diarrheal_diseases_sex_both_age_0_27_days_number" BIGINT,
"deaths_congenital_birth_defects_sex_both_age_0_27_days_number" BIGINT,
"deaths_hemolytic_disease_and_other_neonatal_jaundice_s_31394922" BIGINT,
"deaths_malaria_sex_both_age_0_27_days_number" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_0_27__8cc8341e" BIGINT,
"deaths_meningitis_sex_both_age_0_27_days_number" BIGINT,
"deaths_neonatal_encephalopathy_due_to_birth_asphyxia_a_84daa01f" BIGINT,
"deaths_neonatal_preterm_birth_sex_both_age_0_27_days_number" BIGINT,
"deaths_tetanus_sex_both_age_0_27_days_number" BIGINT,
"deaths_other_unspecified_infectious_diseases_sex_both__5862b103" BIGINT,
"deaths_other_neonatal_disorders_sex_both_age_0_27_days_number" BIGINT,
"deaths_neonatal_sepsis_and_other_neonatal_infections_s_14da482e" BIGINT,
"deaths_sexually_transmitted_infections_excluding_hiv_s_39ce6308" BIGINT
);
CREATE TABLE number_of_children_newly_infected_with_hiv (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"children_ages_0_14_newly_infected_with_hiv" BIGINT
);
CREATE TABLE number_of_children_orphaned_from_aids (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"aids_orphans_0_17_estimate" DOUBLE
);
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_no_access_to_hand_bf68c2ef" BIGINT,
"deaths_cause_diarrheal_diseases_risk_suboptimal_breast_ef680568" BIGINT,
"deaths_cause_diarrheal_diseases_risk_unsafe_water_sour_364b1834" BIGINT,
"deaths_cause_diarrheal_diseases_risk_zinc_deficiency_s_14d16cda" BIGINT,
"deaths_cause_diarrheal_diseases_risk_low_birth_weight__d488618d" BIGINT,
"deaths_cause_diarrheal_diseases_risk_short_gestation_s_e94c3322" BIGINT,
"deaths_cause_diarrheal_diseases_risk_unsafe_sanitation_dcefff8f" BIGINT,
"deaths_cause_diarrheal_diseases_risk_vitamin_a_deficie_d721d620" BIGINT
);
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_children_aged_0_14_children_0_14_estimate" DOUBLE
);
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,
"current_health_expenditure_per_capita_ppp_current_inte_a216693f" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
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_50_69_60f44770" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_15_49_9327ec61" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_5_14__15742278" BIGINT,
"deaths_lower_respiratory_infections_sex_both_age_70_ye_924401ba" BIGINT
);
CREATE TABLE pneumonia_careseeking (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"percentage_of_children_under_5_with_symptoms_of_pneumo_15fa99a3" DOUBLE
);
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
);
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_w_8bcb31fa" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_low_bir_92ca2c2e" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_no_acce_4cca3d6f" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_secondh_5806f820" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_child_u_d7eef78b" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_househo_22ca5aec" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_non_exc_6d6a73c0" BIGINT,
"deaths_cause_lower_respiratory_infections_risk_short_g_7a7064b7" BIGINT
);
CREATE TABLE poverty_and_child_mortality (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"mortality_rate_under_5_per_1_000_live_births" DOUBLE,
"n__1_90_per_day_share_of_population_below_poverty_line" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE youth_mortality_rate (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"youth_mortality_rate_un_igme_2021" DOUBLE
);
Anyone who has the link will be able to view this.