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.

This dataset is about countries. It has 194 rows. It features 5 columns: currency, capital city, continent, and land area. It is 100% filled with non-null values.

World Countries provides a detailed basemap layer for the country boundaries of the world as they existed in January 2024. It has been designed to be used as a basemap and includes fields for local and official names and country codes, along with fields for capital, continent, and display. Particularly useful are the fields LAND_TYPE and LAND_RANK that separate polygons based on their size. These fields are helpful for rendering at different scales by providing the ability to turn off small islands that may clutter small-scale views.The data is sourced from Garmin International, Inc. and was published here in October 2024. This layer is updated every 12-18 months or as significant changes occur.

The average for 2021 based on 194 countries was 207903.4 sq. km. The highest value was in Russia: 8153116 sq. km and the lowest value was in Gibraltar: 0 sq. km. The indicator is available from 1990 to 2022. Below is a chart for all countries where data are available.

The Country boundaries at level 0 dataset is part of the Global Administrative Areas (GADM) 3.6 vector dataset series which includes distinct datasets representing administrative boundaries for all countries in the world. GADM makes use of high spatial resolution images and an extensive set of attributes to map administrative areas at all levels of political sub-division. The National level 0 attributes comprise country name in English and ISO 3166-1 alpha3 coding. Please read the GADM 3.6 - Global Administrative Areas dataset series metadata for more information.

Data publication: 2020-12-01

Supplemental Information:

The dataset was originally produced for the BioGeomancer project, with collaboration from the International Rice Research Institute and of California, Berkeley, Museum of Vertebrate Zoology. The development of GADM was partly supported by the Gordon and Betty Moore foundation for the BioGeomancer project.

Citation:

© 2009-2018 GADM

Contact points:

Resource Contact: Robert Hijmans

Metadata Contact: Robert Hijmans

Data lineage:

GADM unique ID (GID) starts with the three-letter ISO 3166-1 alpha-3 country code. If there are subdivisions these are identified by a number from 1 to n, where n is the number of subdivisions at level 1. This value is concatenated with the country code, using a dot to delimit the two. For example, AFG.1, AFG.2, ..., AFG.n. If there are second-level subdivisions, numeric codes are assigned within each first-level subdivision and these are concatenated with the first level identifier, using a dot as a delimiter. For example, AFG.1.1, AFG.1.2, AFG.1.3, ..., and AFG.2.1, AFG.2.2, .... And so forth for the third, fourth, and fifth levels. Finally, there is an underscore followed by a version number appended to the code. For example, AFG.3_1 and AFG.3.2_1. The GID codes are persistent after version 3.6 (there were errors in the codes in version 3.4). If an area changes, for example, if it splits into two new areas, two new codes will be assigned, and the old code will not be used anymore. The version only changes when there is a major overhaul of the divisions in a country, for example when a whole new set of subdivisions is introduced.

Resource constraints:

The data are freely available for academic use and other non-commercial use. Redistribution, or commercial use is not allowed without prior permission. See the license for more details.

Online resources:

GADM v.3 Dataset Download: The spatial data by country

GADM Historical Data Download

The average for 2021 based on 47 countries was 487417 sq. km. The highest value was in Russia: 16376870 sq. km and the lowest value was in Monaco: 2 sq. km. The indicator is available from 1961 to 2022. Below is a chart for all countries where data are available.

Analysis of ‘Countries of the World’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/fernandol/countries-of-the-world on 12 November 2021.

--- Dataset description provided by original source is as follows ---

Context

World fact sheet, fun to link with other datasets.

Content

Information on population, region, area size, infant mortality and more.

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.

--- Original source retains full ownership of the source dataset ---

This dataset provides values for ARABLE LAND PERCENT OF LAND AREA WB DATA.HTML reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

Russia is the largest country in Europe, and also the largest in the world, its total size amounting to 17 million square kilometers (km2). It should be noted, however, that over three quarters of Russia is located in Asia, and the Ural mountains are often viewed as the meeting point of the two continents in Russia; nonetheless, European Russia is still significantly larger than any other European country. Ukraine, the second largest country on the continent, is only 603,000 km2, making it about 28 times smaller than its eastern neighbor, or seven times smaller than the European part of Russia. France is the third largest country in Europe, but the largest in the European Union. The Vatican City, often referred to as the Holy Sea, is both the smallest country in Europe and in the world, at just one km2. Population Russia is also the most populous country in Europe. It has around 144 million inhabitants across the country; in this case, around three quarters of the population live in the European part, which still gives it the largest population in Europe. Despite having the largest population, Russia is a very sparsely populated country due to its size and the harsh winters. Germany is the second most populous country in Europe, with 83 million inhabitants, while the Vatican has the smallest population. Worldwide, India and China are the most populous countries, with approximately 1.4 billion inhabitants each. Cities Moscow in Russia is ranked as the most populous city in Europe with around 13 million inhabitants, although figures vary, due to differences in the methodologies used by countries and sources. Some statistics include Istanbul in Turkey* as the largest city in Europe with its 15 million inhabitants, bit it has been excluded here as most of the country and parts of the city is located in Asia. Worldwide, Tokyo is the most populous city, with Jakarta the second largest and Delhi the third.

Dataset

This dataset was created by Dinar khan

Contents

This dataset displays level 0 world administrative boundaries. It contains countries as well as non-sovereign territories (like, for instance, French overseas).

Dataset

This dataset was created by Vasu

Contents

Graph and download economic data for Gross Domestic Product for Euro Area (20 Countries) (CPMNACB1GQNSAEA20Q) from Q1 1995 to Q1 2025 about 1 to 19, Euro Area, World, Europe, and GDP.

This dataset is thought as a utility dataset to find geo locations (longitude and latitude) when you only have the names or codes for the countries. Besides ISO-Alpha-3 and ISO-Alpha-2 codes I added IOC and FIFA codes.

Sometimes there is more than one row for a country. This is when there are different (official) names or historical predecessors of a country. If it is the official name as defined by ISO 3166 Maintenance Agency it is marked with the value 1 in the column "ISO-Name".

The locations given here are not intended to be correct geographical centers of a country or region. These locations should be useful for positioning graphical elements (e.g. pie charts) on a map. Since version 4 of this data I added the coordinate locations given in the matching WikiData entities because they seem to be more centered in the countries shape (unfortunately not for all countries).

This dataset provides values for LAND AREA HECTARES WB DATA.HTML reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

A computerized data set of demographic, economic and social data for 227 countries of the world. Information presented includes population, health, nutrition, mortality, fertility, family planning and contraceptive use, literacy, housing, and economic activity data. Tabular data are broken down by such variables as age, sex, and urban/rural residence. Data are organized as a series of statistical tables identified by country and table number. Each record consists of the data values associated with a single row of a given table. There are 105 tables with data for 208 countries. The second file is a note file, containing text of notes associated with various tables. These notes provide information such as definitions of categories (i.e. urban/rural) and how various values were calculated. The IDB was created in the U.S. Census Bureau''s International Programs Center (IPC) to help IPC staff meet the needs of organizations that sponsor IPC research. The IDB provides quick access to specialized information, with emphasis on demographic measures, for individual countries or groups of countries. The IDB combines data from country sources (typically censuses and surveys) with IPC estimates and projections to provide information dating back as far as 1950 and as far ahead as 2050. Because the IDB is maintained as a research tool for IPC sponsor requirements, the amount of information available may vary by country. As funding and research activity permit, the IPC updates and expands the data base content. Types of data include: * Population by age and sex * Vital rates, infant mortality, and life tables * Fertility and child survivorship * Migration * Marital status * Family planning Data characteristics: * Temporal: Selected years, 1950present, projected demographic data to 2050. * Spatial: 227 countries and areas. * Resolution: National population, selected data by urban/rural * residence, selected data by age and sex. Sources of data include: * U.S. Census Bureau * International projects (e.g., the Demographic and Health Survey) * United Nations agencies Links: * ICPSR: http://www.icpsr.umich.edu/icpsrweb/ICPSR/studies/08490

There are approximately 8.16 billion people living in the world today, a figure that shows a dramatic increase since the beginning of the Common Era. Since the 1970s, the global population has also more than doubled in size. It is estimated that the world's population will reach and surpass 10 billion people by 2060 and plateau at around 10.3 billion in the 2080s, before it then begins to fall. Asia When it comes to number of inhabitants per continent, Asia is the most populous continent in the world by a significant margin, with roughly 60 percent of the world's population living there. Similar to other global regions, a quarter of inhabitants in Asia are under 15 years of age. The most populous nations in the world are India and China respectively; each inhabit more than three times the amount of people than the third-ranked United States. 10 of the 20 most populous countries in the world are found in Asia. Africa Interestingly, the top 20 countries with highest population growth rate are mainly countries in Africa. This is due to the present stage of Sub-Saharan Africa's demographic transition, where mortality rates are falling significantly, although fertility rates are yet to drop and match this. As much of Asia is nearing the end of its demographic transition, population growth is predicted to be much slower in this century than in the previous; in contrast, Africa's population is expected to reach almost four billion by the year 2100. Unlike demographic transitions in other continents, Africa's population development is being influenced by climate change on a scale unseen by most other global regions. Rising temperatures are exacerbating challenges such as poor sanitation, lack of infrastructure, and political instability, which have historically hindered societal progress. It remains to be seen how Africa and the world at large adapts to this crisis as it continues to cause drought, desertification, natural disasters, and climate migration across the region.

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

International Trade in Services Survey and Other International Operations: By type of operation and geographic area. Quarterly. National.

Matched boundary lines and polygons with names attributes for countries and sovereign states. Includes dependencies (French Polynesia), map units (U.S. Pacific Island Territories) and sub-national map subunits (Corsica versus mainland Metropolitan France).