In [3]:
%%capture
%load_ext sql
%sql sqlite:///factbook.db
Out[3]:
'Connected: None@factbook.db'
In [2]:
%%sql
SELECT *
  FROM sqlite_master
 WHERE type='table';
Done.
Out[2]:
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)
In [3]:
%%sql
SELECT *
FROM facts
LIMIT 5;
Done.
Out[3]:
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
In [5]:
%%sql
SELECT MIN(population), MAX(population), MIN(population_growth),MAX(population_growth)
FROM facts;
Done.
Out[5]:
MIN(population) MAX(population) MIN(population_growth) MAX(population_growth)
0 7256490011 0.0 4.02
In [10]:
%%sql
SELECT 
name, MIN(population)
FROM facts;
Done.
Out[10]:
name MIN(population)
Antarctica 0
In [11]:
%%sql
SELECT 
name, MAX(population)
FROM facts;
Done.
Out[11]:
name MAX(population)
World 7256490011
In [12]:
%%sql
SELECT MIN(population), MAX(population), MIN(population_growth),MAX(population_growth)
FROM facts
WHERE name <> 'World';
Done.
Out[12]:
MIN(population) MAX(population) MIN(population_growth) MAX(population_growth)
0 1367485388 0.0 4.02
In [16]:
%%sql
SELECT
AVG(population), AVG(area)
FROM facts
WHERE name <> 'World';
Done.
Out[16]:
AVG(population) AVG(area)
32242666.56846473 555093.546184739
In [24]:
%%sql
SELECT
name, population, area
FROM facts
WHERE population > (SELECT
                    AVG(population)
                    FROM facts WHERE name <> 'World')
  AND area < (SELECT
              AVG(area)
              FROM facts WHERE name <> 'World');
                    
Done.
Out[24]:
name population area
Bangladesh 168957745 148460
Germany 80854408 357022
Iraq 37056169 438317
Italy 61855120 301340
Japan 126919659 377915
Korea, South 49115196 99720
Morocco 33322699 446550
Philippines 100998376 300000
Poland 38562189 312685
Spain 48146134 505370
Thailand 67976405 513120
Uganda 37101745 241038
United Kingdom 64088222 243610
Vietnam 94348835 331210
In [27]:
%%sql
SELECT name, MAX(population)
FROM facts
WHERE name <> 'World';
Done.
Out[27]:
name MAX(population)
China 1367485388
In [28]:
%%sql
SELECT name, MAX(population_growth)
FROM facts
WHERE name <> 'World';
Done.
Out[28]:
name MAX(population_growth)
South Sudan 4.02
In [32]:
%%sql
SELECT
name, CAST(area_water AS Float) / CAST(area_land AS Float) AS 'ration_water_to_land'
FROM facts
ORDER BY ration_water_to_land DESC;
Done.
Out[32]:
name ration_water_to_land
British Indian Ocean Territory 905.6666666666666
Virgin Islands 4.520231213872832
Puerto Rico 0.5547914317925592
Bahamas, The 0.3866133866133866
Guinea-Bissau 0.2846728307254623
Malawi 0.25939625850340137
Netherlands 0.22571032366565366
Uganda 0.22292237442922375
Eritrea 0.16435643564356436
Liberia 0.15623961794019933
Bangladesh 0.1405085657217485
Gambia, The 0.116600790513834
Taiwan 0.1153130812151271
Finland 0.11299639583299047
India 0.10563390940312317
Canada 0.09799992456155804
Sweden 0.09738384490720996
Colombia 0.09647636468662751
Brunei 0.0949667616334283
Guyana 0.09205025171578214
French Polynesia 0.08884243532793311
Nicaragua 0.08650720893407784
Burundi 0.0837227414330218
Iran 0.07612978626856316
United States 0.07255091319919764
Tanzania 0.06942876495822985
Vietnam 0.06817815332021801
Rwanda 0.06769904329495703
Estonia 0.06700009436633009
Norway 0.06415101780585115
Armenia 0.054604120129064286
Tunisia 0.05310247167868177
Uzbekistan 0.051716031969910675
Indonesia 0.0513367141963679
Suriname 0.05012820512820513
Albania 0.04927366961092051
Ghana 0.048344635723169826
Azerbaijan 0.048058187803313605
Togo 0.044129815206398824
Russia 0.04399263341674328
Kyrgyzstan 0.04249195781043894
Tonga 0.04184100418410042
Ukraine 0.04180691488443547
Lithuania 0.041799617102744095
West Bank 0.03900709219858156
Gabon 0.03880978161735884
Turkmenistan 0.038665333134722195
Hungary 0.038166235157575217
Latvia 0.03759096531671192
Romania 0.03697404422095689
Japan 0.036846509458551106
Burma 0.03530178666519767
Congo, Democratic Republic of the 0.03432216697661452
Venezuela 0.034011677342554274
Pakistan 0.03271606940165397
Hong Kong 0.032618825722273995
Solomon Islands 0.03251625812906453
Switzerland 0.032002400180013504
Moldova 0.029187315679061143
China 0.029009018475490568
Korea, South 0.028889806025588115
Poland 0.027707022070302872
Iceland 0.02743142144638404
Montenegro 0.026761819803746655
Nepal 0.02671763712844696
Botswana 0.026467630088401885
Laos 0.025996533795493933
Cambodia 0.025606888932951873
Italy 0.024478139661385734
Ecuador 0.02427386116940771
Germany 0.023948008443465493
Paraguay 0.023785432743857318
Belarus 0.023164120256283883
Papua New Guinea 0.022037715850373184
Bulgaria 0.022029883213966393
Senegal 0.02177323014595128
Israel 0.02164289227742253
Czech Republic 0.02097168822090178
Ireland 0.02017914434621024
Kenya 0.019726253645851635
Chad 0.019695044472681066
Slovakia 0.01933270969753664
Brazil 0.018859459161966657
Tajikistan 0.018302593456292843
Turkey 0.018099559269884827
Benin 0.018079586339064563
Austria 0.017296379404451452
Lebanon 0.016617790811339198
Mozambique 0.016531447900506115
Chile 0.01652299236903949
Saint Lucia 0.0165016501650165
Somalia 0.016450488334021428
New Caledonia 0.016415868673050615
Mali 0.016392529032363812
Guatemala 0.016144234268703515
Argentina 0.015971849204696183
Denmark 0.015553565537069332
El Salvador 0.015443270112446311
Sri Lanka 0.01516323688689463
Jamaica 0.01477241251961961
Singapore 0.01455604075691412
Panama 0.014527845036319613
Nigeria 0.014273667937389104
Bolivia 0.014105036365700761
Cote d'Ivoire 0.014025024921148543
Spain 0.012806124493967693
Zambia 0.012402508481324943
Croatia 0.011076571265230286
Macedonia 0.011009318601816538
Mexico 0.010509556597537481
Zimbabwe 0.010107355104214328
Greece 0.010027019372813766
Cuba 0.00947004188672373
Madagascar 0.009459366509612408
Kazakhstan 0.009334370485609512
Swaziland 0.009300162752848175
Syria 0.008440886565376027
Belgium 0.008256820133430213
Australia 0.007669578121135597
Dominican Republic 0.007243377483443708
Belize 0.00701569762343243
United Kingdom 0.006944157400901087
Haiti 0.006894049346879536
Uruguay 0.006856555152415508
Mongolia 0.006797308883619258
Portugal 0.006778178637804745
Philippines 0.006137438374081899
Jordan 0.006080944122880115
Slovenia 0.006054290109671977
Egypt 0.006027424782761565
Cameroon 0.005775211017325633
France 0.005268360016051791
Mauritius 0.0049261083743842365
Thailand 0.004364931785707295
Peru 0.004078137744180451
South Africa 0.0038041285499024265
Malaysia 0.0036207961491768015
Samoa 0.003544842254519674
Iraq 0.0021720888864500522
Honduras 0.00178746983644651
Sierra Leone 0.0016755096341803965
Congo, Republic of the 0.0014641288433382138
Burkina Faso 0.0014609203798392988
Namibia 0.001217068104799038
Cyprus 0.0010821339681852614
Korea, North 0.0010796624808982792
Djibouti 0.0008628127696289905
Costa Rica 0.0007833920877399138
Guinea 0.0005697611479873187
Morocco 0.000560161326462021
Niger 0.00023683587274019106
Bosnia and Herzegovina 0.0001953621036591322
Afghanistan 0.0
Algeria 0.0
Andorra 0.0
Angola 0.0
Antigua and Barbuda 0.0
Bahrain 0.0
Barbados 0.0
Bhutan 0.0
Cabo Verde 0.0
Central African Republic 0.0
Comoros 0.0
Dominica 0.0
Equatorial Guinea 0.0
Fiji 0.0
Georgia 0.0
Grenada 0.0
Kiribati 0.0
Kosovo 0.0
Kuwait 0.0
Lesotho 0.0
Libya 0.0
Liechtenstein 0.0
Luxembourg 0.0
Maldives 0.0
Malta 0.0
Marshall Islands 0.0
Mauritania 0.0
Micronesia, Federated States of 0.0
Monaco 0.0
Nauru 0.0
Oman 0.0
Palau 0.0
Qatar 0.0
Saint Kitts and Nevis 0.0
Saint Vincent and the Grenadines 0.0
San Marino 0.0
Sao Tome and Principe 0.0
Saudi Arabia 0.0
Serbia 0.0
Seychelles 0.0
Timor-Leste 0.0
Trinidad and Tobago 0.0
Tuvalu 0.0
United Arab Emirates 0.0
Vanuatu 0.0
Yemen 0.0
Ashmore and Cartier Islands 0.0
Christmas Island 0.0
Cocos (Keeling) Islands 0.0
Coral Sea Islands 0.0
Heard Island and McDonald Islands 0.0
Norfolk Island 0.0
Macau 0.0
Faroe Islands 0.0
Clipperton Island 0.0
Saint Pierre and Miquelon 0.0
Wallis and Futuna 0.0
Aruba 0.0
Curacao 0.0
Sint Maarten 0.0
Cook Islands 0.0
Niue 0.0
Tokelau 0.0
Bouvet Island 0.0
Jan Mayen 0.0
Svalbard 0.0
Anguilla 0.0
Bermuda 0.0
British Virgin Islands 0.0
Cayman Islands 0.0
Falkland Islands (Islas Malvinas) 0.0
Gibraltar 0.0
Guernsey 0.0
Jersey 0.0
Isle of Man 0.0
Montserrat 0.0
Pitcairn Islands 0.0
Saint Helena, Ascension, and Tristan da Cunha 0.0
South Georgia and South Sandwich Islands 0.0
Turks and Caicos Islands 0.0
American Samoa 0.0
Guam 0.0
Navassa Island 0.0
Northern Mariana Islands 0.0
Wake Island 0.0
Gaza Strip 0.0
Paracel Islands 0.0
Spratly Islands 0.0
Western Sahara 0.0
Ethiopia None
New Zealand None
South Sudan None
Sudan None
Holy See (Vatican City) None
European Union None
Greenland None
French Southern and Antarctic Lands None
Saint Barthelemy None
Saint Martin None
Akrotiri None
Dhekelia None
United States Pacific Island Wildlife Refuges None
Antarctica None
Arctic Ocean None
Atlantic Ocean None
Indian Ocean None
Pacific Ocean None
Southern Ocean None
World None
In [34]:
%%sql
SELECT name, area_water, area_land
FROM facts
WHERE area_water > area_land;
Done.
Out[34]:
name area_water area_land
British Indian Ocean Territory 54340 60
Virgin Islands 1564 346
In [45]:
%%sql
SELECT
name, ROUND(population * (population_growth / 100),0) AS 'people_next_year'
FROM facts
WHERE name NOT IN('World')
ORDER BY people_next_year DESC;
Done.
Out[45]:
name people_next_year
India 15270686.0
China 6153684.0
Nigeria 4448270.0
Pakistan 2906653.0
Ethiopia 2874562.0
Bangladesh 2703324.0
United States 2506677.0
Indonesia 2355142.0
Congo, Democratic Republic of the 1944691.0
Philippines 1626074.0
Egypt 1583924.0
Brazil 1572801.0
Mexico 1436494.0
Tanzania 1424180.0
European Union 1284874.0
Uganda 1202097.0
Iraq 1085746.0
Turkey 1000620.0
Iran 981891.0
Vietnam 915184.0
Kenya 886358.0
Afghanistan 755493.0
Algeria 727576.0
South Africa 713885.0
Yemen 660412.0
Sudan 621072.0
Mozambique 619926.0
Cameroon 614846.0
Madagascar 614367.0
Malawi 596428.0
Niger 586486.0
Ghana 573943.0
Burkina Faso 573630.0
Burma 568834.0
Nepal 564768.0
Angola 545585.0
Mali 505275.0
Colombia 486062.0
South Sudan 484125.0
Cote d'Ivoire 444940.0
Malaysia 439399.0
Zambia 433908.0
Spain 428501.0
Venezuela 406929.0
Saudi Arabia 405184.0
Argentina 403917.0
Burundi 352347.0
United Kingdom 346076.0
Senegal 342408.0
Morocco 333227.0
Rwanda 324140.0
Zimbabwe 314473.0
Guinea 309818.0
Peru 295316.0
Benin 290472.0
France 286181.0
Uzbekistan 271559.0
Guatemala 271526.0
Ukraine 266577.0
Canada 263249.0
Cambodia 248198.0
Australia 243436.0
Thailand 231120.0
Chad 219835.0
Ecuador 214223.0
Kazakhstan 206991.0
Togo 203157.0
Japan 203071.0
Somalia 194280.0
Sri Lanka 185249.0
Bolivia 168494.0
Italy 167009.0
United Arab Emirates 149118.0
Honduras 146944.0
Eritrea 146873.0
Chile 143568.0
Libya 142983.0
Tajikistan 140082.0
Sierra Leone 138159.0
Germany 137452.0
Korea, North 132411.0
Dominican Republic 128889.0
Israel 125569.0
Papua New Guinea 118769.0
Haiti 118287.0
Central African Republic 114840.0
Singapore 107248.0
Laos 107129.0
Liberia 103633.0
Tunisia 98231.0
Congo, Republic of the 95102.0
Azerbaijan 93895.0
Belgium 86062.0
Mauritania 80206.0
Paraguay 78686.0
Sweden 78413.0
Netherlands 69486.0
Korea, South 68761.0
Oman 68040.0
Qatar 67381.0
Jordan 67376.0
Romania 64999.0
Kyrgyzstan 62881.0
Ireland 61154.0
Turkmenistan 59638.0
Nicaragua 59079.0
Norway 58847.0
Costa Rica 58733.0
Switzerland 57665.0
Russia 56970.0
West Bank 54315.0
Taiwan 53855.0
Lebanon 53188.0
Gaza Strip 52520.0
Panama 48273.0
Austria 47661.0
Kuwait 45174.0
Gambia, The 42503.0
Bulgaria 41684.0
Mongolia 39207.0
Moldova 36533.0
New Zealand 36395.0
Poland 34706.0
Serbia 33013.0
Guinea-Bissau 32970.0
Gabon 32913.0
Bahrain 32453.0
Lithuania 29998.0
Timor-Leste 29793.0
Syria 27304.0
Hong Kong 27136.0
Botswana 26411.0
Finland 21908.0
Hungary 21775.0
Puerto Rico 21590.0
Latvia 21059.0
Jamaica 20061.0
Belarus 19179.0
Equatorial Guinea 18593.0
Djibouti 18223.0
Czech Republic 17032.0
Cyprus 17006.0
Cuba 16547.0
Western Sahara 16098.0
Swaziland 15935.0
El Salvador 15353.0
Comoros 13823.0
Namibia 13053.0
Solomon Islands 12574.0
Denmark 12279.0
Luxembourg 12146.0
Portugal 9743.0
Albania 9088.0
Uruguay 9023.0
Mauritius 8575.0
Bhutan 8235.0
Cabo Verde 7426.0
Brunei 6960.0
Estonia 6960.0
Belize 6496.0
Suriname 6260.0
Lesotho 6233.0
Fiji 6093.0
Croatia 5804.0
Vanuatu 5309.0
Slovenia 5157.0
Bosnia and Herzegovina 5027.0
Macau 4742.0
Armenia 4585.0
Macedonia 4192.0
Iceland 4016.0
Georgia 3945.0
New Caledonia 3748.0
Sao Tome and Principe 3570.0
Bahamas, The 2759.0
Montenegro 2718.0
French Polynesia 2657.0
Trinidad and Tobago 1589.0
Aruba 1492.0
Malta 1283.0
Kiribati 1216.0
Marshall Islands 1198.0
Cayman Islands 1178.0
Turks and Caicos Islands 1156.0
Samoa 1147.0
Antigua and Barbuda 1146.0
Northern Mariana Islands 1141.0
Slovakia 1089.0
Greece 1078.0
Barbados 901.0
Guam 874.0
Jersey 778.0
British Virgin Islands 776.0
Seychelles 767.0
Isle of Man 665.0
Curacao 638.0
Virgin Islands 611.0
Sint Maarten 599.0
Saint Lucia 557.0
Grenada 531.0
Micronesia, Federated States of 484.0
Saint Kitts and Nevis 395.0
Bermuda 351.0
Anguilla 333.0
Liechtenstein 316.0
Maldives 315.0
Cook Islands 290.0
Saint Vincent and the Grenadines 287.0
San Marino 271.0
Faroe Islands 256.0
Guernsey 225.0
American Samoa 163.0
Dominica 155.0
Guyana 147.0
Andorra 103.0
Tuvalu 89.0
Palau 81.0
Gibraltar 70.0
Saint Pierre and Miquelon 61.0
Nauru 52.0
Wallis and Futuna 52.0
Monaco 37.0
Tonga 32.0
Montserrat 26.0
Saint Helena, Ascension, and Tristan da Cunha 19.0
Christmas Island 17.0
Svalbard 1.0
Holy See (Vatican City) 0.0
Cocos (Keeling) Islands 0.0
Norfolk Island 0.0
Greenland 0.0
Niue 0.0
Tokelau 0.0
Falkland Islands (Islas Malvinas) 0.0
Pitcairn Islands 0.0
Kosovo None
Ashmore and Cartier Islands None
Coral Sea Islands None
Heard Island and McDonald Islands None
Clipperton Island None
French Southern and Antarctic Lands None
Saint Barthelemy None
Saint Martin None
Bouvet Island None
Jan Mayen None
Akrotiri None
British Indian Ocean Territory None
Dhekelia None
South Georgia and South Sandwich Islands None
Navassa Island None
Wake Island None
United States Pacific Island Wildlife Refuges None
Antarctica None
Paracel Islands None
Spratly Islands None
Arctic Ocean None
Atlantic Ocean None
Indian Ocean None
Pacific Ocean None
Southern Ocean None
In [47]:
%%sql
SELECT
name, death_rate, birth_rate
FROM facts
WHERE death_rate > birth_rate;
Done.
Out[47]:
name death_rate birth_rate
Austria 9.42 9.41
Belarus 13.36 10.7
Bosnia and Herzegovina 9.75 8.87
Bulgaria 14.44 8.92
Croatia 12.18 9.45
Czech Republic 10.34 9.63
Estonia 12.4 10.51
Germany 11.42 8.47
Greece 11.09 8.66
Hungary 12.73 9.16
Italy 10.19 8.74
Japan 9.51 7.93
Latvia 14.31 10.0
Lithuania 14.27 10.1
Moldova 12.59 12.0
Monaco 9.24 6.65
Poland 10.19 9.74
Portugal 11.02 9.27
Romania 11.9 9.14
Russia 13.69 11.6
Serbia 13.66 9.08
Slovenia 11.37 8.42
Ukraine 14.46 10.72
Saint Pierre and Miquelon 9.72 7.42
In [51]:
%%sql
SELECT
name,  ROUND(CAST(population AS Float) / CAST(area AS Float),2) AS 'population_area_ratio'
FROM facts
ORDER BY population_area_ratio DESC;
Done.
Out[51]:
name population_area_ratio
Macau 21168.96
Monaco 15267.5
Singapore 8141.28
Hong Kong 6445.04
Gaza Strip 5191.82
Gibraltar 4876.33
Bahrain 1771.86
Maldives 1319.64
Malta 1310.02
Bermuda 1299.93
Sint Maarten 1167.32
Bangladesh 1138.07
Guernsey 847.18
Jersey 838.74
Barbados 675.82
Mauritius 656.78
Taiwan 650.78
Aruba 623.12
Lebanon 594.68
Saint Martin 588.04
San Marino 541.31
Korea, South 492.53
Rwanda 480.74
West Bank 475.32
Nauru 454.29
Tuvalu 418.04
Netherlands 407.96
Marshall Islands 398.85
Israel 387.55
Burundi 386.0
India 380.77
Belgium 370.94
Haiti 364.33
Comoros 349.43
Philippines 336.66
Sri Lanka 336.13
Japan 335.84
Curacao 334.25
Grenada 321.78
Guam 297.4
El Salvador 291.88
Vietnam 284.86
American Samoa 273.08
Jamaica 268.42
Saint Lucia 266.11
Saint Vincent and the Grenadines 263.82
United Kingdom 263.08
Puerto Rico 260.92
Pakistan 250.08
Trinidad and Tobago 238.37
Liechtenstein 235.15
Germany 226.47
British Virgin Islands 221.55
Luxembourg 220.52
Dominican Republic 215.3
Nepal 214.37
Cayman Islands 212.47
Antigua and Barbuda 209.13
Korea, North 207.26
Italy 205.27
Seychelles 203.14
Sao Tome and Principe 201.25
Saint Kitts and Nevis 198.99
Switzerland 196.76
Nigeria 196.55
Qatar 189.44
Andorra 182.86
Anguilla 180.42
Gambia, The 174.13
Kosovo 171.85
Kuwait 156.5
Uganda 153.92
Isle of Man 153.05
Malawi 151.62
Micronesia, Federated States of 149.88
Tonga 142.57
China 142.49
Guatemala 137.01
Cabo Verde 135.38
Czech Republic 134.97
Indonesia 134.41
Togo 133.0
Thailand 132.48
Kiribati 130.35
Denmark 129.52
Cyprus 128.55
Akrotiri 127.64
Poland 123.33
Dhekelia 120.77
European Union 118.84
Portugal 117.55
Azerbaijan 112.94
Northern Mariana Islands 112.81
Tokelau 111.42
Slovakia 111.04
Ghana 110.37
Wallis and Futuna 109.95
Hungary 106.39
Albania 105.37
Moldova 104.78
France 103.38
Austria 103.32
Armenia 102.76
Turkey 101.35
Cuba 99.51
Dominica 98.01
Slovenia 97.84
Spain 95.27
Costa Rica 94.21
Benin 92.78
Serbia 92.63
Malaysia 92.51
Syria 92.15
Romania 90.89
Jordan 90.86
Ethiopia 90.07
Egypt 88.36
Cambodia 86.77
Iraq 84.54
Burma 83.24
Timor-Leste 82.77
Swaziland 82.68
Sierra Leone 81.95
Greece 81.66
Macedonia 81.52
Kenya 79.13
Croatia 78.89
Honduras 78.03
Bosnia and Herzegovina 75.53
Morocco 74.62
Brunei 74.53
Ukraine 73.61
Cote d'Ivoire 72.24
Senegal 71.04
Georgia 70.75
Samoa 69.86
Ireland 69.62
United Arab Emirates 69.14
Burkina Faso 69.04
French Polynesia 67.84
Tunisia 67.46
Uzbekistan 65.27
Bulgaria 64.82
Lesotho 64.16
Mexico 61.97
Norfolk Island 61.39
Tajikistan 56.85
Ecuador 55.96
Eritrea 55.51
Virgin Islands 54.23
Tanzania 53.89
Turks and Caicos Islands 53.04
Montserrat 51.38
Yemen 50.64
Afghanistan 49.93
Cameroon 49.93
Fiji 49.76
Iran 49.64
Panama 48.49
Guinea 47.91
Guinea-Bissau 47.78
Montenegro 46.85
Palau 46.33
Belarus 46.19
Nicaragua 45.32
Lithuania 44.17
South Africa 44.03
Cocos (Keeling) Islands 42.57
Cook Islands 41.69
Colombia 41.04
Madagascar 40.56
Liberia 37.67
Zimbabwe 36.42
Faroe Islands 36.03
Djibouti 35.7
Congo, Democratic Republic of the 33.85
United States 32.7
Venezuela 32.1
Mozambique 31.65
Latvia 30.76
Laos 29.19
Kyrgyzstan 28.33
Estonia 27.98
Equatorial Guinea 26.41
Saint Helena, Ascension, and Tristan da Cunha 25.31
Brazil 23.99
Peru 23.69
Bahamas, The 23.39
Saint Pierre and Miquelon 23.38
Chile 23.16
Vanuatu 22.34
Sweden 21.77
Solomon Islands 21.54
Zambia 20.02
Sudan 19.4
Bhutan 19.32
Uruguay 18.96
South Sudan 18.69
Paraguay 16.68
Somalia 16.65
Algeria 16.6
New Zealand 16.58
Finland 16.2
Norway 16.08
Angola 15.74
Argentina 15.62
Belize 15.13
New Caledonia 14.62
Papua New Guinea 14.42
Congo, Republic of the 13.9
Mali 13.67
Saudi Arabia 12.91
Christmas Island 11.33
Turkmenistan 10.72
Oman 10.62
Bolivia 9.83
Central African Republic 8.65
Russia 8.33
Kazakhstan 6.66
Gabon 6.37
Niue 4.58
Botswana 3.75
Libya 3.64
Suriname 3.54
Canada 3.52
Mauritania 3.49
Guyana 3.42
Iceland 3.22
Australia 2.94
Namibia 2.68
Western Sahara 2.15
Mongolia 1.91
Pitcairn Islands 1.02
Falkland Islands (Islas Malvinas) 0.28
Greenland 0.03
Svalbard 0.03
Chad None
Niger None
Holy See (Vatican City) None
Ashmore and Cartier Islands None
Coral Sea Islands None
Heard Island and McDonald Islands None
Clipperton Island None
French Southern and Antarctic Lands None
Saint Barthelemy None
Bouvet Island None
Jan Mayen None
British Indian Ocean Territory None
South Georgia and South Sandwich Islands None
Navassa Island None
Wake Island None
United States Pacific Island Wildlife Refuges None
Antarctica None
Paracel Islands None
Spratly Islands None
Arctic Ocean None
Atlantic Ocean None
Indian Ocean None
Pacific Ocean None
Southern Ocean None
World None
In [ ]: