Created
April 5, 2012 11:11
-
-
Save keeguon/2310008 to your computer and use it in GitHub Desktop.
A list of countries in JSON
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| {name: 'Afghanistan', code: 'AF'}, | |
| {name: 'Åland Islands', code: 'AX'}, | |
| {name: 'Albania', code: 'AL'}, | |
| {name: 'Algeria', code: 'DZ'}, | |
| {name: 'American Samoa', code: 'AS'}, | |
| {name: 'AndorrA', code: 'AD'}, | |
| {name: 'Angola', code: 'AO'}, | |
| {name: 'Anguilla', code: 'AI'}, | |
| {name: 'Antarctica', code: 'AQ'}, | |
| {name: 'Antigua and Barbuda', code: 'AG'}, | |
| {name: 'Argentina', code: 'AR'}, | |
| {name: 'Armenia', code: 'AM'}, | |
| {name: 'Aruba', code: 'AW'}, | |
| {name: 'Australia', code: 'AU'}, | |
| {name: 'Austria', code: 'AT'}, | |
| {name: 'Azerbaijan', code: 'AZ'}, | |
| {name: 'Bahamas', code: 'BS'}, | |
| {name: 'Bahrain', code: 'BH'}, | |
| {name: 'Bangladesh', code: 'BD'}, | |
| {name: 'Barbados', code: 'BB'}, | |
| {name: 'Belarus', code: 'BY'}, | |
| {name: 'Belgium', code: 'BE'}, | |
| {name: 'Belize', code: 'BZ'}, | |
| {name: 'Benin', code: 'BJ'}, | |
| {name: 'Bermuda', code: 'BM'}, | |
| {name: 'Bhutan', code: 'BT'}, | |
| {name: 'Bolivia', code: 'BO'}, | |
| {name: 'Bosnia and Herzegovina', code: 'BA'}, | |
| {name: 'Botswana', code: 'BW'}, | |
| {name: 'Bouvet Island', code: 'BV'}, | |
| {name: 'Brazil', code: 'BR'}, | |
| {name: 'British Indian Ocean Territory', code: 'IO'}, | |
| {name: 'Brunei Darussalam', code: 'BN'}, | |
| {name: 'Bulgaria', code: 'BG'}, | |
| {name: 'Burkina Faso', code: 'BF'}, | |
| {name: 'Burundi', code: 'BI'}, | |
| {name: 'Cambodia', code: 'KH'}, | |
| {name: 'Cameroon', code: 'CM'}, | |
| {name: 'Canada', code: 'CA'}, | |
| {name: 'Cape Verde', code: 'CV'}, | |
| {name: 'Cayman Islands', code: 'KY'}, | |
| {name: 'Central African Republic', code: 'CF'}, | |
| {name: 'Chad', code: 'TD'}, | |
| {name: 'Chile', code: 'CL'}, | |
| {name: 'China', code: 'CN'}, | |
| {name: 'Christmas Island', code: 'CX'}, | |
| {name: 'Cocos (Keeling) Islands', code: 'CC'}, | |
| {name: 'Colombia', code: 'CO'}, | |
| {name: 'Comoros', code: 'KM'}, | |
| {name: 'Congo', code: 'CG'}, | |
| {name: 'Congo, The Democratic Republic of the', code: 'CD'}, | |
| {name: 'Cook Islands', code: 'CK'}, | |
| {name: 'Costa Rica', code: 'CR'}, | |
| {name: 'Cote D\'Ivoire', code: 'CI'}, | |
| {name: 'Croatia', code: 'HR'}, | |
| {name: 'Cuba', code: 'CU'}, | |
| {name: 'Cyprus', code: 'CY'}, | |
| {name: 'Czech Republic', code: 'CZ'}, | |
| {name: 'Denmark', code: 'DK'}, | |
| {name: 'Djibouti', code: 'DJ'}, | |
| {name: 'Dominica', code: 'DM'}, | |
| {name: 'Dominican Republic', code: 'DO'}, | |
| {name: 'Ecuador', code: 'EC'}, | |
| {name: 'Egypt', code: 'EG'}, | |
| {name: 'El Salvador', code: 'SV'}, | |
| {name: 'Equatorial Guinea', code: 'GQ'}, | |
| {name: 'Eritrea', code: 'ER'}, | |
| {name: 'Estonia', code: 'EE'}, | |
| {name: 'Ethiopia', code: 'ET'}, | |
| {name: 'Falkland Islands (Malvinas)', code: 'FK'}, | |
| {name: 'Faroe Islands', code: 'FO'}, | |
| {name: 'Fiji', code: 'FJ'}, | |
| {name: 'Finland', code: 'FI'}, | |
| {name: 'France', code: 'FR'}, | |
| {name: 'French Guiana', code: 'GF'}, | |
| {name: 'French Polynesia', code: 'PF'}, | |
| {name: 'French Southern Territories', code: 'TF'}, | |
| {name: 'Gabon', code: 'GA'}, | |
| {name: 'Gambia', code: 'GM'}, | |
| {name: 'Georgia', code: 'GE'}, | |
| {name: 'Germany', code: 'DE'}, | |
| {name: 'Ghana', code: 'GH'}, | |
| {name: 'Gibraltar', code: 'GI'}, | |
| {name: 'Greece', code: 'GR'}, | |
| {name: 'Greenland', code: 'GL'}, | |
| {name: 'Grenada', code: 'GD'}, | |
| {name: 'Guadeloupe', code: 'GP'}, | |
| {name: 'Guam', code: 'GU'}, | |
| {name: 'Guatemala', code: 'GT'}, | |
| {name: 'Guernsey', code: 'GG'}, | |
| {name: 'Guinea', code: 'GN'}, | |
| {name: 'Guinea-Bissau', code: 'GW'}, | |
| {name: 'Guyana', code: 'GY'}, | |
| {name: 'Haiti', code: 'HT'}, | |
| {name: 'Heard Island and Mcdonald Islands', code: 'HM'}, | |
| {name: 'Holy See (Vatican City State)', code: 'VA'}, | |
| {name: 'Honduras', code: 'HN'}, | |
| {name: 'Hong Kong', code: 'HK'}, | |
| {name: 'Hungary', code: 'HU'}, | |
| {name: 'Iceland', code: 'IS'}, | |
| {name: 'India', code: 'IN'}, | |
| {name: 'Indonesia', code: 'ID'}, | |
| {name: 'Iran, Islamic Republic Of', code: 'IR'}, | |
| {name: 'Iraq', code: 'IQ'}, | |
| {name: 'Ireland', code: 'IE'}, | |
| {name: 'Isle of Man', code: 'IM'}, | |
| {name: 'Israel', code: 'IL'}, | |
| {name: 'Italy', code: 'IT'}, | |
| {name: 'Jamaica', code: 'JM'}, | |
| {name: 'Japan', code: 'JP'}, | |
| {name: 'Jersey', code: 'JE'}, | |
| {name: 'Jordan', code: 'JO'}, | |
| {name: 'Kazakhstan', code: 'KZ'}, | |
| {name: 'Kenya', code: 'KE'}, | |
| {name: 'Kiribati', code: 'KI'}, | |
| {name: 'Korea, Democratic People\'S Republic of', code: 'KP'}, | |
| {name: 'Korea, Republic of', code: 'KR'}, | |
| {name: 'Kuwait', code: 'KW'}, | |
| {name: 'Kyrgyzstan', code: 'KG'}, | |
| {name: 'Lao People\'S Democratic Republic', code: 'LA'}, | |
| {name: 'Latvia', code: 'LV'}, | |
| {name: 'Lebanon', code: 'LB'}, | |
| {name: 'Lesotho', code: 'LS'}, | |
| {name: 'Liberia', code: 'LR'}, | |
| {name: 'Libyan Arab Jamahiriya', code: 'LY'}, | |
| {name: 'Liechtenstein', code: 'LI'}, | |
| {name: 'Lithuania', code: 'LT'}, | |
| {name: 'Luxembourg', code: 'LU'}, | |
| {name: 'Macao', code: 'MO'}, | |
| {name: 'Macedonia, The Former Yugoslav Republic of', code: 'MK'}, | |
| {name: 'Madagascar', code: 'MG'}, | |
| {name: 'Malawi', code: 'MW'}, | |
| {name: 'Malaysia', code: 'MY'}, | |
| {name: 'Maldives', code: 'MV'}, | |
| {name: 'Mali', code: 'ML'}, | |
| {name: 'Malta', code: 'MT'}, | |
| {name: 'Marshall Islands', code: 'MH'}, | |
| {name: 'Martinique', code: 'MQ'}, | |
| {name: 'Mauritania', code: 'MR'}, | |
| {name: 'Mauritius', code: 'MU'}, | |
| {name: 'Mayotte', code: 'YT'}, | |
| {name: 'Mexico', code: 'MX'}, | |
| {name: 'Micronesia, Federated States of', code: 'FM'}, | |
| {name: 'Moldova, Republic of', code: 'MD'}, | |
| {name: 'Monaco', code: 'MC'}, | |
| {name: 'Mongolia', code: 'MN'}, | |
| {name: 'Montserrat', code: 'MS'}, | |
| {name: 'Morocco', code: 'MA'}, | |
| {name: 'Mozambique', code: 'MZ'}, | |
| {name: 'Myanmar', code: 'MM'}, | |
| {name: 'Namibia', code: 'NA'}, | |
| {name: 'Nauru', code: 'NR'}, | |
| {name: 'Nepal', code: 'NP'}, | |
| {name: 'Netherlands', code: 'NL'}, | |
| {name: 'Netherlands Antilles', code: 'AN'}, | |
| {name: 'New Caledonia', code: 'NC'}, | |
| {name: 'New Zealand', code: 'NZ'}, | |
| {name: 'Nicaragua', code: 'NI'}, | |
| {name: 'Niger', code: 'NE'}, | |
| {name: 'Nigeria', code: 'NG'}, | |
| {name: 'Niue', code: 'NU'}, | |
| {name: 'Norfolk Island', code: 'NF'}, | |
| {name: 'Northern Mariana Islands', code: 'MP'}, | |
| {name: 'Norway', code: 'NO'}, | |
| {name: 'Oman', code: 'OM'}, | |
| {name: 'Pakistan', code: 'PK'}, | |
| {name: 'Palau', code: 'PW'}, | |
| {name: 'Palestinian Territory, Occupied', code: 'PS'}, | |
| {name: 'Panama', code: 'PA'}, | |
| {name: 'Papua New Guinea', code: 'PG'}, | |
| {name: 'Paraguay', code: 'PY'}, | |
| {name: 'Peru', code: 'PE'}, | |
| {name: 'Philippines', code: 'PH'}, | |
| {name: 'Pitcairn', code: 'PN'}, | |
| {name: 'Poland', code: 'PL'}, | |
| {name: 'Portugal', code: 'PT'}, | |
| {name: 'Puerto Rico', code: 'PR'}, | |
| {name: 'Qatar', code: 'QA'}, | |
| {name: 'Reunion', code: 'RE'}, | |
| {name: 'Romania', code: 'RO'}, | |
| {name: 'Russian Federation', code: 'RU'}, | |
| {name: 'RWANDA', code: 'RW'}, | |
| {name: 'Saint Helena', code: 'SH'}, | |
| {name: 'Saint Kitts and Nevis', code: 'KN'}, | |
| {name: 'Saint Lucia', code: 'LC'}, | |
| {name: 'Saint Pierre and Miquelon', code: 'PM'}, | |
| {name: 'Saint Vincent and the Grenadines', code: 'VC'}, | |
| {name: 'Samoa', code: 'WS'}, | |
| {name: 'San Marino', code: 'SM'}, | |
| {name: 'Sao Tome and Principe', code: 'ST'}, | |
| {name: 'Saudi Arabia', code: 'SA'}, | |
| {name: 'Senegal', code: 'SN'}, | |
| {name: 'Serbia and Montenegro', code: 'CS'}, | |
| {name: 'Seychelles', code: 'SC'}, | |
| {name: 'Sierra Leone', code: 'SL'}, | |
| {name: 'Singapore', code: 'SG'}, | |
| {name: 'Slovakia', code: 'SK'}, | |
| {name: 'Slovenia', code: 'SI'}, | |
| {name: 'Solomon Islands', code: 'SB'}, | |
| {name: 'Somalia', code: 'SO'}, | |
| {name: 'South Africa', code: 'ZA'}, | |
| {name: 'South Georgia and the South Sandwich Islands', code: 'GS'}, | |
| {name: 'Spain', code: 'ES'}, | |
| {name: 'Sri Lanka', code: 'LK'}, | |
| {name: 'Sudan', code: 'SD'}, | |
| {name: 'Suriname', code: 'SR'}, | |
| {name: 'Svalbard and Jan Mayen', code: 'SJ'}, | |
| {name: 'Swaziland', code: 'SZ'}, | |
| {name: 'Sweden', code: 'SE'}, | |
| {name: 'Switzerland', code: 'CH'}, | |
| {name: 'Syrian Arab Republic', code: 'SY'}, | |
| {name: 'Taiwan, Province of China', code: 'TW'}, | |
| {name: 'Tajikistan', code: 'TJ'}, | |
| {name: 'Tanzania, United Republic of', code: 'TZ'}, | |
| {name: 'Thailand', code: 'TH'}, | |
| {name: 'Timor-Leste', code: 'TL'}, | |
| {name: 'Togo', code: 'TG'}, | |
| {name: 'Tokelau', code: 'TK'}, | |
| {name: 'Tonga', code: 'TO'}, | |
| {name: 'Trinidad and Tobago', code: 'TT'}, | |
| {name: 'Tunisia', code: 'TN'}, | |
| {name: 'Turkey', code: 'TR'}, | |
| {name: 'Turkmenistan', code: 'TM'}, | |
| {name: 'Turks and Caicos Islands', code: 'TC'}, | |
| {name: 'Tuvalu', code: 'TV'}, | |
| {name: 'Uganda', code: 'UG'}, | |
| {name: 'Ukraine', code: 'UA'}, | |
| {name: 'United Arab Emirates', code: 'AE'}, | |
| {name: 'United Kingdom', code: 'GB'}, | |
| {name: 'United States', code: 'US'}, | |
| {name: 'United States Minor Outlying Islands', code: 'UM'}, | |
| {name: 'Uruguay', code: 'UY'}, | |
| {name: 'Uzbekistan', code: 'UZ'}, | |
| {name: 'Vanuatu', code: 'VU'}, | |
| {name: 'Venezuela', code: 'VE'}, | |
| {name: 'Viet Nam', code: 'VN'}, | |
| {name: 'Virgin Islands, British', code: 'VG'}, | |
| {name: 'Virgin Islands, U.S.', code: 'VI'}, | |
| {name: 'Wallis and Futuna', code: 'WF'}, | |
| {name: 'Western Sahara', code: 'EH'}, | |
| {name: 'Yemen', code: 'YE'}, | |
| {name: 'Zambia', code: 'ZM'}, | |
| {name: 'Zimbabwe', code: 'ZW'} | |
| ] |
There is no country called Israel
[
{ "name": "Afghanistan", "code": "AF" },
{ "name": "Åland Islands", "code": "AX" },
{ "name": "Albania", "code": "AL" },
{ "name": "Algeria", "code": "DZ" },
{ "name": "American Samoa", "code": "AS" },
{ "name": "AndorrA", "code": "AD" },
{ "name": "Angola", "code": "AO" },
{ "name": "Anguilla", "code": "AI" },
{ "name": "Antarctica", "code": "AQ" },
{ "name": "Antigua and Barbuda", "code": "AG" },
{ "name": "Argentina", "code": "AR" },
{ "name": "Armenia", "code": "AM" },
{ "name": "Aruba", "code": "AW" },
{ "name": "Australia", "code": "AU" },
{ "name": "Austria", "code": "AT" },
{ "name": "Azerbaijan", "code": "AZ" },
{ "name": "Bahamas", "code": "BS" },
{ "name": "Bahrain", "code": "BH" },
{ "name": "Bangladesh", "code": "BD" },
{ "name": "Barbados", "code": "BB" },
{ "name": "Belarus", "code": "BY" },
{ "name": "Belgium", "code": "BE" },
{ "name": "Belize", "code": "BZ" },
{ "name": "Benin", "code": "BJ" },
{ "name": "Bermuda", "code": "BM" },
{ "name": "Bhutan", "code": "BT" },
{ "name": "Bolivia", "code": "BO" },
{ "name": "Bosnia and Herzegovina", "code": "BA" },
{ "name": "Botswana", "code": "BW" },
{ "name": "Bouvet Island", "code": "BV" },
{ "name": "Brazil", "code": "BR" },
{ "name": "British Indian Ocean Territory", "code": "IO" },
{ "name": "Brunei Darussalam", "code": "BN" },
{ "name": "Bulgaria", "code": "BG" },
{ "name": "Burkina Faso", "code": "BF" },
{ "name": "Burundi", "code": "BI" },
{ "name": "Cambodia", "code": "KH" },
{ "name": "Cameroon", "code": "CM" },
{ "name": "Canada", "code": "CA" },
{ "name": "Cape Verde", "code": "CV" },
{ "name": "Cayman Islands", "code": "KY" },
{ "name": "Central African Republic", "code": "CF" },
{ "name": "Chad", "code": "TD" },
{ "name": "Chile", "code": "CL" },
{ "name": "China", "code": "CN" },
{ "name": "Christmas Island", "code": "CX" },
{ "name": "Cocos (Keeling) Islands", "code": "CC" },
{ "name": "Colombia", "code": "CO" },
{ "name": "Comoros", "code": "KM" },
{ "name": "Congo", "code": "CG" },
{ "name": "Congo, The Democratic Republic of the", "code": "CD" },
{ "name": "Cook Islands", "code": "CK" },
{ "name": "Costa Rica", "code": "CR" },
{ "name": "Croatia", "code": "HR" },
{ "name": "Cuba", "code": "CU" },
{ "name": "Cyprus", "code": "CY" },
{ "name": "Czech Republic", "code": "CZ" },
{ "name": "Denmark", "code": "DK" },
{ "name": "Djibouti", "code": "DJ" },
{ "name": "Dominica", "code": "DM" },
{ "name": "Dominican Republic", "code": "DO" },
{ "name": "Ecuador", "code": "EC" },
{ "name": "Egypt", "code": "EG" },
{ "name": "El Salvador", "code": "SV" },
{ "name": "Equatorial Guinea", "code": "GQ" },
{ "name": "Eritrea", "code": "ER" },
{ "name": "Estonia", "code": "EE" },
{ "name": "Ethiopia", "code": "ET" },
{ "name": "Falkland Islands (Malvinas)", "code": "FK" },
{ "name": "Faroe Islands", "code": "FO" },
{ "name": "Fiji", "code": "FJ" },
{ "name": "Finland", "code": "FI" },
{ "name": "France", "code": "FR" },
{ "name": "French Guiana", "code": "GF" },
{ "name": "French Polynesia", "code": "PF" },
{ "name": "French Southern Territories", "code": "TF" },
{ "name": "Gabon", "code": "GA" },
{ "name": "Gambia", "code": "GM" },
{ "name": "Georgia", "code": "GE" },
{ "name": "Germany", "code": "DE" },
{ "name": "Ghana", "code": "GH" },
{ "name": "Gibraltar", "code": "GI" },
{ "name": "Greece", "code": "GR" },
{ "name": "Greenland", "code": "GL" },
{ "name": "Grenada", "code": "GD" },
{ "name": "Guadeloupe", "code": "GP" },
{ "name": "Guam", "code": "GU" },
{ "name": "Guatemala", "code": "GT" },
{ "name": "Guernsey", "code": "GG" },
{ "name": "Guinea", "code": "GN" },
{ "name": "Guinea-Bissau", "code": "GW" },
{ "name": "Guyana", "code": "GY" },
{ "name": "Haiti", "code": "HT" },
{ "name": "Heard Island and Mcdonald Islands", "code": "HM" },
{ "name": "Holy See (Vatican City State)", "code": "VA" },
{ "name": "Honduras", "code": "HN" },
{ "name": "Hong Kong", "code": "HK" },
{ "name": "Hungary", "code": "HU" },
{ "name": "Iceland", "code": "IS" },
{ "name": "India", "code": "IN" },
{ "name": "Indonesia", "code": "ID" },
{ "name": "Iran, Islamic Republic Of", "code": "IR" },
{ "name": "Iraq", "code": "IQ" },
{ "name": "Ireland", "code": "IE" },
{ "name": "Isle of Man", "code": "IM" },
{ "name": "Italy", "code": "IT" },
{ "name": "Jamaica", "code": "JM" },
{ "name": "Japan", "code": "JP" },
{ "name": "Jersey", "code": "JE" },
{ "name": "Jordan", "code": "JO" },
{ "name": "Kazakhstan", "code": "KZ" },
{ "name": "Kenya", "code": "KE" },
{ "name": "Kiribati", "code": "KI" },
{ "name": "Korea, Republic of", "code": "KR" },
{ "name": "Kuwait", "code": "KW" },
{ "name": "Kyrgyzstan", "code": "KG" },
{ "name": "Latvia", "code": "LV" },
{ "name": "Lebanon", "code": "LB" },
{ "name": "Lesotho", "code": "LS" },
{ "name": "Liberia", "code": "LR" },
{ "name": "Libyan Arab Jamahiriya", "code": "LY" },
{ "name": "Liechtenstein", "code": "LI" },
{ "name": "Lithuania", "code": "LT" },
{ "name": "Luxembourg", "code": "LU" },
{ "name": "Macao", "code": "MO" },
{ "name": "North Macedonia", "code": "MK" },
{ "name": "Madagascar", "code": "MG" },
{ "name": "Malawi", "code": "MW" },
{ "name": "Malaysia", "code": "MY" },
{ "name": "Maldives", "code": "MV" },
{ "name": "Mali", "code": "ML" },
{ "name": "Malta", "code": "MT" },
{ "name": "Marshall Islands", "code": "MH" },
{ "name": "Martinique", "code": "MQ" },
{ "name": "Mauritania", "code": "MR" },
{ "name": "Mauritius", "code": "MU" },
{ "name": "Mayotte", "code": "YT" },
{ "name": "Mexico", "code": "MX" },
{ "name": "Micronesia, Federated States of", "code": "FM" },
{ "name": "Moldova, Republic of", "code": "MD" },
{ "name": "Monaco", "code": "MC" },
{ "name": "Mongolia", "code": "MN" },
{ "name": "Montserrat", "code": "MS" },
{ "name": "Morocco", "code": "MA" },
{ "name": "Mozambique", "code": "MZ" },
{ "name": "Myanmar", "code": "MM" },
{ "name": "Namibia", "code": "NA" },
{ "name": "Nauru", "code": "NR" },
{ "name": "Nepal", "code": "NP" },
{ "name": "Netherlands", "code": "NL" },
{ "name": "Netherlands Antilles", "code": "AN" },
{ "name": "New Caledonia", "code": "NC" },
{ "name": "New Zealand", "code": "NZ" },
{ "name": "Nicaragua", "code": "NI" },
{ "name": "Niger", "code": "NE" },
{ "name": "Nigeria", "code": "NG" },
{ "name": "Niue", "code": "NU" },
{ "name": "Norfolk Island", "code": "NF" },
{ "name": "Northern Mariana Islands", "code": "MP" },
{ "name": "Norway", "code": "NO" },
{ "name": "Oman", "code": "OM" },
{ "name": "Pakistan", "code": "PK" },
{ "name": "Palau", "code": "PW" },
{ "name": "Palestinian Territory, Occupied", "code": "PS" },
{ "name": "Panama", "code": "PA" },
{ "name": "Papua New Guinea", "code": "PG" },
{ "name": "Paraguay", "code": "PY" },
{ "name": "Peru", "code": "PE" },
{ "name": "Philippines", "code": "PH" },
{ "name": "Pitcairn Islands", "code": "PN" },
{ "name": "Poland", "code": "PL" },
{ "name": "Portugal", "code": "PT" },
{ "name": "Puerto Rico", "code": "PR" },
{ "name": "Qatar", "code": "QA" },
{ "name": "Reunion", "code": "RE" },
{ "name": "Romania", "code": "RO" },
{ "name": "Russian Federation", "code": "RU" },
{ "name": "Rwanda", "code": "RW" },
{ "name": "Saint Helena", "code": "SH" },
{ "name": "Saint Kitts and Nevis", "code": "KN" },
{ "name": "Saint Lucia", "code": "LC" },
{ "name": "Saint Pierre and Miquelon", "code": "PM" },
{ "name": "Saint Vincent and the Grenadines", "code": "VC" },
{ "name": "Samoa", "code": "WS" },
{ "name": "San Marino", "code": "SM" },
{ "name": "Sao Tome and Principe", "code": "ST" },
{ "name": "Saudi Arabia", "code": "SA" },
{ "name": "Senegal", "code": "SN" },
{ "name": "Serbia and Montenegro", "code": "CS" },
{ "name": "Seychelles", "code": "SC" },
{ "name": "Sierra Leone", "code": "SL" },
{ "name": "Singapore", "code": "SG" },
{ "name": "Slovakia", "code": "SK" },
{ "name": "Slovenia", "code": "SI" },
{ "name": "Solomon Islands", "code": "SB" },
{ "name": "Somalia", "code": "SO" },
{ "name": "South Africa", "code": "ZA" },
{ "name": "South Georgia and the South Sandwich Islands", "code": "GS" },
{ "name": "Spain", "code": "ES" },
{ "name": "Sri Lanka", "code": "LK" },
{ "name": "Sudan", "code": "SD" },
{ "name": "Suriname", "code": "SR" },
{ "name": "Svalbard and Jan Mayen", "code": "SJ" },
{ "name": "Swaziland", "code": "SZ" },
{ "name": "Sweden", "code": "SE" },
{ "name": "Switzerland", "code": "CH" },
{ "name": "Syrian Arab Republic", "code": "SY" },
{ "name": "Taiwan", "code": "TW" },
{ "name": "Tajikistan", "code": "TJ" },
{ "name": "Tanzania, United Republic of", "code": "TZ" },
{ "name": "Thailand", "code": "TH" },
{ "name": "Timor-Leste", "code": "TL" },
{ "name": "Togo", "code": "TG" },
{ "name": "Tokelau", "code": "TK" },
{ "name": "Tonga", "code": "TO" },
{ "name": "Trinidad and Tobago", "code": "TT" },
{ "name": "Tunisia", "code": "TN" },
{ "name": "Turkey", "code": "TR" },
{ "name": "Turkmenistan", "code": "TM" },
{ "name": "Turks and Caicos Islands", "code": "TC" },
{ "name": "Tuvalu", "code": "TV" },
{ "name": "Uganda", "code": "UG" },
{ "name": "Ukraine", "code": "UA" },
{ "name": "United Arab Emirates", "code": "AE" },
{ "name": "United Kingdom", "code": "GB" },
{ "name": "United States", "code": "US" },
{ "name": "United States Minor Outlying Islands", "code": "UM" },
{ "name": "Uruguay", "code": "UY" },
{ "name": "Uzbekistan", "code": "UZ" },
{ "name": "Vanuatu", "code": "VU" },
{ "name": "Venezuela", "code": "VE" },
{ "name": "Vietnam", "code": "VN" },
{ "name": "Virgin Islands, British", "code": "VG" },
{ "name": "Virgin Islands, U.S.", "code": "VI" },
{ "name": "Wallis and Futuna", "code": "WF" },
{ "name": "Western Sahara", "code": "EH" },
{ "name": "Yemen", "code": "YE" },
{ "name": "Zambia", "code": "ZM" },
{ "name": "Zimbabwe", "code": "ZN" }
]
Sure, but, Taiwan isn't a territory, it's as sovereign a nation as the USA.
🤡
Thank you Moh. I agree with removing the colonial state called Israel.
Hi, a variation for JavaScript/TypeScript, I see utility in having big const objects that allow to feed a databases with country id numbers easy, retrieve ids, for each country, avoid spreading 'magic numbers' in the code. This also allows to work with the linter. Hope it helps.
const COUNTRIES = {
AFGHANISTAN: { id: 1, codeName: "AFGHANISTAN", name: "Afghanistan", code: "AF"},
ALAND_ISLANDS: { id: 2, codeName: "ALAND_ISLANDS", name: "Åland Islands", code: "AX"},
ALBANIA: { id: 3, codeName: "ALBANIA", name: "Albania", code: "AL"},
ALGERIA: { id: 4, codeName: "ALGERIA", name: "Algeria", code: "DZ"},
AMERICAN_SAMOA: { id: 5, codeName: "AMERICAN_SAMOA", name: "American Samoa", code: "AS"},
ANDORRA: { id: 6, codeName: "ANDORRA", name: "Andorra", code: "AD"},
ANGOLA: { id: 7, codeName: "ANGOLA", name: "Angola", code: "AO"},
ANGUILLA: { id: 8, codeName: "ANGUILLA", name: "Anguilla", code: "AI"},
ANTARCTICA: { id: 9, codeName: "ANTARCTICA", name: "Antarctica", code: "AQ"},
ANTIGUA_AND_BARBUDA: { id: 10, codeName: "ANTIGUA_AND_BARBUDA", name: "Antigua and Barbuda", code: "AG"},
ARGENTINA: { id: 11, codeName: "ARGENTINA", name: "Argentina", code: "AR"},
ARMENIA: { id: 12, codeName: "ARMENIA", name: "Armenia", code: "AM"},
ARUBA: { id: 13, codeName: "ARUBA", name: "Aruba", code: "AW"},
AUSTRALIA: { id: 14, codeName: "AUSTRALIA", name: "Australia", code: "AU"},
AUSTRIA: { id: 15, codeName: "AUSTRIA", name: "Austria", code: "AT"},
AZERBAIJAN: { id: 16, codeName: "AZERBAIJAN", name: "Azerbaijan", code: "AZ"},
BAHAMAS: { id: 17, codeName: "BAHAMAS", name: "Bahamas", code: "BS"},
BAHRAIN: { id: 18, codeName: "BAHRAIN", name: "Bahrain", code: "BH"},
BANGLADESH: { id: 19, codeName: "BANGLADESH", name: "Bangladesh", code: "BD"},
BARBADOS: { id: 20, codeName: "BARBADOS", name: "Barbados", code: "BB"},
BELARUS: { id: 21, codeName: "BELARUS", name: "Belarus", code: "BY"},
BELGIUM: { id: 22, codeName: "BELGIUM", name: "Belgium", code: "BE"},
BELIZE: { id: 23, codeName: "BELIZE", name: "Belize", code: "BZ"},
BENIN: { id: 24, codeName: "BENIN", name: "Benin", code: "BJ"},
BERMUDA: { id: 25, codeName: "BERMUDA", name: "Bermuda", code: "BM"},
BHUTAN: { id: 26, codeName: "BHUTAN", name: "Bhutan", code: "BT"},
BOLIVIA: { id: 27, codeName: "BOLIVIA", name: "Bolivia", code: "BO"},
BOSNIA_AND_HERZEGOVINA: { id: 28, codeName: "BOSNIA_AND_HERZEGOVINA", name: "Bosnia and Herzegovina", code: "BA"},
BOTSWANA: { id: 29, codeName: "BOTSWANA", name: "Botswana", code: "BW"},
BOUVET_ISLAND: { id: 30, codeName: "BOUVET_ISLAND", name: "Bouvet Island", code: "BV"},
BRAZIL: { id: 31, codeName: "BRAZIL", name: "Brazil", code: "BR"},
BRITISH_INDIAN_OCEAN_TERRITORY: { id: 32, codeName: "BRITISH_INDIAN_OCEAN_TERRITORY", name: "British Indian Ocean Territory", code: "IO"},
BRUNEI_DARUSSALAM: { id: 33, codeName: "BRUNEI_DARUSSALAM", name: "Brunei Darussalam", code: "BN"},
BULGARIA: { id: 34, codeName: "BULGARIA", name: "Bulgaria", code: "BG"},
BURKINA_FASO: { id: 35, codeName: "BURKINA_FASO", name: "Burkina Faso", code: "BF"},
BURUNDI: { id: 36, codeName: "BURUNDI", name: "Burundi", code: "BI"},
CAMBODIA: { id: 37, codeName: "CAMBODIA", name: "Cambodia", code: "KH"},
CAMEROON: { id: 38, codeName: "CAMEROON", name: "Cameroon", code: "CM"},
CANADA: { id: 39, codeName: "CANADA", name: "Canada", code: "CA"},
CAPE_VERDE: { id: 40, codeName: "CAPE_VERDE", name: "Cape Verde", code: "CV"},
CAYMAN_ISLANDS: { id: 41, codeName: "CAYMAN_ISLANDS", name: "Cayman Islands", code: "KY"},
CENTRAL_AFRICAN_REPUBLIC: { id: 42, codeName: "CENTRAL_AFRICAN_REPUBLIC", name: "Central African Republic", code: "CF"},
CHAD: { id: 43, codeName: "CHAD", name: "Chad", code: "TD"},
CHILE: { id: 44, codeName: "CHILE", name: "Chile", code: "CL"},
CHINA: { id: 45, codeName: "CHINA", name: "China", code: "CN"},
CHRISTMAS_ISLAND: { id: 46, codeName: "CHRISTMAS_ISLAND", name: "Christmas Island", code: "CX"},
COCOS_KEELING_ISLANDS: { id: 47, codeName: "COCOS_KEELING_ISLANDS", name: "Cocos (Keeling) Islands", code: "CC"},
COLOMBIA: { id: 48, codeName: "COLOMBIA", name: "Colombia", code: "CO"},
COMOROS: { id: 49, codeName: "COMOROS", name: "Comoros", code: "KM"},
CONGO: { id: 50, codeName: "CONGO", name: "Congo", code: "CG"},
CONGO_THE_DEMOCRATIC_REPUBLIC_OF_THE: { id: 51, codeName: "CONGO_THE_DEMOCRATIC_REPUBLIC_OF_THE", name: "Congo, The Democratic Republic of the", code: "CD"},
COOK_ISLANDS: { id: 52, codeName: "COOK_ISLANDS", name: "Cook Islands", code: "CK"},
COSTA_RICA: { id: 53, codeName: "COSTA_RICA", name: "Costa Rica", code: "CR"},
COTE_DIVOIRE: { id: 54, codeName: "COTE_DIVOIRE", name: "Cote D'Ivoire", code: "CI"},
CROATIA: { id: 55, codeName: "CROATIA", name: "Croatia", code: "HR"},
CUBA: { id: 56, codeName: "CUBA", name: "Cuba", code: "CU"},
CYPRUS: { id: 57, codeName: "CYPRUS", name: "Cyprus", code: "CY"},
CZECH_REPUBLIC: { id: 58, codeName: "CZECH_REPUBLIC", name: "Czech Republic", code: "CZ"},
DENMARK: { id: 59, codeName: "DENMARK", name: "Denmark", code: "DK"},
DJIBOUTI: { id: 60, codeName: "DJIBOUTI", name: "Djibouti", code: "DJ"},
DOMINICA: { id: 61, codeName: "DOMINICA", name: "Dominica", code: "DM"},
DOMINICAN_REPUBLIC: { id: 62, codeName: "DOMINICAN_REPUBLIC", name: "Dominican Republic", code: "DO"},
ECUADOR: { id: 63, codeName: "ECUADOR", name: "Ecuador", code: "EC"},
EGYPT: { id: 64, codeName: "EGYPT", name: "Egypt", code: "EG"},
EL_SALVADOR: { id: 65, codeName: "EL_SALVADOR", name: "El Salvador", code: "SV"},
EQUATORIAL_GUINEA: { id: 66, codeName: "EQUATORIAL_GUINEA", name: "Equatorial Guinea", code: "GQ"},
ERITREA: { id: 67, codeName: "ERITREA", name: "Eritrea", code: "ER"},
ESTONIA: { id: 68, codeName: "ESTONIA", name: "Estonia", code: "EE"},
ETHIOPIA: { id: 69, codeName: "ETHIOPIA", name: "Ethiopia", code: "ET"},
FALKLAND_ISLANDS_MALVINAS: { id: 70, codeName: "FALKLAND_ISLANDS_MALVINAS", name: "Falkland Islands (Malvinas)", code: "FK"},
FAROE_ISLANDS: { id: 71, codeName: "FAROE_ISLANDS", name: "Faroe Islands", code: "FO"},
FIJI: { id: 72, codeName: "FIJI", name: "Fiji", code: "FJ"},
FINLAND: { id: 73, codeName: "FINLAND", name: "Finland", code: "FI"},
FRANCE: { id: 74, codeName: "FRANCE", name: "France", code: "FR"},
FRENCH_GUIANA: { id: 75, codeName: "FRENCH_GUIANA", name: "French Guiana", code: "GF"},
FRENCH_POLYNESIA: { id: 76, codeName: "FRENCH_POLYNESIA", name: "French Polynesia", code: "PF"},
FRENCH_SOUTHERN_TERRITORIES: { id: 77, codeName: "FRENCH_SOUTHERN_TERRITORIES", name: "French Southern Territories", code: "TF"},
GABON: { id: 78, codeName: "GABON", name: "Gabon", code: "GA"},
GAMBIA: { id: 79, codeName: "GAMBIA", name: "Gambia", code: "GM"},
GEORGIA: { id: 80, codeName: "GEORGIA", name: "Georgia", code: "GE"},
GERMANY: { id: 81, codeName: "GERMANY", name: "Germany", code: "DE"},
GHANA: { id: 82, codeName: "GHANA", name: "Ghana", code: "GH"},
GIBRALTAR: { id: 83, codeName: "GIBRALTAR", name: "Gibraltar", code: "GI"},
GREECE: { id: 84, codeName: "GREECE", name: "Greece", code: "GR"},
GREENLAND: { id: 85, codeName: "GREENLAND", name: "Greenland", code: "GL"},
GRENADA: { id: 86, codeName: "GRENADA", name: "Grenada", code: "GD"},
GUADELOUPE: { id: 87, codeName: "GUADELOUPE", name: "Guadeloupe", code: "GP"},
GUAM: { id: 88, codeName: "GUAM", name: "Guam", code: "GU"},
GUATEMALA: { id: 89, codeName: "GUATEMALA", name: "Guatemala", code: "GT"},
GUERNSEY: { id: 90, codeName: "GUERNSEY", name: "Guernsey", code: "GG"},
GUINEA: { id: 91, codeName: "GUINEA", name: "Guinea", code: "GN"},
GUINEA_BISSAU: { id: 92, codeName: "GUINEA_BISSAU", name: "Guinea-Bissau", code: "GW"},
GUYANA: { id: 93, codeName: "GUYANA", name: "Guyana", code: "GY"},
HAITI: { id: 94, codeName: "HAITI", name: "Haiti", code: "HT"},
HEARD_ISLAND_AND_MCDONALD_ISLANDS: { id: 95, codeName: "HEARD_ISLAND_AND_MCDONALD_ISLANDS", name: "Heard Island and Mcdonald Islands", code: "HM"},
HONDURAS: { id: 96, codeName: "HONDURAS", name: "Honduras", code: "HN"},
HONG_KONG: { id: 97, codeName: "HONG_KONG", name: "Hong Kong", code: "HK"},
HUNGARY: { id: 98, codeName: "HUNGARY", name: "Hungary", code: "HU"},
ICELAND: { id: 99, codeName: "ICELAND", name: "Iceland", code: "IS"},
INDIA: { id: 100, codeName: "INDIA", name: "India", code: "IN"},
INDONESIA: { id: 101, codeName: "INDONESIA", name: "Indonesia", code: "ID"},
IRAN_ISLAMIC_REPUBLIC_OF: { id: 102, codeName: "IRAN_ISLAMIC_REPUBLIC_OF", name: "Iran, Islamic Republic Of", code: "IR"},
IRAQ: { id: 103, codeName: "IRAQ", name: "Iraq", code: "IQ"},
IRELAND: { id: 104, codeName: "IRELAND", name: "Ireland", code: "IE"},
ISLE_OF_MAN: { id: 105, codeName: "ISLE_OF_MAN", name: "Isle of Man", code: "IM"},
ISRAEL: { id: 106, codeName: "ISRAEL", name: "Israel", code: "IL"},
ITALY: { id: 107, codeName: "ITALY", name: "Italy", code: "IT"},
JAMAICA: { id: 108, codeName: "JAMAICA", name: "Jamaica", code: "JM"},
JAPAN: { id: 109, codeName: "JAPAN", name: "Japan", code: "JP"},
JERSEY: { id: 110, codeName: "JERSEY", name: "Jersey", code: "JE"},
JORDAN: { id: 111, codeName: "JORDAN", name: "Jordan", code: "JO"},
KAZAKHSTAN: { id: 112, codeName: "KAZAKHSTAN", name: "Kazakhstan", code: "KZ"},
KENYA: { id: 113, codeName: "KENYA", name: "Kenya", code: "KE"},
KIRIBATI: { id: 114, codeName: "KIRIBATI", name: "Kiribati", code: "KI"},
KOREA_DEMOCRATIC_PEOPLES_REPUBLIC_OF: { id: 115, codeName: "KOREA_DEMOCRATIC_PEOPLES_REPUBLIC_OF", name: "Korea, Democratic People'S_Republic of", code: "KP"},
KOREA_REPUBLIC_OF: { id: 116, codeName: "KOREA_REPUBLIC_OF", name: "Korea, Republic of", code: "KR"},
KUWAIT: { id: 117, codeName: "KUWAIT", name: "Kuwait", code: "KW"},
KYRGYZSTAN: { id: 118, codeName: "KYRGYZSTAN", name: "Kyrgyzstan", code: "KG"},
LAO_PEOPLES_DEMOCRATIC_REPUBLIC: { id: 119, codeName: "LAO_PEOPLES_DEMOCRATIC_REPUBLIC", name: "Lao People'S_Democratic Republic", code: "LA"},
LATVIA: { id: 120, codeName: "LATVIA", name: "Latvia", code: "LV"},
LEBANON: { id: 121, codeName: "LEBANON", name: "Lebanon", code: "LB"},
LESOTHO: { id: 122, codeName: "LESOTHO", name: "Lesotho", code: "LS"},
LIBERIA: { id: 123, codeName: "LIBERIA", name: "Liberia", code: "LR"},
LIBYAN_ARAB_JAMAHIRIYA: { id: 124, codeName: "LIBYAN_ARAB_JAMAHIRIYA", name: "Libyan Arab Jamahiriya", code: "LY"},
LIECHTENSTEIN: { id: 125, codeName: "LIECHTENSTEIN", name: "Liechtenstein", code: "LI"},
LITHUANIA: { id: 126, codeName: "LITHUANIA", name: "Lithuania", code: "LT"},
LUXEMBOURG: { id: 127, codeName: "LUXEMBOURG", name: "Luxembourg", code: "LU"},
MACAO: { id: 128, codeName: "MACAO", name: "Macao", code: "MO"},
MACEDONIA_THE_FORMER_YUGOSLAV_REPUBLIC_OF: { id: 129, codeName: "MACEDONIA_THE_FORMER_YUGOSLAV_REPUBLIC_OF", name: "Macedonia, The Former Yugoslav Republic of", code: "MK"},
MADAGASCAR: { id: 130, codeName: "MADAGASCAR", name: "Madagascar", code: "MG"},
MALAWI: { id: 131, codeName: "MALAWI", name: "Malawi", code: "MW"},
MALAYSIA: { id: 132, codeName: "MALAYSIA", name: "Malaysia", code: "MY"},
MALDIVES: { id: 133, codeName: "MALDIVES", name: "Maldives", code: "MV"},
MALI: { id: 134, codeName: "MALI", name: "Mali", code: "ML"},
MALTA: { id: 135, codeName: "MALTA", name: "Malta", code: "MT"},
MARSHALL_ISLANDS: { id: 136, codeName: "MARSHALL_ISLANDS", name: "Marshall Islands", code: "MH"},
MARTINIQUE: { id: 137, codeName: "MARTINIQUE", name: "Martinique", code: "MQ"},
MAURITANIA: { id: 138, codeName: "MAURITANIA", name: "Mauritania", code: "MR"},
MAURITIUS: { id: 139, codeName: "MAURITIUS", name: "Mauritius", code: "MU"},
MAYOTTE: { id: 140, codeName: "MAYOTTE", name: "Mayotte", code: "YT"},
MEXICO: { id: 141, codeName: "MEXICO", name: "Mexico", code: "MX"},
MICRONESIA_FEDERATED_STATES_OF: { id: 142, codeName: "MICRONESIA_FEDERATED_STATES_OF", name: "Micronesia, Federated States of", code: "FM"},
MOLDOVA_REPUBLIC_OF: { id: 143, codeName: "MOLDOVA_REPUBLIC_OF", name: "Moldova, Republic of", code: "MD"},
MONACO: { id: 144, codeName: "MONACO", name: "Monaco", code: "MC"},
MONGOLIA: { id: 145, codeName: "MONGOLIA", name: "Mongolia", code: "MN"},
MONTSERRAT: { id: 146, codeName: "MONTSERRAT", name: "Montserrat", code: "MS"},
MOROCCO: { id: 147, codeName: "MOROCCO", name: "Morocco", code: "MA"},
MOZAMBIQUE: { id: 148, codeName: "MOZAMBIQUE", name: "Mozambique", code: "MZ"},
MYANMAR: { id: 149, codeName: "MYANMAR", name: "Myanmar", code: "MM"},
NAMIBIA: { id: 150, codeName: "NAMIBIA", name: "Namibia", code: "NA"},
NAURU: { id: 151, codeName: "NAURU", name: "Nauru", code: "NR"},
NEPAL: { id: 152, codeName: "NEPAL", name: "Nepal", code: "NP"},
NETHERLANDS: { id: 153, codeName: "NETHERLANDS", name: "Netherlands", code: "NL"},
NETHERLANDS_ANTILLES: { id: 154, codeName: "NETHERLANDS_ANTILLES", name: "Netherlands Antilles", code: "AN"},
NEW_CALEDONIA: { id: 155, codeName: "NEW_CALEDONIA", name: "New Caledonia", code: "NC"},
NEW_ZEALAND: { id: 156, codeName: "NEW_ZEALAND", name: "New Zealand", code: "NZ"},
NICARAGUA: { id: 157, codeName: "NICARAGUA", name: "Nicaragua", code: "NI"},
NIGER: { id: 158, codeName: "NIGER", name: "Niger", code: "NE"},
NIGERIA: { id: 159, codeName: "NIGERIA", name: "Nigeria", code: "NG"},
NIUE: { id: 160, codeName: "NIUE", name: "Niue", code: "NU"},
NORFOLK_ISLAND: { id: 161, codeName: "NORFOLK_ISLAND", name: "Norfolk Island", code: "NF"},
NORTHERN_MARIANA_ISLANDS: { id: 162, codeName: "NORTHERN_MARIANA_ISLANDS", name: "Northern Mariana Islands", code: "MP"},
NORWAY: { id: 163, codeName: "NORWAY", name: "Norway", code: "NO"},
OMAN: { id: 164, codeName: "OMAN", name: "Oman", code: "OM"},
PAKISTAN: { id: 165, codeName: "PAKISTAN", name: "Pakistan", code: "PK"},
PALAU: { id: 166, codeName: "PALAU", name: "Palau", code: "PW"},
PALESTINIAN_TERRITORY_OCCUPIED: { id: 167, codeName: "PALESTINIAN_TERRITORY_OCCUPIED", name: "Palestinian Territory, Occupied", code: "PS"},
PANAMA: { id: 168, codeName: "PANAMA", name: "Panama", code: "PA"},
PAPUA_NEW_GUINEA: { id: 169, codeName: "PAPUA_NEW_GUINEA", name: "Papua New Guinea", code: "PG"},
PARAGUAY: { id: 170, codeName: "PARAGUAY", name: "Paraguay", code: "PY"},
PERU: { id: 171, codeName: "PERU", name: "Peru", code: "PE"},
PHILIPPINES: { id: 172, codeName: "PHILIPPINES", name: "Philippines", code: "PH"},
PITCAIRN: { id: 173, codeName: "PITCAIRN", name: "Pitcairn", code: "PN"},
POLAND: { id: 174, codeName: "POLAND", name: "Poland", code: "PL"},
PORTUGAL: { id: 175, codeName: "PORTUGAL", name: "Portugal", code: "PT"},
PUERTO_RICO: { id: 176, codeName: "PUERTO_RICO", name: "Puerto Rico", code: "PR"},
QATAR: { id: 177, codeName: "QATAR", name: "Qatar", code: "QA"},
REUNION: { id: 178, codeName: "REUNION", name: "Reunion", code: "RE"},
ROMANIA: { id: 179, codeName: "ROMANIA", name: "Romania", code: "RO"},
RUSSIAN_FEDERATION: { id: 180, codeName: "RUSSIAN_FEDERATION", name: "Russian Federation", code: "RU"},
RWANDA: { id: 181, codeName: "RWANDA", name: "RWANDA", code: "RW"},
SAINT_HELENA: { id: 182, codeName: "SAINT_HELENA", name: "Saint Helena", code: "SH"},
SAINT_KITTS_AND_NEVIS: { id: 183, codeName: "SAINT_KITTS_AND_NEVIS", name: "Saint Kitts and Nevis", code: "KN"},
SAINT_LUCIA: { id: 184, codeName: "SAINT_LUCIA", name: "Saint Lucia", code: "LC"},
SAINT_PIERRE_AND_MIQUELON: { id: 185, codeName: "SAINT_PIERRE_AND_MIQUELON", name: "Saint Pierre and Miquelon", code: "PM"},
SAINT_VINCENT_AND_THE_GRENADINES: { id: 186, codeName: "SAINT_VINCENT_AND_THE_GRENADINES", name: "Saint Vincent and the Grenadines", code: "VC"},
SAMOA: { id: 187, codeName: "SAMOA", name: "Samoa", code: "WS"},
SAN_MARINO: { id: 188, codeName: "SAN_MARINO", name: "San Marino", code: "SM"},
SAO_TOME_AND_PRINCIPE: { id: 189, codeName: "SAO_TOME_AND_PRINCIPE", name: "Sao Tome and Principe", code: "ST"},
SAUDI_ARABIA: { id: 190, codeName: "SAUDI_ARABIA", name: "Saudi Arabia", code: "SA"},
SENEGAL: { id: 191, codeName: "SENEGAL", name: "Senegal", code: "SN"},
SERBIA_AND_MONTENEGRO: { id: 192, codeName: "SERBIA_AND_MONTENEGRO", name: "Serbia and Montenegro", code: "CS"},
SEYCHELLES: { id: 193, codeName: "SEYCHELLES", name: "Seychelles", code: "SC"},
SIERRA_LEONE: { id: 194, codeName: "SIERRA_LEONE", name: "Sierra Leone", code: "SL"},
SINGAPORE: { id: 195, codeName: "SINGAPORE", name: "Singapore", code: "SG"},
SLOVAKIA: { id: 196, codeName: "SLOVAKIA", name: "Slovakia", code: "SK"},
SLOVENIA: { id: 197, codeName: "SLOVENIA", name: "Slovenia", code: "SI"},
SOLOMON_ISLANDS: { id: 198, codeName: "SOLOMON_ISLANDS", name: "Solomon Islands", code: "SB"},
SOMALIA: { id: 199, codeName: "SOMALIA", name: "Somalia", code: "SO"},
SOUTH_AFRICA: { id: 200, codeName: "SOUTH_AFRICA", name: "South Africa", code: "ZA"},
SOUTH_GEORGIA_AND_THE_SOUTH_SANDWICH_ISLANDS: { id: 201, codeName: "SOUTH_GEORGIA_AND_THE_SOUTH_SANDWICH_ISLANDS", name: "South Georgia and the South Sandwich Islands", code: "GS"},
SPAIN: { id: 202, codeName: "SPAIN", name: "Spain", code: "ES"},
SRI_LANKA: { id: 203, codeName: "SRI_LANKA", name: "Sri Lanka", code: "LK"},
SUDAN: { id: 204, codeName: "SUDAN", name: "Sudan", code: "SD"},
SURINAME: { id: 205, codeName: "SURINAME", name: "Suriname", code: "SR"},
SVALBARD_AND_JAN_MAYEN: { id: 206, codeName: "SVALBARD_AND_JAN_MAYEN", name: "Svalbard and Jan Mayen", code: "SJ"},
SWAZILAND: { id: 207, codeName: "SWAZILAND", name: "Swaziland", code: "SZ"},
SWEDEN: { id: 208, codeName: "SWEDEN", name: "Sweden", code: "SE"},
SWITZERLAND: { id: 209, codeName: "SWITZERLAND", name: "Switzerland", code: "CH"},
SYRIAN_ARAB_REPUBLIC: { id: 210, codeName: "SYRIAN_ARAB_REPUBLIC", name: "Syrian Arab Republic", code: "SY"},
TAIWAN_PROVINCE_OF_CHINA: { id: 211, codeName: "TAIWAN_PROVINCE_OF_CHINA", name: "Taiwan, Province of China", code: "TW"},
TAJIKISTAN: { id: 212, codeName: "TAJIKISTAN", name: "Tajikistan", code: "TJ"},
TANZANIA_UNITED_REPUBLIC_OF: { id: 213, codeName: "TANZANIA_UNITED_REPUBLIC_OF", name: "Tanzania, United Republic of", code: "TZ"},
THAILAND: { id: 214, codeName: "THAILAND", name: "Thailand", code: "TH"},
TIMOR_LESTE: { id: 215, codeName: "TIMOR_LESTE", name: "Timor-Leste", code: "TL"},
TOGO: { id: 216, codeName: "TOGO", name: "Togo", code: "TG"},
TOKELAU: { id: 217, codeName: "TOKELAU", name: "Tokelau", code: "TK"},
TONGA: { id: 218, codeName: "TONGA", name: "Tonga", code: "TO"},
TRINIDAD_AND_TOBAGO: { id: 219, codeName: "TRINIDAD_AND_TOBAGO", name: "Trinidad and Tobago", code: "TT"},
TUNISIA: { id: 220, codeName: "TUNISIA", name: "Tunisia", code: "TN"},
TURKEY: { id: 221, codeName: "TURKEY", name: "Turkey", code: "TR"},
TURKMENISTAN: { id: 222, codeName: "TURKMENISTAN", name: "Turkmenistan", code: "TM"},
TURKS_AND_CAICOS_ISLANDS: { id: 223, codeName: "TURKS_AND_CAICOS_ISLANDS", name: "Turks and Caicos Islands", code: "TC"},
TUVALU: { id: 224, codeName: "TUVALU", name: "Tuvalu", code: "TV"},
UGANDA: { id: 225, codeName: "UGANDA", name: "Uganda", code: "UG"},
UKRAINE: { id: 226, codeName: "UKRAINE", name: "Ukraine", code: "UA"},
UNITED_ARAB_EMIRATES: { id: 227, codeName: "UNITED_ARAB_EMIRATES", name: "United Arab Emirates", code: "AE"},
UNITED_KINGDOM: { id: 228, codeName: "UNITED_KINGDOM", name: "United Kingdom", code: "GB"},
UNITED_STATES: { id: 229, codeName: "UNITED_STATES", name: "United States", code: "US"},
UNITED_STATES_MINOR_OUTLYING_ISLANDS: { id: 230, codeName: "UNITED_STATES_MINOR_OUTLYING_ISLANDS", name: "United States Minor Outlying Islands", code: "UM"},
URUGUAY: { id: 231, codeName: "URUGUAY", name: "Uruguay", code: "UY"},
UZBEKISTAN: { id: 232, codeName: "UZBEKISTAN", name: "Uzbekistan", code: "UZ"},
VANUATU: { id: 233, codeName: "VANUATU", name: "Vanuatu", code: "VU"},
VATICAN_CITY_STATE: { id: 234, codeName: "VATICAN_CITY_STATE", name: "Vatican City State", code: "VA"},
VENEZUELA: { id: 235, codeName: "VENEZUELA", name: "Venezuela", code: "VE"},
VIET_NAM: { id: 236, codeName: "VIET_NAM", name: "Viet Nam", code: "VN"},
VIRGIN_ISLANDS_BRITISH: { id: 237, codeName: "VIRGIN_ISLANDS_BRITISH", name: "Virgin Islands, British", code: "VG"},
VIRGIN_ISLANDS_US: { id: 238, codeName: "VIRGIN_ISLANDS_US", name: "Virgin Islands, U.S.", code: "VI"},
WALLIS_AND_FUTUNA: { id: 239, codeName: "WALLIS_AND_FUTUNA", name: "Wallis and Futuna", code: "WF"},
WESTERN_SAHARA: { id: 240, codeName: "WESTERN_SAHARA", name: "Western Sahara", code: "EH"},
YEMEN: { id: 241, codeName: "YEMEN", name: "Yemen", code: "YE"},
ZAMBIA: { id: 242, codeName: "ZAMBIA", name: "Zambia", code: "ZM"},
ZIMBABWE: { id: 243, codeName: "ZIMBABWE", name: "Zimbabwe", code: "ZW"}
}
mohamedabdallah20 +1 to no isr***
+1 There is no country called Isr**l
So, i know this is for JSON, but maybe someone will need this on SQL. So, here is in SQL:
`
USE countries;
-- Crear tabla para las monedas
CREATE TABLE IF NOT EXISTS currencies (
code CHAR(3) PRIMARY KEY,
name VARCHAR(255),
symbol VARCHAR(10)
);
-- Crear tabla para los idiomas
CREATE TABLE IF NOT EXISTS languages (
code CHAR(2) PRIMARY KEY,
name VARCHAR(255)
);
-- Crear tabla para los países
CREATE TABLE IF NOT EXISTS countries (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
code CHAR(2),
capital VARCHAR(255),
region CHAR(2),
currency_code CHAR(3),
language_code CHAR(2),
flag_url TEXT,
dialling_code VARCHAR(10),
iso_code CHAR(3),
FOREIGN KEY (currency_code) REFERENCES currencies(code),
FOREIGN KEY (language_code) REFERENCES languages(code)
);
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('AFN', 'Afghan afghani', '؋');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ALL', 'Albanian lek', 'L');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('DZD', 'Algerian dinar', 'د.ج');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('USD', 'United State Dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('EUR', 'Euro', '€');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('AOA', 'Angolan kwanza', 'Kz');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('XCD', 'East Caribbean dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ARS', 'Argentine peso', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('AMD', 'Armenian dram', NULL);
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('AWG', 'Aruban florin', 'ƒ');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('AUD', 'Australian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('AZN', 'Azerbaijani manat', NULL);
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BSD', 'Bahamian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BHD', 'Bahraini dinar', '.د.ب');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BDT', 'Bangladeshi taka', '৳');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BBD', 'Barbadian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BYN', 'New Belarusian ruble', 'Br');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BZD', 'Belize dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('XOF', 'West African CFA franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BMD', 'Bermudian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BTN', 'Bhutanese ngultrum', 'Nu.');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BOB', 'Bolivian boliviano', 'Bs.');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BAM', 'Bosnia and Herzegovina convertible mark', NULL);
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BWP', 'Botswana pula', 'P');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BRL', 'Brazilian real', 'R$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('USD', 'United States dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BND', 'Brunei dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BGN', 'Bulgarian lev', 'лв');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('BIF', 'Burundian franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KHR', 'Cambodian riel', '៛');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('XAF', 'Central African CFA franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CAD', 'Canadian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CVE', 'Cape Verdean escudo', 'Esc');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KYD', 'Cayman Islands dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CLP', 'Chilean peso', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CNY', 'Chinese yuan', '¥');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('COP', 'Colombian peso', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KMF', 'Comorian franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CDF', 'Congolese franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('NZD', 'New Zealand dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CRC', 'Costa Rican colón', '₡');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('HRK', 'Croatian kuna', 'kn');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CUC', 'Cuban convertible peso', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CZK', 'Czech koruna', 'Kč');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('DKK', 'Danish krone', 'kr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('DJF', 'Djiboutian franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('DOP', 'Dominican peso', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('EGP', 'Egyptian pound', '£');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ERN', 'Eritrean nakfa', 'Nfk');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ETB', 'Ethiopian birr', 'Br');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('FKP', 'Falkland Islands pound', '£');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('FJD', 'Fijian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('XPF', 'CFP franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GMD', 'Gambian dalasi', 'D');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GEL', 'Georgian Lari', 'ლ');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GHS', 'Ghanaian cedi', '₵');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GIP', 'Gibraltar pound', '£');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GTQ', 'Guatemalan quetzal', 'Q');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GNF', 'Guinean franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GYD', 'Guyanese dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('HTG', 'Haitian gourde', 'G');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('HNL', 'Honduran lempira', 'L');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('HKD', 'Hong Kong dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('HUF', 'Hungarian forint', 'Ft');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ISK', 'Icelandic króna', 'kr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('INR', 'Indian rupee', '₹');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('IDR', 'Indonesian rupiah', 'Rp');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('IRR', 'Iranian rial', '﷼');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('IQD', 'Iraqi dinar', 'ع.د');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ILS', 'Israeli new shekel', '₪');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('JMD', 'Jamaican dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('JPY', 'Japanese yen', '¥');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('JOD', 'Jordanian dinar', 'د.ا');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KZT', 'Kazakhstani tenge', NULL);
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KES', 'Kenyan shilling', 'Sh');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KWD', 'Kuwaiti dinar', 'د.ك');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KGS', 'Kyrgyzstani som', 'с');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('LAK', 'Lao kip', '₭');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('LBP', 'Lebanese pound', 'ل.ل');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('LSL', 'Lesotho loti', 'L');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('LRD', 'Liberian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('LYD', 'Libyan dinar', 'ل.د');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('CHF', 'Swiss franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MOP', 'Macanese pataca', 'P');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MKD', 'Macedonian denar', 'ден');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MGA', 'Malagasy ariary', 'Ar');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MWK', 'Malawian kwacha', 'MK');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MYR', 'Malaysian ringgit', 'RM');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MVR', 'Maldivian rufiyaa', '.ރ');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MRO', 'Mauritanian ouguiya', 'UM');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MUR', 'Mauritian rupee', '₨');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MXN', 'Mexican peso', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MDL', 'Moldovan leu', 'L');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MNT', 'Mongolian tögrög', '₮');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MAD', 'Moroccan dirham', 'د.م.');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MZN', 'Mozambican metical', 'MT');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('MMK', 'Burmese kyat', 'Ks');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('NAD', 'Namibian dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('NPR', 'Nepalese rupee', '₨');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('NIO', 'Nicaraguan córdoba', 'C$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('NGN', 'Nigerian naira', '₦');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KPW', 'North Korean won', '₩');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('NOK', 'Norwegian krone', 'kr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('OMR', 'Omani rial', 'ر.ع.');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('PKR', 'Pakistani rupee', '₨');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ILS', 'Israeli new sheqel', '₪');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('PGK', 'Papua New Guinean kina', 'K');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('PYG', 'Paraguayan guaraní', '₲');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('PEN', 'Peruvian sol', 'S/.');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('PHP', 'Philippine peso', '₱');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('PLN', 'Polish złoty', 'zł');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('QAR', 'Qatari riyal', 'ر.ق');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('RON', 'Romanian leu', 'lei');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('RUB', 'Russian ruble', '₽');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('RWF', 'Rwandan franc', 'Fr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SHP', 'Saint Helena pound', '£');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('WST', 'Samoan tālā', 'T');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('STD', 'São Tomé and Príncipe dobra', 'Db');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SAR', 'Saudi riyal', 'ر.س');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('RSD', 'Serbian dinar', 'дин.');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SCR', 'Seychellois rupee', '₨');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SLL', 'Sierra Leonean leone', 'Le');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SGD', 'Singapore dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SBD', 'Solomon Islands dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SOS', 'Somali shilling', 'Sh');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ZAR', 'South African rand', 'R');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('KRW', 'South Korean won', '₩');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('LKR', 'Sri Lankan rupee', 'Rs');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SDG', 'Sudanese pound', 'ج.س.');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SRD', 'Surinamese dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SZL', 'Swazi lilangeni', 'L');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SEK', 'Swedish krona', 'kr');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('SYP', 'Syrian pound', '£');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TWD', 'New Taiwan dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TJS', 'Tajikistani somoni', 'ЅМ');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TZS', 'Tanzanian shilling', 'Sh');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('THB', 'Thai baht', '฿');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TOP', 'Tongan paʻanga', 'T$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TTD', 'Trinidad and Tobago dollar', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TND', 'Tunisian dinar', 'د.ت');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TRY', 'Turkish lira', NULL);
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('TMT', 'Turkmenistan manat', 'm');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('UGX', 'Ugandan shilling', 'Sh');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('UAH', 'Ukrainian hryvnia', '₴');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('AED', 'United Arab Emirates dirham', 'د.إ');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('GBP', 'British pound', '£');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('UYU', 'Uruguayan peso', '$');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('UZS', 'Uzbekistani so''m', NULL);
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('VUV', 'Vanuatu vatu', 'Vt');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('VEF', 'Venezuelan bolívar', 'Bs F');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('VND', 'Vietnamese đồng', '₫');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('YER', 'Yemeni rial', '﷼');
INSERT IGNORE INTO currencies (code, name, symbol)
VALUES ('ZMW', 'Zambian kwacha', 'ZK');
INSERT IGNORE INTO languages (code, name)
VALUES ('ps', 'Pashto');
INSERT IGNORE INTO languages (code, name)
VALUES ('sq', 'Albanian');
INSERT IGNORE INTO languages (code, name)
VALUES ('ar', 'Arabic');
INSERT IGNORE INTO languages (code, name)
VALUES ('en', 'English');
INSERT IGNORE INTO languages (code, name)
VALUES ('ca', 'Catalan');
INSERT IGNORE INTO languages (code, name)
VALUES ('pt', 'Portuguese');
INSERT IGNORE INTO languages (code, name)
VALUES ('es', 'Spanish');
INSERT IGNORE INTO languages (code, name)
VALUES ('hy', 'Armenian');
INSERT IGNORE INTO languages (code, name)
VALUES ('nl', 'Dutch');
INSERT IGNORE INTO languages (code, name)
VALUES ('az', 'Azerbaijani');
INSERT IGNORE INTO languages (code, name)
VALUES ('bn', 'Bengali');
INSERT IGNORE INTO languages (code, name)
VALUES ('be', 'Belarusian');
INSERT IGNORE INTO languages (code, name)
VALUES ('fr', 'French');
INSERT IGNORE INTO languages (code, name)
VALUES ('dz', 'Dzongkha');
INSERT IGNORE INTO languages (code, name)
VALUES ('bs', 'Bosnian');
INSERT IGNORE INTO languages (code, name)
VALUES ('ms', 'Malay');
INSERT IGNORE INTO languages (code, name)
VALUES ('bg', 'Bulgarian');
INSERT IGNORE INTO languages (code, name)
VALUES ('km', 'Khmer');
INSERT IGNORE INTO languages (code, name)
VALUES ('zh', 'Chinese');
INSERT IGNORE INTO languages (code, name)
VALUES ('hr', 'Croatian');
INSERT IGNORE INTO languages (code, name)
VALUES ('tr', 'Turkish');
INSERT IGNORE INTO languages (code, name)
VALUES ('cs', 'Czech');
INSERT IGNORE INTO languages (code, name)
VALUES ('da', 'Danish');
INSERT IGNORE INTO languages (code, name)
VALUES ('et', 'Estonian');
INSERT IGNORE INTO languages (code, name)
VALUES ('am', 'Amharic');
INSERT IGNORE INTO languages (code, name)
VALUES ('fo', 'Faroese');
INSERT IGNORE INTO languages (code, name)
VALUES ('fi', 'Finnish');
INSERT IGNORE INTO languages (code, name)
VALUES ('ka', 'Georgian');
INSERT IGNORE INTO languages (code, name)
VALUES ('de', 'German');
INSERT IGNORE INTO languages (code, name)
VALUES ('el', 'Greek (modern)');
INSERT IGNORE INTO languages (code, name)
VALUES ('kl', 'Kalaallisut');
INSERT IGNORE INTO languages (code, name)
VALUES ('hu', 'Hungarian');
INSERT IGNORE INTO languages (code, name)
VALUES ('is', 'Icelandic');
INSERT IGNORE INTO languages (code, name)
VALUES ('hi', 'Hindi');
INSERT IGNORE INTO languages (code, name)
VALUES ('id', 'Indonesian');
INSERT IGNORE INTO languages (code, name)
VALUES ('fa', 'Persian (Farsi)');
INSERT IGNORE INTO languages (code, name)
VALUES ('ga', 'Irish');
INSERT IGNORE INTO languages (code, name)
VALUES ('he', 'Hebrew (modern)');
INSERT IGNORE INTO languages (code, name)
VALUES ('it', 'Italian');
INSERT IGNORE INTO languages (code, name)
VALUES ('ja', 'Japanese');
INSERT IGNORE INTO languages (code, name)
VALUES ('kk', 'Kazakh');
INSERT IGNORE INTO languages (code, name)
VALUES ('ky', 'Kyrgyz');
INSERT IGNORE INTO languages (code, name)
VALUES ('lo', 'Lao');
INSERT IGNORE INTO languages (code, name)
VALUES ('lv', 'Latvian');
INSERT IGNORE INTO languages (code, name)
VALUES ('lt', 'Lithuanian');
INSERT IGNORE INTO languages (code, name)
VALUES ('mk', 'Macedonian');
INSERT IGNORE INTO languages (code, name)
VALUES (NULL, 'Malaysian');
INSERT IGNORE INTO languages (code, name)
VALUES ('dv', 'Divehi');
INSERT IGNORE INTO languages (code, name)
VALUES ('mt', 'Maltese');
INSERT IGNORE INTO languages (code, name)
VALUES ('ro', 'Romanian');
INSERT IGNORE INTO languages (code, name)
VALUES ('mn', 'Mongolian');
INSERT IGNORE INTO languages (code, name)
VALUES ('sr', 'Serbian');
INSERT IGNORE INTO languages (code, name)
VALUES ('my', 'Burmese');
INSERT IGNORE INTO languages (code, name)
VALUES ('ne', 'Nepali');
INSERT IGNORE INTO languages (code, name)
VALUES ('ko', 'Korean');
INSERT IGNORE INTO languages (code, name)
VALUES ('no', 'Norwegian');
INSERT IGNORE INTO languages (code, name)
VALUES ('pl', 'Polish');
INSERT IGNORE INTO languages (code, name)
VALUES ('ru', 'Russian');
INSERT IGNORE INTO languages (code, name)
VALUES ('rw', 'Kinyarwanda');
INSERT IGNORE INTO languages (code, name)
VALUES ('sm', 'Samoan');
INSERT IGNORE INTO languages (code, name)
VALUES ('sk', 'Slovak');
INSERT IGNORE INTO languages (code, name)
VALUES ('sl', 'Slovene');
INSERT IGNORE INTO languages (code, name)
VALUES ('si', 'Sinhalese');
INSERT IGNORE INTO languages (code, name)
VALUES ('sv', 'Swedish');
INSERT IGNORE INTO languages (code, name)
VALUES ('tg', 'Tajik');
INSERT IGNORE INTO languages (code, name)
VALUES ('th', 'Thai');
INSERT IGNORE INTO languages (code, name)
VALUES ('tk', 'Turkmen');
INSERT IGNORE INTO languages (code, name)
VALUES ('uk', 'Ukrainian');
INSERT IGNORE INTO languages (code, name)
VALUES ('uz', 'Uzbek');
INSERT IGNORE INTO languages (code, name)
VALUES ('vi', 'Vietnamese');
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Afghanistan', 'AF', 'Kabul', 'AS', 'AFN', 'ps', 'https://restcountries.eu/data/afg.svg', '+93', '004'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Albania', 'AL', 'Tirana', 'EU', 'ALL', 'sq', 'https://restcountries.eu/data/alb.svg', '+355', '008'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Algeria', 'DZ', 'Algiers', 'AF', 'DZD', 'ar', 'https://restcountries.eu/data/dza.svg', '+213', '012'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'American Samoa', 'AS', 'Pago Pago', 'OC', 'USD', 'en', 'https://restcountries.eu/data/asm.svg', '+1', '016'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Andorra', 'AD', 'Andorra la Vella', 'EU', 'EUR', 'ca', 'https://restcountries.eu/data/and.svg', '+376', '020'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Angola', 'AO', 'Luanda', 'AF', 'AOA', 'pt', 'https://restcountries.eu/data/ago.svg', '+244', '024'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Anguilla', 'AI', 'The Valley', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/aia.svg', '+43', '660'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Antigua and Barbuda', 'AG', 'Saint John''s', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/atg.svg', '+1', '028'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Argentina', 'AR', 'Buenos Aires', 'SA', 'ARS', 'es', 'https://restcountries.eu/data/arg.svg', '+54', '032'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Armenia', 'AM', 'Yerevan', 'AS', 'AMD', 'hy', 'https://restcountries.eu/data/arm.svg', '+374', '051'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Aruba', 'AW', 'Oranjestad', 'SA', 'AWG', 'nl', 'https://restcountries.eu/data/abw.svg', '+297', '533'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Australia', 'AU', 'Canberra', 'OC', 'AUD', 'en', 'https://restcountries.eu/data/aus.svg', '+61', '036'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Azerbaijan', 'AZ', 'Baku', 'AS', 'AZN', 'az', 'https://restcountries.eu/data/aze.svg', '+994', '031'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bahamas', 'BS', 'Nassau', 'NA', 'BSD', 'en', 'https://restcountries.eu/data/bhs.svg', '+1', '044'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bahrain', 'BH', 'Manama', 'AS', 'BHD', 'ar', 'https://restcountries.eu/data/bhr.svg', '+973', '048'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bangladesh', 'BD', 'Dhaka', 'AS', 'BDT', 'bn', 'https://restcountries.eu/data/bgd.svg', '+880', '050'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Barbados', 'BB', 'Bridgetown', 'NA', 'BBD', 'en', 'https://restcountries.eu/data/brb.svg', '+1', '052'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Belarus', 'BY', 'Minsk', 'EU', 'BYN', 'be', 'https://restcountries.eu/data/blr.svg', '+375', '112'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Belgium', 'BE', 'Brussels', 'EU', 'EUR', 'nl', 'https://restcountries.eu/data/bel.svg', '+32', '056'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Belize', 'BZ', 'Belmopan', 'NA', 'BZD', 'en', 'https://restcountries.eu/data/blz.svg', '+501', '084'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Benin', 'BJ', 'Porto-Novo', 'AF', 'XOF', 'fr', 'https://restcountries.eu/data/ben.svg', '+229', '204'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bermuda', 'BM', 'Hamilton', 'NA', 'BMD', 'en', 'https://restcountries.eu/data/bmu.svg', '+1', '060'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bhutan', 'BT', 'Thimphu', 'AS', 'BTN', 'dz', 'https://restcountries.eu/data/btn.svg', '+975', '064'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bolivia (Plurinational State of)', 'BO', 'Sucre', 'SA', 'BOB', 'es', 'https://restcountries.eu/data/bol.svg', '+591', '068'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bosnia and Herzegovina', 'BA', 'Sarajevo', 'EU', 'BAM', 'bs', 'https://restcountries.eu/data/bih.svg', '+387', '070'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Botswana', 'BW', 'Gaborone', 'AF', 'BWP', 'en', 'https://restcountries.eu/data/bwa.svg', '+267', '072'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Brazil', 'BR', 'Brasília', 'SA', 'BRL', 'pt', 'https://restcountries.eu/data/bra.svg', '+55', '076'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'British Indian Ocean Territory', 'IO', 'Diego Garcia', 'AF', 'USD', 'en', 'https://restcountries.eu/data/iot.svg', '+246', '086'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Virgin Islands (British)', 'VG', 'Road Town', 'NA', 'USD', 'en', 'https://restcountries.eu/data/vgb.svg', '+1', '092'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Virgin Islands (U.S.)', 'VI', 'Charlotte Amalie', 'NA', 'USD', 'en', 'https://restcountries.eu/data/vir.svg', '+1', '850'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Brunei Darussalam', 'BN', 'Bandar Seri Begawan', 'AS', 'BND', 'ms', 'https://restcountries.eu/data/brn.svg', '+673', '096'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Bulgaria', 'BG', 'Sofia', 'EU', 'BGN', 'bg', 'https://restcountries.eu/data/bgr.svg', '+359', '100'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Burkina Faso', 'BF', 'Ouagadougou', 'AF', 'XOF', 'fr', 'https://restcountries.eu/data/bfa.svg', '+226', '854'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Burundi', 'BI', 'Bujumbura', 'AF', 'BIF', 'fr', 'https://restcountries.eu/data/bdi.svg', '+257', '108'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cambodia', 'KH', 'Phnom Penh', 'AS', 'KHR', 'km', 'https://restcountries.eu/data/khm.svg', '+855', '116'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cameroon', 'CM', 'Yaoundé', 'AF', 'XAF', 'en', 'https://restcountries.eu/data/cmr.svg', '+237', '120'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Canada', 'CA', 'Ottawa', 'NA', 'CAD', 'en', 'https://restcountries.eu/data/can.svg', '+1', '124'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cabo Verde', 'CV', 'Praia', 'AF', 'CVE', 'pt', 'https://restcountries.eu/data/cpv.svg', '+238', '132'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cayman Islands', 'KY', 'George Town', 'NA', 'KYD', 'en', 'https://restcountries.eu/data/cym.svg', '+1', '136'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Central African Republic', 'CF', 'Bangui', 'AF', 'XAF', 'fr', 'https://restcountries.eu/data/caf.svg', '+236', '140'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Central African Republic', 'CF', 'Bangui', 'AF', 'XAF', 'fr', 'https://restcountries.eu/data/caf.svg', '+236', '140'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Chile', 'CL', 'Santiago', 'SA', 'CLP', 'es', 'https://restcountries.eu/data/chl.svg', '+56', '152'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'China', 'CN', 'Beijing', 'AS', 'CNY', 'zh', 'https://restcountries.eu/data/chn.svg', '+86', '156'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Colombia', 'CO', 'Bogotá', 'SA', 'COP', 'es', 'https://restcountries.eu/data/col.svg', '+57', '170'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Comoros', 'KM', 'Moroni', 'AF', 'KMF', 'fr', 'https://restcountries.eu/data/com.svg', '+269', '174'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Congo', 'CG', 'Brazzaville', 'AF', 'XAF', 'fr', 'https://restcountries.eu/data/cog.svg', '+242', '178'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Congo (Democratic Republic of the)', 'CD', 'Kinshasa', 'AF', 'CDF', 'fr', 'https://restcountries.eu/data/cod.svg', '+243', '180'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cook Islands', 'CK', 'Avarua', 'OC', 'NZD', 'en', 'https://restcountries.eu/data/cok.svg', '+682', '184'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Costa Rica', 'CR', 'San José', 'NA', 'CRC', 'es', 'https://restcountries.eu/data/cri.svg', '+506', '188'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Croatia', 'HR', 'Zagreb', 'EU', 'HRK', 'hr', 'https://restcountries.eu/data/hrv.svg', '+385', '191'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cuba', 'CU', 'Havana', 'NA', 'CUC', 'es', 'https://restcountries.eu/data/cub.svg', '+53', '192'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cuba', 'CU', 'Havana', 'NA', 'CUC', 'es', 'https://restcountries.eu/data/cub.svg', '+53', '192'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Cyprus', 'CY', 'Nicosia', 'EU', 'EUR', 'tr', 'https://restcountries.eu/data/cyp.svg', '+357', '196'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Czech Republic', 'CZ', 'Prague', 'EU', 'CZK', 'cs', 'https://restcountries.eu/data/cze.svg', '+420', '203'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Denmark', 'DK', 'Copenhagen', 'EU', 'DKK', 'da', 'https://restcountries.eu/data/dnk.svg', '+45', '208'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Djibouti', 'DJ', 'Djibouti', 'AF', 'DJF', 'fr', 'https://restcountries.eu/data/dji.svg', '+253', '262'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Dominica', 'DM', 'Roseau', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/dma.svg', '+1', '212'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Dominican Republic', 'DO', 'Santo Domingo', 'NA', 'DOP', 'es', 'https://restcountries.eu/data/dom.svg', '+1', '214'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Ecuador', 'EC', 'Quito', 'SA', 'USD', 'es', 'https://restcountries.eu/data/ecu.svg', '+593', '218'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Egypt', 'EG', 'Cairo', 'AF', 'EGP', 'ar', 'https://restcountries.eu/data/egy.svg', '+20', '818'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'El Salvador', 'SV', 'San Salvador', 'NA', 'USD', 'es', 'https://restcountries.eu/data/slv.svg', '+503', '222'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Equatorial Guinea', 'GQ', 'Malabo', 'AF', 'XAF', 'es', 'https://restcountries.eu/data/gnq.svg', '+240', '226'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Eritrea', 'ER', 'Asmara', 'AF', 'ERN', 'en', 'https://restcountries.eu/data/eri.svg', '+291', '232'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Estonia', 'EE', 'Tallinn', 'EU', 'EUR', 'et', 'https://restcountries.eu/data/est.svg', '+372', '233'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Ethiopia', 'ET', 'Addis Ababa', 'AF', 'ETB', 'am', 'https://restcountries.eu/data/eth.svg', '+251', '231'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Falkland Islands (Malvinas)', 'FK', 'Stanley', 'SA', 'FKP', 'en', 'https://restcountries.eu/data/flk.svg', '+500', '238'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Faroe Islands', 'FO', 'Tórshavn', 'EU', 'DKK', 'fo', 'https://restcountries.eu/data/fro.svg', '+298', '234'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Fiji', 'FJ', 'Suva', 'OC', 'FJD', 'en', 'https://restcountries.eu/data/fji.svg', '+679', '242'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Finland', 'FI', 'Helsinki', 'EU', 'EUR', 'fi', 'https://restcountries.eu/data/fin.svg', '+358', '246'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'France', 'FR', 'Paris', 'EU', 'EUR', 'fr', 'https://restcountries.eu/data/fra.svg', '+33', '250'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'French Guiana', 'GF', 'Cayenne', 'SA', 'EUR', 'fr', 'https://restcountries.eu/data/guf.svg', '+594', '254'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'French Polynesia', 'PF', 'Papeetē', 'OC', 'XPF', 'fr', 'https://restcountries.eu/data/pyf.svg', '+689', '258'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Gabon', 'GA', 'Libreville', 'AF', 'XAF', 'fr', 'https://restcountries.eu/data/gab.svg', '+241', '266'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Gambia', 'GM', 'Banjul', 'AF', 'GMD', 'en', 'https://restcountries.eu/data/gmb.svg', '+220', '270'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Georgia', 'GE', 'Tbilisi', 'AS', 'GEL', 'ka', 'https://restcountries.eu/data/geo.svg', '+995', '268'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Germany', 'DE', 'Berlin', 'EU', 'EUR', 'de', 'https://restcountries.eu/data/deu.svg', '+49', '276'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Ghana', 'GH', 'Accra', 'AF', 'GHS', 'en', 'https://restcountries.eu/data/gha.svg', '+233', '288'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Gibraltar', 'GI', 'Gibraltar', 'EU', 'GIP', 'en', 'https://restcountries.eu/data/gib.svg', '+350', '292'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Greece', 'GR', 'Athens', 'EU', 'EUR', 'el', 'https://restcountries.eu/data/grc.svg', '+30', '300'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Greenland', 'GL', 'Nuuk', 'NA', 'DKK', 'kl', 'https://restcountries.eu/data/grl.svg', '+299', '304'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Grenada', 'GD', 'St. George''s', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/grd.svg', '+1', '308'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Guadeloupe', 'GP', 'Basse-Terre', 'NA', 'EUR', 'fr', 'https://restcountries.eu/data/glp.svg', '+590', '312'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Guam', 'GU', 'Hagåtña', 'OC', 'USD', 'en', 'https://restcountries.eu/data/gum.svg', '+1', '316'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Guatemala', 'GT', 'Guatemala City', 'NA', 'GTQ', 'es', 'https://restcountries.eu/data/gtm.svg', '+502', '320'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Guinea', 'GN', 'Conakry', 'AF', 'GNF', 'fr', 'https://restcountries.eu/data/gin.svg', '+224', '324'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Guinea-Bissau', 'GW', 'Bissau', 'AF', 'XOF', 'pt', 'https://restcountries.eu/data/gnb.svg', '+245', '624'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Guyana', 'GY', 'Georgetown', 'SA', 'GYD', 'en', 'https://restcountries.eu/data/guy.svg', '+592', '328'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Haiti', 'HT', 'Port-au-Prince', 'Americas', 'HTG', 'fr', 'https://restcountries.eu/data/hti.svg', '+509', '332'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Holy See', 'VA', 'Rome', 'EU', 'EUR', 'fr', 'https://restcountries.eu/data/vat.svg', '+39', '336'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Honduras', 'HN', 'Tegucigalpa', 'NA', 'HNL', 'es', 'https://restcountries.eu/data/hnd.svg', '+504', '340'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Hong Kong', 'HK', 'City of Victoria', 'AS', 'HKD', 'en', 'https://restcountries.eu/data/hkg.svg', '+852', '344'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Hungary', 'HU', 'Budapest', 'EU', 'HUF', 'hu', 'https://restcountries.eu/data/hun.svg', '+36', '348'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Iceland', 'IS', 'Reykjavík', 'EU', 'ISK', 'is', 'https://restcountries.eu/data/isl.svg', '+354', '352'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'India', 'IN', 'New Delhi', 'AS', 'INR', 'hi', 'https://restcountries.eu/data/ind.svg', '+91', '356'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Indonesia', 'ID', 'Jakarta', 'AS', 'IDR', 'id', 'https://restcountries.eu/data/idn.svg', '+62', '360'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Côte d''Ivoire', 'CI', 'Yamoussoukro', 'AF', 'XOF', 'fr', 'https://restcountries.eu/data/civ.svg', '+225', '384'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Iran (Islamic Republic of)', 'IR', 'Tehran', 'AS', 'IRR', 'fa', 'https://restcountries.eu/data/irn.svg', '+98', '364'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Iraq', 'IQ', 'Baghdad', 'AS', 'IQD', 'ar', 'https://restcountries.eu/data/irq.svg', '+964', '368'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Ireland', 'IE', 'Dublin', 'EU', 'EUR', 'ga', 'https://restcountries.eu/data/irl.svg', '+353', '372'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Israel', 'IL', 'Jerusalem', 'AS', 'ILS', 'he', 'https://restcountries.eu/data/isr.svg', '+972', '376'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Italy', 'IT', 'Rome', 'EU', 'EUR', 'it', 'https://restcountries.eu/data/ita.svg', '+39', '380'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Jamaica', 'JM', 'Kingston', 'NA', 'JMD', 'en', 'https://restcountries.eu/data/jam.svg', '+1', '388'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Japan', 'JP', 'Tokyo', 'AS', 'JPY', 'ja', 'https://restcountries.eu/data/jpn.svg', '+81', '392'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Jordan', 'JO', 'Amman', 'AS', 'JOD', 'ar', 'https://restcountries.eu/data/jor.svg', '+962', '400'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Kazakhstan', 'KZ', 'Astana', 'AS', 'KZT', 'kk', 'https://restcountries.eu/data/kaz.svg', '+7', '398'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Kenya', 'KE', 'Nairobi', 'AF', 'KES', 'en', 'https://restcountries.eu/data/ken.svg', '+254', '404'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Kiribati', 'KI', 'South Tarawa', 'OC', 'AUD', 'en', 'https://restcountries.eu/data/kir.svg', '+686', '296'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Kuwait', 'KW', 'Kuwait City', 'AS', 'KWD', 'ar', 'https://restcountries.eu/data/kwt.svg', '+965', '414'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Kyrgyzstan', 'KG', 'Bishkek', 'AS', 'KGS', 'ky', 'https://restcountries.eu/data/kgz.svg', '+996', '417'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Lao People''s Democratic Republic', 'LA', 'Vientiane', 'AS', 'LAK', 'lo', 'https://restcountries.eu/data/lao.svg', '+856', '418'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Latvia', 'LV', 'Riga', 'EU', 'EUR', 'lv', 'https://restcountries.eu/data/lva.svg', '+371', '428'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Lebanon', 'LB', 'Beirut', 'AS', 'LBP', 'ar', 'https://restcountries.eu/data/lbn.svg', '+961', '422'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Lesotho', 'LS', 'Maseru', 'AF', 'LSL', 'en', 'https://restcountries.eu/data/lso.svg', '+266', '426'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Liberia', 'LR', 'Monrovia', 'AF', 'LRD', 'en', 'https://restcountries.eu/data/lbr.svg', '+231', '430'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Libya', 'LY', 'Tripoli', 'AF', 'LYD', 'ar', 'https://restcountries.eu/data/lby.svg', '+218', '434'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Liechtenstein', 'LI', 'Vaduz', 'EU', 'CHF', 'de', 'https://restcountries.eu/data/lie.svg', '+423', '438'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Lithuania', 'LT', 'Vilnius', 'EU', 'EUR', 'lt', 'https://restcountries.eu/data/ltu.svg', '+370', '440'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Luxembourg', 'LU', 'Luxembourg', 'EU', 'EUR', 'fr', 'https://restcountries.eu/data/lux.svg', '+352', '442'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Macao', 'MO', '', 'AS', 'MOP', 'zh', 'https://restcountries.eu/data/mac.svg', '+853', '446'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Macedonia (the former Yugoslav Republic of)', 'MK', 'Skopje', 'EU', 'MKD', 'mk', 'https://restcountries.eu/data/mkd.svg', '+389', '807'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Madagascar', 'MG', 'Antananarivo', 'AF', 'MGA', 'fr', 'https://restcountries.eu/data/mdg.svg', '+261', '450'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Malawi', 'MW', 'Lilongwe', 'AF', 'MWK', 'en', 'https://restcountries.eu/data/mwi.svg', '+265', '454'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Malaysia', 'MY', 'Kuala Lumpur', 'AS', 'MYR', NULL, 'https://restcountries.eu/data/mys.svg', '+60', '458'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Maldives', 'MV', 'Malé', 'AS', 'MVR', 'dv', 'https://restcountries.eu/data/mdv.svg', '+960', '462'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Mali', 'ML', 'Bamako', 'AF', 'XOF', 'fr', 'https://restcountries.eu/data/mli.svg', '+223', '466'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Malta', 'MT', 'Valletta', 'EU', 'EUR', 'mt', 'https://restcountries.eu/data/mlt.svg', '+356', '470'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Marshall Islands', 'MH', 'Majuro', 'OC', 'USD', 'en', 'https://restcountries.eu/data/mhl.svg', '+692', '584'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Martinique', 'MQ', 'Fort-de-France', 'Americas', 'EUR', 'fr', 'https://restcountries.eu/data/mtq.svg', '+596', '474'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Mauritania', 'MR', 'Nouakchott', 'AF', 'MRO', 'ar', 'https://restcountries.eu/data/mrt.svg', '+222', '478'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Mauritius', 'MU', 'Port Louis', 'AF', 'MUR', 'en', 'https://restcountries.eu/data/mus.svg', '+230', '480'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Mayotte', 'YT', 'Mamoudzou', 'AF', 'EUR', 'fr', 'https://restcountries.eu/data/myt.svg', '+262', '175'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Mexico', 'MX', 'Mexico City', 'NA', 'MXN', 'es', 'https://restcountries.eu/data/mex.svg', '+52', '484'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Micronesia (Federated States of)', 'FM', 'Palikir', 'OC', 'USD', 'en', 'https://restcountries.eu/data/fsm.svg', '+691', '583'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Moldova (Republic of)', 'MD', 'Chișinău', 'EU', 'MDL', 'ro', 'https://restcountries.eu/data/mda.svg', '+373', '498'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Monaco', 'MC', 'Monaco', 'EU', 'EUR', 'fr', 'https://restcountries.eu/data/mco.svg', '+377', '492'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Mongolia', 'MN', 'Ulan Bator', 'AS', 'MNT', 'mn', 'https://restcountries.eu/data/mng.svg', '+976', '496'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Montenegro', 'ME', 'Podgorica', 'EU', 'EUR', 'sr', 'https://restcountries.eu/data/mne.svg', '+382', '499'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Montserrat', 'MS', 'Plymouth', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/msr.svg', '+1', '500'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Morocco', 'MA', 'Rabat', 'AF', 'MAD', 'ar', 'https://restcountries.eu/data/mar.svg', '+212', '504'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Mozambique', 'MZ', 'Maputo', 'AF', 'MZN', 'pt', 'https://restcountries.eu/data/moz.svg', '+258', '508'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Myanmar', 'MM', 'Naypyidaw', 'AS', 'MMK', 'my', 'https://restcountries.eu/data/mmr.svg', '+95', '104'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Namibia', 'NA', 'Windhoek', 'AF', 'NAD', 'en', 'https://restcountries.eu/data/nam.svg', '+264', '516'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Nauru', 'NR', 'Yaren', 'OC', 'AUD', 'en', 'https://restcountries.eu/data/nru.svg', '+674', '520'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Nepal', 'NP', 'Kathmandu', 'AS', 'NPR', 'ne', 'https://restcountries.eu/data/npl.svg', '+977', '524'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Netherlands', 'NL', 'Amsterdam', 'EU', 'EUR', 'nl', 'https://restcountries.eu/data/nld.svg', '+31', '528'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'New Caledonia', 'NC', 'Nouméa', 'OC', 'XPF', 'fr', 'https://restcountries.eu/data/ncl.svg', '+687', '540'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'New Zealand', 'NZ', 'Wellington', 'OC', 'NZD', 'en', 'https://restcountries.eu/data/nzl.svg', '+64', '554'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Nicaragua', 'NI', 'Managua', 'NA', 'NIO', 'es', 'https://restcountries.eu/data/nic.svg', '+505', '558'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Niger', 'NE', 'Niamey', 'AF', 'XOF', 'fr', 'https://restcountries.eu/data/ner.svg', '+227', '562'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Nigeria', 'NG', 'Abuja', 'AF', 'NGN', 'en', 'https://restcountries.eu/data/nga.svg', '+234', '566'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Niue', 'NU', 'Alofi', 'OC', 'NZD', 'en', 'https://restcountries.eu/data/niu.svg', '+683', '570'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Norfolk Island', 'NF', 'Kingston', 'OC', 'AUD', 'en', 'https://restcountries.eu/data/nfk.svg', '+672', '574'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Korea (Democratic People''s Republic of)', 'KP', 'Pyongyang', 'AS', 'KPW', 'ko', 'https://restcountries.eu/data/prk.svg', '+850', '408'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Northern Mariana Islands', 'MP', 'Saipan', 'OC', 'USD', 'en', 'https://restcountries.eu/data/mnp.svg', '+1', '580'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Norway', 'NO', 'Oslo', 'EU', 'NOK', 'no', 'https://restcountries.eu/data/nor.svg', '+47', '578'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Oman', 'OM', 'Muscat', 'AS', 'OMR', 'ar', 'https://restcountries.eu/data/omn.svg', '+968', '512'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Pakistan', 'PK', 'Islamabad', 'AS', 'PKR', 'en', 'https://restcountries.eu/data/pak.svg', '+92', '586'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Palau', 'PW', 'Ngerulmud', 'OC', 'USD', 'en', 'https://restcountries.eu/data/plw.svg', '+680', '585'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Palestine, State of', 'PS', 'Ramallah', 'AS', 'ILS', 'ar', 'https://restcountries.eu/data/pse.svg', '+970', '275'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Panama', 'PA', 'Panama City', 'NA', 'USD', 'es', 'https://restcountries.eu/data/pan.svg', '+507', '591'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Papua New Guinea', 'PG', 'Port Moresby', 'OC', 'PGK', 'en', 'https://restcountries.eu/data/png.svg', '+675', '598'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Paraguay', 'PY', 'Asunción', 'SA', 'PYG', 'es', 'https://restcountries.eu/data/pry.svg', '+595', '600'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Peru', 'PE', 'Lima', 'SA', 'PEN', 'es', 'https://restcountries.eu/data/per.svg', '+51', '604'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Philippines', 'PH', 'Manila', 'AS', 'PHP', 'en', 'https://restcountries.eu/data/phl.svg', '+63', '608'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Poland', 'PL', 'Warsaw', 'EU', 'PLN', 'pl', 'https://restcountries.eu/data/pol.svg', '+48', '616'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Portugal', 'PT', 'Lisbon', 'EU', 'EUR', 'pt', 'https://restcountries.eu/data/prt.svg', '+351', '620'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Puerto Rico', 'PR', 'San Juan', 'NA', 'USD', 'es', 'https://restcountries.eu/data/pri.svg', '+1', '630'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Qatar', 'QA', 'Doha', 'AS', 'QAR', 'ar', 'https://restcountries.eu/data/qat.svg', '+974', '634'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Republic of Kosovo', 'XK', 'Pristina', 'EU', 'EUR', 'sq', 'https://restcountries.eu/data/kos.svg', '+381', '383'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Réunion', 'RE', 'Saint-Denis', 'AF', 'EUR', 'fr', 'https://restcountries.eu/data/reu.svg', '+262', '638'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Romania', 'RO', 'Bucharest', 'EU', 'RON', 'ro', 'https://restcountries.eu/data/rou.svg', '+40', '642'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Russian Federation', 'RU', 'Moscow', 'EU', 'RUB', 'ru', 'https://restcountries.eu/data/rus.svg', '+7', '643'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Rwanda', 'RW', 'Kigali', 'AF', 'RWF', 'rw', 'https://restcountries.eu/data/rwa.svg', '+250', '646'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saint Barthélemy', 'BL', 'Gustavia', 'NA', 'EUR', 'fr', 'https://restcountries.eu/data/blm.svg', '+590', '652'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saint Helena, Ascension and Tristan da Cunha', 'SH', 'Jamestown', 'AF', 'SHP', 'en', 'https://restcountries.eu/data/shn.svg', '+290', '654'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saint Kitts and Nevis', 'KN', 'Basseterre', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/kna.svg', '+1', '659'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saint Lucia', 'LC', 'Castries', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/lca.svg', '+1', '662'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saint Martin (French part)', 'MF', 'Marigot', 'NA', 'EUR', 'en', 'https://restcountries.eu/data/maf.svg', '+590', '663'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saint Pierre and Miquelon', 'PM', 'Saint-Pierre', 'NA', 'EUR', 'fr', 'https://restcountries.eu/data/spm.svg', '+508', '666'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saint Vincent and the Grenadines', 'VC', 'Kingstown', 'NA', 'XCD', 'en', 'https://restcountries.eu/data/vct.svg', '+1', '670'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Samoa', 'WS', 'Apia', 'OC', 'WST', 'sm', 'https://restcountries.eu/data/wsm.svg', '+685', '882'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'San Marino', 'SM', 'City of San Marino', 'EU', 'EUR', 'it', 'https://restcountries.eu/data/smr.svg', '+378', '674'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Sao Tome and Principe', 'ST', 'São Tomé', 'AF', 'STD', 'pt', 'https://restcountries.eu/data/stp.svg', '+239', '678'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Saudi Arabia', 'SA', 'Riyadh', 'AS', 'SAR', 'ar', 'https://restcountries.eu/data/sau.svg', '+966', '682'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Senegal', 'SN', 'Dakar', 'AF', 'XOF', 'fr', 'https://restcountries.eu/data/sen.svg', '+221', '686'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Serbia', 'RS', 'Belgrade', 'EU', 'RSD', 'sr', 'https://restcountries.eu/data/srb.svg', '+381', '688'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Seychelles', 'SC', 'Victoria', 'AF', 'SCR', 'fr', 'https://restcountries.eu/data/syc.svg', '+248', '690'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Sierra Leone', 'SL', 'Freetown', 'AF', 'SLL', 'en', 'https://restcountries.eu/data/sle.svg', '+232', '694'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Singapore', 'SG', 'Singapore', 'AS', 'SGD', 'en', 'https://restcountries.eu/data/sgp.svg', '+65', '702'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Singapore', 'SG', 'Singapore', 'AS', 'SGD', 'en', 'https://restcountries.eu/data/sgp.svg', '+65', '702'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Slovakia', 'SK', 'Bratislava', 'EU', 'EUR', 'sk', 'https://restcountries.eu/data/svk.svg', '+421', '703'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Slovenia', 'SI', 'Ljubljana', 'EU', 'EUR', 'sl', 'https://restcountries.eu/data/svn.svg', '+386', '705'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Solomon Islands', 'SB', 'Honiara', 'OC', 'SBD', 'en', 'https://restcountries.eu/data/slb.svg', '+677', '090'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Somalia', 'SO', 'Mogadishu', 'AF', 'SOS', 'ar', 'https://restcountries.eu/data/som.svg', '+252', '706'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'South Africa', 'ZA', 'Pretoria', 'AF', 'ZAR', 'en', 'https://restcountries.eu/data/zaf.svg', '+27', '710'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Korea (Republic of)', 'KR', 'Seoul', 'AS', 'KRW', 'ko', 'https://restcountries.eu/data/kor.svg', '+82', '410'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Spain', 'ES', 'Madrid', 'EU', 'EUR', 'es', 'https://restcountries.eu/data/esp.svg', '+34', '724'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Sri Lanka', 'LK', 'Colombo', 'AS', 'LKR', 'si', 'https://restcountries.eu/data/lka.svg', '+94', '144'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Sudan', 'SD', 'Khartoum', 'AF', 'SDG', 'ar', 'https://restcountries.eu/data/sdn.svg', '+249', '729'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Suriname', 'SR', 'Paramaribo', 'SA', 'SRD', 'nl', 'https://restcountries.eu/data/sur.svg', '+597', '740'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Swaziland', 'SZ', 'Lobamba', 'AF', 'SZL', 'en', 'https://restcountries.eu/data/swz.svg', '+268', '748'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Sweden', 'SE', 'Stockholm', 'EU', 'SEK', 'sv', 'https://restcountries.eu/data/swe.svg', '+46', '752'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Switzerland', 'CH', 'Bern', 'EU', 'CHF', 'de', 'https://restcountries.eu/data/che.svg', '+41', '756'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Syrian Arab Republic', 'SY', 'Damascus', 'AS', 'SYP', 'ar', 'https://restcountries.eu/data/syr.svg', '+963', '760'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Taiwan', 'TW', 'Taipei', 'AS', 'TWD', 'zh', 'https://restcountries.eu/data/twn.svg', '+886', '158'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Tajikistan', 'TJ', 'Dushanbe', 'AS', 'TJS', 'tg', 'https://restcountries.eu/data/tjk.svg', '+992', '762'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Tanzania, United Republic of', 'TZ', 'Dodoma', 'AF', 'TZS', 'en', 'https://restcountries.eu/data/tza.svg', '+255', '834'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Thailand', 'TH', 'Bangkok', 'AS', 'THB', 'th', 'https://restcountries.eu/data/tha.svg', '+66', '764'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Timor-Leste', 'TL', 'Dili', 'AS', 'USD', 'pt', 'https://restcountries.eu/data/tls.svg', '+670', '626'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Togo', 'TG', 'Lomé', 'AF', 'XOF', 'fr', 'https://restcountries.eu/data/tgo.svg', '+228', '768'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Tokelau', 'TK', 'Fakaofo', 'OC', 'NZD', 'en', 'https://restcountries.eu/data/tkl.svg', '+690', '772'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Tonga', 'TO', 'Nuku''alofa', 'OC', 'TOP', 'en', 'https://restcountries.eu/data/ton.svg', '+676', '776'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Trinidad and Tobago', 'TT', 'Port of Spain', 'SA', 'TTD', 'en', 'https://restcountries.eu/data/tto.svg', '+1', '780'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Tunisia', 'TN', 'Tunis', 'AF', 'TND', 'ar', 'https://restcountries.eu/data/tun.svg', '+216', '788'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Turkey', 'TR', 'Ankara', 'AS', 'TRY', 'tr', 'https://restcountries.eu/data/tur.svg', '+90', '792'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Turkmenistan', 'TM', 'Ashgabat', 'AS', 'TMT', 'tk', 'https://restcountries.eu/data/tkm.svg', '+993', '795'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Turks and Caicos Islands', 'TC', 'Cockburn Town', 'NA', 'USD', 'en', 'https://restcountries.eu/data/tca.svg', '+1', '796'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Tuvalu', 'TV', 'Funafuti', 'OC', 'AUD', 'en', 'https://restcountries.eu/data/tuv.svg', '+688', '798'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Uganda', 'UG', 'Kampala', 'AF', 'UGX', 'en', 'https://restcountries.eu/data/uga.svg', '+256', '800'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Ukraine', 'UA', 'Kyiv', 'EU', 'UAH', 'uk', 'https://restcountries.eu/data/ukr.svg', '+380', '804'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'United Arab Emirates', 'AE', 'Abu Dhabi', 'AS', 'AED', 'ar', 'https://restcountries.eu/data/are.svg', '+971', '784'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'United Kingdom of Great Britain and Northern Ireland', 'GB', 'London', 'EU', 'GBP', 'en', 'https://restcountries.eu/data/gbr.svg', '+44', '826'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'United States of America', 'US', 'Washington, D.C.', 'NA', 'USD', 'en', 'https://restcountries.eu/data/usa.svg', '+1', '840'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Uruguay', 'UY', 'Montevideo', 'SA', 'UYU', 'es', 'https://restcountries.eu/data/ury.svg', '+598', '858'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Uzbekistan', 'UZ', 'Tashkent', 'AS', 'UZS', 'uz', 'https://restcountries.eu/data/uzb.svg', '+998', '860'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Vanuatu', 'VU', 'Port Vila', 'OC', 'VUV', 'en', 'https://restcountries.eu/data/vut.svg', '+678', '548'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Venezuela (Bolivarian Republic of)', 'VE', 'Caracas', 'SA', 'VEF', 'es', 'https://restcountries.eu/data/ven.svg', '+58', '862'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Viet Nam', 'VN', 'Hanoi', 'AS', 'VND', 'vi', 'https://restcountries.eu/data/vnm.svg', '+84', '704'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Wallis and Futuna', 'WF', 'Mata-Utu', 'OC', 'XPF', 'fr', 'https://restcountries.eu/data/wlf.svg', '+681', '876'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Wallis and Futuna', 'WF', 'Mata-Utu', 'OC', 'XPF', 'fr', 'https://restcountries.eu/data/wlf.svg', '+681', '876'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Yemen', 'YE', 'Sana''a', 'AS', 'YER', 'ar', 'https://restcountries.eu/data/yem.svg', '+967', '887'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Zambia', 'ZM', 'Lusaka', 'AF', 'ZMW', 'en', 'https://restcountries.eu/data/zmb.svg', '+260', '894'
);
INSERT INTO countries (
name, code, capital, region, currency_code, language_code, flag_url, dialling_code, iso_code
) VALUES (
'Zimbabwe', 'ZW', 'Harare', 'AF', 'BWP', 'en', 'https://restcountries.eu/data/zwe.svg', '+263', '716'
);
`
Please kindly update the name of North Macedonia.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi,
a fixed version of the json list. I replace nested " with apostph char ’ in order to avoid error in json and js files.
i.e. {"name": "Korea, Democratic People"S Republic of", "code": "KP"} become {"name": "Korea, Democratic People’S Republic of", "code": "KP"}
Regards,
Davide