Country names & codes (all countries)

Country Names and Codes dataset

All needed World Country Names, Codes and other details with free direct download.

Dataset with country names and country names alternatives, two chart ISO codes, three-chart ISO codes, country numeric codes, Top Level Domain names and telephone country codes.

What data we offer
– all official countries in the world
– Country names and their alternatives
– 2 char and 3 char country code
– TLD – top level domains
– format .xlsx and CSV
– .xlsx file consists sheet Main with notes about data
– optimized size
– ready to use for data analytics
– best for mapping country name by country code
– ready for use in any software

2 datasets available – BASIC and EXPANDED

  • Basic contains just 4 most used columns
  • Expanded contains many forms of the country names, telephone codes and internet Top Level Domain

This dataset is part of CDS World Countries Open Geo Dataset

Enjoying the dataset? 

  • If you find this dataset useful, feel free to share link to this page.
    • https://coronadatasource.org/open-data/geo/country-names-codes-all-countries/
  • If you have idea for improving the dataset?

Created by CDS – CoronaDataSource specialists by cleaning Wikipedia sources

GUIDE HOW TO TREAT WORLD COUNTRY NAMES AND CODES

This dataset contains all countries in the world together with their unique country codes

Recommendations:

  • 2char country code is best for mapping. It is the unique code for every country regardless of country name version.
  • Use Country Name (Usual) for country name mapping. This column is without diacritics and with most used name.
  • Country Name (Usual) also uses better distinguished names like North Korea and South Korea instead of only official Korea
  • Country names (official) are derived from ISO 3166 country codes

Dataset contains fields

Name of columntype of fieldDescription
Country Name (usual)textThe most used name for country without diacritics (Use This Column)
Country Name (short official)textOfficial country name (short official country name, with diacritics)
Country Name (alternative)textCountry name with most used title, often same as Country Name (usual)
Usual Country titletextMost used title from alternative country name, often blank
Official country name (long)textOfficial country name (Long official country name with all titles)
SovereigntytextSovereignty (UN member or Dependent on country or disputed)
2char country codetextISO 3166 Alpha-2 code
3char country codetextISO 3166 Alpha-3 code
numeric codewhole numberISO 3166 Numeric code
internet TLDtextInternet Top Level Domain, sometimes blank
tel. country CodetextText with format “+” & number, sometimes blank

 

Exceptions in database

