This dataset is about countries. It has 194 rows. It features 5 columns: birth rate, death rate, fertility rate, and population. It is 100% filled with non-null values.

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

This dataset of U.S. mortality trends since 1900 highlights the differences in age-adjusted death rates and life expectancy at birth by race and sex. Age-adjusted death rates (deaths per 100,000) after 1998 are calculated based on the 2000 U.S. standard population. Populations used for computing death rates for 2011–2017 are postcensal estimates based on the 2010 census, estimated as of July 1, 2010. Rates for census years are based on populations enumerated in the corresponding censuses. Rates for noncensus years between 2000 and 2010 are revised using updated intercensal population estimates and may differ from rates previously published. Data on age-adjusted death rates prior to 1999 are taken from historical data (see References below). Life expectancy data are available up to 2017. Due to changes in categories of race used in publications, data are not available for the black population consistently before 1968, and not at all before 1960. More information on historical data on age-adjusted death rates is available at https://www.cdc.gov/nchs/nvss/mortality/hist293.htm. SOURCES CDC/NCHS, National Vital Statistics System, historical data, 1900-1998 (see https://www.cdc.gov/nchs/nvss/mortality_historical_data.htm); CDC/NCHS, National Vital Statistics System, mortality data (see http://www.cdc.gov/nchs/deaths.htm); and CDC WONDER (see http://wonder.cdc.gov). REFERENCES National Center for Health Statistics, Data Warehouse. Comparability of cause-of-death between ICD revisions. 2008. Available from: http://www.cdc.gov/nchs/nvss/mortality/comparability_icd.htm. National Center for Health Statistics. Vital statistics data available. Mortality multiple cause files. Hyattsville, MD: National Center for Health Statistics. Available from: https://www.cdc.gov/nchs/data_access/vitalstatsonline.htm. Kochanek KD, Murphy SL, Xu JQ, Arias E. Deaths: Final data for 2017. National Vital Statistics Reports; vol 68 no 9. Hyattsville, MD: National Center for Health Statistics. 2019. Available from: https://www.cdc.gov/nchs/data/nvsr/nvsr68/nvsr68_09-508.pdf. Arias E, Xu JQ. United States life tables, 2017. National Vital Statistics Reports; vol 68 no 7. Hyattsville, MD: National Center for Health Statistics. 2019. Available from: https://www.cdc.gov/nchs/data/nvsr/nvsr68/nvsr68_07-508.pdf. National Center for Health Statistics. Historical Data, 1900-1998. 2009. Available from: https://www.cdc.gov/nchs/nvss/mortality_historical_data.htm.

This Dataset provides comprehensive demographic information on global populations from 1950 to the present. It offers insights into various aspects of population dynamics, including population counts, gender ratios, birth and death rates, life expectancy, and migration patterns.

Column Descriptions:

SortOrder: Numeric identifier for sorting.

LocID: Location identifier.

Notes: Additional notes or comments (blank in this dataset).

ISO3_code: ISO 3-character country code.

ISO2_code: ISO 2-character country code.

SDMX_code: Statistical Data and Metadata Exchange code.

LocTypeID: Location type identifier.

LocTypeName: Location type name.

ParentID: Identifier for the parent location.

Location: Name of the location.

VarID: Identifier for the variant.

Variant: Type of population variant.

Time: Year or time period.

TPopulation1Jan: Total population on January 1st.

TPopulation1July: Total population on July 1st.

TPopulationMale1July: Total male population on July 1st.

TPopulationFemale1July: Total female population on July 1st.

PopDensity: Population density (people per square kilometer).

PopSexRatio: Population sex ratio (male/female).

MedianAgePop: Median age of the population.

NatChange: Natural change in population.

NatChangeRT: Natural change rate (per 1,000 people).

PopChange: Population change.

PopGrowthRate: Population growth rate (percentage).

DoublingTime: Time for population to double (in years).

