library(readxl)
library(tidyr)
library(dplyr)
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
library(rio)
The dataset presents estimates of international migrant by age, sex and origin. Estimates are presented for 1990, 1995, 2000, 2005, 2010, 2015 and 2019 and are available for all countries and areas of the world. The estimates are based on official statistics on the foreign-born or the foreign population.
For our analysis purpose I am only going to grab 2019 data.
convert("UN_MigrantStockByOriginAndDestination_2019.xlsx", "UN_migration_data.csv")
## New names:
## * `` -> ...1
## * `` -> ...2
## * `` -> ...3
## * `` -> ...4
## * `` -> ...6
## * ... and 235 more problems
UN_migration_data <- read.csv("UN_migration_data.csv")
View(UN_migration_data)
Test <- UN_migration_data[-c(1:10, 12:1709),]
head(Test)
## ...1 ...2 ...3 ...4 United.Nations ...6
## 11
## 1710 2019 2019001 WORLD 900
## 1711 2019 2019002 UN development groups
## 1712 2019 2019003 More developed regions b 901
## 1713 2019 2019004 Less developed regions c 902
## 1714 2019 2019005 Least developed countries d 941
## ...7 ...8 ...9 ...10 ...11 ...12
## 11 Total Other South Other North Afghanistan Albania Algeria
## 1710 271642105 7950425 3407920 5120756 1207032 1944784
## 1711 .. .. .. .. .. ..
## 1712 152069261 3114911 991191 686514 1199619 1851127
## 1713 119572844 4835514 2416729 4434242 7413 93657
## 1714 16289023 1042811 484256 536 1439 13793
## ...13 ...14 ...15 ...16 ...17 ...18
## 11 American Samoa Andorra Angola Anguilla Antigua and Barbuda Argentina
## 1710 1817 9114 661590 2707 55089 1013414
## 1711 .. .. .. .. .. ..
## 1712 43 7849 244608 1061 42352 664757
## 1713 1774 1265 416982 1646 12737 348657
## 1714 446 1166 250846 0 4249 628
## ...19 ...20 ...21 ...22 ...23 ...24 ...25 ...26
## 11 Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh
## 1710 964848 19640 577255 575950 1155852 46467 60153 7835152
## 1711 .. .. .. .. .. .. .. ..
## 1712 778187 13889 472987 529343 940311 44731 12869 804412
## 1713 186661 5751 104268 46607 215541 1736 47284 7030740
## 1714 8 0 2238 187 4 12 30558 1533
## ...27 ...28 ...29 ...30 ...31 ...32 ...33
## 11 Barbados Belarus Belgium Belize Benin Bermuda Bhutan
## 1710 112925 1480794 581740 68144 666357 18049 49216
## 1711 .. .. .. .. .. .. ..
## 1712 107860 1342671 532916 62700 35183 17782 14735
## 1713 5065 138123 48824 5444 631174 267 34481
## 1714 10 0 873 1 102401 0 27688
## ...34 ...35
## 11 Bolivia (Plurinational State of) Bonaire, Sint Eustatius and Saba
## 1710 878211 12764
## 1711 .. ..
## 1712 291987 9454
## 1713 586224 3310
## 1714 4 0
## ...36 ...37 ...38 ...39
## 11 Bosnia and Herzegovina Botswana Brazil British Virgin Islands
## 1710 1653056 86501 1745339 5417
## 1711 .. .. .. ..
## 1712 1648777 7277 1383903 601
## 1713 4279 79224 361436 4816
## 1714 1 1327 16029 565
## ...40 ...41 ...42 ...43 ...44 ...45
## 11 Brunei Darussalam Bulgaria Burkina Faso Burundi Cabo Verde Cambodia
## 1710 46977 1541860 1581083 623999 186372 1097884
## 1711 .. .. .. .. .. ..
## 1712 14638 856935 31729 36784 165842 353130
## 1713 32339 684925 1549354 587215 20530 744754
## 1714 0 2 108246 566940 18249 23542
## ...46 ...47 ...48 ...49 ...50
## 11 Cameroon Canada Cayman Islands Central African Republic Chad
## 1710 383029 1323087 1973 767884 206400
## 1711 .. .. .. .. ..
## 1712 247217 1182163 1837 21835 13221
## 1713 135812 140924 136 746049 193179
## 1714 39018 1896 0 447302 113933
## ...51 ...52 ...53 ...54 ...55
## 11 Channel Islands Chile China China, Hong Kong SAR China, Macao SAR
## 1710 22545 650151 10732281 1110358 161930
## 1711 .. .. .. .. ..
## 1712 22417 345515 6315211 741825 24974
## 1713 128 304636 4417070 368533 136956
## 1714 0 2062 247825 123 0
## ...56 ...57 ...58 ...59 ...60 ...61
## 11 Colombia Comoros Congo Cook Islands Costa Rica Côte d'Ivoire
## 1710 2869032 120297 239397 22488 150400 1114003
## 1711 .. .. .. .. .. ..
## 1712 1453269 40870 113088 22429 116319 201763
## 1713 1415763 79427 126309 59 34081 912240
## 1714 3314 13385 68203 0 378 831478
## ...62 ...63 ...64 ...65 ...66
## 11 Croatia Cuba Curaçao Cyprus Czechia
## 1710 990012 1654684 123132 214648 911388
## 1711 .. .. .. .. ..
## 1712 982470 1577214 112716 191347 900934
## 1713 7542 77470 10416 23301 10454
## 1714 1120 2926 0 7 0
## ...67 ...68
## 11 Dem. People's Republic of Korea Democratic Republic of the Congo
## 1710 113118 1684615
## 1711 .. ..
## 1712 31597 299778
## 1713 81521 1384837
## 1714 3349 1112671
## ...69 ...70 ...71 ...72 ...73 ...74
## 11 Denmark Djibouti Dominica Dominican Republic Ecuador Egypt
## 1710 255616 18668 78634 1558668 1183685 3547626
## 1711 .. .. .. .. .. ..
## 1712 238184 12775 56471 1446445 1079500 640473
## 1713 17432 5893 22163 112223 104185 2907153
## 1714 258 4013 12 2363 1 30841
## ...75 ...76 ...77 ...78 ...79 ...80
## 11 El Salvador Equatorial Guinea Eritrea Estonia Eswatini Ethiopia
## 1710 1600739 125670 751481 208257 108188 871747
## 1711 .. .. .. .. .. ..
## 1712 1526023 22883 270147 204905 14525 441756
## 1713 74716 102787 481334 3352 93663 429991
## 1714 3 11355 439234 0 119 127009
## ...81 ...82 ...83 ...84 ...85
## 11 Falkland Islands (Malvinas) Faroe Islands Fiji Finland France
## 1710 1623 13838 222633 290006 2296534
## 1711 .. .. .. .. ..
## 1712 1564 13830 220033 282344 1681852
## 1713 59 8 2600 7662 614682
## 1714 0 0 899 5 47437
## ...86 ...87 ...88 ...89 ...90 ...91 ...92
## 11 French Guiana French Polynesia Gabon Gambia Georgia Germany Ghana
## 1710 4555 1982 46684 118483 852816 4014203 970625
## 1711 .. .. .. .. .. .. ..
## 1712 317 907 26435 97841 710853 3365059 491123
## 1713 4238 1075 20249 20642 141963 649144 479502
## 1714 0 385 15025 11238 0 3678 115784
## ...93 ...94 ...95 ...96 ...97 ...98 ...99 ...100
## 11 Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guinea
## 1710 14320 1039257 18684 75784 11856 2197 1205644 530963
## 1711 .. .. .. .. .. .. .. ..
## 1712 14181 903776 18207 63884 566 127 1111234 116980
## 1713 139 135481 477 11900 11290 2070 94410 413983
## 1714 0 35 0 416 1057 0 0 234852
## ...101 ...102 ...103 ...104 ...105 ...106 ...107
## 11 Guinea-Bissau Guyana Haiti Holy See Honduras Hungary Iceland
## 1710 103587 520196 1585681 217 800707 632126 42186
## 1711 .. .. .. .. .. .. ..
## 1712 43556 455612 929239 209 730574 611108 41274
## 1713 60031 64584 656442 8 70133 21018 912
## 1714 51558 0 23 0 284 8 0
## ...108 ...109 ...110 ...111 ...112
## 11 India Indonesia Iran (Islamic Republic of) Iraq Ireland
## 1710 17510931 4532992 1301975 2033522 816797
## 1711 .. .. .. .. ..
## 1712 5530899 453491 1130032 986301 789416
## 1713 11980032 4079501 171943 1047221 27381
## 1714 566224 159181 7 10065 11
## ...113 ...114 ...115 ...116 ...117 ...118 ...119 ...120
## 11 Isle of Man Israel Italy Jamaica Japan Jordan Kazakhstan Kenya
## 1710 12809 369935 3077777 1111021 838852 784377 4005587 525437
## 1711 .. .. .. .. .. .. .. ..
## 1712 12807 278977 2688581 1072862 608252 147790 3925548 384465
## 1713 2 90958 389196 38159 230600 636587 80039 140972
## 1714 0 1514 2362 0 15509 1 2069 105916
## ...121 ...122 ...123 ...124 ...125
## 11 Kiribati Kuwait Kyrgyzstan Lao People's Democratic Republic Latvia
## 1710 4370 205382 754969 1347034 332220
## 1711 .. .. .. .. ..
## 1712 2622 82847 721883 313077 324492
## 1713 1748 122535 33086 1033957 7728
## 1714 324 32 0 89593 21
## ...126 ...127 ...128 ...129 ...130 ...131 ...132
## 11 Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg
## 1710 844158 341580 219338 180586 3713 610223 75470
## 1711 .. .. .. .. .. .. ..
## 1712 551588 1567 113868 106131 3598 596294 75025
## 1713 292570 340013 105470 74455 115 13929 445
## 1714 2834 8032 15953 5084 3 0 0
## ...133 ...134 ...135 ...136 ...137 ...138 ...139
## 11 Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands
## 1710 184762 324541 1689222 3053 1264700 111137 8205
## 1711 .. .. .. .. .. .. ..
## 1712 148199 24847 417547 1272 124815 110303 7815
## 1713 36563 299694 1271675 1781 1139885 834 390
## 1714 9620 82241 206595 0 342728 0 5
## ...140 ...141 ...142 ...143 ...144
## 11 Martinique Mauritania Mauritius Mayotte Mexico
## 1710 13919 128506 188344 6617 11796178
## 1711 .. .. .. .. ..
## 1712 725 33554 166931 0 11716621
## 1713 13194 94952 21413 6617 79557
## 1714 0 75443 186 0 298
## ...145 ...146 ...147 ...148 ...149
## 11 Micronesia (Fed. States of) Monaco Mongolia Montenegro Montserrat
## 1710 21819 31452 73488 153009 22838
## 1711 .. .. .. .. ..
## 1712 8867 30823 47537 152712 19703
## 1713 12952 629 25951 297 3135
## 1714 2 0 0 0 0
## ...150 ...151 ...152 ...153 ...154 ...155 ...156
## 11 Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands
## 1710 3136069 1013416 3699472 195515 2421 2285364 980753
## 1711 .. .. .. .. .. .. ..
## 1712 2937519 87858 223751 7401 804 288386 852577
## 1713 198550 925558 3475721 188114 1617 1996978 128176
## 1714 5821 74503 940617 2205 1550 40390 370
## ...157 ...158 ...159 ...160 ...161 ...162
## 11 New Caledonia New Zealand Nicaragua Niger Nigeria Niue
## 1710 5098 777303 682865 401653 1438331 5593
## 1711 .. .. .. .. .. ..
## 1712 2409 748000 337533 22389 774739 5521
## 1713 2689 29303 345332 379264 663592 72
## 1714 287 541 4 175245 297904 0
## ...163 ...164 ...165 ...166 ...167
## 11 North Macedonia Northern Mariana Islands Norway Oman Pakistan
## 1710 658264 2764 202336 24939 6303286
## 1711 .. .. .. .. ..
## 1712 459121 49 175111 11536 1498440
## 1713 199143 2715 27225 13403 4804846
## 1714 0 0 14507 0 114633
## ...168 ...169 ...170 ...171 ...172 ...173 ...174
## 11 Palau Panama Papua New Guinea Paraguay Peru Philippines Poland
## 1710 2650 161107 219126 871638 1512920 5377337 4446985
## 1711 .. .. .. .. .. .. ..
## 1712 198 136940 218265 114886 972369 3195290 4342547
## 1713 2452 24167 861 756752 540551 2182047 104438
## 1714 8 0 632 0 343 671 0
## ...175 ...176 ...177 ...178 ...179
## 11 Portugal Puerto Rico Qatar Republic of Korea Republic of Moldova
## 1710 2631559 2007347 171632 2176580 1013417
## 1711 .. .. .. .. ..
## 1712 2316070 1985964 154777 1837996 981305
## 1713 315489 21383 16855 338584 32112
## 1714 11571 1517 0 757 2
## ...180 ...181 ...182 ...183 ...184
## 11 Réunion Romania Russian Federation Rwanda Saint Helena
## 1710 133769 3572794 10491715 588544 6596
## 1711 .. .. .. .. ..
## 1712 131127 3425391 6448511 131344 4389
## 1713 2642 147403 4043204 457200 2207
## 1714 846 4 1052 415696 0
## ...185 ...186 ...187
## 11 Saint Kitts and Nevis Saint Lucia Saint Pierre and Miquelon
## 1710 124941 63605 2356
## 1711 .. .. ..
## 1712 112842 49554 2233
## 1713 12099 14051 123
## 1714 0 0 0
## ...188 ...189 ...190
## 11 Saint Vincent and the Grenadines Samoa San Marino
## 1710 60655 124403 2425
## 1711 .. .. ..
## 1712 44274 107757 2355
## 1713 16381 16646 70
## 1714 28 29 0
## ...191 ...192 ...193 ...194 ...195
## 11 Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles
## 1710 37013 296254 642654 950485 36788
## 1711 .. .. .. .. ..
## 1712 19852 183379 355359 939412 18010
## 1713 17161 112875 287295 11073 18778
## 1714 7143 3459 197108 1 17334
## ...196 ...197 ...198 ...199 ...200
## 11 Sierra Leone Singapore Sint Maarten (Dutch part) Slovakia Slovenia
## 1710 187102 340751 29209 345683 147593
## 1711 .. .. .. .. ..
## 1712 130107 189317 26736 343545 145859
## 1713 56995 151434 2473 2138 1734
## 1714 47823 10858 0 0 73
## ...201 ...202 ...203 ...204 ...205 ...206
## 11 Solomon Islands Somalia South Africa South Sudan Spain Sri Lanka
## 1710 4234 2054377 824601 2608218 1444942 1775768
## 1711 .. .. .. .. .. ..
## 1712 3082 508090 707872 38578 1091769 660919
## 1713 1152 1546287 116729 2569640 353173 1114849
## 1714 132 895732 43906 2443992 2598 128
## ...207 ...208 ...209 ...210 ...211
## 11 State of Palestine Sudan Suriname Sweden Switzerland
## 1710 3890650 2040613 423517 353825 679796
## 1711 .. .. .. .. ..
## 1712 112595 141179 379578 332333 632016
## 1713 3778055 1899434 43939 21492 47780
## 1714 3980 1097111 0 277 598
## ...212 ...213 ...214 ...215 ...216 ...217
## 11 Syrian Arab Republic Tajikistan Thailand Timor-Leste Togo Tokelau
## 1710 8225499 597959 1020119 39202 543277 2242
## 1711 .. .. .. .. .. ..
## 1712 1187179 558271 785079 15459 74367 2136
## 1713 7038320 39688 235040 23743 468910 106
## 1714 4583 4596 47612 0 145782 0
## ...218 ...219 ...220 ...221 ...222
## 11 Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan
## 1710 74433 334304 813213 3493071 260832
## 1711 .. .. .. .. ..
## 1712 69583 317605 769813 3321716 244721
## 1713 4850 16699 43400 171355 16111
## 1714 956 0 765 128 0
## ...223 ...224 ...225 ...226 ...227
## 11 Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates
## 1710 31033 3276 734951 5901067 154404
## 1711 .. .. .. .. ..
## 1712 28600 2374 153787 5212964 62861
## 1713 2433 902 581164 688103 91543
## 1714 744 302 261362 8 3498
## ...228 ...229 ...230
## 11 United Kingdom United Republic of Tanzania United States of America
## 1710 4274998 323173 3167072
## 1711 .. .. ..
## 1712 3773433 143509 1525091
## 1713 501565 179664 1641981
## 1714 39591 122824 56410
## ...231 ...232 ...233 ...234
## 11 United States Virgin Islands Uruguay Uzbekistan Vanuatu
## 1710 25863 633439 1979523 7346
## 1711 .. .. .. ..
## 1712 22055 434156 1523911 2702
## 1713 3808 199283 455612 4644
## 1714 521 843 229 64
## ...235 ...236 ...237
## 11 Venezuela (Bolivarian Republic of) Viet Nam Wallis and Futuna Islands
## 1710 2519780 2683954 11820
## 1711 .. .. ..
## 1712 593840 2326181 1
## 1713 1925940 357773 11819
## 1714 2463 86927 0
## ...238 ...239 ...240 ...241
## 11 Western Sahara Yemen Zambia Zimbabwe
## 1710 195572 1267610 493087 933654
## 1711 .. .. .. ..
## 1712 1244 106755 298307 325316
## 1713 194328 1160855 194780 608338
## 1714 29089 7479 57299 151639
View(Test)
Test <- Test[-c(1:2, 4:9)]
head(Test)
## ...3 ...10 ...11 ...12 ...13
## 11 Afghanistan Albania Algeria American Samoa
## 1710 WORLD 5120756 1207032 1944784 1817
## 1711 UN development groups .. .. .. ..
## 1712 More developed regions 686514 1199619 1851127 43
## 1713 Less developed regions 4434242 7413 93657 1774
## 1714 Least developed countries 536 1439 13793 446
## ...14 ...15 ...16 ...17 ...18 ...19 ...20
## 11 Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba
## 1710 9114 661590 2707 55089 1013414 964848 19640
## 1711 .. .. .. .. .. .. ..
## 1712 7849 244608 1061 42352 664757 778187 13889
## 1713 1265 416982 1646 12737 348657 186661 5751
## 1714 1166 250846 0 4249 628 8 0
## ...21 ...22 ...23 ...24 ...25 ...26 ...27
## 11 Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados
## 1710 577255 575950 1155852 46467 60153 7835152 112925
## 1711 .. .. .. .. .. .. ..
## 1712 472987 529343 940311 44731 12869 804412 107860
## 1713 104268 46607 215541 1736 47284 7030740 5065
## 1714 2238 187 4 12 30558 1533 10
## ...28 ...29 ...30 ...31 ...32 ...33
## 11 Belarus Belgium Belize Benin Bermuda Bhutan
## 1710 1480794 581740 68144 666357 18049 49216
## 1711 .. .. .. .. .. ..
## 1712 1342671 532916 62700 35183 17782 14735
## 1713 138123 48824 5444 631174 267 34481
## 1714 0 873 1 102401 0 27688
## ...34 ...35
## 11 Bolivia (Plurinational State of) Bonaire, Sint Eustatius and Saba
## 1710 878211 12764
## 1711 .. ..
## 1712 291987 9454
## 1713 586224 3310
## 1714 4 0
## ...36 ...37 ...38 ...39
## 11 Bosnia and Herzegovina Botswana Brazil British Virgin Islands
## 1710 1653056 86501 1745339 5417
## 1711 .. .. .. ..
## 1712 1648777 7277 1383903 601
## 1713 4279 79224 361436 4816
## 1714 1 1327 16029 565
## ...40 ...41 ...42 ...43 ...44 ...45
## 11 Brunei Darussalam Bulgaria Burkina Faso Burundi Cabo Verde Cambodia
## 1710 46977 1541860 1581083 623999 186372 1097884
## 1711 .. .. .. .. .. ..
## 1712 14638 856935 31729 36784 165842 353130
## 1713 32339 684925 1549354 587215 20530 744754
## 1714 0 2 108246 566940 18249 23542
## ...46 ...47 ...48 ...49 ...50
## 11 Cameroon Canada Cayman Islands Central African Republic Chad
## 1710 383029 1323087 1973 767884 206400
## 1711 .. .. .. .. ..
## 1712 247217 1182163 1837 21835 13221
## 1713 135812 140924 136 746049 193179
## 1714 39018 1896 0 447302 113933
## ...51 ...52 ...53 ...54 ...55
## 11 Channel Islands Chile China China, Hong Kong SAR China, Macao SAR
## 1710 22545 650151 10732281 1110358 161930
## 1711 .. .. .. .. ..
## 1712 22417 345515 6315211 741825 24974
## 1713 128 304636 4417070 368533 136956
## 1714 0 2062 247825 123 0
## ...56 ...57 ...58 ...59 ...60 ...61
## 11 Colombia Comoros Congo Cook Islands Costa Rica Côte d'Ivoire
## 1710 2869032 120297 239397 22488 150400 1114003
## 1711 .. .. .. .. .. ..
## 1712 1453269 40870 113088 22429 116319 201763
## 1713 1415763 79427 126309 59 34081 912240
## 1714 3314 13385 68203 0 378 831478
## ...62 ...63 ...64 ...65 ...66
## 11 Croatia Cuba Curaçao Cyprus Czechia
## 1710 990012 1654684 123132 214648 911388
## 1711 .. .. .. .. ..
## 1712 982470 1577214 112716 191347 900934
## 1713 7542 77470 10416 23301 10454
## 1714 1120 2926 0 7 0
## ...67 ...68
## 11 Dem. People's Republic of Korea Democratic Republic of the Congo
## 1710 113118 1684615
## 1711 .. ..
## 1712 31597 299778
## 1713 81521 1384837
## 1714 3349 1112671
## ...69 ...70 ...71 ...72 ...73 ...74
## 11 Denmark Djibouti Dominica Dominican Republic Ecuador Egypt
## 1710 255616 18668 78634 1558668 1183685 3547626
## 1711 .. .. .. .. .. ..
## 1712 238184 12775 56471 1446445 1079500 640473
## 1713 17432 5893 22163 112223 104185 2907153
## 1714 258 4013 12 2363 1 30841
## ...75 ...76 ...77 ...78 ...79 ...80
## 11 El Salvador Equatorial Guinea Eritrea Estonia Eswatini Ethiopia
## 1710 1600739 125670 751481 208257 108188 871747
## 1711 .. .. .. .. .. ..
## 1712 1526023 22883 270147 204905 14525 441756
## 1713 74716 102787 481334 3352 93663 429991
## 1714 3 11355 439234 0 119 127009
## ...81 ...82 ...83 ...84 ...85
## 11 Falkland Islands (Malvinas) Faroe Islands Fiji Finland France
## 1710 1623 13838 222633 290006 2296534
## 1711 .. .. .. .. ..
## 1712 1564 13830 220033 282344 1681852
## 1713 59 8 2600 7662 614682
## 1714 0 0 899 5 47437
## ...86 ...87 ...88 ...89 ...90 ...91 ...92
## 11 French Guiana French Polynesia Gabon Gambia Georgia Germany Ghana
## 1710 4555 1982 46684 118483 852816 4014203 970625
## 1711 .. .. .. .. .. .. ..
## 1712 317 907 26435 97841 710853 3365059 491123
## 1713 4238 1075 20249 20642 141963 649144 479502
## 1714 0 385 15025 11238 0 3678 115784
## ...93 ...94 ...95 ...96 ...97 ...98 ...99 ...100
## 11 Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guinea
## 1710 14320 1039257 18684 75784 11856 2197 1205644 530963
## 1711 .. .. .. .. .. .. .. ..
## 1712 14181 903776 18207 63884 566 127 1111234 116980
## 1713 139 135481 477 11900 11290 2070 94410 413983
## 1714 0 35 0 416 1057 0 0 234852
## ...101 ...102 ...103 ...104 ...105 ...106 ...107
## 11 Guinea-Bissau Guyana Haiti Holy See Honduras Hungary Iceland
## 1710 103587 520196 1585681 217 800707 632126 42186
## 1711 .. .. .. .. .. .. ..
## 1712 43556 455612 929239 209 730574 611108 41274
## 1713 60031 64584 656442 8 70133 21018 912
## 1714 51558 0 23 0 284 8 0
## ...108 ...109 ...110 ...111 ...112
## 11 India Indonesia Iran (Islamic Republic of) Iraq Ireland
## 1710 17510931 4532992 1301975 2033522 816797
## 1711 .. .. .. .. ..
## 1712 5530899 453491 1130032 986301 789416
## 1713 11980032 4079501 171943 1047221 27381
## 1714 566224 159181 7 10065 11
## ...113 ...114 ...115 ...116 ...117 ...118 ...119 ...120
## 11 Isle of Man Israel Italy Jamaica Japan Jordan Kazakhstan Kenya
## 1710 12809 369935 3077777 1111021 838852 784377 4005587 525437
## 1711 .. .. .. .. .. .. .. ..
## 1712 12807 278977 2688581 1072862 608252 147790 3925548 384465
## 1713 2 90958 389196 38159 230600 636587 80039 140972
## 1714 0 1514 2362 0 15509 1 2069 105916
## ...121 ...122 ...123 ...124 ...125
## 11 Kiribati Kuwait Kyrgyzstan Lao People's Democratic Republic Latvia
## 1710 4370 205382 754969 1347034 332220
## 1711 .. .. .. .. ..
## 1712 2622 82847 721883 313077 324492
## 1713 1748 122535 33086 1033957 7728
## 1714 324 32 0 89593 21
## ...126 ...127 ...128 ...129 ...130 ...131 ...132
## 11 Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg
## 1710 844158 341580 219338 180586 3713 610223 75470
## 1711 .. .. .. .. .. .. ..
## 1712 551588 1567 113868 106131 3598 596294 75025
## 1713 292570 340013 105470 74455 115 13929 445
## 1714 2834 8032 15953 5084 3 0 0
## ...133 ...134 ...135 ...136 ...137 ...138 ...139
## 11 Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands
## 1710 184762 324541 1689222 3053 1264700 111137 8205
## 1711 .. .. .. .. .. .. ..
## 1712 148199 24847 417547 1272 124815 110303 7815
## 1713 36563 299694 1271675 1781 1139885 834 390
## 1714 9620 82241 206595 0 342728 0 5
## ...140 ...141 ...142 ...143 ...144
## 11 Martinique Mauritania Mauritius Mayotte Mexico
## 1710 13919 128506 188344 6617 11796178
## 1711 .. .. .. .. ..
## 1712 725 33554 166931 0 11716621
## 1713 13194 94952 21413 6617 79557
## 1714 0 75443 186 0 298
## ...145 ...146 ...147 ...148 ...149
## 11 Micronesia (Fed. States of) Monaco Mongolia Montenegro Montserrat
## 1710 21819 31452 73488 153009 22838
## 1711 .. .. .. .. ..
## 1712 8867 30823 47537 152712 19703
## 1713 12952 629 25951 297 3135
## 1714 2 0 0 0 0
## ...150 ...151 ...152 ...153 ...154 ...155 ...156
## 11 Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands
## 1710 3136069 1013416 3699472 195515 2421 2285364 980753
## 1711 .. .. .. .. .. .. ..
## 1712 2937519 87858 223751 7401 804 288386 852577
## 1713 198550 925558 3475721 188114 1617 1996978 128176
## 1714 5821 74503 940617 2205 1550 40390 370
## ...157 ...158 ...159 ...160 ...161 ...162
## 11 New Caledonia New Zealand Nicaragua Niger Nigeria Niue
## 1710 5098 777303 682865 401653 1438331 5593
## 1711 .. .. .. .. .. ..
## 1712 2409 748000 337533 22389 774739 5521
## 1713 2689 29303 345332 379264 663592 72
## 1714 287 541 4 175245 297904 0
## ...163 ...164 ...165 ...166 ...167
## 11 North Macedonia Northern Mariana Islands Norway Oman Pakistan
## 1710 658264 2764 202336 24939 6303286
## 1711 .. .. .. .. ..
## 1712 459121 49 175111 11536 1498440
## 1713 199143 2715 27225 13403 4804846
## 1714 0 0 14507 0 114633
## ...168 ...169 ...170 ...171 ...172 ...173 ...174
## 11 Palau Panama Papua New Guinea Paraguay Peru Philippines Poland
## 1710 2650 161107 219126 871638 1512920 5377337 4446985
## 1711 .. .. .. .. .. .. ..
## 1712 198 136940 218265 114886 972369 3195290 4342547
## 1713 2452 24167 861 756752 540551 2182047 104438
## 1714 8 0 632 0 343 671 0
## ...175 ...176 ...177 ...178 ...179
## 11 Portugal Puerto Rico Qatar Republic of Korea Republic of Moldova
## 1710 2631559 2007347 171632 2176580 1013417
## 1711 .. .. .. .. ..
## 1712 2316070 1985964 154777 1837996 981305
## 1713 315489 21383 16855 338584 32112
## 1714 11571 1517 0 757 2
## ...180 ...181 ...182 ...183 ...184
## 11 Réunion Romania Russian Federation Rwanda Saint Helena
## 1710 133769 3572794 10491715 588544 6596
## 1711 .. .. .. .. ..
## 1712 131127 3425391 6448511 131344 4389
## 1713 2642 147403 4043204 457200 2207
## 1714 846 4 1052 415696 0
## ...185 ...186 ...187
## 11 Saint Kitts and Nevis Saint Lucia Saint Pierre and Miquelon
## 1710 124941 63605 2356
## 1711 .. .. ..
## 1712 112842 49554 2233
## 1713 12099 14051 123
## 1714 0 0 0
## ...188 ...189 ...190
## 11 Saint Vincent and the Grenadines Samoa San Marino
## 1710 60655 124403 2425
## 1711 .. .. ..
## 1712 44274 107757 2355
## 1713 16381 16646 70
## 1714 28 29 0
## ...191 ...192 ...193 ...194 ...195
## 11 Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles
## 1710 37013 296254 642654 950485 36788
## 1711 .. .. .. .. ..
## 1712 19852 183379 355359 939412 18010
## 1713 17161 112875 287295 11073 18778
## 1714 7143 3459 197108 1 17334
## ...196 ...197 ...198 ...199 ...200
## 11 Sierra Leone Singapore Sint Maarten (Dutch part) Slovakia Slovenia
## 1710 187102 340751 29209 345683 147593
## 1711 .. .. .. .. ..
## 1712 130107 189317 26736 343545 145859
## 1713 56995 151434 2473 2138 1734
## 1714 47823 10858 0 0 73
## ...201 ...202 ...203 ...204 ...205 ...206
## 11 Solomon Islands Somalia South Africa South Sudan Spain Sri Lanka
## 1710 4234 2054377 824601 2608218 1444942 1775768
## 1711 .. .. .. .. .. ..
## 1712 3082 508090 707872 38578 1091769 660919
## 1713 1152 1546287 116729 2569640 353173 1114849
## 1714 132 895732 43906 2443992 2598 128
## ...207 ...208 ...209 ...210 ...211
## 11 State of Palestine Sudan Suriname Sweden Switzerland
## 1710 3890650 2040613 423517 353825 679796
## 1711 .. .. .. .. ..
## 1712 112595 141179 379578 332333 632016
## 1713 3778055 1899434 43939 21492 47780
## 1714 3980 1097111 0 277 598
## ...212 ...213 ...214 ...215 ...216 ...217
## 11 Syrian Arab Republic Tajikistan Thailand Timor-Leste Togo Tokelau
## 1710 8225499 597959 1020119 39202 543277 2242
## 1711 .. .. .. .. .. ..
## 1712 1187179 558271 785079 15459 74367 2136
## 1713 7038320 39688 235040 23743 468910 106
## 1714 4583 4596 47612 0 145782 0
## ...218 ...219 ...220 ...221 ...222
## 11 Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan
## 1710 74433 334304 813213 3493071 260832
## 1711 .. .. .. .. ..
## 1712 69583 317605 769813 3321716 244721
## 1713 4850 16699 43400 171355 16111
## 1714 956 0 765 128 0
## ...223 ...224 ...225 ...226 ...227
## 11 Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates
## 1710 31033 3276 734951 5901067 154404
## 1711 .. .. .. .. ..
## 1712 28600 2374 153787 5212964 62861
## 1713 2433 902 581164 688103 91543
## 1714 744 302 261362 8 3498
## ...228 ...229 ...230
## 11 United Kingdom United Republic of Tanzania United States of America
## 1710 4274998 323173 3167072
## 1711 .. .. ..
## 1712 3773433 143509 1525091
## 1713 501565 179664 1641981
## 1714 39591 122824 56410
## ...231 ...232 ...233 ...234
## 11 United States Virgin Islands Uruguay Uzbekistan Vanuatu
## 1710 25863 633439 1979523 7346
## 1711 .. .. .. ..
## 1712 22055 434156 1523911 2702
## 1713 3808 199283 455612 4644
## 1714 521 843 229 64
## ...235 ...236 ...237
## 11 Venezuela (Bolivarian Republic of) Viet Nam Wallis and Futuna Islands
## 1710 2519780 2683954 11820
## 1711 .. .. ..
## 1712 593840 2326181 1
## 1713 1925940 357773 11819
## 1714 2463 86927 0
## ...238 ...239 ...240 ...241
## 11 Western Sahara Yemen Zambia Zimbabwe
## 1710 195572 1267610 493087 933654
## 1711 .. .. .. ..
## 1712 1244 106755 298307 325316
## 1713 194328 1160855 194780 608338
## 1714 29089 7479 57299 151639
View(Test)