Copy of https://www.kaggle.com/datasets/kisoibo/countries-databasesqlite

Updated the name of the table from 'countries of the world' to 'countries', for ease of writing queries.

Info about the dataset:

Content

Table Total Rows Total Columns countries of the world **0 ** ** 20** Country, Region, Population, Area (sq. mi.), Pop. Density (per sq. mi.), Coastline (coast/area ratio), Net migration, Infant mortality (per 1000 births), GDP ($ per capita), Literacy (%), Phones (per 1000), Arable (%), Crops (%), Other (%), Climate, Birthrate, Deathrate, Agriculture, Industry, Service

Acknowledgements

Acknowledgements Source: All these data sets are made up of data from the US government. Generally they are free to use if you use the data in the US. If you are outside of the US, you may need to contact the US Govt to ask. Data from the World Factbook is public domain. The website says "The World Factbook is in the public domain and may be used freely by anyone at anytime without seeking permission." https://www.cia.gov/library/publications/the-world-factbook/docs/faqs.html

Inspiration

When making visualisations related to countries, sometimes it is interesting to group them by attributes such as region, or weigh their importance by population, GDP or other variables.

Trends in Covid vaccinated people per hundred people. The latest data for over 100 countries around the world.

This statistic shows the international migrant stock worldwide as a percentage of the global population from 1990 to 2015. In 2015, the international migrant stock accounted fro *** of the world population.

All cities with a population > 1000 or seats of adm div (ca 80.000)Sources and ContributionsSources : GeoNames is aggregating over hundred different data sources. Ambassadors : GeoNames Ambassadors help in many countries. Wiki : A wiki allows to view the data and quickly fix error and add missing places. Donations and Sponsoring : Costs for running GeoNames are covered by donations and sponsoring.Enrichment:add country name

Worldwide, around 5.8 billion people were living in countries classified as autocracies in 2024. Parts of this is down to the fact that the world's two most populous countries, China and India, who both count around 1.4 billion inhabitants, are classified as a closed autocracy and electoral autocracy, respectively. Similarly, the large increase in people living in autocracies in 2017 is because India was downgraded from an electoral democracy to an electoral autocracy that year.

The Gridded Population of the World, Version 3 (GPWv3): Centroids consists of estimates of human population counts and densities for the years 1990, 1995, 2000, 2005, 2010, and 2015 by administrative Unit centroid location. The centroids are based on the 399,781 input administrative Units used in GPWv3. In addition to population counts and variables, the centroids have associated administrative Unit names and the land area of contained within the administrative Unit. GPWv3 is produced by the Columbia University Center for International Earth Science Information Network (CIESIN) in collaboration with Centro Internacional de Agricultura Tropical (CIAT).

Population, female (% of total population) in World was reported at 49.72 % in 2024, according to the World Bank collection of development indicators, compiled from officially recognized sources. World - Population, female (% of total) - actual values, historical data, forecasts and projections were sourced from the World Bank on August of 2025.

The Gridded Population of the World, Version 4 (GPWv4): Population Density, Revision 11 consists of estimates of human population density (number of persons per square kilometer) based on counts consistent with national censuses and population registers, for the years 2000, 2005, 2010, 2015, and 2020. A proportional allocation gridding algorithm, utilizing approximately 13.5 million national and sub-national administrative units, was used to assign population counts to 30 arc-second grid cells. The population density rasters were created by dividing the population count raster for a given target year by the land area raster. The data files were produced as global rasters at 30 arc-second (~1 km at the equator) resolution.

Purpose: To provide estimates of population density for the years 2000, 2005, 2010, 2015, and 2020, based on counts consistent with national censuses and population registers, as raster data to facilitate data integration.

Recommended Citation(s)*: Center for International Earth Science Information Network - CIESIN - Columbia University. 2018. Gridded Population of the World, Version 4 (GPWv4): Population Density, Revision 11. Palisades, NY: NASA Socioeconomic Data and Applications Center (SEDAC). https://doi.org/10.7927/H49C6VHW. Accessed DAY MONTH YEAR.

