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 provides values for GDP reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

This dataset provides values for GOLD RESERVES reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

Cross-national research on the causes and consequences of income inequality has been hindered by the limitations of existing inequality datasets: greater coverage across countries and over time is available from these sources only at the cost of significantly reduced comparability across observations. The goal of the Standardized World Income Inequality Database (SWIID) is to overcome these limitations. A custom missing-data algorithm was used to standardize the United Nations University's World Income Inequality Database and data from other sources; data collected by the Luxembourg Income Study served as the standard. The SWIID provides comparable Gini indices of gross and net income inequality for 192 countries for as many years as possible from 1960 to the present along with estimates of uncertainty in these statistics. By maximizing comparability for the largest possible sample of countries and years, the SWIID is better suited to broadly cross-national research on income inequality than previously available sources: it offers coverage double that of the next largest income inequality dataset, and its record of comparability is three to eight times better than those of alternate datasets. In any papers or publications that use the SWIID, authors are asked to cite the article of record for the data set and give the version number as follows: Solt, Frederick. 2016. "The Standardized World Income Inequality Database." Social Science Quarterly 97(5):1267-1281. SWIID Version 7.1, August 2018.

This dataset provides values for GDP reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

Techsalerator’s Import/Export Trade Data for North America

Techsalerator’s Import/Export Trade Data for North America delivers an exhaustive and nuanced analysis of trade activities across the North American continent. This extensive dataset provides detailed insights into import and export transactions involving companies across various sectors within North America.

Coverage Across All North American Countries

The dataset encompasses all key countries within North America, including:

1. United States

The dataset provides detailed trade information for the United States, the largest economy in the region. It includes extensive data on trade volumes, product categories, and the key trading partners of the U.S. 2. Canada

Data for Canada covers a wide range of trade activities, including import and export transactions, product classifications, and trade relationships with major global and regional partners. 3. Mexico

Comprehensive data for Mexico includes detailed records on its trade activities, including exports and imports, key sectors, and trade agreements affecting its trade dynamics. 4. Central American Countries:

Belize Costa Rica El Salvador Guatemala Honduras Nicaragua Panama The dataset covers these countries with information on their trade flows, key products, and trade relations with North American and international partners. 5. Caribbean Countries:

Bahamas Barbados Cuba Dominica Dominican Republic Grenada Haiti Jamaica Saint Kitts and Nevis Saint Lucia Saint Vincent and the Grenadines Trinidad and Tobago Trade data for these Caribbean nations includes detailed transaction records, sector-specific trade information, and their interactions with North American trade partners. Comprehensive Data Features

Transaction Details: The dataset includes precise details on each trade transaction, such as product descriptions, quantities, values, and dates. This allows for an accurate understanding of trade flows and patterns across North America.

Company Information: It provides data on companies involved in trade, including names, locations, and industry sectors, enabling targeted business analysis and competitive intelligence.

Categorization: Transactions are categorized by industry sectors, product types, and trade partners, offering insights into market dynamics and sector-specific trends within North America.

Trade Trends: Historical data helps users analyze trends over time, identify emerging markets, and assess the impact of economic or political events on trade flows in the region.

Geographical Insights: The data offers insights into regional trade flows and cross-border dynamics between North American countries and their global trade partners, including significant international trade relationships.

Regulatory and Compliance Data: Information on trade regulations, tariffs, and compliance requirements is included, helping businesses navigate the complex regulatory environments within North America.

Applications and Benefits

Market Research: Companies can leverage the data to discover new market opportunities, analyze competitive landscapes, and understand demand for specific products across North American countries.

Strategic Planning: Insights from the data enable companies to refine trade strategies, optimize supply chains, and manage risks associated with international trade in North America.

Economic Analysis: Analysts and policymakers can monitor economic performance, evaluate trade balances, and make informed decisions on trade policies and economic development strategies.

Investment Decisions: Investors can assess trade trends and market potentials to make informed decisions about investments in North America's diverse economies.

