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

Belgium BE: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 25.940 % in 2022. This records a decrease from the previous number of 26.118 % for 2021. Belgium BE: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 27.184 % from Dec 1960 (Median) to 2022, with 63 observations. The data reached an all-time high of 38.002 % in 1967 and a record low of 25.592 % in 2008. Belgium BE: Age Dependency Ratio: % of Working-Age Population: Young data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Belgium – Table BE.World Bank.WDI: Population and Urbanization Statistics. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.;World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2022 Revision.;Weighted average;

Jordan JO: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 58.507 % in 2017. This records a decrease from the previous number of 59.207 % for 2016. Jordan JO: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 85.299 % from Dec 1960 (Median) to 2017, with 58 observations. The data reached an all-time high of 102.410 % in 1980 and a record low of 58.507 % in 2017. Jordan JO: Age Dependency Ratio: % of Working-Age Population: Young 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. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.; ; World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2017 Revision.; Weighted average;

France FR: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 29.074 % in 2017. This records a decrease from the previous number of 29.088 % for 2016. France FR: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 30.470 % from Dec 1960 (Median) to 2017, with 58 observations. The data reached an all-time high of 42.591 % in 1961 and a record low of 28.258 % in 2006. France FR: Age Dependency Ratio: % of Working-Age Population: Young data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s France – Table FR.World Bank: Population and Urbanization Statistics. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.; ; World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2017 Revision.; Weighted average;

Which county has the most Facebook users?

              There are more than 378 million Facebook users in India alone, making it the leading country in terms of Facebook audience size. To put this into context, if India’s Facebook audience were a country then it would be ranked third in terms of largest population worldwide. Apart from India, there are several other markets with more than 100 million Facebook users each: The United States, Indonesia, and Brazil with 193.8 million, 119.05 million, and 112.55 million Facebook users respectively.

              Facebook – the most used social media

              Meta, the company that was previously called Facebook, owns four of the most popular social media platforms worldwide, WhatsApp, Facebook Messenger, Facebook, and Instagram. As of the third quarter of 2021, there were around 3,5 billion cumulative monthly users of the company’s products worldwide. With around 2.9 billion monthly active users, Facebook is the most popular social media worldwide. With an audience of this scale, it is no surprise that the vast majority of Facebook’s revenue is generated through advertising.

              Facebook usage by device
              As of July 2021, it was found that 98.5 percent of active users accessed their Facebook account from mobile devices. In fact, almost 81.8 percent of Facebook audiences worldwide access the platform only via mobile phone. Facebook is not only available through mobile browser as the company has published several mobile apps for users to access their products and services. As of the third quarter 2021, the four core Meta products were leading the ranking of most downloaded mobile apps worldwide, with WhatsApp amassing approximately six billion downloads.

We assess the potential impact of international migration on population ageing in Asian countries by estimating replacement migration for the period 2022-2050.

This open data deposit contains the code (R-scripts) and the datasets (csv-files) for the replacement migration scenarios and a zero-migration scenario:

• Constant chronological old-age dependency ratio (Constant OADR scenario)
• Constant prospective old-age dependency ratio (Constant POADR scenario)
• Constant chronological working-age population (Constant WA scenario)
• Constant prospective working-age population (Constant PWA scenario)
• Zero-migration (ZM scenario)

Countries included in the analysis: Armenia, China, Georgia, Hong Kong, Japan, Macao, North Korea, Singapore, South Korea, Taiwan, Thailand.

Please note that for Armenia and Hong Kong (2023) and Georgia (2024) later baseline years are applied due to the UN country-specific assumptions on post-Covid-19 mortality.

For detailed information about the scenarios and parameters:

Dörflinger, M., Potancokova, M., Marois, G. (2024): The potential impact of international migration on prospective population ageing in Asian countries. Asian Population Studies. https://doi.org/10.1080/17441730.2024.2436201

All underlying data (UN World Population Prospects 2022) are openly available at:

https://population.un.org/wpp/Download/Archive

Code

1_Data.R:

• Load and merge data from UN World Population Prospects 2022
• Define sample
• Prepare data (prospective old-age thresholds, model sex and age pattern of migrants)

2_Scenarios.R:

• Replacement migration scenarios:
  • Constant chronological old-age dependency
  • Constant prospective old-age dependency
  • Constant chronological working-age population
  • Constant prospective working-age population
• Zero-migration scenario

3_Robustness_checks.R:

• Run replacement migrations scenarios with different model sex and age patterns for net migration

Program version used: RStudio "Chocolate Cosmos" (e4392fc9, 2024-06-05). Files may not be compatible with other versions.

Datasets

The datasets contain the key information on population size, the relevant indicators (OADR, POADR, WA, PWA) and replacement migration volumes and rates by country and year. Please see readme_datasets.txt for detailed information.

Acknowledgements

Part of the research was developed in the Young Scientists Summer Program at the International Institute for Applied Systems Analysis, Laxenburg (Austria) with financial support from the German National Member Organization.

During a 2024 survey, 77 percent of respondents from Nigeria stated that they used social media as a source of news. In comparison, just 23 percent of Japanese respondents said the same. Large portions of social media users around the world admit that they do not trust social platforms either as media sources or as a way to get news, and yet they continue to access such networks on a daily basis.

              Social media: trust and consumption

              Despite the majority of adults surveyed in each country reporting that they used social networks to keep up to date with news and current affairs, a 2018 study showed that social media is the least trusted news source in the world. Less than 35 percent of adults in Europe considered social networks to be trustworthy in this respect, yet more than 50 percent of adults in Portugal, Poland, Romania, Hungary, Bulgaria, Slovakia and Croatia said that they got their news on social media.

              What is clear is that we live in an era where social media is such an enormous part of daily life that consumers will still use it in spite of their doubts or reservations. Concerns about fake news and propaganda on social media have not stopped billions of users accessing their favorite networks on a daily basis.
              Most Millennials in the United States use social media for news every day, and younger consumers in European countries are much more likely to use social networks for national political news than their older peers.
              Like it or not, reading news on social is fast becoming the norm for younger generations, and this form of news consumption will likely increase further regardless of whether consumers fully trust their chosen network or not.

Tunisia TN: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 35.314 % in 2017. This records an increase from the previous number of 34.999 % for 2016. Tunisia TN: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 66.027 % from Dec 1960 (Median) to 2017, with 58 observations. The data reached an all-time high of 92.534 % in 1966 and a record low of 33.566 % in 2011. Tunisia TN: Age Dependency Ratio: % of Working-Age Population: Young data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Tunisia – Table TN.World Bank.WDI: Population and Urbanization Statistics. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.; ; World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2017 Revision.; Weighted average;

This dataset displays the number of television receivers by country for the time period covering 1990 through 1997. Covered throughout this dataset is 150+ countries, This dataset was gathered from the United Nations Statistics Division. http://unstats.un.org/unsd/databases.htm Access Date: October 31, 2007

This dataset shows where media and press are most free to express their views and opinions. Countries rankings are based on laws, violence, and deaths of reporters and journalists. This is a Different measure of freedom than the world freedom index but just as important. This dataset shows the availability of dissenting views and opinions allowed within a Country. In the 2006 Rankings the US Fell to 53rd position, bummer. pretty much the same countries were in the top positions, Denmark dropped a bit due to the Mohammed cartoons. Source URL: http://www.rsf.org/article.php3?id_article=19381

This dataset was derived from Swivel.com at: http://www.swivel.com/data_sets/show/1011482 Which cites the CIA Fact book as the official Source. https://www.cia.gov/library/publications/the-world-factbook/ Data is available for 60 countries around the world, and lists the Muslim Population for each. This data was collected on January 15, 2008.

This dataset tracks the average applied tariff rates in both industrial and developing countries. Data is averaged for the years 1981-2005. Figures for 2005 have been estimated. Notes: All tariff rates are based on unweighted averages for all goods in ad valorem rates, or applied rates, or MFN rates whichever data is available in a longer period. Tariff data is primarily based on UNCTAD TRAINS database and then used WTO IDB data for gap filling if possible. Data in 1980s is taken from other source.** Tariff data in these countries came from IMF Global Monitoring Tariff file in 2004 which might include other duties or charges. Country codes are based on the classifications by income in WDI 2006, where 1 = low income, 2 = middle income, 3 = high incone non-OECDs, and 4 = high income OECD countries. Sources: UNCTAD TRAINS database (through WITS); WTO IDB database (through WITS); WTO IDB CD ROMs, various years and Trade Policy Review -- Country Reports in various issues, 1990-2005; UNCTAD Handbook of Trade Control Measures of Developing Countries -- Supplement 1987 and Directory of Import Regimes 1994; World Bank Trade Policy Reform in Developing Countries since 1985, WB Discussion Paper #267, 1994 and World Development Indicators, 1998-2006; The Uruguay Round: Statistics on Tariffs Concessions Given and Received, 1996; OECD Indicators of Tariff and Non-Tariff Trade Barriers, 1996 and 2000; and IMF Global Monitoring Tariff data file 2004. Data source: http://go.worldbank.org/LGOXFTV550 Access Date: October 17, 2007

Serbia RS: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 24.863 % in 2017. This records a decrease from the previous number of 24.883 % for 2016. Serbia RS: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 28.960 % from Dec 1990 (Median) to 2017, with 28 observations. The data reached an all-time high of 35.673 % in 1990 and a record low of 24.863 % in 2017. Serbia RS: Age Dependency Ratio: % of Working-Age Population: Young data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Serbia – Table RS.World Bank.WDI: Population and Urbanization Statistics. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.; ; World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2017 Revision.; Weighted average;