As of February 2025, India was the country with the largest offline population worldwide. The South Asian country had over 651 million people without internet connection. China ranked second, with around 311.9 million people not connected to the internet. Despite these large shares of the disconnected population in these countries, China and India ranked first and second, respectively, as countries with the highest number of internet users worldwide. Internet access in Africa In 2023, Africa lagged behind other global regions regarding internet penetration rate, as only 37 percent of the continent’s population accessed the web. In contrast, around 91 percent of Europe’s population were internet users. This is heavily influenced by the infrastructure development in the region. However, some improvements are forecasted, as by 2028, the internet penetration rate in Africa will be at an estimated 48.15 percent. Global internet access challenges: disruptions and restrictions Government internet shutdowns around the world are another challenge for internet access. Between 2015 and the first half of 2023, 172 local internet connection disruptions occurred due to protests globally. Moreover, according to a 2023report on internet freedom, almost four out of ten global internet users were deprived of essential freedoms on online platforms. In 2023, 76 new restrictions on internet usage were implemented worldwide. Asia led in imposing these restrictions, accounting for approximately 55 cases across various countries in the region.

The Gridded Population of the World, Version 4 (GPWv4): Administrative Unit Center Points with Population Estimates, Revision 11 consists of UN WPP-adjusted population estimates and densities for the years 2000, 2005, 2010, 2015 and 2020, as well as the basic demographic characteristics (age and sex) for the year 2010. The data set also includes administrative name, land and water area, and data context by administrative Unit center point (centroid) location. The center points are based on approximately 13.5 million input administrative Units used in GPWv4, therefore, these files require hardware and software that can read large amounts of data into memory.

According to a survey published by IPSOS in 2019, ** percent of respondents worldwide believed that the revolution in digital technology will transform their country's democracy for the better. ** percent of respondents from India believed that technology will change their democracy for the better, compared to only ** percent of Japanese respondents who said the same.

Researchers in R&D (per million people) in World was reported at 1516 in 2018, according to the World Bank collection of development indicators, compiled from officially recognized sources. World - Researchers in R&D (per million people) - actual values, historical data, forecasts and projections were sourced from the World Bank on September of 2025.

Abstract

Well-functioning financial systems serve a vital purpose, offering savings, credit, payment, and risk management products to people with a wide range of needs. Yet until now little had been known about the global reach of the financial sector - the extent of financial inclusion and the degree to which such groups as the poor, women, and youth are excluded from formal financial systems. Systematic indicators of the use of different financial services had been lacking for most economies.

The Global Financial Inclusion (Global Findex) database provides such indicators. This database contains the first round of Global Findex indicators, measuring how adults in more than 140 economies save, borrow, make payments, and manage risk. The data set can be used to track the effects of financial inclusion policies globally and develop a deeper and more nuanced understanding of how people around the world manage their day-to-day finances. By making it possible to identify segments of the population excluded from the formal financial sector, the data can help policy makers prioritize reforms and design new policies.

Geographic coverage

National Coverage.

Analysis unit

Individual

Universe

The target population is the civilian, non-institutionalized population 15 years and above. The sample is nationally representative.

Kind of data

Sample survey data [ssd]

Sampling procedure

The Global Findex indicators are drawn from survey data collected by Gallup, Inc. over the 2011 calendar year, covering more than 150,000 adults in 148 economies and representing about 97 percent of the world's population. Since 2005, Gallup has surveyed adults annually around the world, using a uniform methodology and randomly selected, nationally representative samples. The second round of Global Findex indicators was collected in 2014 and is forthcoming in 2015. The set of indicators will be collected again in 2017.

Surveys were conducted face-to-face in economies where landline telephone penetration is less than 80 percent, or where face-to-face interviewing is customary. The first stage of sampling is the identification of primary sampling units, consisting of clusters of households. The primary sampling units are stratified by population size, geography, or both, and clustering is achieved through one or more stages of sampling. Where population information is available, sample selection is based on probabilities proportional to population size; otherwise, simple random sampling is used. Random route procedures are used to select sampled households. Unless an outright refusal occurs, interviewers make up to three attempts to survey the sampled household. If an interview cannot be obtained at the initial sampled household, a simple substitution method is used. Respondents are randomly selected within the selected households by means of the Kish grid.

Surveys were conducted by telephone in economies where landline telephone penetration is over 80 percent. The telephone surveys were conducted using random digit dialing or a nationally representative list of phone numbers. In selected countries where cell phone penetration is high, a dual sampling frame is used. Random respondent selection is achieved by using either the latest birthday or Kish grid method. At least three attempts are made to teach a person in each household, spread over different days and times of year.

The sample size in Latvia was 1,006 individuals.

Mode of data collection

Face-to-face [f2f]

Research instrument

The questionnaire was designed by the World Bank, in conjunction with a Technical Advisory Board composed of leading academics, practitioners, and policy makers in the field of financial inclusion. The Bill and Melinda Gates Foundation and Gallup, Inc. also provided valuable input. The questionnaire was piloted in over 20 countries using focus groups, cognitive interviews, and field testing. The questionnaire is available in 142 languages upon request.

