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
);
Anyone who has the link will be able to view this.