Skip to content

Instantly share code, notes, and snippets.

@marijn
Last active October 1, 2023 13:42
Show Gist options
  • Save marijn/396531 to your computer and use it in GitHub Desktop.
Save marijn/396531 to your computer and use it in GitHub Desktop.
List of countries in YAML, CSV and TXT format
@marijn
Copy link
Author

marijn commented Nov 29, 2019

@antag0n1st check https://github.com/umpirsky/country-list for a better list. There it is also easy to add a pull request.

Nonetheless, thanks for contributing.

@alerti
Copy link

alerti commented May 16, 2020

sql
INSERT INTO countries(name) VALUES
('Afghanistan'),
('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'),
('TP|East Timor'),
('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'),
('GD|Grenada'),
('GP|Guadeloupe'),
('GU|Guam'),
('GT|Guatemala'),
('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'),
('ID|Indonesia'),
('IR|Iran, Islamic Republic Of'),
('IQ|Iraq'),
('IE|Ireland'),
('IL|Israel'),
('IT|Italy'),
('JM|Jamaica'),
('JP|Japan'),
('JO|Jordan'),
('KZ|Kazakstan'),
('KE|Kenya'),
('KI|Kiribati'),
('KP|Korea, Democratic Peoples Republic Of'),
('KR|Korea, Republic Of'),
('KV|Kosovo'),
('KW|Kuwait'),
('KG|Kyrgyzstan'),
('LA|Lao Peoples Democratic Republic'),
('LV|Latvia'),
('LB|Lebanon'),
('LS|Lesotho'),
('LR|Liberia'),
('LY|Libyan Arab Jamahiriya'),
('LI|Liechtenstein'),
('LT|Lithuania'),
('LU|Luxembourg'),
('MO|Macau'),
('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'),
('ME|Montenegro'),
('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'),
('RS|Serbia'),
('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'),
('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');

@balatD
Copy link

