-
Star
(869)
You must be signed in to star a gist -
Fork
(317)
You must be signed in to fork a gist
-
-
Save keeguon/2310008 to your computer and use it in GitHub Desktop.
| [ | |
| {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'} | |
| ] |
typo: AndorrA
Is "AndorrA" meant to end with a capital 'A'?
And "RWANDA" seems to be in ALL_CAPS.
Are these intentional?
Is "AndorrA" meant to end with a capital 'A'? And "RWANDA" seems to be in ALL_CAPS.
Are these intentional?
"Andorra" should be written with a lowercase "a".Regarding "Rwanda," I believe only the "R" should be capitalized, but I am not entirely sure
Hey ! Folks, I see a lot of people are landing here, and sadly had no time to update it, kind of scrolled through the messages I like the idea of having more data like currency, number prefix in some messages, would you like me to update it w/ all those metadata and a recent update w/ country changes since it's dating a bit ?
yes
Fixed all typos with Claude Code
const countries = [
['AF', 'Afghanistan'],
['AX', 'Åland Islands'],
['AL', 'Albania'],
['DZ', 'Algeria'],
['AS', 'American Samoa'],
['AD', 'AndorrA'],
['AO', 'Angola'],
['AI', 'Anguilla'],
['AQ', 'Antarctica'],
['AG', 'Antigua and Barbuda'],
['AR', 'Argentina'],
['AM', 'Armenia'],
['AW', 'Aruba'],
['AU', 'Australia'],
['AT', 'Austria'],
['AZ', 'Azerbaijan'],
['BS', 'Bahamas'],
['BH', 'Bahrain'],
['BD', 'Bangladesh'],
['BB', 'Barbados'],
['BY', 'Belarus'],
['BE', 'Belgium'],
['BZ', 'Belize'],
['BJ', 'Benin'],
['BM', 'Bermuda'],
['BT', 'Bhutan'],
['BO', 'Bolivia'],
['BA', 'Bosnia and Herzegovina'],
['BW', 'Botswana'],
['BV', 'Bouvet Island'],
['BR', 'Brazil'],
['IO', 'British Indian Ocean Territory'],
['BN', 'Brunei Darussalam'],
['BG', 'Bulgaria'],
['BF', 'Burkina Faso'],
['BI', 'Burundi'],
['KH', 'Cambodia'],
['CM', 'Cameroon'],
['CA', 'Canada'],
['CV', 'Cape Verde'],
['KY', 'Cayman Islands'],
['CF', 'Central African Republic'],
['TD', 'Chad'],
['CL', 'Chile'],
['CN', 'China'],
['CX', 'Christmas Island'],
['CC', 'Cocos (Keeling) Islands'],
['CO', 'Colombia'],
['KM', 'Comoros'],
['CG', 'Congo'],
['CD', 'Congo, The Democratic Republic of the'],
['CK', 'Cook Islands'],
['CR', 'Costa Rica'],
['CI', 'Cote D"Ivoire'],
['HR', 'Croatia'],
['CU', 'Cuba'],
['CY', 'Cyprus'],
['CZ', 'Czech Republic'],
['DK', 'Denmark'],
['DJ', 'Djibouti'],
['DM', 'Dominica'],
['DO', 'Dominican Republic'],
['EC', 'Ecuador'],
['EG', 'Egypt'],
['SV', 'El Salvador'],
['GQ', 'Equatorial Guinea'],
['ER', 'Eritrea'],
['EE', 'Estonia'],
['ET', 'Ethiopia'],
['FK', 'Falkland Islands (Malvinas)'],
['FO', 'Faroe Islands'],
['FJ', 'Fiji'],
['FI', 'Finland'],
['FR', 'France'],
['GF', 'French Guiana'],
['PF', 'French Polynesia'],
['TF', 'French Southern Territories'],
['GA', 'Gabon'],
['GM', 'Gambia'],
['GE', 'Georgia'],
['DE', 'Germany'],
['GH', 'Ghana'],
['GI', 'Gibraltar'],
['GR', 'Greece'],
['GL', 'Greenland'],
['GD', 'Grenada'],
['GP', 'Guadeloupe'],
['GU', 'Guam'],
['GT', 'Guatemala'],
['GG', 'Guernsey'],
['GN', 'Guinea'],
['GW', 'Guinea-Bissau'],
['GY', 'Guyana'],
['HT', 'Haiti'],
['HM', 'Heard Island and Mcdonald Islands'],
['VA', 'Holy See (Vatican City State)'],
['HN', 'Honduras'],
['HK', 'Hong Kong'],
['HU', 'Hungary'],
['IS', 'Iceland'],
['IN', 'India'],
['code', 'Indonesia'],
['IR', 'Iran, Islamic Republic Of'],
['IQ', 'Iraq'],
['IE', 'Ireland'],
['IM', 'Isle of Man'],
['IL', 'Israel'],
['IT', 'Italy'],
['JM', 'Jamaica'],
['JP', 'Japan'],
['JE', 'Jersey'],
['JO', 'Jordan'],
['KZ', 'Kazakhstan'],
['KE', 'Kenya'],
['KI', 'Kiribati'],
['KP', 'Korea, Democratic People's Republic of'],
['KR', 'Korea, Republic of'],
['KW', 'Kuwait'],
['KG', 'Kyrgyzstan'],
['LA', 'Lao People's Democratic Republic'],
['LV', 'Latvia'],
['LB', 'Lebanon'],
['LS', 'Lesotho'],
['LR', 'Liberia'],
['LY', 'Libyan Arab Jamahiriya'],
['LI', 'Liechtenstein'],
['LT', 'Lithuania'],
['LU', 'Luxembourg'],
['MO', 'Macao'],
['MK', 'Macedonia, The Former Yugoslav Republic of'],
['MG', 'Madagascar'],
['MW', 'Malawi'],
['MY', 'Malaysia'],
['MV', 'Maldives'],
['ML', 'Mali'],
['MT', 'Malta'],
['MH', 'Marshall Islands'],
['MQ', 'Martinique'],
['MR', 'Mauritania'],
['MU', 'Mauritius'],
['YT', 'Mayotte'],
['MX', 'Mexico'],
['FM', 'Micronesia, Federated States of'],
['MD', 'Moldova, Republic of'],
['MC', 'Monaco'],
['MN', 'Mongolia'],
['MS', 'Montserrat'],
['MA', 'Morocco'],
['MZ', 'Mozambique'],
['MM', 'Myanmar'],
['NA', 'Namibia'],
['NR', 'Nauru'],
['NP', 'Nepal'],
['NL', 'Netherlands'],
['AN', 'Netherlands Antilles'],
['NC', 'New Caledonia'],
['NZ', 'New Zealand'],
['NI', 'Nicaragua'],
['NE', 'Niger'],
['NG', 'Nigeria'],
['NU', 'Niue'],
['NF', 'Norfolk Island'],
['MP', 'Northern Mariana Islands'],
['NO', 'Norway'],
['OM', 'Oman'],
['PK', 'Pakistan'],
['PW', 'Palau'],
['PS', 'Palestinian Territory, Occupied'],
['PA', 'Panama'],
['PG', 'Papua New Guinea'],
['PY', 'Paraguay'],
['PE', 'Peru'],
['PH', 'Philippines'],
['PN', 'Pitcairn'],
['PL', 'Poland'],
['PT', 'Portugal'],
['PR', 'Puerto Rico'],
['QA', 'Qatar'],
['RE', 'Reunion'],
['RO', 'Romania'],
['RU', 'Russian Federation'],
['RW', 'RWANDA'],
['SH', 'Saint Helena'],
['KN', 'Saint Kitts and Nevis'],
['LC', 'Saint Lucia'],
['PM', 'Saint Pierre and Miquelon'],
['VC', 'Saint Vincent and the Grenadines'],
['WS', 'Samoa'],
['SM', 'San Marino'],
['ST', 'Sao Tome and Principe'],
['SA', 'Saudi Arabia'],
['SN', 'Senegal'],
['CS', 'Serbia and Montenegro'],
['SC', 'Seychelles'],
['SL', 'Sierra Leone'],
['SG', 'Singapore'],
['SK', 'Slovakia'],
['SI', 'Slovenia'],
['SB', 'Solomon Islands'],
['SO', 'Somalia'],
['ZA', 'South Africa'],
['GS', 'South Georgia and the South Sandwich Islands'],
['ES', 'Spain'],
['LK', 'Sri Lanka'],
['SD', 'Sudan'],
['SR', 'Suriname'],
['SJ', 'Svalbard and Jan Mayen'],
['SZ', 'Swaziland'],
['SE', 'Sweden'],
['CH', 'Switzerland'],
['SY', 'Syrian Arab Republic'],
['TW', 'Taiwan, Province of China'],
['TJ', 'Tajikistan'],
['TZ', 'Tanzania, United Republic of'],
['TH', 'Thailand'],
['TL', 'Timor-Leste'],
['TG', 'Togo'],
['TK', 'Tokelau'],
['TO', 'Tonga'],
['TT', 'Trinidad and Tobago'],
['TN', 'Tunisia'],
['TR', 'Turkey'],
['TM', 'Turkmenistan'],
['TC', 'Turks and Caicos Islands'],
['TV', 'Tuvalu'],
['UG', 'Uganda'],
['UA', 'Ukraine'],
['AE', 'United Arab Emirates'],
['GB', 'United Kingdom'],
['US', 'United States'],
['UM', 'United States Minor Outlying Islands'],
['UY', 'Uruguay'],
['UZ', 'Uzbekistan'],
['VU', 'Vanuatu'],
['VE', 'Venezuela'],
['VN', 'Viet Nam'],
['VG', 'Virgin Islands, British'],
['VI', 'Virgin Islands, U.S.'],
['WF', 'Wallis and Futuna'],
['EH', 'Western Sahara'],
['YE', 'Yemen'],
['ZM', 'Zambia'],
['ZW', 'Zimbabwe'],
]
More error fixes by Gemini, made it human-readable (without "of" at the end):
const countries = [
['AF', 'Afghanistan'],
['AX', 'Aland Islands'],
['AL', 'Albania'],
['DZ', 'Algeria'],
['AS', 'American Samoa'],
['AD', 'Andorra'],
['AO', 'Angola'],
['AI', 'Anguilla'],
['AQ', 'Antarctica'],
['AG', 'Antigua and Barbuda'],
['AR', 'Argentina'],
['AM', 'Armenia'],
['AW', 'Aruba'],
['AU', 'Australia'],
['AT', 'Austria'],
['AZ', 'Azerbaijan'],
['BS', 'Bahamas'],
['BH', 'Bahrain'],
['BD', 'Bangladesh'],
['BB', 'Barbados'],
['BY', 'Belarus'],
['BE', 'Belgium'],
['BZ', 'Belize'],
['BJ', 'Benin'],
['BM', 'Bermuda'],
['BT', 'Bhutan'],
['BO', 'Bolivia'],
['BQ', 'Bonaire, Saba and St. Eustatius'],
['BA', 'Bosnia and Herzegovina'],
['BW', 'Botswana'],
['BV', 'Bouvet Island'],
['BR', 'Brazil'],
['IO', 'British Indian Ocean Territory'],
['VG', 'British Virgin Islands'],
['BN', 'Brunei'],
['BG', 'Bulgaria'],
['BF', 'Burkina Faso'],
['BI', 'Burundi'],
['CV', 'Cabo Verde'],
['KH', 'Cambodia'],
['CM', 'Cameroon'],
['CA', 'Canada'],
['KY', 'Cayman Islands'],
['CF', 'Central African Republic'],
['TD', 'Chad'],
['CL', 'Chile'],
['CN', 'China'],
['CX', 'Christmas Island'],
['CC', 'Cocos (Keeling) Islands'],
['CO', 'Colombia'],
['KM', 'Comoros'],
['CG', 'Congo (Brazzaville)'],
['CD', 'Congo (Kinshasa)'],
['CK', 'Cook Islands'],
['CR', 'Costa Rica'],
['CI', "Cote d'Ivoire"],
['HR', 'Croatia'],
['CU', 'Cuba'],
['CW', 'Curacao'],
['CY', 'Cyprus'],
['CZ', 'Czech Republic'],
['DK', 'Denmark'],
['DJ', 'Djibouti'],
['DM', 'Dominica'],
['DO', 'Dominican Republic'],
['EC', 'Ecuador'],
['EG', 'Egypt'],
['SV', 'El Salvador'],
['GQ', 'Equatorial Guinea'],
['ER', 'Eritrea'],
['EE', 'Estonia'],
['SZ', 'Eswatini'],
['ET', 'Ethiopia'],
['FK', 'Falkland Islands (Malvinas)'],
['FO', 'Faroe Islands'],
['FJ', 'Fiji'],
['FI', 'Finland'],
['FR', 'France'],
['GF', 'French Guiana'],
['PF', 'French Polynesia'],
['TF', 'French Southern Territories'],
['GA', 'Gabon'],
['GM', 'Gambia'],
['GE', 'Georgia'],
['DE', 'Germany'],
['GH', 'Ghana'],
['GI', 'Gibraltar'],
['GR', 'Greece'],
['GL', 'Greenland'],
['GD', 'Grenada'],
['GP', 'Guadeloupe'],
['GU', 'Guam'],
['GT', 'Guatemala'],
['GG', 'Guernsey'],
['GN', 'Guinea'],
['GW', 'Guinea-Bissau'],
['GY', 'Guyana'],
['HT', 'Haiti'],
['HM', 'Heard Island and McDonald Islands'],
['HN', 'Honduras'],
['HK', 'Hong Kong'],
['HU', 'Hungary'],
['IS', 'Iceland'],
['IN', 'India'],
['ID', 'Indonesia'],
['IR', 'Iran'],
['IQ', 'Iraq'],
['IE', 'Ireland'],
['IM', 'Isle of Man'],
['IL', 'Israel'],
['IT', 'Italy'],
['JM', 'Jamaica'],
['JP', 'Japan'],
['JE', 'Jersey'],
['JO', 'Jordan'],
['KZ', 'Kazakhstan'],
['KE', 'Kenya'],
['KI', 'Kiribati'],
['KP', 'Korea, North'],
['KR', 'Korea, South'],
['KW', 'Kuwait'],
['KG', 'Kyrgyzstan'],
['LA', 'Laos'],
['LV', 'Latvia'],
['LB', 'Lebanon'],
['LS', 'Lesotho'],
['LR', 'Liberia'],
['LY', 'Libya'],
['LI', 'Liechtenstein'],
['LT', 'Lithuania'],
['LU', 'Luxembourg'],
['MO', 'Macao'],
['MG', 'Madagascar'],
['MW', 'Malawi'],
['MY', 'Malaysia'],
['MV', 'Maldives'],
['ML', 'Mali'],
['MT', 'Malta'],
['MH', 'Marshall Islands'],
['MQ', 'Martinique'],
['MR', 'Mauritania'],
['MU', 'Mauritius'],
['YT', 'Mayotte'],
['MX', 'Mexico'],
['FM', 'Micronesia'],
['MD', 'Moldova'],
['MC', 'Monaco'],
['MN', 'Mongolia'],
['ME', 'Montenegro'],
['MS', 'Montserrat'],
['MA', 'Morocco'],
['MZ', 'Mozambique'],
['MM', 'Myanmar'],
['NA', 'Namibia'],
['NR', 'Nauru'],
['NP', 'Nepal'],
['NL', 'Netherlands'],
['NC', 'New Caledonia'],
['NZ', 'New Zealand'],
['NI', 'Nicaragua'],
['NE', 'Niger'],
['NG', 'Nigeria'],
['NU', 'Niue'],
['NF', 'Norfolk Island'],
['MK', 'North Macedonia'],
['MP', 'Northern Mariana Islands'],
['NO', 'Norway'],
['OM', 'Oman'],
['PK', 'Pakistan'],
['PW', 'Palau'],
['PS', 'Palestine'],
['PA', 'Panama'],
['PG', 'Papua New Guinea'],
['PY', 'Paraguay'],
['PE', 'Peru'],
['PH', 'Philippines'],
['PN', 'Pitcairn'],
['PL', 'Poland'],
['PT', 'Portugal'],
['PR', 'Puerto Rico'],
['QA', 'Qatar'],
['RE', 'Reunion'],
['RO', 'Romania'],
['RU', 'Russia'],
['RW', 'Rwanda'],
['SH', 'Saint Helena'],
['KN', 'Saint Kitts and Nevis'],
['LC', 'Saint Lucia'],
['PM', 'Saint Pierre and Miquelon'],
['VC', 'Saint Vincent and the Grenadines'],
['WS', 'Samoa'],
['SM', 'San Marino'],
['ST', 'Sao Tome and Principe'],
['SA', 'Saudi Arabia'],
['SN', 'Senegal'],
['RS', 'Serbia'],
['SC', 'Seychelles'],
['SL', 'Sierra Leone'],
['SG', 'Singapore'],
['SX', 'Sint Maarten'],
['SK', 'Slovakia'],
['SI', 'Slovenia'],
['SB', 'Solomon Islands'],
['SO', 'Somalia'],
['ZA', 'South Africa'],
['GS', 'South Georgia and the South Sandwich Islands'],
['ES', 'Spain'],
['LK', 'Sri Lanka'],
['SD', 'Sudan'],
['SR', 'Suriname'],
['SJ', 'Svalbard and Jan Mayen'],
['SE', 'Sweden'],
['CH', 'Switzerland'],
['SY', 'Syria'],
['TW', 'Taiwan'],
['TJ', 'Tajikistan'],
['TZ', 'Tanzania'],
['TH', 'Thailand'],
['TL', 'Timor-Leste'],
['TG', 'Togo'],
['TK', 'Tokelau'],
['TO', 'Tonga'],
['TT', 'Trinidad and Tobago'],
['TN', 'Tunisia'],
['TR', 'Turkey'],
['TM', 'Turkmenistan'],
['TC', 'Turks and Caicos Islands'],
['TV', 'Tuvalu'],
['VI', 'U.S. Virgin Islands'],
['UG', 'Uganda'],
['UA', 'Ukraine'],
['AE', 'United Arab Emirates'],
['GB', 'United Kingdom'],
['US', 'United States'],
['UM', 'United States Minor Outlying Islands'],
['UY', 'Uruguay'],
['UZ', 'Uzbekistan'],
['VU', 'Vanuatu'],
['VA', 'Vatican City'],
['VE', 'Venezuela'],
['VN', 'Vietnam'],
['WF', 'Wallis and Futuna'],
['EH', 'Western Sahara'],
['YE', 'Yemen'],
['ZM', 'Zambia'],
['ZW', 'Zimbabwe'],
]
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)
);
`