Countries and Cities database download and API

World countries database download

We are selling access to our world countries database, giving you the ability to download it for a period of one year. Our database is constantly updated through dedicated software, developed for each source and the accuracy is manually checked. We use aviation authority organizations for our source of data as well as other official original data sources. Based on the list of ISO recognized countries. Our database is hosted on our servers in Amsterdam and has an uptime of 99.98%. Of each country, we collect all the data which you could possibly need in the aviation industry.

What is in our database

How we classify it

Based on the ISO list and supported by the information from the UN databank. Bringing our list to 239 entries with a focus on the aviation industry.

Our country database is based on the ISO and their ISO 3166 standard. These are the codes that represent the names of countries and their subdivisions. The database includes the alpha-2 code, the alpha-3 code and the numeric-3 digit code which coincides with the Statistic Division of the UN.  It is possible to purchase the basic list from the ISO website and obtain a stamp but this data is really only limited to these aforementioned codes.  Although they claim to be based on the United Nations’s list of Standard Country or Area Codes they actually include a few more.

The country database is basically the classification of the Standard Country or Area Codes which are used by the UN for Statistical Use and a few more that have ISO codes.

A better choice of word for this database would have been the Area database or database of world areas but to make it easy we promote our service as wold country database. Every country or area which has an ISO alpha-3 code is included in our database. The initial source of ISO codes with the full definition of their classification can be found on the UN website.

The entire list of our country database which you can download has 239 entries currently. The aim is directed towards the aviation industry and it contains every entry that would be needed for any purpose of our customers.

What information do we have per country

Data per country

The data we have per country is based on what is used in the aviation and travel industry. We want to avoid flooding our clients with information that is not used. Based on our research and the feedback from our current clients you can find our list below.

The information of our country database can be classified in a certain way. We have the foundation, based on authority websites. This is the Country name, ISO Alpha-2, ISO Alpha-3, Numeric-3 ISO. Upon this, we have built the information that is interesting for the aviation industry such as the official translations of the countries and the population. We add to this the geographical information of the capital of each country and the continent it is based in. Another great feature is the currency name as well as the currency code in our database. This falls under the currency category. Then to complete it we’ve gathered the FIPS code of each country in our database as well as the prefix code of the phone of each country.

Headers  Description
CountryId
NameCountry
CodeIso2Country
CodeIso3Country
NumericIso
NameTranslations
Population
Capital
Continent
NameCurrency
CodeCurrency
CodeFips
PhonePrefix
Our ID code of Countries database API
Name of Country
2 Digit ISO code of Country
3 Digit ISO code of Country
Numeric ISO code of Country
Translations of name of Country
Population of Country
Capital city of Country
2 Digit ISO code of Continent of Country
Name of Currency
Code of Currency
FIPS code of a Country
Phone prefix code of Country

You can collect this data through an Excel/CSV download. Parts of this data is also used in our API services such as the nearby API, the Autocomplete API and the airline and airport routes API.

Example of our database

*image of our database in Excel

You can find the full information about how to use our database or API strings on our developers page here.

Why we choose this information

We believe that a certain factor of focus within big data is important. It is possible to gather all the data in the world, aggregate it into a massive database but then without focus, you give up on the usability of the data. Data that is not used loses it’s value completely. This is why we’ve decided to segment our database in this specific way, to best serve the aviation industry. We provide information about countries that are used. If you feel that more information should be added and you have good arguments, please contact us.

how do we guarantee the accuracy

The accuracy of our database is guaranteed because of the sources we use. We are very selective in our sources and have created partnerships with aviation authorities all across the industry. To guarantee the accuracy, we always confirm the data from multiple original sources.

Method of data collection

Our method makes sure that the data is checked for accuracy automatically as well as manually which allows us to provide up to date and correct information.

We start by building the foundation of our data from authority sources. This includes the different ISO codes, the officially recognized names and translations of countries, timezones, and anything else we gather.