balatD commented Jul 21, 2020

                Afghanistan: "Afghanistan"
                Albania: "Albania"
                Algeria: "Algeria"
                American Samoa: "American Samoa"
                Andorra: "Andorra"
                Angola: "Angola"
                Anguilla: "Anguilla"
                Antarctica: "Antarctica"
                Antigua And Barbuda: "Antigua And Barbuda"
                Argentina: "Argentina"
                Armenia: "Armenia"
                Aruba: "Aruba"
                Australia: "Australia"
                Austria: "Austria"
                Azerbaijan: "Azerbaijan"
                Bahamas: "Bahamas"
                Bahrain: "Bahrain"
                Bangladesh: "Bangladesh"
                Barbados: "Barbados"
                Belarus: "Belarus"
                Belgium: "Belgium"
                Belize: "Belize"
                Benin: "Benin"
                Bermuda: "Bermuda"
                Bhutan: "Bhutan"
                Bolivia: "Bolivia"
                Bosnia And Herzegovina: "Bosnia And Herzegovina"
                Botswana: "Botswana"
                Bouvet Island: "Bouvet Island"
                Brazil: "Brazil"
                British Indian Ocean Territory: "British Indian Ocean Territory"
                Brunei Darussalam: "Brunei Darussalam"
                Bulgaria: "Bulgaria"
                Burkina Faso: "Burkina Faso"
                Burundi: "Burundi"
                Cambodia: "Cambodia"
                Cameroon: "Cameroon"
                Canada: "Canada"
                Cape Verde: "Cape Verde"
                Cayman Islands: "Cayman Islands"
                Central African Republic: "Central African Republic"
                Chad: "Chad"
                Chile: "Chile"
                China: "China"
                Christmas Island: "Christmas Island"
                Cocos (keeling) Islands: "Cocos (keeling) Islands"
                Colombia: "Colombia"
                Comoros: "Comoros"
                Congo: "Congo"
                Congo, The Democratic Republic Of The: "Congo, The Democratic Republic Of The"
                Cook Islands: "Cook Islands"
                Costa Rica: "Costa Rica"
                Cote D'ivoire: "Cote D'ivoire"
                Croatia: "Croatia"
                Cuba: "Cuba"
                Cyprus: "Cyprus"
                Czech Republic: "Czech Republic"
                Denmark: "Denmark"
                Djibouti: "Djibouti"
                Dominica: "Dominica"
                Dominican Republic: "Dominican Republic"
                East Timor: "East Timor"
                Ecuador: "Ecuador"
                Egypt: "Egypt"
                El Salvador: "El Salvador"
                Equatorial Guinea: "Equatorial Guinea"
                Eritrea: "Eritrea"
                Estonia: "Estonia"
                Ethiopia: "Ethiopia"
                Falkland Islands (malvinas): "Falkland Islands (malvinas)"
                Faroe Islands: "Faroe Islands"
                Fiji: "Fiji"
                Finland: "Finland"
                France: "France"
                French Guiana: "French Guiana"
                French Polynesia: "French Polynesia"
                French Southern Territories: "French Southern Territories"
                Gabon: "Gabon"
                Gambia: "Gambia"
                Georgia: "Georgia"
                Germany: "Germany"
                Ghana: "Ghana"
                Gibraltar: "Gibraltar"
                Greece: "Greece"
                Greenland: "Greenland"
                Grenada: "Grenada"
                Guadeloupe: "Guadeloupe"
                Guam: "Guam"
                Guatemala: "Guatemala"
                Guinea: "Guinea"
                Guinea-bissau: "Guinea-bissau"
                Guyana: "Guyana"
                Haiti: "Haiti"
                Heard Island And Mcdonald Islands: "Heard Island And Mcdonald Islands"
                Holy See (vatican City State): "Holy See (vatican City State)"
                Honduras: "Honduras"
                Hong Kong: "Hong Kong"
                Hungary: "Hungary"
                Iceland: "Iceland"
                India: "India"
                Indonesia: "Indonesia"
                Iran, Islamic Republic Of: "Iran, Islamic Republic Of"
                Iraq: "Iraq"
                Ireland: "Ireland"
                Israel: "Israel"
                Italy: "Italy"
                Jamaica: "Jamaica"
                Japan: "Japan"
                Jordan: "Jordan"
                Kazakstan: "Kazakstan"
                Kenya: "Kenya"
                Kiribati: "Kiribati"
                Korea, Democratic People's Republic Of: "Korea, Democratic People's Republic Of"
                Korea, Republic Of: "Korea, Republic Of"
                Kosovo: "Kosovo"
                Kuwait: "Kuwait"
                Kyrgyzstan: "Kyrgyzstan"
                Lao People's Democratic Republic: "Lao People's Democratic Republic"
                Latvia: "Latvia"
                Lebanon: "Lebanon"
                Lesotho: "Lesotho"
                Liberia: "Liberia"
                Libyan Arab Jamahiriya: "Libyan Arab Jamahiriya"
                Liechtenstein: "Liechtenstein"
                Lithuania: "Lithuania"
                Luxembourg: "Luxembourg"
                Macau: "Macau"
                Macedonia, The Former Yugoslav Republic Of: "Macedonia, The Former Yugoslav Republic Of"
                Madagascar: "Madagascar"
                Malawi: "Malawi"
                Malaysia: "Malaysia"
                Maldives: "Maldives"
                Mali: "Mali"
                Malta: "Malta"
                Marshall Islands: "Marshall Islands"
                Martinique: "Martinique"
                Mauritania: "Mauritania"
                Mauritius: "Mauritius"
                Mayotte: "Mayotte"
                Mexico: "Mexico"
                Micronesia, Federated States Of: "Micronesia, Federated States Of"
                Moldova, Republic Of: "Moldova, Republic Of"
                Monaco: "Monaco"
                Mongolia: "Mongolia"
                Montserrat: "Montserrat"
                Montenegro: "Montenegro"
                Morocco: "Morocco"
                Mozambique: "Mozambique"
                Myanmar: "Myanmar"
                Namibia: "Namibia"
                Nauru: "Nauru"
                Nepal: "Nepal"
                Netherlands: "Netherlands"
                Netherlands Antilles: "Netherlands Antilles"
                New Caledonia: "New Caledonia"
                New Zealand: "New Zealand"
                Nicaragua: "Nicaragua"
                Niger: "Niger"
                Nigeria: "Nigeria"
                Niue: "Niue"
                Norfolk Island: "Norfolk Island"
                Northern Mariana Islands: "Northern Mariana Islands"
                Norway: "Norway"
                Oman: "Oman"
                Pakistan: "Pakistan"
                Palau: "Palau"
                Palestinian Territory, Occupied: "Palestinian Territory, Occupied"
                Panama: "Panama"
                Papua New Guinea: "Papua New Guinea"
                Paraguay: "Paraguay"
                Peru: "Peru"
                Philippines: "Philippines"
                Pitcairn: "Pitcairn"
                Poland: "Poland"
                Portugal: "Portugal"
                Puerto Rico: "Puerto Rico"
                Qatar: "Qatar"
                Reunion: "Reunion"
                Romania: "Romania"
                Russian Federation: "Russian Federation"
                Rwanda: "Rwanda"
                Saint Helena: "Saint Helena"
                Saint Kitts And Nevis: "Saint Kitts And Nevis"
                Saint Lucia: "Saint Lucia"
                Saint Pierre And Miquelon: "Saint Pierre And Miquelon"
                Saint Vincent And The Grenadines: "Saint Vincent And The Grenadines"
                Samoa: "Samoa"
                San Marino: "San Marino"
                Sao Tome And Principe: "Sao Tome And Principe"
                Saudi Arabia: "Saudi Arabia"
                Senegal: "Senegal"
                Serbia: "Serbia"
                Seychelles: "Seychelles"
                Sierra Leone: "Sierra Leone"
                Singapore: "Singapore"
                Slovakia: "Slovakia"
                Slovenia: "Slovenia"
                Solomon Islands: "Solomon Islands"
                Somalia: "Somalia"
                South Africa: "South Africa"
                South Georgia And The South Sandwich Islands: "South Georgia And The South Sandwich Islands"
                Spain: "Spain"
                Sri Lanka: "Sri Lanka"
                Sudan: "Sudan"
                Suriname: "Suriname"
                Svalbard And Jan Mayen: "Svalbard And Jan Mayen"
                Swaziland: "Swaziland"
                Sweden: "Sweden"
                Switzerland: "Switzerland"
                Syrian Arab Republic: "Syrian Arab Republic"
                Taiwan, Province Of China: "Taiwan, Province Of China"
                Tajikistan: "Tajikistan"
                Tanzania, United Republic Of: "Tanzania, United Republic Of"
                Thailand: "Thailand"
                Togo: "Togo"
                Tokelau: "Tokelau"
                Tonga: "Tonga"
                Trinidad And Tobago: "Trinidad And Tobago"
                Tunisia: "Tunisia"
                Turkey: "Turkey"
                Turkmenistan: "Turkmenistan"
                Turks And Caicos Islands: "Turks And Caicos Islands"
                Tuvalu: "Tuvalu"
                Uganda: "Uganda"
                Ukraine: "Ukraine"
                United Arab Emirates: "United Arab Emirates"
                United Kingdom: "United Kingdom"
                United States: "United States"
                United States Minor Outlying Islands: "United States Minor Outlying Islands"
                Uruguay: "Uruguay"
                Uzbekistan: "Uzbekistan"
                Vanuatu: "Vanuatu"
                Venezuela: "Venezuela"
                Viet Nam: "Viet Nam"
                Virgin Islands, British: "Virgin Islands, British"
                Virgin Islands, U.s.: "Virgin Islands, U.s."
                Wallis And Futuna: "Wallis And Futuna"
                Western Sahara: "Western Sahara"
                Yemen: "Yemen"
                Zambia: "Zambia"
                Zimbabwe: "Zimbabwe"

