Historical chart and dataset showing Mexico birth rate 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. 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

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?

Historical chart and dataset showing Vietnam birth rate by year from 1950 to 2025.

Historical chart and dataset showing Saudi Arabia birth rate by year from 1950 to 2025.

"Total population is based on the de facto definition of population, which counts all residents regardless of legal status or citizenship. The values shown are midyear estimates.This dataset includes demographic data of 22 countries from 1960 to 2018, including Sri Lanka, Bangladesh, Pakistan, India, Maldives, etc. Data fields include: country, year, population ratio, male ratio, female ratio, population density (km). Source: ( 1 ) United Nations Population Division. World Population Prospects: 2019 Revision. ( 2 ) Census reports and other statistical publications from national statistical offices, ( 3 ) Eurostat: Demographic Statistics, ( 4 ) United Nations Statistical Division. Population and Vital Statistics Reprot ( various years ), ( 5 ) U.S. Census Bureau: International Database, and ( 6 ) Secretariat of the Pacific Community: Statistics and Demography Programme. Periodicity: Annual Statistical Concept and Methodology: Population estimates are usually based on national population censuses. Estimates for the years before and after the census are interpolations or extrapolations based on demographic models. Errors and undercounting occur even in high-income countries. In developing countries errors may be substantial because of limits in the transport, communications, and other resources required to conduct and analyze a full census. The quality and reliability of official demographic data are also affected by public trust in the government, government commitment to full and accurate enumeration, confidentiality and protection against misuse of census data, and census agencies' independence from political influence. Moreover, comparability of population indicators is limited by differences in the concepts, definitions, collection procedures, and estimation methods used by national statistical agencies and other organizations that collect the data. The currentness of a census and the availability of complementary data from surveys or registration systems are objective ways to judge demographic data quality. Some European countries' registration systems offer complete information on population in the absence of a census. The United Nations Statistics Division monitors the completeness of vital registration systems. Some developing countries have made progress over the last 60 years, but others still have deficiencies in civil registration systems. International migration is the only other factor besides birth and death rates that directly determines a country's population growth. Estimating migration is difficult. At any time many people are located outside their home country as tourists, workers, or refugees or for other reasons. Standards for the duration and purpose of international moves that qualify as migration vary, and estimates require information on flows into and out of countries that is difficult to collect. Population projections, starting from a base year are projected forward using assumptions of mortality, fertility, and migration by age and sex through 2050, based on the UN Population Division's World Population Prospects database medium variant."

Live births and stillbirths annual summary statistics, by sex, age of mother, whether within marriage or civil partnership, percentage of non-UK-born mothers, birth rates and births by month and mothers' area of usual residence.

Key figures on the population of the Netherlands.

The following information is available: - Population by sex; - Population by marital status; - Population by age (groups); - Population by origin; - Private households; - Persons in institutional households; - Population growth; - Population density.

CBS is in transition towards a new classification of the population by origin. Greater emphasis is now placed on where a person was born, aside from where that person’s parents were born. The term ‘migration background’ is no longer used in this regard. The main categories western/non-western are being replaced by categories based on continents and a few countries that share a specific migration history with the Netherlands. The new classification is being implemented gradually in tables and publications on population by origin.

Data available from: 1950 Figures on population by origin are only available from 2022 at this moment. The periods 1996 through 2021 will be added to the table at a later time.

Status of the figures: All the figures are final.

Changes as of 17 July 2024: Final figures with regard to population growth for 2023 and final figures of the population on 1 January 2024 have been added.

Changes as of 26 April 2023: None, this is a new table. This table succeeds the table Population; key figures; 1950-2022. See section 3. The following changes have been implemented compared to the discontinued table: - The topic folder 'Population by migration background' has been replaced by 'Population by origin'; - The underlying topic folders regarding 'first and second generation migration background' have been replaced by 'Born in the Netherlands' and 'Born abroad'; - The origin countries Armenia, Azerbaijan, Georgia, Kazakhstan, Kyrgyzstan, Uzbekistan, Tajikistan, Turkmenistan and Turkey have been assigned to the continent of Asia (previously Europe).

When will new figures be published? In the last quarter of 2025 final figures with regard to population growth for 2024 and final figures of the population on 1 January 2025 will be added.

Historical chart and dataset showing Indonesia birth rate by year from 1950 to 2025.

The figures in the table relate to people from the birth generations mentioned who were living in the Netherlands in 2008. The percentage is calculated on the total number of persons from the relevant period of birth with characteristics such as gender and 'parental family situation'. For example, this table shows the percentage of people from a certain birth generation who have ever had children before or at an age with the parental family as a background variable. The family is the context for the socialization process: parents serve as role models for children. In addition, children 'from home' receive social, economic and cultural resources. This table provides an answer to the extent to which the context of the parental family influences the demographic course of life. The central question in this table is: Which demographic events have people up to and including a certain age (at 25, 30, 35, 40 and 45 years of age) experienced? Did this change for successive birth generations? Does it matter what the characteristics are of the parental family in which one grew up? The demographic events relate to: - living together (married or unmarried) - getting married - having children - separating Data available for birth generations from: 1950 to 1960, 1960 to 1970 and 1970 to 1980. Status of the figures: All in the table figures included are provisional. Since this table has been discontinued, the figures are no longer finalized. Changes as of 11 August 2017: One-off, Family Formation Survey 2008. When will new figures be released? Not applicable anymore.