On this foundation, we can expand our database with useful information focussed on the aviation industry. The data comes from authority sources as well as official non-authority sources. We make sure that all sources are original and provide proven and valid information which is used in the aviation industry. They are internationally recognized and used by many industries.

We’ve developed software that ‘crawls’ these original sources for data and aggregates it into our database. Here we do different methods of comparing the data from these original sources.  If it’s proven that the sources match with each other, we integrate it into our database after a manual check. In case of exceptions or when the data seems off, we contact our partners to clarify and rectify the data.

This method assures that our data is constantly updated and accurate.

About our sources

Authority and original non-authority sources at the core of our data.

Our database is compiled from hundreds of sources. We have classified these in two types of sources; Official authority sources, usually in the aviation industry and unofficial sources and data aggregators such as ourselves.

Official authority sources are, in the case of our country database, the UN dataunstatISO, and world databank. Aside from these, we use various other authority sources for our country database.

Non-authority sources are what make our data valuable to the aviation industry, it brings detail to the basic lists. This is where we are unique. We cannot disclose our sources but we can highlight our methods as we’ve written in the previous chapter.

The conclusion is that all our sources are checked for validity and we have good direct relations with all of them.

TBA *infographics on how we gather the data, check it, host it and share it*

 

The different uses of the information for our clients

Our clients are very creative in the reasons for which to use our database. Certainly, you also know what you are going to use it for. In case you need some ideas though, we can explain how we use the database. The data from the country database is used by us as part of the foundation of our APIs in the travel industry.

It can be used as a standalone database that you may need for your software or in case you are one of our clients who needs it for the travel industry, perhaps our API subscriptions are more interesting for you. Here are a few examples of our APIs that make use of this database.

*infographic on how to combine our database or just a funny picture of two merging databases*

Example of our APIs

The Nearby API. Provides cities and airports that are nearby a certain latitude and longitude input.
*image nearby API.*

The Autocomplete API. This provides a drop-down to clients who are searching for something in a drop-down menu by giving automatic suggestions.
*image Autocomplete API*

Routes API. This gives up to date information on all airline and airport routes that are active with various detailed information strings.
*image airline and airport routes API*

How is our database hosted

Location of our host

Our database is centrally hosted at our hosting partner in Amsterdam. We have chosen this location for two reasons, it’s near our headquarter and it’s the location of the iconic airport hub Schiphol. Which is part of the reason as to why we originally started this business.

Our up-time

We offer an SLA server up-time of 99.98%. This is more than the 99.79% industry standard. This means that our downtime will be no more than 1 minute per week. More than is achievable by almost any company who decides to host their own data. Making our API even more valuable.

This is why we’ve chosen Sitegound as our partner for data hosting. If you wish more information about our host, you can consult their website directly.

*picture/logo of our database or that of siteground*

Our Clients

Most of our clients are in our focus group in the aviation industry and we also welcome the occasional client in other industries that want to use our data.

When thinking about our clients, we think about developers who want to build great platforms for consumers.

Some examples of platforms you can find below.

Travel
Price compare platforms
Booking agencies
Destination marketers
Corporate booking platforms
Tour operators

Transport
Cargo transporters

Insurance
Late and delay statistics

Aviation
Civil aviation authorities
Airports
Airliners

Tracking
Air navigation service providers
Airspace management

Metadata
Intelligence and statistics
Trend mapping

how they have used it

Our database is being downloaded thousands of times per year and our API is used millions of times per day to help keep data of our clients up to date and serve their consumers.

Mostly the databases are used as a one time download to try build systems or for companies to expand their own database in the industry. However, it is important not to forget that data is fluid and constantly changes. That’s why eventually they subscribe to our API services.

Although you have the ability to download the database for the period of one year, it is easier to set up an integration with our API and call for these updates automatically.

*logos of a few clients*

Our free/premium setup

how do we handle it for country database

*picture of our premium setup*