Life Expectancy
Life Expectancy DataSet
@kaggle.programmerrdai_life_expectancy
Life Expectancy DataSet
@kaggle.programmerrdai_life_expectancy
Life expectancy is a statistical measure of the average time an organism is expected to live, based on the year of its birth, its current age, and other demographic factors like sex. The most commonly used measure is life expectancy at birth, which can be defined in two ways. Wikipedia
CREATE TABLE expected_years_of_living_with_disability_or_disease_burden (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"years_lived_with_disability" DOUBLE
);CREATE TABLE healthy_life_expectancy_and_years_lived_with_disability (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"healthy_life_expectancy_ihme" DOUBLE -- Healthy Life Expectancy (IHME),
"years_lived_with_disability" DOUBLE
);CREATE TABLE life_expectancy_at_age_10 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"e10_united_nations_population_division_and_human_morta_3466d7ab" DOUBLE -- E10 (United Nations Population Division And Human Mortality Database (2015))
);CREATE TABLE life_expectancy_at_birth_including_the_un_projections (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"estimates_1950_2020_annually_interpolated_demographic__6ddcf4ba" DOUBLE -- Estimates, 1950 - 2020: Annually Interpolated Demographic Indicators - Life Expectancy At Birth, Both Sexes Combined (years),
"medium_fertility_variant_2020_2099_annually_interpolat_bf3d8b62" DOUBLE -- Medium Fertility Variant, 2020 - 2099: Annually Interpolated Demographic Indicators - Life Expectancy At Birth, Both Sexes Combined (years)
);CREATE TABLE life_expectancy_of_women_vs_life_expectancy_of_women (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"estimates_1950_2020_annually_interpolated_demographic__62fc7aa6" DOUBLE -- Estimates, 1950 - 2020: Annually Interpolated Demographic Indicators - Life Expectancy At Birth, Females (years),
"estimates_1950_2020_annually_interpolated_demographic__0c1932d6" DOUBLE -- Estimates, 1950 - 2020: Annually Interpolated Demographic Indicators - Life Expectancy At Birth, Males (years),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE life_expectancy_vs_healthcare_expenditure (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"life_expectancy_at_birth_total_years" DOUBLE -- Life Expectancy At Birth, Total (years),
"health_expenditure_per_capita_ppp_constant_2011_international" DOUBLE -- Health Expenditure Per Capita, PPP (constant 2011 International $),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);CREATE TABLE median_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"un_population_division_median_age_2017" DOUBLE -- UN Population Division (Median Age) (2017)
);CREATE TABLE men_survival_to_age_65 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"survival_to_age_65_male_of_cohort" DOUBLE -- Survival To Age 65, Male (% Of Cohort)
);CREATE TABLE number_of_deaths_by_age_group (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"deaths_all_causes_sex_both_age_under_5_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: Under 5 (Number),
"deaths_all_causes_sex_both_age_70_years_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 70+ Years (Number),
"deaths_all_causes_sex_both_age_50_69_years_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 50-69 Years (Number),
"deaths_all_causes_sex_both_age_5_14_years_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 5-14 Years (Number),
"deaths_all_causes_sex_both_age_15_49_years_number" BIGINT -- Deaths - All Causes - Sex: Both - Age: 15-49 Years (Number)
);CREATE TABLE women_survival_to_age_65 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"survival_to_age_65_female_of_cohort" DOUBLE -- Survival To Age 65, Female (% Of Cohort)
);CREATE TABLE years_lived_with_disability_vs_health_expenditure_per_capita (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"years_lived_with_disability" DOUBLE,
"health_expenditure_per_capita_ppp_constant_2011_international" DOUBLE -- Health Expenditure Per Capita, PPP (constant 2011 International $),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);Anyone who has the link will be able to view this.