forked from regican/postgres-iso3166
-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert into countries.sql
4 lines (3 loc) · 13.8 KB
/
insert into countries.sql
1
2
3
4
-- Data for the table countries --
insert into countries (country_id,country_name,country_code_char2,country_code_char3,un_region,un_subregion) values
(1,'Georgia','GE','GEO','Asia','Western Asia'),(2,'Afghanistan','AF','AFG','Asia','Southern Asia'),(3,'Åland Islands','AX','ALA','Europe','Northern Europe'),(4,'Albania','AL','ALB','Europe','Southern Europe'),(5,'Algeria','DZ','DZA','Africa','Northern Africa'),(6,'American Samoa','AS','ASM','Oceania','Polynesia'),(7,'Andorra','AD','AND','Europe','Southern Europe'),(8,'Angola','AO','AGO','Africa','Middle Africa'),(9,'Anguilla','AI','AIA','Americas','Caribbean'),(10,'Antarctica','AQ','ATA','',''),(11,'Antigua and Barbuda','AG','ATG','Americas','Caribbean'),(12,'Argentina','AR','ARG','Americas','South America'),(13,'Armenia','AM','ARM','Asia','Western Asia'),(14,'Aruba','AW','ABW','Americas','Caribbean'),(15,'Australia','AU','AUS','Oceania','Australia and New Zealand'),(16,'Austria','AT','AUT','Europe','Western Europe'),(17,'Azerbaijan','AZ','AZE','Asia','Western Asia'),(18,'Bahamas','BS','BHS','Americas','Caribbean'),(21,'Bahrain','BH','BHR','Asia','Western Asia'),(22,'Bangladesh','BD','BGD','Asia','Southern Asia'),(23,'Barbados','BB','BRB','Americas','Caribbean'),(24,'Belarus','BY','BLR','Europe','Eastern Europe'),(25,'Belgium','BE','BEL','Europe','Western Europe'),(26,'Belize','BZ','BLZ','Americas','Central America'),(27,'Benin','BJ','BEN','Africa','Western Africa'),(28,'Bermuda','BM','BMU','Americas','Northern America'),(29,'Bhutan','BT','BTN','Asia','Southern Asia'),(30,'Bolivia, Plurinational State Of','BO','BOL','Americas','South America'),(31,'Bosnia and Herzegovina','BA','BIH','Europe','Southern Europe'),(32,'Botswana','BW','BWA','Africa','Southern Africa'),(33,'Bouvet Island','BV','BVT','',''),(34,'Brazil','BR','BRA','Americas','South America'),(35,'British Indian Ocean Territory','IO','IOT','Africa','Eastern Africa'),(36,'Brunei Darussalam','BN','BRN','Asia','South-Eastern Asia'),(37,'Bulgaria','BG','BGR','Europe','Eastern Europe'),(38,'Burkina Faso','BF','BFA','Africa','Western Africa'),(39,'Burundi','BI','BDI','Africa','Eastern Africa'),(40,'Cambodia','KH','KHM','Asia','South-Eastern Asia'),(41,'Cameroon','CM','CMR','Africa','Middle Africa'),(42,'Canada','CA','CAN','Americas','Northern America'),(43,'Cape Verde','CV','CPV','Africa','Western Africa'),(44,'Cayman Islands','KY','CYM','Americas','Caribbean'),(45,'Central African Republic','CF','CAF','Africa','Middle Africa'),(46,'Chad','TD','TCD','Africa','Middle Africa'),(47,'Chile','CL','CHL','Americas','South America'),(48,'China','CN','CHN','Asia','Eastern Asia'),(49,'Christmas Island','CX','CXR','Oceania','Australia and New Zealand'),(50,'Cocos (Keeling) Islands','CC','CCK','Oceania','Australia and New Zealand'),(51,'Colombia','CO','COL','Americas','South America'),(52,'Comoros','KM','COM','Africa','Eastern Africa'),(53,'Congo','CG','COG','Africa','Middle Africa'),(54,'Congo, The Democratic Republic Of The','CD','COD','Africa','Middle Africa'),(55,'Cook Islands','CK','COK','Oceania','Polynesia'),(56,'Costa Rica','CR','CRI','Americas','Central America'),(57,'Côte D''Ivoire','CI','CIV','Africa','Western Africa'),(58,'Croatia','HR','HRV','Europe','Southern Europe'),(59,'Cuba','CU','CUB','Americas','Caribbean'),(60,'Cyprus','CY','CYP','Asia','Western Asia'),(61,'Czech Republic','CZ','CZE','Europe','Eastern Europe'),(62,'Denmark','DK','DNK','Europe','Northern Europe'),(63,'Djibouti','DJ','DJI','Africa','Eastern Africa'),(64,'Dominica','DM','DMA','Americas','Caribbean'),(65,'Dominican Republic','DO','DOM','Americas','Caribbean'),(66,'Ecuador','EC','ECU','Americas','South America'),(67,'Egypt','EG','EGY','Africa','Northern Africa'),(68,'El Salvador','SV','SLV','Americas','Central America'),(69,'Equatorial Guinea','GQ','GNQ','Africa','Middle Africa'),(70,'Eritrea','ER','ERI','Africa','Eastern Africa'),(71,'Estonia','EE','EST','Europe','Northern Europe'),(73,'Ethiopia','ET','ETH','Africa','Eastern Africa'),(74,'Falkland Islands (Malvinas)','FK','FLK','Americas','South America'),(75,'Faroe Islands','FO','FRO','Europe','Northern Europe'),(76,'Fiji','FJ','FJI','Oceania','Melanesia'),(77,'Finland','FI','FIN','Europe','Northern Europe'),(78,'France','FR','FRA','Europe','Western Europe'),(80,'French Guiana','GF','GUF','Americas','South America'),(81,'French Polynesia','PF','PYF','Oceania','Polynesia'),(82,'French Southern Territories','TF','ATF','',''),(83,'Gabon','GA','GAB','Africa','Middle Africa'),(84,'Gambia','GM','GMB','Africa','Western Africa'),(85,'Germany','DE','DEU','Europe','Western Europe'),(86,'Ghana','GH','GHA','Africa','Western Africa'),(87,'Gibraltar','GI','GIB','Europe','Southern Europe'),(88,'Greece','GR','GRC','Europe','Southern Europe'),(89,'Greenland','GL','GRL','Americas','Northern America'),(90,'Grenada','GD','GRD','Americas','Caribbean'),(91,'Guadeloupe','GP','GLP','Americas','Caribbean'),(92,'Guam','GU','GUM','Oceania','Micronesia'),(93,'Guatemala','GT','GTM','Americas','Central America'),(94,'Guernsey','GG','GGY','Europe','Northern Europe'),(95,'Guinea','GN','GIN','Africa','Western Africa'),(96,'Guinea-Bissau','GW','GNB','Africa','Western Africa'),(97,'Guyana','GY','GUY','Americas','South America'),(98,'Haiti','HT','HTI','Americas','Caribbean'),(99,'Heard and McDonald Islands','HM','HMD','',''),(100,'Holy See (Vatican City State)','VA','VAT','Europe','Southern Europe'),(101,'Honduras','HN','HND','Americas','Central America'),(102,'Hong Kong','HK','HKG','Asia','Eastern Asia'),(103,'Hungary','HU','HUN','Europe','Eastern Europe'),(104,'Iceland','IS','ISL','Europe','Northern Europe'),(105,'India','IN','IND','Asia','Southern Asia'),(106,'Indonesia','ID','IDN','Asia','South-Eastern Asia'),(107,'Iran, Islamic Republic Of','IR','IRN','Asia','Southern Asia'),(108,'Iraq','IQ','IRQ','Asia','Western Asia'),(109,'Ireland','IE','IRL','Europe','Northern Europe'),(110,'Isle of Man','IM','IMN','Europe','Northern Europe'),(111,'Israel','IL','ISR','Asia','Western Asia'),(112,'Italy','IT','ITA','Europe','Southern Europe'),(113,'Jamaica','JM','JAM','Americas','Caribbean'),(114,'Japan','JP','JPN','Asia','Eastern Asia'),(115,'Jersey','JE','JEY','Europe','Northern Europe'),(116,'Jordan','JO','JOR','Asia','Western Asia'),(117,'Kazakhstan','KZ','KAZ','Asia','Central Asia'),(118,'Kenya','KE','KEN','Africa','Eastern Africa'),(119,'Kiribati','KI','KIR','Oceania','Micronesia'),(120,'Korea, Republic of','KR','KOR','Asia','Eastern Asia'),(121,'Korea, Democratic People''s Republic Of','KP','PRK','Asia','Eastern Asia'),(122,'Kuwait','KW','KWT','Asia','Western Asia'),(123,'Kyrgyzstan','KG','KGZ','Asia','Central Asia'),(124,'Lao People''s Democratic Republic','LA','LAO','Asia','South-Eastern Asia'),(125,'Latvia','LV','LVA','Europe','Northern Europe'),(126,'Lebanon','LB','LBN','Asia','Western Asia'),(127,'Lesotho','LS','LSO','Africa','Southern Africa'),(128,'Liberia','LR','LBR','Africa','Western Africa'),(129,'Libyan Arab Jamahiriya','LY','LBY','Africa','Northern Africa'),(130,'Liechtenstein','LI','LIE','Europe','Western Europe'),(131,'Lithuania','LT','LTU','Europe','Northern Europe'),(132,'Luxembourg','LU','LUX','Europe','Western Europe'),(133,'Macao','MO','MAC','Asia','Eastern Asia'),(134,'Macedonia, the Former Yugoslav Republic Of','MK','MKD','Europe','Southern Europe'),(135,'Madagascar','MG','MDG','Africa','Eastern Africa'),(136,'Malawi','MW','MWI','Africa','Eastern Africa'),(137,'Malaysia','MY','MYS','Asia','South-Eastern Asia'),(138,'Maldives','MV','MDV','Asia','Southern Asia'),(139,'Mali','ML','MLI','Africa','Western Africa'),(140,'Malta','MT','MLT','Europe','Southern Europe'),(141,'Marshall Islands','MH','MHL','Oceania','Micronesia'),(142,'Martinique','MQ','MTQ','Americas','Caribbean'),(143,'Mauritania','MR','MRT','Africa','Western Africa'),(144,'Mauritius','MU','MUS','Africa','Eastern Africa'),(145,'Mayotte','YT','MYT','Africa','Eastern Africa'),(146,'Mexico','MX','MEX','Americas','Central America'),(147,'Micronesia, Federated States Of','FM','FSM','Oceania','Micronesia'),(148,'Moldova, Republic of','MD','MDA','Europe','Eastern Europe'),(149,'Monaco','MC','MCO','Europe','Western Europe'),(150,'Mongolia','MN','MNG','Asia','Eastern Asia'),(151,'Montenegro','ME','MNE','Europe','Southern Europe'),(152,'Montserrat','MS','MSR','Americas','Caribbean'),(153,'Morocco','MA','MAR','Africa','Northern Africa'),(154,'Mozambique','MZ','MOZ','Africa','Eastern Africa'),(155,'Myanmar','MM','MMR','Asia','South-Eastern Asia'),(156,'Namibia','NA','NAM','Africa','Southern Africa'),(157,'Nauru','NR','NRU','Oceania','Micronesia'),(158,'Nepal','NP','NPL','Asia','Southern Asia'),(159,'Netherlands','NL','NLD','Europe','Western Europe'),(160,'Netherlands Antilles','AN','ANT','Americas','Caribbean'),(161,'New Caledonia','NC','NCL','Oceania','Melanesia'),(162,'New Zealand','NZ','NZL','Oceania','Australia and New Zealand'),(163,'Nicaragua','NI','NIC','Americas','Central America'),(164,'Niger','NE','NER','Africa','Western Africa'),(165,'Nigeria','NG','NGA','Africa','Western Africa'),(166,'Niue','NU','NIU','Oceania','Polynesia'),(167,'Norfolk Island','NF','NFK','Oceania','Australia and New Zealand'),(168,'Northern Mariana Islands','MP','MNP','Oceania','Micronesia'),(169,'Norway','NO','NOR','Europe','Northern Europe'),(170,'Oman','OM','OMN','Asia','Western Asia'),(171,'Pakistan','PK','PAK','Asia','Southern Asia'),(172,'Palau','PW','PLW','Oceania','Micronesia'),(173,'Palestinian Territory, Occupied','PS','PSE','Asia','Western Asia'),(175,'Panama','PA','PAN','Americas','Central America'),(176,'Papua New Guinea','PG','PNG','Oceania','Melanesia'),(177,'Paraguay','PY','PRY','Americas','South America'),(178,'Peru','PE','PER','Americas','South America'),(180,'Philippines','PH','PHL','Asia','South-Eastern Asia'),(181,'Saint Pierre And Miquelon','PM','SPM','Americas','Northern America'),(182,'Pitcairn','PN','PCN','Oceania','Polynesia'),(183,'Poland','PL','POL','Europe','Eastern Europe'),(184,'Portugal','PT','PRT','Europe','Southern Europe'),(185,'Puerto Rico','PR','PRI','Americas','Caribbean'),(186,'Qatar','QA','QAT','Asia','Western Asia'),(187,'Réunion','RE','REU','Africa','Eastern Africa'),(189,'Romania','RO','ROU','Europe','Eastern Europe'),(190,'Russian Federation','RU','RUS','Europe','Eastern Europe'),(191,'Rwanda','RW','RWA','Africa','Eastern Africa'),(192,'Saint Helena, Ascension and Tristan Da Cunha','SH','SHN','Africa','Western Africa'),(193,'Saint Kitts And Nevis','KN','KNA','Americas','Caribbean'),(194,'Saint Lucia','LC','LCA','Americas','Caribbean'),(195,'Saint Vincent And The Grenedines','VC','VCT','Americas','Caribbean'),(196,'Samoa','WS','WSM','Oceania','Polynesia'),(197,'San Marino','SM','SMR','Europe','Southern Europe'),(198,'Sao Tome and Principe','ST','STP','Africa','Middle Africa'),(199,'Saudi Arabia','SA','SAU','Asia','Western Asia'),(200,'Senegal','SN','SEN','Africa','Western Africa'),(201,'Serbia','RS','SRB','Europe','Southern Europe'),(202,'Seychelles','SC','SYC','Africa','Eastern Africa'),(203,'Sierra Leone','SL','SLE','Africa','Western Africa'),(205,'Singapore','SG','SGP','Asia','South-Eastern Asia'),(206,'Slovakia','SK','SVK','Europe','Eastern Europe'),(207,'Slovenia','SI','SVN','Europe','Southern Europe'),(208,'Solomon Islands','SB','SLB','Oceania','Melanesia'),(209,'Somalia','SO','SOM','Africa','Eastern Africa'),(210,'South Africa','ZA','ZAF','Africa','Southern Africa'),(211,'South Georgia and the South Sandwich Islands','GS','SGS','Americas','South America'),(212,'Spain','ES','ESP','Europe','Southern Europe'),(213,'Sri Lanka','LK','LKA','Asia','Southern Asia'),(214,'Sudan','SD','SDN','Africa','Northern Africa'),(215,'Suriname','SR','SUR','Americas','South America'),(216,'Svalbard And Jan Mayen','SJ','SJM','Europe','Northern Europe'),(217,'Swaziland','SZ','SWZ','Africa','Southern Africa'),(218,'Sweden','SE','SWE','Europe','Northern Europe'),(219,'Switzerland','CH','CHE','Europe','Western Europe'),(220,'Syrian Arab Republic','SY','SYR','Asia','Western Asia'),(221,'Taiwan, Province Of China','TW','TWN','Asia','Eastern Asia'),(222,'Tajikistan','TJ','TJK','Asia','Central Asia'),(223,'Tanzania, United Republic of','TZ','TZA','Africa','Eastern Africa'),(224,'Thailand','TH','THA','Asia','South-Eastern Asia'),(226,'Timor-Leste','TL','TLS','Asia','South-Eastern Asia'),(227,'Togo','TG','TGO','Africa','Western Africa'),(228,'Tokelau','TK','TKL','Oceania','Polynesia'),(229,'Tonga','TO','TON','Oceania','Polynesia'),(230,'Trinidad and Tobago','TT','TTO','Americas','Caribbean'),(231,'Tunisia','TN','TUN','Africa','Northern Africa'),(232,'Turkey','TR','TUR','Asia','Western Asia'),(233,'Turkmenistan','TM','TKM','Asia','Central Asia'),(234,'Turks and Caicos Islands','TC','TCA','Americas','Caribbean'),(235,'Tuvalu','TV','TUV','Oceania','Polynesia'),(236,'Uganda','UG','UGA','Africa','Eastern Africa'),(237,'Ukraine','UA','UKR','Europe','Eastern Europe'),(238,'United Arab Emirates','AE','ARE','Asia','Western Asia'),(239,'United Kingdom','GB','GBR','Europe','Northern Europe'),(240,'United States','US','USA','Americas','Northern America'),(241,'United States Minor Outlying Islands','UM','UMI','Americas','Northern America'),(242,'Uruguay','UY','URY','Americas','South America'),(243,'Uzbekistan','UZ','UZB','Asia','Central Asia'),(244,'Vanuatu','VU','VUT','Oceania','Melanesia'),(245,'Venezuela, Bolivarian Republic of','VE','VEN','Americas','South America'),(247,'Viet Nam','VN','VNM','Asia','South-Eastern Asia'),(248,'Virgin Islands, British','VG','VGB','Americas','Caribbean'),(249,'Virgin Islands, U.S.','VI','VIR','Americas','Caribbean'),(250,'Wallis and Futuna','WF','WLF','Oceania','Polynesia'),(251,'Western Sahara','EH','ESH','Africa','Northern Africa'),(252,'Yemen','YE','YEM','Asia','Western Asia'),(255,'Zambia','ZM','ZMB','Africa','Eastern Africa'),(256,'Zimbabwe','ZW','ZWE','Africa','Eastern Africa'),(300,'Saint Barthélemy','BL','BLM','Americas','Caribbean'),(301,'Saint Martin','MF','MAF','Americas','Caribbean'),(700,'Bonaire, Sint Eustatius and Saba','BQ','BES','',''),(701,'Curaçao','CW','CUW','',''),(702,'Sint Maarten (Dutch part)','SX','SXM','',''),(703,'South Sudan','SS','SSD','','');