Births: Total number of births.

Births1519: Births to mothers aged 15-19.

CBR: Crude birth rate (per 1,000 people).

TFR: Total fertility rate (average number of children per woman).

NRR: Net reproduction rate.

MAC: Mean age at childbearing.

SRB: Sex ratio at birth (male/female).

Deaths: Total number of deaths.

DeathsMale: Total male deaths.

DeathsFemale: Total female deaths.

CDR: Crude death rate (per 1,000 people).

LEx: Life expectancy at birth.

LExMale: Life expectancy for males at birth.

LExFemale: Life expectancy for females at birth.

LE15: Life expectancy at age 15.

LE15Male: Life expectancy for males at age 15.

LE15Female: Life expectancy for females at age 15.

LE65: Life expectancy at age 65.

LE65Male: Life expectancy for males at age 65.

LE65Female: Life expectancy for females at age 65.

LE80: Life expectancy at age 80.

LE80Male: Life expectancy for males at age 80.

LE80Female: Life expectancy for females at age 80.

InfantDeaths: Number of infant deaths.

IMR: Infant mortality rate (per 1,000 live births).

LBsurvivingAge1: Children surviving to age 1.

Under5Deaths: Number of deaths under age 5.

NetMigrations: Net migration rate (per 1,000 people).

CNMR: Crude net migration rate.

How to Use the Dataset:

1. Researchers can analyze demographic trends, birth and death rates, and population growth over time.
2. Policymakers can use population data to inform decisions on healthcare, education, and social services.
3. Data scientists can visualize and model population dynamics for various regions.
4. Journalists can use the dataset to report on global population trends and disparities.
5. Educators can incorporate real-world population data into lessons and research.

Please upvote and show your support if you find this dataset valuable for your research or analysis. Your feedback and contributions help make this dataset more accessible to the Kaggle community. Thank you!

This is a source dataset for a Let's Get Healthy California indicator at https://letsgethealthy.ca.gov/. Infant Mortality is defined as the number of deaths in infants under one year of age per 1,000 live births. Infant mortality is often used as an indicator to measure the health and well-being of a community, because factors affecting the health of entire populations can also impact the mortality rate of infants. Although California’s infant mortality rate is better than the national average, there are significant disparities, with African American babies dying at more than twice the rate of other groups. Data are from the Birth Cohort Files. The infant mortality indicator computed from the birth cohort file comprises birth certificate information on all births that occur in a calendar year (denominator) plus death certificate information linked to the birth certificate for those infants who were born in that year but subsequently died within 12 months of birth (numerator). Studies of infant mortality that are based on information from death certificates alone have been found to underestimate infant death rates for infants of all race/ethnic groups and especially for certain race/ethnic groups, due to problems such as confusion about event registration requirements, incomplete data, and transfers of newborns from one facility to another for medical care. Note there is a separate data table "Infant Mortality by Race/Ethnicity" which is based on death records only, which is more timely but less accurate than the Birth Cohort File. Single year shown to provide state-level data and county totals for the most recent year. Numerator: Infants deaths (under age 1 year). Denominator: Live births occurring to California state residents. Multiple years aggregated to allow for stratification at the county level. For this indicator, race/ethnicity is based on the birth certificate information, which records the race/ethnicity of the mother. The mother can “decline to state”; this is considered to be a valid response. These responses are not displayed on the indicator visualization.

The dataset contains information on various demographic and health indicators for different countries. It is organized into several columns, each providing essential information about these countries. Here's a description of each column:

1. Country: This column represents the names of different countries or regions included in the dataset. Each row corresponds to a specific country or region, and this column serves as the identifier for each entry.

2. Life Expectancy Males: This column contains data on the average life expectancy of males in each of the listed countries. Life expectancy is a crucial health indicator and provides an estimate of the average number of years a male can expect to live, given current mortality rates and health conditions.

