CREATE TABLE `skyscanner_routes_usd` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `origin` VARCHAR(3) NOT NULL,
  `origin_country` VARCHAR(2) DEFAULT NULL,
  `origin_country_name` VARCHAR(100) DEFAULT NULL,
  `destination` VARCHAR(3) NOT NULL,
  `destination_country` VARCHAR(2) DEFAULT NULL,
  `destination_country_name` VARCHAR(100) DEFAULT NULL,
  `is_active` TINYINT(1) DEFAULT 1,
  `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `route_pair` (`origin`, `destination`),
  INDEX `idx_active` (`is_active`),
  INDEX `idx_origin_country` (`origin_country`),
  INDEX `idx_destination_country` (`destination_country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO skyscanner_routes_usd (origin, origin_country, origin_country_name, destination, destination_country, destination_country_name) VALUES
-- JFK to Europe
('JFK', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'LGW', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'MAN', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'EDI', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'GLA', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'BHX', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'BRS', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'NCL', 'GB', 'United Kingdom'),
('JFK', 'US', 'United States', 'CDG', 'FR', 'France'),
('JFK', 'US', 'United States', 'ORY', 'FR', 'France'),
('JFK', 'US', 'United States', 'NCE', 'FR', 'France'),
('JFK', 'US', 'United States', 'LYS', 'FR', 'France'),
('JFK', 'US', 'United States', 'MRS', 'FR', 'France'),
('JFK', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('JFK', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('JFK', 'US', 'United States', 'DUS', 'DE', 'Germany'),
('JFK', 'US', 'United States', 'BER', 'DE', 'Germany'),
('JFK', 'US', 'United States', 'HAM', 'DE', 'Germany'),
('JFK', 'US', 'United States', 'CGN', 'DE', 'Germany'),
('JFK', 'US', 'United States', 'STR', 'DE', 'Germany'),
('JFK', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('JFK', 'US', 'United States', 'BRU', 'BE', 'Belgium'),
('JFK', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'AGP', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'PMI', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'ALC', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'VLC', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'IBZ', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'SVQ', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'TFS', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'LPA', 'ES', 'Spain'),
('JFK', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'MXP', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'VCE', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'NAP', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'BLQ', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'PSA', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'FLR', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'CTA', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'PMO', 'IT', 'Italy'),
('JFK', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('JFK', 'US', 'United States', 'GVA', 'CH', 'Switzerland'),
('JFK', 'US', 'United States', 'BSL', 'CH', 'Switzerland'),
('JFK', 'US', 'United States', 'VIE', 'AT', 'Austria'),
('JFK', 'US', 'United States', 'SZG', 'AT', 'Austria'),
('JFK', 'US', 'United States', 'INN', 'AT', 'Austria'),
('JFK', 'US', 'United States', 'LIS', 'PT', 'Portugal'),
('JFK', 'US', 'United States', 'OPO', 'PT', 'Portugal'),
('JFK', 'US', 'United States', 'FAO', 'PT', 'Portugal'),
('JFK', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('JFK', 'US', 'United States', 'SNN', 'IE', 'Ireland'),
('JFK', 'US', 'United States', 'ORK', 'IE', 'Ireland'),
('JFK', 'US', 'United States', 'ATH', 'GR', 'Greece'),
('JFK', 'US', 'United States', 'SKG', 'GR', 'Greece'),
('JFK', 'US', 'United States', 'HER', 'GR', 'Greece'),
('JFK', 'US', 'United States', 'RHO', 'GR', 'Greece'),
('JFK', 'US', 'United States', 'CFU', 'GR', 'Greece'),
('JFK', 'US', 'United States', 'JMK', 'GR', 'Greece'),
('JFK', 'US', 'United States', 'JTR', 'GR', 'Greece'),
('JFK', 'US', 'United States', 'IST', 'TR', 'Turkey'),
('JFK', 'US', 'United States', 'AYT', 'TR', 'Turkey'),
('JFK', 'US', 'United States', 'ADB', 'TR', 'Turkey'),
('JFK', 'US', 'United States', 'DLM', 'TR', 'Turkey'),
('JFK', 'US', 'United States', 'BJV', 'TR', 'Turkey'),
('JFK', 'US', 'United States', 'CPH', 'DK', 'Denmark'),
('JFK', 'US', 'United States', 'ARN', 'SE', 'Sweden'),
('JFK', 'US', 'United States', 'GOT', 'SE', 'Sweden'),
('JFK', 'US', 'United States', 'OSL', 'NO', 'Norway'),
('JFK', 'US', 'United States', 'BGO', 'NO', 'Norway'),
('JFK', 'US', 'United States', 'HEL', 'FI', 'Finland'),
('JFK', 'US', 'United States', 'KEF', 'IS', 'Iceland'),
('JFK', 'US', 'United States', 'WAW', 'PL', 'Poland'),
('JFK', 'US', 'United States', 'KRK', 'PL', 'Poland'),
('JFK', 'US', 'United States', 'WRO', 'PL', 'Poland'),
('JFK', 'US', 'United States', 'GDN', 'PL', 'Poland'),
('JFK', 'US', 'United States', 'PRG', 'CZ', 'Czech Republic'),
('JFK', 'US', 'United States', 'BUD', 'HU', 'Hungary'),
('JFK', 'US', 'United States', 'OTP', 'RO', 'Romania'),
('JFK', 'US', 'United States', 'CLJ', 'RO', 'Romania'),
('JFK', 'US', 'United States', 'SOF', 'BG', 'Bulgaria'),
('JFK', 'US', 'United States', 'VAR', 'BG', 'Bulgaria'),
('JFK', 'US', 'United States', 'ZAG', 'HR', 'Croatia'),
('JFK', 'US', 'United States', 'SPU', 'HR', 'Croatia'),
('JFK', 'US', 'United States', 'DBV', 'HR', 'Croatia'),
('JFK', 'US', 'United States', 'BEG', 'RS', 'Serbia'),
('JFK', 'US', 'United States', 'LJU', 'SI', 'Slovenia'),
('JFK', 'US', 'United States', 'RIX', 'LV', 'Latvia'),
('JFK', 'US', 'United States', 'VNO', 'LT', 'Lithuania'),
('JFK', 'US', 'United States', 'TLL', 'EE', 'Estonia'),
('JFK', 'US', 'United States', 'KBP', 'UA', 'Ukraine'),
-- JFK to Middle East
('JFK', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('JFK', 'US', 'United States', 'AUH', 'AE', 'United Arab Emirates'),
('JFK', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('JFK', 'US', 'United States', 'TLV', 'IL', 'Israel'),
('JFK', 'US', 'United States', 'AMM', 'JO', 'Jordan'),
('JFK', 'US', 'United States', 'BEY', 'LB', 'Lebanon'),
('JFK', 'US', 'United States', 'KWI', 'KW', 'Kuwait'),
('JFK', 'US', 'United States', 'BAH', 'BH', 'Bahrain'),
('JFK', 'US', 'United States', 'MCT', 'OM', 'Oman'),
('JFK', 'US', 'United States', 'RUH', 'SA', 'Saudi Arabia'),
('JFK', 'US', 'United States', 'JED', 'SA', 'Saudi Arabia'),
('JFK', 'US', 'United States', 'DMM', 'SA', 'Saudi Arabia'),
('JFK', 'US', 'United States', 'CAI', 'EG', 'Egypt'),
('JFK', 'US', 'United States', 'HRG', 'EG', 'Egypt'),
('JFK', 'US', 'United States', 'SSH', 'EG', 'Egypt'),
-- JFK to Asia
('JFK', 'US', 'United States', 'DEL', 'IN', 'India'),
('JFK', 'US', 'United States', 'BOM', 'IN', 'India'),
('JFK', 'US', 'United States', 'BLR', 'IN', 'India'),
('JFK', 'US', 'United States', 'MAA', 'IN', 'India'),
('JFK', 'US', 'United States', 'HYD', 'IN', 'India'),
('JFK', 'US', 'United States', 'CCU', 'IN', 'India'),
('JFK', 'US', 'United States', 'AMD', 'IN', 'India'),
('JFK', 'US', 'United States', 'COK', 'IN', 'India'),
('JFK', 'US', 'United States', 'GOI', 'IN', 'India'),
('JFK', 'US', 'United States', 'JAI', 'IN', 'India'),
('JFK', 'US', 'United States', 'HKG', 'HK', 'Hong Kong'),
('JFK', 'US', 'United States', 'SIN', 'SG', 'Singapore'),
('JFK', 'US', 'United States', 'BKK', 'TH', 'Thailand'),
('JFK', 'US', 'United States', 'HKT', 'TH', 'Thailand'),
('JFK', 'US', 'United States', 'CNX', 'TH', 'Thailand'),
('JFK', 'US', 'United States', 'KUL', 'MY', 'Malaysia'),
('JFK', 'US', 'United States', 'PEN', 'MY', 'Malaysia'),
('JFK', 'US', 'United States', 'LGK', 'MY', 'Malaysia'),
('JFK', 'US', 'United States', 'CGK', 'ID', 'Indonesia'),
('JFK', 'US', 'United States', 'DPS', 'ID', 'Indonesia'),
('JFK', 'US', 'United States', 'SGN', 'VN', 'Vietnam'),
('JFK', 'US', 'United States', 'HAN', 'VN', 'Vietnam'),
('JFK', 'US', 'United States', 'DAD', 'VN', 'Vietnam'),
('JFK', 'US', 'United States', 'MNL', 'PH', 'Philippines'),
('JFK', 'US', 'United States', 'CEB', 'PH', 'Philippines'),
('JFK', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('JFK', 'US', 'United States', 'HND', 'JP', 'Japan'),
('JFK', 'US', 'United States', 'KIX', 'JP', 'Japan'),
('JFK', 'US', 'United States', 'NGO', 'JP', 'Japan'),
('JFK', 'US', 'United States', 'CTS', 'JP', 'Japan'),
('JFK', 'US', 'United States', 'FUK', 'JP', 'Japan'),
('JFK', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('JFK', 'US', 'United States', 'PUS', 'KR', 'South Korea'),
('JFK', 'US', 'United States', 'TPE', 'TW', 'Taiwan'),
('JFK', 'US', 'United States', 'KHH', 'TW', 'Taiwan'),
('JFK', 'US', 'United States', 'CMB', 'LK', 'Sri Lanka'),
('JFK', 'US', 'United States', 'DAC', 'BD', 'Bangladesh'),
('JFK', 'US', 'United States', 'KHI', 'PK', 'Pakistan'),
('JFK', 'US', 'United States', 'LHE', 'PK', 'Pakistan'),
('JFK', 'US', 'United States', 'ISB', 'PK', 'Pakistan'),
('JFK', 'US', 'United States', 'KTM', 'NP', 'Nepal'),
('JFK', 'US', 'United States', 'MLE', 'MV', 'Maldives'),
-- JFK to China
('JFK', 'US', 'United States', 'PVG', 'CN', 'China'),
('JFK', 'US', 'United States', 'PEK', 'CN', 'China'),
('JFK', 'US', 'United States', 'CAN', 'CN', 'China'),
('JFK', 'US', 'United States', 'SZX', 'CN', 'China'),
('JFK', 'US', 'United States', 'CTU', 'CN', 'China'),
('JFK', 'US', 'United States', 'HGH', 'CN', 'China'),
('JFK', 'US', 'United States', 'NKG', 'CN', 'China'),
('JFK', 'US', 'United States', 'XIY', 'CN', 'China'),
('JFK', 'US', 'United States', 'WUH', 'CN', 'China'),
('JFK', 'US', 'United States', 'CKG', 'CN', 'China'),
('JFK', 'US', 'United States', 'XMN', 'CN', 'China'),
-- JFK to Australia/Oceania
('JFK', 'US', 'United States', 'SYD', 'AU', 'Australia'),
('JFK', 'US', 'United States', 'MEL', 'AU', 'Australia'),
('JFK', 'US', 'United States', 'BNE', 'AU', 'Australia'),
('JFK', 'US', 'United States', 'PER', 'AU', 'Australia'),
('JFK', 'US', 'United States', 'ADL', 'AU', 'Australia'),
('JFK', 'US', 'United States', 'AKL', 'NZ', 'New Zealand'),
('JFK', 'US', 'United States', 'CHC', 'NZ', 'New Zealand'),
('JFK', 'US', 'United States', 'WLG', 'NZ', 'New Zealand'),
('JFK', 'US', 'United States', 'ZQN', 'NZ', 'New Zealand'),
('JFK', 'US', 'United States', 'NAN', 'FJ', 'Fiji'),
('JFK', 'US', 'United States', 'PPT', 'PF', 'French Polynesia'),
-- JFK to South America
('JFK', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'GIG', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'BSB', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'CNF', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'REC', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'FOR', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'SSA', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'POA', 'BR', 'Brazil'),
('JFK', 'US', 'United States', 'EZE', 'AR', 'Argentina'),
('JFK', 'US', 'United States', 'SCL', 'CL', 'Chile'),
('JFK', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('JFK', 'US', 'United States', 'CUZ', 'PE', 'Peru'),
('JFK', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('JFK', 'US', 'United States', 'MDE', 'CO', 'Colombia'),
('JFK', 'US', 'United States', 'CTG', 'CO', 'Colombia'),
('JFK', 'US', 'United States', 'CLO', 'CO', 'Colombia'),
('JFK', 'US', 'United States', 'UIO', 'EC', 'Ecuador'),
('JFK', 'US', 'United States', 'GYE', 'EC', 'Ecuador'),
('JFK', 'US', 'United States', 'CCS', 'VE', 'Venezuela'),
('JFK', 'US', 'United States', 'MVD', 'UY', 'Uruguay'),
('JFK', 'US', 'United States', 'ASU', 'PY', 'Paraguay'),
('JFK', 'US', 'United States', 'VVI', 'BO', 'Bolivia'),
('JFK', 'US', 'United States', 'LPB', 'BO', 'Bolivia'),
-- JFK to Central America/Caribbean/Mexico
('JFK', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('JFK', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('JFK', 'US', 'United States', 'GDL', 'MX', 'Mexico'),
('JFK', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('JFK', 'US', 'United States', 'SJD', 'MX', 'Mexico'),
('JFK', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('JFK', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('JFK', 'US', 'United States', 'LIR', 'CR', 'Costa Rica'),
('JFK', 'US', 'United States', 'GUA', 'GT', 'Guatemala'),
('JFK', 'US', 'United States', 'SAL', 'SV', 'El Salvador'),
('JFK', 'US', 'United States', 'BZE', 'BZ', 'Belize'),
('JFK', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('JFK', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('JFK', 'US', 'United States', 'MBJ', 'JM', 'Jamaica'),
('JFK', 'US', 'United States', 'KIN', 'JM', 'Jamaica'),
('JFK', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('JFK', 'US', 'United States', 'SDQ', 'DO', 'Dominican Republic'),
('JFK', 'US', 'United States', 'AUA', 'AW', 'Aruba'),
('JFK', 'US', 'United States', 'CUR', 'CW', 'Curacao'),
('JFK', 'US', 'United States', 'SXM', 'SX', 'Sint Maarten'),
('JFK', 'US', 'United States', 'BGI', 'BB', 'Barbados'),
('JFK', 'US', 'United States', 'POS', 'TT', 'Trinidad and Tobago'),
('JFK', 'US', 'United States', 'UVF', 'LC', 'Saint Lucia'),
('JFK', 'US', 'United States', 'GND', 'GD', 'Grenada'),
('JFK', 'US', 'United States', 'ANU', 'AG', 'Antigua'),
('JFK', 'US', 'United States', 'STT', 'VI', 'US Virgin Islands'),
('JFK', 'US', 'United States', 'GCM', 'KY', 'Cayman Islands'),
('JFK', 'US', 'United States', 'PLS', 'TC', 'Turks and Caicos'),
('JFK', 'US', 'United States', 'BDA', 'BM', 'Bermuda'),
-- JFK to Africa
('JFK', 'US', 'United States', 'CMN', 'MA', 'Morocco'),
('JFK', 'US', 'United States', 'RAK', 'MA', 'Morocco'),
('JFK', 'US', 'United States', 'JNB', 'ZA', 'South Africa'),
('JFK', 'US', 'United States', 'CPT', 'ZA', 'South Africa'),
('JFK', 'US', 'United States', 'ADD', 'ET', 'Ethiopia'),
('JFK', 'US', 'United States', 'NBO', 'KE', 'Kenya'),
('JFK', 'US', 'United States', 'LOS', 'NG', 'Nigeria'),
('JFK', 'US', 'United States', 'ABV', 'NG', 'Nigeria'),
('JFK', 'US', 'United States', 'ACC', 'GH', 'Ghana'),
('JFK', 'US', 'United States', 'DSS', 'SN', 'Senegal'),

-- LAX to Europe
('LAX', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('LAX', 'US', 'United States', 'LGW', 'GB', 'United Kingdom'),
('LAX', 'US', 'United States', 'MAN', 'GB', 'United Kingdom'),
('LAX', 'US', 'United States', 'CDG', 'FR', 'France'),
('LAX', 'US', 'United States', 'NCE', 'FR', 'France'),
('LAX', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('LAX', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('LAX', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('LAX', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('LAX', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('LAX', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('LAX', 'US', 'United States', 'MXP', 'IT', 'Italy'),
('LAX', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('LAX', 'US', 'United States', 'VIE', 'AT', 'Austria'),
('LAX', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('LAX', 'US', 'United States', 'LIS', 'PT', 'Portugal'),
('LAX', 'US', 'United States', 'ATH', 'GR', 'Greece'),
('LAX', 'US', 'United States', 'IST', 'TR', 'Turkey'),
('LAX', 'US', 'United States', 'CPH', 'DK', 'Denmark'),
('LAX', 'US', 'United States', 'ARN', 'SE', 'Sweden'),
('LAX', 'US', 'United States', 'OSL', 'NO', 'Norway'),
('LAX', 'US', 'United States', 'HEL', 'FI', 'Finland'),
('LAX', 'US', 'United States', 'KEF', 'IS', 'Iceland'),
('LAX', 'US', 'United States', 'WAW', 'PL', 'Poland'),
('LAX', 'US', 'United States', 'PRG', 'CZ', 'Czech Republic'),
('LAX', 'US', 'United States', 'BUD', 'HU', 'Hungary'),
-- LAX to Middle East
('LAX', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('LAX', 'US', 'United States', 'AUH', 'AE', 'United Arab Emirates'),
('LAX', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('LAX', 'US', 'United States', 'TLV', 'IL', 'Israel'),
('LAX', 'US', 'United States', 'AMM', 'JO', 'Jordan'),
('LAX', 'US', 'United States', 'RUH', 'SA', 'Saudi Arabia'),
('LAX', 'US', 'United States', 'JED', 'SA', 'Saudi Arabia'),
('LAX', 'US', 'United States', 'CAI', 'EG', 'Egypt'),
-- LAX to Asia
('LAX', 'US', 'United States', 'DEL', 'IN', 'India'),
('LAX', 'US', 'United States', 'BOM', 'IN', 'India'),
('LAX', 'US', 'United States', 'BLR', 'IN', 'India'),
('LAX', 'US', 'United States', 'HKG', 'HK', 'Hong Kong'),
('LAX', 'US', 'United States', 'SIN', 'SG', 'Singapore'),
('LAX', 'US', 'United States', 'BKK', 'TH', 'Thailand'),
('LAX', 'US', 'United States', 'HKT', 'TH', 'Thailand'),
('LAX', 'US', 'United States', 'KUL', 'MY', 'Malaysia'),
('LAX', 'US', 'United States', 'CGK', 'ID', 'Indonesia'),
('LAX', 'US', 'United States', 'DPS', 'ID', 'Indonesia'),
('LAX', 'US', 'United States', 'SGN', 'VN', 'Vietnam'),
('LAX', 'US', 'United States', 'HAN', 'VN', 'Vietnam'),
('LAX', 'US', 'United States', 'MNL', 'PH', 'Philippines'),
('LAX', 'US', 'United States', 'CEB', 'PH', 'Philippines'),
('LAX', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('LAX', 'US', 'United States', 'HND', 'JP', 'Japan'),
('LAX', 'US', 'United States', 'KIX', 'JP', 'Japan'),
('LAX', 'US', 'United States', 'NGO', 'JP', 'Japan'),
('LAX', 'US', 'United States', 'CTS', 'JP', 'Japan'),
('LAX', 'US', 'United States', 'FUK', 'JP', 'Japan'),
('LAX', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('LAX', 'US', 'United States', 'PUS', 'KR', 'South Korea'),
('LAX', 'US', 'United States', 'TPE', 'TW', 'Taiwan'),
('LAX', 'US', 'United States', 'CMB', 'LK', 'Sri Lanka'),
('LAX', 'US', 'United States', 'MLE', 'MV', 'Maldives'),
-- LAX to China
('LAX', 'US', 'United States', 'PVG', 'CN', 'China'),
('LAX', 'US', 'United States', 'PEK', 'CN', 'China'),
('LAX', 'US', 'United States', 'CAN', 'CN', 'China'),
('LAX', 'US', 'United States', 'SZX', 'CN', 'China'),
('LAX', 'US', 'United States', 'CTU', 'CN', 'China'),
('LAX', 'US', 'United States', 'HGH', 'CN', 'China'),
('LAX', 'US', 'United States', 'NKG', 'CN', 'China'),
('LAX', 'US', 'United States', 'XIY', 'CN', 'China'),
('LAX', 'US', 'United States', 'CKG', 'CN', 'China'),
('LAX', 'US', 'United States', 'XMN', 'CN', 'China'),
-- LAX to Australia/Oceania
('LAX', 'US', 'United States', 'SYD', 'AU', 'Australia'),
('LAX', 'US', 'United States', 'MEL', 'AU', 'Australia'),
('LAX', 'US', 'United States', 'BNE', 'AU', 'Australia'),
('LAX', 'US', 'United States', 'PER', 'AU', 'Australia'),
('LAX', 'US', 'United States', 'AKL', 'NZ', 'New Zealand'),
('LAX', 'US', 'United States', 'CHC', 'NZ', 'New Zealand'),
('LAX', 'US', 'United States', 'NAN', 'FJ', 'Fiji'),
('LAX', 'US', 'United States', 'PPT', 'PF', 'French Polynesia'),
-- LAX to South America
('LAX', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('LAX', 'US', 'United States', 'GIG', 'BR', 'Brazil'),
('LAX', 'US', 'United States', 'EZE', 'AR', 'Argentina'),
('LAX', 'US', 'United States', 'SCL', 'CL', 'Chile'),
('LAX', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('LAX', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('LAX', 'US', 'United States', 'MDE', 'CO', 'Colombia'),
('LAX', 'US', 'United States', 'UIO', 'EC', 'Ecuador'),
-- LAX to Central America/Mexico
('LAX', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('LAX', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('LAX', 'US', 'United States', 'GDL', 'MX', 'Mexico'),
('LAX', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('LAX', 'US', 'United States', 'SJD', 'MX', 'Mexico'),
('LAX', 'US', 'United States', 'MZT', 'MX', 'Mexico'),
('LAX', 'US', 'United States', 'ZIH', 'MX', 'Mexico'),
('LAX', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('LAX', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('LAX', 'US', 'United States', 'GUA', 'GT', 'Guatemala'),
('LAX', 'US', 'United States', 'SAL', 'SV', 'El Salvador'),

-- SFO routes
('SFO', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('SFO', 'US', 'United States', 'CDG', 'FR', 'France'),
('SFO', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('SFO', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('SFO', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('SFO', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('SFO', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('SFO', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('SFO', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('SFO', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('SFO', 'US', 'United States', 'CPH', 'DK', 'Denmark'),
('SFO', 'US', 'United States', 'IST', 'TR', 'Turkey'),
('SFO', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('SFO', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('SFO', 'US', 'United States', 'TLV', 'IL', 'Israel'),
('SFO', 'US', 'United States', 'DEL', 'IN', 'India'),
('SFO', 'US', 'United States', 'BLR', 'IN', 'India'),
('SFO', 'US', 'United States', 'BOM', 'IN', 'India'),
('SFO', 'US', 'United States', 'HKG', 'HK', 'Hong Kong'),
('SFO', 'US', 'United States', 'SIN', 'SG', 'Singapore'),
('SFO', 'US', 'United States', 'BKK', 'TH', 'Thailand'),
('SFO', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('SFO', 'US', 'United States', 'HND', 'JP', 'Japan'),
('SFO', 'US', 'United States', 'KIX', 'JP', 'Japan'),
('SFO', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('SFO', 'US', 'United States', 'TPE', 'TW', 'Taiwan'),
('SFO', 'US', 'United States', 'MNL', 'PH', 'Philippines'),
('SFO', 'US', 'United States', 'PVG', 'CN', 'China'),
('SFO', 'US', 'United States', 'PEK', 'CN', 'China'),
('SFO', 'US', 'United States', 'CAN', 'CN', 'China'),
('SFO', 'US', 'United States', 'CTU', 'CN', 'China'),
('SFO', 'US', 'United States', 'SYD', 'AU', 'Australia'),
('SFO', 'US', 'United States', 'MEL', 'AU', 'Australia'),
('SFO', 'US', 'United States', 'AKL', 'NZ', 'New Zealand'),
('SFO', 'US', 'United States', 'NAN', 'FJ', 'Fiji'),
('SFO', 'US', 'United States', 'PPT', 'PF', 'French Polynesia'),
('SFO', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('SFO', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('SFO', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('SFO', 'US', 'United States', 'SJD', 'MX', 'Mexico'),
('SFO', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('SFO', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('SFO', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('SFO', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('SFO', 'US', 'United States', 'BOG', 'CO', 'Colombia'),

-- ORD routes
('ORD', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('ORD', 'US', 'United States', 'MAN', 'GB', 'United Kingdom'),
('ORD', 'US', 'United States', 'CDG', 'FR', 'France'),
('ORD', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('ORD', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('ORD', 'US', 'United States', 'BER', 'DE', 'Germany'),
('ORD', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('ORD', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('ORD', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('ORD', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('ORD', 'US', 'United States', 'MXP', 'IT', 'Italy'),
('ORD', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('ORD', 'US', 'United States', 'VIE', 'AT', 'Austria'),
('ORD', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('ORD', 'US', 'United States', 'ATH', 'GR', 'Greece'),
('ORD', 'US', 'United States', 'IST', 'TR', 'Turkey'),
('ORD', 'US', 'United States', 'CPH', 'DK', 'Denmark'),
('ORD', 'US', 'United States', 'ARN', 'SE', 'Sweden'),
('ORD', 'US', 'United States', 'WAW', 'PL', 'Poland'),
('ORD', 'US', 'United States', 'KRK', 'PL', 'Poland'),
('ORD', 'US', 'United States', 'PRG', 'CZ', 'Czech Republic'),
('ORD', 'US', 'United States', 'BUD', 'HU', 'Hungary'),
('ORD', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('ORD', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('ORD', 'US', 'United States', 'TLV', 'IL', 'Israel'),
('ORD', 'US', 'United States', 'DEL', 'IN', 'India'),
('ORD', 'US', 'United States', 'HKG', 'HK', 'Hong Kong'),
('ORD', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('ORD', 'US', 'United States', 'HND', 'JP', 'Japan'),
('ORD', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('ORD', 'US', 'United States', 'PVG', 'CN', 'China'),
('ORD', 'US', 'United States', 'PEK', 'CN', 'China'),
('ORD', 'US', 'United States', 'SYD', 'AU', 'Australia'),
('ORD', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('ORD', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('ORD', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('ORD', 'US', 'United States', 'SJD', 'MX', 'Mexico'),
('ORD', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('ORD', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('ORD', 'US', 'United States', 'MBJ', 'JM', 'Jamaica'),
('ORD', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('ORD', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('ORD', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('ORD', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('ORD', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('ORD', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('ORD', 'US', 'United States', 'EZE', 'AR', 'Argentina'),
('ORD', 'US', 'United States', 'SCL', 'CL', 'Chile'),

-- MIA routes
('MIA', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('MIA', 'US', 'United States', 'CDG', 'FR', 'France'),
('MIA', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('MIA', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('MIA', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('MIA', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('MIA', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('MIA', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('MIA', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('MIA', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('MIA', 'US', 'United States', 'TLV', 'IL', 'Israel'),
('MIA', 'US', 'United States', 'CAI', 'EG', 'Egypt'),
('MIA', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('MIA', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('MIA', 'US', 'United States', 'GDL', 'MX', 'Mexico'),
('MIA', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('MIA', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('MIA', 'US', 'United States', 'MBJ', 'JM', 'Jamaica'),
('MIA', 'US', 'United States', 'KIN', 'JM', 'Jamaica'),
('MIA', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('MIA', 'US', 'United States', 'SDQ', 'DO', 'Dominican Republic'),
('MIA', 'US', 'United States', 'AUA', 'AW', 'Aruba'),
('MIA', 'US', 'United States', 'CUR', 'CW', 'Curacao'),
('MIA', 'US', 'United States', 'SXM', 'SX', 'Sint Maarten'),
('MIA', 'US', 'United States', 'BGI', 'BB', 'Barbados'),
('MIA', 'US', 'United States', 'POS', 'TT', 'Trinidad and Tobago'),
('MIA', 'US', 'United States', 'UVF', 'LC', 'Saint Lucia'),
('MIA', 'US', 'United States', 'GND', 'GD', 'Grenada'),
('MIA', 'US', 'United States', 'ANU', 'AG', 'Antigua'),
('MIA', 'US', 'United States', 'STT', 'VI', 'US Virgin Islands'),
('MIA', 'US', 'United States', 'GCM', 'KY', 'Cayman Islands'),
('MIA', 'US', 'United States', 'HAV', 'CU', 'Cuba'),
('MIA', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('MIA', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('MIA', 'US', 'United States', 'LIR', 'CR', 'Costa Rica'),
('MIA', 'US', 'United States', 'GUA', 'GT', 'Guatemala'),
('MIA', 'US', 'United States', 'SAL', 'SV', 'El Salvador'),
('MIA', 'US', 'United States', 'BZE', 'BZ', 'Belize'),
('MIA', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('MIA', 'US', 'United States', 'MDE', 'CO', 'Colombia'),
('MIA', 'US', 'United States', 'CTG', 'CO', 'Colombia'),
('MIA', 'US', 'United States', 'CLO', 'CO', 'Colombia'),
('MIA', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('MIA', 'US', 'United States', 'GIG', 'BR', 'Brazil'),
('MIA', 'US', 'United States', 'EZE', 'AR', 'Argentina'),
('MIA', 'US', 'United States', 'SCL', 'CL', 'Chile'),
('MIA', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('MIA', 'US', 'United States', 'UIO', 'EC', 'Ecuador'),
('MIA', 'US', 'United States', 'GYE', 'EC', 'Ecuador'),
('MIA', 'US', 'United States', 'CCS', 'VE', 'Venezuela'),
('MIA', 'US', 'United States', 'MVD', 'UY', 'Uruguay'),

-- ATL routes
('ATL', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('ATL', 'US', 'United States', 'CDG', 'FR', 'France'),
('ATL', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('ATL', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('ATL', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('ATL', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('ATL', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('ATL', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('ATL', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('ATL', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('ATL', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('ATL', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('ATL', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('ATL', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('ATL', 'US', 'United States', 'PVG', 'CN', 'China'),
('ATL', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('ATL', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('ATL', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('ATL', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('ATL', 'US', 'United States', 'MBJ', 'JM', 'Jamaica'),
('ATL', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('ATL', 'US', 'United States', 'AUA', 'AW', 'Aruba'),
('ATL', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('ATL', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('ATL', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('ATL', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('ATL', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('ATL', 'US', 'United States', 'JNB', 'ZA', 'South Africa'),
('ATL', 'US', 'United States', 'LOS', 'NG', 'Nigeria'),
('ATL', 'US', 'United States', 'ACC', 'GH', 'Ghana'),

-- DFW routes
('DFW', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('DFW', 'US', 'United States', 'CDG', 'FR', 'France'),
('DFW', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('DFW', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('DFW', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('DFW', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('DFW', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('DFW', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('DFW', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('DFW', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('DFW', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('DFW', 'US', 'United States', 'HND', 'JP', 'Japan'),
('DFW', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('DFW', 'US', 'United States', 'HKG', 'HK', 'Hong Kong'),
('DFW', 'US', 'United States', 'PVG', 'CN', 'China'),
('DFW', 'US', 'United States', 'PEK', 'CN', 'China'),
('DFW', 'US', 'United States', 'SYD', 'AU', 'Australia'),
('DFW', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('DFW', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('DFW', 'US', 'United States', 'GDL', 'MX', 'Mexico'),
('DFW', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('DFW', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('DFW', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('DFW', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('DFW', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('DFW', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('DFW', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('DFW', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('DFW', 'US', 'United States', 'EZE', 'AR', 'Argentina'),
('DFW', 'US', 'United States', 'SCL', 'CL', 'Chile'),

-- IAH routes
('IAH', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('IAH', 'US', 'United States', 'CDG', 'FR', 'France'),
('IAH', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('IAH', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('IAH', 'US', 'United States', 'IST', 'TR', 'Turkey'),
('IAH', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('IAH', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('IAH', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('IAH', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('IAH', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('IAH', 'US', 'United States', 'GDL', 'MX', 'Mexico'),
('IAH', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('IAH', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('IAH', 'US', 'United States', 'MBJ', 'JM', 'Jamaica'),
('IAH', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('IAH', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('IAH', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('IAH', 'US', 'United States', 'GRU', 'BR', 'Brazil'),
('IAH', 'US', 'United States', 'LIM', 'PE', 'Peru'),
('IAH', 'US', 'United States', 'EZE', 'AR', 'Argentina'),
('IAH', 'US', 'United States', 'SCL', 'CL', 'Chile'),
('IAH', 'US', 'United States', 'GUA', 'GT', 'Guatemala'),
('IAH', 'US', 'United States', 'SAL', 'SV', 'El Salvador'),

-- EWR routes
('EWR', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('EWR', 'US', 'United States', 'MAN', 'GB', 'United Kingdom'),
('EWR', 'US', 'United States', 'EDI', 'GB', 'United Kingdom'),
('EWR', 'US', 'United States', 'CDG', 'FR', 'France'),
('EWR', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('EWR', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('EWR', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('EWR', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('EWR', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('EWR', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('EWR', 'US', 'United States', 'MXP', 'IT', 'Italy'),
('EWR', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('EWR', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('EWR', 'US', 'United States', 'SNN', 'IE', 'Ireland'),
('EWR', 'US', 'United States', 'LIS', 'PT', 'Portugal'),
('EWR', 'US', 'United States', 'ATH', 'GR', 'Greece'),
('EWR', 'US', 'United States', 'IST', 'TR', 'Turkey'),
('EWR', 'US', 'United States', 'TLV', 'IL', 'Israel'),
('EWR', 'US', 'United States', 'DEL', 'IN', 'India'),
('EWR', 'US', 'United States', 'BOM', 'IN', 'India'),
('EWR', 'US', 'United States', 'HKG', 'HK', 'Hong Kong'),
('EWR', 'US', 'United States', 'SIN', 'SG', 'Singapore'),
('EWR', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('EWR', 'US', 'United States', 'PEK', 'CN', 'China'),
('EWR', 'US', 'United States', 'PVG', 'CN', 'China'),
('EWR', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('EWR', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('EWR', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('EWR', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('EWR', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('EWR', 'US', 'United States', 'GRU', 'BR', 'Brazil'),

-- SEA routes
('SEA', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('SEA', 'US', 'United States', 'CDG', 'FR', 'France'),
('SEA', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('SEA', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('SEA', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('SEA', 'US', 'United States', 'KEF', 'IS', 'Iceland'),
('SEA', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('SEA', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('SEA', 'US', 'United States', 'HND', 'JP', 'Japan'),
('SEA', 'US', 'United States', 'PVG', 'CN', 'China'),
('SEA', 'US', 'United States', 'PEK', 'CN', 'China'),
('SEA', 'US', 'United States', 'TPE', 'TW', 'Taiwan'),
('SEA', 'US', 'United States', 'HKG', 'HK', 'Hong Kong'),
('SEA', 'US', 'United States', 'SIN', 'SG', 'Singapore'),
('SEA', 'US', 'United States', 'SYD', 'AU', 'Australia'),
('SEA', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('SEA', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('SEA', 'US', 'United States', 'SJD', 'MX', 'Mexico'),
('SEA', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),

-- BOS routes
('BOS', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('BOS', 'US', 'United States', 'MAN', 'GB', 'United Kingdom'),
('BOS', 'US', 'United States', 'CDG', 'FR', 'France'),
('BOS', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('BOS', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('BOS', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('BOS', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('BOS', 'US', 'United States', 'BCN', 'ES', 'Spain'),
('BOS', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('BOS', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('BOS', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('BOS', 'US', 'United States', 'SNN', 'IE', 'Ireland'),
('BOS', 'US', 'United States', 'LIS', 'PT', 'Portugal'),
('BOS', 'US', 'United States', 'KEF', 'IS', 'Iceland'),
('BOS', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('BOS', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('BOS', 'US', 'United States', 'TLV', 'IL', 'Israel'),
('BOS', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('BOS', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('BOS', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('BOS', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('BOS', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('BOS', 'US', 'United States', 'AUA', 'AW', 'Aruba'),

-- IAD routes
('IAD', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('IAD', 'US', 'United States', 'CDG', 'FR', 'France'),
('IAD', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('IAD', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('IAD', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('IAD', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('IAD', 'US', 'United States', 'IST', 'TR', 'Turkey'),
('IAD', 'US', 'United States', 'DXB', 'AE', 'United Arab Emirates'),
('IAD', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('IAD', 'US', 'United States', 'ADD', 'ET', 'Ethiopia'),
('IAD', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('IAD', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('IAD', 'US', 'United States', 'PEK', 'CN', 'China'),
('IAD', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('IAD', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('IAD', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('IAD', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('IAD', 'US', 'United States', 'ACC', 'GH', 'Ghana'),

-- DEN routes
('DEN', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('DEN', 'US', 'United States', 'CDG', 'FR', 'France'),
('DEN', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('DEN', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('DEN', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('DEN', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('DEN', 'US', 'United States', 'KEF', 'IS', 'Iceland'),
('DEN', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('DEN', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('DEN', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('DEN', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('DEN', 'US', 'United States', 'SJD', 'MX', 'Mexico'),
('DEN', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('DEN', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),

-- HNL routes
('HNL', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('HNL', 'US', 'United States', 'HND', 'JP', 'Japan'),
('HNL', 'US', 'United States', 'KIX', 'JP', 'Japan'),
('HNL', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('HNL', 'US', 'United States', 'PVG', 'CN', 'China'),
('HNL', 'US', 'United States', 'PEK', 'CN', 'China'),
('HNL', 'US', 'United States', 'TPE', 'TW', 'Taiwan'),
('HNL', 'US', 'United States', 'MNL', 'PH', 'Philippines'),
('HNL', 'US', 'United States', 'SYD', 'AU', 'Australia'),
('HNL', 'US', 'United States', 'AKL', 'NZ', 'New Zealand'),
('HNL', 'US', 'United States', 'NAN', 'FJ', 'Fiji'),
('HNL', 'US', 'United States', 'PPT', 'PF', 'French Polynesia'),

-- MCO routes
('MCO', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('MCO', 'US', 'United States', 'MAN', 'GB', 'United Kingdom'),
('MCO', 'US', 'United States', 'CDG', 'FR', 'France'),
('MCO', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('MCO', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('MCO', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('MCO', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('MCO', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('MCO', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('MCO', 'US', 'United States', 'MBJ', 'JM', 'Jamaica'),
('MCO', 'US', 'United States', 'AUA', 'AW', 'Aruba'),
('MCO', 'US', 'United States', 'PTY', 'PA', 'Panama'),
('MCO', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),
('MCO', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('MCO', 'US', 'United States', 'GRU', 'BR', 'Brazil'),

-- PHX routes
('PHX', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('PHX', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('PHX', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('PHX', 'US', 'United States', 'GDL', 'MX', 'Mexico'),
('PHX', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('PHX', 'US', 'United States', 'SJD', 'MX', 'Mexico'),
('PHX', 'US', 'United States', 'MZT', 'MX', 'Mexico'),
('PHX', 'US', 'United States', 'SJO', 'CR', 'Costa Rica'),

-- LAS routes
('LAS', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('LAS', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('LAS', 'US', 'United States', 'MEX', 'MX', 'Mexico'),
('LAS', 'US', 'United States', 'GDL', 'MX', 'Mexico'),
('LAS', 'US', 'United States', 'PVR', 'MX', 'Mexico'),
('LAS', 'US', 'United States', 'SJD', 'MX', 'Mexico'),

-- FLL routes
('FLL', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('FLL', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('FLL', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('FLL', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),
('FLL', 'US', 'United States', 'MBJ', 'JM', 'Jamaica'),
('FLL', 'US', 'United States', 'AUA', 'AW', 'Aruba'),
('FLL', 'US', 'United States', 'CUR', 'CW', 'Curacao'),
('FLL', 'US', 'United States', 'SXM', 'SX', 'Sint Maarten'),
('FLL', 'US', 'United States', 'BOG', 'CO', 'Colombia'),
('FLL', 'US', 'United States', 'MDE', 'CO', 'Colombia'),

-- CLT routes
('CLT', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('CLT', 'US', 'United States', 'CDG', 'FR', 'France'),
('CLT', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('CLT', 'US', 'United States', 'MUC', 'DE', 'Germany'),
('CLT', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('CLT', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('CLT', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('CLT', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('CLT', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('CLT', 'US', 'United States', 'NAS', 'BS', 'Bahamas'),
('CLT', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),

-- PHL routes
('PHL', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('PHL', 'US', 'United States', 'CDG', 'FR', 'France'),
('PHL', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('PHL', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('PHL', 'US', 'United States', 'MAD', 'ES', 'Spain'),
('PHL', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('PHL', 'US', 'United States', 'ZRH', 'CH', 'Switzerland'),
('PHL', 'US', 'United States', 'DUB', 'IE', 'Ireland'),
('PHL', 'US', 'United States', 'DOH', 'QA', 'Qatar'),
('PHL', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('PHL', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('PHL', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),

-- MSP routes
('MSP', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('MSP', 'US', 'United States', 'CDG', 'FR', 'France'),
('MSP', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('MSP', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('MSP', 'US', 'United States', 'KEF', 'IS', 'Iceland'),
('MSP', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('MSP', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('MSP', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('MSP', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),
('MSP', 'US', 'United States', 'PUJ', 'DO', 'Dominican Republic'),

-- DTW routes
('DTW', 'US', 'United States', 'LHR', 'GB', 'United Kingdom'),
('DTW', 'US', 'United States', 'CDG', 'FR', 'France'),
('DTW', 'US', 'United States', 'FRA', 'DE', 'Germany'),
('DTW', 'US', 'United States', 'AMS', 'NL', 'Netherlands'),
('DTW', 'US', 'United States', 'FCO', 'IT', 'Italy'),
('DTW', 'US', 'United States', 'NRT', 'JP', 'Japan'),
('DTW', 'US', 'United States', 'ICN', 'KR', 'South Korea'),
('DTW', 'US', 'United States', 'PVG', 'CN', 'China'),
('DTW', 'US', 'United States', 'CUN', 'MX', 'Mexico'),
('DTW', 'US', 'United States', 'SJU', 'PR', 'Puerto Rico'),

-- REVERSE ROUTES: Worldwide to US

-- Europe to JFK
('LHR', 'GB', 'United Kingdom', 'JFK', 'US', 'United States'),
('LGW', 'GB', 'United Kingdom', 'JFK', 'US', 'United States'),
('MAN', 'GB', 'United Kingdom', 'JFK', 'US', 'United States'),
('EDI', 'GB', 'United Kingdom', 'JFK', 'US', 'United States'),
('GLA', 'GB', 'United Kingdom', 'JFK', 'US', 'United States'),
('BHX', 'GB', 'United Kingdom', 'JFK', 'US', 'United States'),
('BRS', 'GB', 'United Kingdom', 'JFK', 'US', 'United States'),
('CDG', 'FR', 'France', 'JFK', 'US', 'United States'),
('ORY', 'FR', 'France', 'JFK', 'US', 'United States'),
('NCE', 'FR', 'France', 'JFK', 'US', 'United States'),
('LYS', 'FR', 'France', 'JFK', 'US', 'United States'),
('MRS', 'FR', 'France', 'JFK', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'JFK', 'US', 'United States'),
('MUC', 'DE', 'Germany', 'JFK', 'US', 'United States'),
('DUS', 'DE', 'Germany', 'JFK', 'US', 'United States'),
('BER', 'DE', 'Germany', 'JFK', 'US', 'United States'),
('HAM', 'DE', 'Germany', 'JFK', 'US', 'United States'),
('CGN', 'DE', 'Germany', 'JFK', 'US', 'United States'),
('STR', 'DE', 'Germany', 'JFK', 'US', 'United States'),
('AMS', 'NL', 'Netherlands', 'JFK', 'US', 'United States'),
('BRU', 'BE', 'Belgium', 'JFK', 'US', 'United States'),
('MAD', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('BCN', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('AGP', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('PMI', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('ALC', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('VLC', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('IBZ', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('SVQ', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('TFS', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('LPA', 'ES', 'Spain', 'JFK', 'US', 'United States'),
('FCO', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('MXP', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('VCE', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('NAP', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('BLQ', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('PSA', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('FLR', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('CTA', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('PMO', 'IT', 'Italy', 'JFK', 'US', 'United States'),
('ZRH', 'CH', 'Switzerland', 'JFK', 'US', 'United States'),
('GVA', 'CH', 'Switzerland', 'JFK', 'US', 'United States'),
('BSL', 'CH', 'Switzerland', 'JFK', 'US', 'United States'),
('VIE', 'AT', 'Austria', 'JFK', 'US', 'United States'),
('SZG', 'AT', 'Austria', 'JFK', 'US', 'United States'),
('INN', 'AT', 'Austria', 'JFK', 'US', 'United States'),
('LIS', 'PT', 'Portugal', 'JFK', 'US', 'United States'),
('OPO', 'PT', 'Portugal', 'JFK', 'US', 'United States'),
('FAO', 'PT', 'Portugal', 'JFK', 'US', 'United States'),
('DUB', 'IE', 'Ireland', 'JFK', 'US', 'United States'),
('SNN', 'IE', 'Ireland', 'JFK', 'US', 'United States'),
('ORK', 'IE', 'Ireland', 'JFK', 'US', 'United States'),
('ATH', 'GR', 'Greece', 'JFK', 'US', 'United States'),
('SKG', 'GR', 'Greece', 'JFK', 'US', 'United States'),
('HER', 'GR', 'Greece', 'JFK', 'US', 'United States'),
('RHO', 'GR', 'Greece', 'JFK', 'US', 'United States'),
('CFU', 'GR', 'Greece', 'JFK', 'US', 'United States'),
('JMK', 'GR', 'Greece', 'JFK', 'US', 'United States'),
('JTR', 'GR', 'Greece', 'JFK', 'US', 'United States'),
('IST', 'TR', 'Turkey', 'JFK', 'US', 'United States'),
('AYT', 'TR', 'Turkey', 'JFK', 'US', 'United States'),
('ADB', 'TR', 'Turkey', 'JFK', 'US', 'United States'),
('DLM', 'TR', 'Turkey', 'JFK', 'US', 'United States'),
('BJV', 'TR', 'Turkey', 'JFK', 'US', 'United States'),
('CPH', 'DK', 'Denmark', 'JFK', 'US', 'United States'),
('ARN', 'SE', 'Sweden', 'JFK', 'US', 'United States'),
('GOT', 'SE', 'Sweden', 'JFK', 'US', 'United States'),
('OSL', 'NO', 'Norway', 'JFK', 'US', 'United States'),
('BGO', 'NO', 'Norway', 'JFK', 'US', 'United States'),
('HEL', 'FI', 'Finland', 'JFK', 'US', 'United States'),
('KEF', 'IS', 'Iceland', 'JFK', 'US', 'United States'),
('WAW', 'PL', 'Poland', 'JFK', 'US', 'United States'),
('KRK', 'PL', 'Poland', 'JFK', 'US', 'United States'),
('WRO', 'PL', 'Poland', 'JFK', 'US', 'United States'),
('GDN', 'PL', 'Poland', 'JFK', 'US', 'United States'),
('PRG', 'CZ', 'Czech Republic', 'JFK', 'US', 'United States'),
('BUD', 'HU', 'Hungary', 'JFK', 'US', 'United States'),
('OTP', 'RO', 'Romania', 'JFK', 'US', 'United States'),
('CLJ', 'RO', 'Romania', 'JFK', 'US', 'United States'),
('SOF', 'BG', 'Bulgaria', 'JFK', 'US', 'United States'),
('VAR', 'BG', 'Bulgaria', 'JFK', 'US', 'United States'),
('ZAG', 'HR', 'Croatia', 'JFK', 'US', 'United States'),
('SPU', 'HR', 'Croatia', 'JFK', 'US', 'United States'),
('DBV', 'HR', 'Croatia', 'JFK', 'US', 'United States'),
('BEG', 'RS', 'Serbia', 'JFK', 'US', 'United States'),
('LJU', 'SI', 'Slovenia', 'JFK', 'US', 'United States'),
('RIX', 'LV', 'Latvia', 'JFK', 'US', 'United States'),
('VNO', 'LT', 'Lithuania', 'JFK', 'US', 'United States'),
('TLL', 'EE', 'Estonia', 'JFK', 'US', 'United States'),
('KBP', 'UA', 'Ukraine', 'JFK', 'US', 'United States'),

-- Middle East to JFK
('DXB', 'AE', 'United Arab Emirates', 'JFK', 'US', 'United States'),
('AUH', 'AE', 'United Arab Emirates', 'JFK', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'JFK', 'US', 'United States'),
('TLV', 'IL', 'Israel', 'JFK', 'US', 'United States'),
('AMM', 'JO', 'Jordan', 'JFK', 'US', 'United States'),
('BEY', 'LB', 'Lebanon', 'JFK', 'US', 'United States'),
('KWI', 'KW', 'Kuwait', 'JFK', 'US', 'United States'),
('BAH', 'BH', 'Bahrain', 'JFK', 'US', 'United States'),
('MCT', 'OM', 'Oman', 'JFK', 'US', 'United States'),
('RUH', 'SA', 'Saudi Arabia', 'JFK', 'US', 'United States'),
('JED', 'SA', 'Saudi Arabia', 'JFK', 'US', 'United States'),
('DMM', 'SA', 'Saudi Arabia', 'JFK', 'US', 'United States'),
('CAI', 'EG', 'Egypt', 'JFK', 'US', 'United States'),
('HRG', 'EG', 'Egypt', 'JFK', 'US', 'United States'),
('SSH', 'EG', 'Egypt', 'JFK', 'US', 'United States'),

-- Asia to JFK
('DEL', 'IN', 'India', 'JFK', 'US', 'United States'),
('BOM', 'IN', 'India', 'JFK', 'US', 'United States'),
('BLR', 'IN', 'India', 'JFK', 'US', 'United States'),
('MAA', 'IN', 'India', 'JFK', 'US', 'United States'),
('HYD', 'IN', 'India', 'JFK', 'US', 'United States'),
('CCU', 'IN', 'India', 'JFK', 'US', 'United States'),
('AMD', 'IN', 'India', 'JFK', 'US', 'United States'),
('COK', 'IN', 'India', 'JFK', 'US', 'United States'),
('GOI', 'IN', 'India', 'JFK', 'US', 'United States'),
('JAI', 'IN', 'India', 'JFK', 'US', 'United States'),
('HKG', 'HK', 'Hong Kong', 'JFK', 'US', 'United States'),
('SIN', 'SG', 'Singapore', 'JFK', 'US', 'United States'),
('BKK', 'TH', 'Thailand', 'JFK', 'US', 'United States'),
('HKT', 'TH', 'Thailand', 'JFK', 'US', 'United States'),
('CNX', 'TH', 'Thailand', 'JFK', 'US', 'United States'),
('KUL', 'MY', 'Malaysia', 'JFK', 'US', 'United States'),
('PEN', 'MY', 'Malaysia', 'JFK', 'US', 'United States'),
('LGK', 'MY', 'Malaysia', 'JFK', 'US', 'United States'),
('CGK', 'ID', 'Indonesia', 'JFK', 'US', 'United States'),
('DPS', 'ID', 'Indonesia', 'JFK', 'US', 'United States'),
('SGN', 'VN', 'Vietnam', 'JFK', 'US', 'United States'),
('HAN', 'VN', 'Vietnam', 'JFK', 'US', 'United States'),
('DAD', 'VN', 'Vietnam', 'JFK', 'US', 'United States'),
('MNL', 'PH', 'Philippines', 'JFK', 'US', 'United States'),
('CEB', 'PH', 'Philippines', 'JFK', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'JFK', 'US', 'United States'),
('HND', 'JP', 'Japan', 'JFK', 'US', 'United States'),
('KIX', 'JP', 'Japan', 'JFK', 'US', 'United States'),
('NGO', 'JP', 'Japan', 'JFK', 'US', 'United States'),
('CTS', 'JP', 'Japan', 'JFK', 'US', 'United States'),
('FUK', 'JP', 'Japan', 'JFK', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'JFK', 'US', 'United States'),
('PUS', 'KR', 'South Korea', 'JFK', 'US', 'United States'),
('TPE', 'TW', 'Taiwan', 'JFK', 'US', 'United States'),
('KHH', 'TW', 'Taiwan', 'JFK', 'US', 'United States'),
('CMB', 'LK', 'Sri Lanka', 'JFK', 'US', 'United States'),
('DAC', 'BD', 'Bangladesh', 'JFK', 'US', 'United States'),
('KHI', 'PK', 'Pakistan', 'JFK', 'US', 'United States'),
('LHE', 'PK', 'Pakistan', 'JFK', 'US', 'United States'),
('ISB', 'PK', 'Pakistan', 'JFK', 'US', 'United States'),
('KTM', 'NP', 'Nepal', 'JFK', 'US', 'United States'),
('MLE', 'MV', 'Maldives', 'JFK', 'US', 'United States'),

-- China to JFK
('PVG', 'CN', 'China', 'JFK', 'US', 'United States'),
('PEK', 'CN', 'China', 'JFK', 'US', 'United States'),
('CAN', 'CN', 'China', 'JFK', 'US', 'United States'),
('SZX', 'CN', 'China', 'JFK', 'US', 'United States'),
('CTU', 'CN', 'China', 'JFK', 'US', 'United States'),
('HGH', 'CN', 'China', 'JFK', 'US', 'United States'),
('NKG', 'CN', 'China', 'JFK', 'US', 'United States'),
('XIY', 'CN', 'China', 'JFK', 'US', 'United States'),
('WUH', 'CN', 'China', 'JFK', 'US', 'United States'),
('CKG', 'CN', 'China', 'JFK', 'US', 'United States'),
('XMN', 'CN', 'China', 'JFK', 'US', 'United States'),

-- Australia/Oceania to JFK
('SYD', 'AU', 'Australia', 'JFK', 'US', 'United States'),
('MEL', 'AU', 'Australia', 'JFK', 'US', 'United States'),
('BNE', 'AU', 'Australia', 'JFK', 'US', 'United States'),
('PER', 'AU', 'Australia', 'JFK', 'US', 'United States'),
('ADL', 'AU', 'Australia', 'JFK', 'US', 'United States'),
('AKL', 'NZ', 'New Zealand', 'JFK', 'US', 'United States'),
('CHC', 'NZ', 'New Zealand', 'JFK', 'US', 'United States'),
('WLG', 'NZ', 'New Zealand', 'JFK', 'US', 'United States'),
('ZQN', 'NZ', 'New Zealand', 'JFK', 'US', 'United States'),
('NAN', 'FJ', 'Fiji', 'JFK', 'US', 'United States'),
('PPT', 'PF', 'French Polynesia', 'JFK', 'US', 'United States'),

-- South America to JFK
('GRU', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('GIG', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('BSB', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('CNF', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('REC', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('FOR', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('SSA', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('POA', 'BR', 'Brazil', 'JFK', 'US', 'United States'),
('EZE', 'AR', 'Argentina', 'JFK', 'US', 'United States'),
('SCL', 'CL', 'Chile', 'JFK', 'US', 'United States'),
('LIM', 'PE', 'Peru', 'JFK', 'US', 'United States'),
('CUZ', 'PE', 'Peru', 'JFK', 'US', 'United States'),
('BOG', 'CO', 'Colombia', 'JFK', 'US', 'United States'),
('MDE', 'CO', 'Colombia', 'JFK', 'US', 'United States'),
('CTG', 'CO', 'Colombia', 'JFK', 'US', 'United States'),
('CLO', 'CO', 'Colombia', 'JFK', 'US', 'United States'),
('UIO', 'EC', 'Ecuador', 'JFK', 'US', 'United States'),
('GYE', 'EC', 'Ecuador', 'JFK', 'US', 'United States'),
('CCS', 'VE', 'Venezuela', 'JFK', 'US', 'United States'),
('MVD', 'UY', 'Uruguay', 'JFK', 'US', 'United States'),
('ASU', 'PY', 'Paraguay', 'JFK', 'US', 'United States'),
('VVI', 'BO', 'Bolivia', 'JFK', 'US', 'United States'),
('LPB', 'BO', 'Bolivia', 'JFK', 'US', 'United States'),

-- Central America/Caribbean/Mexico to JFK
('CUN', 'MX', 'Mexico', 'JFK', 'US', 'United States'),
('MEX', 'MX', 'Mexico', 'JFK', 'US', 'United States'),
('GDL', 'MX', 'Mexico', 'JFK', 'US', 'United States'),
('PVR', 'MX', 'Mexico', 'JFK', 'US', 'United States'),
('SJD', 'MX', 'Mexico', 'JFK', 'US', 'United States'),
('PTY', 'PA', 'Panama', 'JFK', 'US', 'United States'),
('SJO', 'CR', 'Costa Rica', 'JFK', 'US', 'United States'),
('LIR', 'CR', 'Costa Rica', 'JFK', 'US', 'United States'),
('GUA', 'GT', 'Guatemala', 'JFK', 'US', 'United States'),
('SAL', 'SV', 'El Salvador', 'JFK', 'US', 'United States'),
('BZE', 'BZ', 'Belize', 'JFK', 'US', 'United States'),
('SJU', 'PR', 'Puerto Rico', 'JFK', 'US', 'United States'),
('NAS', 'BS', 'Bahamas', 'JFK', 'US', 'United States'),
('MBJ', 'JM', 'Jamaica', 'JFK', 'US', 'United States'),
('KIN', 'JM', 'Jamaica', 'JFK', 'US', 'United States'),
('PUJ', 'DO', 'Dominican Republic', 'JFK', 'US', 'United States'),
('SDQ', 'DO', 'Dominican Republic', 'JFK', 'US', 'United States'),
('AUA', 'AW', 'Aruba', 'JFK', 'US', 'United States'),
('CUR', 'CW', 'Curacao', 'JFK', 'US', 'United States'),
('SXM', 'SX', 'Sint Maarten', 'JFK', 'US', 'United States'),
('BGI', 'BB', 'Barbados', 'JFK', 'US', 'United States'),
('POS', 'TT', 'Trinidad and Tobago', 'JFK', 'US', 'United States'),
('UVF', 'LC', 'Saint Lucia', 'JFK', 'US', 'United States'),
('GND', 'GD', 'Grenada', 'JFK', 'US', 'United States'),
('ANU', 'AG', 'Antigua', 'JFK', 'US', 'United States'),
('STT', 'VI', 'US Virgin Islands', 'JFK', 'US', 'United States'),
('GCM', 'KY', 'Cayman Islands', 'JFK', 'US', 'United States'),
('PLS', 'TC', 'Turks and Caicos', 'JFK', 'US', 'United States'),
('BDA', 'BM', 'Bermuda', 'JFK', 'US', 'United States'),

-- Africa to JFK
('CMN', 'MA', 'Morocco', 'JFK', 'US', 'United States'),
('RAK', 'MA', 'Morocco', 'JFK', 'US', 'United States'),
('JNB', 'ZA', 'South Africa', 'JFK', 'US', 'United States'),
('CPT', 'ZA', 'South Africa', 'JFK', 'US', 'United States'),
('ADD', 'ET', 'Ethiopia', 'JFK', 'US', 'United States'),
('NBO', 'KE', 'Kenya', 'JFK', 'US', 'United States'),
('LOS', 'NG', 'Nigeria', 'JFK', 'US', 'United States'),
('ABV', 'NG', 'Nigeria', 'JFK', 'US', 'United States'),
('ACC', 'GH', 'Ghana', 'JFK', 'US', 'United States'),
('DSS', 'SN', 'Senegal', 'JFK', 'US', 'United States'),

-- Europe to LAX
('LHR', 'GB', 'United Kingdom', 'LAX', 'US', 'United States'),
('LGW', 'GB', 'United Kingdom', 'LAX', 'US', 'United States'),
('MAN', 'GB', 'United Kingdom', 'LAX', 'US', 'United States'),
('CDG', 'FR', 'France', 'LAX', 'US', 'United States'),
('NCE', 'FR', 'France', 'LAX', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'LAX', 'US', 'United States'),
('MUC', 'DE', 'Germany', 'LAX', 'US', 'United States'),
('AMS', 'NL', 'Netherlands', 'LAX', 'US', 'United States'),
('MAD', 'ES', 'Spain', 'LAX', 'US', 'United States'),
('BCN', 'ES', 'Spain', 'LAX', 'US', 'United States'),
('FCO', 'IT', 'Italy', 'LAX', 'US', 'United States'),
('MXP', 'IT', 'Italy', 'LAX', 'US', 'United States'),
('ZRH', 'CH', 'Switzerland', 'LAX', 'US', 'United States'),
('VIE', 'AT', 'Austria', 'LAX', 'US', 'United States'),
('DUB', 'IE', 'Ireland', 'LAX', 'US', 'United States'),
('LIS', 'PT', 'Portugal', 'LAX', 'US', 'United States'),
('ATH', 'GR', 'Greece', 'LAX', 'US', 'United States'),
('IST', 'TR', 'Turkey', 'LAX', 'US', 'United States'),
('CPH', 'DK', 'Denmark', 'LAX', 'US', 'United States'),
('ARN', 'SE', 'Sweden', 'LAX', 'US', 'United States'),
('OSL', 'NO', 'Norway', 'LAX', 'US', 'United States'),
('HEL', 'FI', 'Finland', 'LAX', 'US', 'United States'),
('KEF', 'IS', 'Iceland', 'LAX', 'US', 'United States'),
('WAW', 'PL', 'Poland', 'LAX', 'US', 'United States'),
('PRG', 'CZ', 'Czech Republic', 'LAX', 'US', 'United States'),
('BUD', 'HU', 'Hungary', 'LAX', 'US', 'United States'),

-- Middle East to LAX
('DXB', 'AE', 'United Arab Emirates', 'LAX', 'US', 'United States'),
('AUH', 'AE', 'United Arab Emirates', 'LAX', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'LAX', 'US', 'United States'),
('TLV', 'IL', 'Israel', 'LAX', 'US', 'United States'),
('AMM', 'JO', 'Jordan', 'LAX', 'US', 'United States'),
('RUH', 'SA', 'Saudi Arabia', 'LAX', 'US', 'United States'),
('JED', 'SA', 'Saudi Arabia', 'LAX', 'US', 'United States'),
('CAI', 'EG', 'Egypt', 'LAX', 'US', 'United States'),

-- Asia to LAX
('DEL', 'IN', 'India', 'LAX', 'US', 'United States'),
('BOM', 'IN', 'India', 'LAX', 'US', 'United States'),
('BLR', 'IN', 'India', 'LAX', 'US', 'United States'),
('HKG', 'HK', 'Hong Kong', 'LAX', 'US', 'United States'),
('SIN', 'SG', 'Singapore', 'LAX', 'US', 'United States'),
('BKK', 'TH', 'Thailand', 'LAX', 'US', 'United States'),
('HKT', 'TH', 'Thailand', 'LAX', 'US', 'United States'),
('KUL', 'MY', 'Malaysia', 'LAX', 'US', 'United States'),
('CGK', 'ID', 'Indonesia', 'LAX', 'US', 'United States'),
('DPS', 'ID', 'Indonesia', 'LAX', 'US', 'United States'),
('SGN', 'VN', 'Vietnam', 'LAX', 'US', 'United States'),
('HAN', 'VN', 'Vietnam', 'LAX', 'US', 'United States'),
('MNL', 'PH', 'Philippines', 'LAX', 'US', 'United States'),
('CEB', 'PH', 'Philippines', 'LAX', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'LAX', 'US', 'United States'),
('HND', 'JP', 'Japan', 'LAX', 'US', 'United States'),
('KIX', 'JP', 'Japan', 'LAX', 'US', 'United States'),
('NGO', 'JP', 'Japan', 'LAX', 'US', 'United States'),
('CTS', 'JP', 'Japan', 'LAX', 'US', 'United States'),
('FUK', 'JP', 'Japan', 'LAX', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'LAX', 'US', 'United States'),
('PUS', 'KR', 'South Korea', 'LAX', 'US', 'United States'),
('TPE', 'TW', 'Taiwan', 'LAX', 'US', 'United States'),
('CMB', 'LK', 'Sri Lanka', 'LAX', 'US', 'United States'),
('MLE', 'MV', 'Maldives', 'LAX', 'US', 'United States'),

-- China to LAX
('PVG', 'CN', 'China', 'LAX', 'US', 'United States'),
('PEK', 'CN', 'China', 'LAX', 'US', 'United States'),
('CAN', 'CN', 'China', 'LAX', 'US', 'United States'),
('SZX', 'CN', 'China', 'LAX', 'US', 'United States'),
('CTU', 'CN', 'China', 'LAX', 'US', 'United States'),
('HGH', 'CN', 'China', 'LAX', 'US', 'United States'),
('NKG', 'CN', 'China', 'LAX', 'US', 'United States'),
('XIY', 'CN', 'China', 'LAX', 'US', 'United States'),
('CKG', 'CN', 'China', 'LAX', 'US', 'United States'),
('XMN', 'CN', 'China', 'LAX', 'US', 'United States'),

-- Australia/Oceania to LAX
('SYD', 'AU', 'Australia', 'LAX', 'US', 'United States'),
('MEL', 'AU', 'Australia', 'LAX', 'US', 'United States'),
('BNE', 'AU', 'Australia', 'LAX', 'US', 'United States'),
('PER', 'AU', 'Australia', 'LAX', 'US', 'United States'),
('AKL', 'NZ', 'New Zealand', 'LAX', 'US', 'United States'),
('CHC', 'NZ', 'New Zealand', 'LAX', 'US', 'United States'),
('NAN', 'FJ', 'Fiji', 'LAX', 'US', 'United States'),
('PPT', 'PF', 'French Polynesia', 'LAX', 'US', 'United States'),

-- South America to LAX
('GRU', 'BR', 'Brazil', 'LAX', 'US', 'United States'),
('GIG', 'BR', 'Brazil', 'LAX', 'US', 'United States'),
('EZE', 'AR', 'Argentina', 'LAX', 'US', 'United States'),
('SCL', 'CL', 'Chile', 'LAX', 'US', 'United States'),
('LIM', 'PE', 'Peru', 'LAX', 'US', 'United States'),
('BOG', 'CO', 'Colombia', 'LAX', 'US', 'United States'),
('MDE', 'CO', 'Colombia', 'LAX', 'US', 'United States'),
('UIO', 'EC', 'Ecuador', 'LAX', 'US', 'United States'),

-- Mexico/Central America to LAX
('CUN', 'MX', 'Mexico', 'LAX', 'US', 'United States'),
('MEX', 'MX', 'Mexico', 'LAX', 'US', 'United States'),
('GDL', 'MX', 'Mexico', 'LAX', 'US', 'United States'),
('PVR', 'MX', 'Mexico', 'LAX', 'US', 'United States'),
('SJD', 'MX', 'Mexico', 'LAX', 'US', 'United States'),
('MZT', 'MX', 'Mexico', 'LAX', 'US', 'United States'),
('ZIH', 'MX', 'Mexico', 'LAX', 'US', 'United States'),
('PTY', 'PA', 'Panama', 'LAX', 'US', 'United States'),
('SJO', 'CR', 'Costa Rica', 'LAX', 'US', 'United States'),
('GUA', 'GT', 'Guatemala', 'LAX', 'US', 'United States'),
('SAL', 'SV', 'El Salvador', 'LAX', 'US', 'United States'),

-- Major routes to other US hubs (SFO, ORD, MIA, ATL, DFW)
('LHR', 'GB', 'United Kingdom', 'SFO', 'US', 'United States'),
('CDG', 'FR', 'France', 'SFO', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'SFO', 'US', 'United States'),
('AMS', 'NL', 'Netherlands', 'SFO', 'US', 'United States'),
('DXB', 'AE', 'United Arab Emirates', 'SFO', 'US', 'United States'),
('HKG', 'HK', 'Hong Kong', 'SFO', 'US', 'United States'),
('SIN', 'SG', 'Singapore', 'SFO', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'SFO', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'SFO', 'US', 'United States'),
('PVG', 'CN', 'China', 'SFO', 'US', 'United States'),
('SYD', 'AU', 'Australia', 'SFO', 'US', 'United States'),
('MEL', 'AU', 'Australia', 'SFO', 'US', 'United States'),
('AKL', 'NZ', 'New Zealand', 'SFO', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'ORD', 'US', 'United States'),
('CDG', 'FR', 'France', 'ORD', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'ORD', 'US', 'United States'),
('AMS', 'NL', 'Netherlands', 'ORD', 'US', 'United States'),
('DXB', 'AE', 'United Arab Emirates', 'ORD', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'ORD', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'ORD', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'ORD', 'US', 'United States'),
('PVG', 'CN', 'China', 'ORD', 'US', 'United States'),
('DEL', 'IN', 'India', 'ORD', 'US', 'United States'),
('GRU', 'BR', 'Brazil', 'ORD', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'MIA', 'US', 'United States'),
('CDG', 'FR', 'France', 'MIA', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'MIA', 'US', 'United States'),
('MAD', 'ES', 'Spain', 'MIA', 'US', 'United States'),
('DXB', 'AE', 'United Arab Emirates', 'MIA', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'MIA', 'US', 'United States'),
('GRU', 'BR', 'Brazil', 'MIA', 'US', 'United States'),
('EZE', 'AR', 'Argentina', 'MIA', 'US', 'United States'),
('BOG', 'CO', 'Colombia', 'MIA', 'US', 'United States'),
('LIM', 'PE', 'Peru', 'MIA', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'ATL', 'US', 'United States'),
('CDG', 'FR', 'France', 'ATL', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'ATL', 'US', 'United States'),
('AMS', 'NL', 'Netherlands', 'ATL', 'US', 'United States'),
('DXB', 'AE', 'United Arab Emirates', 'ATL', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'ATL', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'ATL', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'ATL', 'US', 'United States'),
('JNB', 'ZA', 'South Africa', 'ATL', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'DFW', 'US', 'United States'),
('CDG', 'FR', 'France', 'DFW', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'DFW', 'US', 'United States'),
('DXB', 'AE', 'United Arab Emirates', 'DFW', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'DFW', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'DFW', 'US', 'United States'),
('HKG', 'HK', 'Hong Kong', 'DFW', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'DFW', 'US', 'United States'),
('PVG', 'CN', 'China', 'DFW', 'US', 'United States'),
('SYD', 'AU', 'Australia', 'DFW', 'US', 'United States'),
('GRU', 'BR', 'Brazil', 'DFW', 'US', 'United States'),

-- Routes to secondary US hubs (EWR, SEA, BOS, IAD, DEN, HNL)
('LHR', 'GB', 'United Kingdom', 'EWR', 'US', 'United States'),
('CDG', 'FR', 'France', 'EWR', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'EWR', 'US', 'United States'),
('AMS', 'NL', 'Netherlands', 'EWR', 'US', 'United States'),
('TLV', 'IL', 'Israel', 'EWR', 'US', 'United States'),
('DEL', 'IN', 'India', 'EWR', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'EWR', 'US', 'United States'),
('PVG', 'CN', 'China', 'EWR', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'SEA', 'US', 'United States'),
('CDG', 'FR', 'France', 'SEA', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'SEA', 'US', 'United States'),
('AMS', 'NL', 'Netherlands', 'SEA', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'SEA', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'SEA', 'US', 'United States'),
('PVG', 'CN', 'China', 'SEA', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'BOS', 'US', 'United States'),
('CDG', 'FR', 'France', 'BOS', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'BOS', 'US', 'United States'),
('DUB', 'IE', 'Ireland', 'BOS', 'US', 'United States'),
('DXB', 'AE', 'United Arab Emirates', 'BOS', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'BOS', 'US', 'United States'),
('TLV', 'IL', 'Israel', 'BOS', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'IAD', 'US', 'United States'),
('CDG', 'FR', 'France', 'IAD', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'IAD', 'US', 'United States'),
('DXB', 'AE', 'United Arab Emirates', 'IAD', 'US', 'United States'),
('DOH', 'QA', 'Qatar', 'IAD', 'US', 'United States'),
('ADD', 'ET', 'Ethiopia', 'IAD', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'IAD', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'IAD', 'US', 'United States'),

('LHR', 'GB', 'United Kingdom', 'DEN', 'US', 'United States'),
('CDG', 'FR', 'France', 'DEN', 'US', 'United States'),
('FRA', 'DE', 'Germany', 'DEN', 'US', 'United States'),
('MUC', 'DE', 'Germany', 'DEN', 'US', 'United States'),
('NRT', 'JP', 'Japan', 'DEN', 'US', 'United States'),

('NRT', 'JP', 'Japan', 'HNL', 'US', 'United States'),
('HND', 'JP', 'Japan', 'HNL', 'US', 'United States'),
('ICN', 'KR', 'South Korea', 'HNL', 'US', 'United States'),
('PVG', 'CN', 'China', 'HNL', 'US', 'United States'),
('TPE', 'TW', 'Taiwan', 'HNL', 'US', 'United States'),
('MNL', 'PH', 'Philippines', 'HNL', 'US', 'United States'),
('SYD', 'AU', 'Australia', 'HNL', 'US', 'United States'),
('AKL', 'NZ', 'New Zealand', 'HNL', 'US', 'United States'),
('NAN', 'FJ', 'Fiji', 'HNL', 'US', 'United States'),
('PPT', 'PF', 'French Polynesia', 'HNL', 'US', 'United States');
