Skip to content

Instantly share code, notes, and snippets.

@karimcambridge
Last active May 25, 2023 11:15
Show Gist options
  • Save karimcambridge/afff2a4c2344b4a5add1a06d8af96ccf to your computer and use it in GitHub Desktop.
Save karimcambridge/afff2a4c2344b4a5add1a06d8af96ccf to your computer and use it in GitHub Desktop.
Countries
INSERT INTO `countries` (`country_code`, `country_name`, `dial_code`, `currency_name`, `currency_symbol`, `currency_code`, `timezone`, `timezone_name`, `enabled`) VALUES
('AF', 'Afghanistan', '+93', 'Afghan afghani', '؋', 'AFN', '+04:30', NULL, 0),
('AX', 'Åland Islands', '+358', 'Euro', '€', 'EUR', '+03:00', NULL, 0),
('AL', 'Albania', '+355', 'Albanian lek', 'L', 'ALL', '+01:00', NULL, 0),
('DZ', 'Algeria', '+213', 'Algerian dinar', 'د.ج', 'DZD', '+01:00', NULL, 0),
('AS', 'American Samoa', '+1684', '', '', 'USD', '-11:00', NULL, 0),
('AD', 'Andorra', '+376', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('AO', 'Angola', '+244', 'Angolan kwanza', 'Kz', 'AOA', '+01:00', NULL, 0),
('AI', 'Anguilla', '+1264', 'East Caribbean dollar', '$', 'XCD', '-04:00', NULL, 0),
('AQ', 'Antarctica', '+672', '', '', '', NULL, NULL, 0),
('AG', 'Antigua and Barbuda', '+1268', 'East Caribbean dollar', '$', 'XCD', '-04:00', NULL, 0),
('AR', 'Argentina', '+54', 'Argentine peso', '$', 'ARS', '-03:00', NULL, 0),
('AM', 'Armenia', '+374', 'Armenian dram', '', 'AMD', '+04:00', NULL, 0),
('AW', 'Aruba', '+297', 'Aruban florin', 'ƒ', 'AWG', '-04:00', NULL, 0),
('AU', 'Australia', '+61', 'Australian dollar', '$', 'AUD', '+11:00', NULL, 0),
('AT', 'Austria', '+43', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('AZ', 'Azerbaijan', '+994', 'Azerbaijani manat', '₼', 'AZN', '+04:00', NULL, 0),
('BS', 'Bahamas', '+1242', 'Bahamian', '$', 'BSD', '-04:00', NULL, 0),
('BH', 'Bahrain', '+973', 'Bahraini dinar', '.د.ب', 'BHD', '+03:00', NULL, 0),
('BD', 'Bangladesh', '+880', 'Bangladeshi taka', '৳', 'BDT', '+06:00', NULL, 0),
('BB', 'Barbados', '+1246', 'Barbadian dollar', '$', 'BBD', '-04:00', 'America/Barbados', 0),
('BY', 'Belarus', '+375', 'Belarusian ruble', 'Br', 'BYR', '+03:00', NULL, 0),
('BE', 'Belgium', '+32', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('BZ', 'Belize', '+501', 'Belize dollar', '$', 'BZD', '-06:00', NULL, 0),
('BJ', 'Benin', '+229', 'West African CFA franc', 'Fr', 'XOF', '+01:00', NULL, 0),
('BM', 'Bermuda', '+1441', 'Bermudian dollar', '$', 'BMD', '-04:00', NULL, 0),
('BT', 'Bhutan', '+975', 'Bhutanese ngultrum', 'Nu.', 'BTN', '+06:00', NULL, 0),
('BO', 'Bolivia (Plurinational State of Bolivia)', '+591', 'Bolivian Boliviano', 's', 'BOB', '-04:00', NULL, 0),
('BA', 'Bosnia and Herzegovi', '+387', 'Bosnian Mark', 'KM', 'BAM', '+01:00', NULL, 0),
('BW', 'Botswana', '+267', 'Botswana pula', 'P', 'BWP', '+02:00', NULL, 0),
('BV', 'Bouvet Island', '', '', '', '', '+02:00', NULL, 0),
('BR', 'Brazil', '+55', 'Brazilian real', 'R$', 'BRL', '-02:00', NULL, 0),
('IO', 'British Indian Ocean Territory', '+246', '', '', 'USD', NULL, NULL, 0),
('BN', 'Brunei Darussalam', '+673', 'Brunei Dollar', '$', 'BND', '+08:00', NULL, 0),
('BG', 'Bulgaria', '+359', 'Bulgarian lev', 'лв', 'BGN', '+02:00', NULL, 0),
('BF', 'Burkina Faso', '+226', 'West African CFA franc', 'Fr', 'XOF', '+00:00', NULL, 0),
('BI', 'Burundi', '+257', 'Burundian franc', 'Fr', 'BIF', '+02:00', NULL, 0),
('KH', 'Cambodia', '+855', 'Cambodian riel', '៛', 'KHR', '+07:00', NULL, 0),
('CM', 'Cameroon', '+237', 'Central African CFA ', 'Fr', 'XAF', '+01:00', NULL, 0),
('CA', 'Canada', '+1', 'Canadian dollar', '$', 'CAD', '-03:30', NULL, 0),
('CV', 'Cape Verde', '+238', 'Cape Verdean escudo', 'Esc or $', 'CVE', '-01:00', NULL, 0),
('KY', 'Cayman Islands', '+345', 'Cayman Islands dollar', '$', 'KYD', '-05:00', NULL, 0),
('CF', 'Central African Republic', '+236', 'Central African CFA', 'Fr', 'XAF', '+01:00', NULL, 0),
('TD', 'Chad', '+235', 'Central African CFA ', 'Fr', 'XAF', '+01:00', NULL, 0),
('CL', 'Chile', '+56', 'Chilean peso', '$', 'CLP', '-04:00', NULL, 0),
('CN', 'China', '+86', 'Chinese yuan', '¥ or 元', 'CNY', '+08:00', NULL, 0),
('CX', 'Christmas Island', '+61', '', '', 'AUD', '+07:00', NULL, 0),
('CC', 'Cocos (Keeling) Islands', '+61', '', '', 'AUD', '+06:30', NULL, 0),
('CO', 'Colombia', '+57', 'Colombian peso', '$', 'COP', '-05:00', NULL, 0),
('KM', 'Comoros', '+269', 'Comorian franc', 'Fr', 'KMF', '+03:00', NULL, 0),
('CG', 'Republic of the Congo', '+242', '', '', 'XAF', '+01:00', NULL, 0),
('CD', 'Democratic Republic of the Congo', '+243', '', '', 'CDF', '+01:00', NULL, 0),
('CK', 'Cook Islands', '+682', 'New Zealand dollar', '$', 'NZD', '-10:00', NULL, 0),
('CR', 'Costa Rica', '+506', 'Costa Rican colón', '₡', 'CRC', '-06:00', NULL, 0),
('CI', 'Cote d\'Ivoire', '+225', 'West African CFA franc', 'Fr', 'XOF', '+00:00', NULL, 0),
('HR', 'Croatia', '+385', 'Croatian kuna', 'kn', 'HRK', '+01:00', NULL, 0),
('CU', 'Cuba', '+53', 'Cuban convertible pe', '$', 'CUC', '-05:00', NULL, 0),
('CY', 'Cyprus', '+357', 'Euro', '€', 'EUR', '+02:00', NULL, 0),
('CZ', 'Czech Republic', '+420', 'Czech koruna', 'Kč', 'CZK', '+01:00', NULL, 0),
('DK', 'Denmark', '+45', 'Danish krone', 'kr', 'DKK', '+01:00', NULL, 0),
('DJ', 'Djibouti', '+253', 'Djiboutian franc', 'Fr', 'DJF', '+03:00', NULL, 0),
('DM', 'Dominica', '+1767', 'East Caribbean dollar', '$', 'XCD', '-04:00', NULL, 0),
('DO', 'Dominican Republic', '+1849', 'Dominican peso', '$', 'DOP', '-04:00', NULL, 0),
('EC', 'Ecuador', '+593', 'United States dollar', '$', 'USD', '-05:00', NULL, 0),
('EG', 'Egypt', '+20', 'Egyptian pound', '£ or ج.م', 'EGP', '+02:00', NULL, 0),
('SV', 'El Salvador', '+503', 'United States dollar', '$', 'USD', '-06:00', NULL, 0),
('GQ', 'Equatorial Guinea', '+240', 'Central African CFA ', 'Fr', 'XAF', '+01:00', NULL, 0),
('ER', 'Eritrea', '+291', 'Eritrean nakfa', 'Nfk', 'ERN', '+03:00', NULL, 0),
('EE', 'Estonia', '+372', 'Euro', '€', 'EUR', '+02:00', NULL, 0),
('ET', 'Ethiopia', '+251', 'Ethiopian birr', 'Br', 'ETB', '+03:00', NULL, 0),
('FK', 'Falkland Islands (Malvinas)', '+500', '', '', 'FKP', '-03:00', NULL, 0),
('FO', 'Faroe Islands', '+298', 'Danish krone', 'kr', 'DKK', '+00:00', NULL, 0),
('FJ', 'Fiji', '+679', 'Fijian dollar', '$', 'FJD', '+12:00', NULL, 0),
('FI', 'Finland', '+358', 'Euro', '€', 'EUR', '+02:00', NULL, 0),
('FR', 'France', '+33', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('GF', 'French Guiana', '+594', '', '', 'EUR', '-03:00', NULL, 0),
('PF', 'French Polynesia', '+689', 'CFP franc', 'Fr', 'XPF', NULL, NULL, 0),
('TF', 'French Southern Territories', '', '', '', '', NULL, NULL, 0),
('GA', 'Gabon', '+241', 'Central African CFA', 'Fr', 'XAF', '+01:00', NULL, 0),
('GM', 'Gambia', '+220', '', '', 'GMD', '+00:00', NULL, 0),
('GE', 'Georgia', '+995', 'Georgian lari', 'ლ', 'GEL', '+04:00', NULL, 0),
('DE', 'Germany', '+49', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('GH', 'Ghana', '+233', 'Ghana cedi', '₵', 'GHS', '+00:00', NULL, 0),
('GI', 'Gibraltar', '+350', 'Gibraltar pound', '£', 'GIP', '+01:00', NULL, 0),
('GR', 'Greece', '+30', 'Euro', '€', 'EUR', '+02:00', NULL, 0),
('GL', 'Greenland', '+299', 'Danish krone', 'kr', 'DKK', '-03:00', NULL, 0),
('GD', 'Grenada', '+1473', 'East Caribbean Dollar', '$', 'XCD', '-04:00', 'America/Grenada', 0),
('GP', 'Guadeloupe', '+590', '', '', 'EUR', '-04:00', NULL, 0),
('GU', 'Guam', '+1671', '', '', 'USD', '+10:00', NULL, 0),
('GT', 'Guatemala', '+502', 'Guatemalan quetzal', 'Q', 'GTQ', '-06:00', NULL, 0),
('GG', 'Guernsey', '+44', 'British pound', '£', 'GBP', '+00:00', NULL, 0),
('GN', 'Guinea', '+224', 'Guinean franc', 'Fr', 'GNF', '+00:00', NULL, 0),
('GW', 'Guinea-Bissau', '+245', 'West African CFA franc', 'Fr', 'XOF', '+00:00', NULL, 0),
('GY', 'Guyana', '+595', 'Guyanese dollar', '$', 'GYD', '-04:00', NULL, 0),
('HM', 'Heard Island and Mcdonald Islands', '', '', '', '', NULL, NULL, 0),
('HT', 'Haiti', '+509', 'Haitian gourde', 'G', 'HTG', '-05:00', NULL, 0),
('VA', 'Vatican City (Holy See)', '+379', '', '', 'EUR', '+01:00', NULL, 0),
('HN', 'Honduras', '+504', 'Honduran lempira', 'L', 'HNL', '-06:00', NULL, 0),
('HK', 'Hong Kong', '+852', 'Hong Kong dollar', '$', 'HKD', '+08:00', NULL, 0),
('HU', 'Hungary', '+36', 'Hungarian forint', 'Ft', 'HUF', '+01:00', NULL, 0),
('IS', 'Iceland', '+354', 'Icelandic króna', 'kr', 'ISK', '+00:00', NULL, 0),
('IN', 'India', '+91', 'Indian rupee', '₹', 'INR', '+05:30', NULL, 0),
('ID', 'Indonesia', '+62', 'Indonesian rupiah', 'Rp', 'IDR', '+07:00', NULL, 0),
('IR', 'Iran, Islamic Republic', '+98', 'Iranian rial', 'ریال', 'IRR', '+03:30', NULL, 0),
('IQ', 'Iraq', '+964', 'Iraqi dinar', 'ع.د', 'IQD', '+03:00', NULL, 0),
('IE', 'Ireland', '+353', 'Euro', '€', 'EUR', '+00:00', NULL, 0),
('IM', 'Isle of Man', '+44', 'British pound', '£', 'GBP', NULL, NULL, 0),
('IL', 'Israel', '+972', 'Israeli new shekel', '₪', 'ILS', '+02:00', NULL, 0),
('IT', 'Italy', '+39', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('JM', 'Jamaica', '+1876', 'Jamaican dollar', '$', 'JMD', '-05:00', NULL, 0),
('JP', 'Japan', '+81', 'Japanese yen', '¥', 'JPY', '+09:00', NULL, 0),
('JE', 'Jersey', '+44', 'British pound', '£', 'GBP', NULL, NULL, 0),
('JO', 'Jordan', '+962', 'Jordanian dinar', 'د.ا', 'JOD', '+02:00', NULL, 0),
('KZ', 'Kazakhstan', '+7 7', 'Kazakhstani tenge', '', 'KZT', '+06:00', NULL, 0),
('KE', 'Kenya', '+254', 'Kenyan shilling', 'Sh', 'KES', '+03:00', NULL, 0),
('KI', 'Kiribati', '+686', 'Australian dollar', '$', 'AUD', NULL, NULL, 0),
('KP', 'North Korea', '+850', '', '', 'KPW', '+09:00', NULL, 0),
('KR', 'South Korea', '+82', '', '', 'KRW', '+09:00', NULL, 0),
('KW', 'Kuwait', '+965', 'Kuwaiti dinar', 'د.ك', 'KWD', '+03:00', NULL, 0),
('KG', 'Kyrgyzstan', '+996', 'Kyrgyzstani som', 'лв', 'KGS', '+06:00', NULL, 0),
('LA', 'Laos (Lao People\'s Democratic Republic)', '+856', 'Lao kip', '₭', 'LAK', '+07:00', NULL, 0),
('LV', 'Latvia', '+371', 'Euro', '€', 'EUR', '+02:00', NULL, 0),
('LB', 'Lebanon', '+961', 'Lebanese pound', 'ل.ل', 'LBP', '+02:00', NULL, 0),
('LS', 'Lesotho', '+266', 'Lesotho loti', 'L', 'LSL', NULL, NULL, 0),
('LR', 'Liberia', '+231', 'Liberian dollar', '$', 'LRD', NULL, NULL, 0),
('LY', 'Libya', '+218', '', '', 'LYD', '+02:00', NULL, 0),
('LI', 'Liechtenstein', '+423', 'Swiss franc', 'Fr', 'CHF', '+01:00', NULL, 0),
('LT', 'Lithuania', '+370', 'Euro', '€', 'EUR', '+02:00', NULL, 0),
('LU', 'Luxembourg', '+352', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('MO', 'Macao', '+853', '', '', 'MOP', '+08:00', NULL, 0),
('MK', 'North Macedonia', '+389', '', '', 'MKD', '+01:00', NULL, 0),
('MG', 'Madagascar', '+261', 'Malagasy ariary', 'Ar', 'MGA', '+03:00', NULL, 0),
('MW', 'Malawi', '+265', 'Malawian kwacha', 'MK', 'MWK', '+02:00', NULL, 0),
('MY', 'Malaysia', '+60', 'Malaysian ringgit', 'RM', 'MYR', '+08:00', NULL, 0),
('MV', 'Maldives', '+960', 'Maldivian rufiyaa', '.ރ', 'MVR', '+05:00', NULL, 0),
('ML', 'Mali', '+223', 'West African CFA franc', 'Fr', 'XOF', '+00:00', NULL, 0),
('MT', 'Malta', '+356', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('MH', 'Marshall Islands', '+692', 'United States dollar', '$', 'USD', '+12:00', NULL, 0),
('MQ', 'Martinique', '+596', '', '', 'EUR', '-04:00', NULL, 0),
('MR', 'Mauritania', '+222', 'Mauritanian ouguiya', 'UM', 'MRO', NULL, NULL, 0),
('MU', 'Mauritius', '+230', 'Mauritian rupee', '₨', 'MUR', NULL, NULL, 0),
('YT', 'Mayotte', '+262', '', '', 'EUR', NULL, NULL, 0),
('MX', 'Mexico', '+52', 'Mexican peso', '$', 'MXN', '-06:00', NULL, 0),
('FM', 'Micronesia', '+691', '', '', 'USD', '+11:00', NULL, 0),
('MD', 'Moldova', '+373', 'Moldovan leu', 'L', 'MDL', '+02:00', NULL, 0),
('MC', 'Monaco', '+377', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('MN', 'Mongolia', '+976', 'Mongolian tögrög', '₮', 'MNT', '+08:00', NULL, 0),
('ME', 'Montenegro', '+382', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('MS', 'Montserrat', '+1664', 'East Caribbean dollar', '$', 'XCD', '-04:00', NULL, 0),
('MA', 'Morocco', '+212', 'Moroccan dirham', 'د.م.', 'MAD', '+00:00', NULL, 0),
('MZ', 'Mozambique', '+258', 'Mozambican metical', 'MT', 'MZN', '+02:00', NULL, 0),
('MM', 'Myanmar', '+95', 'Burmese kyat', 'Ks', 'MMK', '+06:30', NULL, 0),
('NA', 'Namibia', '+264', 'Namibian dollar', '$', 'NAD', NULL, NULL, 0),
('NR', 'Nauru', '+674', 'Australian dollar', '$', 'AUD', NULL, NULL, 0),
('NP', 'Nepal', '+977', 'Nepalese rupee', '₨', 'NPR', '+05:45', NULL, 0),
('NL', 'Netherlands', '+31', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('AN', 'Netherlands Antilles', '+599', '', '', 'EUR', '-04:00', NULL, 0),
('NC', 'New Caledonia', '+687', 'CFP franc', 'Fr', 'XPF', '+11:00', NULL, 0),
('NZ', 'New Zealand', '+64', 'New Zealand dollar', '$', 'NZD', '+12:00', NULL, 0),
('NI', 'Nicaragua', '+505', 'Nicaraguan córdoba', 'C$', 'NIO', '-06:00', NULL, 0),
('NE', 'Niger', '+227', 'West African CFA franc', 'Fr', 'XOF', '+01:00', NULL, 0),
('NG', 'Nigeria', '+234', 'Nigerian naira', '₦', 'NGN', '+01:00', NULL, 0),
('NU', 'Niue', '+683', 'New Zealand dollar', '$', 'NZD', '-11:00', NULL, 0),
('NF', 'Norfolk Island', '+672', '', '', 'AUD', '+11:00', NULL, 0),
('MP', 'Northern Mariana Islands', '+1670', '', '', 'USD', '+10:00', NULL, 0),
('NO', 'Norway', '+47', 'Norwegian krone', 'kr', 'NOK', '+01:00', NULL, 0),
('OM', 'Oman', '+968', 'Omani rial', 'ر.ع.', 'OMR', '+04:00', NULL, 0),
('PK', 'Pakistan', '+92', 'Pakistani rupee', '₨', 'PKR', '+05:00', NULL, 0),
('PW', 'Palau', '+680', 'Palauan dollar', '$', '', '+09:00', NULL, 0),
('PS', 'Occupied Palestinian Territory', '+970', '', '', 'ILS', '+03:00', NULL, 0),
('PA', 'Panama', '+507', 'Panamanian balboa', 'B/.', 'PAB', '-05:00', NULL, 0),
('PG', 'Papua New Guinea', '+675', 'Papua New Guinean ki', 'K', 'PGK', '+10:00', NULL, 0),
('PY', 'Paraguay', '+595', 'Paraguayan guaraní', '₲', 'PYG', '-04:00', NULL, 0),
('PE', 'Peru', '+51', 'Peruvian nuevo sol', 'S/.', 'PEN', '-05:00', NULL, 0),
('PH', 'Philippines', '+63', 'Philippine peso', '₱', 'PHP', '+08:00', NULL, 0),
('PN', 'Pitcairn Islands', '+872', '', '', 'NZD', '-08:00', NULL, 0),
('PL', 'Poland', '+48', 'Polish z?oty', 'zł', 'PLN', '+01:00', NULL, 0),
('PT', 'Portugal', '+351', 'Euro', '€', 'EUR', '+00:00', NULL, 0),
('PR', 'Puerto Rico', '+1939', '', '', 'USD', '-04:00', NULL, 0),
('QA', 'Qatar', '+974', 'Qatari riyal', 'ر.ق', 'QAR', '+03:00', NULL, 0),
('RE', 'Réunion', '+262', '', '', 'EUR', '+04:00', NULL, 0),
('RO', 'Romania', '+40', 'Romanian leu', 'lei', 'RON', '+02:00', NULL, 0),
('RU', 'Russia', '+7', 'Russian ruble', '', 'RUB', '+02:00', NULL, 0),
('RW', 'Rwanda', '+250', 'Rwandan franc', 'Fr', 'RWF', '+02:00', NULL, 0),
('BL', 'Saint Barthélemy', '+590', '', '', 'EUR', '-04:00', NULL, 0),
('SH', 'Saint Helena, Ascension and Tristan da Cunha', '+290', '', '', 'SHP', '-04:00', NULL, 0),
('KN', 'Saint Kitts and Nevis', '+1869', 'East Caribbean dollar', '$', 'XCD', '-04:00', NULL, 0),
('LC', 'Saint Lucia', '+1758', 'East Caribbean dollar', '$', 'XCD', '-04:00', NULL, 0),
('MF', 'Saint Martin', '+590', '', '', 'EUR', '-04:00', NULL, 0),
('PM', 'Saint Pierre and Miquelon', '+508', '', '', 'EUR', '-03:00', NULL, 0),
('VC', 'Saint Vincent and the Grenadines', '+1784', 'East Caribbean dollar', '$', 'XCD', '-04:00', 'America/St_Vincent', 1),
('WS', 'Samoa', '+685', 'Samoan tālā', 'T', 'WST', '+13:00', NULL, 0),
('SM', 'San Marino', '+378', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('ST', 'Sao Tome and Principe', '+239', '', '', '', '+00:00', NULL, 0),
('SA', 'Saudi Arabia', '+966', 'Saudi riyal', 'ر.س', 'SAR', '+03:00', NULL, 0),
('SN', 'Senegal', '+221', 'West African CFA franc', 'Fr', 'XOF', '+00:00', NULL, 0),
('RS', 'Serbia', '+381', 'Serbian dinar', 'дин. or din.', 'RSD', '+01:00', NULL, 0),
('SC', 'Seychelles', '+248', 'Seychellois rupee', '₨', 'SCR', '+04:00', NULL, 0),
('SL', 'Sierra Leone', '+232', 'Sierra Leonean leone', 'Le', 'SLL', '+00:00', NULL, 0),
('SG', 'Singapore', '+65', 'Brunei dollar', '$', 'BND', '+08:00', NULL, 0),
('SK', 'Slovakia', '+421', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('SI', 'Slovenia', '+386', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('SB', 'Solomon Islands', '+677', 'Solomon Islands doll', '$', 'SBD', '+11:00', NULL, 0),
('SO', 'Somalia', '+252', 'Somali shilling', 'Sh', 'SOS', '+03:00', NULL, 0),
('ZA', 'South Africa', '+27', 'South African rand', 'R', 'ZAR', '+02:00', NULL, 0),
('GS', 'South Georgia and the South Sandwich Islands', '+500', '', '', 'GBP', '-02:00', NULL, 0),
('ES', 'Spain', '+34', 'Euro', '€', 'EUR', '+01:00', NULL, 0),
('LK', 'Sri Lanka', '+94', 'Sri Lankan rupee', 'Rs or රු', 'LKR', '+05:30', NULL, 0),
('SD', 'Sudan', '+249', 'Sudanese pound', 'ج.س.', 'SDG', '+02:00', NULL, 0),
('SR', 'Suriname', '+597', 'Surinamese dollar', '$', 'SRD', '-03:00', NULL, 0),
('SJ', 'Svalbard and Jan Mayen', '+47', '', '', 'NOK', '+02:00', NULL, 0),
('SZ', 'Eswatini (Swaziland)', '+268', 'Swazi lilangeni', 'L', 'SZL', '+02:00', NULL, 0),
('SE', 'Sweden', '+46', 'Swedish krona', 'kr', 'SEK', '+01:00', NULL, 0),
('CH', 'Switzerland', '+41', 'Swiss franc', 'Fr', 'CHF', '+01:00', NULL, 0),
('SY', 'Syria, Syrian Arab Republic', '+963', '', '', 'SYP', '+02:00', NULL, 0),
('TW', 'Taiwan, Republic of China', '+886', 'New Taiwan dollar', '$', 'TWD', '+08:00', NULL, 0),
('TJ', 'Tajikistan', '+992', 'Tajikistani somoni', 'ЅМ', 'TJS', '+05:00', NULL, 0),
('TZ', 'Tanzania', '+255', '', '', 'TZS', '+03:00', NULL, 0),
('TH', 'Thailand', '+66', 'Thai baht', '฿', 'THB', '+07:00', NULL, 0),
('TL', 'Timor-Leste', '+670', '', '', 'USD', '+09:00', NULL, 0),
('TG', 'Togo', '+228', 'West African CFA franc', 'Fr', 'XOF', '+00:00', NULL, 0),
('TK', 'Tokelau', '+690', 'New Zealand dollar', '$', 'NZD', '+13:00', NULL, 0),
('TO', 'Tonga', '+676', 'Tongan Paʻanga', 'T$', 'TOP', '+13:00', NULL, 0),
('TT', 'Trinidad and Tobago', '+1868', 'Trinidad and Tobago ', '$', 'TTD', '-04:00', 'America/Port_of_Spain', 0),
('TN', 'Tunisia', '+216', 'Tunisian dinar', 'د.ت', 'TND', '+01:00', NULL, 0),
('TR', 'Turkey', '+90', 'Turkish lira', '', 'TRY', '+02:00', NULL, 0),
('TM', 'Turkmenistan', '+993', 'Turkmenistan manat', 'm', 'TMT', '+05:00', NULL, 0),
('TC', 'Turks and Caicos Islands', '+1649', '', '', 'USD', '-05:00', NULL, 0),
('TV', 'Tuvalu', '+688', 'Australian dollar', '$', 'AUD', '+12:00', NULL, 0),
('UG', 'Uganda', '+256', 'Ugandan shilling', 'Sh', 'UGX', '+03:00', NULL, 0),
('UA', 'Ukraine', '+380', 'Ukrainian hryvnia', '₴', 'UAH', '+02:00', NULL, 0),
('AE', 'United Arab Emirates', '+971', 'United Arab Emirates', 'د.إ', 'AED', '+04:00', NULL, 0),
('GB', 'United Kingdom', '+44', 'British Pound', '£', 'GBP', '+00:00', NULL, 0),
('US', 'United States', '+1', 'United States Dollar', '$', 'USD', '-05:00', NULL, 0),
('UM', 'United States Minor Outlying Islands', '', '', '', '', NULL, NULL, 0),
('UY', 'Uruguay', '+598', 'Uruguayan peso', '$', 'UYU', '-03:00', NULL, 0),
('UZ', 'Uzbekistan', '+998', 'Uzbekistani som', '', 'UZS', '+05:00', NULL, 0),
('VU', 'Vanuatu', '+678', 'Vanuatu vatu', 'Vt', 'VUV', '+11:00', NULL, 0),
('VE', 'Venezuela', '+58', 'Venezuelan Bolivar', '', 'VEF', '-04:00', NULL, 0),
('VN', 'Vietnam', '+84', 'Vietnamese đồng', '₫', 'VND', '+07:00', NULL, 0),
('VG', 'British Virgin Islands', '+1284', 'United States dollar', '$', 'USD', '-04:00', NULL, 0),
('VI', 'U.S. Virgin Islands', '+1340', 'United States dollar', '$', 'USD', '-04:00', NULL, 0),
('WF', 'Wallis and Futuna', '+681', 'CFP franc', 'Fr', 'XPF', '+12:00', NULL, 0),
('YE', 'Yemen', '+967', 'Yemeni rial', '﷼', 'YER', '+03:00', NULL, 0),
('EH', 'Western Sahara', '', '', '', '', '+01:00', NULL, 0),
('ZM', 'Zambia', '+260', 'Zambian kwacha', 'ZK', 'ZMW', '+02:00', NULL, 0),
('ZW', 'Zimbabwe', '+263', 'Botswana pula', 'P', 'BWP', '+02:00', NULL, 0);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment