A SQL dump for Postgresql containing 217 countries, their COW (correlates of war) codes, and abbreviations. The data is taken from: http://www.correlatesofwar.org/datasets.htm - first link "COW Country Codes".

country_cow_abbreviation_dump

CREATE TABLE IF NOT EXISTS country(
	id SERIAL not null,
	cow_id integer not null,
	name varchar(255) not null,
	abbreviation varchar(5) not null,
	primary key(id, cow_id)
);

INSERT INTO country(cow_id, name, abbreviation) VALUES
(2,'United States of America','USA'),
(20,'Canada','CAN'),
(31,'Bahamas','BHM'),
(40,'Cuba','CUB'),
(41,'Haiti','HAI'),
(42,'Dominican Republic','DOM'),
(51,'Jamaica','JAM'),
(52,'Trinidad and Tobago','TRI'),
(53,'Barbados','BAR'),
(54,'Dominica','DMA'),
(55,'Grenada','GRN'),
(56,'St. Lucia','SLU'),
(57,'St. Vincent and the Grenadines','SVG'),
(58,'Antigua & Barbuda','AAB'),
(60,'St. Kitts and Nevis','SKN'),
(70,'Mexico','MEX'),
(80,'Belize','BLZ'),
(90,'Guatemala','GUA'),
(91,'Honduras','HON'),
(92,'El Salvador','SAL'),
(93,'Nicaragua','NIC'),
(94,'Costa Rica','COS'),
(95,'Panama','PAN'),
(100,'Colombia','COL'),
(101,'Venezuela','VEN'),
(110,'Guyana','GUY'),
(115,'Suriname','SUR'),
(130,'Ecuador','ECU'),
(135,'Peru','PER'),
(140,'Brazil','BRA'),
(145,'Bolivia','BOL'),
(150,'Paraguay','PAR'),
(155,'Chile','CHL'),
(160,'Argentina','ARG'),
(165,'Uruguay','URU'),
(200,'United Kingdom','UKG'),
(205,'Ireland','IRE'),
(210,'Netherlands','NTH'),
(211,'Belgium','BEL'),
(212,'Luxembourg','LUX'),
(220,'France','FRN'),
(221,'Monaco','MNC'),
(223,'Liechtenstein','LIE'),
(225,'Switzerland','SWZ'),
(230,'Spain','SPN'),
(232,'Andorra','AND'),
(235,'Portugal','POR'),
(240,'Hanover','HAN'),
(245,'Bavaria','BAV'),
(255,'Germany','GMY'),
(260,'German Federal Republic','GFR'),
(265,'German Democratic Republic','GDR'),
(267,'Baden','BAD'),
(269,'Saxony','SAX'),
(271,'Wuerttemburg','WRT'),
(273,'Hesse Electoral','HSE'),
(275,'Hesse Grand Ducal','HSG'),
(280,'Mecklenburg Schwerin','MEC'),
(290,'Poland','POL'),
(300,'Austria-Hungary','AUH'),
(305,'Austria','AUS'),
(310,'Hungary','HUN'),
(315,'Czechoslovakia','CZE'),
(316,'Czech Republic','CZR'),
(317,'Slovakia','SLO'),
(325,'Italy','ITA'),
(327,'Papal States','PAP'),
(329,'Two Sicilies','SIC'),
(331,'San Marino','SNM'),
(332,'Modena','MOD'),
(335,'Parma','PMA'),
(337,'Tuscany','TUS'),
(338,'Malta','MLT'),
(339,'Albania','ALB'),
(341,'Montenegro','MNG'),
(343,'Macedonia','MAC'),
(344,'Croatia','CRO'),
(345,'Yugoslavia','YUG'),
(346,'Bosnia and Herzegovina','BOS'),
(347,'Kosovo','KOS'),
(349,'Slovenia','SLV'),
(350,'Greece','GRC'),
(352,'Cyprus','CYP'),
(355,'Bulgaria','BUL'),
(359,'Moldova','MLD'),
(360,'Romania','ROM'),
(365,'Russia','RUS'),
(366,'Estonia','EST'),
(367,'Latvia','LAT'),
(368,'Lithuania','LIT'),
(369,'Ukraine','UKR'),
(370,'Belarus','BLR'),
(371,'Armenia','ARM'),
(372,'Georgia','GRG'),
(373,'Azerbaijan','AZE'),
(375,'Finland','FIN'),
(380,'Sweden','SWD'),
(385,'Norway','NOR'),
(390,'Denmark','DEN'),
(395,'Iceland','ICE'),
(402,'Cape Verde','CAP'),
(403,'Sao Tome and Principe','STP'),
(404,'Guinea-Bissau','GNB'),
(411,'Equatorial Guinea','EQG'),
(420,'Gambia','GAM'),
(432,'Mali','MLI'),
(433,'Senegal','SEN'),
(434,'Benin','BEN'),
(435,'Mauritania','MAA'),
(436,'Niger','NIR'),
(437,'Ivory Coast','CDI'),
(438,'Guinea','GUI'),
(439,'Burkina Faso','BFO'),
(450,'Liberia','LBR'),
(451,'Sierra Leone','SIE'),
(452,'Ghana','GHA'),
(461,'Togo','TOG'),
(471,'Cameroon','CAO'),
(475,'Nigeria','NIG'),
(481,'Gabon','GAB'),
(482,'Central African Republic','CEN'),
(483,'Chad','CHA'),
(484,'Congo','CON'),
(490,'Democratic Republic of the Congo','DRC'),
(500,'Uganda','UGA'),
(501,'Kenya','KEN'),
(510,'Tanzania','TAZ'),
(511,'Zanzibar','ZAN'),
(516,'Burundi','BUI'),
(517,'Rwanda','RWA'),
(520,'Somalia','SOM'),
(522,'Djibouti','DJI'),
(530,'Ethiopia','ETH'),
(531,'Eritrea','ERI'),
(540,'Angola','ANG'),
(541,'Mozambique','MZM'),
(551,'Zambia','ZAM'),
(552,'Zimbabwe','ZIM'),
(553,'Malawi','MAW'),
(560,'South Africa','SAF'),
(565,'Namibia','NAM'),
(570,'Lesotho','LES'),
(571,'Botswana','BOT'),
(572,'Swaziland','SWA'),
(580,'Madagascar','MAG'),
(581,'Comoros','COM'),
(590,'Mauritius','MAS'),
(591,'Seychelles','SEY'),
(600,'Morocco','MOR'),
(615,'Algeria','ALG'),
(616,'Tunisia','TUN'),
(620,'Libya','LIB'),
(625,'Sudan','SUD'),
(626,'South Sudan','SSD'),
(630,'Iran','IRN'),
(640,'Turkey','TUR'),
(645,'Iraq','IRQ'),
(651,'Egypt','EGY'),
(652,'Syria','SYR'),
(660,'Lebanon','LEB'),
(663,'Jordan','JOR'),
(666,'Israel','ISR'),
(670,'Saudi Arabia','SAU'),
(678,'Yemen Arab Republic','YAR'),
(679,'Yemen','YEM'),
(680,'Yemen People''s Republic','YPR'),
(690,'Kuwait','KUW'),
(692,'Bahrain','BAH'),
(694,'Qatar','QAT'),
(696,'United Arab Emirates','UAE'),
(698,'Oman','OMA'),
(700,'Afghanistan','AFG'),
(701,'Turkmenistan','TKM'),
(702,'Tajikistan','TAJ'),
(703,'Kyrgyzstan','KYR'),
(704,'Uzbekistan','UZB'),
(705,'Kazakhstan','KZK'),
(710,'China','CHN'),
(712,'Mongolia','MON'),
(713,'Taiwan','TAW'),
(730,'Korea','KOR'),
(731,'North Korea','PRK'),
(732,'South Korea','ROK'),
(740,'Japan','JPN'),
(750,'India','IND'),
(760,'Bhutan','BHU'),
(770,'Pakistan','PAK'),
(771,'Bangladesh','BNG'),
(775,'Myanmar','MYA'),
(780,'Sri Lanka','SRI'),
(781,'Maldives','MAD'),
(790,'Nepal','NEP'),
(800,'Thailand','THI'),
(811,'Cambodia','CAM'),
(812,'Laos','LAO'),
(816,'Vietnam','DRV'),
(817,'Republic of Vietnam','RVN'),
(820,'Malaysia','MAL'),
(830,'Singapore','SIN'),
(835,'Brunei','BRU'),
(840,'Philippines','PHI'),
(850,'Indonesia','INS'),
(860,'East Timor','ETM'),
(900,'Australia','AUL'),
(910,'Papua New Guinea','PNG'),
(920,'New Zealand','NEW'),
(935,'Vanuatu','VAN'),
(940,'Solomon Islands','SOL'),
(946,'Kiribati','KIR'),
(947,'Tuvalu','TUV'),
(950,'Fiji','FIJ'),
(955,'Tonga','TON'),
(970,'Nauru','NAU'),
(983,'Marshall Islands','MSI'),
(986,'Palau','PAL'),
(987,'Federated States of Micronesia','FSM'),
(990,'Samoa','WSM');