Life Expectancy
Life Expectancy DataSet
@kaggle.programmerrdai_life_expectancy
Life Expectancy DataSet
@kaggle.programmerrdai_life_expectancy
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,
"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
);
CREATE TABLE life_expectancy_at_birth_including_the_un_projections (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"estimates_1950_2020_annually_interpolated_demographic__6ddcf4ba" DOUBLE,
"medium_fertility_variant_2020_2099_annually_interpolat_bf3d8b62" DOUBLE
);
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__0c1932d6" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE life_expectancy_vs_healthcare_expenditure (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"life_expectancy_at_birth_total_years" DOUBLE,
"health_expenditure_per_capita_ppp_constant_2011_international" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE median_age (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"un_population_division_median_age_2017" DOUBLE
);
CREATE TABLE men_survival_to_age_65 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"survival_to_age_65_male_of_cohort" DOUBLE
);
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_70_years_number" BIGINT,
"deaths_all_causes_sex_both_age_50_69_years_number" BIGINT,
"deaths_all_causes_sex_both_age_5_14_years_number" BIGINT,
"deaths_all_causes_sex_both_age_15_49_years_number" BIGINT
);
CREATE TABLE women_survival_to_age_65 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"survival_to_age_65_female_of_cohort" DOUBLE
);
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,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
Anyone who has the link will be able to view this.