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.
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.
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!
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
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.
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
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
Historic (none)
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
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Historical chart and dataset showing World fertility rate by year from 1950 to 2025.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
<ul style='margin-top:20px;'>
<li>World birth rate for 2024 was <strong>17.30</strong>, a <strong>5.9% increase</strong> from 2023.</li>
<li>World birth rate for 2023 was <strong>16.33</strong>, a <strong>1.34% decline</strong> from 2022.</li>
<li>World birth rate for 2022 was <strong>16.56</strong>, a <strong>1.7% decline</strong> from 2021.</li>
</ul>Crude birth rate indicates the number of live births occurring during the year, per 1,000 population estimated at midyear. Subtracting the crude death rate from the crude birth rate provides the rate of natural increase, which is equal to the rate of population change in the absence of migration.
This map service, derived from World Bank data, shows
various characteristics of the Health topic. The World Bank Group provides financing, state-of-the-art analysis, and policy advice to help countries expand access to quality, affordable health care; protects people from falling into poverty or worsening poverty due to illness; and promotes investments in all sectors that form the foundation of healthy societies.Age Dependency Ratio: Age
dependency ratio is the ratio of dependents--people younger than 15 or
older than 64--to the working-age population--those ages 15-64. Data
are shown as the proportion of dependents per 100 working-age
population. Data from 1960 – 2012.Age Dependency Ratio Old: Age
dependency ratio, old, is the ratio of older dependents--people older
than 64--to the working-age population--those ages 15-64. Data are
shown as the proportion of dependents per 100 working-age population.
Data from 1960 – 2012.Birth/Death Rate: Crude birth/death rate
indicates the number of births/deaths occurring during the year, per
1,000 population estimated at midyear. Subtracting the crude death rate
from the crude birth rate provides the rate of natural increase, which
is equal to the rate of population change in the absence of migration. Data spans from 1960 – 2008.Total Fertility: Total
fertility rate represents the number of children that would be born to
a woman if she were to live to the end of her childbearing years and
bear children in accordance with current age-specific fertility rates. Data shown is for 1960 - 2008.Population Growth: Annual
population growth rate for year t is the exponential rate of growth of
midyear population from year t-1 to t, expressed as a percentage.
Population is based on the de facto definition of population, which
counts all residents regardless of legal status or citizenship--except
for refugees not permanently settled in the country of asylum, who are
generally considered part of the population of the country of origin. Data spans from 1960 – 2009.Life Expectancy: Life
expectancy at birth indicates the number of years a newborn infant
would live if prevailing patterns of mortality at the time of its birth
were to stay the same throughout its life. Data spans from 1960 – 2008.Population Female: Female population is the percentage of the population that is female. Population is based on the de facto definition of population. Data from 1960 – 2009.For more information, please visit: World Bank Open Data. _Other International User Community content that may interest you World Bank World Bank Age World Bank Health
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Historical chart and dataset showing U.S. birth rate by year from 1950 to 2025.
https://fred.stlouisfed.org/legal/#copyright-public-domainhttps://fred.stlouisfed.org/legal/#copyright-public-domain
Graph and download economic data for Fertility Rate, Total for the United States (SPDYNTFRTINUSA) from 1960 to 2023 about fertility, rate, and USA.
The region of present-day China has historically been the most populous region in the world; however, its population development has fluctuated throughout history. In 2022, China was overtaken as the most populous country in the world, and current projections suggest its population is heading for a rapid decline in the coming decades. Transitions of power lead to mortality The source suggests that conflict, and the diseases brought with it, were the major obstacles to population growth throughout most of the Common Era, particularly during transitions of power between various dynasties and rulers. It estimates that the total population fell by approximately 30 million people during the 14th century due to the impact of Mongol invasions, which inflicted heavy losses on the northern population through conflict, enslavement, food instability, and the introduction of bubonic plague. Between 1850 and 1870, the total population fell once more, by more than 50 million people, through further conflict, famine and disease; the most notable of these was the Taiping Rebellion, although the Miao an Panthay Rebellions, and the Dungan Revolt, also had large death tolls. The third plague pandemic also originated in Yunnan in 1855, which killed approximately two million people in China. 20th and 21st centuries There were additional conflicts at the turn of the 20th century, which had significant geopolitical consequences for China, but did not result in the same high levels of mortality seen previously. It was not until the overlapping Chinese Civil War (1927-1949) and Second World War (1937-1945) where the death tolls reached approximately 10 and 20 million respectively. Additionally, as China attempted to industrialize during the Great Leap Forward (1958-1962), economic and agricultural mismanagement resulted in the deaths of tens of millions (possibly as many as 55 million) in less than four years, during the Great Chinese Famine. This mortality is not observable on the given dataset, due to the rapidity of China's demographic transition over the entire period; this saw improvements in healthcare, sanitation, and infrastructure result in sweeping changes across the population. The early 2020s marked some significant milestones in China's demographics, where it was overtaken by India as the world's most populous country, and its population also went into decline. Current projections suggest that China is heading for a "demographic disaster", as its rapidly aging population is placing significant burdens on China's economy, government, and society. In stark contrast to the restrictive "one-child policy" of the past, the government has introduced a series of pro-fertility incentives for couples to have larger families, although the impact of these policies are yet to materialize. If these current projections come true, then China's population may be around half its current size by the end of the century.
Students will explore the patterns of world population in terms of total population, arithmetic density, total fertility rate, natural increase rate, and infant mortality rate. The activity uses a web-based map and is tied to the AP Human Geography benchmarks. Learning outcomes:Students will be able to identify and explain the spatial patterns and distribution of world population based on total population, density, total fertility rate, natural increase rate, and infant mortality rate.Find more advanced human geography geoinquiries and explore all geoinquiries at http://www.esri.com/geoinquiries Latest version: Q2 2016
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
<ul style='margin-top:20px;'>
<li>India fertility rate for 2024 was <strong>2.12</strong>, a <strong>7.44% increase</strong> from 2023.</li>
<li>India fertility rate for 2023 was <strong>1.98</strong>, a <strong>0.95% decline</strong> from 2022.</li>
<li>India fertility rate for 2022 was <strong>1.99</strong>, a <strong>0.99% decline</strong> from 2021.</li>
</ul>Total fertility rate represents the number of children that would be born to a woman if she were to live to the end of her childbearing years and bear children in accordance with age-specific fertility rates of the specified year.
https://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
This dataset provides comprehensive global population dynamics data, spanning from 1950 to 2100. It includes historical estimates and medium-scenario projections from the United Nations World Population Prospects 2024 edition. Covering 237 countries or areas, this dataset offers researchers, policymakers, and data enthusiasts a valuable resource for analyzing long-term demographic trends and their potential impacts across a 150-year period.
Key features of this dataset include:
This dataset is ideal for:
Whether you're a data scientist, historian, policymaker, or social researcher, this dataset offers a wealth of information to explore and analyze global population dynamics across a century and a half.
This dataset presents the estimated number of live births in each country for the most recent reference year, based on the 2024 revision of the UN Population Division’s World Population Prospects. Live birth estimates are a key demographic indicator, used for planning health services, calculating health coverage indicators, and understanding population growth trends. These figures support maternal and newborn health monitoring and workforce planning at national and global levels.Data Source:UN Population Division World Population Prospects: https://population.un.org/wpp/Download/StandardData Dictionary: The data is collated with the following columns:Column headingContent of this columnPossible valuesRefNumerical counter for each row of data, for ease of identification1+CountryShort name for the country195 countries in total – all 194 WHO member states plus PalestineISO3Three-digit alphabetical codes International Standard ISO 3166-1 assigned by the International Organization for Standardization (ISO). e.g. AFG (Afghanistan)ISO22 letter identifier code for the countrye.g. AF (Afghanistan)ICM_regionICM Region for countryAFR (Africa), AMR (Americas), EMR (Eastern Mediterranean), EUR (Europe), SEAR (South east Asia) or WPR (Western Pacific)CodeUnique project code for each indicator:GGTXXnnnGG=data group e.g. OU for outcomeT = N for novice or E for ExpertXX = identifier number 00 to 30nnn = identifier name eg mmre.g. OUN01sbafor Outcome Novice Indicator 01 skilled birth attendance Short_nameIndicator namee.g. maternal mortality ratioDescriptionText description of the indicator to be used on websitee.g. Maternal mortality ratio (maternal deaths per 100,000 live births)Value_typeDescribes the indicator typeNumeric: decimal numberPercentage: value between 0 & 100Text: value from list of text optionsY/N: yes or noValue_categoryExpect this to be ‘total’ for all indicators for Phase 1, but this could allow future disaggregation, e.g. male/female; urban/ruraltotalYearThe year that the indicator value was reported. For most indicators, we will only report if 2014 or more recente.g. 2020Latest_Value‘LATEST’ if this is the most recent reported value for the indicator since 2014, otherwise ‘No’. Useful for indicators with time trend data.LATEST or NOValueIndicator valuee.g. 99.8. NB Some indicators are calculated to several decimal places. We present the value to the number of decimal places that should be displayed on the Hub.SourceFor Caesarean birth rate [OUN13cbr] ONLY, this column indicates the source of the data, either OECD when reported, or UNICEF otherwise.OECD or UNICEFTargetHow does the latest value compare with Global guidelines / targets?meets targetdoes not meet targetmeets global standarddoes not meet global standardRankGlobal rank for indicator, i.e. the country with the best global score for this indicator will have rank = 1, next = 2, etc. This ranking is only appropriate for a few indicators, others will show ‘na’1-195Rank out ofThe total number of countries who have reported a value for this indicator. Ranking scores will only go as high as this number.Up to 195TrendIf historic data is available, an indication of the change over time. If there is a global target, then the trend is either getting better, static or getting worse. For mmr [OUN04mmr] and nmr [OUN05nmr] the average annual rate of reduction (arr) between 2016 and latest value is used to determine the trend:arr <-1.0 = getting worsearr >=-1.0 AND <=1.0 = staticarr >1.0 = getting betterFor other indicators, the trend is estimated by comparing the average of the last three years with the average ten years ago:decreasing if now < 95% 10 yrs agoincreasing if now > 105% 10 yrs agostatic otherwiseincreasingdecreasing Or, if there is a global target: getting better,static,getting worseNotesClarification comments, when necessary LongitudeFor use with mapping LatitudeFor use with mapping DateDate data uploaded to the Hubthe following codes are also possible values:not reported does not apply don’t knowThis is one of many datasets featured on the Midwives’ Data Hub, a digital platform designed to strengthen midwifery and advocate for better maternal and newborn health services.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
<ul style='margin-top:20px;'>
<li>China birth rate for 2024 was <strong>10.48</strong>, a <strong>63.97% increase</strong> from 2023.</li>
<li>China birth rate for 2023 was <strong>6.39</strong>, a <strong>5.61% decline</strong> from 2022.</li>
<li>China birth rate for 2022 was <strong>6.77</strong>, a <strong>9.97% decline</strong> from 2021.</li>
</ul>Crude birth rate indicates the number of live births occurring during the year, per 1,000 population estimated at midyear. Subtracting the crude death rate from the crude birth rate provides the rate of natural increase, which is equal to the rate of population change in the absence of migration.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
<ul style='margin-top:20px;'>
<li>India birth rate for 2024 was <strong>16.75</strong>, a <strong>3.74% increase</strong> from 2023.</li>
<li>India birth rate for 2023 was <strong>16.15</strong>, a <strong>1.16% decline</strong> from 2022.</li>
<li>India birth rate for 2022 was <strong>16.34</strong>, a <strong>0.94% decline</strong> from 2021.</li>
</ul>Crude birth rate indicates the number of live births occurring during the year, per 1,000 population estimated at midyear. Subtracting the crude death rate from the crude birth rate provides the rate of natural increase, which is equal to the rate of population change in the absence of migration.
In 2024, the birth rate in South Korea stood at 0.75 births per woman. The country has long struggled with a declining birth rate, dropping below one birth per woman in 2018.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Summary comparison metrics for completeness from CRVS data (calculated using UN birth estimates) and completeness from self-reported data, 12–23 months.
This map is adapted from the outstanding work of Dr. Joseph Kerski at ESRI. A map of political, social, and economic indicators for 2010. Created at the Data Analysis and Social Inquiry Lab at Grinnell College by Megan Schlabaugh, April Chen, and Adam Lauretig.Data from Freedom House, the Center for Systemic Peace, and the World Bank.Shapefile:Weidmann, Nils B., Doreen Kuse, and Kristian Skrede Gleditsch. 2010. The Geography of the International System: The CShapes Dataset. International Interactions 36 (1).Field Descriptions:
Variable Name Variable Description Years Available Further Description Source
TotPop Total Population 2011 Population of the country/region World Bank
GDPpcap GDP per capita (current USD) 2011 A measure of the total output of a country that takes the gross domestic product (GDP) and divides it by the number of people in the country. The per capita GDP is especially useful when comparing one country to another because it shows the relative performance of the countries. World Bank
GDPpcapPPP GDP per capita based on purchasing power parity (PPP) 2011
World Bank
HDI Human Development Index (HDI) 2011 A tool developed by the United Nations to measure and rank countries' levels of social and economic development based on four criteria: Life expectancy at birth, mean years of schooling, expected years of schooling and gross national income per capita. The HDI makes it possible to track changes in development levels over time and to compare development levels in different countries. World Bank
LifeExpct Life expectancy at birth 2011 The probable number of years a person will live after a given age, as determined by mortality in a specific geographic area. World Bank
MyrSchool Mean years of schooling 2011 Years that a 25-year-old person or older has spent in schools World Bank
ExpctSch Expected years of schooling 2011 Number of years of schooling that a child of school entrance age can expect to receive if prevailing patterns of age-specific enrolment rates persist throughout the child’s life. World Bank
GNIpcap Gross National Income (GNI) per capita 2011 Gross national income (GNI) is the sum of value added by all resident producers plus any product taxes (less subsidies) not included in the valuation of output plus net receipts of primary income (compensation of employees and property income) from abroad. GNI per capita is gross national income divided by mid-year population. World Bank
GNIpcapHDI GNI per capita rank minus HDI rank 2011
World Bank
NaIncHDI
Nonincome HDI
2011
World Bank
15+LitRate Adult (15+) literacy rate (%). Total 2010
UNESCO
EmplyAgr Employment in Agriculture 2009
World Bank
GDPenergy GDP per unit of energy use 2010 The PPP GDP per kilogram of oil equivalent of energy use. World Bank
GDPgrowth GDP growth (annual %) 2011
World Bank
GDP GDP (current USD) 2011
World Bank
ExptGDP Exports of Goods and Service (% GDP) 2011 The value of all goods and other market services provided to the rest of the world World Bank
ImprtGDP Imports of Goods and Service (% GDP) 2011 The value of all goods and other market services received from the rest of the world. World Bank
AgrGDP Agriculture, Value added (% GDP) 2011 Agriculture corresponds to ISIC divisions 1-5 and includes forestry, hunting, and fishing, as well as cultivation of crops and livestock production. Value added is the net output of a sector after adding up all outputs and subtracting intermediate inputs. World Bank
FDI Foreign Direct Investment, net (current USD) 2011 Foreign direct investment are the net inflows of investment to acquire a lasting management interest (10 percent or more of voting stock) in an enterprise operating in an economy other than that of the investor. It is the sum of equity capital, reinvestment of earnings, other long-term capital, and short-term capital as shown in the balance of payments. World Bank
GNIpcap GNI per capita PP 2011 GNI per capita based on purchasing power parity (PPP). PPP GNI is gross national income (GNI) converted to international dollars using purchasing power parity rates. An international dollar has the same purchasing power over GNI as a U.S. dollar has in the United States. GNI is the sum of value added by all resident producers plus any product taxes (less subsidies) not included in the valuation of output plus net receipts of primary income (compensation of employees and property income) from abroad. World Bank
Inflatn Inflation, Consumer Prices (annual %) 2011 Inflation as measured by the consumer price index reflects the annual percentage change in the cost to the average consumer of acquiring a basket of goods and services that may be fixed or changed at specified intervals, such as yearly. World Bank
InfltnGDP Inflation, GDP deflator (annual %) 2011 Inflation as measured by the annual growth rate of the GDP implicit deflator shows the rate of price change in the economy as a whole. The GDP implicit deflator is the ratio of GDP in current local currency to GDP in constant local currency. World Bank
PctWomParl % women in national parliament 2010
United Nations
IntnetUser Internet Users, per 100 peple 2011 Internet users are people with access to the worldwide network. World Bank
HIVPrevlnc Estimated HIV Prevalence% - (Ages 15-49) 2009 Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV. UNAIDS estimates. UNAIDS
AgrLand Agricultural land (% of land area) 2009 Agricultural land refers to the share of land area that is arable, under permanent crops, and under permanent pastures. World Bank
AidRecPP Aid received per person (current US$) 2010 Net official development assistance (ODA) per capita consists of disbursements of loans made on concessional terms (net of repayments of principal) and grants by official agencies of the members of the Development Assistance Committee (DAC), by multilateral institutions, and by non-DAC countries to promote economic development and welfare in countries and territories in the DAC list of ODA recipients; and is calculated by dividing net ODA received by the midyear population estimate. It includes loans with a grant element of at least 25 percent (calculated at a rate of discount of 10 percent). World Bank
AlcohAdul Alcohol consumption per adult (15+) in litres 2008 Liters of pure alcohol, computed as the sum of alcohol production and imports, less alcohol exports, divided by the adult population (aged 15 years and older). World Health Organization
ArmyPct Military expenditure (% of central government expenditure) 2008 Military expenditures data from SIPRI are derived from the NATO definition, which includes all current and capital expenditures on the armed forces, including peacekeeping forces; defense ministries and other government agencies engaged in defense projects; paramilitary forces, if these are judged to be trained and equipped for military operations; and military space activities. Such expenditures include military and civil personnel, including retirement pensions of military personnel and social services for personnel; operation and maintenance; procurement; military research and development; and military aid (in the military expenditures of the donor country). World Development Indicators (World Bank)
TFR Total Fertility Rate 2011 The average number of children that would be born per woman if all women lived to the end of their childbearing years and bore children according to a given fertility rate at each age. This indicator shows the potential for population change in a country. World Bank
CO2perUSD CO2 kg per USD 2008 Carbon dioxide emissions are those stemming from the burning of fossil fuels and the manufacture of cement. They include carbon dioxide produced during consumption of solid, liquid, and gas fuels and gas flaring. World Bank
ExpdtrPrim Expenditure per student, primary (% of GDP per capita) 2008 Public expenditure per pupil as a % of GDP per capita. Primary is the total public expenditure per student in primary education as a percentage of GDP per capita. Public expenditure (current and capital) includes government spending on educational institutions (both public and private), education administration as well as subsidies for private entities (students/households and other privates entities). World Bank
ExpdtrSecd Expenditure per student, secondary (% of GDP per capita) 2008 Public expenditure per pupil as a % of GDP per capita. Secondary is the total public expenditure per student in secondary education as a percentage of GDP per capita. World Bank
ExpdtrTert Expenditure per student, tertiary (% of GDP per capita) 2008 Public expenditure per pupil as a % of GDP per capita. Tertiary is the total public expenditure per student in tertiary education as a percentage of GDP per capita. World Bank
FDIoutf Foreign direct investment, net outflows (% of GDP) 2010 Foreign direct investment are the net inflows of investment to acquire a lasting management interest (10 percent or more of voting stock) in an enterprise operating in an economy other than that of the investor. It is the sum of equity capital, reinvestment of earnings, other long-term capital, and short-term capital as shown in the balance of payments. This series shows net outflows of investment from the
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Absolute difference (self-reported completeness minus CRVS completeness) calculated using UN and GBD birth estimates (percentage points), less than five years, by countries with unpublished data.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Since 1991, the governments of 15 countries, formerly integrated into a unified cultural, economic, social, and legal framework within the Union of Soviet Socialist Republics, have sequentially decided to secede from the union and build sovereign nation-states with independent foreign and domestic policies. The dataset has been compiled with the aim of studying the demographic policies of post-Soviet countries, including the Russian Federation, Republic of Kazakhstan, Republic of Belarus, Kyrgyz Republic, and Republic of Estonia. For consistency in comparison, demographic statistics were obtained from a single source: the non-profit, non-governmental resource “Database.earth,” which bases its data on the report titled “2024 Revision of World Population Prospects” prepared by the Department of Economic and Social Affairs of the United Nations.The files include two tables (with corresponding charts): 1. The natural increase rate in the studied countries over the period from 1990 to 2024. 2. Urban-rural population ratio in the studied countries as of 2024. The natural increase rate is a standardized indicator that allows comparisons between different states regardless of their size or level of economic development. Private trends for individual states. 1. The Russian Federation. After a stable period of positive growth in the late 1980s, the country faced a deep crisis in the first half of the 1990s (-5.7% in 1995). By the beginning of the 21st century, dynamics stabilized, but the overall trend remains negative. Attempts to restore fertility led to temporary improvement in 2015 (+0.3%). 2. Republic of Kazakhstan. The country maintained a positive growth dynamic almost throughout the observation period. The highest peak of growth falls on the early 2010s (13.6% in 2010, 15.2% in 2015), demonstrating high rates of population reproduction. However, by the end of the observed period (2024), there is also a gradual slowdown in growth noted. 3. Republic of Belarus. The situation in Belarus is characterized by alternating positive and negative phases. The beginning of the 1990s was marked by a significant drop, followed by a weak recovery period. Nevertheless, the general tendency is towards maintaining low levels of growth, transitioning into an insignificant minus by the 2020s. 4. Kyrgyz Republic. The only country showing sustained positive values of growth over the entire study period. Although some reduction in positive figures has been observed, nevertheless, it maintains relatively high rates of natural increase (approximately +15-18%). 5. Estonian Republic. This country stands out with the strongest volatility among the reviewed states. Except for one year (2010), natural growth remained consistently negative. The significant fall was observed in the mid-1990s and continued through the first decades of the 21st century.
Not seeing a result you expected?
Learn how you can add new datasets to our index.
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.
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.
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!
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
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.
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
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
Historic (none)
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