Techsalerator’s Import/Export Trade Data for North America offers a vital resource for organizations involved in international trade, providing a thorough, reliable, and detailed view of trade activities across the continent.

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.

This dataset provides values for CORONAVIRUS DEATHS reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

This dataset provides values for EMPLOYMENT RATE reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

This dataset provides values for GDP reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

The global gender gap index benchmarks national gender gaps on economic, political, education, and health-based criteria. In 2025, the country offering most gender equal conditions was Iceland, with a score of 0.93. Overall, the Nordic countries make up 3 of the 5 most gender equal countries in the world. The Nordic countries are known for their high levels of gender equality, including high female employment rates and evenly divided parental leave. Sudan is the second-least gender equal country Pakistan is found on the other end of the scale, ranked as the least gender equal country in the world. Conditions for civilians in the North African country have worsened significantly after a civil war broke out in April 2023. Especially girls and women are suffering and have become victims of sexual violence. Moreover, nearly 9 million people are estimated to be at acute risk of famine. The Middle East and North Africa has the largest gender gap Looking at the different world regions, the Middle East and North Africa has the largest gender gap as of 2023, just ahead of South Asia. Moreover, it is estimated that it will take another 152 years before the gender gap in the Middle East and North Africa is closed. On the other hand, Europe has the lowest gender gap in the world.

Associated with manuscript titled: Fifty Muslim-majority countries have fewer COVID-19 cases and deaths than the 50 richest non-Muslim countriesThe objective of this research was to determine the difference in the total number of COVID-19 cases and deaths between Muslim-majority and non-Muslim countries, and investigate reasons for the disparities. Methods: The 50 Muslim-majority countries had more than 50.0% Muslims with an average of 87.5%. The non-Muslim country sample consisted of 50 countries with the highest GDP while omitting any Muslim-majority countries listed. The non-Muslim countries’ average percentage of Muslims was 4.7%. Data pulled on September 18, 2020 included the percentage of Muslim population per country by World Population Review15 and GDP per country, population count, and total number of COVID-19 cases and deaths by Worldometers.16 The data set was transferred via an Excel spreadsheet on September 23, 2020 and analyzed. To measure COVID-19’s incidence in the countries, three different Average Treatment Methods (ATE) were used to validate the results. Results published as a preprint at https://doi.org/10.31235/osf.io/84zq5(15) Muslim Majority Countries 2020 [Internet]. Walnut (CA): World Population Review. 2020- [Cited 2020 Sept 28]. Available from: http://worldpopulationreview.com/country-rankings/muslim-majority-countries (16) Worldometers.info. Worldometer. Dover (DE): Worldometer; 2020 [cited 2020 Sept 28]. Available from: http://worldometers.info

