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.

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 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.

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 is about countries per year in St. Lucia. It has 64 rows. It features 4 columns: country, birth rate, and death rate.

China Fertility Rate of Childbearing Women data was reported at 3.127 % in 2021. This records a decrease from the previous number of 3.726 % for 2020. China Fertility Rate of Childbearing Women data is updated yearly, averaging 3.730 % from Dec 1999 (Median) to 2021, with 22 observations. The data reached an all-time high of 4.703 % in 2017 and a record low of 2.975 % in 2011. China Fertility Rate of Childbearing Women 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.

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;

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.

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.

Live births by usual residence of mother, and General Fertility Rates (GFR), and Deaths and Standardised Mortality Ratio (SMR) by ward and local authority.

The births and deaths data comes from ONS Vital Statistics Table 4.
Small area data is only available directly from ONS under licence.

The general fertility rate (GFR) is the number of live births per 1,000 women aged 15-44.

SMR measures whether the population of an area has a higher or lower number of deaths than expected based on the age profile of the population (more deaths are expected in older populations). The SMR is defined as follows: SMR = (Observed no. of deaths per year)/(Expected no. of deaths per year).

Rates are provisional, they are based on the GLA 2011 based SHLAA ward projections (standard) released in January 2012. At national level, however, they are based on the mid-year population estimates.

More information is on the ONS website.

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

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

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.

Infant Death Rate - This indicator shows the infant mortality rate per 1,000 live births. Infant mortality has long been considered the most sensitive indicator of the overall health of a population. While there have been several decades of improvement in infant mortality, Maryland’s rate remains higher than the national average. Link to Data Details

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.

China Fertility Rate of Childbearing Women: 1st Birth data was reported at 1.417 % in 2021. This records a decrease from the previous number of 1.705 % for 2020. China Fertility Rate of Childbearing Women: 1st Birth data is updated yearly, averaging 2.232 % from Dec 1999 (Median) to 2021, with 22 observations. The data reached an all-time high of 3.170 % in 1999 and a record low of 1.417 % in 2021. China Fertility Rate of Childbearing Women: 1st Birth 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.

The Mortality - Infant Deaths (from Linked Birth / Infant Death Records) online databases on CDC WONDER provide counts and rates for deaths of children under 1 year of age, occuring within the United States to U.S. residents. Information from death certificates has been linked to corresponding birth certificates. Data are available by county of mother's residence, child's age, underlying cause of death, sex, birth weight, birth plurality, birth order, gestational age at birth, period of prenatal care, maternal race and ethnicity, maternal age, maternal education and marital status. Data are available since 1995. The data are produced by the National Center for Health Statistics.

This data presents national-level provisional maternal mortality rates based on a current flow of mortality and natality data in the National Vital Statistics System. Provisional rates which are an early estimate of the number of maternal deaths per 100,000 live births, are shown as of the date specified and may not include all deaths and births that occurred during a given time period (see Technical Notes). A maternal death is the death of a woman while pregnant or within 42 days of termination of pregnancy irrespective of the duration and the site of the pregnancy, from any cause related to or aggravated by the pregnancy or its management, but not from accidental or incidental causes. In this data visualization, maternal deaths are those deaths with an underlying cause of death assigned to International Statistical Classification of Diseases, 10th Revision (ICD-10) code numbers A34, O00–O95, and O98–O99. The provisional data include reported 12 month-ending provisional maternal mortality rates overall, by age, and by race and Hispanic origin. Provisional maternal mortality rates presented in this data visualization are for “12-month ending periods,” defined as the number of maternal deaths per 100,000 live births occurring in the 12-month period ending in the month indicated. For example, the 12-month ending period in June 2020 would include deaths and births occurring from July 1, 2019, through June 30, 2020. Evaluation of trends over time should compare estimates from year to year (June 2020 and June 2021), rather than month to month, to avoid overlapping time periods. In the visualization and in the accompanying data file, rates based on death counts less than 20 are suppressed in accordance with current NCHS standards of reliability for rates. Death counts between 1-9 in the data file are suppressed in accordance with National Center for Health Statistics (NCHS) confidentiality standards. Provisional data presented on this page will be updated on a quarterly basis as additional records are received. Previously released estimates are revised to include data and record updates received since the previous release. As a result, the reliability of estimates for a 12-month period ending with a specific month will improve with each quarterly release and estimates for previous time periods may change as new data and updates are received.

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

Data on infant, neonatal, postneonatal, fetal, and perinatal mortality rates by selected characteristics of the mother. Please refer to the PDF or Excel version of this table in the HUS 2019 Data Finder (https://www.cdc.gov/nchs/hus/contents2019.htm) for critical information about measures, definitions, and changes over time. SOURCE: NCHS, National Vital Statistics System, public-use Linked Birth/Infant Death Data Set, public-use Fetal Death File, and public-use Birth File. For more information on the National Vital Statistics System, see the corresponding Appendix entry at https://www.cdc.gov/nchs/data/hus/hus19-appendix-508.pdf.