Below is a table of countries, with their ISO and UN codes, assigned top-level Internet domains and timezone relative to UTC. In all cases, there may be gaps where the ISO or UN codes, or Internet domains, have not yet been assigned. Dependent territories are provided as entries under the country to which responsibility is recognised; entities which no longer exist are shown in grey.

Caveats apply especially in the cases of Serbia, Montenegro and Kosovo, where the codes may have changed since this list was produced.

This list is also available in SQL format, where the following fields are defined:

  • country_id: Sequential from 1 to 250;
  • name: Alpha characters, ASCII;
  • iso2: ISO alpha-2 code if available;
  • iso3: ISO alpha-3 code if available;
  • un3: UN number if available;
  • sovereign: Flag (0 if dependent territory);
  • extant: Flag (0 if no longer existing);
  • parent: Set to parent's country_id if dependent;
  • cctld: Two-character Internet domain;
  • time_offset: Number of hours from UTC.

http://imrannazar.com/content/files/countries.sql

CountryISO alpha-2ISO alpha-3UN numberInternet TLDTimezone
AfghanistanAFAFG004af+4.50
AlbaniaALALB008al+1
AlgeriaDZDZA012dz+1
AndorraADAND020ad+1
AngolaAOAGO024ao+1
Antigua and BarbudaAGATG028ag-4
ArgentinaARARG032ar-3
ArmeniaAMARM051am+4
AustraliaAUAUS036au+10
Christmas Islandcx+7
Cocos (Keeling) Islandcc+6.50
Heard and McDonald Islandshm+5
Norfolk IslandNFNFK574nf+11.50
AustriaATAUT040at+1
AzerbaijanAZAZE031az+4
BahamasBSBHS044bs-5
BahrainBHBHR048bh+3
BangladeshBDBGD050bd+6
BarbadosBBBRB052bb-4
BelarusBYBLR112by+2
BelgiumBEBEL056be+1
BelizeBZBLZ084bz-6
BeninBJBEN204bj+1
BhutanBTBTN064bt+6
BoliviaBOBOL068bo-4
Bosnia and HerzegovinaBABIH070ba+1
BotswanaBWBWA072bw+2
BrazilBRBRA076br-3
Brunei DarussalamBNBRN096bn+8
BulgariaBGBGR100bg+2
Burkina FasoBFBFA854bf+0
BurundiBIBDI108bi+2
CambodiaKHKHM116kh+7
CameroonCMCMR120cm+1
CanadaCACAN124ca-5
Cape VerdeCVCPV132cv-1
Central African RepublicCFCAF140cf+1
ChadTDTCD148td+1
ChileCLCHL152cl-4
ChinaCNCHN156cn+8
Hong KongHKHKG344hk+8
MacauMOMAC446mo+8
ColombiaCOCOL170co-5
ComorosKMCOM174km+3
Congo, Democratic Republic ofCDCOD180cd+1
Congo, Republic ofCGCOG178cg+1
Costa RicaCRCRI188cr-6
Cote d'IvoireCICIV384ci+0
CroatiaHRHRV191hr+1
CubaCUCUB192cu-5
CyprusCYCYP196cy+2
Czech RepublicCZCZE203cz+1
DenmarkDKDNK208dk+1
Faroe IslandsFOFRO234fo+0
GreenlandGLGRL304gl-3
DjiboutiDJDJI262dj+3
DominicaDMDMA212dm-4
Dominican RepublicDODOM214do-4
EcuadorECECU218ec-5
EgyptEGEGY818eg+2
El SalvadorSVSLV222sv-6
Equatorial GuineaGQGNQ226gq+1
EritreaERERI232er+3
EstoniaEEEST233ee+2
EthiopiaETETH230et+3
FijiFJFJI242fj+12
FinlandFIFIN246fi+2
AlandAXALA248+2
FranceFRFRA250fr+1
French GuianaGFGUF254gf-3
French PolynesiaPFPYF258pf-10
French Southern Territoriestf+5
GuadeloupeGPGLP312gp-4
MartiniqueMQMTQ474mq-4
MayotteYTMYT175yt+3
New CaledoniaNCNCL540nc+11
ReunionREREU638re+4
Saint Pierre and MiquelonPMSPM666pm+0
Wallis and Futuna IslandsWFWLF876wf+12
GabonGAGAB266ga+1
GambiaGMGMB270gm+0
GeorgiaGEGEO268ge+4
GermanyDEDEU276de+1
GhanaGHGHA288gh+0
GreeceGRGRC300gr+2
GrenadaGDGRD308gd-4
GuatemalaGTGTM320gt-6
GuineaGNGIN324gn+0
Guinea-BissauGWGNB624gw+0
GuyanaGYGUY328gy-4
HaitiHTHTI332ht-5
HondurasHNHND340hn-6
HungaryHUHUN348hu+1
IcelandISISL352is+0
IndiaININD356in+5.50
IndonesiaIDIDN360id+7
IranIRIRN364ir+3.50
IraqIQIRQ368iq+3
IrelandIEIRL372ie+0
IsraelILISR376il+2
ItalyITITA380it+1
JamaicaJMJAM388jm-5
JapanJPJPN392jp+9
JordanJOJOR400jo+0
KazakhstanKZKAZ398kz+6
KenyaKEKEN404ke+3
KiribatiKIKIR296ki+12
Korea, NorthKPPRK408kp+9
Korea, SouthKRKOR410kr+9
Kosovo+1
KuwaitKWKWT414kw+3
KyrgyzstanKGKGZ417kg+6
LaosLALAO418la+7
LatviaLVLVA428lv+2
LebanonLBLBN422lb+0
LesothoLSLSO426ls+2
LiberiaLRLBR430lr+0
LibyaLYLBY434ly+2
LiechtensteinLILIE438li+1
LithuaniaLTLTU440lt+2
LuxembourgLULUX442lu+1
MacedoniaMKMKD807mk+1
MadagascarMGMDG450mg+3
MalawiMWMWI454mw+2
MalaysiaMYMYS458my+8
MaldivesMVMDV462mv+5
MaliMLMLI466ml+0
MaltaMTMLT470mt+1
Marshall IslandsMHMHL584mh+12
MauritaniaMRMRT478mr+0
MauritiusMUMUS480mu+4
MexicoMXMEX484mx-6
MicronesiaFMFSM583fm+10
MoldovaMDMDA498md+2
MonacoMCMCO492mc+1
MongoliaMNMNG496mn+8
Montenegrome+1
MoroccoMAMAR504ma+0
Western SaharaEHESH732eh+0
MozambiqueMZMOZ508mz+2
MyanmarMMMMR104mm+6.50
NamibiaNANAM516na+2
NauruNRNRU520nr+12
NepalNPNPL524np+5.75
NetherlandsNLNLD528nl+1
ArubaAWABW533aw-4
Netherlands AntillesANANT530an-4
New ZealandNZNZL554nz+12
Cook IslandsCKCOK184ck-10
NiueNUNIU570nu-11
Tokelautk-10
NicaraguaNINIC558ni-6
NigerNENER562ne+1
NigeriaNGNGA566ng+1
NorwayNONOR578no+1
Bouvet Islandbv+1
Svalbard and Jan Mayen IslandsSJSJM744sj+1
OmanOMOMN512om+4
PakistanPKPAK586pk+5
PalauPWPLW585pw+9
Palestinian Territory, OccupiedPSPSE275ps+0
PanamaPAPAN591pa-5
Papua New GuineaPGPNG598pg+10
ParaguayPYPRY600py-4
PeruPEPER604pe-5
PhilippinesPHPHL608ph+8
PolandPLPOL616pl+1
PortugalPTPRT620pt+0
QatarQAQAT634qa+3
RomaniaROROU642ro+2
RussiaRURUS643ru+3
RwandaRWRWA646rw+2
Saint Kitts and NevisKNKNA659kn-4
Saint LuciaLCLCA662lc-4
Saint Vincent and the GrenadinesVCVCT670vc-4
SamoaWSWSM882ws-11
San MarinoSMSMR674sm+1
Sao Tome and PrincipeSTSTP678st+0
Saudi ArabiaSASAU682sa+3
SenegalSNSEN686sn+0
SerbiaCSSCG891rs+1
SeychellesSCSYC690sc+4
Sierra LeoneSLSLE694sl+0
SingaporeSGSGP702sg+8
SlovakiaSKSVK703sk+1
SloveniaSISVN705si+1
Solomon IslandsSBSLB090sb+11
SomaliaSOSOM706so+3
South AfricaZAZAF710za+2
SpainESESP724es+1
Sri LankaLKLKA144lk+5.50
SudanSDSDN736sd+3
SurinameSRSUR740sr+0
SwazilandSZSWZ748sz+2
SwedenSESWE752se+1
SwitzerlandCHCHE756ch+1
SyriaSYSYR760sy+0
TaiwanTWTWN158tw+8
TajikistanTJTJK762tj+5
TanzaniaTZTZA834tz+3
ThailandTHTHA764th+7
Timor-LesteTLTLS626tp+9
TogoTGTGO768tg+0
TongaTOTON776to+13
Trinidad and TobagoTTTTO780tt-4
TunisiaTNTUN788tn+1
TurkeyTRTUR792tr+2
TurkmenistanTMTKM795tm+5
TuvaluTVTUV798tv+12
USSRSUSUN810su+0
UgandaUGUGA800ug+3
UkraineUAUKR804ua+2
United Arab EmiratesAEARE784ae+4
United KingdomGBGBR826uk+0
AnguillaAIAIA660ai-4
Ascension Islandac+0
BermudaBMBMU060bm-4
British Indian Ocean Territoryio+6
British Virgin IslandsIOVGB092vg-4
Cayman IslandsKYCYM136ky-5
Falkland Islands (Malvinas)FKFLK238fk-4
GibraltarGIGIB292gi+1
GuernseyGGGGY831gg+0
Isle of ManIMIMN833im+0
JerseyJEJEY832je+0
MontserratMSMSR500ms-4
Pitcairn IslandPNPCN612pn-8
Saint HelenaSHSHN654sh+0
South Georgia and the South Sandwich Islandsgs-2
Turks and Caicos IslandsTCTCA796tc-5
United States of AmericaUSUSA840us-5
American SamoaASASM016as-11
GuamGUGUM316gu+10
Northern Mariana IslandsMPMNP580mp+10
Puerto RicoPRPRI630pr-4
US Minor Outlying Islandsum-11
United States Virgin IslandsVIVIR850vi-4
UruguayUYURY858uy-3
UzbekistanUZUZB860uz+5
VanuatuVUVUT548vu+11
Vatican City State (Holy See)VAVAT336va+1
VenezuelaVEVEN862ve-4.50
VietnamVNVNM704vn+7
YemenYEYEM887ye+3
YugoslaviaYUYUG890yu+0
ZambiaZMZMB894zm+2
ZimbabweZWZWE716zw+2

Article dated: 31st Dec 2008

Get the RSS feed