Home / Geographic / Worldwide Countries

Worldwide Countries

A complete country reference dataset intended for use in web and application development. It includes standardized country identifiers and codes, with a schema designed for predictable querying and reuse. This dataset is suitable for common use cases such as user profiles, address storage, localization, and reporting.

Rows 249

Last updated 2025-12-23 19:22:05

Download

View raw SQL

worldwide-countries.sql (12 KB)

Preview

id	name	iso_code_2	iso_code_3	iso_numeric	dialling_code
1	Afghanistan	AF	AFG	4	93
2	Albania	AL	ALB	8	355
3	Algeria	DZ	DZA	12	213
4	American Samoa	AS	ASM	16	1684
5	Andorra	AD	AND	20	376
6	Angola	AO	AGO	24	244
7	Anguilla	AI	AIA	660	1264
8	Antarctica	AQ	ATA	10	0
9	Antigua and Barbuda	AG	ATG	28	1268
10	Argentina	AR	ARG	32	54
11	Armenia	AM	ARM	51	374
12	Aruba	AW	ABW	533	297
13	Australia	AU	AUS	36	61
14	Austria	AT	AUT	40	43
15	Azerbaijan	AZ	AZE	31	994
16	Bahamas	BS	BHS	44	1242
17	Bahrain	BH	BHR	48	973
18	Bangladesh	BD	BGD	50	880
19	Barbados	BB	BRB	52	1246
20	Belarus	BY	BLR	112	375
21	Belgium	BE	BEL	56	32
22	Belize	BZ	BLZ	84	501
23	Benin	BJ	BEN	204	229
24	Bermuda	BM	BMU	60	1441
25	Bhutan	BT	BTN	64	975

Raw SQL

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `worldwide_countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `worldwide_countries` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `iso_code_2` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `iso_code_3` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `iso_numeric` smallint DEFAULT NULL,
  `dialling_code` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `worldwide_countries` WRITE;
/*!40000 ALTER TABLE `worldwide_countries` DISABLE KEYS */;
INSERT INTO `worldwide_countries` VALUES (1,'Afghanistan','AF','AFG',4,93),(2,'Albania','AL','ALB',8,355),(3,'Algeria','DZ','DZA',12,213),(4,'American Samoa','AS','ASM',16,1684),(5,'Andorra','AD','AND',20,376),(6,'Angola','AO','AGO',24,244),(7,'Anguilla','AI','AIA',660,1264),(8,'Antarctica','AQ','ATA',10,0),(9,'Antigua and Barbuda','AG','ATG',28,1268),(10,'Argentina','AR','ARG',32,54),(11,'Armenia','AM','ARM',51,374),(12,'Aruba','AW','ABW',533,297),(13,'Australia','AU','AUS',36,61),(14,'Austria','AT','AUT',40,43),(15,'Azerbaijan','AZ','AZE',31,994),(16,'Bahamas','BS','BHS',44,1242),(17,'Bahrain','BH','BHR',48,973),(18,'Bangladesh','BD','BGD',50,880),(19,'Barbados','BB','BRB',52,1246),(20,'Belarus','BY','BLR',112,375),(21,'Belgium','BE','BEL',56,32),(22,'Belize','BZ','BLZ',84,501),(23,'Benin','BJ','BEN',204,229),(24,'Bermuda','BM','BMU',60,1441),(25,'Bhutan','BT','BTN',64,975),(26,'Bolivia','BO','BOL',68,591),(27,'Bonaire, Sint Eustatius and Saba','BQ','BES',535,599),(28,'Bosnia and Herzegovina','BA','BIH',70,387),(29,'Botswana','BW','BWA',72,267),(30,'Bouvet Island','BV','BVT',74,0),(31,'Brazil','BR','BRA',76,55),(32,'British Indian Ocean Territory','IO','IOT',86,246),(33,'Brunei Darussalam','BN','BRN',96,673),(34,'Bulgaria','BG','BGR',100,359),(35,'Burkina Faso','BF','BFA',854,226),(36,'Burundi','BI','BDI',108,257),(37,'Cabo Verde','CV','CPV',132,238),(38,'Cambodia','KH','KHM',116,855),(39,'Cameroon','CM','CMR',120,237),(40,'Canada','CA','CAN',124,1),(41,'Cayman Islands','KY','CYM',136,1345),(42,'Central African Republic','CF','CAF',140,236),(43,'Chad','TD','TCD',148,235),(44,'Chile','CL','CHL',152,56),(45,'China','CN','CHN',156,86),(46,'Christmas Island','CX','CXR',162,61),(47,'Cocos (Keeling) Islands','CC','CCK',166,61),(48,'Colombia','CO','COL',170,57),(49,'Comoros','KM','COM',174,269),(50,'Congo','CG','COG',178,242),(51,'Congo, the Democratic Republic of the','CD','COD',180,243),(52,'Cook Islands','CK','COK',184,682),(53,'Costa Rica','CR','CRI',188,506),(54,'Côte d\'Ivoire','CI','CIV',384,225),(55,'Croatia','HR','HRV',191,385),(56,'Cuba','CU','CUB',192,53),(57,'Curaçao','CW','CUW',531,599),(58,'Cyprus','CY','CYP',196,357),(59,'Czechia','CZ','CZE',203,420),(60,'Denmark','DK','DNK',208,45),(61,'Djibouti','DJ','DJI',262,253),(62,'Dominica','DM','DMA',212,1767),(63,'Dominican Republic','DO','DOM',214,1809),(64,'Ecuador','EC','ECU',218,593),(65,'Egypt','EG','EGY',818,20),(66,'El Salvador','SV','SLV',222,503),(67,'Equatorial Guinea','GQ','GNQ',226,240),(68,'Eritrea','ER','ERI',232,291),(69,'Estonia','EE','EST',233,372),(70,'Eswatini','SZ','SWZ',748,268),(71,'Ethiopia','ET','ETH',231,251),(72,'Falkland Islands (Malvinas)','FK','FLK',238,500),(73,'Faroe Islands','FO','FRO',234,298),(74,'Fiji','FJ','FJI',242,679),(75,'Finland','FI','FIN',246,358),(76,'France','FR','FRA',250,33),(77,'French Guiana','GF','GUF',254,594),(78,'French Polynesia','PF','PYF',258,689),(79,'French Southern Territories','TF','ATF',260,0),(80,'Gabon','GA','GAB',266,241),(81,'Gambia','GM','GMB',270,220),(82,'Georgia','GE','GEO',268,995),(83,'Germany','DE','DEU',276,49),(84,'Ghana','GH','GHA',288,233),(85,'Gibraltar','GI','GIB',292,350),(86,'Greece','GR','GRC',300,30),(87,'Greenland','GL','GRL',304,299),(88,'Grenada','GD','GRD',308,1473),(89,'Guadeloupe','GP','GLP',312,590),(90,'Guam','GU','GUM',316,1671),(91,'Guatemala','GT','GTM',320,502),(92,'Guernsey','GG','GGY',831,44),(93,'Guinea','GN','GIN',324,224),(94,'Guinea-Bissau','GW','GNB',624,245),(95,'Guyana','GY','GUY',328,592),(96,'Haiti','HT','HTI',332,509),(97,'Heard Island and McDonald Islands','HM','HMD',334,0),(98,'Holy See','VA','VAT',336,379),(99,'Honduras','HN','HND',340,504),(100,'Hong Kong','HK','HKG',344,852),(101,'Hungary','HU','HUN',348,36),(102,'Iceland','IS','ISL',352,354),(103,'India','IN','IND',356,91),(104,'Indonesia','ID','IDN',360,62),(105,'Iran, Islamic Republic of','IR','IRN',364,98),(106,'Iraq','IQ','IRQ',368,964),(107,'Ireland','IE','IRL',372,353),(108,'Isle of Man','IM','IMN',833,44),(109,'Israel','IL','ISR',376,972),(110,'Italy','IT','ITA',380,39),(111,'Jamaica','JM','JAM',388,1876),(112,'Japan','JP','JPN',392,81),(113,'Jersey','JE','JEY',832,44),(114,'Jordan','JO','JOR',400,962),(115,'Kazakhstan','KZ','KAZ',398,7),(116,'Kenya','KE','KEN',404,254),(117,'Kiribati','KI','KIR',296,686),(118,'Korea, Democratic People\'s Republic of','KP','PRK',408,850),(119,'Korea, Republic of','KR','KOR',410,82),(120,'Kosovo','XK','XKX',NULL,383),(121,'Kuwait','KW','KWT',414,965),(122,'Kyrgyzstan','KG','KGZ',417,996),(123,'Lao People\'s Democratic Republic','LA','LAO',418,856),(124,'Latvia','LV','LVA',428,371),(125,'Lebanon','LB','LBN',422,961),(126,'Lesotho','LS','LSO',426,266),(127,'Liberia','LR','LBR',430,231),(128,'Libya','LY','LBY',434,218),(129,'Liechtenstein','LI','LIE',438,423),(130,'Lithuania','LT','LTU',440,370),(131,'Luxembourg','LU','LUX',442,352),(132,'Macao','MO','MAC',446,853),(133,'Madagascar','MG','MDG',450,261),(134,'Malawi','MW','MWI',454,265),(135,'Malaysia','MY','MYS',458,60),(136,'Maldives','MV','MDV',462,960),(137,'Mali','ML','MLI',466,223),(138,'Malta','MT','MLT',470,356),(139,'Marshall Islands','MH','MHL',584,692),(140,'Martinique','MQ','MTQ',474,596),(141,'Mauritania','MR','MRT',478,222),(142,'Mauritius','MU','MUS',480,230),(143,'Mayotte','YT','MYT',175,262),(144,'Mexico','MX','MEX',484,52),(145,'Micronesia, Federated States of','FM','FSM',583,691),(146,'Moldova, Republic of','MD','MDA',498,373),(147,'Monaco','MC','MCO',492,377),(148,'Mongolia','MN','MNG',496,976),(149,'Montenegro','ME','MNE',499,382),(150,'Montserrat','MS','MSR',500,1664),(151,'Morocco','MA','MAR',504,212),(152,'Mozambique','MZ','MOZ',508,258),(153,'Myanmar','MM','MMR',104,95),(154,'Namibia','NA','NAM',516,264),(155,'Nauru','NR','NRU',520,674),(156,'Nepal','NP','NPL',524,977),(157,'Netherlands','NL','NLD',528,31),(158,'New Caledonia','NC','NCL',540,687),(159,'New Zealand','NZ','NZL',554,64),(160,'Nicaragua','NI','NIC',558,505),(161,'Niger','NE','NER',562,227),(162,'Nigeria','NG','NGA',566,234),(163,'Niue','NU','NIU',570,683),(164,'Norfolk Island','NF','NFK',574,672),(165,'North Macedonia','MK','MKD',807,389),(166,'Northern Mariana Islands','MP','MNP',580,1670),(167,'Norway','NO','NOR',578,47),(168,'Oman','OM','OMN',512,968),(169,'Pakistan','PK','PAK',586,92),(170,'Palau','PW','PLW',585,680),(171,'Palestine, State of','PS','PSE',275,970),(172,'Panama','PA','PAN',591,507),(173,'Papua New Guinea','PG','PNG',598,675),(174,'Paraguay','PY','PRY',600,595),(175,'Peru','PE','PER',604,51),(176,'Philippines','PH','PHL',608,63),(177,'Pitcairn','PN','PCN',612,64),(178,'Poland','PL','POL',616,48),(179,'Portugal','PT','PRT',620,351),(180,'Puerto Rico','PR','PRI',630,1787),(181,'Qatar','QA','QAT',634,974),(182,'Réunion','RE','REU',638,262),(183,'Romania','RO','ROU',642,40),(184,'Russian Federation','RU','RUS',643,7),(185,'Rwanda','RW','RWA',646,250),(186,'Saint Barthélemy','BL','BLM',652,590),(187,'Saint Helena, Ascension and Tristan da Cunha','SH','SHN',654,290),(188,'Saint Kitts and Nevis','KN','KNA',659,1869),(189,'Saint Lucia','LC','LCA',662,1758),(190,'Saint Martin (French part)','MF','MAF',663,590),(191,'Saint Pierre and Miquelon','PM','SPM',666,508),(192,'Saint Vincent and the Grenadines','VC','VCT',670,1784),(193,'Samoa','WS','WSM',882,685),(194,'San Marino','SM','SMR',674,378),(195,'Sao Tome and Principe','ST','STP',678,239),(196,'Saudi Arabia','SA','SAU',682,966),(197,'Senegal','SN','SEN',686,221),(198,'Serbia','RS','SRB',688,381),(199,'Seychelles','SC','SYC',690,248),(200,'Sierra Leone','SL','SLE',694,232),(201,'Singapore','SG','SGP',702,65),(202,'Sint Maarten (Dutch part)','SX','SXM',534,1721),(203,'Slovakia','SK','SVK',703,421),(204,'Slovenia','SI','SVN',705,386),(205,'Solomon Islands','SB','SLB',90,677),(206,'Somalia','SO','SOM',706,252),(207,'South Africa','ZA','ZAF',710,27),(208,'South Georgia and the South Sandwich Islands','GS','SGS',239,500),(209,'South Sudan','SS','SSD',728,211),(210,'Spain','ES','ESP',724,34),(211,'Sri Lanka','LK','LKA',144,94),(212,'Sudan','SD','SDN',729,249),(213,'Suriname','SR','SUR',740,597),(214,'Svalbard and Jan Mayen','SJ','SJM',744,47),(215,'Sweden','SE','SWE',752,46),(216,'Switzerland','CH','CHE',756,41),(217,'Syrian Arab Republic','SY','SYR',760,963),(218,'Taiwan, Province of China','TW','TWN',158,886),(219,'Tajikistan','TJ','TJK',762,992),(220,'Tanzania, United Republic of','TZ','TZA',834,255),(221,'Thailand','TH','THA',764,66),(222,'Timor-Leste','TL','TLS',626,670),(223,'Togo','TG','TGO',768,228),(224,'Tokelau','TK','TKL',772,690),(225,'Tonga','TO','TON',776,676),(226,'Trinidad and Tobago','TT','TTO',780,1868),(227,'Tunisia','TN','TUN',788,216),(228,'Türkiye','TR','TUR',792,90),(229,'Turkmenistan','TM','TKM',795,993),(230,'Turks and Caicos Islands','TC','TCA',796,1649),(231,'Tuvalu','TV','TUV',798,688),(232,'Uganda','UG','UGA',800,256),(233,'Ukraine','UA','UKR',804,380),(234,'United Arab Emirates','AE','ARE',784,971),(235,'United Kingdom','GB','GBR',826,44),(236,'United States','US','USA',840,1),(237,'United States Minor Outlying Islands','UM','UMI',581,1),(238,'Uruguay','UY','URY',858,598),(239,'Uzbekistan','UZ','UZB',860,998),(240,'Vanuatu','VU','VUT',548,678),(241,'Venezuela','VE','VEN',862,58),(242,'Viet Nam','VN','VNM',704,84),(243,'Virgin Islands, British','VG','VGB',92,1284),(244,'Virgin Islands, U.S.','VI','VIR',850,1340),(245,'Wallis and Futuna','WF','WLF',876,681),(246,'Western Sahara','EH','ESH',732,212),(247,'Yemen','YE','YEM',887,967),(248,'Zambia','ZM','ZMB',894,260),(249,'Zimbabwe','ZW','ZWE',716,263);
/*!40000 ALTER TABLE `worldwide_countries` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Categories

Popular

Worldwide Countries

Download

Preview

Raw SQL