3. Life Expectancy Females: Similar to the "Life Expectancy Males" column, this column provides data on the average life expectancy of females in the same countries. It reflects the average number of years a female can expect to live, considering the prevailing health and mortality conditions.

4. Birth Rate: The "Birth Rate" column contains information about the birth rate in each country. Birth rate is a demographic indicator that represents the number of live births per 1,000 people in a given population over a specific period, usually a year. It can provide insights into a country's population growth or decline.

5. Death Rate: This column presents data on the death rate in each of the listed countries. The death rate is another crucial demographic indicator and represents the number of deaths per 1,000 people in a population over a specific period, often a year. It helps gauge the overall health and mortality conditions within a country.

United States US: Birth Rate: Crude: per 1000 People data was reported at 12.400 Ratio in 2016. This stayed constant from the previous number of 12.400 Ratio for 2015. United States US: Birth Rate: Crude: per 1000 People data is updated yearly, averaging 15.100 Ratio from Dec 1960 (Median) to 2016, with 57 observations. The data reached an all-time high of 23.700 Ratio in 1960 and a record low of 12.400 Ratio in 2016. United States US: Birth Rate: Crude: per 1000 People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s United States – Table US.World Bank.WDI: Population and Urbanization Statistics. 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.; ; (1) United Nations Population Division. World Population Prospects: 2017 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.; Weighted average;

United States US: Maternal Mortality Ratio: Modeled Estimate: per 100,000 Live Births data was reported at 14.000 Ratio in 2015. This stayed constant from the previous number of 14.000 Ratio for 2014. United States US: Maternal Mortality Ratio: Modeled Estimate: per 100,000 Live Births data is updated yearly, averaging 13.000 Ratio from Dec 1990 (Median) to 2015, with 26 observations. The data reached an all-time high of 15.000 Ratio in 2009 and a record low of 11.000 Ratio in 1998. United States US: Maternal Mortality Ratio: Modeled Estimate: per 100,000 Live Births data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Health Statistics. Maternal mortality ratio is the number of women who die from pregnancy-related causes while pregnant or within 42 days of pregnancy termination per 100,000 live births. The data are estimated with a regression model using information on the proportion of maternal deaths among non-AIDS deaths in women ages 15-49, fertility, birth attendants, and GDP.; ; WHO, UNICEF, UNFPA, World Bank Group, and the United Nations Population Division. Trends in Maternal Mortality: 1990 to 2015. Geneva, World Health Organization, 2015; Weighted average; This indicator represents the risk associated with each pregnancy and is also a Sustainable Development Goal Indicator for monitoring maternal health.

This dataset is about countries per year in Micronesia. It has 64 rows. It features 4 columns: country, death rate, and life expectancy at birth.

United States US: Death Rate: Crude: per 1000 People data was reported at 8.400 Ratio in 2016. This records a decrease from the previous number of 8.440 Ratio for 2015. United States US: Death Rate: Crude: per 1000 People data is updated yearly, averaging 8.700 Ratio from Dec 1960 (Median) to 2016, with 57 observations. The data reached an all-time high of 9.800 Ratio in 1968 and a record low of 7.900 Ratio in 2009. United States US: Death Rate: Crude: per 1000 People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s United States – Table US.World Bank.WDI: Population and Urbanization Statistics. Crude death rate indicates the number of 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.; ; (1) United Nations Population Division. World Population Prospects: 2017 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.; Weighted average;

This dataset tracks the updates made on the dataset "NCHS - Death rates and life expectancy at birth" as a repository for previous versions of the data and metadata.

The data shows the year, state and region wise estimated birth rates, death rates, infant mortality rates by residence

Note: Infant Mortality Rate for smaller States & Union Territories are based on three-years period 2013-15.

