Skip to content

Instantly share code, notes, and snippets.

@iBet7o
Last active February 23, 2023 03:10
Show Gist options
  • Save iBet7o/6a6bde83cd9aa01f932b3410310ea3fd to your computer and use it in GitHub Desktop.
Save iBet7o/6a6bde83cd9aa01f932b3410310ea3fd to your computer and use it in GitHub Desktop.
ISO3166-1 Alpha-2 && Alpha-3 && Numeric | delimiter = "," && enclosure = '"'
name ISO3166-1-Alpha-2 ISO3166-1-Alpha-3
Afghanistan AF AFG
Åland Islands AX ALA
Albania AL ALB
Algeria DZ DZA
American Samoa AS ASM
Andorra AD AND
Angola AO AGO
Anguilla AI AIA
Antigua and Barbuda AG ATG
Argentina AR ARG
Armenia AM ARM
Aruba AW ABW
Australia AU AUS
Austria AT AUT
Azerbaijan AZ AZE
Bahamas BS BHS
Bahrain BH BHR
Bangladesh BD BGD
Barbados BB BRB
Belarus BY BLR
Belgium BE BEL
Belize BZ BLZ
Benin BJ BEN
Bermuda BM BMU
Bhutan BT BTN
Bolivia (Plurinational State of) BO BOL
Bonaire, Sint Eustatius and Saba BQ BES
Bosnia and Herzegovina BA BIH
Botswana BW BWA
Brazil BR BRA
British Virgin Islands VG VGB
Brunei Darussalam BN BRN
Bulgaria BG BGR
Burkina Faso BF BFA
Burundi BI BDI
Cabo Verde CV CPV
Cambodia KH KHM
Cameroon CM CMR
Canada CA CAN
Cayman Islands KY CYM
Central African Republic CF CAF
Chad TD TCD
Chile CL CHL
China CN CHN
China, Hong Kong Special Administrative Region HK HKG
China, Macao Special Administrative Region MO MAC
Colombia CO COL
Comoros KM COM
Congo CG COG
Cook Islands CK COK
Costa Rica CR CRI
Côte d'Ivoire CI CIV
Croatia HR HRV
Cuba CU CUB
Curaçao CW CUW
Cyprus CY CYP
Czechia CZ CZE
Democratic People's Republic of Korea KP PRK
Democratic Republic of the Congo CD COD
Denmark DK DNK
Djibouti DJ DJI
Dominica DM DMA
Dominican Republic DO DOM
Ecuador EC ECU
Egypt EG EGY
El Salvador SV SLV
Equatorial Guinea GQ GNQ
Eritrea ER ERI
Estonia EE EST
Ethiopia ET ETH
Faeroe Islands FO FRO
Falkland Islands (Malvinas) FK FLK
Fiji FJ FJI
Finland FI FIN
France FR FRA
French Guiana GF GUF
French Polynesia PF PYF
Gabon GA GAB
Gambia GM GMB
Georgia GE GEO
Germany DE DEU
Ghana GH GHA
Gibraltar GI GIB
Greece GR GRC
Greenland GL GRL
Grenada GD GRD
Guadeloupe GP GLP
Guam GU GUM
Guatemala GT GTM
Guernsey GG GGY
Guinea GN GIN
Guinea-Bissau GW GNB
Guyana GY GUY
Haiti HT HTI
Holy See VA VAT
Honduras HN HND
Hungary HU HUN
Iceland IS ISL
India IN IND
Indonesia ID IDN
Iran (Islamic Republic of) IR IRN
Iraq IQ IRQ
Ireland IE IRL
Isle of Man IM IMN
Israel IL ISR
Italy IT ITA
Jamaica JM JAM
Japan JP JPN
Jersey JE JEY
Jordan JO JOR
Kazakhstan KZ KAZ
Kenya KE KEN
Kiribati KI KIR
Kuwait KW KWT
Kyrgyzstan KG KGZ
Lao People's Democratic Republic LA LAO
Latvia LV LVA
Lebanon LB LBN
Lesotho LS LSO
Liberia LR LBR
Libya LY LBY
Liechtenstein LI LIE
Lithuania LT LTU
Luxembourg LU LUX
Madagascar MG MDG
Malawi MW MWI
Malaysia MY MYS
Maldives MV MDV
Mali ML MLI
Malta MT MLT
Marshall Islands MH MHL
Martinique MQ MTQ
Mauritania MR MRT
Mauritius MU MUS
Mayotte YT MYT
Mexico MX MEX
Micronesia (Federated States of) FM FSM
Monaco MC MCO
Mongolia MN MNG
Montenegro ME MNE
Montserrat MS MSR
Morocco MA MAR
Mozambique MZ MOZ
Myanmar MM MMR
Namibia NA NAM
Nauru NR NRU
Nepal NP NPL
Netherlands NL NLD
New Caledonia NC NCL
New Zealand NZ NZL
Nicaragua NI NIC
Niger NE NER
Nigeria NG NGA
Niue NU NIU
Norfolk Island NF NFK
Northern Mariana Islands MP MNP
Norway NO NOR
Oman OM OMN
Pakistan PK PAK
Palau PW PLW
Panama PA PAN
Papua New Guinea PG PNG
Paraguay PY PRY
Peru PE PER
Philippines PH PHL
Pitcairn PN PCN
Poland PL POL
Portugal PT PRT
Puerto Rico PR PRI
Qatar QA QAT
Republic of Korea KR KOR
Republic of Moldova MD MDA
Réunion RE REU
Romania RO ROU
Russian Federation RU RUS
Rwanda RW RWA
Saint Barthélemy BL BLM
Saint Helena SH SHN
Saint Kitts and Nevis KN KNA
Saint Lucia LC LCA
Saint Martin (French part) MF MAF
Saint Pierre and Miquelon PM SPM
Saint Vincent and the Grenadines VC VCT
Samoa WS WSM
San Marino SM SMR
Sao Tome and Principe ST STP
Saudi Arabia SA SAU
Senegal SN SEN
Serbia RS SRB
Seychelles SC SYC
Sierra Leone SL SLE
Singapore SG SGP
Sint Maarten (Dutch part) SX SXM
Slovakia SK SVK
Slovenia SI SVN
Solomon Islands SB SLB
Somalia SO SOM
South Africa ZA ZAF
South Sudan SS SSD
Spain ES ESP
Sri Lanka LK LKA
State of Palestine PS PSE
Sudan SD SDN
Suriname SR SUR
Svalbard and Jan Mayen Islands SJ SJM
Swaziland SZ SWZ
Sweden SE SWE
Switzerland CH CHE
Syrian Arab Republic SY SYR
Tajikistan TJ TJK
Thailand TH THA
The former Yugoslav Republic of Macedonia MK MKD
Timor-Leste TL TLS
Togo TG TGO
Tokelau TK TKL
Tonga TO TON
Trinidad and Tobago TT TTO
Tunisia TN TUN
Turkey TR TUR
Turkmenistan TM TKM
Turks and Caicos Islands TC TCA
Tuvalu TV TUV
Uganda UG UGA
Ukraine UA UKR
United Arab Emirates AE ARE
United Kingdom of Great Britain and Northern Irela GB GBR
United Republic of Tanzania TZ TZA
United States of America US USA
United States Virgin Islands VI VIR
Uruguay UY URY
Uzbekistan UZ UZB
Vanuatu VU VUT
Venezuela (Bolivarian Republic of) VE VEN
Viet Nam VN VNM
Wallis and Futuna Islands WF WLF
Western Sahara EH ESH
Yemen YE YEM
Zambia ZM ZMB
Zimbabwe ZW ZWE
<?php
namespace AppBundle\DataFixtures\ORM;
use AppBundle\Entity\Country;
use Doctrine\Common\DataFixtures\FixtureInterface;
use Doctrine\Common\Persistence\ObjectManager;
class LoadCountryData implements FixtureInterface
{
public function load(ObjectManager $manager)
{
$resource = 'https://gist.github.com/iBet7o/6a6bde83cd9aa01f932b3410310ea3fd/raw/ISO3166-1.csv';
$data = file($resource);
$countries = array_map('str_getcsv', $data);
$headers = array_shift($countries);
array_walk($countries, function ($country, $key) use ($headers, $manager) {
$country = array_combine($headers, $country);
$Country = new Country();
$Country
->setName($country['name'])
->setAlpha2($country['ISO3166-1-Alpha-2'])
->setAlpha3($country['ISO3166-1-Alpha-3'])
;
$manager->persist($Country);
});
$manager->flush();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment