worldCountries
Ideal for basic country selection in multiple languages, this is a subset of our most complete database, worldCities Pro.
worldCountries currently contains the continents, regions and subregions in 12 languages and most of the 263 recognized countries and territories in 40 to 100 languages.
worldCountries files available for purchase
| Name | Delivery | License | Last update | Price (without updates) |
Price (including 1-year updates) |
|---|---|---|---|---|---|
| worldCountries Standard - World | download | single | April 29, 2010 | € 49.99 EUR | € 79.98 EUR |
| All of our databases include free unlimited e-mail support. | |||||
The default license includes the right to use the data on one (1) server (website, intranet...), and does not authorize redistribution or integration into products to be distributed (CMS, software application,...)
Please contact us if you need to use the data on multiple projects (discounts available), want redistributing rights or simply have questions about our License Agreement and the authorized uses.
worldCountries database features
| Feature | Standard | ||
|---|---|---|---|
| Code identifying the type of feature (See feature type reference for more details.) |  | ||
| Names in conventionnal language (english) (Included with all records.) | | ||
| Names in foreign languages (Continents and regions names in 12 languages, and most country names in 40 to 100 languages) | | ||
| Language code associated to the feature name. (Included with all records. See language reference for more details.) | | ||
| FIPS country codes | | ||
| ISO 3166-1 (alpha 2) country codes | | ||
| ISO 3166-1 (alpha 3) country codes | | ||
| ISO 3166-1 numeric country codes | | ||
| Continents, regions and subregions (Continents, regions and subregions in 3 languages.) | | ||
| Internet top-level domains | | ||
| ISO 4217 currency codes (See currency reference for more details.) | | ||
| Phone country codes | | ||
| Character set of the name | | ||
| Free unlimited e-mail support | |
|
|
worldCountries database structure
Having comprehensive and accurate data is good, but if it's not well structured, it might not be very useful. That's why not only worldCountries, but all of our databases are structured in a very efficient way, which is a compromise between usability and database normalization (which do not always meet the same requirements). This results in very easy to use data, and the possibility to retrieve all the details for specific records with very simple and fast queries.
For easier maintenance, we also assigned a unique identification number to each feature. It is thus possible to store that number to refer to a particular feature, no matter the language used to display the name.
Click here to view the full structure of each table and detailed descriptions of their fields.
worldCountries records statistics
Click here to view the number of records for each table, as well as the breakdowns by country.
Requirements and files information
The worldCountries data is available in text files (tab delimited) encoded in Unicode (UTF-8). It can therefore be imported in virtually any database, including MySQL, Microsoft SQL Server, PostgreSQL, Oracle, etc... The only requirements are that you have enough free space on you hard drive to store the files and that you can import those files into your database.
For faster download, files are compressed in ZIP format.
- worldCountries Standard files:
- worldCountries Standard - World - languages.zip (1.94 KB, compressed)
- worldCountries Standard - World - countries.zip (6.27 KB, compressed)
- worldCountries Standard - World - regions.zip (2.82 KB, compressed)
- worldCountries Standard - World - countries_variants.zip (162.73 KB, compressed)
