Working with data collected from the CIA World Factbook, we will be analyzing their data compiled in a dataset containing info such as population (pop'n; as of 2015), pop'n growth and area.
%%capture
%load_ext sql
%sql sqlite:///factbook.db
'Connected: None@factbook.db'
%%sql
SELECT *
FROM sqlite_master
WHERE type ="table";
Done.
type | name | tbl_name | rootpage | sql |
---|---|---|---|---|
table | sqlite_sequence | sqlite_sequence | 3 | CREATE TABLE sqlite_sequence(name,seq) |
table | facts | facts | 47 | CREATE TABLE "facts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255) NOT NULL, "name" varchar(255) NOT NULL, "area" integer, "area_land" integer, "area_water" integer, "population" integer, "population_growth" float, "birth_rate" float, "death_rate" float, "migration_rate" float) |
%%sql
SELECT *
FROM facts
LIMIT 5;
Done.
id | code | name | area | area_land | area_water | population | population_growth | birth_rate | death_rate | migration_rate |
---|---|---|---|---|---|---|---|---|---|---|
1 | af | Afghanistan | 652230 | 652230 | 0 | 32564342 | 2.32 | 38.57 | 13.89 | 1.51 |
2 | al | Albania | 28748 | 27398 | 1350 | 3029278 | 0.3 | 12.92 | 6.58 | 3.3 |
3 | ag | Algeria | 2381741 | 2381741 | 0 | 39542166 | 1.84 | 23.67 | 4.31 | 0.92 |
4 | an | Andorra | 468 | 468 | 0 | 85580 | 0.12 | 8.13 | 6.96 | 0.0 |
5 | ao | Angola | 1246700 | 1246700 | 0 | 19625353 | 2.78 | 38.78 | 11.49 | 0.46 |
%%sql
SELECT name, population, population_growth
FROM facts
ORDER BY population_growth DESC;
Done.
name | population | population_growth |
---|---|---|
South Sudan | 12042910 | 4.02 |
Malawi | 17964697 | 3.32 |
Burundi | 10742276 | 3.28 |
Niger | 18045729 | 3.25 |
Uganda | 37101745 | 3.24 |
Qatar | 2194817 | 3.07 |
Burkina Faso | 18931686 | 3.03 |
Mali | 16955536 | 2.98 |
Cook Islands | 9838 | 2.95 |
Iraq | 37056169 | 2.93 |
Ethiopia | 99465819 | 2.89 |
Zambia | 15066266 | 2.88 |
Western Sahara | 570866 | 2.82 |
Gaza Strip | 1869055 | 2.81 |
Tanzania | 51045882 | 2.79 |
Angola | 19625353 | 2.78 |
Benin | 10448647 | 2.78 |
Togo | 7552318 | 2.69 |
Guinea | 11780162 | 2.63 |
Cameroon | 23739218 | 2.59 |
Madagascar | 23812681 | 2.58 |
United Arab Emirates | 5779760 | 2.58 |
Rwanda | 12661733 | 2.56 |
Equatorial Guinea | 740743 | 2.51 |
Liberia | 4195666 | 2.47 |
Yemen | 26737317 | 2.47 |
Congo, Democratic Republic of the | 79375136 | 2.45 |
Mozambique | 25303113 | 2.45 |
Nigeria | 181562056 | 2.45 |
Senegal | 13975834 | 2.45 |
Timor-Leste | 1231116 | 2.42 |
Bahrain | 1346613 | 2.41 |
Sierra Leone | 5879098 | 2.35 |
Afghanistan | 32564342 | 2.32 |
British Virgin Islands | 33454 | 2.32 |
Turks and Caicos Islands | 50280 | 2.3 |
Eritrea | 6527689 | 2.25 |
Libya | 6411776 | 2.23 |
Mauritania | 3596702 | 2.23 |
Zimbabwe | 14229541 | 2.21 |
Djibouti | 828324 | 2.2 |
Ghana | 26327649 | 2.18 |
Northern Mariana Islands | 52344 | 2.18 |
Gambia, The | 1967709 | 2.16 |
Central African Republic | 5391539 | 2.13 |
Luxembourg | 570252 | 2.13 |
Cayman Islands | 56092 | 2.1 |
Oman | 3286936 | 2.07 |
Anguilla | 16418 | 2.03 |
Solomon Islands | 622469 | 2.02 |
Congo, Republic of the | 4755097 | 2.0 |
Vanuatu | 272264 | 1.95 |
West Bank | 2785366 | 1.95 |
Gabon | 1705336 | 1.93 |
Kenya | 45925301 | 1.93 |
Cote d'Ivoire | 23295302 | 1.91 |
Guinea-Bissau | 1726170 | 1.91 |
Chad | 11631456 | 1.89 |
Singapore | 5674472 | 1.89 |
Belize | 347369 | 1.87 |
Algeria | 39542166 | 1.84 |
Sao Tome and Principe | 194006 | 1.84 |
Somalia | 10616380 | 1.83 |
Guatemala | 14918999 | 1.82 |
Egypt | 88487396 | 1.79 |
Nepal | 31551305 | 1.79 |
Papua New Guinea | 6672429 | 1.78 |
Comoros | 780971 | 1.77 |
Sudan | 36108853 | 1.72 |
Tajikistan | 8191958 | 1.71 |
Honduras | 8746673 | 1.68 |
Marshall Islands | 72191 | 1.66 |
Brunei | 429646 | 1.62 |
Kuwait | 2788534 | 1.62 |
Philippines | 100998376 | 1.61 |
Bangladesh | 168957745 | 1.6 |
Cambodia | 15708756 | 1.58 |
Bolivia | 10800882 | 1.56 |
Israel | 8049314 | 1.56 |
Laos | 6911544 | 1.55 |
Sint Maarten | 39689 | 1.51 |
Pakistan | 199085847 | 1.46 |
Saudi Arabia | 27752316 | 1.46 |
Malaysia | 30513848 | 1.44 |
Cyprus | 1189197 | 1.43 |
Venezuela | 29275460 | 1.39 |
New Caledonia | 271615 | 1.38 |
Cabo Verde | 545993 | 1.36 |
Ecuador | 15868396 | 1.35 |
South Africa | 53675563 | 1.33 |
Aruba | 112162 | 1.33 |
Panama | 3657024 | 1.32 |
Mongolia | 2992908 | 1.31 |
Turkey | 79414269 | 1.26 |
Ireland | 4892305 | 1.25 |
Antigua and Barbuda | 92436 | 1.24 |
Dominican Republic | 10478756 | 1.23 |
Costa Rica | 4814144 | 1.22 |
India | 1251695584 | 1.22 |
Botswana | 2182719 | 1.21 |
Iceland | 331918 | 1.21 |
Iran | 81824270 | 1.2 |
Mexico | 121736809 | 1.18 |
Haiti | 10110019 | 1.17 |
Paraguay | 6783272 | 1.16 |
Kiribati | 105711 | 1.15 |
Kazakhstan | 18157122 | 1.14 |
Turkmenistan | 5231422 | 1.14 |
Norway | 5207689 | 1.13 |
Bhutan | 741919 | 1.11 |
Kyrgyzstan | 5664939 | 1.11 |
Swaziland | 1435613 | 1.11 |
Christmas Island | 1530 | 1.11 |
Suriname | 579633 | 1.08 |
Saint Pierre and Miquelon | 5657 | 1.08 |
World | 7256490011 | 1.08 |
Australia | 22751014 | 1.07 |
Latvia | 1986705 | 1.06 |
Colombia | 46736728 | 1.04 |
Lithuania | 2884433 | 1.04 |
Moldova | 3546847 | 1.03 |
Burma | 56320206 | 1.01 |
Morocco | 33322699 | 1.0 |
Nicaragua | 5907881 | 1.0 |
Peru | 30444999 | 0.97 |
Vietnam | 94348835 | 0.97 |
Azerbaijan | 9780780 | 0.96 |
French Polynesia | 282703 | 0.94 |
Argentina | 43431886 | 0.93 |
Uzbekistan | 29199942 | 0.93 |
Indonesia | 255993674 | 0.92 |
Spain | 48146134 | 0.89 |
Tunisia | 11037225 | 0.89 |
Lebanon | 6184701 | 0.86 |
Bahamas, The | 324597 | 0.85 |
Liechtenstein | 37624 | 0.84 |
Sri Lanka | 22053488 | 0.84 |
Jordan | 8117564 | 0.83 |
Seychelles | 92430 | 0.83 |
Chile | 17508260 | 0.82 |
New Zealand | 4438393 | 0.82 |
San Marino | 33020 | 0.82 |
Tuvalu | 10869 | 0.82 |
Sweden | 9801616 | 0.8 |
Macau | 592731 | 0.8 |
Jersey | 97294 | 0.8 |
United States | 321368864 | 0.78 |
Brazil | 204259812 | 0.77 |
Belgium | 11323973 | 0.76 |
Saint Kitts and Nevis | 51936 | 0.76 |
Isle of Man | 87545 | 0.76 |
Canada | 35099836 | 0.75 |
Switzerland | 8121830 | 0.71 |
Jamaica | 2950210 | 0.68 |
Fiji | 909389 | 0.67 |
Mauritius | 1339827 | 0.64 |
Ukraine | 44429471 | 0.6 |
Puerto Rico | 3598357 | 0.6 |
Namibia | 2212307 | 0.59 |
Virgin Islands | 103574 | 0.59 |
Bulgaria | 7186893 | 0.58 |
Samoa | 197773 | 0.58 |
Austria | 8665550 | 0.55 |
Estonia | 1265420 | 0.55 |
Nauru | 9540 | 0.55 |
United Kingdom | 64088222 | 0.54 |
Guam | 161785 | 0.54 |
Korea, North | 24983205 | 0.53 |
Faroe Islands | 50196 | 0.51 |
Bermuda | 70196 | 0.5 |
Montserrat | 5241 | 0.5 |
Grenada | 110694 | 0.48 |
Micronesia, Federated States of | 105216 | 0.46 |
Serbia | 7176794 | 0.46 |
China | 1367485388 | 0.45 |
France | 66553766 | 0.43 |
Curacao | 148406 | 0.43 |
Montenegro | 647073 | 0.42 |
Netherlands | 16947904 | 0.41 |
Finland | 5476922 | 0.4 |
Palau | 21265 | 0.38 |
Hong Kong | 7141106 | 0.38 |
Saint Lucia | 163922 | 0.34 |
Thailand | 67976405 | 0.34 |
Guernsey | 66080 | 0.34 |
Wallis and Futuna | 15613 | 0.33 |
Lesotho | 1947701 | 0.32 |
Barbados | 290604 | 0.31 |
Malta | 413965 | 0.31 |
Albania | 3029278 | 0.3 |
Romania | 21666350 | 0.3 |
American Samoa | 54343 | 0.3 |
Saint Vincent and the Grenadines | 102627 | 0.28 |
Italy | 61855120 | 0.27 |
Uruguay | 3341893 | 0.27 |
Slovenia | 1983412 | 0.26 |
El Salvador | 6141350 | 0.25 |
European Union | 513949445 | 0.25 |
Gibraltar | 29258 | 0.24 |
Saint Helena, Ascension, and Tristan da Cunha | 7795 | 0.24 |
Taiwan | 23415126 | 0.23 |
Denmark | 5581503 | 0.22 |
Hungary | 9897541 | 0.22 |
Dominica | 73607 | 0.21 |
Belarus | 9589689 | 0.2 |
Macedonia | 2096015 | 0.2 |
Germany | 80854408 | 0.17 |
Czech Republic | 10644842 | 0.16 |
Japan | 126919659 | 0.16 |
Syria | 17064854 | 0.16 |
Armenia | 3056382 | 0.15 |
Cuba | 11031433 | 0.15 |
Korea, South | 49115196 | 0.14 |
Bosnia and Herzegovina | 3867055 | 0.13 |
Croatia | 4464844 | 0.13 |
Trinidad and Tobago | 1222363 | 0.13 |
Andorra | 85580 | 0.12 |
Monaco | 30535 | 0.12 |
Poland | 38562189 | 0.09 |
Portugal | 10825309 | 0.09 |
Georgia | 4931226 | 0.08 |
Maldives | 393253 | 0.08 |
Russia | 142423773 | 0.04 |
Tonga | 106501 | 0.03 |
Niue | 1190 | 0.03 |
Svalbard | 1872 | 0.03 |
Guyana | 735222 | 0.02 |
Slovakia | 5445027 | 0.02 |
Greece | 10775643 | 0.01 |
Norfolk Island | 2210 | 0.01 |
Tokelau | 1337 | 0.01 |
Falkland Islands (Islas Malvinas) | 3361 | 0.01 |
Holy See (Vatican City) | 842 | 0.0 |
Cocos (Keeling) Islands | 596 | 0.0 |
Greenland | 57733 | 0.0 |
Pitcairn Islands | 48 | 0.0 |
Kosovo | 1870981 | None |
Ashmore and Cartier Islands | None | None |
Coral Sea Islands | None | None |
Heard Island and McDonald Islands | None | None |
Clipperton Island | None | None |
French Southern and Antarctic Lands | None | None |
Saint Barthelemy | 7237 | None |
Saint Martin | 31754 | None |
Bouvet Island | None | None |
Jan Mayen | None | None |
Akrotiri | 15700 | None |
British Indian Ocean Territory | None | None |
Dhekelia | 15700 | None |
South Georgia and South Sandwich Islands | None | None |
Navassa Island | None | None |
Wake Island | None | None |
United States Pacific Island Wildlife Refuges | None | None |
Antarctica | 0 | None |
Paracel Islands | None | None |
Spratly Islands | None | None |
Arctic Ocean | None | None |
Atlantic Ocean | None | None |
Indian Ocean | None | None |
Pacific Ocean | None | None |
Southern Ocean | None | None |
Here is a description of the columns under the "Facts" table:
COLUMN NAME | DESCRIPTION |
---|---|
id | ID Number |
code | Short-form code for name of country |
name | Name of the country |
area | Total land and sea area of country |
area_land | Total land area of country |
area_water | Total sea area of country |
population | Population of the country |
population_growth | Population growth as a percentage |
birth_rate | Birth rate per 1000 citizens |
death_rate | Death rate per 1000 citizens |
migration_rate | Rate of people migrating into the country |
%%sql
SELECT MIN(population) as "Lowest Population amongst Nations",
MAX(population) as "Highest Population amongst Nations",
MIN(population_growth) as "Lowest Population Growth",
MAX(population_growth) as "Highest Population Growth"
FROM facts
Done.
Lowest Population amongst Nations | Highest Population amongst Nations | Lowest Population Growth | Highest Population Growth |
---|---|---|---|
0 | 7256490011 | 0.0 | 4.02 |
Observing our findings, we see that
Important to note that there are a number of nations where population and population growth rate were not recorded.
%%sql
SELECT *
FROM facts
WHERE Population = (SELECT Min(population)
FROM facts);
Done.
id | code | name | area | area_land | area_water | population | population_growth | birth_rate | death_rate | migration_rate |
---|---|---|---|---|---|---|---|---|---|---|
250 | ay | Antarctica | None | 280000 | None | 0 | None | None | None | None |
%%sql
SELECT *
FROM facts
WHERE Population = (SELECT MAX(population)
FROM facts);
Done.
id | code | name | area | area_land | area_water | population | population_growth | birth_rate | death_rate | migration_rate |
---|---|---|---|---|---|---|---|---|---|---|
261 | xx | World | None | None | None | 7256490011 | 1.08 | 18.6 | 7.8 | None |
%%sql
SELECT MAX(population), MIN(population), MAX(population_growth), MIN(population_growth)
FROM facts
WHERE name != "World";
Done.
MAX(population) | MIN(population) | MAX(population_growth) | MIN(population_growth) |
---|---|---|---|
1367485388 | 0 | 4.02 | 0.0 |
It looks like the max population corresponds to China.
%%sql
SELECT AVG(population), AVG(area)
FROM facts
WHERE name != "World";
Done.
AVG(population) | AVG(area) |
---|---|
32242666.56846473 | 555093.546184739 |
%%sql
SELECT *
FROM facts
WHERE population > (SELECT AVG(Population)
FROM facts)
and area < (SELECT AVG(area)
FROM facts);
Done.
id | code | name | area | area_land | area_water | population | population_growth | birth_rate | death_rate | migration_rate |
---|---|---|---|---|---|---|---|---|---|---|
14 | bg | Bangladesh | 148460 | 130170 | 18290 | 168957745 | 1.6 | 21.14 | 5.61 | 0.46 |
65 | gm | Germany | 357022 | 348672 | 8350 | 80854408 | 0.17 | 8.47 | 11.42 | 1.24 |
85 | ja | Japan | 377915 | 364485 | 13430 | 126919659 | 0.16 | 7.93 | 9.51 | 0.0 |
138 | rp | Philippines | 300000 | 298170 | 1830 | 100998376 | 1.61 | 24.27 | 6.11 | 2.09 |
173 | th | Thailand | 513120 | 510890 | 2230 | 67976405 | 0.34 | 11.19 | 7.8 | 0.0 |
185 | uk | United Kingdom | 243610 | 241930 | 1680 | 64088222 | 0.54 | 12.17 | 9.35 | 2.54 |
192 | vm | Vietnam | 331210 | 310070 | 21140 | 94348835 | 0.97 | 15.96 | 5.93 | 0.3 |
Based on the average population and area of the various nations we found that the list of countries with the highest density are:
%%sql
SELECT *
FROM facts
WHERE name != "World"
ORDER BY population DESC;
Done.
id | code | name | area | area_land | area_water | population | population_growth | birth_rate | death_rate | migration_rate |
---|---|---|---|---|---|---|---|---|---|---|
37 | ch | China | 9596960 | 9326410 | 270550 | 1367485388 | 0.45 | 12.49 | 7.53 | 0.44 |
77 | in | India | 3287263 | 2973193 | 314070 | 1251695584 | 1.22 | 19.55 | 7.32 | 0.04 |
197 | ee | European Union | 4324782 | None | None | 513949445 | 0.25 | 10.2 | 10.2 | 2.5 |
186 | us | United States | 9826675 | 9161966 | 664709 | 321368864 | 0.78 | 12.49 | 8.15 | 3.86 |
78 | id | Indonesia | 1904569 | 1811569 | 93000 | 255993674 | 0.92 | 16.72 | 6.37 | 1.16 |
24 | br | Brazil | 8515770 | 8358140 | 157630 | 204259812 | 0.77 | 14.46 | 6.58 | 0.14 |
132 | pk | Pakistan | 796095 | 770875 | 25220 | 199085847 | 1.46 | 22.58 | 6.49 | 1.54 |
129 | ni | Nigeria | 923768 | 910768 | 13000 | 181562056 | 2.45 | 37.64 | 12.9 | 0.22 |
14 | bg | Bangladesh | 148460 | 130170 | 18290 | 168957745 | 1.6 | 21.14 | 5.61 | 0.46 |
143 | rs | Russia | 17098242 | 16377742 | 720500 | 142423773 | 0.04 | 11.6 | 13.69 | 1.69 |
85 | ja | Japan | 377915 | 364485 | 13430 | 126919659 | 0.16 | 7.93 | 9.51 | 0.0 |
114 | mx | Mexico | 1964375 | 1943945 | 20430 | 121736809 | 1.18 | 18.78 | 5.26 | 1.68 |
138 | rp | Philippines | 300000 | 298170 | 1830 | 100998376 | 1.61 | 24.27 | 6.11 | 2.09 |
58 | et | Ethiopia | 1104300 | None | 104300 | 99465819 | 2.89 | 37.27 | 8.19 | 0.22 |
192 | vm | Vietnam | 331210 | 310070 | 21140 | 94348835 | 0.97 | 15.96 | 5.93 | 0.3 |
53 | eg | Egypt | 1001450 | 995450 | 6000 | 88487396 | 1.79 | 22.9 | 4.77 | 0.19 |
79 | ir | Iran | 1648195 | 1531595 | 116600 | 81824270 | 1.2 | 17.99 | 5.94 | 0.07 |
65 | gm | Germany | 357022 | 348672 | 8350 | 80854408 | 0.17 | 8.47 | 11.42 | 1.24 |
179 | tu | Turkey | 783562 | 769632 | 13930 | 79414269 | 1.26 | 16.33 | 5.88 | 2.16 |
40 | cg | Congo, Democratic Republic of the | 2344858 | 2267048 | 77810 | 79375136 | 2.45 | 34.88 | 10.07 | 0.27 |
173 | th | Thailand | 513120 | 510890 | 2230 | 67976405 | 0.34 | 11.19 | 7.8 | 0.0 |
61 | fr | France | 643801 | 640427 | 3374 | 66553766 | 0.43 | 12.38 | 9.16 | 1.09 |
185 | uk | United Kingdom | 243610 | 241930 | 1680 | 64088222 | 0.54 | 12.17 | 9.35 | 2.54 |
83 | it | Italy | 301340 | 294140 | 7200 | 61855120 | 0.27 | 8.74 | 10.19 | 4.1 |
28 | bm | Burma | 676578 | 653508 | 23070 | 56320206 | 1.01 | 18.39 | 7.96 | 0.28 |
161 | sf | South Africa | 1219090 | 1214470 | 4620 | 53675563 | 1.33 | 20.75 | 9.91 | 2.42 |
172 | tz | Tanzania | 947300 | 885800 | 61500 | 51045882 | 2.79 | 36.39 | 8.0 | 0.54 |
91 | ks | Korea, South | 99720 | 96920 | 2800 | 49115196 | 0.14 | 8.19 | 6.75 | 0.0 |
163 | sp | Spain | 505370 | 498980 | 6390 | 48146134 | 0.89 | 9.64 | 9.04 | 8.31 |
38 | co | Colombia | 1138910 | 1038700 | 100210 | 46736728 | 1.04 | 16.47 | 5.4 | 0.64 |
88 | ke | Kenya | 580367 | 569140 | 11227 | 45925301 | 1.93 | 26.4 | 6.89 | 0.22 |
183 | up | Ukraine | 603550 | 579330 | 24220 | 44429471 | 0.6 | 10.72 | 14.46 | 2.25 |
7 | ar | Argentina | 2780400 | 2736690 | 43710 | 43431886 | 0.93 | 16.64 | 7.33 | 0.0 |
3 | ag | Algeria | 2381741 | 2381741 | 0 | 39542166 | 1.84 | 23.67 | 4.31 | 0.92 |
139 | pl | Poland | 312685 | 304255 | 8430 | 38562189 | 0.09 | 9.74 | 10.19 | 0.46 |
182 | ug | Uganda | 241038 | 197100 | 43938 | 37101745 | 3.24 | 43.79 | 10.69 | 0.74 |
80 | iz | Iraq | 438317 | 437367 | 950 | 37056169 | 2.93 | 31.45 | 3.77 | 1.62 |
165 | su | Sudan | 1861484 | None | None | 36108853 | 1.72 | 29.19 | 7.66 | 4.29 |
32 | ca | Canada | 9984670 | 9093507 | 891163 | 35099836 | 0.75 | 10.28 | 8.42 | 5.66 |
120 | mo | Morocco | 446550 | 446300 | 250 | 33322699 | 1.0 | 18.2 | 4.81 | 3.36 |
1 | af | Afghanistan | 652230 | 652230 | 0 | 32564342 | 2.32 | 38.57 | 13.89 | 1.51 |
124 | np | Nepal | 147181 | 143351 | 3830 | 31551305 | 1.79 | 20.64 | 6.56 | 3.86 |
107 | my | Malaysia | 329847 | 328657 | 1190 | 30513848 | 1.44 | 19.71 | 5.03 | 0.33 |
137 | pe | Peru | 1285216 | 1279996 | 5220 | 30444999 | 0.97 | 18.28 | 6.01 | 2.53 |
191 | ve | Venezuela | 912050 | 882050 | 30000 | 29275460 | 1.39 | 19.16 | 5.31 | 0.0 |
188 | uz | Uzbekistan | 447400 | 425400 | 22000 | 29199942 | 0.93 | 17.0 | 5.3 | 2.37 |
151 | sa | Saudi Arabia | 2149690 | 2149690 | 0 | 27752316 | 1.46 | 18.51 | 3.33 | 0.55 |
193 | ym | Yemen | 527968 | 527968 | 0 | 26737317 | 2.47 | 29.98 | 6.28 | 1.0 |
66 | gh | Ghana | 238533 | 227533 | 11000 | 26327649 | 2.18 | 31.09 | 7.22 | 2.02 |
121 | mz | Mozambique | 799380 | 786380 | 13000 | 25303113 | 2.45 | 38.58 | 12.1 | 1.98 |
90 | kn | Korea, North | 120538 | 120408 | 130 | 24983205 | 0.53 | 14.52 | 9.21 | 0.04 |
105 | ma | Madagascar | 587041 | 581540 | 5501 | 23812681 | 2.58 | 32.61 | 6.81 | 0.0 |
31 | cm | Cameroon | 475440 | 472710 | 2730 | 23739218 | 2.59 | 36.17 | 10.11 | 0.15 |
196 | tw | Taiwan | 35980 | 32260 | 3720 | 23415126 | 0.23 | 8.47 | 7.11 | 0.89 |
43 | iv | Cote d'Ivoire | 322463 | 318003 | 4460 | 23295302 | 1.91 | 28.67 | 9.55 | 0.0 |
9 | as | Australia | 7741220 | 7682300 | 58920 | 22751014 | 1.07 | 12.15 | 7.14 | 5.65 |
164 | ce | Sri Lanka | 65610 | 64630 | 980 | 22053488 | 0.84 | 15.85 | 6.11 | 1.35 |
142 | ro | Romania | 238391 | 229891 | 8500 | 21666350 | 0.3 | 9.14 | 11.9 | 0.24 |
5 | ao | Angola | 1246700 | 1246700 | 0 | 19625353 | 2.78 | 38.78 | 11.49 | 0.46 |
27 | uv | Burkina Faso | 274200 | 273800 | 400 | 18931686 | 3.03 | 42.03 | 11.72 | 0.0 |
87 | kz | Kazakhstan | 2724900 | 2699700 | 25200 | 18157122 | 1.14 | 19.15 | 8.21 | 0.41 |
128 | ng | Niger | None | 1266700 | 300 | 18045729 | 3.25 | 45.45 | 12.42 | 0.56 |
106 | mi | Malawi | 118484 | 94080 | 24404 | 17964697 | 3.32 | 41.56 | 8.41 | 0.0 |
36 | ci | Chile | 756102 | 743812 | 12290 | 17508260 | 0.82 | 13.83 | 6.0 | 0.34 |
170 | sy | Syria | 185180 | 183630 | 1550 | 17064854 | 0.16 | 22.17 | 4.0 | 19.79 |
109 | ml | Mali | 1240192 | 1220190 | 20002 | 16955536 | 2.98 | 44.99 | 12.89 | 2.26 |
125 | nl | Netherlands | 41543 | 33893 | 7650 | 16947904 | 0.41 | 10.83 | 8.66 | 1.95 |
52 | ec | Ecuador | 283561 | 276841 | 6720 | 15868396 | 1.35 | 18.51 | 5.06 | 0.0 |
30 | cb | Cambodia | 181035 | 176515 | 4520 | 15708756 | 1.58 | 23.83 | 7.68 | 0.32 |
194 | za | Zambia | 752618 | 743398 | 9220 | 15066266 | 2.88 | 42.13 | 12.67 | 0.68 |
69 | gt | Guatemala | 108889 | 107159 | 1730 | 14918999 | 1.82 | 24.89 | 4.77 | 1.97 |
195 | zi | Zimbabwe | 390757 | 386847 | 3910 | 14229541 | 2.21 | 32.26 | 10.13 | 0.0 |
152 | sg | Senegal | 196722 | 192530 | 4192 | 13975834 | 2.45 | 34.52 | 8.46 | 1.59 |
144 | rw | Rwanda | 26338 | 24668 | 1670 | 12661733 | 2.56 | 33.75 | 8.96 | 0.85 |
162 | od | South Sudan | 644329 | None | None | 12042910 | 4.02 | 36.91 | 8.18 | 11.47 |
70 | gv | Guinea | 245857 | 245717 | 140 | 11780162 | 2.63 | 35.74 | 9.46 | 0.0 |
35 | cd | Chad | None | 1259200 | 24800 | 11631456 | 1.89 | 36.6 | 14.28 | 3.45 |
17 | be | Belgium | 30528 | 30278 | 250 | 11323973 | 0.76 | 11.41 | 9.63 | 5.87 |
178 | ts | Tunisia | 163610 | 155360 | 8250 | 11037225 | 0.89 | 16.64 | 5.98 | 1.73 |
45 | cu | Cuba | 110860 | 109820 | 1040 | 11031433 | 0.15 | 9.9 | 7.72 | 3.66 |
140 | po | Portugal | 92090 | 91470 | 620 | 10825309 | 0.09 | 9.27 | 11.02 | 2.67 |
21 | bl | Bolivia | 1098581 | 1083301 | 15280 | 10800882 | 1.56 | 22.76 | 6.52 | 0.62 |
67 | gr | Greece | 131957 | 130647 | 1310 | 10775643 | 0.01 | 8.66 | 11.09 | 2.32 |
29 | by | Burundi | 27830 | 25680 | 2150 | 10742276 | 3.28 | 42.01 | 9.27 | 0.0 |
47 | ez | Czech Republic | 78867 | 77247 | 1620 | 10644842 | 0.16 | 9.63 | 10.34 | 2.33 |
160 | so | Somalia | 637657 | 627337 | 10320 | 10616380 | 1.83 | 40.45 | 13.62 | 8.49 |
51 | dr | Dominican Republic | 48670 | 48320 | 350 | 10478756 | 1.23 | 18.73 | 4.55 | 1.91 |
19 | bn | Benin | 112622 | 110622 | 2000 | 10448647 | 2.78 | 36.02 | 8.21 | 0.0 |
73 | ha | Haiti | 27750 | 27560 | 190 | 10110019 | 1.17 | 22.31 | 7.83 | 2.76 |
75 | hu | Hungary | 93028 | 89608 | 3420 | 9897541 | 0.22 | 9.16 | 12.73 | 1.33 |
168 | sw | Sweden | 450295 | 410335 | 39960 | 9801616 | 0.8 | 11.99 | 9.4 | 5.42 |
11 | aj | Azerbaijan | 86600 | 82629 | 3971 | 9780780 | 0.96 | 16.64 | 7.07 | 0.0 |
16 | bo | Belarus | 207600 | 202900 | 4700 | 9589689 | 0.2 | 10.7 | 13.36 | 0.7 |
74 | ho | Honduras | 112090 | 111890 | 200 | 8746673 | 1.68 | 23.14 | 5.17 | 1.16 |
10 | au | Austria | 83871 | 82445 | 1426 | 8665550 | 0.55 | 9.41 | 9.42 | 5.56 |
171 | ti | Tajikistan | 144100 | 141510 | 2590 | 8191958 | 1.71 | 24.38 | 6.18 | 1.15 |
169 | sz | Switzerland | 41277 | 39997 | 1280 | 8121830 | 0.71 | 10.5 | 8.13 | 4.74 |
86 | jo | Jordan | 89342 | 88802 | 540 | 8117564 | 0.83 | 25.37 | 3.79 | 13.24 |
82 | is | Israel | 20770 | 20330 | 440 | 8049314 | 1.56 | 18.48 | 5.15 | 2.24 |
175 | to | Togo | 56785 | 54385 | 2400 | 7552318 | 2.69 | 34.13 | 7.26 | 0.0 |
26 | bu | Bulgaria | 110879 | 108489 | 2390 | 7186893 | 0.58 | 8.92 | 14.44 | 0.29 |
153 | ri | Serbia | 77474 | 77474 | 0 | 7176794 | 0.46 | 9.08 | 13.66 | 0.0 |
204 | hk | Hong Kong | 1108 | 1073 | 35 | 7141106 | 0.38 | 9.23 | 7.07 | 1.68 |
95 | la | Laos | 236800 | 230800 | 6000 | 6911544 | 1.55 | 24.25 | 7.63 | 1.09 |
136 | pa | Paraguay | 406752 | 397302 | 9450 | 6783272 | 1.16 | 16.37 | 4.68 | 0.07 |
135 | pp | Papua New Guinea | 462840 | 452860 | 9980 | 6672429 | 1.78 | 24.38 | 6.53 | 0.0 |
56 | er | Eritrea | 117600 | 101000 | 16600 | 6527689 | 2.25 | 30.0 | 7.52 | 0.0 |
100 | ly | Libya | 1759540 | 1759540 | 0 | 6411776 | 2.23 | 18.03 | 3.58 | 7.8 |
97 | le | Lebanon | 10400 | 10230 | 170 | 6184701 | 0.86 | 14.59 | 4.88 | 1.1 |
54 | es | El Salvador | 21041 | 20721 | 320 | 6141350 | 0.25 | 16.46 | 5.69 | 8.28 |
127 | nu | Nicaragua | 130370 | 119990 | 10380 | 5907881 | 1.0 | 18.03 | 5.08 | 3.0 |
155 | sl | Sierra Leone | 71740 | 71620 | 120 | 5879098 | 2.35 | 37.03 | 10.81 | 2.77 |
184 | ae | United Arab Emirates | 83600 | 83600 | 0 | 5779760 | 2.58 | 15.43 | 1.97 | 12.36 |
156 | sn | Singapore | 697 | 687 | 10 | 5674472 | 1.89 | 8.27 | 3.43 | 14.05 |
94 | kg | Kyrgyzstan | 199951 | 191801 | 8150 | 5664939 | 1.11 | 22.98 | 6.65 | 5.22 |
48 | da | Denmark | 43094 | 42434 | 660 | 5581503 | 0.22 | 10.27 | 10.25 | 2.2 |
60 | fi | Finland | 338145 | 303815 | 34330 | 5476922 | 0.4 | 10.72 | 9.83 | 3.1 |
157 | lo | Slovakia | 49035 | 48105 | 930 | 5445027 | 0.02 | 9.91 | 9.74 | 0.04 |
34 | ct | Central African Republic | 622984 | 622984 | 0 | 5391539 | 2.13 | 35.08 | 13.8 | 0.0 |
180 | tx | Turkmenistan | 488100 | 469930 | 18170 | 5231422 | 1.14 | 19.4 | 6.13 | 1.84 |
130 | no | Norway | 323802 | 304282 | 19520 | 5207689 | 1.13 | 12.14 | 8.12 | 7.25 |
64 | gg | Georgia | 69700 | 69700 | 0 | 4931226 | 0.08 | 12.74 | 10.82 | 2.7 |
81 | ei | Ireland | 70273 | 68883 | 1390 | 4892305 | 1.25 | 14.84 | 6.48 | 4.09 |
42 | cs | Costa Rica | 51100 | 51060 | 40 | 4814144 | 1.22 | 15.91 | 4.55 | 0.83 |
41 | cf | Congo, Republic of the | 342000 | 341500 | 500 | 4755097 | 2.0 | 35.85 | 10.0 | 5.9 |
44 | hr | Croatia | 56594 | 55974 | 620 | 4464844 | 0.13 | 9.45 | 12.18 | 1.39 |
126 | nz | New Zealand | 267710 | 267710 | None | 4438393 | 0.82 | 13.33 | 7.36 | 2.21 |
99 | li | Liberia | 111369 | 96320 | 15049 | 4195666 | 2.47 | 34.41 | 9.69 | 0.0 |
22 | bk | Bosnia and Herzegovina | 51197 | 51187 | 10 | 3867055 | 0.13 | 8.87 | 9.75 | 0.38 |
134 | pm | Panama | 75420 | 74340 | 1080 | 3657024 | 1.32 | 18.32 | 4.81 | 0.28 |
246 | rq | Puerto Rico | 13791 | 8870 | 4921 | 3598357 | 0.6 | 10.86 | 8.67 | 8.15 |
112 | mr | Mauritania | 1030700 | 1030700 | 0 | 3596702 | 2.23 | 31.34 | 8.2 | 0.83 |
116 | md | Moldova | 33851 | 32891 | 960 | 3546847 | 1.03 | 12.0 | 12.59 | 9.67 |
187 | uy | Uruguay | 176215 | 175015 | 1200 | 3341893 | 0.27 | 13.07 | 9.45 | 0.9 |
131 | mu | Oman | 309500 | 309500 | 0 | 3286936 | 2.07 | 24.44 | 3.36 | 0.43 |
8 | am | Armenia | 29743 | 28203 | 1540 | 3056382 | 0.15 | 13.61 | 9.34 | 5.8 |
2 | al | Albania | 28748 | 27398 | 1350 | 3029278 | 0.3 | 12.92 | 6.58 | 3.3 |
118 | mg | Mongolia | 1564116 | 1553556 | 10560 | 2992908 | 1.31 | 20.25 | 6.35 | 0.84 |
84 | jm | Jamaica | 10991 | 10831 | 160 | 2950210 | 0.68 | 18.16 | 6.7 | 4.66 |
102 | lh | Lithuania | 65300 | 62680 | 2620 | 2884433 | 1.04 | 10.1 | 14.27 | 6.27 |
93 | ku | Kuwait | 17818 | 17818 | 0 | 2788534 | 1.62 | 19.91 | 2.18 | 1.58 |
254 | we | West Bank | 5860 | 5640 | 220 | 2785366 | 1.95 | 22.99 | 3.5 | 0.0 |
122 | wa | Namibia | 824292 | 823290 | 1002 | 2212307 | 0.59 | 19.8 | 13.91 | 0.0 |
141 | qa | Qatar | 11586 | 11586 | 0 | 2194817 | 3.07 | 9.84 | 1.53 | 22.39 |
23 | bc | Botswana | 581730 | 566730 | 15000 | 2182719 | 1.21 | 20.96 | 13.39 | 4.56 |
104 | mk | Macedonia | 25713 | 25433 | 280 | 2096015 | 0.2 | 11.55 | 9.08 | 0.48 |
96 | lg | Latvia | 64589 | 62249 | 2340 | 1986705 | 1.06 | 10.0 | 14.31 | 6.26 |
158 | si | Slovenia | 20273 | 20151 | 122 | 1983412 | 0.26 | 8.42 | 11.37 | 0.37 |
63 | ga | Gambia, The | 11300 | 10120 | 1180 | 1967709 | 2.16 | 30.86 | 7.15 | 2.12 |
98 | lt | Lesotho | 30355 | 30355 | 0 | 1947701 | 0.32 | 25.47 | 14.89 | 7.36 |
92 | kv | Kosovo | 10887 | 10887 | 0 | 1870981 | None | None | None | None |
251 | gz | Gaza Strip | 360 | 360 | 0 | 1869055 | 2.81 | 31.11 | 3.04 | 0.0 |
71 | pu | Guinea-Bissau | 36125 | 28120 | 8005 | 1726170 | 1.91 | 33.38 | 14.33 | 0.0 |
62 | gb | Gabon | 267667 | 257667 | 10000 | 1705336 | 1.93 | 34.49 | 13.12 | 2.03 |
167 | wz | Swaziland | 17364 | 17204 | 160 | 1435613 | 1.11 | 24.67 | 13.56 | 0.0 |
13 | ba | Bahrain | 760 | 760 | 0 | 1346613 | 2.41 | 13.66 | 2.69 | 13.09 |
113 | mp | Mauritius | 2040 | 2030 | 10 | 1339827 | 0.64 | 13.29 | 6.91 | 0.0 |
57 | en | Estonia | 45228 | 42388 | 2840 | 1265420 | 0.55 | 10.51 | 12.4 | 3.6 |
174 | tt | Timor-Leste | 14874 | 14874 | 0 | 1231116 | 2.42 | 34.16 | 6.1 | 3.86 |
177 | td | Trinidad and Tobago | 5128 | 5128 | 0 | 1222363 | 0.13 | 13.46 | 8.56 | 6.25 |
46 | cy | Cyprus | 9251 | 9241 | 10 | 1189197 | 1.43 | 11.41 | 6.62 | 9.48 |
59 | fj | Fiji | 18274 | 18274 | 0 | 909389 | 0.67 | 19.43 | 6.04 | 6.75 |
49 | dj | Djibouti | 23200 | 23180 | 20 | 828324 | 2.2 | 23.65 | 7.73 | 6.06 |
39 | cn | Comoros | 2235 | 2235 | 0 | 780971 | 1.77 | 27.84 | 7.57 | 2.53 |
20 | bt | Bhutan | 38394 | 38394 | 0 | 741919 | 1.11 | 17.78 | 6.69 | 0.0 |
55 | ek | Equatorial Guinea | 28051 | 28051 | 0 | 740743 | 2.51 | 33.31 | 8.19 | 0.0 |
72 | gy | Guyana | 214969 | 196849 | 18120 | 735222 | 0.02 | 15.59 | 7.32 | 8.06 |
119 | mj | Montenegro | 13812 | 13452 | 360 | 647073 | 0.42 | 10.42 | 9.43 | None |
159 | bp | Solomon Islands | 28896 | 27986 | 910 | 622469 | 2.02 | 25.77 | 3.85 | 1.75 |
205 | mc | Macau | 28 | 28 | 0 | 592731 | 0.8 | 8.88 | 4.22 | 3.37 |
166 | ns | Suriname | 163820 | 156000 | 7820 | 579633 | 1.08 | 16.34 | 6.13 | 0.56 |
255 | wi | Western Sahara | 266000 | 266000 | 0 | 570866 | 2.82 | 30.24 | 8.34 | None |
103 | lu | Luxembourg | 2586 | 2586 | 0 | 570252 | 2.13 | 11.37 | 7.24 | 17.16 |
33 | cv | Cabo Verde | 4033 | 4033 | 0 | 545993 | 1.36 | 20.33 | 6.11 | 0.63 |
25 | bx | Brunei | 5765 | 5265 | 500 | 429646 | 1.62 | 17.32 | 3.52 | 2.43 |
110 | mt | Malta | 316 | 316 | 0 | 413965 | 0.31 | 10.18 | 9.09 | 1.98 |
108 | mv | Maldives | 298 | 298 | 0 | 393253 | 0.08 | 15.75 | 3.89 | 12.68 |
18 | bh | Belize | 22966 | 22806 | 160 | 347369 | 1.87 | 24.68 | 5.97 | 0.0 |
76 | ic | Iceland | 103000 | 100250 | 2750 | 331918 | 1.21 | 13.91 | 6.28 | 4.43 |
12 | bf | Bahamas, The | 13880 | 10010 | 3870 | 324597 | 0.85 | 15.5 | 7.05 | 0.0 |
15 | bb | Barbados | 430 | 430 | 0 | 290604 | 0.31 | 11.87 | 8.44 | 0.3 |
209 | fp | French Polynesia | 4167 | 3827 | 340 | 282703 | 0.94 | 15.22 | 5.02 | 0.84 |
189 | nh | Vanuatu | 12189 | 12189 | 0 | 272264 | 1.95 | 25.04 | 4.09 | 1.47 |
211 | nc | New Caledonia | 18575 | 18275 | 300 | 271615 | 1.38 | 15.33 | 5.52 | 4.01 |
148 | ws | Samoa | 2831 | 2821 | 10 | 197773 | 0.58 | 20.87 | 5.32 | 9.78 |
150 | tp | Sao Tome and Principe | 964 | 964 | 0 | 194006 | 1.84 | 34.23 | 7.24 | 8.63 |
146 | st | Saint Lucia | 616 | 606 | 10 | 163922 | 0.34 | 13.7 | 7.42 | 2.93 |
243 | gq | Guam | 544 | 544 | 0 | 161785 | 0.54 | 16.82 | 5.12 | 6.34 |
217 | cc | Curacao | 444 | 444 | 0 | 148406 | 0.43 | 13.8 | 8.2 | 1.4 |
216 | aa | Aruba | 180 | 180 | 0 | 112162 | 1.33 | 12.56 | 8.18 | 8.92 |
68 | gj | Grenada | 344 | 344 | 0 | 110694 | 0.48 | 16.03 | 8.08 | 3.13 |
176 | tn | Tonga | 747 | 717 | 30 | 106501 | 0.03 | 23.0 | 4.85 | 17.84 |
89 | kr | Kiribati | 811 | 811 | 0 | 105711 | 1.15 | 21.46 | 7.12 | 2.87 |
115 | fm | Micronesia, Federated States of | 702 | 702 | 0 | 105216 | 0.46 | 20.54 | 4.23 | 20.93 |
247 | vq | Virgin Islands | 1910 | 346 | 1564 | 103574 | 0.59 | 10.31 | 8.54 | 7.67 |
147 | vc | Saint Vincent and the Grenadines | 389 | 389 | 0 | 102627 | 0.28 | 13.57 | 7.18 | 9.17 |
235 | je | Jersey | 116 | 116 | 0 | 97294 | 0.8 | 11.91 | 7.68 | 3.76 |
6 | ac | Antigua and Barbuda | 442 | 442 | 0 | 92436 | 1.24 | 15.85 | 5.69 | 2.21 |
154 | se | Seychelles | 455 | 455 | 0 | 92430 | 0.83 | 14.19 | 6.89 | 1.0 |
236 | im | Isle of Man | 572 | 572 | 0 | 87545 | 0.76 | 11.1 | 10.06 | 6.56 |
4 | an | Andorra | 468 | 468 | 0 | 85580 | 0.12 | 8.13 | 6.96 | 0.0 |
50 | do | Dominica | 751 | 751 | 0 | 73607 | 0.21 | 15.41 | 7.91 | 5.38 |
111 | rm | Marshall Islands | 181 | 181 | 0 | 72191 | 1.66 | 25.6 | 4.21 | 4.83 |
227 | bd | Bermuda | 54 | 54 | 0 | 70196 | 0.5 | 11.33 | 8.23 | 1.88 |
234 | gk | Guernsey | 78 | 78 | 0 | 66080 | 0.34 | 9.84 | 8.78 | 2.32 |
207 | gl | Greenland | 2166086 | 2166086 | None | 57733 | 0.0 | 14.48 | 8.49 | 5.98 |
230 | cj | Cayman Islands | 264 | 264 | 0 | 56092 | 2.1 | 12.11 | 5.53 | 14.4 |
242 | aq | American Samoa | 199 | 199 | 0 | 54343 | 0.3 | 22.89 | 4.75 | 21.13 |
245 | cq | Northern Mariana Islands | 464 | 464 | 0 | 52344 | 2.18 | 18.32 | 3.71 | 7.16 |
145 | sc | Saint Kitts and Nevis | 261 | 261 | 0 | 51936 | 0.76 | 13.5 | 7.09 | 1.21 |
241 | tk | Turks and Caicos Islands | 948 | 948 | 0 | 50280 | 2.3 | 16.13 | 3.1 | 9.94 |
206 | fo | Faroe Islands | 1393 | 1393 | 0 | 50196 | 0.51 | 13.77 | 8.71 | 0.0 |
218 | sk | Sint Maarten | 34 | 34 | 0 | 39689 | 1.51 | 13.0 | 4.51 | 6.63 |
101 | ls | Liechtenstein | 160 | 160 | 0 | 37624 | 0.84 | 10.45 | 7.12 | 5.08 |
229 | vi | British Virgin Islands | 151 | 151 | 0 | 33454 | 2.32 | 10.91 | 4.99 | 17.28 |
149 | sm | San Marino | 61 | 61 | 0 | 33020 | 0.82 | 8.63 | 8.45 | 8.03 |
213 | rn | Saint Martin | 54 | 54 | None | 31754 | None | None | None | None |
117 | mn | Monaco | 2 | 2 | 0 | 30535 | 0.12 | 6.65 | 9.24 | 3.83 |
233 | gi | Gibraltar | 6 | 6 | 0 | 29258 | 0.24 | 14.08 | 8.37 | 3.28 |
133 | ps | Palau | 459 | 459 | 0 | 21265 | 0.38 | 11.05 | 7.99 | 0.71 |
226 | av | Anguilla | 91 | 91 | 0 | 16418 | 2.03 | 12.67 | 4.57 | 12.18 |
225 | ax | Akrotiri | 123 | None | None | 15700 | None | None | None | None |
231 | dx | Dhekelia | 130 | None | None | 15700 | None | None | None | None |
215 | wf | Wallis and Futuna | 142 | 142 | 0 | 15613 | 0.33 | 13.45 | 5.06 | 5.06 |
181 | tv | Tuvalu | 26 | 26 | 0 | 10869 | 0.82 | 23.74 | 8.74 | 6.81 |
219 | cw | Cook Islands | 236 | 236 | 0 | 9838 | 2.95 | 14.33 | 8.03 | None |
123 | nr | Nauru | 21 | 21 | 0 | 9540 | 0.55 | 24.95 | 5.87 | 13.63 |
239 | sh | Saint Helena, Ascension, and Tristan da Cunha | 308 | 122 | 0 | 7795 | 0.24 | 9.88 | 7.44 | 0.0 |
212 | tb | Saint Barthelemy | None | None | None | 7237 | None | None | None | None |
214 | sb | Saint Pierre and Miquelon | 242 | 242 | 0 | 5657 | 1.08 | 7.42 | 9.72 | 8.49 |
237 | mh | Montserrat | 102 | 102 | 0 | 5241 | 0.5 | 11.26 | 6.3 | 0.0 |
232 | fk | Falkland Islands (Islas Malvinas) | 12173 | 12173 | 0 | 3361 | 0.01 | 10.9 | 4.9 | None |
203 | nf | Norfolk Island | 36 | 36 | 0 | 2210 | 0.01 | None | None | None |
224 | sv | Svalbard | 62045 | 62045 | 0 | 1872 | 0.03 | None | None | None |
199 | kt | Christmas Island | 135 | 135 | 0 | 1530 | 1.11 | None | None | None |
221 | tl | Tokelau | 12 | 12 | 0 | 1337 | 0.01 | None | None | None |
220 | ne | Niue | 260 | 260 | 0 | 1190 | 0.03 | None | None | None |
190 | vt | Holy See (Vatican City) | 0 | 0 | 0 | 842 | 0.0 | None | None | None |
200 | ck | Cocos (Keeling) Islands | 14 | 14 | 0 | 596 | 0.0 | None | None | None |
238 | pc | Pitcairn Islands | 47 | 47 | 0 | 48 | 0.0 | None | None | None |
250 | ay | Antarctica | None | 280000 | None | 0 | None | None | None | None |
198 | at | Ashmore and Cartier Islands | 5 | 5 | 0 | None | None | None | None | None |
201 | cr | Coral Sea Islands | 3 | 3 | 0 | None | None | None | None | None |
202 | hm | Heard Island and McDonald Islands | 412 | 412 | 0 | None | None | None | None | None |
208 | ip | Clipperton Island | 6 | 6 | 0 | None | None | None | None | None |
210 | fs | French Southern and Antarctic Lands | None | None | None | None | None | None | None | None |
222 | bv | Bouvet Island | 49 | 49 | 0 | None | None | None | None | None |
223 | jn | Jan Mayen | 377 | 377 | 0 | None | None | None | None | None |
228 | io | British Indian Ocean Territory | 54400 | 60 | 54340 | None | None | None | None | None |
240 | sx | South Georgia and South Sandwich Islands | 3903 | 3903 | 0 | None | None | None | None | None |
244 | bq | Navassa Island | 5 | 5 | 0 | None | None | None | None | None |
248 | wq | Wake Island | 6 | 6 | 0 | None | None | None | None | None |
249 | um | United States Pacific Island Wildlife Refuges | None | None | None | None | None | None | None | None |
252 | pf | Paracel Islands | 7 | 7 | 0 | None | None | None | None | None |
253 | pg | Spratly Islands | 5 | 5 | 0 | None | None | None | None | None |
256 | xq | Arctic Ocean | None | None | None | None | None | None | None | None |
257 | zh | Atlantic Ocean | None | None | None | None | None | None | None | None |
258 | xo | Indian Ocean | None | None | None | None | None | None | None | None |
259 | zn | Pacific Ocean | None | None | None | None | None | None | None | None |
260 | oo | Southern Ocean | None | None | None | None | None | None | None | None |
%%sql
SELECT *
FROM facts
WHERE name != "World"
ORDER BY population_growth DESC;
Done.
id | code | name | area | area_land | area_water | population | population_growth | birth_rate | death_rate | migration_rate |
---|---|---|---|---|---|---|---|---|---|---|
162 | od | South Sudan | 644329 | None | None | 12042910 | 4.02 | 36.91 | 8.18 | 11.47 |
106 | mi | Malawi | 118484 | 94080 | 24404 | 17964697 | 3.32 | 41.56 | 8.41 | 0.0 |
29 | by | Burundi | 27830 | 25680 | 2150 | 10742276 | 3.28 | 42.01 | 9.27 | 0.0 |
128 | ng | Niger | None | 1266700 | 300 | 18045729 | 3.25 | 45.45 | 12.42 | 0.56 |
182 | ug | Uganda | 241038 | 197100 | 43938 | 37101745 | 3.24 | 43.79 | 10.69 | 0.74 |
141 | qa | Qatar | 11586 | 11586 | 0 | 2194817 | 3.07 | 9.84 | 1.53 | 22.39 |
27 | uv | Burkina Faso | 274200 | 273800 | 400 | 18931686 | 3.03 | 42.03 | 11.72 | 0.0 |
109 | ml | Mali | 1240192 | 1220190 | 20002 | 16955536 | 2.98 | 44.99 | 12.89 | 2.26 |
219 | cw | Cook Islands | 236 | 236 | 0 | 9838 | 2.95 | 14.33 | 8.03 | None |
80 | iz | Iraq | 438317 | 437367 | 950 | 37056169 | 2.93 | 31.45 | 3.77 | 1.62 |
58 | et | Ethiopia | 1104300 | None | 104300 | 99465819 | 2.89 | 37.27 | 8.19 | 0.22 |
194 | za | Zambia | 752618 | 743398 | 9220 | 15066266 | 2.88 | 42.13 | 12.67 | 0.68 |
255 | wi | Western Sahara | 266000 | 266000 | 0 | 570866 | 2.82 | 30.24 | 8.34 | None |
251 | gz | Gaza Strip | 360 | 360 | 0 | 1869055 | 2.81 | 31.11 | 3.04 | 0.0 |
172 | tz | Tanzania | 947300 | 885800 | 61500 | 51045882 | 2.79 | 36.39 | 8.0 | 0.54 |
5 | ao | Angola | 1246700 | 1246700 | 0 | 19625353 | 2.78 | 38.78 | 11.49 | 0.46 |
19 | bn | Benin | 112622 | 110622 | 2000 | 10448647 | 2.78 | 36.02 | 8.21 | 0.0 |
175 | to | Togo | 56785 | 54385 | 2400 | 7552318 | 2.69 | 34.13 | 7.26 | 0.0 |
70 | gv | Guinea | 245857 | 245717 | 140 | 11780162 | 2.63 | 35.74 | 9.46 | 0.0 |
31 | cm | Cameroon | 475440 | 472710 | 2730 | 23739218 | 2.59 | 36.17 | 10.11 | 0.15 |
105 | ma | Madagascar | 587041 | 581540 | 5501 | 23812681 | 2.58 | 32.61 | 6.81 | 0.0 |
184 | ae | United Arab Emirates | 83600 | 83600 | 0 | 5779760 | 2.58 | 15.43 | 1.97 | 12.36 |
144 | rw | Rwanda | 26338 | 24668 | 1670 | 12661733 | 2.56 | 33.75 | 8.96 | 0.85 |
55 | ek | Equatorial Guinea | 28051 | 28051 | 0 | 740743 | 2.51 | 33.31 | 8.19 | 0.0 |
99 | li | Liberia | 111369 | 96320 | 15049 | 4195666 | 2.47 | 34.41 | 9.69 | 0.0 |
193 | ym | Yemen | 527968 | 527968 | 0 | 26737317 | 2.47 | 29.98 | 6.28 | 1.0 |
40 | cg | Congo, Democratic Republic of the | 2344858 | 2267048 | 77810 | 79375136 | 2.45 | 34.88 | 10.07 | 0.27 |
121 | mz | Mozambique | 799380 | 786380 | 13000 | 25303113 | 2.45 | 38.58 | 12.1 | 1.98 |
129 | ni | Nigeria | 923768 | 910768 | 13000 | 181562056 | 2.45 | 37.64 | 12.9 | 0.22 |
152 | sg | Senegal | 196722 | 192530 | 4192 | 13975834 | 2.45 | 34.52 | 8.46 | 1.59 |
174 | tt | Timor-Leste | 14874 | 14874 | 0 | 1231116 | 2.42 | 34.16 | 6.1 | 3.86 |
13 | ba | Bahrain | 760 | 760 | 0 | 1346613 | 2.41 | 13.66 | 2.69 | 13.09 |
155 | sl | Sierra Leone | 71740 | 71620 | 120 | 5879098 | 2.35 | 37.03 | 10.81 | 2.77 |
1 | af | Afghanistan | 652230 | 652230 | 0 | 32564342 | 2.32 | 38.57 | 13.89 | 1.51 |
229 | vi | British Virgin Islands | 151 | 151 | 0 | 33454 | 2.32 | 10.91 | 4.99 | 17.28 |
241 | tk | Turks and Caicos Islands | 948 | 948 | 0 | 50280 | 2.3 | 16.13 | 3.1 | 9.94 |
56 | er | Eritrea | 117600 | 101000 | 16600 | 6527689 | 2.25 | 30.0 | 7.52 | 0.0 |
100 | ly | Libya | 1759540 | 1759540 | 0 | 6411776 | 2.23 | 18.03 | 3.58 | 7.8 |
112 | mr | Mauritania | 1030700 | 1030700 | 0 | 3596702 | 2.23 | 31.34 | 8.2 | 0.83 |
195 | zi | Zimbabwe | 390757 | 386847 | 3910 | 14229541 | 2.21 | 32.26 | 10.13 | 0.0 |
49 | dj | Djibouti | 23200 | 23180 | 20 | 828324 | 2.2 | 23.65 | 7.73 | 6.06 |
66 | gh | Ghana | 238533 | 227533 | 11000 | 26327649 | 2.18 | 31.09 | 7.22 | 2.02 |
245 | cq | Northern Mariana Islands | 464 | 464 | 0 | 52344 | 2.18 | 18.32 | 3.71 | 7.16 |
63 | ga | Gambia, The | 11300 | 10120 | 1180 | 1967709 | 2.16 | 30.86 | 7.15 | 2.12 |
34 | ct | Central African Republic | 622984 | 622984 | 0 | 5391539 | 2.13 | 35.08 | 13.8 | 0.0 |
103 | lu | Luxembourg | 2586 | 2586 | 0 | 570252 | 2.13 | 11.37 | 7.24 | 17.16 |
230 | cj | Cayman Islands | 264 | 264 | 0 | 56092 | 2.1 | 12.11 | 5.53 | 14.4 |
131 | mu | Oman | 309500 | 309500 | 0 | 3286936 | 2.07 | 24.44 | 3.36 | 0.43 |
226 | av | Anguilla | 91 | 91 | 0 | 16418 | 2.03 | 12.67 | 4.57 | 12.18 |
159 | bp | Solomon Islands | 28896 | 27986 | 910 | 622469 | 2.02 | 25.77 | 3.85 | 1.75 |
41 | cf | Congo, Republic of the | 342000 | 341500 | 500 | 4755097 | 2.0 | 35.85 | 10.0 | 5.9 |
189 | nh | Vanuatu | 12189 | 12189 | 0 | 272264 | 1.95 | 25.04 | 4.09 | 1.47 |
254 | we | West Bank | 5860 | 5640 | 220 | 2785366 | 1.95 | 22.99 | 3.5 | 0.0 |
62 | gb | Gabon | 267667 | 257667 | 10000 | 1705336 | 1.93 | 34.49 | 13.12 | 2.03 |
88 | ke | Kenya | 580367 | 569140 | 11227 | 45925301 | 1.93 | 26.4 | 6.89 | 0.22 |
43 | iv | Cote d'Ivoire | 322463 | 318003 | 4460 | 23295302 | 1.91 | 28.67 | 9.55 | 0.0 |
71 | pu | Guinea-Bissau | 36125 | 28120 | 8005 | 1726170 | 1.91 | 33.38 | 14.33 | 0.0 |
35 | cd | Chad | None | 1259200 | 24800 | 11631456 | 1.89 | 36.6 | 14.28 | 3.45 |
156 | sn | Singapore | 697 | 687 | 10 | 5674472 | 1.89 | 8.27 | 3.43 | 14.05 |
18 | bh | Belize | 22966 | 22806 | 160 | 347369 | 1.87 | 24.68 | 5.97 | 0.0 |
3 | ag | Algeria | 2381741 | 2381741 | 0 | 39542166 | 1.84 | 23.67 | 4.31 | 0.92 |
150 | tp | Sao Tome and Principe | 964 | 964 | 0 | 194006 | 1.84 | 34.23 | 7.24 | 8.63 |
160 | so | Somalia | 637657 | 627337 | 10320 | 10616380 | 1.83 | 40.45 | 13.62 | 8.49 |
69 | gt | Guatemala | 108889 | 107159 | 1730 | 14918999 | 1.82 | 24.89 | 4.77 | 1.97 |
53 | eg | Egypt | 1001450 | 995450 | 6000 | 88487396 | 1.79 | 22.9 | 4.77 | 0.19 |
124 | np | Nepal | 147181 | 143351 | 3830 | 31551305 | 1.79 | 20.64 | 6.56 | 3.86 |
135 | pp | Papua New Guinea | 462840 | 452860 | 9980 | 6672429 | 1.78 | 24.38 | 6.53 | 0.0 |
39 | cn | Comoros | 2235 | 2235 | 0 | 780971 | 1.77 | 27.84 | 7.57 | 2.53 |
165 | su | Sudan | 1861484 | None | None | 36108853 | 1.72 | 29.19 | 7.66 | 4.29 |
171 | ti | Tajikistan | 144100 | 141510 | 2590 | 8191958 | 1.71 | 24.38 | 6.18 | 1.15 |
74 | ho | Honduras | 112090 | 111890 | 200 | 8746673 | 1.68 | 23.14 | 5.17 | 1.16 |
111 | rm | Marshall Islands | 181 | 181 | 0 | 72191 | 1.66 | 25.6 | 4.21 | 4.83 |
25 | bx | Brunei | 5765 | 5265 | 500 | 429646 | 1.62 | 17.32 | 3.52 | 2.43 |
93 | ku | Kuwait | 17818 | 17818 | 0 | 2788534 | 1.62 | 19.91 | 2.18 | 1.58 |
138 | rp | Philippines | 300000 | 298170 | 1830 | 100998376 | 1.61 | 24.27 | 6.11 | 2.09 |
14 | bg | Bangladesh | 148460 | 130170 | 18290 | 168957745 | 1.6 | 21.14 | 5.61 | 0.46 |
30 | cb | Cambodia | 181035 | 176515 | 4520 | 15708756 | 1.58 | 23.83 | 7.68 | 0.32 |
21 | bl | Bolivia | 1098581 | 1083301 | 15280 | 10800882 | 1.56 | 22.76 | 6.52 | 0.62 |
82 | is | Israel | 20770 | 20330 | 440 | 8049314 | 1.56 | 18.48 | 5.15 | 2.24 |
95 | la | Laos | 236800 | 230800 | 6000 | 6911544 | 1.55 | 24.25 | 7.63 | 1.09 |
218 | sk | Sint Maarten | 34 | 34 | 0 | 39689 | 1.51 | 13.0 | 4.51 | 6.63 |
132 | pk | Pakistan | 796095 | 770875 | 25220 | 199085847 | 1.46 | 22.58 | 6.49 | 1.54 |
151 | sa | Saudi Arabia | 2149690 | 2149690 | 0 | 27752316 | 1.46 | 18.51 | 3.33 | 0.55 |
107 | my | Malaysia | 329847 | 328657 | 1190 | 30513848 | 1.44 | 19.71 | 5.03 | 0.33 |
46 | cy | Cyprus | 9251 | 9241 | 10 | 1189197 | 1.43 | 11.41 | 6.62 | 9.48 |
191 | ve | Venezuela | 912050 | 882050 | 30000 | 29275460 | 1.39 | 19.16 | 5.31 | 0.0 |
211 | nc | New Caledonia | 18575 | 18275 | 300 | 271615 | 1.38 | 15.33 | 5.52 | 4.01 |
33 | cv | Cabo Verde | 4033 | 4033 | 0 | 545993 | 1.36 | 20.33 | 6.11 | 0.63 |
52 | ec | Ecuador | 283561 | 276841 | 6720 | 15868396 | 1.35 | 18.51 | 5.06 | 0.0 |
161 | sf | South Africa | 1219090 | 1214470 | 4620 | 53675563 | 1.33 | 20.75 | 9.91 | 2.42 |
216 | aa | Aruba | 180 | 180 | 0 | 112162 | 1.33 | 12.56 | 8.18 | 8.92 |
134 | pm | Panama | 75420 | 74340 | 1080 | 3657024 | 1.32 | 18.32 | 4.81 | 0.28 |
118 | mg | Mongolia | 1564116 | 1553556 | 10560 | 2992908 | 1.31 | 20.25 | 6.35 | 0.84 |
179 | tu | Turkey | 783562 | 769632 | 13930 | 79414269 | 1.26 | 16.33 | 5.88 | 2.16 |
81 | ei | Ireland | 70273 | 68883 | 1390 | 4892305 | 1.25 | 14.84 | 6.48 | 4.09 |
6 | ac | Antigua and Barbuda | 442 | 442 | 0 | 92436 | 1.24 | 15.85 | 5.69 | 2.21 |
51 | dr | Dominican Republic | 48670 | 48320 | 350 | 10478756 | 1.23 | 18.73 | 4.55 | 1.91 |
42 | cs | Costa Rica | 51100 | 51060 | 40 | 4814144 | 1.22 | 15.91 | 4.55 | 0.83 |
77 | in | India | 3287263 | 2973193 | 314070 | 1251695584 | 1.22 | 19.55 | 7.32 | 0.04 |
23 | bc | Botswana | 581730 | 566730 | 15000 | 2182719 | 1.21 | 20.96 | 13.39 | 4.56 |
76 | ic | Iceland | 103000 | 100250 | 2750 | 331918 | 1.21 | 13.91 | 6.28 | 4.43 |
79 | ir | Iran | 1648195 | 1531595 | 116600 | 81824270 | 1.2 | 17.99 | 5.94 | 0.07 |
114 | mx | Mexico | 1964375 | 1943945 | 20430 | 121736809 | 1.18 | 18.78 | 5.26 | 1.68 |
73 | ha | Haiti | 27750 | 27560 | 190 | 10110019 | 1.17 | 22.31 | 7.83 | 2.76 |
136 | pa | Paraguay | 406752 | 397302 | 9450 | 6783272 | 1.16 | 16.37 | 4.68 | 0.07 |
89 | kr | Kiribati | 811 | 811 | 0 | 105711 | 1.15 | 21.46 | 7.12 | 2.87 |
87 | kz | Kazakhstan | 2724900 | 2699700 | 25200 | 18157122 | 1.14 | 19.15 | 8.21 | 0.41 |
180 | tx | Turkmenistan | 488100 | 469930 | 18170 | 5231422 | 1.14 | 19.4 | 6.13 | 1.84 |
130 | no | Norway | 323802 | 304282 | 19520 | 5207689 | 1.13 | 12.14 | 8.12 | 7.25 |
20 | bt | Bhutan | 38394 | 38394 | 0 | 741919 | 1.11 | 17.78 | 6.69 | 0.0 |
94 | kg | Kyrgyzstan | 199951 | 191801 | 8150 | 5664939 | 1.11 | 22.98 | 6.65 | 5.22 |
167 | wz | Swaziland | 17364 | 17204 | 160 | 1435613 | 1.11 | 24.67 | 13.56 | 0.0 |
199 | kt | Christmas Island | 135 | 135 | 0 | 1530 | 1.11 | None | None | None |
166 | ns | Suriname | 163820 | 156000 | 7820 | 579633 | 1.08 | 16.34 | 6.13 | 0.56 |
214 | sb | Saint Pierre and Miquelon | 242 | 242 | 0 | 5657 | 1.08 | 7.42 | 9.72 | 8.49 |
9 | as | Australia | 7741220 | 7682300 | 58920 | 22751014 | 1.07 | 12.15 | 7.14 | 5.65 |
96 | lg | Latvia | 64589 | 62249 | 2340 | 1986705 | 1.06 | 10.0 | 14.31 | 6.26 |
38 | co | Colombia | 1138910 | 1038700 | 100210 | 46736728 | 1.04 | 16.47 | 5.4 | 0.64 |
102 | lh | Lithuania | 65300 | 62680 | 2620 | 2884433 | 1.04 | 10.1 | 14.27 | 6.27 |
116 | md | Moldova | 33851 | 32891 | 960 | 3546847 | 1.03 | 12.0 | 12.59 | 9.67 |
28 | bm | Burma | 676578 | 653508 | 23070 | 56320206 | 1.01 | 18.39 | 7.96 | 0.28 |
120 | mo | Morocco | 446550 | 446300 | 250 | 33322699 | 1.0 | 18.2 | 4.81 | 3.36 |
127 | nu | Nicaragua | 130370 | 119990 | 10380 | 5907881 | 1.0 | 18.03 | 5.08 | 3.0 |
137 | pe | Peru | 1285216 | 1279996 | 5220 | 30444999 | 0.97 | 18.28 | 6.01 | 2.53 |
192 | vm | Vietnam | 331210 | 310070 | 21140 | 94348835 | 0.97 | 15.96 | 5.93 | 0.3 |
11 | aj | Azerbaijan | 86600 | 82629 | 3971 | 9780780 | 0.96 | 16.64 | 7.07 | 0.0 |
209 | fp | French Polynesia | 4167 | 3827 | 340 | 282703 | 0.94 | 15.22 | 5.02 | 0.84 |
7 | ar | Argentina | 2780400 | 2736690 | 43710 | 43431886 | 0.93 | 16.64 | 7.33 | 0.0 |
188 | uz | Uzbekistan | 447400 | 425400 | 22000 | 29199942 | 0.93 | 17.0 | 5.3 | 2.37 |
78 | id | Indonesia | 1904569 | 1811569 | 93000 | 255993674 | 0.92 | 16.72 | 6.37 | 1.16 |
163 | sp | Spain | 505370 | 498980 | 6390 | 48146134 | 0.89 | 9.64 | 9.04 | 8.31 |
178 | ts | Tunisia | 163610 | 155360 | 8250 | 11037225 | 0.89 | 16.64 | 5.98 | 1.73 |
97 | le | Lebanon | 10400 | 10230 | 170 | 6184701 | 0.86 | 14.59 | 4.88 | 1.1 |
12 | bf | Bahamas, The | 13880 | 10010 | 3870 | 324597 | 0.85 | 15.5 | 7.05 | 0.0 |
101 | ls | Liechtenstein | 160 | 160 | 0 | 37624 | 0.84 | 10.45 | 7.12 | 5.08 |
164 | ce | Sri Lanka | 65610 | 64630 | 980 | 22053488 | 0.84 | 15.85 | 6.11 | 1.35 |
86 | jo | Jordan | 89342 | 88802 | 540 | 8117564 | 0.83 | 25.37 | 3.79 | 13.24 |
154 | se | Seychelles | 455 | 455 | 0 | 92430 | 0.83 | 14.19 | 6.89 | 1.0 |
36 | ci | Chile | 756102 | 743812 | 12290 | 17508260 | 0.82 | 13.83 | 6.0 | 0.34 |
126 | nz | New Zealand | 267710 | 267710 | None | 4438393 | 0.82 | 13.33 | 7.36 | 2.21 |
149 | sm | San Marino | 61 | 61 | 0 | 33020 | 0.82 | 8.63 | 8.45 | 8.03 |
181 | tv | Tuvalu | 26 | 26 | 0 | 10869 | 0.82 | 23.74 | 8.74 | 6.81 |
168 | sw | Sweden | 450295 | 410335 | 39960 | 9801616 | 0.8 | 11.99 | 9.4 | 5.42 |
205 | mc | Macau | 28 | 28 | 0 | 592731 | 0.8 | 8.88 | 4.22 | 3.37 |
235 | je | Jersey | 116 | 116 | 0 | 97294 | 0.8 | 11.91 | 7.68 | 3.76 |
186 | us | United States | 9826675 | 9161966 | 664709 | 321368864 | 0.78 | 12.49 | 8.15 | 3.86 |
24 | br | Brazil | 8515770 | 8358140 | 157630 | 204259812 | 0.77 | 14.46 | 6.58 | 0.14 |
17 | be | Belgium | 30528 | 30278 | 250 | 11323973 | 0.76 | 11.41 | 9.63 | 5.87 |
145 | sc | Saint Kitts and Nevis | 261 | 261 | 0 | 51936 | 0.76 | 13.5 | 7.09 | 1.21 |
236 | im | Isle of Man | 572 | 572 | 0 | 87545 | 0.76 | 11.1 | 10.06 | 6.56 |
32 | ca | Canada | 9984670 | 9093507 | 891163 | 35099836 | 0.75 | 10.28 | 8.42 | 5.66 |
169 | sz | Switzerland | 41277 | 39997 | 1280 | 8121830 | 0.71 | 10.5 | 8.13 | 4.74 |
84 | jm | Jamaica | 10991 | 10831 | 160 | 2950210 | 0.68 | 18.16 | 6.7 | 4.66 |
59 | fj | Fiji | 18274 | 18274 | 0 | 909389 | 0.67 | 19.43 | 6.04 | 6.75 |
113 | mp | Mauritius | 2040 | 2030 | 10 | 1339827 | 0.64 | 13.29 | 6.91 | 0.0 |
183 | up | Ukraine | 603550 | 579330 | 24220 | 44429471 | 0.6 | 10.72 | 14.46 | 2.25 |
246 | rq | Puerto Rico | 13791 | 8870 | 4921 | 3598357 | 0.6 | 10.86 | 8.67 | 8.15 |
122 | wa | Namibia | 824292 | 823290 | 1002 | 2212307 | 0.59 | 19.8 | 13.91 | 0.0 |
247 | vq | Virgin Islands | 1910 | 346 | 1564 | 103574 | 0.59 | 10.31 | 8.54 | 7.67 |
26 | bu | Bulgaria | 110879 | 108489 | 2390 | 7186893 | 0.58 | 8.92 | 14.44 | 0.29 |
148 | ws | Samoa | 2831 | 2821 | 10 | 197773 | 0.58 | 20.87 | 5.32 | 9.78 |
10 | au | Austria | 83871 | 82445 | 1426 | 8665550 | 0.55 | 9.41 | 9.42 | 5.56 |
57 | en | Estonia | 45228 | 42388 | 2840 | 1265420 | 0.55 | 10.51 | 12.4 | 3.6 |
123 | nr | Nauru | 21 | 21 | 0 | 9540 | 0.55 | 24.95 | 5.87 | 13.63 |
185 | uk | United Kingdom | 243610 | 241930 | 1680 | 64088222 | 0.54 | 12.17 | 9.35 | 2.54 |
243 | gq | Guam | 544 | 544 | 0 | 161785 | 0.54 | 16.82 | 5.12 | 6.34 |
90 | kn | Korea, North | 120538 | 120408 | 130 | 24983205 | 0.53 | 14.52 | 9.21 | 0.04 |
206 | fo | Faroe Islands | 1393 | 1393 | 0 | 50196 | 0.51 | 13.77 | 8.71 | 0.0 |
227 | bd | Bermuda | 54 | 54 | 0 | 70196 | 0.5 | 11.33 | 8.23 | 1.88 |
237 | mh | Montserrat | 102 | 102 | 0 | 5241 | 0.5 | 11.26 | 6.3 | 0.0 |
68 | gj | Grenada | 344 | 344 | 0 | 110694 | 0.48 | 16.03 | 8.08 | 3.13 |
115 | fm | Micronesia, Federated States of | 702 | 702 | 0 | 105216 | 0.46 | 20.54 | 4.23 | 20.93 |
153 | ri | Serbia | 77474 | 77474 | 0 | 7176794 | 0.46 | 9.08 | 13.66 | 0.0 |
37 | ch | China | 9596960 | 9326410 | 270550 | 1367485388 | 0.45 | 12.49 | 7.53 | 0.44 |
61 | fr | France | 643801 | 640427 | 3374 | 66553766 | 0.43 | 12.38 | 9.16 | 1.09 |
217 | cc | Curacao | 444 | 444 | 0 | 148406 | 0.43 | 13.8 | 8.2 | 1.4 |
119 | mj | Montenegro | 13812 | 13452 | 360 | 647073 | 0.42 | 10.42 | 9.43 | None |
125 | nl | Netherlands | 41543 | 33893 | 7650 | 16947904 | 0.41 | 10.83 | 8.66 | 1.95 |
60 | fi | Finland | 338145 | 303815 | 34330 | 5476922 | 0.4 | 10.72 | 9.83 | 3.1 |
133 | ps | Palau | 459 | 459 | 0 | 21265 | 0.38 | 11.05 | 7.99 | 0.71 |
204 | hk | Hong Kong | 1108 | 1073 | 35 | 7141106 | 0.38 | 9.23 | 7.07 | 1.68 |
146 | st | Saint Lucia | 616 | 606 | 10 | 163922 | 0.34 | 13.7 | 7.42 | 2.93 |
173 | th | Thailand | 513120 | 510890 | 2230 | 67976405 | 0.34 | 11.19 | 7.8 | 0.0 |
234 | gk | Guernsey | 78 | 78 | 0 | 66080 | 0.34 | 9.84 | 8.78 | 2.32 |
215 | wf | Wallis and Futuna | 142 | 142 | 0 | 15613 | 0.33 | 13.45 | 5.06 | 5.06 |
98 | lt | Lesotho | 30355 | 30355 | 0 | 1947701 | 0.32 | 25.47 | 14.89 | 7.36 |
15 | bb | Barbados | 430 | 430 | 0 | 290604 | 0.31 | 11.87 | 8.44 | 0.3 |
110 | mt | Malta | 316 | 316 | 0 | 413965 | 0.31 | 10.18 | 9.09 | 1.98 |
2 | al | Albania | 28748 | 27398 | 1350 | 3029278 | 0.3 | 12.92 | 6.58 | 3.3 |
142 | ro | Romania | 238391 | 229891 | 8500 | 21666350 | 0.3 | 9.14 | 11.9 | 0.24 |
242 | aq | American Samoa | 199 | 199 | 0 | 54343 | 0.3 | 22.89 | 4.75 | 21.13 |
147 | vc | Saint Vincent and the Grenadines | 389 | 389 | 0 | 102627 | 0.28 | 13.57 | 7.18 | 9.17 |
83 | it | Italy | 301340 | 294140 | 7200 | 61855120 | 0.27 | 8.74 | 10.19 | 4.1 |
187 | uy | Uruguay | 176215 | 175015 | 1200 | 3341893 | 0.27 | 13.07 | 9.45 | 0.9 |
158 | si | Slovenia | 20273 | 20151 | 122 | 1983412 | 0.26 | 8.42 | 11.37 | 0.37 |
54 | es | El Salvador | 21041 | 20721 | 320 | 6141350 | 0.25 | 16.46 | 5.69 | 8.28 |
197 | ee | European Union | 4324782 | None | None | 513949445 | 0.25 | 10.2 | 10.2 | 2.5 |
233 | gi | Gibraltar | 6 | 6 | 0 | 29258 | 0.24 | 14.08 | 8.37 | 3.28 |
239 | sh | Saint Helena, Ascension, and Tristan da Cunha | 308 | 122 | 0 | 7795 | 0.24 | 9.88 | 7.44 | 0.0 |
196 | tw | Taiwan | 35980 | 32260 | 3720 | 23415126 | 0.23 | 8.47 | 7.11 | 0.89 |
48 | da | Denmark | 43094 | 42434 | 660 | 5581503 | 0.22 | 10.27 | 10.25 | 2.2 |
75 | hu | Hungary | 93028 | 89608 | 3420 | 9897541 | 0.22 | 9.16 | 12.73 | 1.33 |
50 | do | Dominica | 751 | 751 | 0 | 73607 | 0.21 | 15.41 | 7.91 | 5.38 |
16 | bo | Belarus | 207600 | 202900 | 4700 | 9589689 | 0.2 | 10.7 | 13.36 | 0.7 |
104 | mk | Macedonia | 25713 | 25433 | 280 | 2096015 | 0.2 | 11.55 | 9.08 | 0.48 |
65 | gm | Germany | 357022 | 348672 | 8350 | 80854408 | 0.17 | 8.47 | 11.42 | 1.24 |
47 | ez | Czech Republic | 78867 | 77247 | 1620 | 10644842 | 0.16 | 9.63 | 10.34 | 2.33 |
85 | ja | Japan | 377915 | 364485 | 13430 | 126919659 | 0.16 | 7.93 | 9.51 | 0.0 |
170 | sy | Syria | 185180 | 183630 | 1550 | 17064854 | 0.16 | 22.17 | 4.0 | 19.79 |
8 | am | Armenia | 29743 | 28203 | 1540 | 3056382 | 0.15 | 13.61 | 9.34 | 5.8 |
45 | cu | Cuba | 110860 | 109820 | 1040 | 11031433 | 0.15 | 9.9 | 7.72 | 3.66 |
91 | ks | Korea, South | 99720 | 96920 | 2800 | 49115196 | 0.14 | 8.19 | 6.75 | 0.0 |
22 | bk | Bosnia and Herzegovina | 51197 | 51187 | 10 | 3867055 | 0.13 | 8.87 | 9.75 | 0.38 |
44 | hr | Croatia | 56594 | 55974 | 620 | 4464844 | 0.13 | 9.45 | 12.18 | 1.39 |
177 | td | Trinidad and Tobago | 5128 | 5128 | 0 | 1222363 | 0.13 | 13.46 | 8.56 | 6.25 |
4 | an | Andorra | 468 | 468 | 0 | 85580 | 0.12 | 8.13 | 6.96 | 0.0 |
117 | mn | Monaco | 2 | 2 | 0 | 30535 | 0.12 | 6.65 | 9.24 | 3.83 |
139 | pl | Poland | 312685 | 304255 | 8430 | 38562189 | 0.09 | 9.74 | 10.19 | 0.46 |
140 | po | Portugal | 92090 | 91470 | 620 | 10825309 | 0.09 | 9.27 | 11.02 | 2.67 |
64 | gg | Georgia | 69700 | 69700 | 0 | 4931226 | 0.08 | 12.74 | 10.82 | 2.7 |
108 | mv | Maldives | 298 | 298 | 0 | 393253 | 0.08 | 15.75 | 3.89 | 12.68 |
143 | rs | Russia | 17098242 | 16377742 | 720500 | 142423773 | 0.04 | 11.6 | 13.69 | 1.69 |
176 | tn | Tonga | 747 | 717 | 30 | 106501 | 0.03 | 23.0 | 4.85 | 17.84 |
220 | ne | Niue | 260 | 260 | 0 | 1190 | 0.03 | None | None | None |
224 | sv | Svalbard | 62045 | 62045 | 0 | 1872 | 0.03 | None | None | None |
72 | gy | Guyana | 214969 | 196849 | 18120 | 735222 | 0.02 | 15.59 | 7.32 | 8.06 |
157 | lo | Slovakia | 49035 | 48105 | 930 | 5445027 | 0.02 | 9.91 | 9.74 | 0.04 |
67 | gr | Greece | 131957 | 130647 | 1310 | 10775643 | 0.01 | 8.66 | 11.09 | 2.32 |
203 | nf | Norfolk Island | 36 | 36 | 0 | 2210 | 0.01 | None | None | None |
221 | tl | Tokelau | 12 | 12 | 0 | 1337 | 0.01 | None | None | None |
232 | fk | Falkland Islands (Islas Malvinas) | 12173 | 12173 | 0 | 3361 | 0.01 | 10.9 | 4.9 | None |
190 | vt | Holy See (Vatican City) | 0 | 0 | 0 | 842 | 0.0 | None | None | None |
200 | ck | Cocos (Keeling) Islands | 14 | 14 | 0 | 596 | 0.0 | None | None | None |
207 | gl | Greenland | 2166086 | 2166086 | None | 57733 | 0.0 | 14.48 | 8.49 | 5.98 |
238 | pc | Pitcairn Islands | 47 | 47 | 0 | 48 | 0.0 | None | None | None |
92 | kv | Kosovo | 10887 | 10887 | 0 | 1870981 | None | None | None | None |
198 | at | Ashmore and Cartier Islands | 5 | 5 | 0 | None | None | None | None | None |
201 | cr | Coral Sea Islands | 3 | 3 | 0 | None | None | None | None | None |
202 | hm | Heard Island and McDonald Islands | 412 | 412 | 0 | None | None | None | None | None |
208 | ip | Clipperton Island | 6 | 6 | 0 | None | None | None | None | None |
210 | fs | French Southern and Antarctic Lands | None | None | None | None | None | None | None | None |
212 | tb | Saint Barthelemy | None | None | None | 7237 | None | None | None | None |
213 | rn | Saint Martin | 54 | 54 | None | 31754 | None | None | None | None |
222 | bv | Bouvet Island | 49 | 49 | 0 | None | None | None | None | None |
223 | jn | Jan Mayen | 377 | 377 | 0 | None | None | None | None | None |
225 | ax | Akrotiri | 123 | None | None | 15700 | None | None | None | None |
228 | io | British Indian Ocean Territory | 54400 | 60 | 54340 | None | None | None | None | None |
231 | dx | Dhekelia | 130 | None | None | 15700 | None | None | None | None |
240 | sx | South Georgia and South Sandwich Islands | 3903 | 3903 | 0 | None | None | None | None | None |
244 | bq | Navassa Island | 5 | 5 | 0 | None | None | None | None | None |
248 | wq | Wake Island | 6 | 6 | 0 | None | None | None | None | None |
249 | um | United States Pacific Island Wildlife Refuges | None | None | None | None | None | None | None | None |
250 | ay | Antarctica | None | 280000 | None | 0 | None | None | None | None |
252 | pf | Paracel Islands | 7 | 7 | 0 | None | None | None | None | None |
253 | pg | Spratly Islands | 5 | 5 | 0 | None | None | None | None | None |
256 | xq | Arctic Ocean | None | None | None | None | None | None | None | None |
257 | zh | Atlantic Ocean | None | None | None | None | None | None | None | None |
258 | xo | Indian Ocean | None | None | None | None | None | None | None | None |
259 | zn | Pacific Ocean | None | None | None | None | None | None | None | None |
260 | oo | Southern Ocean | None | None | None | None | None | None | None | None |
%%sql
SELECT name, area_water, area_land, CAST(area_water AS FLOAT)/ CAST(area_land AS FLOAT) AS "ratio"
FROM facts
ORDER BY ratio DESC
LIMIT 5;
Done.
name | area_water | area_land | ratio |
---|---|---|---|
British Indian Ocean Territory | 54340 | 60 | 905.6666666666666 |
Virgin Islands | 1564 | 346 | 4.520231213872832 |
Puerto Rico | 4921 | 8870 | 0.5547914317925592 |
Bahamas, The | 3870 | 10010 | 0.3866133866133866 |
Guinea-Bissau | 8005 | 28120 | 0.2846728307254623 |
Looking at the data, it seems that the countries with the highest water-to-land ratio are
British Indian Ocean Territory (Have more water than land)
Virgin Islands (Have more water than land)
Puerto Rico
The Bahamas
Guinea-Bissau
%%sql
SELECT name, population_growth
FROM facts
ORDER BY population_growth DESC
LIMIT 10;
Done.
name | population_growth |
---|---|
South Sudan | 4.02 |
Malawi | 3.32 |
Burundi | 3.28 |
Niger | 3.25 |
Uganda | 3.24 |
Qatar | 3.07 |
Burkina Faso | 3.03 |
Mali | 2.98 |
Cook Islands | 2.95 |
Iraq | 2.93 |
South Sudan looks to be the nation with the highest population growth. The rest of the nations pertain to nations in Africa.
%%sql
SELECT name,
death_rate,
birth_rate,
CAST(death_rate AS FLOAT)/CAST(birth_rate AS FLOAT) AS "Ratio"
FROM facts
ORDER BY Ratio DESC
LIMIT 20;
Done.
name | death_rate | birth_rate | Ratio |
---|---|---|---|
Bulgaria | 14.44 | 8.92 | 1.6188340807174888 |
Serbia | 13.66 | 9.08 | 1.5044052863436124 |
Latvia | 14.31 | 10.0 | 1.431 |
Lithuania | 14.27 | 10.1 | 1.4128712871287128 |
Hungary | 12.73 | 9.16 | 1.3897379912663756 |
Monaco | 9.24 | 6.65 | 1.3894736842105262 |
Slovenia | 11.37 | 8.42 | 1.350356294536817 |
Ukraine | 14.46 | 10.72 | 1.3488805970149254 |
Germany | 11.42 | 8.47 | 1.3482880755608027 |
Saint Pierre and Miquelon | 9.72 | 7.42 | 1.3099730458221026 |
Romania | 11.9 | 9.14 | 1.3019693654266957 |
Croatia | 12.18 | 9.45 | 1.288888888888889 |
Greece | 11.09 | 8.66 | 1.2806004618937643 |
Belarus | 13.36 | 10.7 | 1.2485981308411216 |
Japan | 9.51 | 7.93 | 1.1992433795712485 |
Portugal | 11.02 | 9.27 | 1.1887810140237325 |
Russia | 13.69 | 11.6 | 1.1801724137931033 |
Estonia | 12.4 | 10.51 | 1.1798287345385348 |
Italy | 10.19 | 8.74 | 1.165903890160183 |
Bosnia and Herzegovina | 9.75 | 8.87 | 1.0992108229988726 |
Top nation with the highest ratio of Death-to-Birth is Bulgaria with the rest of the top 5-6 correspond to nations in Eastern Europe.
%%sql
SELECT name,
population,
area,
CAST(population AS FLOAT)/CAST(area AS FLOAT) AS "Ratio"
FROM facts
ORDER BY Ratio DESC
LIMIT 10;
Done.
name | population | area | Ratio |
---|---|---|---|
Macau | 592731 | 28 | 21168.964285714286 |
Monaco | 30535 | 2 | 15267.5 |
Singapore | 5674472 | 697 | 8141.279770444763 |
Hong Kong | 7141106 | 1108 | 6445.041516245487 |
Gaza Strip | 1869055 | 360 | 5191.819444444444 |
Gibraltar | 29258 | 6 | 4876.333333333333 |
Bahrain | 1346613 | 760 | 1771.8592105263158 |
Maldives | 393253 | 298 | 1319.6409395973155 |
Malta | 413965 | 316 | 1310.01582278481 |
Bermuda | 70196 | 54 | 1299.9259259259259 |
The country with the highest population/area ratio is Macau, followed by Monaco, Singapore and Hong Kong. These nations differ greatly from the nations previously mentioned above.