Many records are missing a country name and identifier. ETL could be updated to parse some of the more obvious strings such as "U.S.A" to assign a countryId. Below are the most frequent strings (n > 100) that have missing identifiers.
Eesti 30930
DANMARK 21151
HOLLAND 14336
U.S.A. 10933
Tanzania 3516
NORGE 1582
Finland 1546
Unknown 1203
Suomi 861
FINLAND 859
Svalbard 739
United States of America 733
South Korea 601
Holland 433
Ivory Coast 427
MAROC 419
Canary Islands 405
Zaire 398
Hawaii 290
unknown 278
U.S.A 251
Skotlanti 232
Iso-Britannia 231
Tunis 229
FI 227
U.K. 218
England 204
Europe 194
Arabiemiraatit 182
Reunion 175
Great Britain 171
España 170
Norge 170
BALTIC SEA 159
Republic of South Africa 155
Madeira 145
USSR 122
Republic du Congo 116
Republic of Macedonia 115
Spain (Canary Islands) 110
REP. DEMOCRATIQUE DU CONGO 109
Many records are missing a country name and identifier. ETL could be updated to parse some of the more obvious strings such as "U.S.A" to assign a countryId. Below are the most frequent strings (n > 100) that have missing identifiers.