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

The world population surpassed eight billion people in 2022, having doubled from its figure less than 50 years previously. Looking forward, it is projected that the world population will reach nine billion in 2038, and 10 billion in 2060, but it will peak around 10.3 billion in the 2080s before it then goes into decline. Regional variations The global population has seen rapid growth since the early 1800s, due to advances in areas such as food production, healthcare, water safety, education, and infrastructure, however, these changes did not occur at a uniform time or pace across the world. Broadly speaking, the first regions to undergo their demographic transitions were Europe, North America, and Oceania, followed by Latin America and Asia (although Asia's development saw the greatest variation due to its size), while Africa was the last continent to undergo this transformation. Because of these differences, many so-called "advanced" countries are now experiencing population decline, particularly in Europe and East Asia, while the fastest population growth rates are found in Sub-Saharan Africa. In fact, the roughly two billion difference in population between now and the 2080s' peak will be found in Sub-Saharan Africa, which will rise from 1.2 billion to 3.2 billion in this time (although populations in other continents will also fluctuate). Changing projections The United Nations releases their World Population Prospects report every 1-2 years, and this is widely considered the foremost demographic dataset in the world. However, recent years have seen a notable decline in projections when the global population will peak, and at what number. Previous reports in the 2010s had suggested a peak of over 11 billion people, and that population growth would continue into the 2100s, however a sooner and shorter peak is now projected. Reasons for this include a more rapid population decline in East Asia and Europe, particularly China, as well as a prolongued development arc in Sub-Saharan Africa.

Historical chart and dataset showing World population growth rate by year from 1961 to 2023.

The increased world population is among the fierce problems the world is facing right now and it will get uncontrolled in the coming future if proper steps for its betterment were not taken immediately. This world has observed the fastest growth during the 20th century. In the 1950s world population was 2.7 billion, By the end of this year it will cross 8 billion. This dataset is uploaded with the assumption to use your Data Science, Machine learning, and Predictive analytics skills and answer the following questions. 1. Which countries have the highest growth rate. 2. What are the densely populated countries in the world. 3. Keeping in view all the variables in mind which countries should take serious steps to control their population.

Context

This is a dataset of the most highly populated city (if applicable) in a form easy to join with the COVID19 Global Forecasting (Week 1) dataset. You can see how to use it in this kernel

Content

There are four columns. The first two correspond to the columns from the original COVID19 Global Forecasting (Week 1) dataset. The other two is the highest population density, at city level, for the given country/state. Note that some countries are very small and in those cases the population density reflects the entire country. Since the original dataset has a few cruise ships as well, I've added them there.

Acknowledgements

Thanks a lot to Kaggle for this competition that gave me the opportunity to look closely at some data and understand this problem better.

Inspiration

Summary: I believe that the square root of the population density should relate to the logistic growth factor of the SIR model. I think the SEIR model isn't applicable due to any intervention being too late for a fast-spreading virus like this, especially in places with dense populations.

After playing with the data provided in COVID19 Global Forecasting (Week 1) (and everything else online or media) a bit, one thing becomes clear. They have nothing to do with epidemiology. They reflect sociopolitical characteristics of a country/state and, more specifically, the reactivity and attitude towards testing.

The testing method used (PCR tests) means that what we measure could potentially be a proxy for the number of people infected during the last 3 weeks, i.e the growth (with lag). It's not how many people have been infected and recovered. Antibody or serology tests would measure that, and by using them, we could go back to normality faster... but those will arrive too late. Way earlier, China will have experimentally shown that it's safe to go back to normal as soon as your number of newly infected per day is close to zero.

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F197482%2F429e0fdd7f1ce86eba882857ac7a735e%2Fcovid-summary.png?generation=1585072438685236&alt=media" alt="">

My view, as a person living in NYC, about this virus, is that by the time governments react to media pressure, to lockdown or even test, it's too late. In dense areas, everyone susceptible has already amble opportunities to be infected. Especially for a virus with 5-14 days lag between infections and symptoms, a period during which hosts spread it all over on subway, the conditions are hopeless. Active populations have already been exposed, mostly asymptomatic and recovered. Sensitive/older populations are more self-isolated/careful in affluent societies (maybe this isn't the case in North Italy). As the virus finishes exploring the active population, it starts penetrating the more isolated ones. At this point in time, the first fatalities happen. Then testing starts. Then the media and the lockdown. Lockdown seems overly effective because it coincides with the tail of the disease spread. It helps slow down the virus exploring the long-tail of sensitive population, and we should all contribute by doing it, but it doesn't cause the end of the disease. If it did, then as soon as people were back in the streets (see China), there would be repeated outbreaks.

Smart politicians will test a lot because it will make their condition look worse. It helps them demand more resources. At the same time, they will have a low rate of fatalities due to large denominator. They can take credit for managing well a disproportionally major crisis - in contrast to people who didn't test.

We were lucky this time. We, Westerners, have woken up to the potential of a pandemic. I'm sure we will give further resources for prevention. Additionally, we will be more open-minded, helping politicians to have more direct responses. We will also require them to be more responsible in their messages and reactions.

Estimated number of persons by quarter of a year and by year, Canada, provinces and territories.

The statistic shows the total population of India from 2019 to 2029. In 2023, the estimated total population in India amounted to approximately 1.43 billion people.

Total population in India

India currently has the second-largest population in the world and is projected to overtake top-ranking China within forty years. Its residents comprise more than one-seventh of the entire world’s population, and despite a slowly decreasing fertility rate (which still exceeds the replacement rate and keeps the median age of the population relatively low), an increasing life expectancy adds to an expanding population. In comparison with other countries whose populations are decreasing, such as Japan, India has a relatively small share of aged population, which indicates the probability of lower death rates and higher retention of the existing population.

With a land mass of less than half that of the United States and a population almost four times greater, India has recognized potential problems of its growing population. Government attempts to implement family planning programs have achieved varying degrees of success. Initiatives such as sterilization programs in the 1970s have been blamed for creating general antipathy to family planning, but the combined efforts of various family planning and contraception programs have helped halve fertility rates since the 1960s. The population growth rate has correspondingly shrunk as well, but has not yet reached less than one percent growth per year.

As home to thousands of ethnic groups, hundreds of languages, and numerous religions, a cohesive and broadly-supported effort to reduce population growth is difficult to create. Despite that, India is one country to watch in coming years. It is also a growing economic power; among other measures, its GDP per capita was expected to triple between 2003 and 2013 and was listed as the third-ranked country for its share of the global gross domestic product.

This paper presents the largest globally comparable panel database of education quality. The database includes 163 countries and regions over 1965-2015. The globally comparable achievement outcomes were constructed by linking standardized, psychometrically-robust international and regional achievement tests. The paper contributes to the literature in the following ways: (1) it is the largest and most current globally comparable data set, covering more than 90 percent of the global population; (2) the data set includes 100 developing areas and the most developing countries included in such a data set to date -- the countries that have the most to gain from the potential benefits of a high-quality education; (3) the data set contains credible measures of globally comparable achievement distributions as well as mean scores; (4) the data set uses multiple methods to link assessments, including mean and percentile linking methods, thus enhancing the robustness of the data set; (5) the data set includes the standard errors for the estimates, enabling explicit quantification of the degree of reliability of each estimate; and (6) the data set can be disaggregated across gender, socioeconomic status, rural/urban, language, and immigration status, thus enabling greater precision and equity analysis. A first analysis of the data set reveals a few important trends: learning outcomes in developing countries are often clustered at the bottom of the global scale; although variation in performance is high in developing countries, the top performers still often perform worse than the bottom performers in developed countries; gender gaps are relatively small, with high variation in the direction of the gap; and distributions reveal meaningfully different trends than mean scores, with less than 50 percent of students reaching the global minimum threshold of proficiency in developing countries relative to 86 percent in developed countries. The paper also finds a positive and significant association between educational achievement and economic growth. The data set can be used to benchmark global progress on education quality, as well as to uncover potential drivers of education quality, growth, and development.

PART I: Distribution table: Interval Frequency Cumulative Frequency Percentage distribution Cumulative percentage distribution 10-12 2 2 13.33 13.33 12.1-14 5 7 33.33 46.66 14.1-16 8 15 53.33 99.99 16.1-18 0 15 0 99.99

18.1 0 15 0 99.99

Majority of the countries, eight, fall in the 14.1-16 category. Five countries fall in the 12.1-14 category and two countries in the 10-12 bin. The remaining categories have zero entries. This means the data does not follow a normal distribution since most of the countries are concentrated at the highest peak. This data could be better visualized in a histogram.

Frequency distribution with revised interval: Interval Frequency Cumulative Frequency Percentage Frequency Cumulative percentage <12 2 2 13.33 13.33 12-12.9 1 3 6.67 20 13-13.9 4 7 26.67 46.67 14-14.9 4 11 26.67 73.34 15-15.9 3 14 20 93.34 16-16.9 1 15 6.67 100.01 17-17.9 0 15 0 100.01

18 0 15 0 100.01 Eight countries have between 14% and 18% of their population above age 65. The number of countries with 14% - 18% of their population above 65 years remain the same even after revising the interval. The percentage of countries that have between 14-18 percent of their population above age 65 is 53.33%.

PART II Q1. Time series chart for divorce rate in Netherlands

Q2. Describe divorce rate in Netherlands before and after 1970. There is a decline in divorce rate between 1950 and 1960. There is a moderate rise in divorce rate between 1960 and 1970, the rate steadily rises between 1970 and 1980 and thereafter exhibits a slight decline between 1980 and 1990. The rate shifts to a declining trend after the year 2000. The decline does not indicate negative number of divorces, this could be attributed to increased population size and fewer number of divorce cases filed. Q3. A bar graph would best display the divorce rate for each year, hence easy comparison. Q4. Bar graph The highest number of divorce cases were recorded in the year 2000, while the least number was observed in 1960.

Set 2: Show how different elements contributed to population change in 2018

Immigration contributed 34 percent of the change in population; births, Emigration, and deaths contributed almost equal change in population.

Q2. Elements of population growth

Immigration contributed the largest change in population growth compared to birth.

Q3. A time series to show changes in male and female population

Both populations show an increasing trend over the 4 years. We could also conclude there are more females than males in the country’s population.

As of April 2024, Bahrain was the country with the highest Instagram audience reach with 95.6 percent. Kazakhstan also had a high Instagram audience penetration rate, with 90.8 percent of the population using the social network. In the United Arab Emirates, Turkey, and Brunei, the photo-sharing platform was used by more than 85 percent of each country's population.

As of April 2024, Facebook had an addressable ad audience reach 131.1 percent in Libya, followed by the United Arab Emirates with 120.5 percent and Mongolia with 116 percent. Additionally, the Philippines and Qatar had addressable ad audiences of 114.5 percent and 111.7 percent.

As of July 2024, Nigeria's population was estimated at around 229.5 million. Between 1965 and 2024, the number of people living in Nigeria increased at an average rate of over two percent. In 2024, the population grew by 2.42 percent compared to the previous year. Nigeria is the most populous country in Africa. By extension, the African continent records the highest growth rate in the world. Africa's most populous country Nigeria was the most populous country in Africa as of 2023. As of 2022, Lagos held the distinction of being Nigeria's biggest urban center, a status it also retained as the largest city across all of sub-Saharan Africa. The city boasted an excess of 17.5 million residents. Notably, Lagos assumed the pivotal roles of the nation's primary financial hub, cultural epicenter, and educational nucleus. Furthermore, Lagos was one of the largest urban agglomerations in the world. Nigeria's youthful population In Nigeria, a significant 50 percent of the populace is under the age of 19. The most prominent age bracket is constituted by those up to four years old: comprising 8.3 percent of men and eight percent of women as of 2021. Nigeria boasts one of the world's most youthful populations. On a broader scale, both within Africa and internationally, Niger maintains the lowest median age record. Nigeria secures the 20th position in global rankings. Furthermore, the life expectancy in Nigeria is an average of 62 years old. However, this is different between men and women. The main causes of death have been neonatal disorders, malaria, and diarrheal diseases.

The population share with mobile internet access in North America was forecast to increase between 2024 and 2029 by in total 2.9 percentage points. This overall increase does not happen continuously, notably not in 2028 and 2029. The mobile internet penetration is estimated to amount to 84.21 percent in 2029. Notably, the population share with mobile internet access of was continuously increasing over the past years.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).Find more key insights for the population share with mobile internet access in countries like Caribbean and Europe.

The online banking penetration rate in Africa was forecast to continuously increase between 2024 and 2029 by in total 5.2 percentage points. After the fifteenth consecutive increasing year, the online banking penetration is estimated to reach 13.25 percent and therefore a new peak in 2029. Notably, the online banking penetration rate of was continuously increasing over the past years.Shown is the estimated percentage of the total population in a given region or country, which makes use of online banking.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).Find more key insights for the online banking penetration rate in countries like North America and Europe.

The global number of smartphone users in was forecast to continuously increase between 2024 and 2029 by in total 1.8 billion users (+42.62 percent). After the ninth consecutive increasing year, the smartphone user base is estimated to reach 6.1 billion users and therefore a new peak in 2029. Notably, the number of smartphone users of was continuously increasing over the past years.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).Find more key insights for the number of smartphone users in countries like Australia & Oceania and Asia.