[CountryCodeISO] ([Code], [Name]) VALUES (N’COK’, N’Cook Islands’) GO INSERT [dbo]. The country codes from all three parts of ISO 3166 are available in .xml, .csv and .xls formats here: Country Codes Collection Abstract ISO 3166-2:2013 establishes a universally applicable code for the representation of the names of principal administrative divisions of countries and territories included in ISO 3166 … [CountryCodeISO] ([Code], [Name]) VALUES (N’AUT’, N’Austria’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’CAF’, N’Central African Republic’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’SVN’, N’Slovenia’) GO INSERT [dbo]. See the ISO 3166-3 standard for former country codes. Current ISO 3166 country codes. [CountryCodeISO] ([Code], [Name]) VALUES (N’LSO’, N’Lesotho’) GO INSERT [dbo]. Staðallinn var fyrst gefinn út árið 1974 af Alþjóðlegu staðlastofnuninni . [CountryCodeISO] ([Code], [Name]) VALUES (N’SLV’, N’El Salvador’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’ABW’, N’Aruba’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’BLM’, N’Saint Barthélemy’) GO INSERT [dbo]. 1974-ben jelentette meg az International Organization for Standardization.Minden országhoz háromfajta kódot rendel. Also what is your lat and long source, so i can get South Sudan coordinates for consistency issues. [CountryCodeISO] ([Code], [Name]) VALUES (N’VCT’, N’Saint Vincent and the Grenadines’) GO INSERT [dbo]. ISO 3166-1, is part of the ISO 3166 standard.It gives a code for the names of countries and dependent territories, and is published by the International Organization for Standardization (ISO). Clone with Git or checkout with SVN using the repository’s web address. [CountryCodeISO] ([Code], [Name]) VALUES (N’JAM’, N’Jamaica’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’KAZ’, N’Kazakhstan’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’MKD’, N’Macedonia, the former Yugoslav Republic of’) GO INSERT [dbo]. ISO 3166-1:2013 Codes for the representation of names of countries and their subdivisions — Part 1: Country codes. [CountryCodeISO] ([Code], [Name]) VALUES (N’NIU’, N’Niue’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’STP’, N’Sao Tome and Principe’) GO INSERT [dbo]. Data are fetched from multiple sources: Official formal and short names (in English, French, Spanish, Arabic, Chinese, and Russian) are fromUnited Nations Protocol and Liaison Service Customary English short names are fromUnicode Common Locale Data Repository (CLDR) Project. Whole worlds Country Code in three alphabets format as per ISO 3166-1 is given on Wikipedia. [CountryCodeISO] ([Code], [Name]) VALUES (N’IRN’, N’Iran, Islamic Republic of’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’USA’, N’United States’) GO INSERT [dbo]. ISO 3166-2:FI on ISO-standardointijärjestön standardi, joka määrittää geokoodit Suomelle. Is your list dedicated to the public domain? Koodit. [CountryCodeISO] ([Code], [Name]) VALUES (N’IDN’, N’Indonesia’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’NAM’, N’Namibia’) GO INSERT [dbo]. Constantly updated lists of world countries, territories and areas of geographical interest, with associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166-1 standard, published and maintained by the International Organization for Standardization, available in CSV, JSON, PHP and SQL formats, in multiple languages and with national flags included. [CountryCodeISO] ([Code], [Name]) VALUES (N’BDI’, N’Burundi’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’ARE’, N’United Arab Emirates’) GO INSERT [dbo]. /****** Object: Table [dbo]. ISO 3166 is a standard published by the International Organization for Standardization (ISO) that defines codes for the names of countries, dependent territories, special areas of geographical interest, and their principal subdivisions (e.g., provinces or states).The official name of the standard is Codes for the representation of names of countries and their subdivisions [CountryCodeISO] ([Code], [Name]) VALUES (N’DZA’, N’Algeria’) GO INSERT [dbo]. English short name lower case Alpha-2 code Alpha-3 code Numeric code ISO 3166-2; Afghanistan: AF: AFG: 004: ISO 3166-2:AF: Åland Islands: AX: ALA: 248: ISO 3166-2:AX [CountryCodeISO] ([Code], [Name]) VALUES (N’NZL’, N’New Zealand’) GO INSERT [dbo]. [CountryCodeISO] Script Date: 13-May-14 3:49:07 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’GHA’, N’Ghana’) GO INSERT [dbo]. Instantly share code, notes, and snippets. Constantly updated lists of world countries, territories and areas of geographical interest, with associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166-1 standard, published and maintained by the International Organization for Standardization, available in CSV, JSON, PHP and SQL formats, in multiple languages and with national flags included. @tadast I do not know about forking. [CountryCodeISO] ([Code], [Name]) VALUES (N’SHN’, N’Saint Helena, Ascension and Tristan da Cunha’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’DMA’, N’Dominica’) GO INSERT [dbo]. Az ISO 3166-1 az ISO 3166 szabvány első részeként az egyes országokat (vagy régiókat) reprezentáló kódokat tartalmaz. De gegevens werden tot op 26 november 2018 geüpdatet op het ISO Online Browsing Platform (OBP).Hier worden 1 metropolitaans bestuur - … [CountryCodeISO] ([Code], [Name]) VALUES (N’KOR’, N’Korea, Republic of’) GO INSERT [dbo]. De ISO-norm ISO 3166 geeft codes voor alle landen, grondgebieden of belangrijke geografische gebieden (bijvoorbeeld Antarctica), kortweg "landen" genoemd.. De norm bestaat uit drie delen: ISO 3166-1 geeft driecijferige (numeric-3), drieletterige (alpha-3) en tweeletterige (alpha-2) codes voor alle landen, grondgebieden of belangrijke geografische gebieden (bijvoorbeeld AQ). [CountryCodeISO] ([Code], [Name]) VALUES (N’ZMB’, N’Zambia’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’LBY’, N’Libya’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’WLF’, N’Wallis and Futuna’) GO INSERT [dbo]. ISO 3166 official short names (in English, French, Spanish, Arabic, Chinese, and Russian) are from United Nations Department of Ecoonomic and Social Affairs Statistics Division. [CountryCodeISO] ([Code], [Name]) VALUES (N’CUB’, N’Cuba’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’BRA’, N’Brazil’) GO INSERT [dbo]. iso3-alpha3: SSD. [CountryCodeISO] ([Code], [Name]) VALUES (N’TGO’, N’Togo’) GO INSERT [dbo]. This is very helpful, thank you very much! [CountryCodeISO] ([Code], [Name]) VALUES (N’CHL’, N’Chile’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’MAR’, N’Morocco’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’CPV’, N’Cape Verde’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’IMN’, N’Isle of Man’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’RWA’, N’Rwanda’) GO INSERT [dbo]. The Americas Open Geocode (AOG). ISO 3166-2 Waa fure magacyada dalalka iyo meelaha oo ay soo gudbiyeen Ururka caalamiga ah ee halbeegyada.Marki ugu horraysay waxaa la soo gudbiyay sannaddii 1998. [CountryCodeISO] ([Code], [Name]) VALUES (N’FIN’, N’Finland’) GO INSERT [dbo]. [CountryCodeISO]( [Code] [varchar](50) NULL, [Name] [varchar](50) NULL ) ON [PRIMARY], GO SET ANSI_PADDING OFF GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’KHM’, N’Cambodia’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’ISR’, N’Israel’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’AND’, N’Andorra’) GO INSERT [dbo]. Country codes. [CountryCodeISO] ([Code], [Name]) VALUES (N’KEN’, N’Kenya’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’ESH’, N’Western Sahara’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’SXM’, N’Sint Maarten (Dutch part)’) GO INSERT [dbo]. It allows you to download the most recent, official lists of country codes and/or subdivisions not to mention formerly used … - haliaeetus/iso-3166 @msgoussi sorry, I don't remember where I got this data from, this whole gist was supposed to be helpful only for future self, but it looks people come here from google and use it. [CountryCodeISO] ([Code], [Name]) VALUES (N’COM’, N’Comoros’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’KWT’, N’Kuwait’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’DNK’, N’Denmark’) GO INSERT [dbo]. Also known as +2 country code and iso 3166. [CountryCodeISO] ([Code], [Name]) VALUES (N’GEO’, N’Georgia’) GO INSERT [dbo]. ISO 3166-1 ul ISO 3166 standardnıñ öleşe bulıp, illärneñ wä bäyle cirlärneñ kodlarnı berketä. [CountryCodeISO] ([Code], [Name]) VALUES (N’SPM’, N’Saint Pierre and Miquelon’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’CRI’, N’Costa Rica’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’REU’, N’Réunion’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’BHS’, N’Bahamas’) GO INSERT [dbo]. La dua parto estas du literoj. [CountryCodeISO] ([Code], [Name]) VALUES (N’TUN’, N’Tunisia’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’PNG’, N’Papua New Guinea’) GO INSERT [dbo]. ISO 3166-2:FI on ISO-standardointijärjestön standardi, joka määrittää geokoodit Suomelle. [CountryCodeISO] ([Code], [Name]) VALUES (N’ALB’, N’Albania’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’KGZ’, N’Kyrgyzstan’) GO INSERT [dbo]. Should it be merged? [CountryCodeISO] ([Code], [Name]) VALUES (N’BFA’, N’Burkina Faso’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’NER’, N’Niger’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’OMN’, N’Oman’) GO INSERT [dbo]. @tadast nice work, thanks! Free Download a List of Countries in Format ISO 3166-1 alpha-3 and SQL and CSV file [CountryCodeISO] ([Code], [Name]) VALUES (N’SEN’, N’Senegal’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’TON’, N’Tonga’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’EGY’, N’Egypt’) GO INSERT [dbo]. ISO 3166 Country Codes Below are ISO codes for countries in GeoIP legacy databases, with the addition of MaxMind-specific codes for Europe , Asia Pacific Region , Anonymous Proxy and Satellite Provider . Country list: ISO 3166-1-alpha-2 English country names and code elements as two letter country codes. [CountryCodeISO] ([Code], [Name]) VALUES (N’GNB’, N’Guinea-Bissau’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’TUV’, N’Tuvalu’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’TKL’, N’Tokelau’) GO INSERT [dbo]. [CountryCodeISO] ([Code], [Name]) VALUES (N’ATF’, N’French Southern Territories’) GO INSERT [dbo]. kindly follow our blog here. Whether you're in banking or a business using country codes, look no further than this collection to keep you up-to-date. ISO 3166-2 lagana soo qaatay Liiska dalalka hadba halbeeg caalamiga ah ee ISO 3166-1.. Waxa uu ka koobanyahay dalalka oo kaliya. ISO 3166-2:JO: Zambiya: ZM: ZMB: 894: ISO 3166-2:ZM: Zimbabwe: ZW: ZWE: 716: ISO 3166-2:ZW: AN Antiye za Nederilande; KO Kosovo; TB Tibeti; ZR Zayire; Last edited on 15 April 2013, at 01:32.