const upsert = require('../src/utils/upsert'); const countries = [ { name: 'Afghanistan', code: 4, alpha2: 'AF', alpha3: 'AFG', nationality: 'Afghan', }, { name: 'Åland Islands', code: 248, alpha2: 'AX', alpha3: 'ALA', nationality: 'Åland Island', }, { name: 'Albania', code: 8, alpha2: 'AL', alpha3: 'ALB', nationality: 'Albanian', }, { name: 'Algeria', code: 12, alpha2: 'DZ', alpha3: 'DZA', nationality: 'Algerian', }, { name: 'American Samoa', code: 16, alpha2: 'AS', alpha3: 'ASM', nationality: 'American Samoan', priority: 0, }, { name: 'Andorra', code: 20, alpha2: 'AD', alpha3: 'AND', nationality: 'Andorran', }, { name: 'Angola', code: 24, alpha2: 'AO', alpha3: 'AGO', nationality: 'Angolan', }, { name: 'Anguilla', code: 660, alpha2: 'AI', alpha3: 'AIA', nationality: 'Anguillan', }, { name: 'Antarctica', code: 10, alpha2: 'AQ', alpha3: 'ATA', nationality: 'Antarctic', }, { name: 'Antigua and Barbuda', code: 28, alpha2: 'AG', alpha3: 'ATG', nationality: 'Antiguan or Barbudan', }, { name: 'Argentina', code: 32, alpha2: 'AR', alpha3: 'ARG', nationality: 'Argentine, Argentinian', }, { name: 'Armenia', code: 51, alpha2: 'AM', alpha3: 'ARM', nationality: 'Armenian', }, { name: 'Aruba', code: 533, alpha2: 'AW', alpha3: 'ABW', nationality: 'Aruban', }, { name: 'Australia', code: 36, alpha2: 'AU', alpha3: 'AUS', nationality: 'Australian', }, { name: 'Austria', code: 40, alpha2: 'AT', alpha3: 'AUT', nationality: 'Austrian', }, { name: 'Azerbaijan', code: 31, alpha2: 'AZ', alpha3: 'AZE', nationality: 'Azerbaijani, Azeri', }, { name: 'Bahamas', code: 44, alpha2: 'BS', alpha3: 'BHS', nationality: 'Bahamian', }, { name: 'Bahrain', code: 48, alpha2: 'BH', alpha3: 'BHR', nationality: 'Bahraini', }, { name: 'Bangladesh', code: 50, alpha2: 'BD', alpha3: 'BGD', nationality: 'Bangladeshi', }, { name: 'Barbados', code: 52, alpha2: 'BB', alpha3: 'BRB', nationality: 'Barbadian', }, { name: 'Belarus', code: 112, alpha2: 'BY', alpha3: 'BLR', nationality: 'Belarusian', }, { name: 'Belgium', code: 56, alpha2: 'BE', alpha3: 'BEL', nationality: 'Belgian', }, { name: 'Belize', code: 84, alpha2: 'BZ', alpha3: 'BLZ', nationality: 'Belizean', }, { name: 'Benin', code: 204, alpha2: 'BJ', alpha3: 'BEN', nationality: 'Beninese, Beninois', }, { name: 'Bermuda', code: 60, alpha2: 'BM', alpha3: 'BMU', nationality: 'Bermudian, Bermudan', }, { name: 'Bhutan', code: 64, alpha2: 'BT', alpha3: 'BTN', nationality: 'Bhutanese', }, { name: 'Bolivia (Plurinational State of)', alias: 'Bolivia', code: 68, alpha2: 'BO', alpha3: 'BOL', nationality: 'Bolivian', }, { name: 'Bonaire, Sint Eustatius and Saba', alias: 'Bonaire', code: 535, alpha2: 'BQ', alpha3: 'BES', nationality: 'Bonaire', }, { name: 'Bosnia and Herzegovina', alias: 'Bosnia', code: 70, alpha2: 'BA', alpha3: 'BIH', nationality: 'Bosnian or Herzegovinian', }, { name: 'Botswana', code: 72, alpha2: 'BW', alpha3: 'BWA', nationality: 'Motswana, Botswanan', }, { name: 'Bouvet Island', code: 74, alpha2: 'BV', alpha3: 'BVT', nationality: 'Bouvet Islander', }, { name: 'Brazil', code: 76, alpha2: 'BR', alpha3: 'BRA', nationality: 'Brazilian', }, { name: 'British Indian Ocean Territory', code: 86, alpha2: 'IO', alpha3: 'IOT', nationality: 'BIOT', }, { name: 'Brunei Darussalam', alias: 'Brunei', code: 96, alpha2: 'BN', alpha3: 'BRN', nationality: 'Bruneian', }, { name: 'Bulgaria', code: 100, alpha2: 'BG', alpha3: 'BGR', nationality: 'Bulgarian', }, { name: 'Burkina Faso', code: 854, alpha2: 'BF', alpha3: 'BFA', nationality: 'Burkinabé', }, { name: 'Burundi', code: 108, alpha2: 'BI', alpha3: 'BDI', nationality: 'Burundian', }, { name: 'Cabo Verde', code: 132, alpha2: 'CV', alpha3: 'CPV', nationality: 'Cabo Verdean', }, { name: 'Cambodia', code: 116, alpha2: 'KH', alpha3: 'KHM', nationality: 'Cambodian', }, { name: 'Cameroon', code: 120, alpha2: 'CM', alpha3: 'CMR', nationality: 'Cameroonian', }, { name: 'Canada', code: 124, alpha2: 'CA', alpha3: 'CAN', nationality: 'Canadian', }, { name: 'Cayman Islands', code: 136, alpha2: 'KY', alpha3: 'CYM', nationality: 'Caymanian', }, { name: 'Central African Republic', code: 140, alpha2: 'CF', alpha3: 'CAF', nationality: 'Central African', }, { name: 'Chad', code: 148, alpha2: 'TD', alpha3: 'TCD', nationality: 'Chadian', }, { name: 'Chile', code: 152, alpha2: 'CL', alpha3: 'CHL', nationality: 'Chilean', }, { name: 'China', code: 156, alpha2: 'CN', alpha3: 'CHN', nationality: 'Chinese', priority: 1, }, { name: 'Christmas Island', code: 162, alpha2: 'CX', alpha3: 'CXR', nationality: 'Christmas Islander', }, { name: 'Cocos (Keeling) Islands', code: 166, alpha2: 'CC', alpha3: 'CCK', nationality: 'Cocos Islander, Cocos Malays', }, { name: 'Colombia', code: 170, alpha2: 'CO', alpha3: 'COL', nationality: 'Colombian', }, { name: 'Comoros', code: 174, alpha2: 'KM', alpha3: 'COM', nationality: 'Comoran, Comorian', }, { name: 'Congo (Republic of the)', alias: 'Congo Republic', code: 178, alpha2: 'CG', alpha3: 'COG', nationality: 'Congolese', }, { name: 'Congo (Democratic Republic of the)', alias: 'DR Congo', code: 180, alpha2: 'CD', alpha3: 'COD', nationality: 'Congolese', }, { name: 'Cook Islands', code: 184, alpha2: 'CK', alpha3: 'COK', nationality: 'Cook Islander', }, { name: 'Costa Rica', code: 188, alpha2: 'CR', alpha3: 'CRI', nationality: 'Costa Rican', }, { name: "Côte d'Ivoire", code: 384, alpha2: 'CI', alpha3: 'CIV', nationality: 'Ivorian', }, { name: 'Croatia', code: 191, alpha2: 'HR', alpha3: 'HRV', nationality: 'Croatian', }, { name: 'Cuba', code: 192, alpha2: 'CU', alpha3: 'CUB', nationality: 'Cuban', }, { name: 'Curaçao', code: 531, alpha2: 'CW', alpha3: 'CUW', nationality: 'Curaçaoan', }, { name: 'Cyprus', code: 196, alpha2: 'CY', alpha3: 'CYP', nationality: 'Cypriot', }, { name: 'Czech Republic', code: 203, alpha2: 'CZ', alpha3: 'CZE', nationality: 'Czech', }, { name: 'Denmark', code: 208, alpha2: 'DK', alpha3: 'DNK', nationality: 'Danish', }, { name: 'Djibouti', code: 262, alpha2: 'DJ', alpha3: 'DJI', nationality: 'Djiboutian', }, { name: 'Dominica', code: 212, alpha2: 'DM', alpha3: 'DMA', nationality: 'Dominican', }, { name: 'Dominican Republic', code: 214, alpha2: 'DO', alpha3: 'DOM', nationality: 'Dominican', }, { name: 'Ecuador', code: 218, alpha2: 'EC', alpha3: 'ECU', nationality: 'Ecuadorian', }, { name: 'Egypt', code: 818, alpha2: 'EG', alpha3: 'EGY', nationality: 'Egyptian', }, { name: 'El Salvador', code: 222, alpha2: 'SV', alpha3: 'SLV', nationality: 'Salvadoran', }, { name: 'Equatorial Guinea', code: 226, alpha2: 'GQ', alpha3: 'GNQ', nationality: 'Equatorial Guinean, Equatoguinean', }, { name: 'Eritrea', code: 232, alpha2: 'ER', alpha3: 'ERI', nationality: 'Eritrean', }, { name: 'Estonia', code: 233, alpha2: 'EE', alpha3: 'EST', nationality: 'Estonian', }, { name: 'Ethiopia', code: 231, alpha2: 'ET', alpha3: 'ETH', nationality: 'Ethiopian', }, { name: 'Falkland Islands (Malvinas)', alias: 'Falkland Islands', code: 238, alpha2: 'FK', alpha3: 'FLK', nationality: 'Falkland Islander', }, { name: 'Faroe Islands', code: 234, alpha2: 'FO', alpha3: 'FRO', nationality: 'Faroese', }, { name: 'Fiji', code: 242, alpha2: 'FJ', alpha3: 'FJI', nationality: 'Fijian', }, { name: 'Finland', code: 246, alpha2: 'FI', alpha3: 'FIN', nationality: 'Finnish', }, { name: 'France', code: 250, alpha2: 'FR', alpha3: 'FRA', nationality: 'French', }, { name: 'French Guiana', code: 254, alpha2: 'GF', alpha3: 'GUF', nationality: 'French Guianese', }, { name: 'French Polynesia', code: 258, alpha2: 'PF', alpha3: 'PYF', nationality: 'French Polynesian', }, { name: 'French Southern Territories', code: 260, alpha2: 'TF', alpha3: 'ATF', nationality: 'French Southern Territories', }, { name: 'Gabon', code: 266, alpha2: 'GA', alpha3: 'GAB', nationality: 'Gabonese', }, { name: 'Gambia', code: 270, alpha2: 'GM', alpha3: 'GMB', nationality: 'Gambian', }, { name: 'Georgia', code: 268, alpha2: 'GE', alpha3: 'GEO', nationality: 'Georgian', }, { name: 'Germany', code: 276, alpha2: 'DE', alpha3: 'DEU', nationality: 'German', }, { name: 'Ghana', code: 288, alpha2: 'GH', alpha3: 'GHA', nationality: 'Ghanaian', }, { name: 'Gibraltar', code: 292, alpha2: 'GI', alpha3: 'GIB', nationality: 'Gibraltar', }, { name: 'Greece', code: 300, alpha2: 'GR', alpha3: 'GRC', nationality: 'Greek, Hellenic', }, { name: 'Greenland', code: 304, alpha2: 'GL', alpha3: 'GRL', nationality: 'Greenlandic', }, { name: 'Grenada', code: 308, alpha2: 'GD', alpha3: 'GRD', nationality: 'Grenadian', }, { name: 'Guadeloupe', code: 312, alpha2: 'GP', alpha3: 'GLP', nationality: 'Guadeloupean', }, { name: 'Guam', code: 316, alpha2: 'GU', alpha3: 'GUM', nationality: 'Guamanian, Guambat', }, { name: 'Guatemala', code: 320, alpha2: 'GT', alpha3: 'GTM', nationality: 'Guatemalan', }, { name: 'Guernsey', code: 831, alpha2: 'GG', alpha3: 'GGY', nationality: 'Channel Islander', }, { name: 'Guinea', code: 324, alpha2: 'GN', alpha3: 'GIN', nationality: 'Guinean', }, { name: 'Guinea-Bissau', code: 624, alpha2: 'GW', alpha3: 'GNB', nationality: 'Bissau-Guinean', }, { name: 'Guyana', code: 328, alpha2: 'GY', alpha3: 'GUY', nationality: 'Guyanese', }, { name: 'Haiti', code: 332, alpha2: 'HT', alpha3: 'HTI', nationality: 'Haitian', }, { name: 'Heard Island and McDonald Islands', code: 334, alpha2: 'HM', alpha3: 'HMD', nationality: 'Heard Islander, McDonald Islander', }, { name: 'Vatican City State', code: 336, alpha2: 'VA', alpha3: 'VAT', nationality: 'Vatican', }, { name: 'Honduras', code: 340, alpha2: 'HN', alpha3: 'HND', nationality: 'Honduran', }, { name: 'Hong Kong', code: 344, alpha2: 'HK', alpha3: 'HKG', nationality: 'Hongkonger, Hong Konger, Hong Kongese', }, { name: 'Hungary', code: 348, alpha2: 'HU', alpha3: 'HUN', nationality: 'Hungarian, Magyar', }, { name: 'Iceland', code: 352, alpha2: 'IS', alpha3: 'ISL', nationality: 'Icelandic', }, { name: 'India', code: 356, alpha2: 'IN', alpha3: 'IND', nationality: 'Indian', }, { name: 'Indonesia', code: 360, alpha2: 'ID', alpha3: 'IDN', nationality: 'Indonesian', }, { name: 'Iran', code: 364, alpha2: 'IR', alpha3: 'IRN', nationality: 'Iranian, Persian', }, { name: 'Iraq', code: 368, alpha2: 'IQ', alpha3: 'IRQ', nationality: 'Iraqi', }, { name: 'Ireland', code: 372, alpha2: 'IE', alpha3: 'IRL', nationality: 'Irish', }, { name: 'Isle of Man', code: 833, alpha2: 'IM', alpha3: 'IMN', nationality: 'Manx', }, { name: 'Israel', code: 376, alpha2: 'IL', alpha3: 'ISR', nationality: 'Israeli', }, { name: 'Italy', code: 380, alpha2: 'IT', alpha3: 'ITA', nationality: 'Italian', }, { name: 'Jamaica', code: 388, alpha2: 'JM', alpha3: 'JAM', nationality: 'Jamaican', }, { name: 'Japan', code: 392, alpha2: 'JP', alpha3: 'JPN', nationality: 'Japanese', }, { name: 'Jersey', code: 832, alpha2: 'JE', alpha3: 'JEY', nationality: 'Channel Island', }, { name: 'Jordan', code: 400, alpha2: 'JO', alpha3: 'JOR', nationality: 'Jordanian', }, { name: 'Kazakhstan', code: 398, alpha2: 'KZ', alpha3: 'KAZ', nationality: 'Kazakhstani, Kazakh', }, { name: 'Kenya', code: 404, alpha2: 'KE', alpha3: 'KEN', nationality: 'Kenyan', }, { name: 'Kiribati', code: 296, alpha2: 'KI', alpha3: 'KIR', nationality: 'I-Kiribati', }, { name: "Korea (Democratic People's Republic of)", alias: 'North Korea', code: 408, alpha2: 'KP', alpha3: 'PRK', nationality: 'North Korean', }, { name: 'Korea (Republic of)', alias: 'South Korea', code: 410, alpha2: 'KR', alpha3: 'KOR', nationality: 'South Korean', }, { name: 'Republic of Kosovo', alias: 'Kosovo', code: 383, alpha2: 'XK', alpha3: 'UNK', nationality: 'Kosovan', }, { name: 'Kuwait', code: 414, alpha2: 'KW', alpha3: 'KWT', nationality: 'Kuwaiti', }, { name: 'Kyrgyzstan', code: 417, alpha2: 'KG', alpha3: 'KGZ', nationality: 'Kyrgyzstani, Kyrgyz, Kirgiz, Kirghiz', }, { name: 'Lao People\'s Democratic Republic', alias: 'Laos', code: 418, alpha2: 'LA', alpha3: 'LAO', nationality: 'Lao, Laotian', }, { name: 'Latvia', code: 428, alpha2: 'LV', alpha3: 'LVA', nationality: 'Latvian', }, { name: 'Lebanon', code: 422, alpha2: 'LB', alpha3: 'LBN', nationality: 'Lebanese', }, { name: 'Lesotho', code: 426, alpha2: 'LS', alpha3: 'LSO', nationality: 'Basotho', }, { name: 'Liberia', code: 430, alpha2: 'LR', alpha3: 'LBR', nationality: 'Liberian', }, { name: 'Libya', code: 434, alpha2: 'LY', alpha3: 'LBY', nationality: 'Libyan', }, { name: 'Liechtenstein', code: 438, alpha2: 'LI', alpha3: 'LIE', nationality: 'Liechtenstein', }, { name: 'Lithuania', code: 440, alpha2: 'LT', alpha3: 'LTU', nationality: 'Lithuanian', }, { name: 'Luxembourg', code: 442, alpha2: 'LU', alpha3: 'LUX', nationality: 'Luxembourg, Luxembourgish', }, { name: 'Macao', code: 446, alpha2: 'MO', alpha3: 'MAC', nationality: 'Macanese, Chinese', priority: 0, }, { name: 'Macedonia (the former Yugoslav Republic of)', alias: 'Macedonia', code: 807, alpha2: 'MK', alpha3: 'MKD', nationality: 'Macedonian', }, { name: 'Madagascar', code: 450, alpha2: 'MG', alpha3: 'MDG', nationality: 'Malagasy', }, { name: 'Malawi', code: 454, alpha2: 'MW', alpha3: 'MWI', nationality: 'Malawian', }, { name: 'Malaysia', code: 458, alpha2: 'MY', alpha3: 'MYS', nationality: 'Malaysian', }, { name: 'Maldives', code: 462, alpha2: 'MV', alpha3: 'MDV', nationality: 'Maldivian', }, { name: 'Mali', code: 466, alpha2: 'ML', alpha3: 'MLI', nationality: 'Malian, Malinese', }, { name: 'Malta', code: 470, alpha2: 'MT', alpha3: 'MLT', nationality: 'Maltese', }, { name: 'Marshall Islands', code: 584, alpha2: 'MH', alpha3: 'MHL', nationality: 'Marshallese', }, { name: 'Martinique', code: 474, alpha2: 'MQ', alpha3: 'MTQ', nationality: 'Martiniquais, Martinican', }, { name: 'Mauritania', code: 478, alpha2: 'MR', alpha3: 'MRT', nationality: 'Mauritanian', }, { name: 'Mauritius', code: 480, alpha2: 'MU', alpha3: 'MUS', nationality: 'Mauritian', }, { name: 'Mayotte', code: 175, alpha2: 'YT', alpha3: 'MYT', nationality: 'Mahoran', }, { name: 'Mexico', code: 484, alpha2: 'MX', alpha3: 'MEX', nationality: 'Mexican', }, { name: 'Micronesia (Federated States of)', alias: 'Micronesia', code: 583, alpha2: 'FM', alpha3: 'FSM', nationality: 'Micronesian', }, { name: 'Moldova (Republic of)', alias: 'Moldova', code: 498, alpha2: 'MD', alpha3: 'MDA', nationality: 'Moldovan', }, { name: 'Monaco', code: 492, alpha2: 'MC', alpha3: 'MCO', nationality: 'Monégasque, Monacan', }, { name: 'Mongolia', code: 496, alpha2: 'MN', alpha3: 'MNG', nationality: 'Mongolian', }, { name: 'Montenegro', code: 499, alpha2: 'ME', alpha3: 'MNE', nationality: 'Montenegrin', }, { name: 'Montserrat', code: 500, alpha2: 'MS', alpha3: 'MSR', nationality: 'Montserratian', }, { name: 'Morocco', code: 504, alpha2: 'MA', alpha3: 'MAR', nationality: 'Moroccan', }, { name: 'Mozambique', code: 508, alpha2: 'MZ', alpha3: 'MOZ', nationality: 'Mozambican', }, { name: 'Myanmar', code: 104, alpha2: 'MM', alpha3: 'MMR', nationality: 'Burmese', }, { name: 'Namibia', code: 516, alpha2: 'NA', alpha3: 'NAM', nationality: 'Namibian', }, { name: 'Nauru', code: 520, alpha2: 'NR', alpha3: 'NRU', nationality: 'Nauruan', }, { name: 'Nepal', code: 524, alpha2: 'NP', alpha3: 'NPL', nationality: 'Nepali, Nepalese', }, { name: 'Netherlands', code: 528, alpha2: 'NL', alpha3: 'NLD', nationality: 'Dutch', }, { name: 'New Caledonia', code: 540, alpha2: 'NC', alpha3: 'NCL', nationality: 'New Caledonian', }, { name: 'New Zealand', code: 554, alpha2: 'NZ', alpha3: 'NZL', nationality: 'New Zealander, Kiwi', }, { name: 'Nicaragua', code: 558, alpha2: 'NI', alpha3: 'NIC', nationality: 'Nicaraguan', }, { name: 'Niger', code: 562, alpha2: 'NE', alpha3: 'NER', nationality: 'Nigerien', }, { name: 'Nigeria', code: 566, alpha2: 'NG', alpha3: 'NGA', nationality: 'Nigerian', }, { name: 'Niue', code: 570, alpha2: 'NU', alpha3: 'NIU', nationality: 'Niuean', }, { name: 'Norfolk Island', code: 574, alpha2: 'NF', alpha3: 'NFK', nationality: 'Norfolk Islander', }, { name: 'Northern Mariana Islands', code: 580, alpha2: 'MP', alpha3: 'MNP', nationality: 'Northern Marianan', }, { name: 'Norway', code: 578, alpha2: 'NO', alpha3: 'NOR', nationality: 'Norwegian', }, { name: 'Oman', code: 512, alpha2: 'OM', alpha3: 'OMN', nationality: 'Omani', }, { name: 'Pakistan', code: 586, alpha2: 'PK', alpha3: 'PAK', nationality: 'Pakistani', }, { name: 'Palau', code: 585, alpha2: 'PW', alpha3: 'PLW', nationality: 'Palauan', }, { name: 'Palestine, State of', alias: 'Palestine', code: 275, alpha2: 'PS', alpha3: 'PSE', nationality: 'Palestinian', }, { name: 'Panama', code: 591, alpha2: 'PA', alpha3: 'PAN', nationality: 'Panamanian', }, { name: 'Papua New Guinea', code: 598, alpha2: 'PG', alpha3: 'PNG', nationality: 'Papua New Guinean, Papuan', }, { name: 'Paraguay', code: 600, alpha2: 'PY', alpha3: 'PRY', nationality: 'Paraguayan', }, { name: 'Peru', code: 604, alpha2: 'PE', alpha3: 'PER', nationality: 'Peruvian', }, { name: 'Philippines', code: 608, alpha2: 'PH', alpha3: 'PHL', nationality: 'Philippine, Filipino', }, { name: 'Pitcairn', code: 612, alpha2: 'PN', alpha3: 'PCN', nationality: 'Pitcairn Island', }, { name: 'Poland', code: 616, alpha2: 'PL', alpha3: 'POL', nationality: 'Polish', }, { name: 'Portugal', code: 620, alpha2: 'PT', alpha3: 'PRT', nationality: 'Portuguese', }, { name: 'Puerto Rico', code: 630, alpha2: 'PR', alpha3: 'PRI', nationality: 'Puerto Rican', }, { name: 'Qatar', code: 634, alpha2: 'QA', alpha3: 'QAT', nationality: 'Qatari', }, { name: 'Réunion', code: 638, alpha2: 'RE', alpha3: 'REU', nationality: 'Réunionese, Réunionnais', }, { name: 'Romania', code: 642, alpha2: 'RO', alpha3: 'ROU', nationality: 'Romanian', }, { name: 'Russian Federation', alias: 'Russia', code: 643, alpha2: 'RU', alpha3: 'RUS', nationality: 'Russian', }, { name: 'Rwanda', code: 646, alpha2: 'RW', alpha3: 'RWA', nationality: 'Rwandan', }, { name: 'Saint Barthélemy', code: 652, alpha2: 'BL', alpha3: 'BLM', nationality: 'Barthélemois', }, { name: 'Saint Helena, Ascension and Tristan da Cunha', code: 654, alpha2: 'SH', alpha3: 'SHN', nationality: 'Saint Helenian', }, { name: 'Saint Kitts and Nevis', code: 659, alpha2: 'KN', alpha3: 'KNA', nationality: 'Kittitian or Nevisian', }, { name: 'Saint Lucia', code: 662, alpha2: 'LC', alpha3: 'LCA', nationality: 'Saint Lucian', }, { name: 'Saint Martin (French part)', alias: 'Saint Martin', code: 663, alpha2: 'MF', alpha3: 'MAF', nationality: 'Saint-Martinoise', }, { name: 'Saint Pierre and Miquelon', code: 666, alpha2: 'PM', alpha3: 'SPM', nationality: 'Saint-Pierrais or Miquelonnais', }, { name: 'Saint Vincent and the Grenadines', code: 670, alpha2: 'VC', alpha3: 'VCT', nationality: 'Saint Vincentian, Vincentian', }, { name: 'Samoa', code: 882, alpha2: 'WS', alpha3: 'WSM', nationality: 'Samoan', }, { name: 'San Marino', code: 674, alpha2: 'SM', alpha3: 'SMR', nationality: 'Sammarinese', }, { name: 'Sao Tome and Principe', code: 678, alpha2: 'ST', alpha3: 'STP', nationality: 'São Toméan', }, { name: 'Saudi Arabia', code: 682, alpha2: 'SA', alpha3: 'SAU', nationality: 'Saudi, Saudi Arabian', }, { name: 'Senegal', code: 686, alpha2: 'SN', alpha3: 'SEN', nationality: 'Senegalese', }, { name: 'Serbia', code: 688, alpha2: 'RS', alpha3: 'SRB', nationality: 'Serbian', }, { name: 'Seychelles', code: 690, alpha2: 'SC', alpha3: 'SYC', nationality: 'Seychellois', }, { name: 'Sierra Leone', code: 694, alpha2: 'SL', alpha3: 'SLE', nationality: 'Sierra Leonean', }, { name: 'Singapore', code: 702, alpha2: 'SG', alpha3: 'SGP', nationality: 'Singaporean', }, { name: 'Sint Maarten (Dutch part)', alias: 'Sint Maarten', code: 534, alpha2: 'SX', alpha3: 'SXM', nationality: 'Sint Maarten', }, { name: 'Slovakia', code: 703, alpha2: 'SK', alpha3: 'SVK', nationality: 'Slovak', }, { name: 'Slovenia', code: 705, alpha2: 'SI', alpha3: 'SVN', nationality: 'Slovenian, Slovene', }, { name: 'Solomon Islands', code: 90, alpha2: 'SB', alpha3: 'SLB', nationality: 'Solomon Island', }, { name: 'Somalia', code: 706, alpha2: 'SO', alpha3: 'SOM', nationality: 'Somali, Somalian', }, { name: 'South Africa', code: 710, alpha2: 'ZA', alpha3: 'ZAF', nationality: 'South African', }, { name: 'South Georgia and the South Sandwich Islands', code: 239, alpha2: 'GS', alpha3: 'SGS', nationality: 'South Georgia or South Sandwich Islands', }, { name: 'South Sudan', code: 728, alpha2: 'SS', alpha3: 'SSD', nationality: 'South Sudanese', }, { name: 'Spain', code: 724, alpha2: 'ES', alpha3: 'ESP', nationality: 'Spanish', }, { name: 'Sri Lanka', code: 144, alpha2: 'LK', alpha3: 'LKA', nationality: 'Sri Lankan', }, { name: 'Sudan', code: 729, alpha2: 'SD', alpha3: 'SDN', nationality: 'Sudanese', }, { name: 'Suriname', code: 740, alpha2: 'SR', alpha3: 'SUR', nationality: 'Surinamese', }, { name: 'Svalbard and Jan Mayen', code: 744, alpha2: 'SJ', alpha3: 'SJM', nationality: 'Svalbard', }, { name: 'Swaziland', code: 748, alpha2: 'SZ', alpha3: 'SWZ', nationality: 'Swazi', }, { name: 'Sweden', code: 752, alpha2: 'SE', alpha3: 'SWE', nationality: 'Swedish', }, { name: 'Switzerland', code: 756, alpha2: 'CH', alpha3: 'CHE', nationality: 'Swiss', }, { name: 'Syrian Arab Republic', alias: 'Syria', code: 760, alpha2: 'SY', alpha3: 'SYR', nationality: 'Syrian', }, { name: 'Taiwan, Province of China', alias: 'Taiwan', code: 158, alpha2: 'TW', alpha3: 'TWN', nationality: 'Chinese, Taiwanese', priority: 0, }, { name: 'Tajikistan', code: 762, alpha2: 'TJ', alpha3: 'TJK', nationality: 'Tajikistani', }, { name: 'Tanzania, United Republic of', alias: 'Tanzania', code: 834, alpha2: 'TZ', alpha3: 'TZA', nationality: 'Tanzanian', }, { name: 'Thailand', code: 764, alpha2: 'TH', alpha3: 'THA', nationality: 'Thai', }, { name: 'Timor-Leste', code: 626, alpha2: 'TL', alpha3: 'TLS', nationality: 'Timorese', }, { name: 'Togo', code: 768, alpha2: 'TG', alpha3: 'TGO', nationality: 'Togolese', }, { name: 'Tokelau', code: 772, alpha2: 'TK', alpha3: 'TKL', nationality: 'Tokelauan', }, { name: 'Tonga', code: 776, alpha2: 'TO', alpha3: 'TON', nationality: 'Tongan', }, { name: 'Trinidad and Tobago', code: 780, alpha2: 'TT', alpha3: 'TTO', nationality: 'Trinidadian or Tobagonian', }, { name: 'Tunisia', code: 788, alpha2: 'TN', alpha3: 'TUN', nationality: 'Tunisian', }, { name: 'Turkey', code: 792, alpha2: 'TR', alpha3: 'TUR', nationality: 'Turkish', }, { name: 'Turkmenistan', code: 795, alpha2: 'TM', alpha3: 'TKM', nationality: 'Turkmen', }, { name: 'Turks and Caicos Islands', code: 796, alpha2: 'TC', alpha3: 'TCA', nationality: 'Turks and Caicos Island', }, { name: 'Tuvalu', code: 798, alpha2: 'TV', alpha3: 'TUV', nationality: 'Tuvaluan', }, { name: 'Uganda', code: 800, alpha2: 'UG', alpha3: 'UGA', nationality: 'Ugandan', }, { name: 'Ukraine', code: 804, alpha2: 'UA', alpha3: 'UKR', nationality: 'Ukrainian', }, { name: 'United Arab Emirates', code: 784, alpha2: 'AE', alpha3: 'ARE', nationality: 'Emirati, Emirian, Emiri', }, { name: 'United Kingdom of Great Britain and Northern Ireland', alias: 'United Kingdom', code: 826, alpha2: 'GB', alpha3: 'GBR', nationality: 'British, English', }, { name: 'United States Minor Outlying Islands', code: 581, alpha2: 'UM', alpha3: 'UMI', nationality: 'American', priority: 0, }, { name: 'United States of America', alias: 'United States', code: 840, alpha2: 'US', alpha3: 'USA', nationality: 'American', priority: 1, }, { name: 'Uruguay', code: 858, alpha2: 'UY', alpha3: 'URY', nationality: 'Uruguayan', }, { name: 'Uzbekistan', code: 860, alpha2: 'UZ', alpha3: 'UZB', nationality: 'Uzbekistani, Uzbek', }, { name: 'Vanuatu', code: 548, alpha2: 'VU', alpha3: 'VUT', nationality: 'Ni-Vanuatu, Vanuatuan', }, { name: 'Venezuela (Bolivarian Republic of)', alias: 'Venezuela', code: 862, alpha2: 'VE', alpha3: 'VEN', nationality: 'Venezuelan', }, { name: 'Vietnam', code: 704, alpha2: 'VN', alpha3: 'VNM', nationality: 'Vietnamese', }, { name: 'Virgin Islands (British)', code: 92, alpha2: 'VG', alpha3: 'VGB', nationality: 'British Virgin Island', }, { name: 'Virgin Islands (U.S.)', code: 850, alpha2: 'VI', alpha3: 'VIR', nationality: 'U.S. Virgin Island', }, { name: 'Wallis and Futuna', code: 876, alpha2: 'WF', alpha3: 'WLF', nationality: 'Wallis and Futuna, Wallisian or Futunan', }, { name: 'Western Sahara', code: 732, alpha2: 'EH', alpha3: 'ESH', nationality: 'Sahrawi, Sahrawian, Sahraouian', }, { name: 'Yemen', code: 887, alpha2: 'YE', alpha3: 'YEM', nationality: 'Yemeni', }, { name: 'Zambia', code: 894, alpha2: 'ZM', alpha3: 'ZMB', nationality: 'Zambian', }, { name: 'Zimbabwe', code: 716, alpha2: 'ZW', alpha3: 'ZWE', nationality: 'Zimbabwean', }, ]; exports.seed = (knex) => knex('countries') .then(async () => upsert('countries', countries, 'alpha2', knex));