%%capture
%load_ext sql
%sql sqlite:///factbook.db
'Connected: None@factbook.db'
%%sql
SELECT name, max(population) As sum_Pop
From facts
WHERE name <> 'World'
Group By name
Having sum_Pop = max(population)
ORDER BY sum_Pop DESC;
Done.
name | sum_Pop |
---|---|
China | 1367485388 |
India | 1251695584 |
European Union | 513949445 |
United States | 321368864 |
Indonesia | 255993674 |
Brazil | 204259812 |
Pakistan | 199085847 |
Nigeria | 181562056 |
Bangladesh | 168957745 |
Russia | 142423773 |
Japan | 126919659 |
Mexico | 121736809 |
Philippines | 100998376 |
Ethiopia | 99465819 |
Vietnam | 94348835 |
Egypt | 88487396 |
Iran | 81824270 |
Germany | 80854408 |
Turkey | 79414269 |
Congo, Democratic Republic of the | 79375136 |
Thailand | 67976405 |
France | 66553766 |
United Kingdom | 64088222 |
Italy | 61855120 |
Burma | 56320206 |
South Africa | 53675563 |
Tanzania | 51045882 |
Korea, South | 49115196 |
Spain | 48146134 |
Colombia | 46736728 |
Kenya | 45925301 |
Ukraine | 44429471 |
Argentina | 43431886 |
Algeria | 39542166 |
Poland | 38562189 |
Uganda | 37101745 |
Iraq | 37056169 |
Sudan | 36108853 |
Canada | 35099836 |
Morocco | 33322699 |
Afghanistan | 32564342 |
Nepal | 31551305 |
Malaysia | 30513848 |
Peru | 30444999 |
Venezuela | 29275460 |
Uzbekistan | 29199942 |
Saudi Arabia | 27752316 |
Yemen | 26737317 |
Ghana | 26327649 |
Mozambique | 25303113 |
Korea, North | 24983205 |
Madagascar | 23812681 |
Cameroon | 23739218 |
Taiwan | 23415126 |
Cote d'Ivoire | 23295302 |
Australia | 22751014 |
Sri Lanka | 22053488 |
Romania | 21666350 |
Angola | 19625353 |
Burkina Faso | 18931686 |
Kazakhstan | 18157122 |
Niger | 18045729 |
Malawi | 17964697 |
Chile | 17508260 |
Syria | 17064854 |
Mali | 16955536 |
Netherlands | 16947904 |
Ecuador | 15868396 |
Cambodia | 15708756 |
Zambia | 15066266 |
Guatemala | 14918999 |
Zimbabwe | 14229541 |
Senegal | 13975834 |
Rwanda | 12661733 |
South Sudan | 12042910 |
Guinea | 11780162 |
Chad | 11631456 |
Belgium | 11323973 |
Tunisia | 11037225 |
Cuba | 11031433 |
Portugal | 10825309 |
Bolivia | 10800882 |
Greece | 10775643 |
Burundi | 10742276 |
Czech Republic | 10644842 |
Somalia | 10616380 |
Dominican Republic | 10478756 |
Benin | 10448647 |
Haiti | 10110019 |
Hungary | 9897541 |
Sweden | 9801616 |
Azerbaijan | 9780780 |
Belarus | 9589689 |
Honduras | 8746673 |
Austria | 8665550 |
Tajikistan | 8191958 |
Switzerland | 8121830 |
Jordan | 8117564 |
Israel | 8049314 |
Togo | 7552318 |
Bulgaria | 7186893 |
Serbia | 7176794 |
Hong Kong | 7141106 |
Laos | 6911544 |
Paraguay | 6783272 |
Papua New Guinea | 6672429 |
Eritrea | 6527689 |
Libya | 6411776 |
Lebanon | 6184701 |
El Salvador | 6141350 |
Nicaragua | 5907881 |
Sierra Leone | 5879098 |
United Arab Emirates | 5779760 |
Singapore | 5674472 |
Kyrgyzstan | 5664939 |
Denmark | 5581503 |
Finland | 5476922 |
Slovakia | 5445027 |
Central African Republic | 5391539 |
Turkmenistan | 5231422 |
Norway | 5207689 |
Georgia | 4931226 |
Ireland | 4892305 |
Costa Rica | 4814144 |
Congo, Republic of the | 4755097 |
Croatia | 4464844 |
New Zealand | 4438393 |
Liberia | 4195666 |
Bosnia and Herzegovina | 3867055 |
Panama | 3657024 |
Puerto Rico | 3598357 |
Mauritania | 3596702 |
Moldova | 3546847 |
Uruguay | 3341893 |
Oman | 3286936 |
Armenia | 3056382 |
Albania | 3029278 |
Mongolia | 2992908 |
Jamaica | 2950210 |
Lithuania | 2884433 |
Kuwait | 2788534 |
West Bank | 2785366 |
Namibia | 2212307 |
Qatar | 2194817 |
Botswana | 2182719 |
Macedonia | 2096015 |
Latvia | 1986705 |
Slovenia | 1983412 |
Gambia, The | 1967709 |
Lesotho | 1947701 |
Kosovo | 1870981 |
Gaza Strip | 1869055 |
Guinea-Bissau | 1726170 |
Gabon | 1705336 |
Swaziland | 1435613 |
Bahrain | 1346613 |
Mauritius | 1339827 |
Estonia | 1265420 |
Timor-Leste | 1231116 |
Trinidad and Tobago | 1222363 |
Cyprus | 1189197 |
Fiji | 909389 |
Djibouti | 828324 |
Comoros | 780971 |
Bhutan | 741919 |
Equatorial Guinea | 740743 |
Guyana | 735222 |
Montenegro | 647073 |
Solomon Islands | 622469 |
Macau | 592731 |
Suriname | 579633 |
Western Sahara | 570866 |
Luxembourg | 570252 |
Cabo Verde | 545993 |
Brunei | 429646 |
Malta | 413965 |
Maldives | 393253 |
Belize | 347369 |
Iceland | 331918 |
Bahamas, The | 324597 |
Barbados | 290604 |
French Polynesia | 282703 |
Vanuatu | 272264 |
New Caledonia | 271615 |
Samoa | 197773 |
Sao Tome and Principe | 194006 |
Saint Lucia | 163922 |
Guam | 161785 |
Curacao | 148406 |
Aruba | 112162 |
Grenada | 110694 |
Tonga | 106501 |
Kiribati | 105711 |
Micronesia, Federated States of | 105216 |
Virgin Islands | 103574 |
Saint Vincent and the Grenadines | 102627 |
Jersey | 97294 |
Antigua and Barbuda | 92436 |
Seychelles | 92430 |
Isle of Man | 87545 |
Andorra | 85580 |
Dominica | 73607 |
Marshall Islands | 72191 |
Bermuda | 70196 |
Guernsey | 66080 |
Greenland | 57733 |
Cayman Islands | 56092 |
American Samoa | 54343 |
Northern Mariana Islands | 52344 |
Saint Kitts and Nevis | 51936 |
Turks and Caicos Islands | 50280 |
Faroe Islands | 50196 |
Sint Maarten | 39689 |
Liechtenstein | 37624 |
British Virgin Islands | 33454 |
San Marino | 33020 |
Saint Martin | 31754 |
Monaco | 30535 |
Gibraltar | 29258 |
Palau | 21265 |
Anguilla | 16418 |
Akrotiri | 15700 |
Dhekelia | 15700 |
Wallis and Futuna | 15613 |
Tuvalu | 10869 |
Cook Islands | 9838 |
Nauru | 9540 |
Saint Helena, Ascension, and Tristan da Cunha | 7795 |
Saint Barthelemy | 7237 |
Saint Pierre and Miquelon | 5657 |
Montserrat | 5241 |
Falkland Islands (Islas Malvinas) | 3361 |
Norfolk Island | 2210 |
Svalbard | 1872 |
Christmas Island | 1530 |
Tokelau | 1337 |
Niue | 1190 |
Holy See (Vatican City) | 842 |
Cocos (Keeling) Islands | 596 |
Pitcairn Islands | 48 |
Antarctica | 0 |
%%sql
SELECT name, max(population_growth) As sum_Pop_growth
From facts
WHERE name <> 'World'
Group By name
Having sum_Pop_growth = max(population_growth)
ORDER BY sum_Pop_growth DESC;
Done.
name | sum_Pop_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 |
Ethiopia | 2.89 |
Zambia | 2.88 |
Western Sahara | 2.82 |
Gaza Strip | 2.81 |
Tanzania | 2.79 |
Angola | 2.78 |
Benin | 2.78 |
Togo | 2.69 |
Guinea | 2.63 |
Cameroon | 2.59 |
Madagascar | 2.58 |
United Arab Emirates | 2.58 |
Rwanda | 2.56 |
Equatorial Guinea | 2.51 |
Liberia | 2.47 |
Yemen | 2.47 |
Congo, Democratic Republic of the | 2.45 |
Mozambique | 2.45 |
Nigeria | 2.45 |
Senegal | 2.45 |
Timor-Leste | 2.42 |
Bahrain | 2.41 |
Sierra Leone | 2.35 |
Afghanistan | 2.32 |
British Virgin Islands | 2.32 |
Turks and Caicos Islands | 2.3 |
Eritrea | 2.25 |
Libya | 2.23 |
Mauritania | 2.23 |
Zimbabwe | 2.21 |
Djibouti | 2.2 |
Ghana | 2.18 |
Northern Mariana Islands | 2.18 |
Gambia, The | 2.16 |
Central African Republic | 2.13 |
Luxembourg | 2.13 |
Cayman Islands | 2.1 |
Oman | 2.07 |
Anguilla | 2.03 |
Solomon Islands | 2.02 |
Congo, Republic of the | 2.0 |
Vanuatu | 1.95 |
West Bank | 1.95 |
Gabon | 1.93 |
Kenya | 1.93 |
Cote d'Ivoire | 1.91 |
Guinea-Bissau | 1.91 |
Chad | 1.89 |
Singapore | 1.89 |
Belize | 1.87 |
Algeria | 1.84 |
Sao Tome and Principe | 1.84 |
Somalia | 1.83 |
Guatemala | 1.82 |
Egypt | 1.79 |
Nepal | 1.79 |
Papua New Guinea | 1.78 |
Comoros | 1.77 |
Sudan | 1.72 |
Tajikistan | 1.71 |
Honduras | 1.68 |
Marshall Islands | 1.66 |
Brunei | 1.62 |
Kuwait | 1.62 |
Philippines | 1.61 |
Bangladesh | 1.6 |
Cambodia | 1.58 |
Bolivia | 1.56 |
Israel | 1.56 |
Laos | 1.55 |
Sint Maarten | 1.51 |
Pakistan | 1.46 |
Saudi Arabia | 1.46 |
Malaysia | 1.44 |
Cyprus | 1.43 |
Venezuela | 1.39 |
New Caledonia | 1.38 |
Cabo Verde | 1.36 |
Ecuador | 1.35 |
Aruba | 1.33 |
South Africa | 1.33 |
Panama | 1.32 |
Mongolia | 1.31 |
Turkey | 1.26 |
Ireland | 1.25 |
Antigua and Barbuda | 1.24 |
Dominican Republic | 1.23 |
Costa Rica | 1.22 |
India | 1.22 |
Botswana | 1.21 |
Iceland | 1.21 |
Iran | 1.2 |
Mexico | 1.18 |
Haiti | 1.17 |
Paraguay | 1.16 |
Kiribati | 1.15 |
Kazakhstan | 1.14 |
Turkmenistan | 1.14 |
Norway | 1.13 |
Bhutan | 1.11 |
Christmas Island | 1.11 |
Kyrgyzstan | 1.11 |
Swaziland | 1.11 |
Saint Pierre and Miquelon | 1.08 |
Suriname | 1.08 |
Australia | 1.07 |
Latvia | 1.06 |
Colombia | 1.04 |
Lithuania | 1.04 |
Moldova | 1.03 |
Burma | 1.01 |
Morocco | 1.0 |
Nicaragua | 1.0 |
Peru | 0.97 |
Vietnam | 0.97 |
Azerbaijan | 0.96 |
French Polynesia | 0.94 |
Argentina | 0.93 |
Uzbekistan | 0.93 |
Indonesia | 0.92 |
Spain | 0.89 |
Tunisia | 0.89 |
Lebanon | 0.86 |
Bahamas, The | 0.85 |
Liechtenstein | 0.84 |
Sri Lanka | 0.84 |
Jordan | 0.83 |
Seychelles | 0.83 |
Chile | 0.82 |
New Zealand | 0.82 |
San Marino | 0.82 |
Tuvalu | 0.82 |
Jersey | 0.8 |
Macau | 0.8 |
Sweden | 0.8 |
United States | 0.78 |
Brazil | 0.77 |
Belgium | 0.76 |
Isle of Man | 0.76 |
Saint Kitts and Nevis | 0.76 |
Canada | 0.75 |
Switzerland | 0.71 |
Jamaica | 0.68 |
Fiji | 0.67 |
Mauritius | 0.64 |
Puerto Rico | 0.6 |
Ukraine | 0.6 |
Namibia | 0.59 |
Virgin Islands | 0.59 |
Bulgaria | 0.58 |
Samoa | 0.58 |
Austria | 0.55 |
Estonia | 0.55 |
Nauru | 0.55 |
Guam | 0.54 |
United Kingdom | 0.54 |
Korea, North | 0.53 |
Faroe Islands | 0.51 |
Bermuda | 0.5 |
Montserrat | 0.5 |
Grenada | 0.48 |
Micronesia, Federated States of | 0.46 |
Serbia | 0.46 |
China | 0.45 |
Curacao | 0.43 |
France | 0.43 |
Montenegro | 0.42 |
Netherlands | 0.41 |
Finland | 0.4 |
Hong Kong | 0.38 |
Palau | 0.38 |
Guernsey | 0.34 |
Saint Lucia | 0.34 |
Thailand | 0.34 |
Wallis and Futuna | 0.33 |
Lesotho | 0.32 |
Barbados | 0.31 |
Malta | 0.31 |
Albania | 0.3 |
American Samoa | 0.3 |
Romania | 0.3 |
Saint Vincent and the Grenadines | 0.28 |
Italy | 0.27 |
Uruguay | 0.27 |
Slovenia | 0.26 |
El Salvador | 0.25 |
European Union | 0.25 |
Gibraltar | 0.24 |
Saint Helena, Ascension, and Tristan da Cunha | 0.24 |
Taiwan | 0.23 |
Denmark | 0.22 |
Hungary | 0.22 |
Dominica | 0.21 |
Belarus | 0.2 |
Macedonia | 0.2 |
Germany | 0.17 |
Czech Republic | 0.16 |
Japan | 0.16 |
Syria | 0.16 |
Armenia | 0.15 |
Cuba | 0.15 |
Korea, South | 0.14 |
Bosnia and Herzegovina | 0.13 |
Croatia | 0.13 |
Trinidad and Tobago | 0.13 |
Andorra | 0.12 |
Monaco | 0.12 |
Poland | 0.09 |
Portugal | 0.09 |
Georgia | 0.08 |
Maldives | 0.08 |
Russia | 0.04 |
Niue | 0.03 |
Svalbard | 0.03 |
Tonga | 0.03 |
Guyana | 0.02 |
Slovakia | 0.02 |
Falkland Islands (Islas Malvinas) | 0.01 |
Greece | 0.01 |
Norfolk Island | 0.01 |
Tokelau | 0.01 |
Cocos (Keeling) Islands | 0.0 |
Greenland | 0.0 |
Holy See (Vatican City) | 0.0 |
Pitcairn Islands | 0.0 |
%%sql
SELECT name, AVG(area_land), AVG(area_water)
From facts
WHERE area_water > area_land;
Done.
name | AVG(area_land) | AVG(area_water) |
---|---|---|
Virgin Islands | 203.0 | 27952.0 |
%%sql
SELECT name, area_land, area_water
From facts
WHERE area_water > area_land;
Done.
name | area_land | area_water |
---|---|---|
British Indian Ocean Territory | 60 | 54340 |
Virgin Islands | 346 | 1564 |
%%sql
SELECT name, max(death_rate) As sum_death_rate
From facts
WHERE name <> 'World'
Group By name
Having sum_death_rate = max(death_rate)
ORDER BY sum_death_rate DESC;
Done.
name | sum_death_rate |
---|---|
Lesotho | 14.89 |
Ukraine | 14.46 |
Bulgaria | 14.44 |
Guinea-Bissau | 14.33 |
Latvia | 14.31 |
Chad | 14.28 |
Lithuania | 14.27 |
Namibia | 13.91 |
Afghanistan | 13.89 |
Central African Republic | 13.8 |
Russia | 13.69 |
Serbia | 13.66 |
Somalia | 13.62 |
Swaziland | 13.56 |
Botswana | 13.39 |
Belarus | 13.36 |
Gabon | 13.12 |
Nigeria | 12.9 |
Mali | 12.89 |
Hungary | 12.73 |
Zambia | 12.67 |
Moldova | 12.59 |
Niger | 12.42 |
Estonia | 12.4 |
Croatia | 12.18 |
Mozambique | 12.1 |
Romania | 11.9 |
Burkina Faso | 11.72 |
Angola | 11.49 |
Germany | 11.42 |
Slovenia | 11.37 |
Greece | 11.09 |
Portugal | 11.02 |
Georgia | 10.82 |
Sierra Leone | 10.81 |
Uganda | 10.69 |
Czech Republic | 10.34 |
Denmark | 10.25 |
European Union | 10.2 |
Italy | 10.19 |
Poland | 10.19 |
Zimbabwe | 10.13 |
Cameroon | 10.11 |
Congo, Democratic Republic of the | 10.07 |
Isle of Man | 10.06 |
Congo, Republic of the | 10.0 |
South Africa | 9.91 |
Finland | 9.83 |
Bosnia and Herzegovina | 9.75 |
Slovakia | 9.74 |
Saint Pierre and Miquelon | 9.72 |
Liberia | 9.69 |
Belgium | 9.63 |
Cote d'Ivoire | 9.55 |
Japan | 9.51 |
Guinea | 9.46 |
Uruguay | 9.45 |
Montenegro | 9.43 |
Austria | 9.42 |
Sweden | 9.4 |
United Kingdom | 9.35 |
Armenia | 9.34 |
Burundi | 9.27 |
Monaco | 9.24 |
Korea, North | 9.21 |
France | 9.16 |
Malta | 9.09 |
Macedonia | 9.08 |
Spain | 9.04 |
Rwanda | 8.96 |
Guernsey | 8.78 |
Tuvalu | 8.74 |
Faroe Islands | 8.71 |
Puerto Rico | 8.67 |
Netherlands | 8.66 |
Trinidad and Tobago | 8.56 |
Virgin Islands | 8.54 |
Greenland | 8.49 |
Senegal | 8.46 |
San Marino | 8.45 |
Barbados | 8.44 |
Canada | 8.42 |
Malawi | 8.41 |
Gibraltar | 8.37 |
Western Sahara | 8.34 |
Bermuda | 8.23 |
Benin | 8.21 |
Kazakhstan | 8.21 |
Curacao | 8.2 |
Mauritania | 8.2 |
Equatorial Guinea | 8.19 |
Ethiopia | 8.19 |
Aruba | 8.18 |
South Sudan | 8.18 |
United States | 8.15 |
Switzerland | 8.13 |
Norway | 8.12 |
Grenada | 8.08 |
Cook Islands | 8.03 |
Tanzania | 8.0 |
Palau | 7.99 |
Burma | 7.96 |
Dominica | 7.91 |
Haiti | 7.83 |
Thailand | 7.8 |
Djibouti | 7.73 |
Cuba | 7.72 |
Cambodia | 7.68 |
Jersey | 7.68 |
Sudan | 7.66 |
Laos | 7.63 |
Comoros | 7.57 |
China | 7.53 |
Eritrea | 7.52 |
Saint Helena, Ascension, and Tristan da Cunha | 7.44 |
Saint Lucia | 7.42 |
New Zealand | 7.36 |
Argentina | 7.33 |
Guyana | 7.32 |
India | 7.32 |
Togo | 7.26 |
Luxembourg | 7.24 |
Sao Tome and Principe | 7.24 |
Ghana | 7.22 |
Saint Vincent and the Grenadines | 7.18 |
Gambia, The | 7.15 |
Australia | 7.14 |
Kiribati | 7.12 |
Liechtenstein | 7.12 |
Taiwan | 7.11 |
Saint Kitts and Nevis | 7.09 |
Azerbaijan | 7.07 |
Hong Kong | 7.07 |
Bahamas, The | 7.05 |
Andorra | 6.96 |
Mauritius | 6.91 |
Kenya | 6.89 |
Seychelles | 6.89 |
Madagascar | 6.81 |
Korea, South | 6.75 |
Jamaica | 6.7 |
Bhutan | 6.69 |
Kyrgyzstan | 6.65 |
Cyprus | 6.62 |
Albania | 6.58 |
Brazil | 6.58 |
Nepal | 6.56 |
Papua New Guinea | 6.53 |
Bolivia | 6.52 |
Pakistan | 6.49 |
Ireland | 6.48 |
Indonesia | 6.37 |
Mongolia | 6.35 |
Montserrat | 6.3 |
Iceland | 6.28 |
Yemen | 6.28 |
Tajikistan | 6.18 |
Suriname | 6.13 |
Turkmenistan | 6.13 |
Cabo Verde | 6.11 |
Philippines | 6.11 |
Sri Lanka | 6.11 |
Timor-Leste | 6.1 |
Fiji | 6.04 |
Peru | 6.01 |
Chile | 6.0 |
Tunisia | 5.98 |
Belize | 5.97 |
Iran | 5.94 |
Vietnam | 5.93 |
Turkey | 5.88 |
Nauru | 5.87 |
Antigua and Barbuda | 5.69 |
El Salvador | 5.69 |
Bangladesh | 5.61 |
Cayman Islands | 5.53 |
New Caledonia | 5.52 |
Colombia | 5.4 |
Samoa | 5.32 |
Venezuela | 5.31 |
Uzbekistan | 5.3 |
Mexico | 5.26 |
Honduras | 5.17 |
Israel | 5.15 |
Guam | 5.12 |
Nicaragua | 5.08 |
Ecuador | 5.06 |
Wallis and Futuna | 5.06 |
Malaysia | 5.03 |
French Polynesia | 5.02 |
British Virgin Islands | 4.99 |
Falkland Islands (Islas Malvinas) | 4.9 |
Lebanon | 4.88 |
Tonga | 4.85 |
Morocco | 4.81 |
Panama | 4.81 |
Egypt | 4.77 |
Guatemala | 4.77 |
American Samoa | 4.75 |
Paraguay | 4.68 |
Anguilla | 4.57 |
Costa Rica | 4.55 |
Dominican Republic | 4.55 |
Sint Maarten | 4.51 |
Algeria | 4.31 |
Micronesia, Federated States of | 4.23 |
Macau | 4.22 |
Marshall Islands | 4.21 |
Vanuatu | 4.09 |
Syria | 4.0 |
Maldives | 3.89 |
Solomon Islands | 3.85 |
Jordan | 3.79 |
Iraq | 3.77 |
Northern Mariana Islands | 3.71 |
Libya | 3.58 |
Brunei | 3.52 |
West Bank | 3.5 |
Singapore | 3.43 |
Oman | 3.36 |
Saudi Arabia | 3.33 |
Turks and Caicos Islands | 3.1 |
Gaza Strip | 3.04 |
Bahrain | 2.69 |
Kuwait | 2.18 |
United Arab Emirates | 1.97 |
Qatar | 1.53 |
%%sql
SELECT *
FROM facts
WHERE population > (SELECT AVG(population)
FROM facts
WHERE name <> 'World'
)
AND area > (SELECT AVG(area)
FROM facts
WHERE name <> 'World'
);
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 |
3 | ag | Algeria | 2381741 | 2381741 | 0 | 39542166 | 1.84 | 23.67 | 4.31 | 0.92 |
7 | ar | Argentina | 2780400 | 2736690 | 43710 | 43431886 | 0.93 | 16.64 | 7.33 | 0.0 |
24 | br | Brazil | 8515770 | 8358140 | 157630 | 204259812 | 0.77 | 14.46 | 6.58 | 0.14 |
28 | bm | Burma | 676578 | 653508 | 23070 | 56320206 | 1.01 | 18.39 | 7.96 | 0.28 |
32 | ca | Canada | 9984670 | 9093507 | 891163 | 35099836 | 0.75 | 10.28 | 8.42 | 5.66 |
37 | ch | China | 9596960 | 9326410 | 270550 | 1367485388 | 0.45 | 12.49 | 7.53 | 0.44 |
38 | co | Colombia | 1138910 | 1038700 | 100210 | 46736728 | 1.04 | 16.47 | 5.4 | 0.64 |
40 | cg | Congo, Democratic Republic of the | 2344858 | 2267048 | 77810 | 79375136 | 2.45 | 34.88 | 10.07 | 0.27 |
53 | eg | Egypt | 1001450 | 995450 | 6000 | 88487396 | 1.79 | 22.9 | 4.77 | 0.19 |
58 | et | Ethiopia | 1104300 | None | 104300 | 99465819 | 2.89 | 37.27 | 8.19 | 0.22 |
61 | fr | France | 643801 | 640427 | 3374 | 66553766 | 0.43 | 12.38 | 9.16 | 1.09 |
77 | in | India | 3287263 | 2973193 | 314070 | 1251695584 | 1.22 | 19.55 | 7.32 | 0.04 |
78 | id | Indonesia | 1904569 | 1811569 | 93000 | 255993674 | 0.92 | 16.72 | 6.37 | 1.16 |
79 | ir | Iran | 1648195 | 1531595 | 116600 | 81824270 | 1.2 | 17.99 | 5.94 | 0.07 |
88 | ke | Kenya | 580367 | 569140 | 11227 | 45925301 | 1.93 | 26.4 | 6.89 | 0.22 |
114 | mx | Mexico | 1964375 | 1943945 | 20430 | 121736809 | 1.18 | 18.78 | 5.26 | 1.68 |
129 | ni | Nigeria | 923768 | 910768 | 13000 | 181562056 | 2.45 | 37.64 | 12.9 | 0.22 |
132 | pk | Pakistan | 796095 | 770875 | 25220 | 199085847 | 1.46 | 22.58 | 6.49 | 1.54 |
143 | rs | Russia | 17098242 | 16377742 | 720500 | 142423773 | 0.04 | 11.6 | 13.69 | 1.69 |
161 | sf | South Africa | 1219090 | 1214470 | 4620 | 53675563 | 1.33 | 20.75 | 9.91 | 2.42 |
165 | su | Sudan | 1861484 | None | None | 36108853 | 1.72 | 29.19 | 7.66 | 4.29 |
172 | tz | Tanzania | 947300 | 885800 | 61500 | 51045882 | 2.79 | 36.39 | 8.0 | 0.54 |
179 | tu | Turkey | 783562 | 769632 | 13930 | 79414269 | 1.26 | 16.33 | 5.88 | 2.16 |
183 | up | Ukraine | 603550 | 579330 | 24220 | 44429471 | 0.6 | 10.72 | 14.46 | 2.25 |
186 | us | United States | 9826675 | 9161966 | 664709 | 321368864 | 0.78 | 12.49 | 8.15 | 3.86 |
197 | ee | European Union | 4324782 | None | None | 513949445 | 0.25 | 10.2 | 10.2 | 2.5 |