Switzerland is leading the ranking by population share with mobile internet access, recording 95.06 percent. Following closely behind is Ukraine with 95.06 percent, while Moldova is trailing the ranking with 46.83 percent, resulting in a difference of 48.23 percentage points to the ranking leader, Switzerland. The penetration rate refers to the share of the total population having access to the internet via a mobile broadband connection. The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).

This dataset displays the annual US import of pork. This is measured in carcass weight by 1000 pound scale. The data is available from 2003 - January of 2008.

All the data for this dataset is provided from CARMA: Data from CARMA (www.carma.org) This dataset provides information about Power Plant emissions in Hungary. Power Plant emissions from all power plants in Hungary were obtained by CARMA for the past (2000 Annual Report), the present (2007 data), and the future. CARMA determine data presented for the future to reflect planned plant construction, expansion, and retirement. The dataset provides the name, company, parent company, city, state, zip, county, metro area, lat/lon, and plant id for each individual power plant. The dataset reports for the three time periods: Intensity: Pounds of CO2 emitted per megawatt-hour of electricity produced. Energy: Annual megawatt-hours of electricity produced. Carbon: Annual carbon dioxide (CO2) emissions. The units are short or U.S. tons. Multiply by 0.907 to get metric tons. Carbon Monitoring for Action (CARMA) is a massive database containing information on the carbon emissions of over 50,000 power plants and 4,000 power companies worldwide. Power generation accounts for 40% of all carbon emissions in the United States and about one-quarter of global emissions. CARMA is the first global inventory of a major, sector of the economy. The objective of CARMA.org is to equip individuals with the information they need to forge a cleaner, low-carbon future. By providing complete information for both clean and dirty power producers, CARMA hopes to influence the opinions and decisions of consumers, investors, shareholders, managers, workers, activists, and policymakers. CARMA builds on experience with public information disclosure techniques that have proven successful in reducing traditional pollutants. Please see carma.org for more information

Denmark DK: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 25.824 % in 2017. This records a decrease from the previous number of 25.939 % for 2016. Denmark DK: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 28.170 % from Dec 1960 (Median) to 2017, with 58 observations. The data reached an all-time high of 39.271 % in 1960 and a record low of 25.277 % in 1990. Denmark DK: Age Dependency Ratio: % of Working-Age Population: Young data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Denmark – Table DK.World Bank: Population and Urbanization Statistics. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.; ; World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2017 Revision.; Weighted average;

Laos LA: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 52.127 % in 2017. This records a decrease from the previous number of 52.996 % for 2016. Laos LA: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 78.144 % from Dec 1960 (Median) to 2017, with 58 observations. The data reached an all-time high of 85.940 % in 1993 and a record low of 52.127 % in 2017. Laos LA: Age Dependency Ratio: % of Working-Age Population: Young data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Laos – Table LA.World Bank.WDI: Population and Urbanization Statistics. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.; ; World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2017 Revision.; Weighted average;

China is leading the ranking by number of smartphone users, recording ****** million users. Following closely behind is India with ****** million users, while Seychelles is trailing the ranking with **** million users, resulting in a difference of ****** million users to the ranking leader, China. Smartphone users here are limited to internet users of any age using a smartphone. The shown figures have been derived from survey data that has been processed to estimate missing demographics.The shown data are an excerpt of Statista's Key Market Indicators (KMI). The KMI are a collection of primary and secondary indicators on the macro-economic, demographic and technological environment in up to 150 countries and regions worldwide. All indicators are sourced from international and national statistical offices, trade associations and the trade press and they are processed to generate comparable data sets (see supplementary notes under details for more information).

Slovenia SI: Age Dependency Ratio: % of Working-Age Population: Young data was reported at 23.518 % in 2023. This records a decrease from the previous number of 23.648 % for 2022. Slovenia SI: Age Dependency Ratio: % of Working-Age Population: Young data is updated yearly, averaging 29.359 % from Dec 1960 (Median) to 2023, with 64 observations. The data reached an all-time high of 42.070 % in 1961 and a record low of 20.037 % in 2007. Slovenia SI: Age Dependency Ratio: % of Working-Age Population: Young data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Slovenia – Table SI.World Bank.WDI: Population and Urbanization Statistics. Age dependency ratio, young, is the ratio of younger dependents--people younger than 15--to the working-age population--those ages 15-64. Data are shown as the proportion of dependents per 100 working-age population.;World Bank staff estimates based on age distributions of United Nations Population Division's World Population Prospects: 2022 Revision.;Weighted average;