Use case TYPO3 EXT:Form yaml selectbox options!

@ab-muhammad-hamza
Copy link

AF
AL
DZ
AS
AD
AO
AI
AQ
AG
AR
AM
AW
AU
AT
AZ
BS
BH
BD
BB
BY
BE
BZ
BJ
BM
BT
BO
BA
BW
BV
BR
IO
BN
BG
BF
BI
KH
CM
CA
CV
KY
CF
TD
CL
CN
CX
CC
CO
KM
CG
CD
CK
CR
CI
HR
CU
CY
CZ
DK
DJ
DM
DO
TP
EC
EG
SV
GQ
ER
EE
ET
FK
FO
FJ
FI
FR
GF
PF
TF
GA
GM
GE
DE
GH
GI
GR
GL
GD
GP
GU
GT
GN
GW
GY
HT
HM
VA
HN
HK
HU
IS
IN
ID
IR
IQ
IE
IL
IT
JM
JP
JO
KZ
KE
KI
KP
KR
KV
KW
KG
LA
LV
LB
LS
LR
LY
LI
LT
LU
MO
MK
MG
MW
MY
MV
ML
MT
MH
MQ
MR
MU
YT
MX
FM
MD
MC
MN
MS
ME
MA
MZ
MM
NA
NR
NP
NL
AN
NC
NZ
NI
NE
NG
NU
NF
MP
NO
OM
PK
PW
PS
PA
PG
PY
PE
PH
PN
PL
PT
PR
QA
RE
RO
RU
RW
SH
KN
LC
PM
VC
WS
SM
ST
SA
SN
RS
SC
SL
SG
SK
SI
SB
SO
ZA
GS
ES
LK
SD
SR
SJ
SZ
SE
CH
SY
TW
TJ
TZ
TH
TG
TK
TO
TT
TN
TR
TM
TC
TV
UG
UA
AE
GB
US
UM
UY
UZ
VU
VE
VN
VG
VI
WF
EH
YE
ZM
ZW

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment