%%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 MAX(population) AS Maximum_population,
MIN(population) AS Minimum_Population,
MIN(population_growth) AS MIN_population_growth,
MAX(population_growth) AS Maximum_population_growth
FROM facts;
Done.
Maximum_population | Minimum_Population | MIN_population_growth | Maximum_population_growth |
---|---|---|---|
7256490011 | 0 | 0.0 | 4.02 |
%%sql
SELECT name
FROM facts
WHERE population = (SELECT MIN(population) FROM facts)
Done.
name |
---|
Antarctica |
%%sql
SELECT name
FROM facts
WHERE population = (SELECT MAX(population) FROM facts)
Done.
name |
---|
World |
%%sql
SELECT MAX(population) AS Maximum_population,
MIN(population) AS Minimum_Population,
MIN(population_growth) AS MIN_population_growth,
MAX(population_growth) AS Maximum_population_growth
FROM facts
WHERE name != 'World';
Done.
Maximum_population | Minimum_Population | MIN_population_growth | Maximum_population_growth |
---|---|---|---|
1367485388 | 0 | 0.0 | 4.02 |
%%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
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
80 | iz | Iraq | 438317 | 437367 | 950 | 37056169 | 2.93 | 31.45 | 3.77 | 1.62 |
83 | it | Italy | 301340 | 294140 | 7200 | 61855120 | 0.27 | 8.74 | 10.19 | 4.1 |
85 | ja | Japan | 377915 | 364485 | 13430 | 126919659 | 0.16 | 7.93 | 9.51 | 0.0 |
91 | ks | Korea, South | 99720 | 96920 | 2800 | 49115196 | 0.14 | 8.19 | 6.75 | 0.0 |
120 | mo | Morocco | 446550 | 446300 | 250 | 33322699 | 1.0 | 18.2 | 4.81 | 3.36 |
138 | rp | Philippines | 300000 | 298170 | 1830 | 100998376 | 1.61 | 24.27 | 6.11 | 2.09 |
139 | pl | Poland | 312685 | 304255 | 8430 | 38562189 | 0.09 | 9.74 | 10.19 | 0.46 |
163 | sp | Spain | 505370 | 498980 | 6390 | 48146134 | 0.89 | 9.64 | 9.04 | 8.31 |
173 | th | Thailand | 513120 | 510890 | 2230 | 67976405 | 0.34 | 11.19 | 7.8 | 0.0 |
182 | ug | Uganda | 241038 | 197100 | 43938 | 37101745 | 3.24 | 43.79 | 10.69 | 0.74 |
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 |
%%sql
SELECT *
FROM facts
WHERE population = (SELECT MAX(population)
FROM facts
WHERE name != 'World')
;
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 |
%%sql
SELECT *
FROM facts
WHERE population_growth = (SELECT MAX(population_growth)
FROM facts
WHERE name != 'World')
;
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 |
%%sql
SELECT name,area_land,area_water, CAST(area_water AS FLOAT) / area_land AS water_to_land_ratio
FROM facts
WHERE name != 'World'
ORDER BY water_to_land_ratio DESC
LIMIT 150
;
Done.
name | area_land | area_water | water_to_land_ratio |
---|---|---|---|
British Indian Ocean Territory | 60 | 54340 | 905.6666666666666 |
Virgin Islands | 346 | 1564 | 4.520231213872832 |
Puerto Rico | 8870 | 4921 | 0.5547914317925592 |
Bahamas, The | 10010 | 3870 | 0.3866133866133866 |
Guinea-Bissau | 28120 | 8005 | 0.2846728307254623 |
Malawi | 94080 | 24404 | 0.25939625850340137 |
Netherlands | 33893 | 7650 | 0.22571032366565366 |
Uganda | 197100 | 43938 | 0.22292237442922375 |
Eritrea | 101000 | 16600 | 0.16435643564356436 |
Liberia | 96320 | 15049 | 0.15623961794019933 |
Bangladesh | 130170 | 18290 | 0.1405085657217485 |
Gambia, The | 10120 | 1180 | 0.116600790513834 |
Taiwan | 32260 | 3720 | 0.1153130812151271 |
Finland | 303815 | 34330 | 0.11299639583299047 |
India | 2973193 | 314070 | 0.10563390940312317 |
Canada | 9093507 | 891163 | 0.09799992456155804 |
Sweden | 410335 | 39960 | 0.09738384490720996 |
Colombia | 1038700 | 100210 | 0.09647636468662751 |
Brunei | 5265 | 500 | 0.0949667616334283 |
Guyana | 196849 | 18120 | 0.09205025171578214 |
French Polynesia | 3827 | 340 | 0.08884243532793311 |
Nicaragua | 119990 | 10380 | 0.08650720893407784 |
Burundi | 25680 | 2150 | 0.0837227414330218 |
Iran | 1531595 | 116600 | 0.07612978626856316 |
United States | 9161966 | 664709 | 0.07255091319919764 |
Tanzania | 885800 | 61500 | 0.06942876495822985 |
Vietnam | 310070 | 21140 | 0.06817815332021801 |
Rwanda | 24668 | 1670 | 0.06769904329495703 |
Estonia | 42388 | 2840 | 0.06700009436633009 |
Norway | 304282 | 19520 | 0.06415101780585115 |
Armenia | 28203 | 1540 | 0.054604120129064286 |
Tunisia | 155360 | 8250 | 0.05310247167868177 |
Uzbekistan | 425400 | 22000 | 0.051716031969910675 |
Indonesia | 1811569 | 93000 | 0.0513367141963679 |
Suriname | 156000 | 7820 | 0.05012820512820513 |
Albania | 27398 | 1350 | 0.04927366961092051 |
Ghana | 227533 | 11000 | 0.048344635723169826 |
Azerbaijan | 82629 | 3971 | 0.048058187803313605 |
Togo | 54385 | 2400 | 0.044129815206398824 |
Russia | 16377742 | 720500 | 0.04399263341674328 |
Kyrgyzstan | 191801 | 8150 | 0.04249195781043894 |
Tonga | 717 | 30 | 0.04184100418410042 |
Ukraine | 579330 | 24220 | 0.04180691488443547 |
Lithuania | 62680 | 2620 | 0.041799617102744095 |
West Bank | 5640 | 220 | 0.03900709219858156 |
Gabon | 257667 | 10000 | 0.03880978161735884 |
Turkmenistan | 469930 | 18170 | 0.038665333134722195 |
Hungary | 89608 | 3420 | 0.038166235157575217 |
Latvia | 62249 | 2340 | 0.03759096531671192 |
Romania | 229891 | 8500 | 0.03697404422095689 |
Japan | 364485 | 13430 | 0.036846509458551106 |
Burma | 653508 | 23070 | 0.03530178666519767 |
Congo, Democratic Republic of the | 2267048 | 77810 | 0.03432216697661452 |
Venezuela | 882050 | 30000 | 0.034011677342554274 |
Pakistan | 770875 | 25220 | 0.03271606940165397 |
Hong Kong | 1073 | 35 | 0.032618825722273995 |
Solomon Islands | 27986 | 910 | 0.03251625812906453 |
Switzerland | 39997 | 1280 | 0.032002400180013504 |
Moldova | 32891 | 960 | 0.029187315679061143 |
China | 9326410 | 270550 | 0.029009018475490568 |
Korea, South | 96920 | 2800 | 0.028889806025588115 |
Poland | 304255 | 8430 | 0.027707022070302872 |
Iceland | 100250 | 2750 | 0.02743142144638404 |
Montenegro | 13452 | 360 | 0.026761819803746655 |
Nepal | 143351 | 3830 | 0.02671763712844696 |
Botswana | 566730 | 15000 | 0.026467630088401885 |
Laos | 230800 | 6000 | 0.025996533795493933 |
Cambodia | 176515 | 4520 | 0.025606888932951873 |
Italy | 294140 | 7200 | 0.024478139661385734 |
Ecuador | 276841 | 6720 | 0.02427386116940771 |
Germany | 348672 | 8350 | 0.023948008443465493 |
Paraguay | 397302 | 9450 | 0.023785432743857318 |
Belarus | 202900 | 4700 | 0.023164120256283883 |
Papua New Guinea | 452860 | 9980 | 0.022037715850373184 |
Bulgaria | 108489 | 2390 | 0.022029883213966393 |
Senegal | 192530 | 4192 | 0.02177323014595128 |
Israel | 20330 | 440 | 0.02164289227742253 |
Czech Republic | 77247 | 1620 | 0.02097168822090178 |
Ireland | 68883 | 1390 | 0.02017914434621024 |
Kenya | 569140 | 11227 | 0.019726253645851635 |
Chad | 1259200 | 24800 | 0.019695044472681066 |
Slovakia | 48105 | 930 | 0.01933270969753664 |
Brazil | 8358140 | 157630 | 0.018859459161966657 |
Tajikistan | 141510 | 2590 | 0.018302593456292843 |
Turkey | 769632 | 13930 | 0.018099559269884827 |
Benin | 110622 | 2000 | 0.018079586339064563 |
Austria | 82445 | 1426 | 0.017296379404451452 |
Lebanon | 10230 | 170 | 0.016617790811339198 |
Mozambique | 786380 | 13000 | 0.016531447900506115 |
Chile | 743812 | 12290 | 0.01652299236903949 |
Saint Lucia | 606 | 10 | 0.0165016501650165 |
Somalia | 627337 | 10320 | 0.016450488334021428 |
New Caledonia | 18275 | 300 | 0.016415868673050615 |
Mali | 1220190 | 20002 | 0.016392529032363812 |
Guatemala | 107159 | 1730 | 0.016144234268703515 |
Argentina | 2736690 | 43710 | 0.015971849204696183 |
Denmark | 42434 | 660 | 0.015553565537069332 |
El Salvador | 20721 | 320 | 0.015443270112446311 |
Sri Lanka | 64630 | 980 | 0.01516323688689463 |
Jamaica | 10831 | 160 | 0.01477241251961961 |
Singapore | 687 | 10 | 0.01455604075691412 |
Panama | 74340 | 1080 | 0.014527845036319613 |
Nigeria | 910768 | 13000 | 0.014273667937389104 |
Bolivia | 1083301 | 15280 | 0.014105036365700761 |
Cote d'Ivoire | 318003 | 4460 | 0.014025024921148543 |
Spain | 498980 | 6390 | 0.012806124493967693 |
Zambia | 743398 | 9220 | 0.012402508481324943 |
Croatia | 55974 | 620 | 0.011076571265230286 |
Macedonia | 25433 | 280 | 0.011009318601816538 |
Mexico | 1943945 | 20430 | 0.010509556597537481 |
Zimbabwe | 386847 | 3910 | 0.010107355104214328 |
Greece | 130647 | 1310 | 0.010027019372813766 |
Cuba | 109820 | 1040 | 0.00947004188672373 |
Madagascar | 581540 | 5501 | 0.009459366509612408 |
Kazakhstan | 2699700 | 25200 | 0.009334370485609512 |
Swaziland | 17204 | 160 | 0.009300162752848175 |
Syria | 183630 | 1550 | 0.008440886565376027 |
Belgium | 30278 | 250 | 0.008256820133430213 |
Australia | 7682300 | 58920 | 0.007669578121135597 |
Dominican Republic | 48320 | 350 | 0.007243377483443708 |
Belize | 22806 | 160 | 0.00701569762343243 |
United Kingdom | 241930 | 1680 | 0.006944157400901087 |
Haiti | 27560 | 190 | 0.006894049346879536 |
Uruguay | 175015 | 1200 | 0.006856555152415508 |
Mongolia | 1553556 | 10560 | 0.006797308883619258 |
Portugal | 91470 | 620 | 0.006778178637804745 |
Philippines | 298170 | 1830 | 0.006137438374081899 |
Jordan | 88802 | 540 | 0.006080944122880115 |
Slovenia | 20151 | 122 | 0.006054290109671977 |
Egypt | 995450 | 6000 | 0.006027424782761565 |
Cameroon | 472710 | 2730 | 0.005775211017325633 |
France | 640427 | 3374 | 0.005268360016051791 |
Mauritius | 2030 | 10 | 0.0049261083743842365 |
Thailand | 510890 | 2230 | 0.004364931785707295 |
Peru | 1279996 | 5220 | 0.004078137744180451 |
South Africa | 1214470 | 4620 | 0.0038041285499024265 |
Malaysia | 328657 | 1190 | 0.0036207961491768015 |
Samoa | 2821 | 10 | 0.003544842254519674 |
Iraq | 437367 | 950 | 0.0021720888864500522 |
Honduras | 111890 | 200 | 0.00178746983644651 |
Sierra Leone | 71620 | 120 | 0.0016755096341803965 |
Congo, Republic of the | 341500 | 500 | 0.0014641288433382138 |
Burkina Faso | 273800 | 400 | 0.0014609203798392988 |
Namibia | 823290 | 1002 | 0.001217068104799038 |
Cyprus | 9241 | 10 | 0.0010821339681852614 |
Korea, North | 120408 | 130 | 0.0010796624808982792 |
Djibouti | 23180 | 20 | 0.0008628127696289905 |
Costa Rica | 51060 | 40 | 0.0007833920877399138 |
Guinea | 245717 | 140 | 0.0005697611479873187 |
Morocco | 446300 | 250 | 0.000560161326462021 |
%%sql
SELECT name,area_land,area_water
FROM facts
WHERE name != 'World' AND area_water > area_land
ORDER BY area_water DESC
;
Done.
name | area_land | area_water |
---|---|---|
British Indian Ocean Territory | 60 | 54340 |
Virgin Islands | 346 | 1564 |
%%sql
SELECT name, MAX(population*population_growth)
FROM facts
WHERE name != 'World'
;
Done.
name | MAX(population*population_growth) |
---|---|
India | 1527068612.48 |
%%sql
SELECT name, birth_rate, death_rate
FROM facts
WHERE death_rate>birth_rate;
Done.
name | birth_rate | death_rate |
---|---|---|
Austria | 9.41 | 9.42 |
Belarus | 10.7 | 13.36 |
Bosnia and Herzegovina | 8.87 | 9.75 |
Bulgaria | 8.92 | 14.44 |
Croatia | 9.45 | 12.18 |
Czech Republic | 9.63 | 10.34 |
Estonia | 10.51 | 12.4 |
Germany | 8.47 | 11.42 |
Greece | 8.66 | 11.09 |
Hungary | 9.16 | 12.73 |
Italy | 8.74 | 10.19 |
Japan | 7.93 | 9.51 |
Latvia | 10.0 | 14.31 |
Lithuania | 10.1 | 14.27 |
Moldova | 12.0 | 12.59 |
Monaco | 6.65 | 9.24 |
Poland | 9.74 | 10.19 |
Portugal | 9.27 | 11.02 |
Romania | 9.14 | 11.9 |
Russia | 11.6 | 13.69 |
Serbia | 9.08 | 13.66 |
Slovenia | 8.42 | 11.37 |
Ukraine | 10.72 | 14.46 |
Saint Pierre and Miquelon | 7.42 | 9.72 |
%%sql
SELECT name, CAST(population as FLOAT) / area AS 'p/a_ratio'
FROM facts
WHERE name != 'World';
Done.
name | p/a_ratio |
---|---|
Afghanistan | 49.92769728470018 |
Albania | 105.37352163628775 |
Algeria | 16.602210735760103 |
Andorra | 182.86324786324786 |
Angola | 15.741840859870058 |
Antigua and Barbuda | 209.13122171945702 |
Argentina | 15.620732988059272 |
Armenia | 102.75970816662745 |
Australia | 2.9389442490976876 |
Austria | 103.31997949231558 |
Azerbaijan | 112.94203233256351 |
Bahamas, The | 23.385951008645534 |
Bahrain | 1771.8592105263158 |
Bangladesh | 1138.0691432035565 |
Barbados | 675.8232558139534 |
Belarus | 46.193106936416186 |
Belgium | 370.9372707023061 |
Belize | 15.125359226682923 |
Benin | 92.77625153167232 |
Bhutan | 19.3238266395791 |
Bolivia | 9.831666486130745 |
Bosnia and Herzegovina | 75.53284372131179 |
Botswana | 3.752116961476974 |
Brazil | 23.98606491250938 |
Brunei | 74.5266261925412 |
Bulgaria | 64.81744063348334 |
Burkina Faso | 69.04334792122539 |
Burma | 83.24273919636761 |
Burundi | 385.99626302551206 |
Cambodia | 86.77192808020548 |
Cameroon | 49.93104913343429 |
Canada | 3.515372666297434 |
Cabo Verde | 135.3813538308951 |
Central African Republic | 8.654377961552784 |
Chad | None |
Chile | 23.15594985861696 |
China | 142.4915168970174 |
Colombia | 41.036366350282286 |
Comoros | 349.42774049217 |
Congo, Democratic Republic of the | 33.85072187740153 |
Congo, Republic of the | 13.903792397660819 |
Costa Rica | 94.21025440313112 |
Cote d'Ivoire | 72.2417827781792 |
Croatia | 78.89253277732622 |
Cuba | 99.50778459318059 |
Cyprus | 128.54794076316074 |
Czech Republic | 134.97206689743493 |
Denmark | 129.51926022184063 |
Djibouti | 35.703620689655175 |
Dominica | 98.01198402130493 |
Dominican Republic | 215.3021573864804 |
Ecuador | 55.96113710982822 |
Egypt | 88.3592750511758 |
El Salvador | 291.8753861508483 |
Equatorial Guinea | 26.40700866279277 |
Eritrea | 55.507559523809526 |
Estonia | 27.978685769877067 |
Ethiopia | 90.0713746264602 |
Fiji | 49.764091058334245 |
Finland | 16.196962841384615 |
France | 103.37630106197412 |
Gabon | 6.371110372216224 |
Gambia, The | 174.13353982300885 |
Georgia | 70.74929698708752 |
Germany | 226.4689795026637 |
Ghana | 110.37319364616216 |
Greece | 81.66026053941815 |
Grenada | 321.7848837209302 |
Guatemala | 137.01107549890256 |
Guinea | 47.91469024676946 |
Guinea-Bissau | 47.78325259515571 |
Guyana | 3.4201303443752353 |
Haiti | 364.325009009009 |
Honduras | 78.03258988312963 |
Hungary | 106.3931396998753 |
Iceland | 3.222504854368932 |
India | 380.7713541630226 |
Indonesia | 134.41029125224657 |
Iran | 49.64477504178814 |
Iraq | 84.5419388250969 |
Ireland | 69.61855904828312 |
Israel | 387.5452094366875 |
Italy | 205.26687462666754 |
Jamaica | 268.4205258848148 |
Japan | 335.8418136353413 |
Jordan | 90.85943900964831 |
Kazakhstan | 6.6634085654519435 |
Kenya | 79.1314823206695 |
Kiribati | 130.34648581997533 |
Korea, North | 207.26414076888616 |
Korea, South | 492.53104693140796 |
Kosovo | 171.8545972260494 |
Kuwait | 156.50095409136827 |
Kyrgyzstan | 28.331636250881466 |
Laos | 29.187263513513514 |
Latvia | 30.759185000541887 |
Lebanon | 594.6827884615385 |
Lesotho | 64.16409158293527 |
Liberia | 37.6735536819043 |
Libya | 3.644006956363595 |
Liechtenstein | 235.15 |
Lithuania | 44.172021439509955 |
Luxembourg | 220.51508120649652 |
Macedonia | 81.51577023295609 |
Madagascar | 40.56391461584455 |
Malawi | 151.62129063839842 |
Malaysia | 92.50909664177634 |
Maldives | 1319.6409395973155 |
Mali | 13.671702446072866 |
Malta | 1310.01582278481 |
Marshall Islands | 398.8453038674033 |
Mauritania | 3.4895721354419327 |
Mauritius | 656.7779411764706 |
Mexico | 61.972285841552655 |
Micronesia, Federated States of | 149.8803418803419 |
Moldova | 104.77820448435793 |
Monaco | 15267.5 |
Mongolia | 1.9134821202519505 |
Montenegro | 46.84860990443093 |
Morocco | 74.6225484268279 |
Mozambique | 31.65342265255573 |
Namibia | 2.6838875058838374 |
Nauru | 454.2857142857143 |
Nepal | 214.3707747603291 |
Netherlands | 407.96052283176465 |
New Zealand | 16.57910798998917 |
Nicaragua | 45.31626140983355 |
Niger | None |
Nigeria | 196.5450805830035 |
Norway | 16.082942662491277 |
Oman | 10.620148626817448 |
Pakistan | 250.07800199724906 |
Palau | 46.328976034858385 |
Panama | 48.48878281622912 |
Papua New Guinea | 14.416275602800104 |
Paraguay | 16.67667768074896 |
Peru | 23.688624324627146 |
Philippines | 336.6612533333333 |
Poland | 123.3259958104802 |
Portugal | 117.5514062330329 |
Qatar | 189.43699292249266 |
Romania | 90.88577169440121 |
Russia | 8.329731968935754 |
Rwanda | 480.74010934771053 |
Saint Kitts and Nevis | 198.98850574712642 |
Saint Lucia | 266.10714285714283 |
Saint Vincent and the Grenadines | 263.82262210796915 |
Samoa | 69.8597668668315 |
San Marino | 541.311475409836 |
Sao Tome and Principe | 201.25103734439833 |
Saudi Arabia | 12.909915383148268 |
Senegal | 71.0435741808237 |
Serbia | 92.63487105351473 |
Seychelles | 203.14285714285714 |
Sierra Leone | 81.9500696961249 |
Singapore | 8141.279770444763 |
Slovakia | 111.04368308351178 |
Slovenia | 97.8351501997731 |
Solomon Islands | 21.54170127353267 |
Somalia | 16.649044862676956 |
South Africa | 44.02920457062235 |
South Sudan | 18.690622337346294 |
Spain | 95.26907810119319 |
Sri Lanka | 336.12998018594726 |
Sudan | 19.397885235650698 |
Suriname | 3.5382309852276888 |
Swaziland | 82.67755125547109 |
Sweden | 21.7670993459843 |
Switzerland | 196.76405746541658 |
Syria | 92.1527918781726 |
Tajikistan | 56.84911866759195 |
Tanzania | 53.88565607516098 |
Thailand | 132.47662340193327 |
Timor-Leste | 82.76966518757564 |
Togo | 132.99846790525666 |
Tonga | 142.57161981258366 |
Trinidad and Tobago | 238.3703198127925 |
Tunisia | 67.46057698184707 |
Turkey | 101.35033220089795 |
Turkmenistan | 10.717930751895103 |
Tuvalu | 418.03846153846155 |
Uganda | 153.92487906471177 |
Ukraine | 73.61357136939773 |
United Arab Emirates | 69.13588516746411 |
United Kingdom | 263.0771396904889 |
United States | 32.70372369087204 |
Uruguay | 18.96486110717022 |
Uzbekistan | 65.26585158694681 |
Vanuatu | 22.336861104274345 |
Holy See (Vatican City) | None |
Venezuela | 32.09852530014802 |
Vietnam | 284.8610700160019 |
Yemen | 50.64192716225226 |
Zambia | 20.01847683685482 |
Zimbabwe | 36.41531949523617 |
Taiwan | 650.7817120622568 |
European Union | 118.83823161491145 |
Ashmore and Cartier Islands | None |
Christmas Island | 11.333333333333334 |
Cocos (Keeling) Islands | 42.57142857142857 |
Coral Sea Islands | None |
Heard Island and McDonald Islands | None |
Norfolk Island | 61.388888888888886 |
Hong Kong | 6445.041516245487 |
Macau | 21168.964285714286 |
Faroe Islands | 36.034458004307254 |
Greenland | 0.026653143042335344 |
Clipperton Island | None |
French Polynesia | 67.84329253659708 |
French Southern and Antarctic Lands | None |
New Caledonia | 14.622611036339165 |
Saint Barthelemy | None |
Saint Martin | 588.0370370370371 |
Saint Pierre and Miquelon | 23.376033057851238 |
Wallis and Futuna | 109.95070422535211 |
Aruba | 623.1222222222223 |
Curacao | 334.2477477477477 |
Sint Maarten | 1167.3235294117646 |
Cook Islands | 41.686440677966104 |
Niue | 4.576923076923077 |
Tokelau | 111.41666666666667 |
Bouvet Island | None |
Jan Mayen | None |
Svalbard | 0.030171649609154645 |
Akrotiri | 127.64227642276423 |
Anguilla | 180.41758241758242 |
Bermuda | 1299.9259259259259 |
British Indian Ocean Territory | None |
British Virgin Islands | 221.5496688741722 |
Cayman Islands | 212.46969696969697 |
Dhekelia | 120.76923076923077 |
Falkland Islands (Islas Malvinas) | 0.2761028505709357 |
Gibraltar | 4876.333333333333 |
Guernsey | 847.1794871794872 |
Jersey | 838.7413793103449 |
Isle of Man | 153.0506993006993 |
Montserrat | 51.38235294117647 |
Pitcairn Islands | 1.0212765957446808 |
Saint Helena, Ascension, and Tristan da Cunha | 25.308441558441558 |
South Georgia and South Sandwich Islands | None |
Turks and Caicos Islands | 53.037974683544306 |
American Samoa | 273.08040201005025 |
Guam | 297.39889705882354 |
Navassa Island | None |
Northern Mariana Islands | 112.8103448275862 |
Puerto Rico | 260.92067290261764 |
Virgin Islands | 54.227225130890055 |
Wake Island | None |
United States Pacific Island Wildlife Refuges | None |
Antarctica | None |
Gaza Strip | 5191.819444444444 |
Paracel Islands | None |
Spratly Islands | None |
West Bank | 475.3184300341297 |
Western Sahara | 2.146112781954887 |
Arctic Ocean | None |
Atlantic Ocean | None |
Indian Ocean | None |
Pacific Ocean | None |
Southern Ocean | None |