Analysis of ‘Life Expectancy vs GDP, 1950-2018’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/luxoloshilofunde/life-expectancy-vs-gdp-19502018 on 13 February 2022.

--- Dataset description provided by original source is as follows ---

Context

Life expectancy at birth is defined as the average number of years that a newborn could expect to live if he or she were to pass through life subject to the age-specific mortality rates of a given period. The years are from 1950 to 2018.

Content

For regional- and global-level data pre-1950, data from a study by Riley was used, which draws from over 700 sources to estimate life expectancy at birth from 1800 to 2001.

Riley estimated life expectancy before 1800, which he calls "the pre-health transition period". "Health transitions began in different countries in different periods, as early as the 1770s in Denmark and as late as the 1970s in some countries of sub-Saharan Africa". As such, for the sake of consistency, we have assigned the period before the health transition to the year 1770. "The life expectancy values employed are averages of estimates for the period before the beginning of the transitions for countries within that region. ... This period has presumably the weakest basis, the largest margin of error, and the simplest method of deriving an estimate."

For country-level data pre-1950, Clio Infra's dataset was used, compiled by Zijdeman and Ribeira da Silva (2015).

For country-, regional- and global-level data post-1950, data published by the United Nations Population Division was used, since they are updated every year. This is possible because Riley writes that "for 1950-2001, I have drawn life expectancy estimates chiefly from various sources provided by the United Nations, the World Bank’s World Development Indicators, and the Human Mortality Database".

For the Americas from 1950-2015, the population-weighted average of Northern America and Latin America and the Caribbean was taken, using UN Population Division estimates of population size.

Acknowledgements

Life expectancy:

Data publisher's source: https://www.lifetable.de/RileyBib.pdf Data published by: James C. Riley (2005) – Estimates of Regional and Global Life Expectancy, 1800–2001. Issue Population and Development Review. Population and Development Review. Volume 31, Issue 3, pages 537–543, September 2005., Zijdeman, Richard; Ribeira da Silva, Filipa, 2015, "Life Expectancy at Birth (Total)", http://hdl.handle.net/10622/LKYT53, IISH Dataverse, V1, and UN Population Division (2019) Link: https://datasets.socialhistory.org/dataset.xhtml?persistentId=hdl:10622/LKYT53, http://onlinelibrary.wiley.com/doi/10.1111/j.1728-4457.2005.00083.x/epdf, https://population.un.org/wpp/Download/Standard/Population/ Dataset: https://ourworldindata.org/life-expectancy

GDP per capita:

Data publisher's source: The Maddison Project Database is based on the work of many researchers that have produced estimates of economic growth for individual countries. Data published by: Bolt, Jutta and Jan Luiten van Zanden (2020), “Maddison style estimates of the evolution of the world economy. A new 2020 update”. Link: https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020 Dataset: https://ourworldindata.org/life-expectancy

Inspiration

The life expectancy vs GDP per capita analysis.

--- Original source retains full ownership of the source dataset ---

Historical dataset showing Indonesia life expectancy by year from 1950 to 2025.

Historical dataset showing Central America life expectancy by year from 1950 to 2025.

Historical dataset showing Brazil life expectancy by year from 1950 to 2025.

This database includes a comprehensive set of estimates on lifespan inequality and polarization for 258 countries and areas for the period 1950–2021. These extensive series on the distribution of lifespans provide access to crucial information for researchers, policy-makers, and the general public, thus representing a fundamental step towards a better understanding of health differences within and between nations.

Context

The United States Census Bureau’s international dataset provides estimates of country populations since 1950 and projections through 2050. Specifically, the dataset includes midyear population figures broken down by age and gender assignment at birth. Additionally, time-series data is provided for attributes including fertility rates, birth rates, death rates, and migration rates.

Querying BigQuery tables

You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.census_bureau_international.

Sample Query 1

What countries have the longest life expectancy? In this query, 2016 census information is retrieved by joining the mortality_life_expectancy and country_names_area tables for countries larger than 25,000 km2. Without the size constraint, Monaco is the top result with an average life expectancy of over 89 years!

standardSQL

SELECT age.country_name, age.life_expectancy, size.country_area FROM ( SELECT country_name, life_expectancy FROM bigquery-public-data.census_bureau_international.mortality_life_expectancy WHERE year = 2016) age INNER JOIN ( SELECT country_name, country_area FROM bigquery-public-data.census_bureau_international.country_names_area where country_area > 25000) size ON age.country_name = size.country_name ORDER BY 2 DESC /* Limit removed for Data Studio Visualization */ LIMIT 10

Sample Query 2

Which countries have the largest proportion of their population under 25? Over 40% of the world’s population is under 25 and greater than 50% of the world’s population is under 30! This query retrieves the countries with the largest proportion of young people by joining the age-specific population table with the midyear (total) population table.

standardSQL

SELECT age.country_name, SUM(age.population) AS under_25, pop.midyear_population AS total, ROUND((SUM(age.population) / pop.midyear_population) * 100,2) AS pct_under_25 FROM ( SELECT country_name, population, country_code FROM bigquery-public-data.census_bureau_international.midyear_population_agespecific WHERE year =2017 AND age < 25) age INNER JOIN ( SELECT midyear_population, country_code FROM bigquery-public-data.census_bureau_international.midyear_population WHERE year = 2017) pop ON age.country_code = pop.country_code GROUP BY 1, 3 ORDER BY 4 DESC /* Remove limit for visualization*/ LIMIT 10

Sample Query 3

