List of countries and dependent territories

31st Dec 2008

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

Country	ISO alpha-2	ISO alpha-3	UN number	Internet TLD	Timezone
Afghanistan	AF	AFG	004	af	+4.50
Albania	AL	ALB	008	al	+1
Algeria	DZ	DZA	012	dz	+1
Andorra	AD	AND	020	ad	+1
Angola	AO	AGO	024	ao	+1
Antigua and Barbuda	AG	ATG	028	ag	-4
Argentina	AR	ARG	032	ar	-3
Armenia	AM	ARM	051	am	+4
Australia	AU	AUS	036	au	+10
Christmas Island				cx	+7
Cocos (Keeling) Island				cc	+6.50
Heard and McDonald Islands				hm	+5
Norfolk Island	NF	NFK	574	nf	+11.50
Austria	AT	AUT	040	at	+1
Azerbaijan	AZ	AZE	031	az	+4
Bahamas	BS	BHS	044	bs	-5
Bahrain	BH	BHR	048	bh	+3
Bangladesh	BD	BGD	050	bd	+6
Barbados	BB	BRB	052	bb	-4
Belarus	BY	BLR	112	by	+2
Belgium	BE	BEL	056	be	+1
Belize	BZ	BLZ	084	bz	-6
Benin	BJ	BEN	204	bj	+1
Bhutan	BT	BTN	064	bt	+6
Bolivia	BO	BOL	068	bo	-4
Bosnia and Herzegovina	BA	BIH	070	ba	+1
Botswana	BW	BWA	072	bw	+2
Brazil	BR	BRA	076	br	-3
Brunei Darussalam	BN	BRN	096	bn	+8
Bulgaria	BG	BGR	100	bg	+2
Burkina Faso	BF	BFA	854	bf	+0
Burundi	BI	BDI	108	bi	+2
Cambodia	KH	KHM	116	kh	+7
Cameroon	CM	CMR	120	cm	+1
Canada	CA	CAN	124	ca	-5
Cape Verde	CV	CPV	132	cv	-1
Central African Republic	CF	CAF	140	cf	+1
Chad	TD	TCD	148	td	+1
Chile	CL	CHL	152	cl	-4
China	CN	CHN	156	cn	+8
Hong Kong	HK	HKG	344	hk	+8
Macau	MO	MAC	446	mo	+8
Colombia	CO	COL	170	co	-5
Comoros	KM	COM	174	km	+3
Congo, Democratic Republic of	CD	COD	180	cd	+1
Congo, Republic of	CG	COG	178	cg	+1
Costa Rica	CR	CRI	188	cr	-6
Cote d'Ivoire	CI	CIV	384	ci	+0
Croatia	HR	HRV	191	hr	+1
Cuba	CU	CUB	192	cu	-5
Cyprus	CY	CYP	196	cy	+2
Czech Republic	CZ	CZE	203	cz	+1
Denmark	DK	DNK	208	dk	+1
Faroe Islands	FO	FRO	234	fo	+0
Greenland	GL	GRL	304	gl	-3
Djibouti	DJ	DJI	262	dj	+3
Dominica	DM	DMA	212	dm	-4
Dominican Republic	DO	DOM	214	do	-4
Ecuador	EC	ECU	218	ec	-5
Egypt	EG	EGY	818	eg	+2
El Salvador	SV	SLV	222	sv	-6
Equatorial Guinea	GQ	GNQ	226	gq	+1
Eritrea	ER	ERI	232	er	+3
Estonia	EE	EST	233	ee	+2
Ethiopia	ET	ETH	230	et	+3
Fiji	FJ	FJI	242	fj	+12
Finland	FI	FIN	246	fi	+2
Aland	AX	ALA	248		+2
France	FR	FRA	250	fr	+1
French Guiana	GF	GUF	254	gf	-3
French Polynesia	PF	PYF	258	pf	-10
French Southern Territories				tf	+5
Guadeloupe	GP	GLP	312	gp	-4
Martinique	MQ	MTQ	474	mq	-4
Mayotte	YT	MYT	175	yt	+3
New Caledonia	NC	NCL	540	nc	+11
Reunion	RE	REU	638	re	+4
Saint Pierre and Miquelon	PM	SPM	666	pm	+0
Wallis and Futuna Islands	WF	WLF	876	wf	+12
Gabon	GA	GAB	266	ga	+1
Gambia	GM	GMB	270	gm	+0
Georgia	GE	GEO	268	ge	+4
Germany	DE	DEU	276	de	+1
Ghana	GH	GHA	288	gh	+0
Greece	GR	GRC	300	gr	+2
Grenada	GD	GRD	308	gd	-4
Guatemala	GT	GTM	320	gt	-6
Guinea	GN	GIN	324	gn	+0
Guinea-Bissau	GW	GNB	624	gw	+0
Guyana	GY	GUY	328	gy	-4
Haiti	HT	HTI	332	ht	-5
Honduras	HN	HND	340	hn	-6
Hungary	HU	HUN	348	hu	+1
Iceland	IS	ISL	352	is	+0
India	IN	IND	356	in	+5.50
Indonesia	ID	IDN	360	id	+7
Iran	IR	IRN	364	ir	+3.50
Iraq	IQ	IRQ	368	iq	+3
Ireland	IE	IRL	372	ie	+0
Israel	IL	ISR	376	il	+2
Italy	IT	ITA	380	it	+1
Jamaica	JM	JAM	388	jm	-5
Japan	JP	JPN	392	jp	+9
Jordan	JO	JOR	400	jo	+0
Kazakhstan	KZ	KAZ	398	kz	+6
Kenya	KE	KEN	404	ke	+3
Kiribati	KI	KIR	296	ki	+12
Korea, North	KP	PRK	408	kp	+9
Korea, South	KR	KOR	410	kr	+9
Kosovo					+1
Kuwait	KW	KWT	414	kw	+3
Kyrgyzstan	KG	KGZ	417	kg	+6
Laos	LA	LAO	418	la	+7
Latvia	LV	LVA	428	lv	+2
Lebanon	LB	LBN	422	lb	+0
Lesotho	LS	LSO	426	ls	+2
Liberia	LR	LBR	430	lr	+0
Libya	LY	LBY	434	ly	+2
Liechtenstein	LI	LIE	438	li	+1
Lithuania	LT	LTU	440	lt	+2
Luxembourg	LU	LUX	442	lu	+1
Macedonia	MK	MKD	807	mk	+1
Madagascar	MG	MDG	450	mg	+3
Malawi	MW	MWI	454	mw	+2
Malaysia	MY	MYS	458	my	+8
Maldives	MV	MDV	462	mv	+5
Mali	ML	MLI	466	ml	+0
Malta	MT	MLT	470	mt	+1
Marshall Islands	MH	MHL	584	mh	+12
Mauritania	MR	MRT	478	mr	+0
Mauritius	MU	MUS	480	mu	+4
Mexico	MX	MEX	484	mx	-6
Micronesia	FM	FSM	583	fm	+10
Moldova	MD	MDA	498	md	+2
Monaco	MC	MCO	492	mc	+1
Mongolia	MN	MNG	496	mn	+8
Montenegro				me	+1
Morocco	MA	MAR	504	ma	+0
Western Sahara	EH	ESH	732	eh	+0
Mozambique	MZ	MOZ	508	mz	+2
Myanmar	MM	MMR	104	mm	+6.50
Namibia	NA	NAM	516	na	+2
Nauru	NR	NRU	520	nr	+12
Nepal	NP	NPL	524	np	+5.75
Netherlands	NL	NLD	528	nl	+1
Aruba	AW	ABW	533	aw	-4
Netherlands Antilles	AN	ANT	530	an	-4
New Zealand	NZ	NZL	554	nz	+12
Cook Islands	CK	COK	184	ck	-10
Niue	NU	NIU	570	nu	-11
Tokelau				tk	-10
Nicaragua	NI	NIC	558	ni	-6
Niger	NE	NER	562	ne	+1
Nigeria	NG	NGA	566	ng	+1
Norway	NO	NOR	578	no	+1
Bouvet Island				bv	+1
Svalbard and Jan Mayen Islands	SJ	SJM	744	sj	+1
Oman	OM	OMN	512	om	+4
Pakistan	PK	PAK	586	pk	+5
Palau	PW	PLW	585	pw	+9
Palestinian Territory, Occupied	PS	PSE	275	ps	+0
Panama	PA	PAN	591	pa	-5
Papua New Guinea	PG	PNG	598	pg	+10
Paraguay	PY	PRY	600	py	-4
Peru	PE	PER	604	pe	-5
Philippines	PH	PHL	608	ph	+8
Poland	PL	POL	616	pl	+1
Portugal	PT	PRT	620	pt	+0
Qatar	QA	QAT	634	qa	+3
Romania	RO	ROU	642	ro	+2
Russia	RU	RUS	643	ru	+3
Rwanda	RW	RWA	646	rw	+2
Saint Kitts and Nevis	KN	KNA	659	kn	-4
Saint Lucia	LC	LCA	662	lc	-4
Saint Vincent and the Grenadines	VC	VCT	670	vc	-4
Samoa	WS	WSM	882	ws	-11
San Marino	SM	SMR	674	sm	+1
Sao Tome and Principe	ST	STP	678	st	+0
Saudi Arabia	SA	SAU	682	sa	+3
Senegal	SN	SEN	686	sn	+0
Serbia	CS	SCG	891	rs	+1
Seychelles	SC	SYC	690	sc	+4
Sierra Leone	SL	SLE	694	sl	+0
Singapore	SG	SGP	702	sg	+8
Slovakia	SK	SVK	703	sk	+1
Slovenia	SI	SVN	705	si	+1
Solomon Islands	SB	SLB	090	sb	+11
Somalia	SO	SOM	706	so	+3
South Africa	ZA	ZAF	710	za	+2
Spain	ES	ESP	724	es	+1
Sri Lanka	LK	LKA	144	lk	+5.50
Sudan	SD	SDN	736	sd	+3
Suriname	SR	SUR	740	sr	+0
Swaziland	SZ	SWZ	748	sz	+2
Sweden	SE	SWE	752	se	+1
Switzerland	CH	CHE	756	ch	+1
Syria	SY	SYR	760	sy	+0
Taiwan	TW	TWN	158	tw	+8
Tajikistan	TJ	TJK	762	tj	+5
Tanzania	TZ	TZA	834	tz	+3
Thailand	TH	THA	764	th	+7
Timor-Leste	TL	TLS	626	tp	+9
Togo	TG	TGO	768	tg	+0
Tonga	TO	TON	776	to	+13
Trinidad and Tobago	TT	TTO	780	tt	-4
Tunisia	TN	TUN	788	tn	+1
Turkey	TR	TUR	792	tr	+2
Turkmenistan	TM	TKM	795	tm	+5
Tuvalu	TV	TUV	798	tv	+12
USSR	SU	SUN	810	su	+0
Uganda	UG	UGA	800	ug	+3
Ukraine	UA	UKR	804	ua	+2
United Arab Emirates	AE	ARE	784	ae	+4
United Kingdom	GB	GBR	826	uk	+0
Anguilla	AI	AIA	660	ai	-4
Ascension Island				ac	+0
Bermuda	BM	BMU	060	bm	-4
British Indian Ocean Territory				io	+6
British Virgin Islands	IO	VGB	092	vg	-4
Cayman Islands	KY	CYM	136	ky	-5
Falkland Islands (Malvinas)	FK	FLK	238	fk	-4
Gibraltar	GI	GIB	292	gi	+1
Guernsey	GG	GGY	831	gg	+0
Isle of Man	IM	IMN	833	im	+0
Jersey	JE	JEY	832	je	+0
Montserrat	MS	MSR	500	ms	-4
Pitcairn Island	PN	PCN	612	pn	-8
Saint Helena	SH	SHN	654	sh	+0
South Georgia and the South Sandwich Islands				gs	-2
Turks and Caicos Islands	TC	TCA	796	tc	-5
United States of America	US	USA	840	us	-5
American Samoa	AS	ASM	016	as	-11
Guam	GU	GUM	316	gu	+10
Northern Mariana Islands	MP	MNP	580	mp	+10
Puerto Rico	PR	PRI	630	pr	-4
US Minor Outlying Islands				um	-11
United States Virgin Islands	VI	VIR	850	vi	-4
Uruguay	UY	URY	858	uy	-3
Uzbekistan	UZ	UZB	860	uz	+5
Vanuatu	VU	VUT	548	vu	+11
Vatican City State (Holy See)	VA	VAT	336	va	+1
Venezuela	VE	VEN	862	ve	-4.50
Vietnam	VN	VNM	704	vn	+7
Yemen	YE	YEM	887	ye	+3
Yugoslavia	YU	YUG	890	yu	+0
Zambia	ZM	ZMB	894	zm	+2
Zimbabwe	ZW	ZWE	716	zw	+2