We present the GLOBAL ROADKILL DATA, the largest worldwide compilation of roadkill data on terrestrial vertebrates. We outline the workflow (Fig. 1) to illustrate the sequential steps of the study, in which we merged local-scale survey datasets and opportunistic records into a unified roadkill large dataset comprising 208,570 roadkill records. These records include 2283 species and subspecies from 54 countries across six continents, ranging from 1971 to 2024.Large roadkill datasets offer the advantage ofpreventing the collection of redundant data and are valuable resources for both local and macro-scale analyses regarding roadkill rates, road and landscape features associated with roadkill risk, species more vulnerable to road traffic, and populations at risk due to additional mortality. The standardization of data - such as scientific names, projection coordinates, and units - in a user-friendly format, makes themreadily accessible to a broader scientific and non-scientific community, including NGOs, consultants, public administration officials, and road managers. The open-access approach promotes collaboration among researchers and road practitioners, facilitating the replication of studies, validation of findings, and expansion of previous work. Moreover, researchers can utilize suchdatasets to develop new hypotheses, conduct meta-analyses, address pressing challenges more efficiently and strengthen the robustness of road ecology research. Ensuring widespreadaccess to roadkill data fosters a more diverse and inclusive research community. This not only grants researchers in emerging economies with more data for analysis, but also cultivates a diverse array of perspectives and insightspromoting the advance of infrastructure ecology.MethodsInformation sources: A core team from different continents performed a systematic literature search in Web of Science and Google Scholar for published peer-reviewed papers and dissertations. It was searched for the following terms: “roadkill* OR “road-kill” OR “road mortality” AND (country) in English, Portuguese, Spanish, French and/or Mandarin. This initiative was also disseminated to the mailing lists associated with transport infrastructure: The CCSG Transport Working Group (WTG), Infrastructure & Ecology Network Europe (IENE) and Latin American & Caribbean Transport Working Group (LACTWG) (Fig. 1). The core team identified 750 scientific papers and dissertations with information on roadkill and contacted the first authors of the publications to request georeferenced locations of roadkill andofferco-authorship to this data paper. Of the 824 authors contacted, 145agreed to sharegeoreferenced roadkill locations, often involving additional colleagues who contributed to data collection. Since our main goal was to provide open access to data that had never been shared in this format before, data from citizen science projects (e.g., globalroakill.net) that are already available were not included.Data compilation: A total of 423 co-authors compiled the following information: continent, country, latitude and longitude in WGS 84 decimal degrees of the roadkill, coordinates uncertainty, class, order, family, scientific name of the roadkill, vernacular name, IUCN status, number of roadkill, year, month, and day of the record, identification of the road, type of road, survey type, references, and observers that recorded the roadkill (Supplementary Information Table S1 - description of the fields and Table S2 - reference list). When roadkill data were derived from systematic surveys, the dataset included additional information on road length that was surveyed, latitude and longitude of the road (initial and final part of the road segment), survey period, start year of the survey, final year of the survey, 1st month of the year surveyed, last month of the year surveyed, and frequency of the survey. We consolidated 142 valid datasets into a single dataset. We complemented this data with OccurenceID (a UUID generated using Java code), basisOfRecord, countryCode, locality using OpenStreetMap’s API (https://www.openstreetmap.org), geodeticDatum, verbatimScientificName, Kingdom, phylum, genus, specificEpithet, infraspecificEpithet, acceptedNameUsage, scientific name authorship, matchType, taxonRank using Darwin Core Reference Guide (https://dwc.tdwg.org/terms/#dwc:coordinateUncertaintyInMeters) and link of the associatedReference (URL).Data standardization - We conducted a clustering analysis on all text fields to identify similar entries with minor variations, such as typos, and corrected them using OpenRefine (http://openrefine.org). Wealsostandardized all date values using OpenRefine. Coordinate uncertainties listed as 0 m were adjusted to either 30m or 100m, depending on whether they were recorded after or before 2000, respectively, following the recommendation in the Darwin Core Reference Guide (https://dwc.tdwg.org/terms/#dwc:coordinateUncertaintyInMeters).Taxonomy - We cross-referenced all species names with the Global Biodiversity Information Facility (GBIF) Backbone Taxonomy using Java and GBIF’s API (https://doi.org/10.15468/39omei). This process aimed to rectify classification errors, include additional fields such as Kingdom, Phylum, and scientific authorship, and gather comprehensive taxonomic information to address any gap withinthe datasets. For species not automatically matched (matchType - Table S1), we manually searched for correct synonyms when available.Species conservation status - Using the species names, we retrieved their conservation status and also vernacular names by cross-referencing with the database downloaded from the IUCNRed List of Threatened Species (https://www.iucnredlist.org). Species without a match were categorized as "Not Evaluated".Data RecordsGLOBAL ROADKILL DATA is available at Figshare27 https://doi.org/10.6084/m9.figshare.25714233. The dataset incorporates opportunistic (collected incidentally without data collection efforts) and systematic data (collected through planned, structured, and controlled methods designed to ensure consistency and reliability). In total, it comprises 208,570 roadkill records across 177,428 different locations(Fig. 2). Data were collected from the road network of 54 countries from 6 continents: Europe (n = 19), Asia (n = 16), South America (n=7), North America (n = 4), Africa (n = 6) and Oceania (n = 2).(Figure 2 goes here)All data are georeferenced in WGS84 decimals with maximum uncertainty of 5000 m. Approximately 92% of records have a location uncertainty of 30 m or less, with only 1138 records having location uncertainties ranging from 1000 to 5000 m. Mammals have the highest number of roadkill records (61%), followed by amphibians (21%), reptiles (10%) and birds (8%). The species with the highest number of records were roe deer (Capreolus capreolus, n = 44,268), pool frog (Pelophylax lessonae, n = 11,999) and European fallow deer (Dama dama, n = 7,426).We collected information on 126 threatened species with a total of 4570 records. Among the threatened species, the giant anteater (Myrmecophaga tridactyla, VULNERABLE) has the highest number of records n = 1199), followed by the common fire salamander (Salamandra salamandra, VULNERABLE, n=1043), and European rabbit (Oryctolagus cuniculus, ENDANGERED, n = 440). Records ranged from 1971 and 2024, comprising 72% of the roadkill recorded since 2013. Over 46% of the records were obtained from systematic surveys, with road length and survey period averaging, respectively, 66 km (min-max: 0.09-855 km) and 780 days (1-25,720 days).Technical ValidationWe employed the OpenStreetMap API through Java todetect location inaccuracies, andvalidate whether the geographic coordinates aligned with the specified country. We calculated the distance of each occurrence to the nearest road using the GRIP global roads database28, ensuring that all records were within the defined coordinate uncertainty. We verified if the survey duration matched the provided initial and final survey dates. We calculated the distance between the provided initial and final road coordinates and cross-checked it with the given road length. We identified and merged duplicate entries within the same dataset (same location, species, and date), aggregating the number of roadkills for each occurrence.Usage NotesThe GLOBAL ROADKILL DATA is a compilation of roadkill records and was designed to serve as a valuable resource for a wide range of analyses. Nevertheless, to prevent the generation of meaningless results, users should be aware of the followinglimitations:- Geographic representation – There is an evident bias in the distribution of records. Data originatedpredominantly from Europe (60% of records), South America (22%), and North America (12%). Conversely, there is a notable lack of records from Asia (5%), Oceania (1%) and Africa (0.3%). This dataset represents 36% of the initial contacts that provided geo-referenced records, which may not necessarily correspond to locations where high-impact roads are present.- Location accuracy - Insufficient location accuracy was observed for 1% of the data (ranging from 1000 to 5000 m), that was associated with various factors, such as survey methods, recording practices, or timing of the survey.- Sampling effort - This dataset comprised both opportunistic data and records from systematic surveys, with a high variability in survey duration and frequency. As a result, the use of both opportunistic and systematic surveys may affect the relative abundance of roadkill making it hard to make sound comparisons among species or areas.- Detectability and carcass removal bias - Although several studies had a high frequency of road surveys,the duration of carcass persistence on roads may vary with species size and environmental conditions, affecting detectability. Accordingly, several approaches account for survey frequency and target speciesto estimate more

The Fiscal Monitor surveys and analyzes the latest public finance developments, it updates fiscal implications of the crisis and medium-term fiscal projections, and assesses policies to put public finances on a sustainable footing.

Country-specific data and projections for key fiscal variables are based on the April 2020 World Economic Outlook database, unless indicated otherwise, and compiled by the IMF staff. Historical data and projections are based on information gathered by IMF country desk officers in the context of their missions and through their ongoing analysis of the evolving situation in each country; they are updated on a continual basis as more information becomes available. Structural breaks in data may be adjusted to produce smooth series through splicing and other techniques. IMF staff estimates serve as proxies when complete information is unavailable. As a result, Fiscal Monitor data can differ from official data in other sources, including the IMF's International Financial Statistics.

The country classification in the Fiscal Monitor divides the world into three major groups: 35 advanced economies, 40 emerging market and middle-income economies, and 40 low-income developing countries. The seven largest advanced economies as measured by GDP (Canada, France, Germany, Italy, Japan, United Kingdom, United States) constitute the subgroup of major advanced economies, often referred to as the Group of Seven (G7). The members of the euro area are also distinguished as a subgroup. Composite data shown in the tables for the euro area cover the current members for all years, even though the membership has increased over time. Data for most European Union member countries have been revised following the adoption of the new European System of National and Regional Accounts (ESA 2010). The low-income developing countries (LIDCs) are countries that have per capita income levels below a certain threshold (currently set at $2,700 in 2016 as measured by the World Bank's Atlas method), structural features consistent with limited development and structural transformation, and external financial linkages insufficiently close to be widely seen as emerging market economies. Zimbabwe is included in the group. Emerging market and middle-income economies include those not classified as advanced economies or low-income developing countries. See Table A, "Economy Groupings," for more details.

Most fiscal data refer to the general government for advanced economies, while for emerging markets and developing economies, data often refer to the central government or budgetary central government only (for specific details, see Tables B-D). All fiscal data refer to the calendar years, except in the cases of Bangladesh, Egypt, Ethiopia, Haiti, Hong Kong Special Administrative Region, India, the Islamic Republic of Iran, Myanmar, Nepal, Pakistan, Singapore, and Thailand, for which they refer to the fiscal year.

Composite data for country groups are weighted averages of individual-country data, unless otherwise specified. Data are weighted by annual nominal GDP converted to U.S. dollars at average market exchange rates as a share of the group GDP.

In many countries, fiscal data follow the IMF's Government Finance Statistics Manual 2014. The overall fiscal balance refers to net lending (+) and borrowing ("") of the general government. In some cases, however, the overall balance refers to total revenue and grants minus total expenditure and net lending.

The fiscal gross and net debt data reported in the Fiscal Monitor are drawn from official data sources and IMF staff estimates. While attempts are made to align gross and net debt data with the definitions in the IMF's Government Finance Statistics Manual, as a result of data limitations or specific country circumstances, these data can sometimes deviate from the formal definitions.

This dataset provides values for GDP reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

World Bank Water Data is your source for all water-related open data at the World Bank. Here, you will find datasets and applications generated or compiled by the Water Global Practice. As the world’s largest multilateral source of financing for water in developing countries, the World Bank works closely with partners to achieve its vision of “A Water-Secure World for All" centered on three interrelated pillars: Sustain water resources Deliver services Build resilience Supported by the Global Water Security & Sanitation Partnership (GWSP)*, the World Bank works to advance five priority themes where action is critically needed to achieve the United Nations’ Sustainable Development Goals for water: sustainability, inclusion, institutions, financing, and resilience.

As of June 2024, the most popular database management system (DBMS) worldwide was Oracle, with a ranking score of 1244.08; MySQL and Microsoft SQL server rounded out the top three. Although the database management industry contains some of the largest companies in the tech industry, such as Microsoft, Oracle and IBM, a number of free and open-source DBMSs such as PostgreSQL and MariaDB remain competitive. Database Management Systems As the name implies, DBMSs provide a platform through which developers can organize, update, and control large databases. Given the business world’s growing focus on big data and data analytics, knowledge of SQL programming languages has become an important asset for software developers around the world, and database management skills are seen as highly desirable. In addition to providing developers with the tools needed to operate databases, DBMS are also integral to the way that consumers access information through applications, which further illustrates the importance of the software.

This dataset provides values for NAPHTHA reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

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.

Temporal Coverage: Latest available snapshot as of today Member countries are allocated votes at the time of membership and subsequently for additional subscriptions to capital. Votes are allocated differently in each organization. Each member receives votes consisting of share votes (one vote for each share of the Bank's capital stock held by the member) plus basic votes (calculated so that the sum of all basic votes is equal to 5.55 percent of the sum of basic votes and share votes for all members). Latest information about voting power is available at http://www.worldbank.org/en/about/leadership/votingpowers