Type of exceptionNote
2 names for countryUnited Kingdom (#236 GB) is often named Great Britain (GB is unofficial, but popular name)
TLD exceptionUnited Kingdom (#236 GB) uses two TLD – .gb & .uk – only most famous .uk is in table
2 names for countryFalkland Islands (#69 FK) is using also name Malvinas
2 different countries of Congo(#55 CD) Congo and (#180 CG) Congo

(#55 CD) Congo Kinshasa is The Democratic Republic of the Congo (5,2 mil. Population), often named French Congo

(#180 CG) Congo Brazzaville is The Republic of the Congo (91 mil. Population), old name Zaire

2 different countries of Korea(#162 KP) Korea as North Korea and (#207 KR) Korea as South Korea
2 countries with similar name(#201 SK) Slovakia and (#202 SI) Slovenia (both in EU, both with €, both small states)
# Others Value(#252) Value is Others with country code XX. This code is usable for places outside official countries
# Undefined Value(#253) Value is # Undefined with the country code XY. This code is usable for errors

Source:
CoronaDataSource.org
https://coronadatasource.org/open-data/geo/country-names-codes-all-countries/

License
Unlicensed and free to use

Data optimized and cleaned by CDS specialists from Wikipedia source
CoronaDataSource.org

Original data source
https://en.wikipedia.org/wiki/ISO_3166-2

DATASET PREVIEW TABLE

Country Name (usual)2char country code3char country codenumeric code
AfghanistanAFAFG4
Aland IslandsAXALA248
AlbaniaALALB8
AlgeriaDZDZA12
American SamoaASASM16
AndorraADAND20
AngolaAOAGO24
AnguillaAIAIA660
AntarcticaAQATA10
Antigua and BarbudaAGATG28
ArgentinaARARG32
ArmeniaAMARM51
ArubaAWABW533
AustraliaAUAUS36
AustriaATAUT40
AzerbaijanAZAZE31
BahrainBHBHR48
BangladeshBDBGD50
BarbadosBBBRB52
BelarusBYBLR112
BelgiumBEBEL56
BelizeBZBLZ84
BeninBJBEN204
BermudaBMBMU60
BhutanBTBTN64
BoliviaBOBOL68
BonaireBQBES535
Bosnia and HerzegovinaBABIH70
BotswanaBWBWA72
Bouvet IslandBVBVT74
BrazilBRBRA76
British Indian Ocean TerritoryIOIOT86
Virgin IslandsVGVGB92
BruneiBNBRN96
BulgariaBGBGR100
Burkina FasoBFBFA854
BurundiBIBDI108
CambodiaKHKHM116
CameroonCMCMR120
CanadaCACAN124
Cabo VerdeCVCPV132
Cayman IslandsKYCYM136
Central African RepublicCFCAF140
CocosCCCCK166
Saint MartinMFMAF663
ColombiaCOCOL170
ComorosKMCOM174
Cook IslandsCKCOK184
Costa RicaCRCRI188
CroatiaHRHRV191
CubaCUCUB192
CuracaoCWCUW531
CyprusCYCYP196
CzechiaCZCZE203
Congo KinshasaCDCOD180
DenmarkDKDNK208
DjiboutiDJDJI262
DominicaDMDMA212
Dominican RepublicDODOM214
Timor LesteTLTLS626
EcuadorECECU218
EgyptEGEGY818
El SalvadorSVSLV222
Equatorial GuineaGQGNQ226
EritreaERERI232
EstoniaEEEST233
EswatiniSZSWZ748
EthiopiaETETH231
Falkland IslandsFKFLK238
Faroe IslandsFOFRO234
MicronesiaFMFSM583
FijiFJFJI242
FinlandFIFIN246
FranceFRFRA250
French GuianaGFGUF254
French PolynesiaPFPYF258
French Southern TerritoriesTFATF260
GabonGAGAB266
GeorgiaGEGEO268
GermanyDEDEU276
GhanaGHGHA288
GibraltarGIGIB292
GreeceGRGRC300
GreenlandGLGRL304
GrenadaGDGRD308
GuadeloupeGPGLP312
GuamGUGUM316
GuatemalaGTGTM320
GuernseyGGGGY831
GuineaGNGIN324
Guinea BissauGWGNB624
GuyanaGYGUY328
HaitiHTHTI332
Heard Island and McDonald IslandsHMHMD334
Vatican CityVAVAT336
HondurasHNHND340
Hong KongHKHKG344
HungaryHUHUN348
ChadTDTCD148
ChileCLCHL152
ChinaCNCHN156
Christmas IslandCXCXR162
IcelandISISL352
IndiaININD356
IndonesiaIDIDN360
IranIRIRN364
IraqIQIRQ368
Isle of ManIMIMN833
IsraelILISR376
ItalyITITA380
Cote d’IvoireCICIV384
JamaicaJMJAM388
JapanJPJPN392
JerseyJEJEY832
JordanJOJOR400
KazakhstanKZKAZ398
KenyaKEKEN404
KiribatiKIKIR296
KuwaitKWKWT414
KyrgyzstanKGKGZ417
LaosLALAO418
LatviaLVLVA428
LebanonLBLBN422
LesothoLSLSO426
LiberiaLRLBR430
LibyaLYLBY434
LiechtensteinLILIE438
LithuaniaLTLTU440
LuxembourgLULUX442
MacaoMOMAC446
MadagascarMGMDG450
MalawiMWMWI454
MalaysiaMYMYS458
MaldivesMVMDV462
MaliMLMLI466
MaltaMTMLT470
Marshall IslandsMHMHL584
MartiniqueMQMTQ474
MauritaniaMRMRT478
MauritiusMUMUS480
MayotteYTMYT175
MexicoMXMEX484
MoldovaMDMDA498
MonacoMCMCO492
MongoliaMNMNG496
MontenegroMEMNE499
MontserratMSMSR500
MoroccoMAMAR504
MozambiqueMZMOZ508
MyanmarMMMMR104
NamibiaNANAM516
NauruNRNRU520
NepalNPNPL524
NetherlandsNLNLD528
New CaledoniaNCNCL540
New ZealandNZNZL554
NicaraguaNINIC558
NigerNENER562
NigeriaNGNGA566
NiueNUNIU570
Norfolk IslandNFNFK574
North KoreaKPPRK408
North MacedoniaMKMKD807
Northern Mariana IslandsMPMNP580
NorwayNONOR578
OmanOMOMN512
PakistanPKPAK586
PalauPWPLW585
PanamaPAPAN591
Papua New GuineaPGPNG598
ParaguayPYPRY600
PeruPEPER604
PhilippinesPHPHL608
PitcairnPNPCN612
PolandPLPOL616
PortugalPTPRT620
Puerto RicoPRPRI630
QatarQAQAT634
IrelandIEIRL372
Congo BrazzavilleCGCOG178
ReunionREREU638
RomaniaROROU642
RussiaRURUS643
RwandaRWRWA646
Saint BarthelemyBLBLM652
Saint HelenaSHSHN654
Saint Kitts and NevisKNKNA659
Saint LuciaLCLCA662
Saint Pierre and MiquelonPMSPM666
Saint Vincent and the GrenadinesVCVCT670
SamoaWSWSM882
San MarinoSMSMR674
Sao Tome and PrincipeSTSTP678
Saudi ArabiaSASAU682
SenegalSNSEN686
SerbiaRSSRB688
SeychellesSCSYC690
Sierra LeoneSLSLE694
SingaporeSGSGP702
Sint MaartenSXSXM534
SlovakiaSKSVK703
SloveniaSISVN705
Solomon IslandsSBSLB90
SomaliaSOSOM706
South AfricaZAZAF710
South Georgia and the South Sandwich IslandsGSSGS239
South KoreaKRKOR410
South SudanSSSSD728
SpainESESP724
Sri LankaLKLKA144
PalestinePSPSE275
SudanSDSDN729
SurinameSRSUR740
SvalbardSJSJM744
SwedenSESWE752
SwitzerlandCHCHE756
SyriaSYSYR760
TaiwanTWTWN158
TajikistanTJTJK762
TanzaniaTZTZA834
ThailandTHTHA764
BahamasBSBHS44
GambiaGMGMB270
TogoTGTGO768
TokelauTKTKL772
TongaTOTON776
Trinidad and TobagoTTTTO780
TunisiaTNTUN788
TurkeyTRTUR792
TurkmenistanTMTKM795
Turks and Caicos IslandsTCTCA796
TuvaluTVTUV798
UgandaUGUGA800
UkraineUAUKR804
United Arab EmiratesAEARE784
United KingdomGBGBR826
Virgin IslandsVIVIR850
United States Minor Outlying IslandsUMUMI581
USAUSUSA840
UruguayUYURY858
UzbekistanUZUZB860
VanuatuVUVUT548
VenezuelaVEVEN862
VietnamVNVNM704
Wallis and FutunaWFWLF876
Western SaharaEHESH732
YemenYEYEM887
ZambiaZMZMB894
ZimbabweZWZWE716
KosovoXKXKX383
Netherlands AntillesANANT530
OthersXXXXX999
# UndefinedXYXXY998

Last Updated on

Corona Data Source .org

The best place to find updated online open data.