Welcome to the Open Countries Database, an open-source project under the open-aviation-data initiative. This repository aims to provide a comprehensive and up-to-date global database of countries and territories in an easy-to-use format.
This project is licensed under the Open Database License (ODbL), see
LICENSE. In short, any modification to this data source must be published.
This repository collects and maintains country and territory data from official sources and community contributions. The data is structured in CSV format, making it easy to use for developers, researchers, and aviation-related applications.
The primary dataset is stored in a CSV file: data/countries.csv. Each row represents a country or territory with the
following fields:
| Column Name | Description |
|---|---|
name |
Official country name |
iso2 |
ISO 3166-1 alpha-2 country code |
iso3 |
ISO 3166-1 alpha-3 country code |
numeric_code |
ISO 3166-1 numeric country code |
iso_3166_2 |
ISO 3166-2 subdivision code |
region |
Region name UN region classification |
region_code |
Region code UN region classification |
sub_region |
Sub region name UN sub-region classification |
sub_region_code |
Numeric sub-region code UN sub-region classification |
intermediate_region |
UN intermediate region classification |
intermediate_region_code |
Numeric intermediate region code |
The dataset categorizes countries based on UN and ISO 3166 standards, including:
- Regions (e.g., Europe, Asia, Africa)
- Sub-regions (e.g., Northern Europe, Western Asia)
- Intermediate regions (for additional classification where applicable)
This dataset can be used for various applications, including:
- Geographic information systems (GIS) and mapping projects
- Aviation and transportation analysis
- Regulatory and compliance use cases
- International research and data analysis
- Country and territory-based applications
We welcome contributions from the community! See CONTRIBUTING.md for details on how to add new
countries, fix errors, or improve the dataset.
Follow our updates and join the discussion on:
- GitHub Issues & Discussions