Questions on insurance, mobile payments, and loan purposes were asked only in developing economies. The indicators on awareness and use of microfinance insitutions (MFIs) are not included in the public dataset. However, adults who report saving at an MFI are considered to have an account; this is reflected in the composite account indicator.

Sampling error estimates

Estimates of standard errors (which account for sampling error) vary by country and indicator. For country- and indicator-specific standard errors, refer to the Annex and Country Table in Demirguc-Kunt, Asli and L. Klapper. 2012. "Measuring Financial Inclusion: The Global Findex." Policy Research Working Paper 6025, World Bank, Washington, D.C.

The Gridded Population of the World, Version 3 (GPWv3): National Administrative Boundaries are derived from the land area grid to show the outlines of pixels (cells) that contain administrative Units in GPWv3 on a per-country/territory basis. The National Boundaries data are derived from the pixels as polygons and thus have rectilinear boundaries at large scale. Note that the polygons that outline the countries and territories are not official representations; rather, they represent the area covered by the statistical data as provided. The national/territorial boundaries are designed for cartographic use with the GPWv3 population raster data sets. GPWv3 is produced by the Columbia University Center for International Earth Science Information Network (CIESIN) in collaboration with Centro Internacional de Agricultura Tropical (CIAT).

Context

The World Bank is an international financial institution that provides loans to countries of the world for capital projects. The World Bank's stated goal is the reduction of poverty. Source: https://en.wikipedia.org/wiki/World_Bank

Content

This dataset combines key education statistics from a variety of sources to provide a look at global literacy, spending, and access.

For more information, see the World Bank website.

Fork this kernel to get started with this dataset.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:world_bank_health_population

http://data.worldbank.org/data-catalog/ed-stats

https://cloud.google.com/bigquery/public-data/world-bank-education

Citation: The World Bank: Education Statistics

Dataset Source: World Bank. 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.

Banner Photo by @till_indeman from Unplash.

Inspiration

Of total government spending, what percentage is spent on education?

Content

The Global Financial Inclusion Database provides 800 country-level indicators of financial inclusion summarized for all adults and disaggregated by key demographic characteristics-gender, age, education, income, and rural residence. Covering more than 140 economies, the indicators of financial inclusion measure how people save, borrow, make payments and manage risk.

The reference citation for the data is: Demirguc-Kunt, Asli, Leora Klapper, Dorothe Singer, and Peter Van Oudheusden. 2015. “The Global Findex Database 2014: Measuring Financial Inclusion around the World.” Policy Research Working Paper 7255, World Bank, Washington, DC.

Context

This is a dataset hosted by the World Bank. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore the World Bank using Kaggle and all of the data sources available through the World Bank organization page!

• Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using the World Bank's APIs and Kaggle's API.

Cover photo by ZACHARY STAINES on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Global Population of the World (GPW) translates census population data to a latitude-longitude grid so that population data may be used in cross-disciplinary studies. There are three data files with this data set for the reference years 1990 and 1995. Over 127,000 administrative units and population counts were collected and integrated from various sources to create the gridded data. In brief, GPW was created using the following steps: * Population data were estimated for the product reference years, 1990 and 1995, either by the data source or by interpolating or extrapolating the given estimates for other years. * Additional population estimates were created by adjusting the source population data to match UN national population estimates for the reference years. * Borders and coastlines of the spatial data were matched to the Digital Chart of the World where appropriate and lakes from the Digital Chart of the World were added. * The resulting data were then transformed into grids of UN-adjusted and unadjusted population counts for the reference years. * Grids containing the area of administrative boundary data in each cell (net of lakes) were created and used with the count grids to produce population densities.As with any global data set based on multiple data sources, the spatial and attribute precision of GPW is variable. The level of detail and accuracy, both in time and space, vary among the countries for which data were obtained.

The average for 2020 based on 123 countries was 0.81 percent. The highest value was in France: 19.29 percent and the lowest value was in Bhutan: 0 percent. The indicator is available from 1995 to 2020. Below is a chart for all countries where data are available.

Graph and download economic data for Population Growth for Developing Countries in Europe and Central Asia (SPPOPGROWECA) from 1961 to 2024 about Central Asia, Europe, population, and rate.

The average for 2024 based on 138 countries was 5.56 points. The highest value was in Finland: 7.74 points and the lowest value was in Afghanistan: 1.72 points. The indicator is available from 2013 to 2024. Below is a chart for all countries where data are available.