#
# DUMP FILE
#
# Database is ported from MS Access
#------------------------------------------------------------------
# Created using "MS Access to MySQL" form http://www.bullzip.com
# Program Version 5.4.274
#
# OPTIONS:
#   sourcefilename=Z:\RABIO\corona\corona.accdb
#   sourceusername=
#   sourcepassword=
#   sourcesystemdatabase=
#   destinationdatabase=stggr922280_ccms
#   storageengine=InnoDB
#   dropdatabase=0
#   createtables=1
#   unicode=1
#   autocommit=0
#   transferdefaultvalues=0
#   transferindexes=1
#   transferautonumbers=0
#   transferrecords=1
#   columnlist=0
#   tableprefix=
#   negativeboolean=0
#   ignorelargeblobs=0
#   memotype=LONGTEXT
#   datetimetype=DATETIME
#

CREATE DATABASE IF NOT EXISTS `stggr922280_ccms`;
USE `stggr922280_ccms`;

#
# Table structure for table 'ain_corona_countries'
#

DROP TABLE IF EXISTS `ain_corona_countries`;

CREATE TABLE `ain_corona_countries` (
  `Continent_Name` VARCHAR(255), 
  `Continent_Code` VARCHAR(255), 
  `Country_Name` VARCHAR(255), 
  `Two_Letter_Country_Code` VARCHAR(255), 
  `Three_Letter_Country_Code` VARCHAR(255), 
  `Country_Number` DOUBLE NULL, 
  INDEX (`Continent_Code`), 
  INDEX (`Three_Letter_Country_Code`), 
  INDEX (`Two_Letter_Country_Code`)
) ENGINE=innodb DEFAULT CHARSET=utf8;

SET autocommit=0;

#
# Dumping data for table 'ain_corona_countries'
#

INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Afghanistan, Islamic Republic of', 'AF', 'AFG', 4);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Albania, Republic of', 'AL', 'ALB', 8);
INSERT INTO `ain_corona_countries` VALUES ('Antarctica', 'AN', 'Antarctica (the territory South of 60 deg S)', 'AQ', 'ATA', 10);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Algeria, People\'s Democratic Republic of', 'DZ', 'DZA', 12);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'American Samoa', 'AS', 'ASM', 16);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Andorra, Principality of', 'AD', 'AND', 20);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Angola, Republic of', 'AO', 'AGO', 24);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Antigua and Barbuda', 'AG', 'ATG', 28);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Azerbaijan, Republic of', 'AZ', 'AZE', 31);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Azerbaijan, Republic of', 'AZ', 'AZE', 31);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Argentina, Argentine Republic', 'AR', 'ARG', 32);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Australia, Commonwealth of', 'AU', 'AUS', 36);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Austria, Republic of', 'AT', 'AUT', 40);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Bahamas, Commonwealth of the', 'BS', 'BHS', 44);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Bahrain, Kingdom of', 'BH', 'BHR', 48);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Bangladesh, People\'s Republic of', 'BD', 'BGD', 50);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Armenia, Republic of', 'AM', 'ARM', 51);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Armenia, Republic of', 'AM', 'ARM', 51);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Barbados', 'BB', 'BRB', 52);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Belgium, Kingdom of', 'BE', 'BEL', 56);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Bermuda', 'BM', 'BMU', 60);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Bhutan, Kingdom of', 'BT', 'BTN', 64);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Bolivia, Republic of', 'BO', 'BOL', 68);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Bosnia and Herzegovina', 'BA', 'BIH', 70);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Botswana, Republic of', 'BW', 'BWA', 72);
INSERT INTO `ain_corona_countries` VALUES ('Antarctica', 'AN', 'Bouvet Island (Bouvetoya)', 'BV', 'BVT', 74);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Brazil, Federative Republic of', 'BR', 'BRA', 76);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Belize', 'BZ', 'BLZ', 84);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'British Indian Ocean Territory (Chagos Archipelago)', 'IO', 'IOT', 86);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Solomon Islands', 'SB', 'SLB', 90);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'British Virgin Islands', 'VG', 'VGB', 92);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Brunei Darussalam', 'BN', 'BRN', 96);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Bulgaria, Republic of', 'BG', 'BGR', 100);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Myanmar, Union of', 'MM', 'MMR', 104);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Burundi, Republic of', 'BI', 'BDI', 108);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Belarus, Republic of', 'BY', 'BLR', 112);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Cambodia, Kingdom of', 'KH', 'KHM', 116);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Cameroon, Republic of', 'CM', 'CMR', 120);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Canada', 'CA', 'CAN', 124);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Cape Verde, Republic of', 'CV', 'CPV', 132);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Cayman Islands', 'KY', 'CYM', 136);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Central African Republic', 'CF', 'CAF', 140);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Sri Lanka, Democratic Socialist Republic of', 'LK', 'LKA', 144);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Chad, Republic of', 'TD', 'TCD', 148);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Chile, Republic of', 'CL', 'CHL', 152);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'China, People\'s Republic of', 'CN', 'CHN', 156);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Taiwan', 'TW', 'TWN', 158);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Christmas Island', 'CX', 'CXR', 162);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Cocos (Keeling) Islands', 'CC', 'CCK', 166);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Colombia, Republic of', 'CO', 'COL', 170);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Comoros, Union of the', 'KM', 'COM', 174);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Mayotte', 'YT', 'MYT', 175);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Congo, Republic of the', 'CG', 'COG', 178);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Congo, Democratic Republic of the', 'CD', 'COD', 180);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Cook Islands', 'CK', 'COK', 184);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Costa Rica, Republic of', 'CR', 'CRI', 188);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Croatia, Republic of', 'HR', 'HRV', 191);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Cuba, Republic of', 'CU', 'CUB', 192);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Cyprus, Republic of', 'CY', 'CYP', 196);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Cyprus, Republic of', 'CY', 'CYP', 196);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Czech Republic', 'CZ', 'CZE', 203);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Benin, Republic of', 'BJ', 'BEN', 204);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Denmark, Kingdom of', 'DK', 'DNK', 208);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Dominica, Commonwealth of', 'DM', 'DMA', 212);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Dominican Republic', 'DO', 'DOM', 214);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Ecuador, Republic of', 'EC', 'ECU', 218);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'El Salvador, Republic of', 'SV', 'SLV', 222);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Equatorial Guinea, Republic of', 'GQ', 'GNQ', 226);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Ethiopia, Federal Democratic Republic of', 'ET', 'ETH', 231);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Eritrea, State of', 'ER', 'ERI', 232);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Estonia, Republic of', 'EE', 'EST', 233);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Faroe Islands', 'FO', 'FRO', 234);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Falkland Islands (Malvinas)', 'FK', 'FLK', 238);
INSERT INTO `ain_corona_countries` VALUES ('Antarctica', 'AN', 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 239);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Fiji, Republic of the Fiji Islands', 'FJ', 'FJI', 242);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Finland, Republic of', 'FI', 'FIN', 246);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Aland Islands', 'AX', 'ALA', 248);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'France, French Republic', 'FR', 'FRA', 250);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'French Guiana', 'GF', 'GUF', 254);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'French Polynesia', 'PF', 'PYF', 258);
INSERT INTO `ain_corona_countries` VALUES ('Antarctica', 'AN', 'French Southern Territories', 'TF', 'ATF', 260);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Djibouti, Republic of', 'DJ', 'DJI', 262);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Gabon, Gabonese Republic', 'GA', 'GAB', 266);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Georgia', 'GE', 'GEO', 268);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Georgia', 'GE', 'GEO', 268);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Gambia, Republic of the', 'GM', 'GMB', 270);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Palestinian Territory, Occupied', 'PS', 'PSE', 275);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Germany, Federal Republic of', 'DE', 'DEU', 276);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Ghana, Republic of', 'GH', 'GHA', 288);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Gibraltar', 'GI', 'GIB', 292);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Kiribati, Republic of', 'KI', 'KIR', 296);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Greece, Hellenic Republic', 'GR', 'GRC', 300);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Greenland', 'GL', 'GRL', 304);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Grenada', 'GD', 'GRD', 308);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Guadeloupe', 'GP', 'GLP', 312);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Guam', 'GU', 'GUM', 316);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Guatemala, Republic of', 'GT', 'GTM', 320);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Guinea, Republic of', 'GN', 'GIN', 324);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Guyana, Co-operative Republic of', 'GY', 'GUY', 328);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Haiti, Republic of', 'HT', 'HTI', 332);
INSERT INTO `ain_corona_countries` VALUES ('Antarctica', 'AN', 'Heard Island and McDonald Islands', 'HM', 'HMD', 334);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Holy See (Vatican City State)', 'VA', 'VAT', 336);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Honduras, Republic of', 'HN', 'HND', 340);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Hong Kong, Special Administrative Region of China', 'HK', 'HKG', 344);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Hungary, Republic of', 'HU', 'HUN', 348);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Iceland, Republic of', 'IS', 'ISL', 352);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'India, Republic of', 'IN', 'IND', 356);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Indonesia, Republic of', 'ID', 'IDN', 360);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Iran, Islamic Republic of', 'IR', 'IRN', 364);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Iraq, Republic of', 'IQ', 'IRQ', 368);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Ireland', 'IE', 'IRL', 372);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Israel, State of', 'IL', 'ISR', 376);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Italy, Italian Republic', 'IT', 'ITA', 380);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Cote d\'Ivoire, Republic of', 'CI', 'CIV', 384);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Jamaica', 'JM', 'JAM', 388);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Japan', 'JP', 'JPN', 392);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Kazakhstan, Republic of', 'KZ', 'KAZ', 398);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Kazakhstan, Republic of', 'KZ', 'KAZ', 398);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Jordan, Hashemite Kingdom of', 'JO', 'JOR', 400);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Kenya, Republic of', 'KE', 'KEN', 404);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Korea, Democratic People\'s Republic of', 'KP', 'PRK', 408);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Korea, Republic of', 'KR', 'KOR', 410);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Kuwait, State of', 'KW', 'KWT', 414);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Kyrgyz Republic', 'KG', 'KGZ', 417);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Lao People\'s Democratic Republic', 'LA', 'LAO', 418);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Lebanon, Lebanese Republic', 'LB', 'LBN', 422);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Lesotho, Kingdom of', 'LS', 'LSO', 426);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Latvia, Republic of', 'LV', 'LVA', 428);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Liberia, Republic of', 'LR', 'LBR', 430);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Libyan Arab Jamahiriya', 'LY', 'LBY', 434);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Liechtenstein, Principality of', 'LI', 'LIE', 438);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Lithuania, Republic of', 'LT', 'LTU', 440);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Luxembourg, Grand Duchy of', 'LU', 'LUX', 442);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Macao, Special Administrative Region of China', 'MO', 'MAC', 446);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Madagascar, Republic of', 'MG', 'MDG', 450);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Malawi, Republic of', 'MW', 'MWI', 454);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Malaysia', 'MY', 'MYS', 458);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Maldives, Republic of', 'MV', 'MDV', 462);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Mali, Republic of', 'ML', 'MLI', 466);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Malta, Republic of', 'MT', 'MLT', 470);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Martinique', 'MQ', 'MTQ', 474);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Mauritania, Islamic Republic of', 'MR', 'MRT', 478);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Mauritius, Republic of', 'MU', 'MUS', 480);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Mexico, United Mexican States', 'MX', 'MEX', 484);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Monaco, Principality of', 'MC', 'MCO', 492);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Mongolia', 'MN', 'MNG', 496);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Moldova, Republic of', 'MD', 'MDA', 498);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Montenegro, Republic of', 'ME', 'MNE', 499);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Montserrat', 'MS', 'MSR', 500);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Morocco, Kingdom of', 'MA', 'MAR', 504);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Mozambique, Republic of', 'MZ', 'MOZ', 508);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Oman, Sultanate of', 'OM', 'OMN', 512);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Namibia, Republic of', 'NA', 'NAM', 516);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Nauru, Republic of', 'NR', 'NRU', 520);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Nepal, State of', 'NP', 'NPL', 524);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Netherlands, Kingdom of the', 'NL', 'NLD', 528);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Netherlands Antilles', 'AN', 'ANT', 530);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Curasao', 'CW', 'CUW', 531);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Aruba', 'AW', 'ABW', 533);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Sint Maarten (Netherlands)', 'SX', 'SXM', 534);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Bonaire, Sint Eustatius and Saba', 'BQ', 'BES', 535);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'New Caledonia', 'NC', 'NCL', 540);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Vanuatu, Republic of', 'VU', 'VUT', 548);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'New Zealand', 'NZ', 'NZL', 554);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Nicaragua, Republic of', 'NI', 'NIC', 558);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Niger, Republic of', 'NE', 'NER', 562);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Nigeria, Federal Republic of', 'NG', 'NGA', 566);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Niue', 'NU', 'NIU', 570);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Norfolk Island', 'NF', 'NFK', 574);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Norway, Kingdom of', 'NO', 'NOR', 578);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Northern Mariana Islands, Commonwealth of the', 'MP', 'MNP', 580);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'United States Minor Outlying Islands', 'UM', 'UMI', 581);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'United States Minor Outlying Islands', 'UM', 'UMI', 581);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Micronesia, Federated States of', 'FM', 'FSM', 583);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Marshall Islands, Republic of the', 'MH', 'MHL', 584);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Palau, Republic of', 'PW', 'PLW', 585);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Pakistan, Islamic Republic of', 'PK', 'PAK', 586);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Panama, Republic of', 'PA', 'PAN', 591);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Papua New Guinea, Independent State of', 'PG', 'PNG', 598);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Paraguay, Republic of', 'PY', 'PRY', 600);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Peru, Republic of', 'PE', 'PER', 604);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Philippines, Republic of the', 'PH', 'PHL', 608);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Pitcairn Islands', 'PN', 'PCN', 612);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Poland, Republic of', 'PL', 'POL', 616);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Portugal, Portuguese Republic', 'PT', 'PRT', 620);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Guinea-Bissau, Republic of', 'GW', 'GNB', 624);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Timor-Leste, Democratic Republic of', 'TL', 'TLS', 626);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Puerto Rico, Commonwealth of', 'PR', 'PRI', 630);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Qatar, State of', 'QA', 'QAT', 634);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Reunion', 'RE', 'REU', 638);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Romania', 'RO', 'ROU', 642);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Russian Federation', 'RU', 'RUS', 643);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Russian Federation', 'RU', 'RUS', 643);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Rwanda, Republic of', 'RW', 'RWA', 646);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Saint Barthelemy', 'BL', 'BLM', 652);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Saint Helena', 'SH', 'SHN', 654);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Saint Kitts and Nevis, Federation of', 'KN', 'KNA', 659);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Anguilla', 'AI', 'AIA', 660);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Saint Lucia', 'LC', 'LCA', 662);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Saint Martin', 'MF', 'MAF', 663);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Saint Pierre and Miquelon', 'PM', 'SPM', 666);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Saint Vincent and the Grenadines', 'VC', 'VCT', 670);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'San Marino, Republic of', 'SM', 'SMR', 674);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Sao Tome and Principe, Democratic Republic of', 'ST', 'STP', 678);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Saudi Arabia, Kingdom of', 'SA', 'SAU', 682);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Senegal, Republic of', 'SN', 'SEN', 686);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Serbia, Republic of', 'RS', 'SRB', 688);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Seychelles, Republic of', 'SC', 'SYC', 690);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Sierra Leone, Republic of', 'SL', 'SLE', 694);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Singapore, Republic of', 'SG', 'SGP', 702);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Slovakia (Slovak Republic)', 'SK', 'SVK', 703);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Vietnam, Socialist Republic of', 'VN', 'VNM', 704);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Slovenia, Republic of', 'SI', 'SVN', 705);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Somalia, Somali Republic', 'SO', 'SOM', 706);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'South Africa, Republic of', 'ZA', 'ZAF', 710);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Zimbabwe, Republic of', 'ZW', 'ZWE', 716);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Spain, Kingdom of', 'ES', 'ESP', 724);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'South Sudan', 'SS', 'SSD', 728);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Western Sahara', 'EH', 'ESH', 732);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Sudan, Republic of', 'SD', 'SDN', 736);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Suriname, Republic of', 'SR', 'SUR', 740);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Svalbard & Jan Mayen Islands', 'SJ', 'SJM', 744);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Swaziland, Kingdom of', 'SZ', 'SWZ', 748);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Sweden, Kingdom of', 'SE', 'SWE', 752);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Switzerland, Swiss Confederation', 'CH', 'CHE', 756);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Syrian Arab Republic', 'SY', 'SYR', 760);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Tajikistan, Republic of', 'TJ', 'TJK', 762);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Thailand, Kingdom of', 'TH', 'THA', 764);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Togo, Togolese Republic', 'TG', 'TGO', 768);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Tokelau', 'TK', 'TKL', 772);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Tonga, Kingdom of', 'TO', 'TON', 776);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Trinidad and Tobago, Republic of', 'TT', 'TTO', 780);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'United Arab Emirates', 'AE', 'ARE', 784);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Tunisia, Tunisian Republic', 'TN', 'TUN', 788);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Turkey, Republic of', 'TR', 'TUR', 792);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Turkey, Republic of', 'TR', 'TUR', 792);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Turkmenistan', 'TM', 'TKM', 795);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'Turks and Caicos Islands', 'TC', 'TCA', 796);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Tuvalu', 'TV', 'TUV', 798);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Uganda, Republic of', 'UG', 'UGA', 800);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Ukraine', 'UA', 'UKR', 804);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 807);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Egypt, Arab Republic of', 'EG', 'EGY', 818);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'United Kingdom of Great Britain & Northern Ireland', 'GB', 'GBR', 826);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Guernsey, Bailiwick of', 'GG', 'GGY', 831);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Jersey, Bailiwick of', 'JE', 'JEY', 832);
INSERT INTO `ain_corona_countries` VALUES ('Europe', 'EU', 'Isle of Man', 'IM', 'IMN', 833);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Tanzania, United Republic of', 'TZ', 'TZA', 834);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'United States of America', 'US', 'USA', 840);
INSERT INTO `ain_corona_countries` VALUES ('North America', 'NA', 'United States Virgin Islands', 'VI', 'VIR', 850);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Burkina Faso', 'BF', 'BFA', 854);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Uruguay, Eastern Republic of', 'UY', 'URY', 858);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Uzbekistan, Republic of', 'UZ', 'UZB', 860);
INSERT INTO `ain_corona_countries` VALUES ('South America', 'SA', 'Venezuela, Bolivarian Republic of', 'VE', 'VEN', 862);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Wallis and Futuna', 'WF', 'WLF', 876);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Samoa, Independent State of', 'WS', 'WSM', 882);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Yemen', 'YE', 'YEM', 887);
INSERT INTO `ain_corona_countries` VALUES ('Africa', 'AF', 'Zambia, Republic of', 'ZM', 'ZMB', 894);
INSERT INTO `ain_corona_countries` VALUES ('Oceania', 'OC', 'Disputed Territory', 'XX', NULL, NULL);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Iraq-Saudi Arabia Neutral Zone', 'XE', NULL, NULL);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'United Nations Neutral Zone', 'XD', NULL, NULL);
INSERT INTO `ain_corona_countries` VALUES ('Asia', 'AS', 'Spratly Islands', 'XS', NULL, NULL);
# 262 records

COMMIT;