Thailand TH: Death Rate: Crude: per 1000 People data was reported at 7.872 Ratio in 2016. This records an increase from the previous number of 7.750 Ratio for 2015. Thailand TH: Death Rate: Crude: per 1000 People data is updated yearly, averaging 7.229 Ratio from Dec 1960 (Median) to 2016, with 57 observations. The data reached an all-time high of 13.180 Ratio in 1960 and a record low of 5.663 Ratio in 1989. Thailand TH: Death Rate: Crude: per 1000 People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Thailand – Table TH.World Bank.WDI: Population and Urbanization Statistics. Crude death rate indicates the number of 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.; ; (1) United Nations Population Division. World Population Prospects: 2017 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.; Weighted average;

Annual UK and constituent country figures for births, deaths, marriages, divorces, civil partnerships and civil partnership dissolutions.

Italy IT: Death Rate: Crude: per 1000 People data was reported at 10.100 Ratio in 2016. This records a decrease from the previous number of 10.700 Ratio for 2015. Italy IT: Death Rate: Crude: per 1000 People data is updated yearly, averaging 9.800 Ratio from Dec 1960 (Median) to 2016, with 57 observations. The data reached an all-time high of 10.700 Ratio in 2015 and a record low of 9.300 Ratio in 1961. Italy IT: Death Rate: Crude: per 1000 People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Italy – Table IT.World Bank.WDI: Population and Urbanization Statistics. Crude death rate indicates the number of 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.; ; (1) United Nations Population Division. World Population Prospects: 2017 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.; Weighted average;

Crude death rate : The ratio of the number of deaths during the year to the average population in that year. The value is expressed per 1 000 population Infant mortality rate : The ratio of the number of deaths of children under one year of age during the year to the number of live births in that year. The value is expressed per 1 000 live births. Description copied from catalog.inspire.geoportail.lu.

Israel IL: Birth Rate: Crude: per 1000 People data was reported at 21.200 Ratio in 2016. This records a decrease from the previous number of 21.300 Ratio for 2015. Israel IL: Birth Rate: Crude: per 1000 People data is updated yearly, averaging 22.600 Ratio from Dec 1960 (Median) to 2016, with 57 observations. The data reached an all-time high of 28.000 Ratio in 1971 and a record low of 20.800 Ratio in 2005. Israel IL: Birth Rate: Crude: per 1000 People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Israel – Table IL.World Bank.WDI: Population and Urbanization Statistics. 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.; ; (1) United Nations Population Division. World Population Prospects: 2017 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.; Weighted average;

China Number of Births data was reported at 10.588 Person th in 2021. This records a decrease from the previous number of 1,213.144 Person th for 2020. China Number of Births data is updated yearly, averaging 12.486 Person th from Dec 1999 (Median) to 2021, with 22 observations. The data reached an all-time high of 1,213.144 Person th in 2020 and a record low of 9.684 Person th in 2011. China Number of Births data remains active status in CEIC and is reported by National Bureau of Statistics. The data is categorized under China Premium Database’s Socio-Demographic – Table CN.GA: Population: No of Birth, Death, Natural Growth, Birth Rate, Death Rate and Natural Growth Rate, Life Expectancy, Dependency Ratio.

Jordan JO: Death Rate: Crude: per 1000 People data was reported at 3.828 Ratio in 2016. This records a decrease from the previous number of 3.829 Ratio for 2015. Jordan JO: Death Rate: Crude: per 1000 People data is updated yearly, averaging 5.389 Ratio from Dec 1960 (Median) to 2016, with 57 observations. The data reached an all-time high of 15.800 Ratio in 1960 and a record low of 3.828 Ratio in 2016. Jordan JO: Death Rate: Crude: per 1000 People data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Jordan – Table JO.World Bank.WDI: Population and Urbanization Statistics. Crude death rate indicates the number of 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.; ; (1) United Nations Population Division. World Population Prospects: 2017 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.; Weighted average;

This dataset is about countries per year in St. Lucia. It has 64 rows. It features 4 columns: country, birth rate, and death rate.