The International Census dataset contains growth information in the form of birth rates, death rates, and migration rates. Net migration is the net number of migrants per 1,000 population, an important component of total population and one that often drives the work of the United Nations Refugee Agency. This query joins the growth rate table with the area table to retrieve 2017 data for countries greater than 500 km2.

SELECT growth.country_name, growth.net_migration, CAST(area.country_area AS INT64) AS country_area FROM ( SELECT country_name, net_migration, country_code FROM bigquery-public-data.census_bureau_international.birth_death_growth_rates WHERE year = 2017) growth INNER JOIN ( SELECT country_area, country_code FROM bigquery-public-data.census_bureau_international.country_names_area

Update frequency

Historic (none)

Dataset source

United States Census Bureau

Terms of use: This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

See the GCP Marketplace listing for more details and sample queries: https://console.cloud.google.com/marketplace/details/united-states-census-bureau/international-census-data

Historical dataset showing Poland life expectancy by year from 1950 to 2025.

Historical dataset showing Antigua and Barbuda life expectancy by year from 1950 to 2025.

Mexico Life Expectancy at Birth: Male data was reported at 72.150 Year in 2018. This records an increase from the previous number of 72.030 Year for 2017. Mexico Life Expectancy at Birth: Male data is updated yearly, averaging 65.810 Year from Dec 1950 (Median) to 2018, with 69 observations. The data reached an all-time high of 72.870 Year in 2006 and a record low of 45.530 Year in 1951. Mexico Life Expectancy at Birth: Male data remains active status in CEIC and is reported by National Population Council. The data is categorized under Global Database’s Mexico – Table MX.G004: Life Expectancy at Birth.

Historical dataset showing U.S. life expectancy by year from 1950 to 2025.

This table contains the period survival tables (per period of 1 year and 5 years) by sex and age for the population of the Netherlands. The table shows how many boys or girls from a group of 100,000 newborns will reach the age of 0, 1, 2, etc. on December 31 of the year of observation. It is also possible to see how old these children will be on average. The following breakdowns are possible: - Mortality probability by sex and age; - Living (table population) by sex and age; - Deaths (table population) by sex and age; - Life expectancy by sex and age. Data available from: - one-year periods: from 1950 - five-year periods: from 1861 to 1866. Status of the figures: All figures included in the table are final. Changes as of June 16, 2023: Final figures for 2022 have been added. When will new numbers come out? The figures for 2023 will be published in the second quarter of 2024.

The dataset presents information on life expectancy in selected countries in 10-year periods. The list covers the years 1950-2020. The dataset also includes GDP values ​​per capita in a given country in the years studied.

Raw data sets for life tables in Brazil between 1950-2020, originally from the GHDx website.

Historical dataset showing Sao Tome and Principe life expectancy by year from 1950 to 2025.

In 1870, the average person born in the Philippines could expect to live to just under the age of 31 years old. This figure would remain unchanged until the early 1900s, when life expectancy would fall to just over 25 years in the Philippine-American War of 1899-1902, as disruptions in food supply and healthcare would result in the loss of several hundred thousand Filipinos to famine and disease. This drop would be accompanied by another drop in the 1920s as the Spanish Flu would ravage the country. However, life expectancy would quickly recover and begin to rise under the United States military administration of the island, as investment by the American government would result in significant expansion in access to nutrition and healthcare. As a result, life expectancy would rise to over 41 years by 1940.

Life expectancy in the Philippines would decline once more in the 1940s, however, in the 1941 invasion and subsequent occupation of the island nation by the Empire of Japan in the Second World War, in which famine and causalities of war would result in the death of an estimated 500,000 Filipinos. Despite significant destruction in the Second World War, and an ending to the bulk of American investment in the country following its independence from the U.S. in 1946, life expectancy in the Philippines would quickly rise in the post-war years as the country would modernize; almost doubling in the two decades between 1945 and 1965 alone. It then plateaued throughout the 1970s and 1980s, during the authoritarian regime of Ferdinand Marcos, before the People Power Revolution in 1986 returned democracy to the country, and living standards began to improve once more. Life expectancy has also increased since this time, and in 2020, it is estimated that the average person born in the Philippines can expect to live to just over the age of 71 years old.

Historical dataset showing Iceland life expectancy by year from 1950 to 2025.

Context

The United States Census Bureau’s International Dataset provides estimates of country populations since 1950 and projections through 2050.

Content

The U.S. Census Bureau provides estimates and projections for countries and areas that are recognized by the U.S. Department of State that have a population of at least 5,000. Specifically, the data set includes midyear population figures broken down by age and gender assignment at birth. Additionally, they provide time-series data for attributes including fertility rates, birth rates, death rates, and migration rates.

Fork this kernel to get started.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:census_bureau_international

https://cloud.google.com/bigquery/public-data/international-census

Dataset Source: www.census.gov

This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source -http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by Steve Richey from Unsplash.

Inspiration

What countries have the longest life expectancy?

Which countries have the largest proportion of their population under 25?

Which countries are seeing the largest net migration?

Absolute β convergence for life expectancy at birth across countries, 1950–55, 2010–15.

Historical dataset showing Kiribati life expectancy by year from 1950 to 2025.

This table includes key figures on mortality in the Dutch population broken down by gender. The figures include totals and ratios of deceased persons, infant mortality, mortality in babies younger than 4 weeks and perinatal mortality (after a gestation period of 24 weeks or more and after a gestation period of 28 weeks or more). The table also presents figures on life expectancy at birth and average age at death. For additional information on Mortality the reader is referred to the Dutch tables. Data available from: 1950 Status of the figures: All data recorded in this publication are final data. Changes as of 2 August 2022: - Data of 2021 have been added. When will new figures be published? In the fourth quarter 2023 final figures of 2022 will be published.