The total population in Japan was estimated at 123.6 million people in 2024, according to the latest census figures and projections from Trading Economics. This dataset provides - Japan Population - actual values, historical data, forecast, chart, statistics, economic calendar and news.

Our global population is getting older, largely because of increasing life expectancies and declining birth rates. In 2018 the number of people older than 64 years old surpassed the number of children under 5 years old. This was the first time in history this was the case.

Age groups: - 0-4 years - 5-14 years - 15-24 years - 24-65 years - 65+ year

Data Source: Age Structure - Our World in Data

Full Data (1950-2021): Population by age group, including UN projections, World

Historical chart and dataset showing Tanzania birth rate by year from 1950 to 2025.

The POPLINK database contains personal records entered from parish registers from large parts of the Västerbotten county and the inland of Norrland. The database covers parish registers from the end of the 17th century until 1950. The personal records stem from different types of parish registers such as catechetical registers, birth and baptism registers, banns and marriage registers, migrations registers, and death registers.

These datasets, ranging from birth to death, provides possibilities to link together individuals and generations. The life stories of individuals as well as family histories can be tracked. Moreover, the dataset offers the possibility to study demographical and socio-economic changes over time across different regions and parishes.

The purpose of the POPLINK database is to provide detailed individual records from church books between the late 1600s and around 1950 for research. It enables studies on demography, social structures, and historical development in Sweden. POPUM offers data on, among other things, population development, migration patterns, economic changes, industrialization, agricultural communities, small-scale farming, Sámi history, and urbanization.

The database is a resource in many areas of research. Not least because of the possibility to link together POPLINK with other modern registers. This means, among other things, that the life sciences can investigate how nature and nurture influence the development of our most common national diseases, such as cardiovascular diseases, cancer, and diabetes. Within the social sciences and the humanities, the increasing access to personal records brings about an opportunity for new perspectives on the rise of the welfare state and the time that shaped the modern Sweden.

POPLINK is a research database, which means that only academic researchers can be given access. In some cases it requires approval from The Swedish Ethical Review Authority.

Historical chart and dataset showing Uganda birth rate by year from 1950 to 2025.

Historical chart and dataset showing Yemen birth rate by year from 1950 to 2025.

This database is a compendium of histories of known age seals (Weddell) from observations across the Southern Ocean but focussed on the Windmill Islands, Mawson and the Vestfold Hills. Although the following information pertains to Elephant Seals, it is assumed similar procedures were undertaken with the Weddell Seals between 1973 and 2006: At Macquarie Island 1000 seals were weighed per annum between 1993-2003 at birth and individually marked with two plastic flipper tags in the inter-digital webbing of their hind flippers. These tagged seals were weighed again at weaning, when length, girth, fat depth, and flipper measurements were made. Three weeks after weaning 2000 seals were permanently and individually marked by hot-iron branding. Recaptures and re-weighings of these known aged individuals were used to calculate growth and age-specific survival of the seals. Similar data were collected from elephant seals between 1950 and 1965 when seals were individually marked by hot-iron branding. Mark-recapture data from these cohorts were used to assess the demography of the declining population. Length and mass data were also collected for these cohorts and were used, for the first time, to assess the growth of individual seals without killing them. The database was held by the Australian Antarctic Data Centre, but was taken offline due to maintenance problems. A snapshot of the database was taken in June 2018 and stored in an access database. This work was completed as part of ASAC project 90.

This database is a compendium of histories of known age seals (leopard) from observations across the Southern Ocean but primarily focussed on Macquarie Island. Although the following information pertains to Elephant Seals, it is assumed similar procedures were undertaken with the Leopard Seals between 1957 and 1999: "At Macquarie Island 1000 seals were weighed per annum between 1993-2003 at birth and individually marked with two plastic flipper tags in the inter-digital webbing of their hind flippers. These tagged seals were weighed again at weaning, when length, girth, fat depth, and flipper measurements were made. Three weeks after weaning 2000 seals were permanently and individually marked by hot-iron branding. Recaptures and re-weighings of these known aged individuals were used to calculate growth and age-specific survival of the seals. Similar data were collected from elephant seals between 1950 and 1965 when seals were individually marked by hot-iron branding. Mark-recapture data from these cohorts were used to assess the demography of the declining population. Length and mass data were also collected for these cohorts and were used, for the first time, to assess the growth of individual seals without killing them." The database was held by the Australian Antarctic Data Centre, but was taken offline due to maintenance problems. A snapshot of the database was taken in June 2018 and stored in an access database. This work was completed as part of ASAC project 90.

Historical chart and dataset showing Indonesia death rate by year from 1950 to 2025.

Historical chart and dataset showing Singapore death rate by year from 1950 to 2025.